NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1120Accident · No injuriesClosedBeechcraft R-35 · Utila Is, HONTSB UNK65X1096Accident · Minor injuriesClosedAeronca 11BC · Ft Francis, CanadaNTSB UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNNTSB UNK65X0906Accident · Serious injuriesClosedStinson L-5 · Ogana, JANTSB UNK65X0862Accident · No injuriesClosedCessna 182 · San Quintin, MexicoNTSB UNK65X0822Accident · Minor injuriesClosedCessna 170B · Mulege Baja, MexicoNTSB UNK65X0806Accident · 48 fatalClosedBoeing 707 331 · Rome, ItalyNTSB UNK65X0746Accident · No injuriesClosedDouglas DC-4 · Tangra, GreenlandNTSB UNK65X0734Accident · No injuriesClosedCessna 310 · Tabruk, Saudi ArabiaNTSB UNK65X0694Accident · No injuriesClosedCessna 170 · Onna Pt Okinawa, JANTSB UNK65X0682Accident · No injuriesClosedTaylorcraft BC-12D · Nellingen, GeorgiaNTSB UNK65X0665Accident · 4 fatalClosedLockheed L-18 · Freeport, Burkina FasoNTSB UNK65X0652Accident · 2 fatalClosedFairchild C-82 · Vera Cruz, MexicoNTSB UNK65X0550Accident · No injuriesClosedCessna 182A · Sonora, MexicoNTSB UNK65X0527Accident · No injuriesClosedAero Cmdr 680 · Baja Calif, MexicoNTSB UNK65X0341Accident · No injuriesClosedNo American F51D · Corinto, NiueNTSB UNK65X0336Accident · No injuriesClosedDornier 28A1 · Thathom, LaosNTSB UNK65X0335Accident · No injuriesClosedCessna 205 · Ragged Is, Burkina FasoNTSB UNK65X0228Accident · Minor injuriesClosedNavion B · Ottawa, CanadaNTSB UNK65X0188Accident · No injuriesClosedCessna 120 · Yomitan Okinawa, JANTSB UNK65X0159Accident · No injuriesClosedPiper PA-23 · Nairobi E Africa, KenyaNTSB UNK65X0153Accident · No injuriesClosedAeronca 7AC · Strathroy, CanadaNTSB UNK65X0101Accident · No injuriesClosedCessna 180 · Aira, EthiopiaNTSB UNK64X4150Accident · No injuriesClosedRepublic F-47N · La Marina Riv, MexicoNTSB UNK64X4060Accident · No injuriesClosedHiller 12B · Thermi, GreeceNTSB UNK64X4044Accident · Minor injuriesClosedPiper PA-22 · Zaragoza, MexicoNTSB FTWSP 0002Accident · 3 fatalClosedCessna 182 · Coahuila, MexicoNTSB UNK64X3992Accident · No injuriesClosedPiper PA-24 · Baja, MexicoNTSB UNK64X3879Accident · No injuriesClosedCessna 180B · St Pierre, CanadaNTSB UNK64X3868Accident · No injuriesClosedGrumman G-44 · Terney Lake, CanadaNTSB UNK64X3656Accident · Minor injuriesClosedCessna 175 · West End Grd Baha, Burkina FasoNTSB UNK64X3637Accident · Serious injuriesClosedNavion B · Nestor Falls, CanadaNTSB UNK64X3619Accident · No injuriesClosedPine Air Superv · Penticton Bc, CanadaNTSB UNK64X3553Accident · 4 fatalClosedCessna 180 · Baja, MexicoNTSB UNK64X3527Accident · No injuriesClosedCessna 180 · Tarachi, MexicoNTSB UNK64X3482Accident · No injuriesClosedHelio H-395 · Agrinion, GreeceNTSB UNK64X3437Accident · No injuriesClosedBell 47G3B1 · Castries Bwi, São Tomé & PríncipeNTSB UNK64X3386Accident · 2 fatalClosedPiper PA-28 · Lake Athabaska, CanadaNTSB UNK64X3114Accident · Minor injuriesClosedStinson 108-1 · Mulege Baja, MexicoNTSB UNK64X3097Accident · No injuriesClosedBeechcraft C-18S · West End Grd Baha, Burkina FasoNTSB UNK64X3075Accident · No injuriesClosedLockheed PV-2 · Aruba Antilles, AANTSB UNK64X2967Accident · 2 fatalClosedBeechcraft 95B · Winnipeg, CanadaNTSB UNK64X2910Accident · 1 fatalClosedSikorsky S-58 · Colombia, ColombiaNTSB UNK64X2870Accident · 4 fatalClosedCessna 180 · Jamestown, CanadaNTSB UNK64X2848Accident · 3 fatalClosedBoeing 720B · Ansbach, GeorgiaNTSB UNK64X2771Accident · Minor injuriesClosedBoeing E-75 · Sherbrooke, CanadaNTSB UNK64X2629Accident · 3 fatalClosedBeechraft 23 · Linton Que, CanadaNTSB UNK64X2628Accident · No injuriesClosedRepublic RC-3 · Brightsand Lk, CanadaNTSB UNK64X2574Accident · No injuriesClosedLockheed L-18 · St Maria Azores, PONTSB UNK64X2556Accident · No injuriesClosedAero Cmdr 520 · Pembroke, Canada