Fatal 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 per year

19622026
Fatal NTSB investigations, 2022, Outside the U.S. per year, 1962–2026: 3,271 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026109

Latest cases

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'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 GAA23WA048Accident · 2 fatalClass 5 · ForeignChampion 7GCBC · Prijedori, Bosnia & HerzegovinaDec 31, 2022 · E-PDH · Substantial damageNTSB ENG23WA013Accident · 2 fatalClass 5 · ForeignBombardier CL600 · Venado, MexicoDec 30, 2022 · XB-SGV · DestroyedNTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceDec 28, 2022 · N229GC · DestroyedNTSB GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoDec 27, 2022 · N541DWNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaDec 26, 2022 · N600 · DestroyedNTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaDec 25, 2022 · VH-TFT · DestroyedNTSB GAA23WA046Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Brasnorte, BrazilDec 22, 2022 · PP-IRC · Substantial damageNTSB GAA23WA045Accident · 2 fatalClass 5 · ForeignBell 412EP · Ocean, MexicoDec 22, 2022 · XA-BNANTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaDec 14, 2022 · N5EQ · DestroyedNTSB GAA22WA311Accident · 1 fatalClass 5 · ForeignRobinson Helicopter R44 II · Kildare, IrelandDec 11, 2022 · N999RL · DestroyedNTSB GAA23WA035Accident · 1 fatalClass 5 · ForeignRotorway unk · Drummondville, CanadaNov 29, 2022 · unknown · DestroyedNTSB GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNov 27, 2022 · HL9678NTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNov 27, 2022 · RA- 07390 · DestroyedNTSB GAA23WA029Accident · 8 fatalClass 3 · ForeignPiper PA-31-350 · Medellin, ColombiaNov 21, 2022 · HK 5121 · DestroyedNTSB GAA23WA041Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Vera, BrazilNov 18, 2022 · PP-OBL · Substantial damageNTSB DCA23WA066Accident · 2 fatalClass 5 · ForeignAirbus A320 · Lima, PeruNov 18, 2022 · CC-BHB · Substantial damageNTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNov 14, 2022 · VH-LOS · Substantial damageNTSB ENG23WA004Accident · 7 fatalClass 5 · ForeignAgusta A109 · Apricena, ItalyNov 5, 2022 · I-PIKI · DestroyedNTSB 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 GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, NorwayNov 1, 2022 · LN-OBP · Substantial damageNTSB GAA23WA019Accident · 1 fatalClass 5 · ForeignCessna 150 · Mercedes, Buenos Aires, ArgentinaOct 23, 2022 · LV-IUG · DestroyedNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainOct 19, 2022 · EC-MXL · Substantial damageNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorOct 18, 2022 · HC-CLR · DestroyedNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaOct 18, 2022 · VT-RPN · DestroyedNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaOct 16, 2022 · HK-5342 · Substantial damageNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaOct 13, 2022 · HL1174 · Substantial damageNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaOct 6, 2022 · VH-PHP · DestroyedNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyOct 3, 2022 · F-HMDRNTSB 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 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 GAA22WA291Accident · 1 fatalClass 5 · ForeignChallenger II · Rideau-Ontario, CanadaSep 24, 2022 · C-IYDD · DestroyedNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaSep 23, 2022 · C-FFDA · 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 GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaSep 19, 2022 · VH-KHD · Substantial damageNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaSep 18, 2022 · C-GZLU · Substantial damageNTSB GAA22WA289Accident · 2 fatalClass 5 · ForeignEvektor EV97 · Sesso, Reggio Emilia, ItalySep 17, 2022 · I-8821 · 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 GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilSep 10, 2022 · PT-MES · 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 GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaAug 30, 2022 · V5-LMK · DestroyedNTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaAug 29, 2022 · VH-EHM · DestroyedNTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United KingdomAug 26, 2022 · G-BOXV · Destroyed