Fatal NTSB investigations, 2023, 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, 2023, 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\") = 2023
    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 GAA24WA062Accident · 1 fatalClass 5 · ForeignCessna A185 · Dorotea, ColombiaDec 30, 2023 · HK1658G · Substantial damageNTSB GAA24WA061Accident · 3 fatalClass 5 · ForeignAir Tractor AT502 · Carletonville, South AfricaDec 29, 2023 · ZS-XPC · 2 aircraft · Substantial damageNTSB DCA24WA149Accident · 1 fatalClass 5 · ForeignRobinson R22 · Tindal, AustraliaDec 7, 2023 · VH-DLD · Substantial damageNTSB GAA24WA052Accident · 5 fatalClass 3 · ForeignBell 412 · Arau, GuyanaDec 6, 2023 · 8R-AYA · DestroyedNTSB GAA24WA049Accident · 5 fatalClass 5 · ForeignPiper PA-32-260 · Terre-de-Haut, GuadeloupeDec 4, 2023 · N15902NTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayDec 2, 2023 · ZP-BDN · DestroyedNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNov 26, 2023 · LV-FQJ · Substantial damageNTSB GAA24WA043Accident · 4 fatalClass 5 · ForeignRockwell 112 · Kasberg, Grünau im Almtal, AustriaNov 25, 2023 · D-ELPO · Substantial damageNTSB GAA24WA039Accident · 1 fatalClass 5 · ForeignCessna 402B · Panama City, PanamaNov 24, 2023 · N76MD · DestroyedNTSB GAA24WA036Accident · 1 fatalClass 5 · ForeignCessna 172 · Dinslaken, GermanyNov 17, 2023 · D-EDJL · DestroyedNTSB GAA24WA034Accident · 3 fatalClass 5 · ForeignCessna 421C · Sunshine Coast, AustraliaNov 10, 2023 · VH-VPYNTSB GAA24WA032Accident · 2 fatalClass 5 · ForeignCessna 150 · Ponte de Sor, PortugalNov 10, 2023 · D-ERITNTSB GAA24WA028Accident · 3 fatalClass 5 · ForeignGulfstream 695A · Cloncurry, AustraliaNov 4, 2023 · VH-HPY · DestroyedNTSB GAA24WA025Accident · 4 fatalClass 5 · ForeignCirrus SR20 · St. Andrä im Lunga, AustriaNov 2, 2023 · D-ESFB · DestroyedNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionOct 31, 2023 · F-HLOU · DestroyedNTSB GAA24WA022Accident · 12 fatalClass 5 · ForeignCessna 208 · Rio Branco, BrazilOct 29, 2023 · PT-MEE · DestroyedNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaOct 26, 2023 · VH-KFT · DestroyedNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaOct 21, 2023 · ZS-JKE · Substantial damageNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damageNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaOct 19, 2023 · HK-2465G · Substantial damageNTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · DestroyedNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceOct 15, 2023 · F-HSLE · DestroyedNTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceOct 12, 2023 · F-GIKS · DestroyedNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyOct 10, 2023 · T7-HZM · DestroyedNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainOct 10, 2023 · CO493 · Substantial damageNTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoOct 9, 2023 · N6518P · Substantial damageNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaOct 8, 2023 · VH-RSBNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaOct 6, 2023 · C-GTYH · DestroyedNTSB GAA24WA006Accident · 4 fatalClass 4 · ForeignCirrus SR22 · Canberra, AustraliaOct 6, 2023 · VH-MSF · DestroyedNTSB GAA24WA004Accident · 3 fatalClass 5 · ForeignBeech 90 · Cuiaba, BrazilOct 4, 2023 · PS-JCO · DestroyedNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanySep 30, 2023 · D-EDDHNTSB GAA23WA282Accident · 5 fatalClass 5 · ForeignCessna 206G · Mashava, ZimbabweSep 29, 2023 · Z-CAM · Substantial damageNTSB GAA23WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Garmen village, BulgariaSep 22, 2023 · LZRAD · DestroyedNTSB GAA23WA259Accident · 1 fatalClass 5 · ForeignCessna 182 · Bamberg, GermanySep 17, 2023 · D-EOLP · Substantial damageNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaSep 10, 2023 · RA-05823 · Substantial damageNTSB GAA23WA253Accident · 2 fatalClass 5 · ForeignNorth American T28 · Székesfehérvár, HungarySep 10, 2023 · HA-RDM · DestroyedNTSB GAA23WA250Accident · 2 fatalClass 5 · ForeignBell 212 · Um Al Quwain, United Arab EmiratesSep 7, 2023 · A6-ALD · Substantial damageNTSB GAA23WA280Accident · 3 fatalClass 5 · ForeignCessna 172N · Mountains, IcelandAug 31, 2023 · TF-KLO · DestroyedNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayAug 29, 2023 · N · DestroyedNTSB GAA23WA243Accident · 2 fatalClass 5 · ForeignGulfstream 690C · Las Velas, VenezuelaAug 23, 2023 · YV2915 · DestroyedNTSB GAA23WA245Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · Enstone-, United KingdomAug 22, 2023 · G-CLHJ · DestroyedNTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomAug 21, 2023 · G-AYUH · DestroyedNTSB DCA23WA416Accident · 10 fatalClass 5 · ForeignRaytheon 390 · Elmina, MalaysiaAug 17, 2023 · N28JV · DestroyedNTSB GAA24WA051Accident · 2 fatalClass 5 · ForeignDiamond DA20-C1 · Cooking Lake, CanadaAug 11, 2023 · C-FRZGNTSB GAA23WA231Accident · 2 fatalClass 5 · ForeignHawker Beechcraft G58 · Vilhena, BrazilJul 29, 2023 · PR-ITE · Substantial damageNTSB GAA23WA230Accident · 2 fatalClass 5 · ForeignCessna 172 · Trujillo, PeruJul 28, 2023 · OB-1334 · DestroyedNTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoJul 28, 2023 · XB-VFJ · DestroyedNTSB GAA23WA211Accident · 6 fatalClass 5 · ForeignCessna 210 · San Luis Gaceno, ColombiaJul 19, 2023 · HK5138G · Substantial damageNTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaJul 17, 2023 · ZS-HLG · DestroyedNTSB GAA23WA207Accident · 1 fatalClass 5 · ForeignCessna 210 · Bradda Head, United KingdomJul 17, 2023 · G-TOTN · Substantial damage