NTSB investigations, 1994, Outside the U.S.
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 393 |
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\") = 1994
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") = 1994 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 DCA95WA012Accident · No injuriesForeign investigationBoeing 737-400 · Van, TürkiyeNTSB MIA95WA047Accident · No injuriesForeign investigationNorth American NA-265-40 · Buenos Aires, ArgentinaNTSB DCA95RA009Accident · 5 fatalForeign investigationBoeing B737-2D6C · Coventry, AlgeriaNTSB MIA95WA045Accident · No injuriesForeign investigationMooney M20J · Spanish Cay, BahamasNTSB NYC95WA235Accident · 2 fatalForeign investigationDouglas DC-3C · Lobito, Central African RepublicNTSB MIA95WA043Accident · No injuriesForeign investigationIsrael Aircraft Industries WESTWIND-1123 · Caracas, VenezuelaNTSB MIA95WA025Accident · 3 fatalForeign investigationPiper PA28 · St. Vincent, SpainNTSB LAX95WA056Accident · No injuriesForeign investigationPiper PA-32R-300 · Tripui, MexicoNTSB MIA95WA022Accident · No injuriesForeign investigationFairchild Hiller F-27F · Cordoba, ArgentinaNTSB MIA95WA017Accident · No injuriesForeign investigationPiper PA-23-250 · Mangrove Key, Congo - KinshasaNTSB FTW95WA037Accident · No injuriesForeign investigationBell 212 · Cozumel, MexicoNTSB MIA95WA009Accident · No injuriesForeign investigationCessna 402B · Exuma Island, BahamasNTSB BFO95WA004Accident · No injuriesForeign investigationPiper PA28RT-201 · SwitzerlandNTSB NYC94WA183Accident · 1 fatalForeign investigationBeech C35 · Lake Erie, CanadaNTSB DCA94WA077Accident · 2 fatalForeign investigationAero Commander 500S · Westman Isles, IcelandNTSB MIA94WA215Accident · No injuriesForeign investigationPiper PA32R-301T · Long Island, BahamasNTSB LAX94WA373Accident · No injuriesForeign investigationPiper PA-28-140 · Prince George, CanadaNTSB MIA94T#A04Accident · No injuriesClass 3Final reportCASA 212-A · Canuto, St. LuciaNTSB LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.NTSB MIA94RA192Accident · No injuriesForeign investigationBell UH-1B · Salama, GuatemalaNTSB LAX94WA341Accident · 1 fatalForeign investigationCessna 182 · Creel, MexicoNTSB MIA94WA189Accident · No injuriesForeign investigationPiper PA28-180 · Great Inagua, Turks & Caicos IslandsNTSB BFO94WA126Accident · 1 fatalForeign investigationNorth American F-100F · Cuxhaven, GermanyNTSB MIA94WA219Accident · No injuriesForeign investigationCessna 401A · Congotown, Congo - KinshasaNTSB MIA94WA145Accident · No injuriesForeign investigationPiper PA-31-350 · Herrera, Dominican RepublicNTSB MIA94WA136Accident · 4 fatalForeign investigationBeech BE65-A80 · Moca, Dominican RepublicNTSB MIA94RA142Incident · No injuriesForeign investigationMcdonnell Douglas DC9-34 · Maiquetia, VenezuelaNTSB MIA94WA134Accident · 1 fatalForeign investigationBlackmun, Larry Kitfox IV 1200 · Munjack Cay, BahamasNTSB DCA94RA055Accident · No injuriesForeign investigationLearjet 55 · Seville, SpainNTSB BFO94WA063Accident · No injuriesForeign investigationABC ABC 60 Plus · Romsley, United KingdomNTSB BFO94WA088Accident · No injuriesForeign investigationCessna CE-421C · Ingolstadt, GermanyNTSB MIA94WA101Accident · Serious injuriesForeign investigationCessna 402B · Cat Island, BahamasNTSB ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…NTSB MIA94WA095Accident · Serious injuriesForeign investigationCessna 402B · Jeremie, HaitiNTSB MIA94WA092Accident · Serious injuriesForeign investigationCessna T-337-B · Cay Sal, BahamasNTSB BFO94WA056Accident · No injuriesForeign investigationCessna C 182 · Tanzania, SudanNTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasNTSB DCA94RA037Accident · No injuriesForeign investigationBoeing 747 · Narita, JapanNTSB MIA94WA079Accident · No injuriesForeign investigationPiper PA-23-250 · Tortola, British Virgin IslandsNTSB DCA94WA036Accident · No injuriesForeign investigationBeech 2000 (Starship) · Roskilde, DenmarkNTSB BFO94WA125Accident · No injuriesForeign investigationGrumman AA1B · Bayreuth, GermanyNTSB BFO94WA031Accident · Minor injuriesForeign investigationBeech BE-90 · France