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 GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, AustraliaOct 3, 2022 · VH-WQA · Substantial damageNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyOct 3, 2022 · F-HMDRNTSB ENG23WA001IncidentClass 5 · ForeignBoeing 777 · Islamabad, PakistanOct 3, 2022 · HZ-AK18 · No damageNTSB DCA23WA116Incident · No injuriesClass 5 · ForeignBoeing 737 · Frankfurt, GermanyOct 3, 2022 · PH-HXB · No damageNTSB DCA23WA012Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Komatsu, Ishikawa, JapanOct 3, 2022 · JA07RK · No damageNTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaOct 2, 2022 · VH-RAS · DestroyedNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyOct 2, 2022 · I-EDUK · DestroyedNTSB ENG23WA017Accident · 3 fatalClass 5 · ForeignAirbus Helicopters MBB BK117 · Tabasco, MexicoOct 1, 2022 · XB-NWY · Substantial damageNTSB DCA23WA002Incident · No injuriesClass 5 · ForeignBoeing 777 · Manila, PhilippinesOct 1, 2022 · HZ-AK28 · Minor damageNTSB DCA23WA001Accident · No injuriesClass 5 · ForeignBoeing 737 · Nantes, FranceOct 1, 2022 · F-GZHA · Substantial damageNTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoSep 30, 2022 · XB-NGT · DestroyedNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaSep 29, 2022 · TG-UMG · DestroyedNTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonSep 28, 2022 · HL-7782 · 2 aircraft · Substantial damageNTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaSep 25, 2022 · HP-1539 CMP · Substantial damageNTSB GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaSep 24, 2022 · C-IYDD · DestroyedNTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceSep 24, 2022 · EC-NLSNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaSep 23, 2022 · C-FFDA · Substantial damageNTSB ENG22WA046OccurrenceClass 5 · ForeignATR ATR72 · Vicinity of Sárvár, HungarySep 23, 2022 · YU-ALY · No damageNTSB GAA22WA317Accident · No injuriesClass 4 · ForeignPiper PA38 · Jujuy, ArgentinaSep 22, 2022 · LV-OIB · Substantial damageNTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanSep 22, 2022 · JA3969 · Substantial damageNTSB GAA22WA300Accident · 1 fatalClass 5 · ForeignEmbraer EMB720 · Santa Cruz, BoliviaSep 21, 2022 · CP-2420 · DestroyedNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaSep 21, 2022 · N638JM · DestroyedNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruSep 20, 2022 · OB-2152 · DestroyedNTSB GAA22WA288Incident · No injuriesClass 5 · ForeignCessna 172 · Donji Proložac, CroatiaSep 19, 2022 · 9A-BDMNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaSep 19, 2022 · VH-KHD · Substantial damageNTSB ENG22WA045Incident · No injuriesClass 5 · ForeignATR ATR72 · Belfast, United KingdomSep 19, 2022 · EI-GPN · No damageNTSB DCA22WA205OccurrenceClass 5 · ForeignBeech 1900 · Brazzaville, Congo - KinshasaSep 19, 2022 · TN-AIQNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaSep 18, 2022 · C-GZLU · Substantial damageNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanySep 17, 2022 · N132MK · Substantial damageNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalySep 17, 2022 · I-8821 · Substantial damageNTSB GAA22WA293AccidentClass 5 · ForeignFairchild 227 · Queretaro, MexicoSep 15, 2022 · XA-UMW · Substantial damageNTSB GAA22WA284AccidentClass 5 · ForeignPiper PA 46-350P · Glisy, FranceSep 14, 2022 · N9190X · Substantial damageNTSB DCA22WA204IncidentClass 5 · ForeignBoeing 787 · Mumbai, IndiaSep 14, 2022 · VT-ANM · 2 aircraft · No damageNTSB GAA22WA295AccidentClass 5 · ForeignKodiak 100 · Rendsburg-Schachtholm, GermanySep 12, 2022 · 2-RUFF · Substantial damageNTSB GAA22WA280Accident · 1 fatalClass 4 · ForeignAir Tractor AT502 · Camrose, CanadaSep 12, 2022 · C-FJVL · Substantial damageNTSB GAA22WA282Accident · 1 fatalClass 5 · ForeignEurocopter EC120B · Bidor, MalaysiaSep 11, 2022 · N409HH · DestroyedNTSB GAA22WA279Accident · No injuriesClass 5 · ForeignCessna 207 · Oromomo, BoliviaSep 10, 2022 · CP-2504NTSB GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilSep 10, 2022 · PT-MES · Substantial damageNTSB GAA22WA281AccidentClass 5 · ForeignCessna A188B · Santa Helena de Goias, BrazilSep 9, 2022 · PT-WQN · Substantial damageNTSB GAA22WA273Accident · Minor injuriesClass 5 · ForeignCessna 172 · Barrancominas, ColombiaSep 9, 2022 · HK2573 · Substantial damageNTSB GAA22WA292AccidentClass 3 · ForeignAgusta A119 · Mount Cusna, ItalySep 6, 2022 · I-ELOP · Substantial damageNTSB GAA22WA268Accident · 4 fatalClass 5 · ForeignCessna 551 · Baltic Sea, LatviaSep 4, 2022 · OE-FGR · DestroyedNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileSep 4, 2022 · CC-DFY · Substantial damageNTSB DCA22WA206Incident · No injuriesClass 5 · ForeignBoeing 737 · Zurich, SwitzerlandSep 3, 2022 · TC-MKCNTSB DCA23WA014IncidentClass 5 · ForeignBoeing 777-222 · Schiphol, NetherlandsSep 2, 2022 · N787UA · No damageNTSB GAA22WA316Accident · Serious injuriesClass 5 · ForeignCessna 208 · Al Ajban, United Arab EmiratesAug 31, 2022 · N208JM · DestroyedNTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaAug 31, 2022 · VH-IWI · Minor damageNTSB GAA22WA267Accident · No injuriesClass 5 · ForeignBell 205 · La Ronge, SK, CanadaAug 31, 2022 · C-GZGK · Substantial damageNTSB GAA22WA296AccidentClass 4 · ForeignCessna 208B · Timika, IndonesiaAug 30, 2022 · PK-SNW · Substantial damageNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaAug 30, 2022 · V5-LMK · Destroyed