Fatal NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 FTW00WA056Accident · 2 fatalForeign investigationCessna 414 · Apodaca, MexicoNTSB DCA00RA017Accident · 4 fatalForeign investigationBoeing 747-200F · Stansted, United KingdomNTSB DCA00WA016Accident · 18 fatalForeign investigationMcDonnell Douglas DC-10-30 · Guatemala City, GuatemalaNTSB FTW00RA043Accident · 1 fatalForeign investigationBell UH-1H · Cali, ColombiaNTSB MIA00WA045Accident · 1 fatalForeign investigationBeech B95A · Maizal, Dominican RepublicNTSB IAD00WA011Accident · 10 fatalForeign investigationPiper PA31-350 · Rand, South AfricaNTSB IAD00WA010Accident · 2 fatalForeign investigationCessna 206 · Port-Au-Prince, HaitiNTSB IAD00RA009Accident · 10 fatalForeign investigationBell 212 · Rangali, MaldivesNTSB FTW00RA062Accident · 3 fatalForeign investigationCessna 182S · Tepic, MexicoNTSB FTW00RA039Accident · 1 fatalForeign investigationBell 206-L1 · Cabinda, AngolaNTSB LAX00WA042Accident · 1 fatalForeign investigationHiller UH-12E · Kaohslung, TaiwanNTSB NYC00WA038Accident · 4 fatalForeign investigationCessna 208 · Nairobi, KenyaNTSB NYC00WA062Accident · 3 fatalForeign investigationEurocopter EC-135 · Basepohl, GermanyNTSB FTW00RA029Accident · 18 fatalForeign investigationDouglas DC-9-31 · Uruapan, MexicoNTSB MIA00WA024Accident · 4 fatalForeign investigationBeech 58 · Abidjan, MaliNTSB IAD00WA004Accident · 2 fatalForeign investigationHughes 369D · Cologne, GermanyNTSB NYC00WA015Accident · 1 fatalForeign investigationPiper PA-46-350P · Cranbrook, CanadaNTSB FTW00WA020Accident · 3 fatalForeign investigationCessna 182P · Coban, GuatemalaNTSB FTW00RA156Accident · 2 fatalForeign investigationBell 206L-1 · Quetzaltenango, GuatemalaNTSB MIA00WA014Accident · 4 fatalForeign investigationCessna 207 · Puerto Ayacucho, VenezuelaNTSB FTW00RA003Accident · 12 fatalForeign investigationBell 214ST · Dhahran, Saudi ArabiaNTSB MIA99WA260Accident · 6 fatalForeign investigationAero Commander 500S · La Tinta, GuatemalaNTSB DCA99RA084Accident · 6 fatalForeign investigationDassault Falcon 900 · Bucharest, RomaniaNTSB IAD99RA065Accident · 8 fatalForeign investigationCessna 404 · Linwood, United KingdomNTSB IAD99RA063Accident · 12 fatalForeign investigationCessna 404 · Arusha, TanzaniaNTSB DCA99RA076Accident · 80 fatalForeign investigationBoeing 737-200 · Ba, ArgentinaNTSB IAD99WA062Accident · 2 fatalForeign investigationLearjet 35A · Adwa, EthiopiaNTSB MIA99WA244Accident · 4 fatalForeign investigationCessna 206 · La Ceiba, HondurasNTSB MIA99WA240Accident · 2 fatalForeign investigationRobinson R22B · Cornakelly, IrelandNTSB IAD99WA060Accident · 1 fatalForeign investigationCessna 206G · Nairobi, KenyaNTSB DCA99RA074Accident · 1 fatalForeign investigationMcDonnell Douglas MD-90 · Hualien, TaiwanNTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB FTW99RA217Accident · 6 fatalForeign investigationCessna 414 · Monrovia, LiberiaNTSB FTW99WA209Accident · 5 fatalForeign investigationPiper PA-32-260 · Guayaquil, EcuadorNTSB IAD99RA057Accident · 16 fatalForeign investigationCessna 208B · Bluefields, NicaraguaNTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaNTSB DCA99WA068Accident · 5 fatalForeign investigationBoeing 727-243F · Kathmandu, NepalNTSB DCA99WA075Accident · 2 fatalForeign investigationBeech 99 · Leige, BelgiumNTSB MIA99WA198Accident · 2 fatalForeign investigationBeech T-34B Mentor · San Isidro, Dominican RepublicNTSB NYC99WA206Accident · 4 fatalForeign investigationRobinson R22 · Grossenhain, GermanyNTSB CHI99WA194Accident · 2 fatalForeign investigationMaule M-5-220C · Lake St. John, CanadaNTSB MIA99WA187Accident · 2 fatalForeign investigationCessna U206F · Ciudad Bolivar, VenezuelaNTSB NYC99WA121Accident · 2 fatalForeign investigationMitsubishi MU-2B-40 · Perry Sound, CanadaNTSB SEA99WA057Accident · 2 fatalForeign investigationPiper PA-60-602P · Tambon Tha Chal, IndiaNTSB FTW99RA122Accident · 3 fatalForeign investigationKawasaki BK-117B-1 · Keelung, TaiwanNTSB DCA99RA056Accident · 3 fatalForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB LAX99RA151Accident · 4 fatalForeign investigationBell 206B · 60 N. Jakarta, IndonesiaNTSB DCA99RA053Accident · 6 fatalForeign investigationBoeing 737-400 · Ceyhan Adana, TürkiyeNTSB LAX99WA141Accident · 7 fatalForeign investigationBell 412 · Santan, IndonesiaNTSB IAD99GA036Accident · 13 fatalFinal reportMil MI-8MTV-1 · Hinche, HaitiThe flightcrew's inability to maintain visual contact with mountainous terrain in night, instrument meteorological conditions. Contributing to the accident was a lack of preparation and support for difficult flight conditions, including lack of coordination…