Skip to content

NTSB investigations, 1972, Outside the U.S.

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1972, Outside the U.S. per year, 1962–2026: 9,098 cases
1962	9
1963	3
1964	108
1965	99
1966	106
1967	101
1968	64
1969	63
1970	70
1971	56
1972	79
1973	66
1974	65
1975	58
1976	16
1977	24
1978	36
1979	14
1980	5
1981	2
1982	5
1983	3
1984	7
1985	6
1986	8
1987	22
1988	41
1989	25
1990	30
1991	29
1992	36
1993	41
1994	42
1995	66
1996	61
1997	93
1998	134
1999	110
2000	159
2001	152
2002	134
2003	136
2004	154
2005	174
2006	181
2007	174
2008	174
2009	181
2010	227
2011	238
2012	259
2013	248
2014	219
2015	268
2016	319
2017	304
2018	337
2019	323
2020	257
2021	428
2022	429
2023	460
2024	492
2025	475
2026	393

Latest cases

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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.

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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB UNK73X0104Accident · 4 fatalClosedPiper PA-30 · Mrn Diablotin, DRDec 18, 1972 · N7769Y · Destroyed NTSB MIA73OKT40Accident · No injuriesClosedCessna 150 · Neuvo Empradr, CanadaDec 8, 1972 · N6602G · Substantial damage NTSB MIA73RKT36Accident · Serious injuriesClosedPiper PA-23 · Coakly Twn, Burkina FasoDec 5, 1972 · N112MW · Destroyed NTSB JAM73AB781Accident · Serious injuriesClosedCessna 337 · Trelawny, JamaicaDec 3, 1972 · N1319M · Substantial damage NTSB MIA73OKT41Accident · No injuriesClosedCessna 172 · Freeport, Burkina FasoNov 30, 1972 · N7213A · Substantial damage NTSB UNK73X0103Incident · No injuriesClosedBeech 65-80 · Ora, LibyaNov 28, 1972 · N2613 · Minor damage NTSB MIA73RM053Accident · 2 fatalClosedPiper PA-24 · Port Howe, Burkina FasoNov 17, 1972 · N8119P · Substantial damage NTSB MIA73RKT18Accident · No injuriesClosedCessna 180D · Nassau, Burkina FasoOct 4, 1972 · N6471X · Substantial damage NTSB OAK73DJY08Accident · Minor injuriesClosedBell 204B · Lat Khai, LaosSep 26, 1972 · N8513F · Substantial damage NTSB MIA73RKT17Accident · No injuriesClosedCessna 336 · Nassau, Burkina FasoSep 25, 1972 · N1792Z · Destroyed NTSB OAK73FJZ02Accident · No injuriesClosedCessna 150F · Yongju, St. Kitts & NevisSep 22, 1972 · N7849F · Substantial damage NTSB OAK73DJY07Accident · Serious injuriesClosedPorter PC6 C-H2 · Ban Kha, LaosSep 12, 1972 · N357F · Substantial damage NTSB UNK72X0116Accident · 1 fatalClosedLockheed 18 · Clarendon, JamaicaSep 11, 1972 · N1040E · Destroyed NTSB MIA73RM030Accident · 5 fatalClosedPiper PA-23 · Georgetown, Burkina FasoSep 11, 1972 · N14265 · Destroyed NTSB LAX73DUJ28Accident · Minor injuriesClosedCessna 182 · Sn Frn Bajaca, MexicoSep 3, 1972 · N9302G · Destroyed NTSB UNK72X0114Accident · Minor injuriesClosedHoward DGA-15 · Anhien Lk Bc, CanadaAug 26, 1972 · N138J · Destroyed NTSB MIA73OM021Incident · No injuriesClosedPiper PA-23 · Virgin Gorda, U.S. Virgin IslandsAug 21, 1972 · N4444P · Minor damage NTSB MIA73OKA03Accident · Minor injuriesClosedBeech A24R · Codringtn Vil, Ascension IslandAug 20, 1972 · N8038R · Substantial damage NTSB UNK72X0113Accident · 5 fatalClosedBeech D35 · Bevans Town, Burkina FasoAug 18, 1972 · N2070D · Destroyed NTSB EU173DYZ01Accident · Minor injuriesClosedConsolidate 28-5AC · Monte Carlo, MongoliaAug 15, 1972 · N190 · Substantial damage NTSB MIA73OKT13Accident · No injuriesClosedHelio Acft H-295 · S.Salvador, Burkina FasoAug 9, 1972 · N7899 · Substantial damage NTSB OAK73DJY04Accident · Serious injuriesClosedLockheed 18 · Cebu City, RPAug 8, 1972 · N666P · Substantial damage NTSB MIA73OKA02Accident · Serious injuriesClosedBeech D18S · St Maarten, NTAug 4, 1972 · N103P · Destroyed NTSB OAK73FJZ01Accident · No injuriesClosedCessna 150 · Misawa, JAAug 2, 1972 · N6937G · Substantial damage NTSB OAK73DJY03Accident · No injuriesClosedGrumman G44 · Majuro, MontserratAug 1, 1972 · N4452 · Destroyed NTSB UNK72X0112Accident · 3 fatalClosedCessna 170 · Iron Crk, CanadaJul 27, 1972 · N4059V · Destroyed NTSB MIA73RM013Accident · 5 fatalClosedCessna 310C · Normans Cay, Burkina FasoJul 27, 1972 · N2121T · Destroyed NTSB OAK73DJY01Accident · 3 fatalClosedDehavilland DHC-6 · Tha Tam Blng, LaosJul 25, 1972 · N5662 · Destroyed NTSB OAK73DJY02Accident · No injuriesClosedBell 204 · Can Tho, VMJul 24, 1972 · N1304X · Substantial damage NTSB MIA73OM063Accident · No injuriesClosedDouglas DC-3 · Pivijay, ColombiaJul 21, 1972 · N39393 · Substantial damage NTSB OAK73DJY06Accident · 1 fatalClosedCessna 172 · Savannakhet, LaosJul 18, 1972 · 0067 · 2 aircraft · Destroyed NTSB UNK72X0110Accident · No injuriesClosedHughes 269 · Eucott Bay, CanadaJul 10, 1972 · N9622F · Substantial damage NTSB MIA73OKT07Accident · Minor injuriesClosedPiper PA-28 · Spanish Wells, Burkina FasoJul 10, 1972 · N9091J · Substantial damage NTSB LAX73OL001Accident · No injuriesClosedCessna 175 · San Felipe, MexicoJul 5, 1972 · N7601M · Substantial damage NTSB OAK73DJY09Accident · No injuriesClosedDouglas A-26B · Manila, RPJul 4, 1972 · N4000K · Substantial damage NTSB MIA73OKT04Accident · Minor injuriesClosedBellanca 17-30 · Nassau, Burkina FasoJul 1, 1972 · N6680V · Substantial damage NTSB CAN73A0904Accident · 2 fatalClosedPiper PA28-R · Dorchester Ont, MexicoJun 30, 1972 · N7649J · Destroyed NTSB OAK72DJY16Accident · No injuriesClosedHughes 369HS · Long Tieng, LaosJun 27, 1972 · N354X · Substantial damage NTSB NYC72IN165Incident · No injuriesClosedBoeing 747 · Madrid, SPJun 26, 1972 · N93103 · Minor damage NTSB UNK72X0109Accident · Serious injuriesClosedBeech 50 · Elk Is, CanadaJun 24, 1972 · N3674B · Destroyed NTSB LAX72DUK11Accident · Minor injuriesClosedBeech 35 · San Carlos, MexicoJun 15, 1972 · N570D · Substantial damage NTSB CAN73P0902Accident · No injuriesClosedPiper PA-28 · Tsacha Lk, CanadaJun 11, 1972 · N4521T · Substantial damage NTSB LAX73OL011Accident · No injuriesClosedAero Comdr 100 · Villa Ahumada, MexicoJun 9, 1972 · N3875X · Substantial damage NTSB OAK73O0001Accident · No injuriesClosedCessna 150 · Kadena Ab, JAMay 28, 1972 · N2491J · Minor damage NTSB MIA72OKA16Accident · No injuriesClosedCessna 140 · Trinidad, WNMay 27, 1972 · N1850V · Substantial damage NTSB OAK72DJY19Accident · Minor injuriesClosedBell 204B · Bouam Long, LaosMay 25, 1972 · N8535F · Substantial damage NTSB FTW72DRG85Accident · 2 fatalClosedBellanca 7ECA · San Frncsqita, MexicoMay 14, 1972 · N11671 · Substantial damage NTSB FTW72OF075Accident · Serious injuriesClosedDouglas DC-8 · Santiago, Côte d’IvoireMay 7, 1972 · N1807 · No damage NTSB OAK72DJY06Accident · 4 fatalClosedPilatus PC6CH2 · Nyot Mo, LaosApr 24, 1972 · N391R · Destroyed NTSB UNK72X0108Accident · No injuriesClosedCessna 172 · Ptd.Bight, JamaicaApr 20, 1972 · N8065B · Destroyed