Skip to content

Fatal NTSB investigations, 1967

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

Fatal NTSB investigations, 1967 per year, 1962–2026: 30,836 cases
1962	11
1963	13
1964	539
1965	560
1966	581
1967	625
1968	718
1969	655
1970	643
1971	664
1972	697
1973	731
1974	727
1975	692
1976	707
1977	713
1978	800
1979	691
1980	672
1981	705
1982	638
1983	651
1984	617
1985	555
1986	507
1987	496
1988	502
1989	484
1990	499
1991	482
1992	494
1993	437
1994	445
1995	456
1996	421
1997	402
1998	422
1999	404
2000	443
2001	412
2002	417
2003	440
2004	418
2005	428
2006	408
2007	387
2008	373
2009	359
2010	363
2011	398
2012	389
2013	344
2014	360
2015	365
2016	341
2017	338
2018	361
2019	381
2020	294
2021	321
2022	330
2023	295
2024	292
2025	275
2026	248

Where

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."highestInjuryLevel" = 'Fatal' 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.\"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.

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."highestInjuryLevel" = 'Fatal'
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 FTW68A0066Accident · 6 fatalClosedBeech 95-B55 · New Orleans La, LADec 31, 1967 · N6139V · Destroyed NTSB DEN68A0030Accident · 1 fatalClosedCessna 182 · Idaho Spring, CODec 31, 1967 · N681JF · Destroyed NTSB OAK68A0052Accident · 2 fatalClosedCessna 170B · Hawthorne, NVDec 30, 1967 · N3114B · Destroyed NTSB DEN68A0028Accident · 1 fatalClosedCessna 320A · Kanosh, UTDec 30, 1967 · N3047R · Destroyed NTSB CHI68A0058Accident · 2 fatalClosedNavion F · Murphysboro, ILDec 29, 1967 · N91461 · Destroyed NTSB NYC68A0084Accident · 3 fatalClosedPiper PA-31 · Muncy, PADec 28, 1967 · N9040Y · Destroyed NTSB FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXDec 27, 1967 · N7097P · Destroyed NTSB CHI68A0057Accident · 1 fatalClosedCessna 172 · Millersburg, OHDec 25, 1967 · N8160X · Destroyed NTSB MKC68A0040Accident · 1 fatalClosedLuscombe 8A · Lyons, KSDec 24, 1967 · N71543 · Destroyed NTSB MKC68A0039Accident · 1 fatalClosedCessna 150D · Hillsboro, KSDec 24, 1967 · N4227U · Destroyed NTSB LAX68A0063Accident · 1 fatalClosedGlendening Stits · Corona, CADec 24, 1967 · N6050C · Destroyed NTSB UNK68X0116Accident · 4 fatalClosedCessna 210 · Naucalpan, MexicoDec 22, 1967 · N3701Y · Destroyed NTSB MIA68A0058Accident · 2 fatalClosedCessna 170B · Warm Springs, GADec 22, 1967 · N1953C · Destroyed NTSB DIA68A0042Accident · 2 fatalClosedPiper PA-24 · Robbinsville, NCDec 22, 1967 · N6238P · Destroyed NTSB CHI68A0056Accident · 3 fatalClosedMooney M20F · Knox, INDec 22, 1967 · N2779W · Destroyed NTSB NYC68A0082Accident · 2 fatalClosedBell 47J-2 · New York City, NYDec 21, 1967 · N73251 · Destroyed NTSB DEN68A0027Accident · 2 fatalClosedDouglas DC-3C · Denver, CODec 21, 1967 · N65276 · Destroyed NTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXDec 19, 1967 · N6885P · Destroyed NTSB DIA68A0026Accident · 3 fatalClosedPiper PA-28 · Monroe, NCDec 18, 1967 · N7197W · Destroyed NTSB NYC68A0080Accident · 2 fatalClosedPiper PA-28 · Stowe, PADec 17, 1967 · N8883W · Destroyed NTSB NYC68A0079Accident · 4 fatalClosedPiper PA-28 · Bridgeport, CTDec 16, 1967 · N9736J · Destroyed NTSB NYC68F0330Accident · 1 fatalClosedBeech T-34 · Butler, PADec 15, 1967 · N9182R · Destroyed NTSB DEN68A0026Accident · 2 fatalClosedPiper PA-32 · Corona, NMDec 15, 1967 · N3408W · Destroyed NTSB OAK68A0050Accident · 2 fatalClosedBell 47J-2A · Hanalei, HIDec 13, 1967 · N8501F · Destroyed NTSB MIA68A0054Accident · 2 fatalClosedAero Comdr 560E · Kingshill, VIDec 12, 1967 · N8448C · Destroyed NTSB NYC68A0076Accident · 2 fatalClosedAero Comdr 560E · Seven Springs, PADec 11, 1967 · N6231D · Destroyed NTSB LAX68A0060Accident · 2 fatalClosedChampion 7GCAA · Lucerne Vly, CADec 10, 1967 · N9683S · Destroyed NTSB CHI68A0053Accident · 7 fatalClosedBeech H18 · Madison, WIDec 10, 1967 · N390R · Destroyed NTSB FTW68A0059Accident · 1 fatalClosedPiper PA-24 · Black Oak, ARDec 9, 1967 · N7657P · Destroyed NTSB CHI68A0052Accident · 2 fatalClosedHughes 269B · Evansville, INDec 9, 1967 · N9454F · Destroyed NTSB FTW68A0062Accident · 2 fatalClosedPiper PA-24 · Shawnee, OKDec 8, 1967 · N6519P · Destroyed NTSB FTW68F0381Accident · 1 fatalClosedBeech V-35 · Athens, LADec 7, 1967 · N348E · Destroyed NTSB CHI68F0499Accident · 1 fatalClosedPiper PA-30 · Lowell, MIDec 6, 1967 · N8071Y · Destroyed NTSB DIA68A0025Accident · 2 fatalClosedCessna 310F · Norfolk, VADec 5, 1967 · N6704X · Destroyed NTSB OAK68A0048Accident · 1 fatalClosedPiper PA-23 · Reno, NVDec 4, 1967 · N5853Y · Destroyed NTSB CHI68F0502Accident · 1 fatalClosedBeech J35 · Chicago, ILDec 4, 1967 · N8240D · Destroyed NTSB MKC68A0036Accident · 3 fatalClosedMooney M20C · Davenport, IADec 3, 1967 · N5940Q · Destroyed NTSB LAX68A0058Accident · 1 fatalClosedHome-Built Burro · Jamul, CADec 3, 1967 · N40S · Destroyed NTSB LAX68A0057Accident · 2 fatalClosedPiper PA-28 · Castaic, CADec 1, 1967 · N149VP · Destroyed NTSB FTW68A0058Accident · 3 fatalClosedCessna 182 · Orange, TXDec 1, 1967 · N8952X · Destroyed NTSB FTW68A0057Accident · 1 fatalClosedPiper PA-22 · Porum, OKDec 1, 1967 · N7007B · Destroyed NTSB FTW68A0056Accident · 2 fatalClosedPiper PA-24 · Enid, OKNov 30, 1967 · N6020P · Destroyed NTSB MIA68A0053Accident · 3 fatalClosedLear Jet 23 · Orlando, FLNov 29, 1967 · N690L · Destroyed NTSB LAX68A0056Accident · 3 fatalClosedCessna 172H · Newhall, CANov 28, 1967 · N1780F · Destroyed NTSB FTW68A0055Accident · 1 fatalClosedCessna 310H · Alpine, TXNov 27, 1967 · N1118Q · Destroyed NTSB NYC68A0074Accident · 1 fatalClosedCessna 401 · Whitefield, NHNov 26, 1967 · N3280Q · Destroyed NTSB MIA68A0052Accident · 4 fatalClosedMooney M20E · Tallahassee, FLNov 26, 1967 · N9253M · Destroyed NTSB FTW68A0054Accident · 4 fatalClosedCessna 170A · Van Horn, WANov 26, 1967 · N81K · Destroyed NTSB FTW68A0053Accident · 2 fatalClosedCessna 182D · Rayville, LANov 26, 1967 · N8738X · Destroyed NTSB DIA68A0023Incident · 1 fatalClosedBensen B8MWBH · Stafford, VANov 26, 1967 · N2129 · Substantial damage