NTSB investigations, 1996, 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\") = 1996
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") = 1996 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 MIA97WA060Accident · No injuriesForeign investigationAerospatiale SA-315B · Sapahwa, PeruNTSB MIA97WA044Accident · No injuriesForeign investigationPiper PA-23-250 · Walker Cay, BahamasNTSB DCA97WA014Accident · 3 fatalForeign investigationBell 206B · Madrid, SpainNTSB DCA97WA068Accident · 1 fatalForeign investigationSikorsky S-76B · Omeath Ireland, IrelandNTSB ATL97WA024Accident · No injuriesForeign investigationCessna 182 · Bimini, BahamasNTSB LAX97WA094Accident · No injuriesForeign investigationCessna 182N · Obergon, MexicoNTSB CHI97WA039Accident · 2 fatalForeign investigationLearjet 36 · Stephenville, IrelandNTSB DCA97WA013Incident · No injuriesForeign investigationBoeing 747-236F · Hong Kong, United KingdomNTSB DCA97WA011Accident · 125 fatalForeign investigationBoeing 767 · Comorso Islands, EthiopiaNTSB FTW97RA055Accident · No injuriesForeign investigationBell 407 · Moran, SpainNTSB NYC97WA017Accident · 8 fatalForeign investigationPiper PA-31-310 · Nairobi, KenyaNTSB DCA97WA007Accident · 349 fatalForeign investigationBoeing 747-168 · New Delhi, IndiaNTSB NYC97WA016Accident · 2 fatalForeign investigationBell 206B3 · Dear, South AfricaNTSB NYC97WA015Accident · 8 fatalForeign investigationCessna 421 · Donzeil, FranceNTSB DCA97WA005Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Buenos Aires, ArgentinaNTSB MIA97WA018Accident · 14 fatalForeign investigationEmbraer EMB-110 · Flores, GuatemalaNTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNNTSB DCA97WA004Accident · 97 fatalForeign investigationFokker 100 · Sao Paulo, BrazilNTSB MIA97RA011Accident · 34 fatalForeign investigationBoeing 707-323 · Manta, EcuadorNTSB NYC97RA006Accident · 8 fatalForeign investigationPiper PA-31-350 · Eel River Cross, CanadaNTSB MIA97WA015Accident · 3 fatalForeign investigationCessna 404 · Bolognesi, PeruNTSB LAX97WA017Accident · Serious injuriesForeign investigationPiper PA-28-140 · Kumamoto, JapanNTSB MIA97WA009Accident · 3 fatalForeign investigationBeech 65-A90 · Itaguazurenda, BoliviaNTSB MIA97RA005Accident · Serious injuriesForeign investigationBell 407 · Andros Island, BahamasNTSB DCA97RA001Accident · 70 fatalForeign investigationBoeing B-757-23A · Lima, PeruNTSB SEA96WA222Accident · No injuriesForeign investigationDouglas DC-3 · Holland, NetherlandsNTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalNTSB IAD96WA141Accident · No injuriesForeign investigationCessna T-310P · Skiathos, GreeceNTSB MIA96WA230Accident · 8 fatalForeign investigationBell UH-1B · Concepcion, ArgentinaNTSB MIA96WA204Accident · Minor injuriesForeign investigationCessna 402B · St. Barthelemy, MartiniqueNTSB IAD96LA128Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Amos, Canadathe pilot's inadvertent wheels down landing on water. A related factor was his diverted attention during the landing.NTSB LAX96WA348Accident · No injuriesForeign investigationPiper PA-24-260C · FijiNTSB NYC96WA175Accident · 2 fatalForeign investigationPiper PA-30 · North Italy, ItalyNTSB FTW96WA310Accident · 2 fatalForeign investigationAerospatiale SA315B · La Peruanita, PeruNTSB MIA96WA170Accident · No injuriesForeign investigationBeech D18S · Rock Sound, BahamasNTSB MIA96WA169Accident · 2 fatalForeign investigationPiper PA-18-C23 · Iztapa, GuatemalaNTSB CHI96WA204Accident · 1 fatalForeign investigationPiper PA-24-250 · Pelican Narrows, CanadaNTSB MIA96WA140Accident · 2 fatalForeign investigationBeech 200 · Treasure Cay, BahamasNTSB FTW96WA220Accident · Minor injuriesForeign investigationDouglas DC9-14 · Tampico, MexicoNTSB MIA96WA129Accident · Minor injuriesForeign investigationCessna 182F · Grand Cayman, Cayman IslandsNTSB MIA96WA124Accident · No injuriesForeign investigationCessna C441 · Walkers Cay, BahamasNTSB MIA96WA110Accident · Minor injuriesForeign investigationde Havilland DH6 · Virgin Gorda, British Virgin IslandsNTSB DCA96RA046Accident · 33 fatalForeign investigationBoeing CT-42A · Dubrovnik, CroatiaNTSB NYC96WA082Accident · No injuriesForeign investigationCessna C340 · Valreas, FranceNTSB NYC96WA076Accident · Minor injuriesForeign investigationBritten-Norman BN2A-21 · IcelandNTSB MIA96WA098Accident · 8 fatalForeign investigationCessna 402B · Punto Fijo, VenezuelaNTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruNTSB LAX96WA132Accident · 1 fatalForeign investigationCessna 421B · Vigan, PhilippinesNTSB DCA96RA034Accident · 123 fatalForeign investigationBoeing -737-222 · Arequipa, PeruNTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, Cuba