Fatal NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 DFW07WA054Accident · 2 fatalForeign investigationSabreliner NA-265T39 · Culiacan, MexicoNTSB DEN07WA041Accident · 1 fatalForeign investigationPiper PA-28-161 · Cantal Region, FranceNTSB WAS07WA005Accident · 2 fatalForeign investigationCessna 310Q · Mbeya, TanzaniaNTSB DFW07WA040Accident · 3 fatalForeign investigationPiper PA-34-220T · Cadiz, SpainNTSB DEN07WA031Accident · 1 fatalForeign investigation107.5 Flying One Design DR 107 · Langenthal, SwitzerlandNTSB LAX07WA057Accident · 1 fatalForeign investigationRobinson R44 · Nadi, FijiNTSB DEN07WA034Accident · 1 fatalForeign investigationGrob G 180 · Mindelheim, GermanyNTSB NYC07WA044Accident · 2 fatalForeign investigationBell 412 · Cafasse, Torino, ItalyNTSB NYC07WA039Accident · 1 fatalForeign investigationRobinson R-44 · Venice, ItalyNTSB DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNTSB MIA07WA022Accident · 6 fatalForeign investigationBeech B55 · Coyhaique, ChileNTSB DEN07WA025Accident · 1 fatalForeign investigationBurton Christen Eagle II · Pfronten, GermanyNTSB MIA07WA023Accident · 1 fatalForeign investigationBell 206L · Antioquia, ColombiaNTSB DEN07WA018Accident · 1 fatalForeign investigationRobinson R-44 · Katrineholm, SwedenNTSB WAS07RA004Accident · 96 fatalForeign investigationBoeing 737-200 · Abuja, NigeriaNTSB DEN07WA016Accident · 5 fatalForeign investigationCASA C-212-CE · Skanoer, SwedenNTSB WAS07WA003Accident · 6 fatalForeign investigationCessna 425 · Tulear, MadagascarNTSB WAS07WA001Accident · 2 fatalForeign investigationPiper PA-28-140 · Petrusburg, South AfricaNTSB DEN07WA012Accident · 4 fatalForeign investigationBeech 90 · Besancon, FranceNTSB DFW07WA005Accident · 3 fatalForeign investigationPiper PA-32 · Alava, SpainNTSB MIA07WA006Accident · 6 fatalForeign investigationPiper PA-34-200 · Victoria, BrazilNTSB DFW07WA002Accident · 4 fatalForeign investigationRobinson R44 · Sosua, Dominican RepublicNTSB WAS07WA002Accident · 3 fatalForeign investigationBeech V35 · Himeville, South AfricaNTSB DCA07WA002Accident · 4 fatalForeign investigationBritish Aerospace BAe-146-200A · Stord-Sorstokke, NorwayNTSB DCA06RA076Accident · 154 fatalForeign investigationBoeing 737-800 · Azevedo, BrazilNTSB ANC06WA139Accident · 1 fatalForeign investigationBell 204B · Stony Rapids, CanadaNTSB MIA06WA138Accident · 1 fatalForeign investigationBell 212 · San Vicente, ColombiaNTSB DEN06WA133Accident · 1 fatalForeign investigationPiper PA-28-181 · Bad Schwartau, GermanyNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaNTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoNTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaNTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaNTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoNTSB DEN06WA120Accident · 1 fatalForeign investigationBellanca 17-31 ATC · Neuwerk Island, GermanyNTSB ANC06WA120Accident · 6 fatalForeign investigationCessna 337 · Ft. Good Hope, CanadaNTSB NYC06WA202Accident · 3 fatalForeign investigationLockheed L-100-30 · Piacenza, ItalyNTSB MIA06WA128Accident · 2 fatalForeign investigationCessna 207A · Puerto Ayacucho, VenezuelaNTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaNTSB NYC06WA186Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Guipuzcoa, SpainNTSB CHI06WA192Accident · 4 fatalForeign investigationPiper PA-46-310P · Marina di Campo, ItalyNTSB DEN06WA102Accident · 1 fatalForeign investigationCessna T310R · Saint Tropez, FranceNTSB DEN06WA098Accident · 3 fatalForeign investigationCessna 172N · El Rosario, SpainNTSB WAS06WA012Accident · 5 fatalForeign investigationLockheed 382 C130 · Kigoma, TanzaniaNTSB DFW06WA177Accident · 5 fatalForeign investigationCessna 182C · Tepic, MexicoNTSB DCA06RA055Accident · 124 fatalForeign investigationAirbus Industrie A310-300 · Irkutsk, RussiaNTSB DCA06RA053Accident · 6 fatalForeign investigationSikorsky S61N · Tenerife, SpainNTSB DFW08WA205Accident · 5 fatalForeign investigationCessna T210N · Poptun, GuatemalaNTSB WAS06WA011Accident · 3 fatalForeign investigationCessna 208B · Vilanculos, MozambiqueNTSB NYC06WA166Accident · 1 fatalForeign investigationPiper PA-23-250 · Thirkleby, United KingdomNTSB DFW06WA170Accident · 1 fatalForeign investigationCessna U206 · Chiguao, Venezuela