Skip to content

NTSB investigations, 1997, Outside the U.S.

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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

NTSB investigations, 1997, Outside the U.S. per year, 1962–2026: 9,095 cases
1962	9
1963	3
1964	108
1965	99
1966	106
1967	101
1968	64
1969	63
1970	70
1971	56
1972	79
1973	66
1974	65
1975	58
1976	16
1977	24
1978	36
1979	14
1980	5
1981	2
1982	5
1983	3
1984	7
1985	6
1986	8
1987	22
1988	41
1989	25
1990	30
1991	29
1992	36
1993	41
1994	42
1995	66
1996	61
1997	93
1998	134
1999	110
2000	159
2001	152
2002	134
2003	136
2004	154
2005	174
2006	181
2007	174
2008	174
2009	181
2010	227
2011	238
2012	259
2013	248
2014	219
2015	268
2016	319
2017	304
2018	337
2019	323
2020	257
2021	428
2022	429
2023	460
2024	492
2025	475
2026	390

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' 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'
  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'
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 MIA98WA075Accident · No injuriesForeign investigationRockwell 690A · Villavicencio, ColombiaDec 28, 1997 · N60B · Substantial damage NTSB DCA98WA025Accident · No injuriesForeign investigationBoeing 757 · Amsterdam, NetherlandsDec 24, 1997 · PHTKC · Substantial damage NTSB DCA98WA019Accident · No injuriesForeign investigationBell UH-1H · Columbia, ColombiaDec 22, 1997 · UNK NTSB DCA98WA014Accident · No injuriesForeign investigationSikorsky S-76B · North Sea, NetherlandsDec 20, 1997 · H-KHB · Destroyed NTSB MIA98WA043Accident · No injuriesForeign investigationBeech BE-200 · Huarmey, PeruDec 19, 1997 · N26LE · Substantial damage NTSB DCA98RA013Accident · 97 fatalForeign investigationBoeing 737-300 · IndonesiaDec 19, 1997 · 9VTRF NTSB DCA98RA012Accident · Serious injuriesForeign investigationCanadair CL-600-2B19 · fredericton, CanadaDec 16, 1997 · CFSKI NTSB ATL98IA024Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Montego Bay, JamaicaThe pilot's improper recovery from a bounced landing, compounded by the automatic deployment of the ground spoilers on main wheel spin-up, resulting in a pitch angle beyond the tail strike pitch angle of the airplane, which led to the tail contacting the…Dec 15, 1997 · N90070 · Minor damage 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 MIA98WA042Accident · Minor injuriesForeign investigationSocata TB-20 · Little Cayman, Cayman IslandsDec 6, 1997 · N52CJ · Substantial damage NTSB LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.Dec 6, 1997 · N9068F · Destroyed NTSB MIA98WA056Incident · No injuriesForeign investigationBoeing 707-320 · Montevideo, UruguayDec 5, 1997 · CXBSB · No damage NTSB MIA98WA041Accident · Minor injuriesForeign investigationPiper PA-31-350 · Walker Cay, BahamasDec 4, 1997 · N116PM · Substantial damage NTSB DCA98WA017Incident · No injuriesForeign investigationMcDonnell Douglas MD83-2 · Paris, FranceDec 2, 1997 · GHEI · Minor damage NTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.Nov 26, 1997 · N1256H · Destroyed NTSB DCA98RA009Accident · 9 fatalForeign investigationBell UH-1H · La Palma, PanamaNov 25, 1997 · N124 NTSB DCA98WA039Incident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Paris, FranceNov 23, 1997 · FGRMC · No damage NTSB DCA98WA007Accident · Minor injuriesForeign investigationMcDonnell Douglas DC-8F · Mwanza Airport, TanzaniaNov 18, 1997 · ELWVD · Substantial damage NTSB FTW98WA043Accident · No injuriesForeign investigationPiper PA-24-180 · Guatemala City, GuatemalaNov 3, 1997 · N5071P · Substantial damage NTSB LAX98WA032Accident · Serious injuriesForeign investigationCessna 182 · Nayarit, MexicoNov 2, 1997 · N2664R · Destroyed NTSB DCA98RA008Accident · 2 fatalForeign investigationBoeing 234 · Comox Lake, CanadaOct 30, 1997 · CFHFH NTSB DCA98WA005Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Montevideo, UruguayOct 24, 1997 · N275WA · Substantial damage NTSB FTW98RA011Accident · Minor injuriesForeign investigationAyres S2R-T65 · Neiva, ColombiaOct 14, 1997 · PN259 NTSB DCA98RA003Accident · 75 fatalForeign investigationMcDonnell Douglas DC-9-32 · Nuevo Berlin, UruguayOct 10, 1997 · LVWEG NTSB DCA98WA082Accident · No injuriesForeign investigationCessna 650-0220 · Harbin, ChinaOct 9, 1997 · B4106 · Substantial damage 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 DCA97RA063Accident · No injuriesForeign investigationBoeing 737-200 · Saudi ArabiaSep 6, 1997 · HZ-AG NTSB ATL97WA145Accident · 1 fatalForeign investigationCessna A188B · Trinidad, WNSep 5, 1997 · 9YTIQ · Destroyed NTSB DCA98WA006Incident · No injuriesForeign investigationde Havilland DHC-2 · Spa Belgium, BelgiumSep 2, 1997 · OYJRR · Minor damage 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 DCA97WA054Accident · No injuriesForeign investigationLearjet LR-31 · Southern Thaila, ThailandJul 21, 1997 · Destroyed NTSB MIA97WA214Accident · Serious injuriesForeign investigationCessna 402C · Gt. Harbour Cay, BahamasJul 10, 1997 · N2717Y · Destroyed NTSB LAX97LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · Aguiguan Island, MauritiusThe pilot's failure to maintain runway alignment while landing on an undeveloped private dirt strip.Jul 4, 1997 · N8189B · Substantial damage NTSB DCA99WA071Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Saudia Arabia, Saudi ArabiaJun 30, 1997 · UNK · No damage NTSB SEA97WA154Accident · Serious injuriesForeign investigationPiper PA-24-250 · Powell River, CanadaJun 27, 1997 · N6745P · Substantial damage NTSB MIA97WA189Accident · No injuriesForeign investigationAviat A-1 · San Fernando, ArgentinaJun 21, 1997 · N12HU · Substantial damage NTSB DCA97WA067Incident · No injuriesForeign investigationBoeing 737-548 · Copenhagen, DenmarkJun 20, 1997 · EI-CDT · No damage NTSB NYC97WA115Accident · 3 fatalForeign investigationCessna 185F · Bagotville, CanadaJun 14, 1997 · N4758E · Destroyed NTSB MIA97WA186Accident · No injuriesForeign investigationCessna 501 · Berry Island, BahamasJun 11, 1997 · N1AT · Substantial damage NTSB DCA97RA050Accident · Serious injuriesForeign investigationMcDonnell Douglas MD-11 · Nagoya, JapanJun 8, 1997 · J8580 · Minor damage NTSB ATL97WA079Accident · Serious injuriesForeign investigationBoeing 767-300 · Asuncion, ParaguayJun 4, 1997 · N651UA · No damage NTSB NYC97WA104Accident · 2 fatalForeign investigationCessna TU-206G · Carroll Lake, CanadaJun 1, 1997 · N6428Z · Substantial damage