Fatal NTSB investigations, 1996, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 1 |
|---|---|
| 1964 | 20 |
| 1965 | 18 |
| 1966 | 15 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 14 |
| 1971 | 11 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 11 |
| 1975 | 11 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 11 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 24 |
| 1996 | 37 |
| 1997 | 37 |
| 1998 | 43 |
| 1999 | 53 |
| 2000 | 77 |
| 2001 | 66 |
| 2002 | 59 |
| 2003 | 71 |
| 2004 | 75 |
| 2005 | 97 |
| 2006 | 89 |
| 2007 | 87 |
| 2008 | 90 |
| 2009 | 90 |
| 2010 | 98 |
| 2011 | 120 |
| 2012 | 119 |
| 2013 | 124 |
| 2014 | 107 |
| 2015 | 130 |
| 2016 | 131 |
| 2017 | 133 |
| 2018 | 137 |
| 2019 | 140 |
| 2020 | 91 |
| 2021 | 107 |
| 2022 | 125 |
| 2023 | 98 |
| 2024 | 110 |
| 2025 | 109 |
| 2026 | 109 |
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'
AND c.\"highestInjuryLevel\" = 'Fatal'
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' AND c."highestInjuryLevel" = 'Fatal' 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 DCA97WA014Accident · 3 fatalForeign investigationBell 206B · Madrid, SpainNTSB DCA97WA068Accident · 1 fatalForeign investigationSikorsky S-76B · Omeath Ireland, IrelandNTSB CHI97WA039Accident · 2 fatalForeign investigationLearjet 36 · Stephenville, IrelandNTSB DCA97WA011Accident · 125 fatalForeign investigationBoeing 767 · Comorso Islands, EthiopiaNTSB 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 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 MIA97WA009Accident · 3 fatalForeign investigationBeech 65-A90 · Itaguazurenda, BoliviaNTSB DCA97RA001Accident · 70 fatalForeign investigationBoeing B-757-23A · Lima, PeruNTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalNTSB MIA96WA230Accident · 8 fatalForeign investigationBell UH-1B · Concepcion, ArgentinaNTSB NYC96WA175Accident · 2 fatalForeign investigationPiper PA-30 · North Italy, ItalyNTSB FTW96WA310Accident · 2 fatalForeign investigationAerospatiale SA315B · La Peruanita, PeruNTSB 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 DCA96RA046Accident · 33 fatalForeign investigationBoeing CT-42A · Dubrovnik, CroatiaNTSB 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, CubaNTSB MIA96WA083Accident · 1 fatalForeign investigationCessna 207 · San Jose, Costa RicaNTSB NYC96WA070Accident · 5 fatalForeign investigationPiper PA-46 · ZambiaNTSB MIA96WA079Accident · 11 fatalForeign investigationAerospace Tech. of Australia N24A · Port-Au-Prince, HaitiNTSB DCA96RA030Accident · 189 fatalForeign investigationBoeing 757-200 · Puerto Plata, Dominican RepublicNTSB LAX96RA116Accident · 8 fatalForeign investigationCessna 550 · Ensenada, MexicoNTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.NTSB MIA96WA058Accident · 5 fatalForeign investigationCessna 172 · Nassau, BahamasNTSB MIA96WA056Accident · 3 fatalForeign investigationCessna 182M · Trujillo, Honduras