Skip to content

Fatal NTSB investigations, 1997, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

Fatal NTSB investigations, 1997, Outside the U.S. per year, 1962–2026: 3,271 cases
1962	1
1964	20
1965	18
1966	15
1967	16
1968	16
1969	14
1970	14
1971	11
1972	17
1973	16
1974	11
1975	11
1976	1
1977	6
1978	11
1979	2
1981	1
1982	1
1983	1
1984	3
1985	3
1986	2
1987	9
1988	11
1989	8
1990	8
1991	9
1992	11
1993	11
1994	10
1995	24
1996	37
1997	37
1998	43
1999	53
2000	77
2001	66
2002	59
2003	71
2004	75
2005	97
2006	89
2007	87
2008	90
2009	90
2010	98
2011	120
2012	119
2013	124
2014	107
2015	130
2016	131
2017	133
2018	137
2019	140
2020	91
2021	107
2022	125
2023	98
2024	110
2025	109
2026	109

Latest cases

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1997 AND c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 1997
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 1997
  AND c."eventCountry" <> 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA98WA049Accident · 10 fatalForeign investigationBritten-Norman Islander · Rio Sidra, PanamaDec 31, 1997 · HP986 · Destroyed NTSB DCA98RA013Accident · 97 fatalForeign investigationBoeing 737-300 · IndonesiaDec 19, 1997 · 9VTRF NTSB DCA98RA011Accident · 10 fatalForeign investigationFairchild SA-226-TC · La Veriente, BoliviaDec 13, 1997 · CP1635 NTSB FTW98RA076Accident · 10 fatalForeign investigationFairchild SA-2226-TC · La Vertiente, BoliviaDec 12, 1997 · CP-1635 NTSB DCA98RA009Accident · 9 fatalForeign investigationBell UH-1H · La Palma, PanamaNov 25, 1997 · N124 NTSB DCA98RA008Accident · 2 fatalForeign investigationBoeing 234 · Comox Lake, CanadaOct 30, 1997 · CFHFH NTSB DCA98RA003Accident · 75 fatalForeign investigationMcDonnell Douglas DC-9-32 · Nuevo Berlin, UruguayOct 10, 1997 · LVWEG NTSB DCA98WA004Accident · 8 fatalForeign investigationBeech BE-200 · Banjul, GambiaOct 9, 1997 · ECERQ · Destroyed NTSB DCA98WA001Accident · 7 fatalForeign investigationZhuhai Helicopter S-76A · Wenzho, ChinaOct 3, 1997 · B7301 · Destroyed NTSB NYC97WA191Accident · 2 fatalForeign investigationBellanca 17-30A · BelgiumSep 24, 1997 · N28158 · Destroyed NTSB ATL97WA145Accident · 1 fatalForeign investigationCessna A188B · Trinidad, WNSep 5, 1997 · 9YTIQ · Destroyed NTSB FTW97RA323Accident · 3 fatalForeign investigationBell 206L-1 · Arica, PeruAug 21, 1997 · N2246Q NTSB FTW97RA314Accident · 8 fatalForeign investigationBell 412HP · Cuernavaca, MexicoAug 15, 1997 · XCPFI NTSB MIA97WA226Accident · 1 fatalForeign investigationBoeing 757-200 · Lima, PeruAug 3, 1997 · N12114 · No damage NTSB MIA97WA220Accident · 1 fatalForeign investigationCessna 172K · Normans Cay, BahamasJul 28, 1997 · N84653 · Destroyed NTSB SEA97WA180Accident · 4 fatalForeign investigationPiper PA-28 · Nelson, CanadaJul 27, 1997 · N2394Q · Destroyed NTSB NYC97WA115Accident · 3 fatalForeign investigationCessna 185F · Bagotville, CanadaJun 14, 1997 · N4758E · Destroyed NTSB NYC97WA104Accident · 2 fatalForeign investigationCessna TU-206G · Carroll Lake, CanadaJun 1, 1997 · N6428Z · Substantial damage NTSB FTW97RA213Accident · 2 fatalForeign investigationBell UH-1H · Roque, PeruMay 30, 1997 · PNP30 NTSB FTW97RA194Accident · 4 fatalForeign investigationRockwell 1121B · La Carbonera, MexicoMay 20, 1997 · N1121F NTSB MIA97WA158Accident · 1 fatalForeign investigationAyres S2R · Brenon, PanamaMay 11, 1997 · N3090K · Destroyed NTSB DCA97WA045Accident · 35 fatalForeign investigationBoeing 737-300 · Shenzhen, ChinaMay 8, 1997 · Destroyed NTSB MIA97WA181Accident · 1 fatalForeign investigationPiper PA-23-250 · Bimini, BahamasMay 4, 1997 · N570VR · Substantial damage NTSB ATL97WA068Accident · 6 fatalForeign investigationBeech 58 · St. Vincent, SpainMay 1, 1997 · 9YTHF · Substantial damage NTSB DCA97WA044Accident · 2 fatalForeign investigationCessna 208 · CambodiaApr 30, 1997 · N9825F · Destroyed NTSB MIA97WA135Accident · 4 fatalForeign investigationBeech A-36 · Pitts Town, BahamasApr 12, 1997 · N11RV · Destroyed NTSB DCA97WA039Accident · 10 fatalForeign investigationCessna 414 · Zurich, SwitzerlandApr 10, 1997 · HBLPN · Destroyed NTSB DCA97WA035Accident · 1 fatalForeign investigationBell B212 · Nuevo Leon, MexicoMar 30, 1997 · XCJBO · Destroyed NTSB FTW97RA151Accident · 2 fatalForeign investigationBell UH-1H · Mariquita, ColombiaMar 26, 1997 · PN160 NTSB FTW97WA133Accident · 3 fatalForeign investigationPiper PA-28-181 · Tejupilco, MexicoMar 16, 1997 · N5968F · Destroyed NTSB FTW97RA126Accident · 1 fatalForeign investigationBell 205A1 · Lofssjon, SwedenMar 15, 1997 · HSX NTSB MIA97WA092Accident · 6 fatalForeign investigationCessna 402A · Caracas, VenezuelaMar 3, 1997 · YV784 · Destroyed NTSB MIA97WA085Accident · 5 fatalForeign investigationIsrael Aircraft Industries 1124A · Guatemala City, GuatemalaFeb 19, 1997 · YV160 · Destroyed NTSB MIA97WA100Accident · 1 fatalForeign investigationCessna T210 · Challao, ArgentinaFeb 11, 1997 · N470E · Destroyed NTSB FTW97RA101Accident · 1 fatalForeign investigationBeech 23 · Santa Catarina, MexicoFeb 5, 1997 · N8723M NTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…Jan 12, 1997 · N9087 · Destroyed NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.Jan 7, 1997 · N3100U · Destroyed