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, newest first
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'
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' 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 GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, AustraliaNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyNTSB ENG23WA001IncidentClass 5 · ForeignBoeing 777 · Islamabad, PakistanNTSB DCA23WA116Incident · No injuriesClass 5 · ForeignBoeing 737 · Frankfurt, GermanyNTSB DCA23WA012Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Komatsu, Ishikawa, JapanNTSB 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 DCA23WA002Incident · No injuriesClass 5 · ForeignBoeing 777 · Manila, PhilippinesNTSB DCA23WA001Accident · No injuriesClass 5 · ForeignBoeing 737 · Nantes, FranceNTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaNTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonNTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaNTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaNTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaNTSB ENG22WA046OccurrenceClass 5 · ForeignATR ATR72 · Vicinity of Sárvár, HungaryNTSB GAA22WA317Accident · No injuriesClass 4 · ForeignPiper PA38 · Jujuy, ArgentinaNTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanNTSB 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 GAA22WA288Incident · No injuriesClass 5 · ForeignCessna 172 · Donji Proložac, CroatiaNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaNTSB ENG22WA045Incident · No injuriesClass 5 · ForeignATR ATR72 · Belfast, United KingdomNTSB DCA22WA205OccurrenceClass 5 · ForeignBeech 1900 · Brazzaville, Congo - KinshasaNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanyNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalyNTSB GAA22WA293AccidentClass 5 · ForeignFairchild 227 · Queretaro, MexicoNTSB GAA22WA284AccidentClass 5 · ForeignPiper PA 46-350P · Glisy, FranceNTSB DCA22WA204IncidentClass 5 · ForeignBoeing 787 · Mumbai, IndiaNTSB GAA22WA295AccidentClass 5 · ForeignKodiak 100 · Rendsburg-Schachtholm, GermanyNTSB GAA22WA280Accident · 1 fatalClass 4 · ForeignAir Tractor AT502 · Camrose, CanadaNTSB GAA22WA282Accident · 1 fatalClass 5 · ForeignEurocopter EC120B · Bidor, MalaysiaNTSB GAA22WA279Accident · No injuriesClass 5 · ForeignCessna 207 · Oromomo, BoliviaNTSB GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilNTSB GAA22WA281AccidentClass 5 · ForeignCessna A188B · Santa Helena de Goias, BrazilNTSB GAA22WA273Accident · Minor injuriesClass 5 · ForeignCessna 172 · Barrancominas, ColombiaNTSB GAA22WA292AccidentClass 3 · ForeignAgusta A119 · Mount Cusna, ItalyNTSB GAA22WA268Accident · 4 fatalClass 5 · ForeignCessna 551 · Baltic Sea, LatviaNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileNTSB DCA22WA206Incident · No injuriesClass 5 · ForeignBoeing 737 · Zurich, SwitzerlandNTSB DCA23WA014IncidentClass 5 · ForeignBoeing 777-222 · Schiphol, NetherlandsNTSB GAA22WA316Accident · Serious injuriesClass 5 · ForeignCessna 208 · Al Ajban, United Arab EmiratesNTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaNTSB GAA22WA267Accident · No injuriesClass 5 · ForeignBell 205 · La Ronge, SK, CanadaNTSB GAA22WA296AccidentClass 4 · ForeignCessna 208B · Timika, IndonesiaNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, Namibia