Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPDec 22, 1973 · N21963 · Destroyed NTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoDec 20, 1973 · N39385 · Destroyed NTSB UNK74X0101Incident · 31 fatalClosedBoeing 707 · Rome, ItalyDec 17, 1973 · N407PA · Destroyed NTSB FTW74DRD20Accident · 2 fatalClosedCessna 182 · Mexico City, MexicoDec 7, 1973 · N869TX · Substantial damage NTSB FTW74DRJ26Accident · No injuriesClosedPiper PA-23 · Vera Cruz, MexicoDec 5, 1973 · N14348 · Substantial damage NTSB MIA740KT47Accident · No injuriesClosedCessna 402 · San Vicente, MexicoNov 29, 1973 · N111RN · Destroyed NTSB FTW74DRG40Accident · Serious injuriesClosedPiper PA-28 · Mexico City, MexicoNov 29, 1973 · N5872U · Destroyed NTSB MIA74OKT42Accident · No injuriesClosedPiper PA-23 · G Bahama I, Burkina FasoNov 27, 1973 · N5ML · Substantial damage NTSB FTW74DRG38Accident · No injuriesClosedCessna 182 · San Luis Ptsi, MexicoNov 26, 1973 · N3352Y · Substantial damage NTSB UNK74X0100Accident · 1 fatalClosedBeech D55 · Honiara, BPNov 25, 1973 · N7499N · Destroyed NTSB OAK74DJY07Accident · Minor injuriesClosedPilatus PC6CH2 · Ling Tieng, LaosNov 25, 1973 · N5304F · Destroyed NTSB LAX74OL078Accident · No injuriesClosedPiper PA-20 · La Salina, MexicoNov 21, 1973 · N1521A · Substantial damage NTSB LAX74OL040Accident · 5 fatalClosedBeech 95-B55 · R.Buena Vista, MexicoNov 21, 1973 · N8842M · Destroyed NTSB OAK74OJY06Accident · Minor injuriesClosedPilatus PC6CH2 · Lam Son, VMOct 30, 1973 · N392R · Substantial damage NTSB LAX74OL039Accident · No injuriesClosedAero Comdr 500-A · Las Cruces, MexicoOct 27, 1973 · N9392R · Substantial damage NTSB MIA74OKT35Accident · No injuriesClosedCessna 150G · Mores Is, Burkina FasoOct 26, 1973 · N3234X · Substantial damage NTSB LAX74OL033Accident · 9 fatalClosedSikorsky S-62A · Requena, PeruOct 11, 1973 · N316Y · Substantial damage NTSB APC74IF053Accident · No injuriesClosedDouglas DC-8 · Tokyo, JAOct 8, 1973 · N794FT · No damage NTSB MIA74DKT22Accident · No injuriesClosedAero Comdr 500S · Andros Isl, Burkina FasoSep 26, 1973 · N69NP · Destroyed NTSB UNK73X0124Accident · Minor injuriesClosedBeech B95 · San Inez, MexicoSep 24, 1973 · N9915R · Substantial damage NTSB OAK74DJY03Accident · No injuriesClosedBeech C-45H · Phan Rang, VMSep 20, 1973 · N9157Z · Substantial damage NTSB MIA74OKA05Accident · No injuriesClosedBrittnorman BN-2A · Santo Domingo, DRSep 17, 1973 · N869JA · Substantial damage NTSB MIA74DKT40Accident · No injuriesClosedBeech D18S · Freeport, Burkina FasoSep 15, 1973 · N436B · Substantial damage NTSB UNK73X0123Accident · No injuriesClosedLockheed 18 · Santa Lucia, MexicoSep 14, 1973 · N211W · Destroyed NTSB MIA74OKT18Accident · No injuriesClosedBeech D18S · Middle Caicos, TokelauSep 11, 1973 · N80351 · Destroyed NTSB LAX74OL034Accident · Serious injuriesClosedPiper PA-28 · Buena Vista, MexicoSep 10, 1973 · N8761W · Substantial damage NTSB OAK74DJY05Accident · No injuriesClosedCessna 172L · Cubi Point Nas, RPSep 7, 1973 · N7199Q · Substantial damage NTSB OAK74DJY04Accident · No injuriesClosedBell 204B · Ramasun, ThailandSep 7, 1973 · N8535F · Substantial damage NTSB FTW74DPA06Accident · Serious injuriesClosedCessna 210 · Las Delicias, MexicoSep 5, 1973 · N3910Y · Substantial damage NTSB MIA74AM041Accident · Serious injuriesClosedLockheed L-1011 · Grnd Turk Is, Burkina FasoAug 25, 1973 · N318EA · No damage NTSB MIA74OKT63Accident · 10 fatalClosedNorman BN-2A · Don Don, HAAug 15, 1973 · N38JA · Destroyed NTSB UNK73X0120Accident · Serious injuriesClosedCessna 182 · Malaga, SPAug 9, 1973 · N3957D · Substantial damage NTSB MIA74DKT06Accident · Serious injuriesClosedCessna 150 · France Fld, St. Pierre & MiquelonAug 1, 1973 · N6473G · Substantial damage NTSB UNK73X0119Accident · No injuriesClosedBellanca 17-30A · Montego Bay, JamaicaJul 28, 1973 · N39818 · Substantial damage NTSB DCA74RZ002Accident · 78 fatalClosedBoeing 707 · Papeete, FPJul 22, 1973 · N417PA · Destroyed NTSB UNK73X0117Accident · Minor injuriesClosedDehavilland DHC-6 · Dhahran, Saudi ArabiaJul 16, 1973 · N660MA · Substantial damage NTSB MIA74RM002Accident · 2 fatalClosedPiper PA-23 · Nassau, Burkina FasoJul 9, 1973 · N43BB · Destroyed NTSB UNK73X0116Accident · No injuriesClosedPiper PA-24 · Riske Crk, CanadaJun 30, 1973 · N6330P · Substantial damage NTSB UNK73X0115Accident · No injuriesClosedCessna 210 · Falmouth, JamaicaJun 21, 1973 · N5927F · Substantial damage NTSB MIA73OM112Accident · No injuriesClosedCessna 172 · Hope Bay, Burkina FasoJun 18, 1973 · N5366R · No damage NTSB UNK73X0114Accident · Minor injuriesClosedDouglas DC3 · Tamnrsset, Antigua & BarbudaJun 17, 1973 · N7119 · Substantial damage NTSB FTW73DQG43Accident · 2 fatalClosedMitsubishi MU-2B · Cedillos C, MexicoJun 13, 1973 · N882Q · Destroyed NTSB MIA73RM108Accident · 1 fatalClosedPiper PA-23 · Staniel Cay, Burkina FasoJun 11, 1973 · N5218Y · Destroyed NTSB OAK73DJY12Accident · No injuriesClosedCessna 150 · Plaridel, RPMay 28, 1973 · N22309 · Destroyed NTSB OAK73DVD39Accident · No injuriesClosedPiper PA-32 · La Paz, MexicoMay 26, 1973 · N3852W · Substantial damage NTSB FTW73DRG82Accident · No injuriesClosedLockheed 18 · Sota L.Marina, MexicoMay 19, 1973 · N90LV · Substantial damage NTSB FTW73DQD18Accident · Serious injuriesClosedCessna T210F · El Fuerte, MexicoMay 8, 1973 · N6136R · Destroyed NTSB MIA73RM100Accident · 2 fatalClosedLockheed L18 · Chub Cay, Burkina FasoMay 6, 1973 · N620S · Destroyed NTSB UNK73X0113Accident · No injuriesClosedPiper PA-31 · Chihuahua Cty, MexicoMay 3, 1973 · N3105E · Destroyed NTSB LAX74OL025Accident · 3 fatalClosedCessna 175 · San L Gonzaga, MexicoApr 30, 1973 · N7059M · Destroyed