NTSB investigations, 1991, 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\") = 1991
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") = 1991 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 DCA92RA015Accident · No injuriesForeign investigationBoeing 747-200F · Taipei, TaiwanNTSB MIA92WA060Accident · No injuriesForeign investigationPiper PA-31-350 · Nagua, Dominican RepublicNTSB DCA92RA014Accident · No injuriesForeign investigationMcDonnell Douglas MD-81 (DC-9-81) · Stockholm, SwedenNTSB CHI92RA060Incident · No injuriesForeign investigationBoeing B-747-121 · Nakina, CanadaNTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB MIA92WA037Accident · No injuriesForeign investigationBell-Transworld 47G2 · David, PanamaNTSB MIA92WA032Accident · No injuriesForeign investigationBoeing 737-200 · San Jose, Costa RicaNTSB MIA92WA030Accident · No injuriesForeign investigationCessna 172H · Virgin Gorda, British Virgin IslandsNTSB MIA92WA023Accident · 1 fatalForeign investigationGrumman G-164B · La Romana, Dominican RepublicNTSB MIA92RA011Incident · No injuriesForeign investigationBoeing 737-300 · Grand Cayman Is, Cayman IslandsNTSB LAX91LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-602P · Pago Pago, AntarcticaThe mechanical failure of the airplane's nose wheel/gear steering system. A contributing factor was the pilot's inability to maintain directional control following the loss of steering effectiveness.NTSB MIA91WA212Accident · No injuriesForeign investigationCessna 402 · Andros Island, BahamasNTSB MIA91WA203Accident · No injuriesForeign investigationCessna 172N · Nassau, BahamasNTSB MIA91WA198Accident · No injuriesForeign investigationBeech E18S · Bimini, BahamasNTSB MIA91WA176Accident · 6 fatalForeign investigationCessna U206 · Missing, BahamasNTSB MIA91WA164Accident · 4 fatalForeign investigationGulfstream G-1159A · Caracas, VenezuelaNTSB MIA91WA162Accident · No injuriesForeign investigationAero Commander 680-E · Nassau, BahamasNTSB MIA91WA157Accident · 2 fatalForeign investigationGovernment Aircraft Fact N24A · Great Inagua, Turks & Caicos IslandsNTSB MIA91WA134Incident · No injuriesForeign investigationBeech TC-45J · Nassau, BahamasNTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB MIA91WA114Accident · 8 fatalForeign investigationCessna 402B · Ambergrs, BelizeNTSB LAX91LA147Accident · 1 fatalLimited investigationFinal reportde Havilland DHC6-300 · Nuuuli, AntarcticaThe inadequate lighting of the gate at the terminal and inadequate training of the security guard by company personnel. Contributing to this accident was a dark night condition.NTSB MIA91RA102Accident · 5 fatalForeign investigationCessna 402C · Treasure Cay, BahamasNTSB MIA91WA088Accident · No injuriesForeign investigationBeech C23 · Alice Town, BahamasNTSB MIA91WA079Accident · No injuriesForeign investigationBeech B36TC · Pitts Town, BahamasNTSB MIA91WA074Accident · Minor injuriesForeign investigationCessna 152 · Mores Island, BahamasNTSB MIA91WA066Accident · 1 fatalForeign investigationCessna U206F · MontserratNTSB MIA91WA065Accident · No injuriesForeign investigationPiper PA-23-250 · Little Whale, BahamasNTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NT