Fatal NTSB investigations, 2023, 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\") = 2023
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") = 2023 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 GAA24WA062Accident · 1 fatalClass 5 · ForeignCessna A185 · Dorotea, ColombiaNTSB GAA24WA061Accident · 3 fatalClass 5 · ForeignAir Tractor AT502 · Carletonville, South AfricaNTSB DCA24WA149Accident · 1 fatalClass 5 · ForeignRobinson R22 · Tindal, AustraliaNTSB GAA24WA052Accident · 5 fatalClass 3 · ForeignBell 412 · Arau, GuyanaNTSB GAA24WA049Accident · 5 fatalClass 5 · ForeignPiper PA-32-260 · Terre-de-Haut, GuadeloupeNTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNTSB GAA24WA043Accident · 4 fatalClass 5 · ForeignRockwell 112 · Kasberg, Grünau im Almtal, AustriaNTSB GAA24WA039Accident · 1 fatalClass 5 · ForeignCessna 402B · Panama City, PanamaNTSB GAA24WA036Accident · 1 fatalClass 5 · ForeignCessna 172 · Dinslaken, GermanyNTSB GAA24WA034Accident · 3 fatalClass 5 · ForeignCessna 421C · Sunshine Coast, AustraliaNTSB GAA24WA032Accident · 2 fatalClass 5 · ForeignCessna 150 · Ponte de Sor, PortugalNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNTSB GAA24WA025Accident · 4 fatalClass 5 · ForeignCirrus SR20 · St. Andrä im Lunga, AustriaNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionNTSB GAA24WA022Accident · 12 fatalClass 5 · ForeignCessna 208 · Rio Branco, BrazilNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainNTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaNTSB GAA24WA006Accident · 4 fatalClass 4 · ForeignCirrus SR22 · Canberra, AustraliaNTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanyNTSB GAA23WA282Accident · 5 fatalClass 5 · ForeignCessna 206G · Mashava, ZimbabweNTSB GAA23WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Garmen village, BulgariaNTSB GAA23WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Bamberg, GermanyNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaNTSB GAA23WA253Accident · 2 fatalClass 5 · ForeignNorth American T28 · Székesfehérvár, HungaryNTSB GAA23WA250Accident · 2 fatalClass 5 · ForeignBell 212 · Um Al Quwain, United Arab EmiratesNTSB GAA23WA280Accident · 3 fatalClass 5 · ForeignCessna 172N · Mountains, IcelandNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayNTSB GAA23WA243Accident · 2 fatalClass 5 · ForeignGulfstream 690C · Las Velas, VenezuelaNTSB GAA23WA245Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · Enstone-, United KingdomNTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomNTSB DCA23WA416Accident · 10 fatalClass 5 · ForeignRaytheon 390 · Elmina, MalaysiaNTSB GAA24WA051Accident · 2 fatalClass 5 · ForeignDiamond DA20-C1 · Cooking Lake, CanadaNTSB GAA23WA231Accident · 2 fatalClass 5 · ForeignHawker Beechcraft G58 · Vilhena, BrazilNTSB GAA23WA230Accident · 2 fatalClass 5 · ForeignCessna 172 · Trujillo, PeruNTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoNTSB GAA23WA211Accident · 6 fatalClass 5 · ForeignCessna 210 · San Luis Gaceno, ColombiaNTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaNTSB GAA23WA207Accident · 1 fatalClass 5 · ForeignCessna 210 · Bradda Head, United Kingdom