Fatal NTSB investigations, 2022, 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\") = 2022
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") = 2022 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 GAA23WA048Accident · 2 fatalClass 5 · ForeignChampion 7GCBC · Prijedori, Bosnia & HerzegovinaNTSB ENG23WA013Accident · 2 fatalClass 5 · ForeignBombardier CL600 · Venado, MexicoNTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceNTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaNTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaNTSB GAA23WA046Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Brasnorte, BrazilNTSB GAA23WA045Accident · 2 fatalClass 5 · ForeignBell 412EP · Ocean, MexicoNTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaNTSB GAA22WA311Accident · 1 fatalClass 5 · ForeignRobinson Helicopter R44 II · Kildare, IrelandNTSB GAA23WA035Accident · 1 fatalClass 5 · ForeignRotorway unk · Drummondville, CanadaNTSB GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNTSB GAA23WA029Accident · 8 fatalClass 3 · ForeignPiper PA-31-350 · Medellin, ColombiaNTSB GAA23WA041Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Vera, BrazilNTSB DCA23WA066Accident · 2 fatalClass 5 · ForeignAirbus A320 · Lima, PeruNTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNTSB GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, NorwayNTSB GAA23WA019Accident · 1 fatalClass 5 · ForeignCessna 150 · Mercedes, Buenos Aires, ArgentinaNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyNTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyNTSB ENG23WA017Accident · 3 fatalClass 5 · ForeignAirbus Helicopters MBB BK117 · Tabasco, MexicoNTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaNTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaNTSB GAA22WA300Accident · 1 fatalClass 5 · ForeignEmbraer EMB720 · Santa Cruz, BoliviaNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalyNTSB GAA22WA280Accident · 1 fatalClass 4 · ForeignAir Tractor AT502 · Camrose, CanadaNTSB GAA22WA282Accident · 1 fatalClass 5 · ForeignEurocopter EC120B · Bidor, MalaysiaNTSB GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilNTSB GAA22WA268Accident · 4 fatalClass 5 · ForeignCessna 551 · Baltic Sea, LatviaNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaNTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United Kingdom