Fatal NTSB investigations, 2001, Outside the U.S.
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 | 108 |
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\") = 2001
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") = 2001 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 WAS02WA014Accident · 3 fatalForeign investigationCessna 337D · Piura, PeruNTSB ATL02WA020Accident · 2 fatalForeign investigationCessna CE-560 · Zurich, SwitzerlandNTSB WAS02WA011Accident · 1 fatalForeign investigationRobinson R22 · Phitippeburg, GermanyNTSB LAX02RA045Accident · 1 fatalForeign investigationBeech 200C · Mount Gambier, AustraliaNTSB WAS02RA006Accident · 3 fatalForeign investigationCessna 208 · Quepos, Costa RicaNTSB WAS02WA007Accident · 9 fatalForeign investigationBell UH-1H · El Limon, El SalvadorNTSB DCA02WA009Accident · 4 fatalForeign investigationBeech BE-200 · Moulins, FranceNTSB DCA02WA008Accident · 24 fatalForeign investigationBritish Aerospace Avro RJ100 · Zurich, SwitzerlandNTSB IAD02WA008Accident · 1 fatalForeign investigationBell Bell 47-G2 · Fabregues, FranceNTSB WAS02WA003Accident · 2 fatalForeign investigationRobinson R-22 · San Salvador, El SalvadorNTSB DCA02WA005Accident · 2 fatalForeign investigationFairchild Swearingen SA-226-TC · Shamattawa, Man, CanadaNTSB DCA02WA004Accident · 10 fatalForeign investigationSwearingen Metroliner · Mediterranean, SpainNTSB DCA02RA002Accident · 118 fatalForeign investigationCessna CitationJet 2 · Milan, ItalyNTSB WAS02WA001Accident · 3 fatalForeign investigationBell 412HP · Los Cabos, MexicoNTSB WAS01RA026Accident · 8 fatalForeign investigationLet 410 UVP-E · Guatemala City, GuatemalaNTSB ENG01RA010Incident · 1 fatalForeign investigationFokker F28 Mk 100 · Belo Horizonte, BrazilNTSB WAS01RA025Accident · 19 fatalForeign investigationLet 410 UVP-E · Chichen Itza, MexicoNTSB WAS01WA028Accident · 8 fatalForeign investigationCessna TU206G · Baborigame, MexicoNTSB DCA01WA059Accident · 4 fatalForeign investigationCASA 235 · Malaga, SpainNTSB MIA01RA225Accident · 9 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasNTSB IAD01WA081Accident · 2 fatalForeign investigationCessna T210M · Innsbruck, AustriaNTSB NYC01WA207Accident · 2 fatalForeign investigationHughes 369D · Baffin Island, CanadaNTSB MIA01WA214Accident · 5 fatalForeign investigationCessna 210 · Barcelonette, FranceNTSB ENG01RA005Incident · 3 fatalForeign investigationDassault Falcon 20 · Narsarsuaq, GreenlandNTSB MIA01WA188Accident · 1 fatalForeign investigation206 · Minas Parapapoy, VenezuelaNTSB MIA01WA183Accident · 1 fatalForeign investigationMooney M20M · Manhay, BelgiumNTSB WAS01RA011Accident · 2 fatalForeign investigationRobinson R-44 · La Fortuna, ParaguayNTSB WAS01WA015Accident · 8 fatalForeign investigationSikorsky S-76B · P'ohang, South KoreaNTSB WAS01RA013Accident · 2 fatalForeign investigationCessna U206G · San Ignacio, BoliviaNTSB MIA01WA184Accident · 1 fatalForeign investigationCessna 172 · Sonnblick, AustriaNTSB MIA01WA177Accident · 6 fatalForeign investigationCessna 206 · Baborigame, MexicoNTSB NYC01WA162Accident · 4 fatalForeign investigationPiper PA-28-161 · Yverdon, SwitzerlandNTSB NYC01WA159Accident · 1 fatalForeign investigationCessna 170B · Uxbridge, CanadaNTSB IAD01WA073Accident · 2 fatalForeign investigationCessna 210 · Petawa, Ontario, CanadaNTSB IAD01WA064Accident · 3 fatalForeign investigationPiper 31-310 · Prince Edward, CanadaNTSB WAS01WA010Accident · 3 fatalForeign investigationBell UH-IH · Taumarunui, New ZealandNTSB IAD01WA065Accident · 1 fatalForeign investigationBell P-63A-7BE · Biggin Hill, United KingdomNTSB IAD01WA060Accident · 2 fatalForeign investigationBeech BE-36 · Berlin, GermanyNTSB SEA01WA099Accident · 10 fatalForeign investigationCessna 172P · Kuwana Mie Pre., JapanNTSB WAS01RA008Accident · 6 fatalForeign investigationBell 407 · Puerto Princesa, PhilippinesNTSB WAS01WA007Accident · 2 fatalForeign investigationCessna 182 · Zumatlan, MexicoNTSB MIA01WA141Accident · 2 fatalForeign investigationPiper PA-24-250 · Maldon Essex, United KingdomNTSB IAD01WA057Accident · 2 fatalForeign investigationCessna 182S · Leicester, United KingdomNTSB NYC01WA117Accident · 1 fatalForeign investigationPiper PA-42-1000 · Nurnberg, GermanyNTSB WAS01RA005Accident · 5 fatalForeign investigationCessna 182J · Coban, GuatemalaNTSB MIA01WA142Accident · 1 fatalForeign investigationCessna C-208 Caravan · Nagambie, AustraliaNTSB MIA01WA133Accident · 10 fatalForeign investigationCessna 208B · Roque Perez, ArgentinaNTSB NYC01WA104Accident · 3 fatalForeign investigationMooney M20E · Saint Mamet, FranceNTSB MIA01WA132Accident · 1 fatalForeign investigationBeech 55 · Carache, VenezuelaNTSB CHI01WA123Accident · 2 fatalForeign investigationCessna T310R · Madinah, Saudi Arabia