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 GAA22WA264AccidentClass 5 · ForeignMooney M20J · Braunschweig, GermanyAug 30, 2022 · D-EKPC · Substantial damageNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaAug 29, 2022 · VH-EHM · DestroyedNTSB ENG22WA041IncidentClass 5 · ForeignATR ATR42 · Eberdeen, United KingdomAug 27, 2022 · G-LMRC · No damageNTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United KingdomAug 26, 2022 · G-BOXV · DestroyedNTSB ENG22WA044IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoAug 24, 2022 · XA-VAJ · No damageNTSB ENG22WA047OccurrenceClass 5 · ForeignAirbus Canada BD500 · Zurich, SwitzerlandAug 22, 2022 · HB-JBH · Minor damageNTSB GAA22WA260Accident · No injuriesClass 5 · ForeignCessna 172 · Malloca, SpainAug 21, 2022 · EC-ETC · Substantial damageNTSB DCA22WA187IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaAug 21, 2022 · YV3465 · No damageNTSB DCA22WA194AccidentClass 5 · ForeignUvify IFO · Darwin, AustraliaAug 18, 2022 · UNREGNTSB GAA22WA252Accident · No injuriesClass 5 · ForeignMooney M20E · Augsburg, GermanyAug 17, 2022 · F-BRHA · Substantial damageNTSB GAA22WA251Incident · No injuriesClass 5 · ForeignChristen Industries A1 · Menuma, JapanAug 15, 2022 · JA4083 · No damageNTSB ENG22WA042IncidentClass 5 · ForeignBoeing 737 · Gdansk, PolandAug 15, 2022 · SP-ENU · No damageNTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaAug 14, 2022 · C-FYSZ · Substantial damageNTSB DCA22WA184Incident · No injuriesClass 5 · ForeignBoeing 737 · Banjarmasin, IndonesiaAug 14, 2022 · PK-YGV · Minor damageNTSB GAA22WA250Accident · No injuriesClass 5 · ForeignCessna 172H · Assens, DenmarkAug 11, 2022 · OY-AHY · No damageNTSB GAA22WA261Accident · 1 fatalClass 5 · ForeignRobinson R22 · Albosaggia, ItalyAug 10, 2022 · I-JADE · Substantial damageNTSB ENG22WA040IncidentClass 5 · ForeignBombardier CL600 2B16 · Farnborough, United KingdomAug 10, 2022 · D-AAAY · No damageNTSB GAA22WA245Accident · 1 fatalClass 5 · ForeignPiper PA11 · Aeródromo Chañar Ladeado, Santa Fe, ArgentinaAug 9, 2022 · LV-NIG · Substantial damageNTSB GAA22WA243Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Bueanaventura Beach, PanamaAug 8, 2022 · HP-1685 · DestroyedNTSB GAA22WA248Accident · 1 fatalClass 5 · ForeignRobinson R44 · Lanzhou, ChinaAug 7, 2022 · B-70F2 · Substantial damageNTSB GAA22WA246Accident · No injuriesClass 5 · ForeignRobinson R22 · Lotus Vale, AustraliaAug 6, 2022 · VH-NKV · Substantial damageNTSB GAA22WA244Accident · No injuriesClass 5 · ForeignPiper PA-28-161 · Hampshire, United KingdomAug 6, 2022 · G-JASE · Substantial damageNTSB GAA22WA277Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Gloucestershire, United KingdomAug 4, 2022 · G-BCJN · Substantial damageNTSB GAA22WA269Accident · 2 fatalClass 5 · ForeignShort SC7 · Piotrków Trybunalski, PolandAug 3, 2022 · SP-SIP · DestroyedNTSB GAA22WA258Accident · Minor injuriesClass 5 · ForeignAir Tractor AT-802A · Cranbrook, CanadaAug 3, 2022 · C-FFQS · Substantial damageNTSB GAA22WA257Accident · 1 fatalClass 5 · ForeignAyres S2R · Morden Reginao, CanadaAug 3, 2022 · C-GOKD · DestroyedNTSB GAA22WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Sungai Pinji, MalaysiaAug 1, 2022 · 9M-BAA · DestroyedNTSB DCA22WA165AccidentClass 5 · Foreigndrone Viper Pro · Felthorpe, United KingdomJul 30, 2022 · UNREGNTSB DCA22WA164Accident · No injuriesClass 5 · ForeignBoeing 737-800 · Chiang Rai, ThailandJul 30, 2022 · HS-DBR · Substantial damageNTSB GAA22WA312Accident · No injuriesClass 5 · ForeignCessna 172P · Mukuchi - Sangar, RussiaJul 28, 2022 · RA-67332 · Substantial damageNTSB GAA22WA307Accident · 2 fatalClass 5 · ForeignRobinson R44 · Off shore, EcuadorJul 28, 2022 · HC-CLZ · Substantial damageNTSB GAA22WA313Accident · Serious injuriesClass 5 · ForeignPiper PA25 · Trinidad, ColombiaJul 26, 2022 · HK 1207 · DestroyedNTSB GAA22WA266Accident · Serious injuriesClass 5 · ForeignCessna 172 · Qualicum Beach, CanadaJul 25, 2022 · C-GGSN · Substantial damageNTSB ENG22WA035Incident · No injuriesClass 4 · ForeignAirbus A320-214 · Bogota, ColombiaJul 25, 2022 · N562AV · No damageNTSB GAA22WA315Incident · No injuriesClass 5 · ForeignCessna 560 · Salta, ArgentinaJul 24, 2022 · LV-KFB · Minor damageNTSB GAA22WA238Accident · 1 fatalClass 5 · ForeignCessna T210L · Puerto Plata, Dominican RepublicJul 23, 2022 · N210DE · Substantial damageNTSB GAA22WA239Accident · No injuriesClass 5 · ForeignCessna 152 · Baramati, IndiaJul 22, 2022 · VT-ALI · Substantial damageNTSB GAA22WA237Accident · No injuriesClass 5 · ForeignRobinson R44 · Buenos Aires, ArgentinaJul 22, 2022 · LV-WMB · DestroyedNTSB GAA22WA235Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Tiquisate, GuatemalaJul 20, 2022 · TG-OLM · Substantial damageNTSB GAA22WA254Accident · 1 fatalClass 5 · ForeignRobinson R44 · Loanda, BrazilJul 19, 2022 · PR-EGD · DestroyedNTSB GAA22WA253Accident · No injuriesClass 5 · ForeignEnstrom F28 · Nurnberg, GermanyJul 19, 2022 · G-ERDW · Substantial damageNTSB GAA22WA234Accident · No injuriesClass 5 · ForeignCessna F150 · Gödöllo, HungaryJul 19, 2022 · HA-BIF · Substantial damageNTSB GAA22WA231Accident · 2 fatalClass 5 · ForeignUnited Consultants UC-1 · Lake Siljan, SwedenJul 18, 2022 · N747HJNTSB DCA22WA154IncidentClass 5 · ForeignBoeing 737 · Wave Rock, AustraliaJul 18, 2022 · VH-VZO · No damageNTSB GAA22WA232Accident · 1 fatalClass 5 · ForeignChampion 7GCBC · Trois Riviere, Quebec, CanadaJul 17, 2022 · C-GOQZ · Substantial damageNTSB GAA22WA259Accident · No injuriesClass 5 · ForeignMXR Technologies MXS · Hajdúszoboszló, HungaryJul 16, 2022 · N540XX · Substantial damageNTSB GAA22WA241AccidentClass 5 · ForeignCessna 172RG · Aaachen, GermanyJul 16, 2022 · D-EWAE · 2 aircraft · Substantial damageNTSB GAA22WA233Accident · 3 fatalClass 4 · ForeignRobinson R44 · Kronotsky Nature Reserve, RussiaJul 16, 2022 · RA-07350 · DestroyedNTSB DCA22WA152Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Naha, JapanJul 16, 2022 · JA807X · No damageNTSB GAA22WA228Accident · 1 fatalClass 5 · ForeignAir Tractor AT-802F · Vila Nova de Foz Côa-Guarda, PortugalJul 15, 2022 · CS-EDY · Destroyed