Fatal NTSB investigations, 1972, 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, 1972, 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\") = 1972
    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 UNK73X0104Accident · 4 fatalClosedPiper PA-30 · Mrn Diablotin, DRDec 18, 1972 · N7769Y · DestroyedNTSB MIA73RM053Accident · 2 fatalClosedPiper PA-24 · Port Howe, Burkina FasoNov 17, 1972 · N8119P · Substantial damageNTSB UNK72X0116Accident · 1 fatalClosedLockheed 18 · Clarendon, JamaicaSep 11, 1972 · N1040E · DestroyedNTSB MIA73RM030Accident · 5 fatalClosedPiper PA-23 · Georgetown, Burkina FasoSep 11, 1972 · N14265 · DestroyedNTSB UNK72X0113Accident · 5 fatalClosedBeech D35 · Bevans Town, Burkina FasoAug 18, 1972 · N2070D · DestroyedNTSB UNK72X0112Accident · 3 fatalClosedCessna 170 · Iron Crk, CanadaJul 27, 1972 · N4059V · DestroyedNTSB MIA73RM013Accident · 5 fatalClosedCessna 310C · Normans Cay, Burkina FasoJul 27, 1972 · N2121T · DestroyedNTSB OAK73DJY01Accident · 3 fatalClosedDehavilland DHC-6 · Tha Tam Blng, LaosJul 25, 1972 · N5662 · DestroyedNTSB OAK73DJY06Accident · 1 fatalClosedCessna 172 · Savannakhet, LaosJul 18, 1972 · 0067 · 2 aircraft · DestroyedNTSB CAN73A0904Accident · 2 fatalClosedPiper PA28-R · Dorchester Ont, MexicoJun 30, 1972 · N7649J · DestroyedNTSB FTW72DRG85Accident · 2 fatalClosedBellanca 7ECA · San Frncsqita, MexicoMay 14, 1972 · N11671 · Substantial damageNTSB OAK72DJY06Accident · 4 fatalClosedPilatus PC6CH2 · Nyot Mo, LaosApr 24, 1972 · N391R · DestroyedNTSB OAK72DJY04Accident · 1 fatalClosedPilatus PC6CH2 · Ban Xieng, LaosApr 8, 1972 · N152L · DestroyedNTSB FTW72DRG63Accident · 1 fatalClosedCessna 210 · Novillo Cueva, MexicoApr 6, 1972 · N9438X · Substantial damageNTSB OAK72FJY14Accident · 2 fatalClosedBeech 23 · Castillejos, RPMar 10, 1972 · N3786 · DestroyedNTSB BAH72ATC25Accident · 2 fatalClosedCessna 207 · San Salvdor, Burkina FasoMar 4, 1972 · N1607U · DestroyedNTSB UNK72X0104Accident · 1 fatalClosedCessna 182 · Kibati, TanzaniaJan 26, 1972 · N6251A · Substantial damage