Fatal NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 LAX08WA045Accident · 1 fatalForeign investigationRobinson R-44 · Westgate Bridge, AustraliaNTSB DFW08WA050Accident · 3 fatalForeign investigationCessna 172 · Boquete, PanamaNTSB NYC08WA065Accident · 1 fatalForeign investigationCirrus SR22 · Gurupi, BrazilNTSB DEN08WA042Accident · 1 fatalForeign investigationReims F172 M · Chevroux, FranceNTSB NYC08WA057Accident · 5 fatalForeign investigationBeech C90B · Kyiv, UkraineNTSB MIA08WA060Accident · 2 fatalForeign investigationCessna T210 · Guario, VenezuelaNTSB DFW08WA043Accident · 1 fatalForeign investigationCessna 210 · Arteaga, MexicoNTSB DCA08RA015Accident · 57 fatalForeign investigationMcDonnell Douglas MD-83 · Isparta, TürkiyeNTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNTSB LAX08WA131Accident · 4 fatalForeign investigationCessna 337G · Inverloch, AustraliaNTSB ANC08WA021Accident · 2 fatalForeign investigationCessna 404 · Nakatsugawa, JapanNTSB DEN08WA029Accident · 1 fatalForeign investigationPiper PA-32R · Merrenberg, FranceNTSB MIA08RA013Accident · 8 fatalForeign investigationLearjet 35A · Sao Paulo, BrazilNTSB MIA08WA020Accident · 3 fatalForeign investigationRobinson R-44 · San Paulo, BrazilNTSB DFW08WA034Accident · 2 fatalForeign investigationVans RV4 · Palencia, SpainNTSB ANC08WA016Accident · 2 fatalForeign investigationCessna 172 · Golden, CanadaNTSB ANC08WA013Accident · 2 fatalForeign investigationRobinson R-22B · Yao-City, JapanNTSB ANC08WA012Accident · 3 fatalForeign investigationPiper PA-46 · Fairmont, CanadaNTSB MIA08WA059Accident · 2 fatalForeign investigationCessna 182 · Araya, VenezuelaNTSB DCA08WA010Accident · 2 fatalForeign investigationBeech A36 · Windhoek, NamibiaNTSB ANC08WA014Accident · 1 fatalForeign investigationPiper PA-34 · Vancouver, CanadaNTSB DEN08WA018Accident · 2 fatalForeign investigationNorth American T-6G · Neuchatel, SwitzerlandNTSB NYC08WA014Accident · 1 fatalClass 5 · ForeignSullivan Lancair IV · Great Harbor, BahamasOn October 13, 2007, at 1036 eastern daylight time, an amateur-built Lancair IV, N95HS, was destroyed when it encountered turbulence over Bahamian waters near Great Harbor Cay, Berry Islands. The certificated commercial pilot was presumed to be fatally…NTSB ANC08WA015Accident · 3 fatalForeign investigationCessna 172 · Bamfield, CanadaNTSB NYC08WA013Accident · 7 fatalForeign investigationHawker-Beechcraft BE-200 · Bogota, ColombiaNTSB DCA08WA002Accident · 2 fatalForeign investigationGulfstream Aerospace Giib · Santo Domingo, VenezuelaNTSB DCA07WA064Accident · 2 fatalForeign investigationReims F406 · Entebbe, UgandaNTSB DEN07WA164Accident · 2 fatalForeign investigationPiper PA-28-181 · Airolo, SwitzerlandNTSB DCA07RA063Accident · 89 fatalForeign investigationBoeing MD-82 · Phuket, ThailandNTSB DCA08WA009Accident · 2 fatalForeign investigationRobinson R44 · Johannesburg, South AfricaNTSB DEN07WA159Accident · 2 fatalForeign investigationRobinson R-22 Beta · Buhl, GermanyNTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceNTSB MIA07WA135Accident · 2 fatalForeign investigationCessna U206G · Anaco, VenezuelaNTSB DFW07WA188Accident · 1 fatalForeign investigationPiper PA-25-235 · Tamoyo, Dominican RepublicNTSB ANC07WA091Accident · 3 fatalForeign investigationCirrus SR-22 · Spirit River, CanadaNTSB DFW08WA037Accident · 3 fatalForeign investigationCessna 206 · Zihuatanejo, MexicoNTSB DEN08WA039Accident · 20 fatalForeign investigationde Havilland DHC6-33 · Moorea, French PolynesiaNTSB CHI07WA257Accident · 4 fatalForeign investigationPiper PA-28-140 · Sandown, United KingdomNTSB WAS07WA013Accident · 1 fatalForeign investigationBell 412 EP · Eket, NigeriaNTSB CHI07WA256Accident · 4 fatalForeign investigationRobinson R44 · Lancastershire, United KingdomNTSB DFW07WA176Accident · 2 fatalForeign investigationPiper PA-38-112 · Madrid, SpainNTSB LAX07WA239Accident · 2 fatalForeign investigationRockwell 500S · Melbourne, VIC, AustraliaNTSB DEN07WA129Accident · 1 fatalForeign investigationStein Skybolt · Ardfert, IrelandNTSB NYC07WA180Accident · 5 fatalForeign investigationRobinson R44 · Izhevsk, RussiaNTSB DEN07WA125Accident · 1 fatalForeign investigationExpress Express 2000 ER · Basel, SwitzerlandNTSB DFW07WA166Accident · 1 fatalForeign investigationRobinson R22 Beta II · San Salvador, El SalvadorNTSB DFW07WA168Accident · 1 fatalForeign investigationBeech BE-36TC · Tlajomulco, MexicoNTSB DCA07RA059Accident · 199 fatalForeign investigationAirbus Industrie A320-233 · Sao Paulo, BrazilNTSB ENG07WA039Accident · 1 fatalForeign investigationAerospatiale 350B1 · Ballynacally, County Clare, Republic of Ireland, IrelandNTSB DFW07WA159Accident · 9 fatalForeign investigationNorth American T39A · Culiacan, Mexico