Skip to content

NTSB investigations, 1967

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year, 1962–2026: 180,581 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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 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
  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
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 MKC68F0441Accident · No injuriesClosedPiper PA-22 · Edwards, MODec 31, 1967 · N640A · Substantial damage NTSB MKC68F0404Accident · No injuriesClosedPiper PA-22 · Hot Springs, SDDec 31, 1967 · N9178D · Substantial damage NTSB MKC68D0433Accident · No injuriesClosedCessna 150 · Duluth, MNDec 31, 1967 · N6230T · Substantial damage NTSB MIA68D0372Accident · No injuriesClosedPiper PA-22 · Gretna, FLDec 31, 1967 · N3332A · Substantial damage NTSB LAX68D0281Accident · Minor injuriesClosedPiper PA-28 · Lancaster, CADec 31, 1967 · N5952W · Substantial damage NTSB LAX68D0255Accident · No injuriesClosedBellanca 14-13 · Compton, CADec 31, 1967 · N74368 · Substantial damage NTSB FTW68A0066Accident · 6 fatalClosedBeech 95-B55 · New Orleans La, LADec 31, 1967 · N6139V · Destroyed NTSB DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VADec 31, 1967 · N8535J · Substantial damage NTSB DEN68A0030Accident · 1 fatalClosedCessna 182 · Idaho Spring, CODec 31, 1967 · N681JF · Destroyed NTSB CHI68F0529Accident · Serious injuriesClosedPiper PA-24 · Manistee, MIDec 31, 1967 · N7636P · Substantial damage NTSB CHI68D0543Accident · No injuriesClosedPiper PA-28 · New Richmond, WIDec 31, 1967 · N7642W · Substantial damage NTSB CHI68D0536Accident · No injuriesClosedPiper PA-28 · Waukegan, ILDec 31, 1967 · N6195W · Substantial damage NTSB OAK68F0288Accident · Minor injuriesClosedCessna 170 · Lodi, CADec 30, 1967 · N4422V · Substantial damage NTSB OAK68D0267Accident · Minor injuriesClosedLuscombe 8A · Half Moon Bay, CADec 30, 1967 · N71151 · Substantial damage NTSB OAK68D0262Accident · No injuriesClosedCessna 170A · Morgan Hill, CADec 30, 1967 · N9240A · Substantial damage NTSB OAK68D0258Accident · Minor injuriesClosedPiper PA-28 · Mariposa, CADec 30, 1967 · N8963J · Substantial damage NTSB OAK68A0052Accident · 2 fatalClosedCessna 170B · Hawthorne, NVDec 30, 1967 · N3114B · Destroyed NTSB NYC68F0346Accident · No injuriesClosedCessna 210B · Erie, PADec 30, 1967 · N9605X · Substantial damage NTSB MKC68F0408Accident · No injuriesClosedBeech 95-B55 · Hibbing, MNDec 30, 1967 · N9574Y · Substantial damage NTSB MIA69D0033Accident · No injuriesClosedPiper PA-22 · Gainesville, GADec 30, 1967 · N9249D · Substantial damage NTSB MIA68D0392Accident · No injuriesClosedBellanca 17-30 · Ft Lauderdale, FLDec 30, 1967 · N6687V · Substantial damage NTSB LAX68D0242Accident · No injuriesClosedCessna 150 · Riverside, CADec 30, 1967 · N8840S · Substantial damage NTSB FTW68A0067Accident · Minor injuriesClosedAero Cmdr 500-B · Mena, ARDec 30, 1967 · N6369U · Substantial damage NTSB DEN68D0191Accident · No injuriesClosedCessna 172 · Richfield, UTDec 30, 1967 · N8267X · Substantial damage NTSB DEN68A0028Accident · 1 fatalClosedCessna 320A · Kanosh, UTDec 30, 1967 · N3047R · Destroyed NTSB OAK68D0309Accident · No injuriesClosedCessna 172 · Corning, CADec 29, 1967 · N5421T · Substantial damage NTSB LAX68D0332Accident · Minor injuriesClosedPiper PA-24 · Goleta, CADec 29, 1967 · N7250P · Substantial damage NTSB LAX68D0268Accident · Minor injuriesClosedCessna 150 · Rialto, CADec 29, 1967 · N6414T · Substantial damage NTSB FTW68F0411Accident · No injuriesClosedBeech A23 · Tyler, TXDec 29, 1967 · N6939Q · Substantial damage NTSB FTW68D0410Accident · Minor injuriesClosedCessna 310D · Midland, TXDec 29, 1967 · N6989T · Substantial damage NTSB FTW68D0403Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARDec 29, 1967 · N6417W · Substantial damage NTSB DIA68D0196Accident · No injuriesClosedCessna 310 · Grundy, VADec 29, 1967 · N2615C · Substantial damage NTSB DEN68F0189Accident · No injuriesClosedBeech D18S · Albuquerque, NMDec 29, 1967 · N260R · Substantial damage NTSB DEN68F0179Accident · Minor injuriesClosedCessna 210 · Denver, CODec 29, 1967 · N6641X · Destroyed NTSB DEN68D0186Accident · No injuriesClosedCessna 320C · Farmington, NMDec 29, 1967 · N3024T · Substantial damage NTSB CHI68F0498Accident · No injuriesClosedAero Comdr 200-D · Plymouth, MIDec 29, 1967 · N235M · Substantial damage NTSB CHI68D0558Accident · No injuriesClosedPiper PA-30 · Willoughby, OHDec 29, 1967 · N7745Y · Substantial damage NTSB CHI68A0058Accident · 2 fatalClosedNavion F · Murphysboro, ILDec 29, 1967 · N91461 · Destroyed NTSB ANC68A0035Accident · Minor injuriesClosedAero Macchi AL60B · Nome, AKDec 29, 1967 · N1702L · Substantial damage NTSB OAK68F0297Accident · Minor injuriesClosedCessna 170B · Petaluma, CADec 28, 1967 · N2590C · Destroyed NTSB NYC68A0084Accident · 3 fatalClosedPiper PA-31 · Muncy, PADec 28, 1967 · N9040Y · Destroyed NTSB MKC68F0395Accident · No injuriesClosedStinson 10 · Grimes, IADec 28, 1967 · N26290 · Substantial damage NTSB MKC68D0459Accident · No injuriesClosedBeech 35 · Linneus, MODec 28, 1967 · N2851V · Substantial damage NTSB MKC68D0399Accident · No injuriesClosedCessna 172E · Agency, IADec 28, 1967 · N3684S · Substantial damage NTSB MKC68A0042Accident · No injuriesClosedCessna 210 · Ute, IADec 28, 1967 · N3672Y · Substantial damage NTSB MIA68A0059Accident · No injuriesClosedBeech C18 · St.Croix, VIDec 28, 1967 · N7940C · Substantial damage NTSB LAX68O0294Accident · No injuriesClosedCessna 182 · San Pedro, MexicoDec 28, 1967 · N9354X · Substantial damage NTSB FTW68F0404Accident · No injuriesClosedCessna 210E · Searcy, ARDec 28, 1967 · N2322F · Substantial damage NTSB DEN68D0175Accident · No injuriesClosedLuscombe 8F · Broomfield, CODec 28, 1967 · N2109B · Substantial damage NTSB NYC68F0305Accident · No injuriesClosedBeech 35R · Prospectville, PADec 27, 1967 · N1220 · Substantial damage