Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 LAX68O0294Accident · No injuriesClosedCessna 182 · San Pedro, MexicoDec 28, 1967 · N9354X · Substantial damage NTSB MIA68D0379Accident · Minor injuriesClosedLuscombe 8A · Grand Turk Is.Bwi, TokelauDec 26, 1967 · N1597K · Destroyed NTSB UNK68X0117Accident · No injuriesClosedBellanca 14-13 · Swift River, CanadaDec 24, 1967 · N86734 · Substantial damage NTSB UNK68X0115Incident · No injuriesClosedPiper PA-23 · Caborca, MexicoDec 21, 1967 · N5271Y · Minor damage NTSB UNK68X0114Accident · No injuriesClosedCessna 150 · Buckner B Okinawa, JADec 20, 1967 · N2290J · Substantial damage NTSB OAK68O0009Accident · Minor injuriesClosedBeech 10-2 · Phu Loi, VMDec 9, 1967 · N51259 · Substantial damage NTSB MIA68O0008Accident · No injuriesClosedGrumman G-21A · Tortola, U.S. Virgin IslandsDec 5, 1967 · N95467 · Substantial damage NTSB UNK68X0112Incident · No injuriesClosedCessna 320 · Navojoa, MexicoDec 1, 1967 · N3019T · Minor damage NTSB UNK68X0111Incident · No injuriesClosedPiper PA-24 · Navojoa, MexicoDec 1, 1967 · N7971P · Minor damage NTSB OAK68F0255Accident · Minor injuriesClosedCessna 150 · Kadena, JANov 25, 1967 · N4087J · Destroyed NTSB MIA68D0318Accident · No injuriesClosedPiper PA-30 · Hawks Nest, Burkina FasoNov 25, 1967 · N8035Y · Substantial damage NTSB UNK68X0110Incident · No injuriesClosedDouglas DC-8 · Munich, GeorgiaNov 19, 1967 · N809PA NTSB MIA68O0005Accident · 1 fatalClosedCessna 182 · Apartado, ColombiaNov 19, 1967 · N5506B · Destroyed NTSB UNK68X0108Accident · No injuriesClosedCessna 140 · Egelsbach, GeorgiaNov 16, 1967 · N2211V · Substantial damage NTSB MIA68D0425Accident · No injuriesClosedBeech 95-55 · Corn Is, NiueNov 2, 1967 · N1391Z · Substantial damage NTSB LAX68O0361Accident · No injuriesClosedMooney M20E · Mazatlan, MexicoOct 23, 1967 · N1237X · Substantial damage NTSB MIA68D0274Accident · No injuriesClosedLake LA-4 · Bimini, Burkina FasoOct 22, 1967 · N1113L · Destroyed NTSB LAX68O0296Accident · No injuriesClosedCessna 120 · Rosarita Bch, MexicoOct 21, 1967 · N2798N · Substantial damage NTSB MIA68D0324Accident · No injuriesClosedGrumman G-73 · Freeport, Burkina FasoOct 20, 1967 · N2970 · Substantial damage NTSB NYC68I0065Incident · No injuriesClosedBoeing 707 · Geneva, EswatiniOct 17, 1967 · N5771 · Minor damage NTSB UNK68X0105Accident · 1 fatalClosedGrumman TBM-3 · Agrinion, GreeceOct 16, 1967 · N68684 · Destroyed NTSB UNK68X0104Accident · Serious injuriesClosedPiper PA-23 · Shingle Pt, CanadaOct 13, 1967 · N93411 · Substantial damage NTSB UNK68X0103Accident · No injuriesClosedCessna 180 · Val D Or, CanadaOct 10, 1967 · N26564 · Substantial damage NTSB MIA68D0255Accident · No injuriesClosedAero Comdr 100 · Exhuma Is., Burkina FasoOct 9, 1967 · N2923T · Substantial damage NTSB UNK68X0102Accident · No injuriesClosedCessna 180 · Kluane Lake, CanadaOct 7, 1967 · N4743U · Substantial damage NTSB UNK67X0160Accident · Serious injuriesClosedPorter PC-6C · Ta Vieng, LaosSep 30, 1967 · N197X · Substantial damage NTSB OAK68A0031Accident · Serious injuriesClosedBoeing 707 · Ubon, ThailandSep 29, 1967 · N417PA · No damage NTSB LAX68D0247Accident · Serious injuriesClosedCessna 210 · Tres Marias, MexicoSep 24, 1967 · N7461E · Substantial damage NTSB MIA68F0273Accident · No injuriesClosedBeech D50 · Nassau, Burkina FasoSep 23, 1967 · N4311D · Substantial damage NTSB UNK67X0158Accident · 1 fatalClosedRepublic RC-3 · Mcneil Lake, CanadaSep 21, 1967 · N6316K · Substantial damage NTSB UNK67X0157Accident · No injuriesClosedBell 47G3B1 · Dhahran, Saudi ArabiaSep 20, 1967 · N1341X · Destroyed NTSB UNK67X0156Accident · 5 fatalClosedDehavilland DHC-2 · Whitewater Lk, CanadaSep 15, 1967 · N2118 · Substantial damage NTSB MIA68O0003Accident · No injuriesClosedCurtiss-Wrt C-46F · Kingston, JamaicaSep 13, 1967 · N1309V · Destroyed NTSB UNK67X0155Accident · No injuriesClosedBeech C-45 · Hon Quan, VMSep 12, 1967 · N9518Z · Substantial damage NTSB DCA68R0001Accident · Serious injuriesClosedBoeing 707 · Frankfurt, GeorgiaSep 9, 1967 · N724PA · Substantial damage NTSB UNK67X0154Accident · Serious injuriesClosedCuster CCW-5 · Gander, CanadaSep 8, 1967 · N6257C · Destroyed NTSB MIA68O0002Accident · No injuriesClosedBell 206A · Andros Tw, Burkina FasoSep 7, 1967 · N7827S · Substantial damage NTSB OAK68F0180Accident · No injuriesClosedStinson L-5 · Okuma, JASep 3, 1967 · N9881F · Substantial damage NTSB UNK67X0153Accident · No injuriesClosedCessna 182 · Kamloops Arpt, CanadaSep 1, 1967 · N5671B · Substantial damage NTSB ANC68O0001Accident · No injuriesClosedGrumman G-21A · Prince Rupert, CanadaAug 30, 1967 · N74588 · Substantial damage NTSB OAK68D0229Accident · No injuriesClosedBeech A55 · Long Tien, LaosAug 29, 1967 · N1313Z · Substantial damage NTSB MIA68O0001Accident · No injuriesClosedHiller UH12E4 · Santa Fe, RPAug 29, 1967 · N44B · Destroyed NTSB UNK67X0152Accident · 2 fatalClosedPiper PA-28 · Wms Lake, CanadaAug 28, 1967 · N4329J · Destroyed NTSB FTW68O0004Accident · 5 fatalClosedPiper PA-24 · Mexico City, MexicoAug 27, 1967 · N9066P · Destroyed NTSB FTW68O0003Accident · 4 fatalClosedPiper PA-24 · Mexico City, MexicoAug 27, 1967 · N7473P · Destroyed NTSB UNK67X0149Accident · 4 fatalClosedBeech C-45 · Danang, VMAug 21, 1967 · N9475Z · Destroyed NTSB UNK67X0147Accident · No injuriesClosedBell 47G-5 · Iraklion, GreeceAug 18, 1967 · N1395X · Substantial damage NTSB OAK68A0013Accident · Serious injuriesClosedBoeing 707 · Manila, RPAug 18, 1967 · N17322 · No damage NTSB NYC68A0027Accident · 1 fatalClosedAero Comdr 680-FL · Greenland Ice Cap, GreenlandAug 14, 1967 · N6362U · Destroyed NTSB OAK68D0234Accident · Serious injuriesClosedCurtis-Wrt C-46 · Phu Cum, LaosAug 13, 1967 · N9473Z · Destroyed