Skip to content

Final NTSB investigations, 1967

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

Final NTSB investigations, 1967 per year, 1962–2026: 171,584 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,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

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."completionStatus" = 'Completed' 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.\"completionStatus\" = 'Completed'
  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."completionStatus" = 'Completed'
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