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.

NTSB GAA23WA034Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Ronselarestraat, BelgiumNov 16, 2022 · N821CC · Substantial damageNTSB GAA23WA028Incident · No injuriesClass 5 · ForeignBeech 200 · Oxfordshire, United KingdomNov 15, 2022 · GTXRNTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNov 14, 2022 · VH-LOS · Substantial damageNTSB DCA23WA081OccurrenceClass 5 · ForeignBoeing 737 · Sydney, AustraliaNov 14, 2022 · VH-IWQ · No damageNTSB DCA23WA062Occurrence · No injuriesClass 5 · ForeignDouglas DC3 · Balikpapan, IndonesiaNov 13, 2022 · C-FTGX · Minor damageNTSB DCA23WA064Occurrence · No injuriesClass 5 · ForeignBoeing 747-44AF · Almaty, KazakhstanNov 11, 2022 · N573UPNTSB DCA23WA049Incident · Minor injuriesClass 5 · ForeignSaab 340 · Canberra, AustraliaNov 10, 2022 · VH-VEQ · Minor damageNTSB DCA23WA048IncidentClass 5 · ForeignBoeing 737 · Winnipeg, CanadaNov 8, 2022 · C-GEKZ · No damageNTSB DCA23WA051IncidentClass 5 · ForeignBoeing 737 · Amman, JordanNov 6, 2022 · JY-JAD · Minor damageNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNov 5, 2022 · I-PIKI · DestroyedNTSB DCA23WA054IncidentClass 5 · ForeignSaab 340 · Whitemark, AustraliaNov 4, 2022 · VH-ZRC · Minor damageNTSB GAA23WA026AccidentClass 5 · ForeignBeech 33 · San Felipe, VenezuelaNov 3, 2022 · YV-2052 · Substantial damageNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNov 3, 2022 · CC-CXZ · Substantial damageNTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNov 3, 2022 · G-WINS · DestroyedNTSB DCA23WA044Incident · No injuriesClass 5 · ForeignBoeing 757-232 · LIberia, Costa RicaNov 2, 2022 · N6714Q · Minor damageNTSB GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, NorwayNov 1, 2022 · LN-OBP · Substantial damageNTSB GAA23WA027AccidentClass 5 · ForeignLeonardo AW109 · Gien, FranceNov 1, 2022 · G-RAYN · Substantial damageNTSB DCA23WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Kitchener, CanadaOct 30, 2022 · C-FLWJ · No damageNTSB GAA23WA023Accident · No injuriesClass 5 · ForeignCessna 182 · Igarassu, BrazilOct 29, 2022 · PT-DAB · Substantial damageNTSB ENG23WA002IncidentClass 5 · ForeignAirbus A320 · Delhi, IndiaOct 28, 2022 · VT-IFM · No damageNTSB DCA23WA037Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Buenos Aires, ArgentinaOct 28, 2022 · N765AN · Minor damageNTSB ENG23WA003IncidentClass 5 · ForeignBombardier BD-700-2A12 · Nanjing Lukou International Airport, Hong Kong SAR ChinaOct 27, 2022 · N899ST · Minor damageNTSB DCA23WA035Incident · No injuriesClass 4 · ForeignBoeing 737 · Shiraz, IranOct 27, 2022 · A6-FED · No damageNTSB DCA23WA047IncidentClass 5 · ForeignBoeing 777 · Batam, SingaporeOct 25, 2022 · 9V-SWH · No damageNTSB DCA23WA045IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaOct 25, 2022 · VH-VZA · No damageNTSB DCA23WA033IncidentClass 5 · ForeignSaab 340 · Sydney, AustraliaOct 24, 2022 · VH-VEQ · No damageNTSB DCA23WA032IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaOct 24, 2022 · VH-VUT · No damageNTSB GAA23WA019Accident · 1 fatalClass 5 · ForeignCessna 150 · Mercedes, Buenos Aires, ArgentinaOct 23, 2022 · LV-IUG · DestroyedNTSB DCA23WA029Accident · No injuriesClass 5 · ForeignAirbus A330 · Mactan-Cebu, PhilippinesOct 23, 2022 · HL7525 · Substantial damageNTSB GAA23WA013AccidentClass 5 · ForeignPiper PA30 · Quebec, CanadaOct 22, 2022 · C-FFOWNTSB DCA23WA041IncidentClass 5 · ForeignBoeing 737 · Agadir, MoroccoOct 22, 2022 · EI-EKJ · No damageNTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshOct 21, 2022 · S2-AJD · Minor damageNTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceOct 20, 2022 · F-HYOG · Minor damageNTSB GAA23WA018Accident · Serious injuriesClass 5 · ForeignBell 407 · São Paulo, BrazilOct 19, 2022 · PP-BDL · Substantial damageNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainOct 19, 2022 · EC-MXL · Substantial damageNTSB DCA23WA046IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaOct 19, 2022 · VH-YFT · No damageNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorOct 18, 2022 · HC-CLR · DestroyedNTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanOct 18, 2022 · JA80AP · No damageNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaOct 18, 2022 · VT-RPN · DestroyedNTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaOct 17, 2022 · VH-UDQ · DestroyedNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaOct 16, 2022 · HK-5342 · Substantial damageNTSB GAA23WA016Incident · No injuriesClass 5 · ForeignBell 206 · Kitakyushu, JapanOct 15, 2022 · JA6113 · No damageNTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaOct 14, 2022 · HK-3065 · No damageNTSB DCA23WA019IncidentClass 5 · ForeignBoeing 787-9 · Keflavík, IcelandOct 14, 2022 · N823AN · Minor damageNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaOct 13, 2022 · HL1174 · Substantial damageNTSB GAA23WA006Incident · No injuriesClass 5 · ForeignLearjet 45 · Sao Paulo, BrazilOct 9, 2022 · PP-MIX · Minor damageNTSB GAA23WA020Accident · No injuriesClass 5 · ForeignEurocopter AS350 · Los Jaramillos, PanamaOct 8, 2022 · HP-1806RK · Substantial damageNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaOct 6, 2022 · VH-PHP · DestroyedNTSB DCA23WA473IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeOct 6, 2022 · TC-JVN · Minor damageNTSB DCA23WA013IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeOct 6, 2022 · TC-JVN · Minor damage