NTSB investigations, 1992, 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\") = 1992
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") = 1992 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 LAX93WA090Accident · No injuriesForeign investigationPiper PA-34-200 · Loreto, MexicoNTSB FTW93RA052Accident · No injuriesForeign investigationPiper PA-34-200T · Quito, EcuadorNTSB DCA93RA011Accident · 56 fatalForeign investigationMcDonnell Douglas DC-10-30F · Faro, PortugalNTSB MIA93WA028Accident · No injuriesForeign investigationGrumman G-21A · West Caicos Isl, Turks & Caicos IslandsNTSB FTW93WA054Accident · No injuriesForeign investigationMcdonnell Douglas DC-8-63 · Mexico City, MexicoNTSB FTW93RA063Accident · No injuriesForeign investigationRockwell Sabreliner 75A · Quito, EcuadorNTSB MIA93WA021Accident · No injuriesForeign investigationBoeing 737-200C · San Luis, ArgentinaNTSB LAX93WA028Accident · 1 fatalForeign investigationde Havilland DHC-6-200 · KenyaNTSB MIA93WA068Accident · Minor injuriesForeign investigationHughes 369D · Buenos Aires, ArgentinaNTSB FTW93WA030Accident · No injuriesForeign investigationPiper PA-31-325 · Barranquilla, ColombiaNTSB LAX93LA019Accident · 3 fatalLimited investigationFinal reportCessna 310R · Saipan, MauritiusThe pilot not following wake turbulence (votex) avoidance procedures, which are detailed in FAA publications, resulting in the airplane encountering wake turbulence. Factors in this accident were: 1) the pilot's inability to control the airplane after…NTSB MIA93WA010Accident · No injuriesForeign investigationCessna T188C · Cozumel, MexicoNTSB MIA93WA008Accident · No injuriesForeign investigationCessna 172M · Mayaguana Isl, BahamasNTSB FTW93WA018Accident · No injuriesForeign investigationGulfstream 680 T · Pesqueria, MexicoNTSB FTW93WA026Accident · No injuriesForeign investigationCessna 550 · Comayagua, HondurasNTSB MIA93WA002Accident · No injuriesForeign investigationBoeing 727-200 · Martinique, FranceNTSB NYC92WA186Accident · 4 fatalForeign investigationMcdonnell Douglas 500E · Niagara Falls, CanadaNTSB MIA92WA192Accident · No injuriesForeign investigationPiper PA-23-250 · Mores Island, BahamasNTSB MIA92WA193Incident · No injuriesForeign investigationBoeing 747-287 · Rio De Janeiro, BrazilNTSB FTW92WA231Accident · No injuriesForeign investigationCessna 402B · San Fernando, MexicoNTSB FTW92WA236Accident · No injuriesForeign investigationPiper PA-32-260 · Punta China, MexicoNTSB MIA92WA164Accident · No injuriesForeign investigationCessna 172L · Virgin Gorda, British Virgin IslandsNTSB NYC92WA141Accident · 1 fatalForeign investigationCessna Reems F172 · Munich, GermanyNTSB MIA92WA146Accident · No injuriesForeign investigationPiper PA32R-300 · Andros Island, BahamasNTSB LAX92WA284Accident · 3 fatalForeign investigationBeech 58 · Ensenada, MexicoNTSB MIA92WA140Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasNTSB DCA92RA038Accident · No injuriesForeign investigationBoeing 737-204 · Tucuti, PanamaNTSB LAX92WA231Accident · Minor injuriesForeign investigationPiper PA-46-310P · Yokota, JapanNTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiNTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasNTSB MIA92WA074Accident · 5 fatalForeign investigationBell 206-B-III · Bridgetown, BarbadosNTSB DCA92RA020Accident · 30 fatalForeign investigationConvair 640 · Kafoutine, SenegalNTSB MIA92WA071Accident · No injuriesForeign investigationPiper PA-34-200 · West End, BahamasNTSB MIA92WA066Accident · 2 fatalForeign investigationBeech B-99 · DominicaNTSB DCA92RA019Accident · No injuriesForeign investigationAirbus Industrie A320 · Strasburg, FranceNTSB LAX92WA091Accident · Serious injuriesForeign investigationBoeing 747-100 · Narita, Japan