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 GAA23WA034Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Ronselarestraat, BelgiumNTSB GAA23WA028Incident · No injuriesClass 5 · ForeignBeech 200 · Oxfordshire, United KingdomNTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNTSB DCA23WA081OccurrenceClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB DCA23WA062Occurrence · No injuriesClass 5 · ForeignDouglas DC3 · Balikpapan, IndonesiaNTSB DCA23WA064Occurrence · No injuriesClass 5 · ForeignBoeing 747-44AF · Almaty, KazakhstanNTSB DCA23WA049Incident · Minor injuriesClass 5 · ForeignSaab 340 · Canberra, AustraliaNTSB DCA23WA048IncidentClass 5 · ForeignBoeing 737 · Winnipeg, CanadaNTSB DCA23WA051IncidentClass 5 · ForeignBoeing 737 · Amman, JordanNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNTSB DCA23WA054IncidentClass 5 · ForeignSaab 340 · Whitemark, AustraliaNTSB GAA23WA026AccidentClass 5 · ForeignBeech 33 · San Felipe, VenezuelaNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNTSB DCA23WA044Incident · No injuriesClass 5 · ForeignBoeing 757-232 · LIberia, Costa RicaNTSB GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, NorwayNTSB GAA23WA027AccidentClass 5 · ForeignLeonardo AW109 · Gien, FranceNTSB DCA23WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Kitchener, CanadaNTSB GAA23WA023Accident · No injuriesClass 5 · ForeignCessna 182 · Igarassu, BrazilNTSB ENG23WA002IncidentClass 5 · ForeignAirbus A320 · Delhi, IndiaNTSB DCA23WA037Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Buenos Aires, ArgentinaNTSB ENG23WA003IncidentClass 5 · ForeignBombardier BD-700-2A12 · Nanjing Lukou International Airport, Hong Kong SAR ChinaNTSB DCA23WA035Incident · No injuriesClass 4 · ForeignBoeing 737 · Shiraz, IranNTSB DCA23WA047IncidentClass 5 · ForeignBoeing 777 · Batam, SingaporeNTSB DCA23WA045IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB DCA23WA033IncidentClass 5 · ForeignSaab 340 · Sydney, AustraliaNTSB DCA23WA032IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB GAA23WA019Accident · 1 fatalClass 5 · ForeignCessna 150 · Mercedes, Buenos Aires, ArgentinaNTSB DCA23WA029Accident · No injuriesClass 5 · ForeignAirbus A330 · Mactan-Cebu, PhilippinesNTSB GAA23WA013AccidentClass 5 · ForeignPiper PA30 · Quebec, CanadaNTSB DCA23WA041IncidentClass 5 · ForeignBoeing 737 · Agadir, MoroccoNTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshNTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceNTSB GAA23WA018Accident · Serious injuriesClass 5 · ForeignBell 407 · São Paulo, BrazilNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainNTSB DCA23WA046IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorNTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaNTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaNTSB GAA23WA016Incident · No injuriesClass 5 · ForeignBell 206 · Kitakyushu, JapanNTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaNTSB DCA23WA019IncidentClass 5 · ForeignBoeing 787-9 · Keflavík, IcelandNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaNTSB GAA23WA006Incident · No injuriesClass 5 · ForeignLearjet 45 · Sao Paulo, BrazilNTSB GAA23WA020Accident · No injuriesClass 5 · ForeignEurocopter AS350 · Los Jaramillos, PanamaNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaNTSB DCA23WA473IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeNTSB DCA23WA013IncidentClass 5 · ForeignBoeing 737 · Hatay, Türkiye