NTSB investigations, 1993, Outside the U.S.
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 394 |
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\") = 1993
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") = 1993 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 MIA94WA032Accident · No injuriesForeign investigationMcDonnell Douglas DC10-30 · Buenos Aires, ArgentinaNTSB FTW94WA073Accident · Minor injuriesForeign investigationPiper Aerostar 601P · Campeche, MexicoNTSB MIA94WA025Accident · No injuriesForeign investigationBeech BE-80 · Guatemala City, GuatemalaNTSB LAX94WA053Accident · Serious injuriesForeign investigationPiper PA-32R-300 · Mulege, MexicoNTSB MIA94WA018Accident · No injuriesForeign investigationBeech 58TC · Kingston, JamaicaNTSB MIA94WA006Accident · 5 fatalForeign investigationPiper Aerostar 601P · Hog Cay, BahamasNTSB MIA94WA005Accident · 2 fatalForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB MIA93WA201Accident · Minor injuriesForeign investigationCessna 172F · Long Island, Turks & Caicos IslandsNTSB BFO94WA055Accident · Minor injuriesForeign investigationHiller H-23C · Egwell, GermanyNTSB MIA93WA195Accident · Serious injuriesForeign investigationCessna 402B · Sandy Point, BahamasNTSB MIA93WA188Accident · No injuriesForeign investigationBeagle B 206 Series 1 · Freeport, BahamasNTSB MIA93WA186Accident · 1 fatalForeign investigationChristen Industries Pitts S-2B · Cayenne, French GuianaNTSB BFO93WA148Incident · No injuriesForeign investigationBoeing 747-100 · Milan, ItalyNTSB DCA93RA060Accident · Serious injuriesClass 1 · ForeignDouglas DC-8-61 · Guantanamo Bay, CubaNTSB BFO93WA145Accident · 1 fatalForeign investigationCessna 208B · Valensol, FranceNTSB BFO93WA146Accident · No injuriesForeign investigationBell 212 · Marjan, Saudi ArabiaNTSB BFO93WA144Accident · 3 fatalForeign investigationMooney M20J · Celle-Arloh, GermanyNTSB MIA93WA167Accident · 4 fatalForeign investigationPiper PA-23-250 · Marsh Harbor, BahamasNTSB BFO93WA141Accident · 4 fatalForeign investigationCessna 177RG · Marseille, FranceNTSB MIA93RA146Accident · No injuriesForeign investigationCessna 421A · Aruba, ArubaNTSB FTW93TA#06Accident · No injuriesFinal reportCessna CE-550 · Comayagua, HondurasNTSB FTW93WA270Accident · 3 fatalForeign investigationAero Commander 680F · Chihuahua, MexicoNTSB FTW93WA259Accident · 3 fatalForeign investigationCessna 180G · Huazapares, MexicoNTSB MIA93WA115Accident · No injuriesForeign investigationPiper PA-32R-300 · West End, BahamasNTSB MIA93WA117Accident · Serious injuriesForeign investigationMaule M-5-235C · Fowl Cay, BahamasNTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.NTSB MIA93WA113Accident · No injuriesForeign investigationCessna 401 · Middle Caicos, Turks & Caicos IslandsNTSB LAX93WA184Accident · No injuriesForeign investigationBruce RV-6 · Pvt Ranch Baja, MexicoNTSB MIA93WA098Accident · No injuriesForeign investigationPiper PA-32-260 · N. Eleuthera I., BahamasNTSB DCA93RA036Accident · No injuriesForeign investigationBoeing 767-251 · Guatemala City, PanamaNTSB MIA93WA095Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNTSB MIA93WA094Accident · No injuriesForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB FTW93WA107Accident · No injuriesForeign investigationBoeing 727-232 · Guadalajara, MexicoNTSB LAX93WA145Accident · 3 fatalForeign investigationPiper PA-28-235 · Loreto, MexicoNTSB MIA93WA070Accident · No injuriesForeign investigationDouglas DC-7C · Santo Domingo, Dominican RepublicNTSB MIA93WA078Accident · No injuriesForeign investigationDassault-Breguet Falcon 10 · Aurillac, FranceNTSB MIA93WA060Accident · No injuriesForeign investigationPiper PA-32-260 · Rock Sound, BahamasNTSB MIA93WA059Incident · No injuriesForeign investigationDouglas DC-8-54F · Bogota, ColombiaNTSB MIA93WA057Incident · No injuriesForeign investigationCessna 402-C · Georgetown, GuyanaNTSB MIA93WA049Accident · 2 fatalForeign investigationBeech 95-B55B · Walkers Cay, BahamasNTSB MIA93WA043Accident · No injuriesForeign investigationPiper PA-31-350 · Bimini, Bahamas