NTSB investigations, 1990, 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.
Cases per year
| 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
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\") = 1990
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") = 1990 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 MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasNTSB MIA91WA055Accident · No injuriesForeign investigationPiper PA-34-200 · Nassau, BahamasNTSB MIA91WA054Accident · Serious injuriesForeign investigationCessna 401B · Marsh Harbor, BahamasNTSB MIA91IA051Incident · No injuriesIncident investigationFinal reportDassault-Breguet HU-25/A · Bimini, BahamasInadequate visual lookout by the pilots of both aircraft, resulted in their failure to see-and-avoid the other aircraft.NTSB MIA91WA046Incident · No injuriesForeign investigationCessna 402B · Nevis, WNNTSB MIA91WA053Accident · No injuriesForeign investigationAstar AS-350D · San Jose, Costa RicaNTSB MIA91WA039Accident · No injuriesForeign investigationPiper PA-28R200 · St. Mary, JamaicaNTSB MIA91WA030Incident · No injuriesForeign investigationBoeing 727-200 · Curacao, NTNTSB LAX91LA013Accident · 2 fatalLimited investigationFinal reportBell 47G5 · AntarcticaThe pilot's failure to maintain on adequate altitude while maneuvering above the water.NTSB MIA91WA012Accident · 6 fatalForeign investigationPiper PA-34-200T · Lascahobas, HaitiNTSB MIA90WA184Accident · 1 fatalForeign investigationCessna 402B · Santo Domingo, Dominican RepublicNTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesNTSB DCA90WA045Accident · Serious injuriesForeign investigationAirbus Industrie A-310 · Paris, FranceNTSB MIA90WA175Accident · No injuriesForeign investigationPiper PA-23-250T · AnguillaNTSB MIA90WA165Accident · No injuriesForeign investigationCessna 172 · Grd Bahama Isl, BahamasNTSB DCA90WA049Accident · Serious injuriesForeign investigationMcdonnell Douglas DC-10-30 · Bharu, MalaysiaNTSB LAX90WA265Accident · No injuriesForeign investigationPiper PA-11 · Belize City, BelizeNTSB MIA90WA142Accident · 1 fatalForeign investigationPiper PA31T · New Town, BahamasNTSB LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…NTSB LAX90WA201Accident · Minor injuriesForeign investigationCessna 182 · Luzon Island, PhilippinesNTSB MIA90WA131Accident · No injuriesForeign investigationCessna 310R · Eleuthera Isl., BahamasNTSB MIA90WA121Accident · No injuriesForeign investigationBell 222-UT · Lavega, Dominican RepublicNTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaNTSB MIA90WA114Accident · No injuriesForeign investigationPiper PA-32-260 · Freeport, BahamasNTSB DCA90WA430Accident · 1 fatalForeign investigationBeech C99 Airliner · Moosonee, CanadaNTSB MIA90WA116Accident · 1 fatalForeign investigationRyan, Robert R. Glasair · Orangewalk Town, BelizeNTSB MIA90WA108Accident · No injuriesForeign investigationPiper PA-28-140 · St.Maarten, NTNTSB MIA90WA095Accident · No injuriesForeign investigationBeech H-18 · Nassau, BahamasNTSB MIA90WA068Accident · 5 fatalForeign investigationMooney M20F · San Andros, BahamasNTSB MIA90WA062Accident · No injuriesForeign investigationPiper PA-23-250 · Congotown, Congo - Kinshasa