Skip to content

NTSB investigations, 1967, OK

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

19642026

NTSB investigations, 1967, OK per year, 1964–2026: 2,798 cases
1964	108
1965	105
1966	100
1967	134
1968	100
1969	99
1970	81
1971	102
1972	56
1973	77
1974	66
1975	60
1976	66
1977	72
1978	63
1979	66
1980	64
1981	79
1982	63
1983	64
1984	65
1985	47
1986	42
1987	45
1988	38
1989	40
1990	29
1991	30
1992	36
1993	23
1994	32
1995	42
1996	35
1997	31
1998	41
1999	36
2000	31
2001	24
2002	26
2003	22
2004	23
2005	25
2006	21
2007	28
2008	25
2009	23
2010	23
2011	19
2012	18
2013	23
2014	11
2015	17
2016	21
2017	20
2018	15
2019	15
2020	18
2021	17
2022	22
2023	23
2024	19
2025	19
2026	13

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."eventStateOrRegion" = 'OK' 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.\"eventStateOrRegion\" = 'OK' 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."eventStateOrRegion" = 'OK' 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 FTW68D0402Accident · No injuriesClosedCessna 172 · Stigler, OKDec 25, 1967 · N3958F · Substantial damage NTSB FTW68D0401Accident · No injuriesClosedBeech A23 · Pryor, OKDec 23, 1967 · N3515R · Substantial damage NTSB FTW68A0062Accident · 2 fatalClosedPiper PA-24 · Shawnee, OKDec 8, 1967 · N6519P · Destroyed NTSB FTW68A0061Accident · No injuriesClosedDouglas B-26 · Oklahoma Cty, OKDec 8, 1967 · N6840D · Substantial damage 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 FTW68D0340Accident · No injuriesClosedPiper PA-30 · Okla.City, OKNov 27, 1967 · N7519Y · Substantial damage NTSB FTW68D0366Accident · No injuriesClosedPiper PA-24 · Hollis, OKNov 25, 1967 · N8378P · Substantial damage NTSB FTW68A0051Accident · No injuriesClosedCessna 310L · El Reno, OKNov 22, 1967 · N2261F · Substantial damage NTSB FTW68F0364Accident · No injuriesClosedCessna 175 · Mooreland, OKNov 20, 1967 · N9431B · Substantial damage NTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNov 20, 1967 · N3288J · Substantial damage NTSB FTW68D0338Accident · No injuriesClosedMooney M20C · Marlow, OKNov 20, 1967 · N6434U · Substantial damage NTSB FTW68F0362Accident · No injuriesClosedPiper PA-28 · Yukon, OKNov 17, 1967 · N4483J · Substantial damage NTSB FTW68D0352Accident · No injuriesClosedErco 415-C · Guthrie, OKNov 15, 1967 · N99911 · Substantial damage NTSB FTW68D0336Accident · No injuriesClosedCessna 182 · Norman, OKNov 14, 1967 · N2087R · Substantial damage NTSB FTW68D0361Accident · No injuriesClosedCessna 210 · Alva, OKNov 13, 1967 · N6766R · Substantial damage NTSB FTW68D0292Accident · No injuriesClosedMooney M20E · Tulsa, OKNov 13, 1967 · N5596Q · Substantial damage NTSB FTW68D0334Accident · No injuriesClosedRyan ST-3KR · Tulsa, OKNov 12, 1967 · N1344 · Minor damage NTSB FTW68A0048Accident · Serious injuriesClosedGyrocopter Z3-65M · Oklahoma Cty, OKNov 12, 1967 · N74064 · Substantial damage NTSB FTW68F0333Accident · No injuriesClosedCessna 150 · Bethany, OKNov 11, 1967 · N8761S · Substantial damage NTSB FTW68F0331Accident · Minor injuriesClosedPiper PA-22 · Fairview, OKNov 11, 1967 · N3635P · Destroyed NTSB FTW68D0332Accident · No injuriesClosedNaval Fcty N3N · Frederick, OKNov 11, 1967 · N44830 · Substantial damage NTSB FTW68F0329Accident · Serious injuriesClosedAeronca 7AC · Kingfisher, OKNov 6, 1967 · N1703E · Substantial damage NTSB FTW68A0047Accident · 2 fatalClosedCessna 150F · Elgin, OKNov 4, 1967 · N8683S · Destroyed NTSB FTW68D0415Accident · Minor injuriesClosedPiper PA-22 · Honobia, OKOct 28, 1967 · N6707B · Substantial damage NTSB FTW68D0297Accident · No injuriesClosedPiper PA-25 · Reed, OKOct 20, 1967 · N7655Z · Substantial damage NTSB FTW68F0288Accident · Minor injuriesClosedCessna 310D · Stilwell, OKOct 19, 1967 · N6927T · Substantial damage NTSB FTW68D0286Accident · No injuriesClosedCessna 150 · Okla. City, OKOct 17, 1967 · N3954U · Substantial damage NTSB FTW68D0283Accident · No injuriesClosedBeech S35 · Tulsa, OKOct 14, 1967 · N320JD · Substantial damage NTSB FTW68A0040Accident · 1 fatalClosedBensen B8M · Yukon, OKOct 10, 1967 · N9171 · Destroyed NTSB FTW68F0244Accident · Serious injuriesClosedPiper PA-28 · Tulsa, OKOct 1, 1967 · N6721W · Substantial damage NTSB FTW68D0026Accident · No injuriesClosedCessna 150E · Mill Creek, OKSep 30, 1967 · N6251T · Substantial damage NTSB FTW68D0241Accident · No injuriesClosedCessna 150 · Lexington, OKSep 24, 1967 · N7985E · Substantial damage NTSB FTW68D0238CaseClosedMooney M20C · Okmulgee, OKSep 19, 1967 NTSB FTW68D0222Accident · No injuriesClosedCessna 150F · Guymon, OKSep 10, 1967 · N6671F · Substantial damage NTSB FTW68D0220Accident · No injuriesClosedPiper PA-22 · Marshall, OKSep 9, 1967 · N6946D · Substantial damage NTSB FTW68D0199Accident · No injuriesClosedCessna 182C · Skiatook, OKSep 4, 1967 · N8572T · Substantial damage NTSB MKC68A0018Accident · 4 fatalClosedPiper PA-16 · Blocker, OKSep 3, 1967 · N5746H · 2 aircraft · Destroyed NTSB FTW68D0217Accident · No injuriesClosedErco 415-C · Canute, OKSep 3, 1967 · N2131H · Substantial damage NTSB FTW68A0023Accident · 2 fatalClosedPiper PA-28 · Springer, OKAug 31, 1967 · N7452R · Destroyed NTSB FTW68F0213Accident · No injuriesClosedPiper PA-22 · Quinton, OKAug 27, 1967 · N1330C · Substantial damage NTSB FTW68F0161Accident · Minor injuriesClosedPiper PA-28 · Blackwell, OKAug 27, 1967 · N5090W · Substantial damage NTSB FTW68F0160Accident · No injuriesClosedPiper PA-24 · Okla-City, OKAug 27, 1967 · N8545P · Substantial damage NTSB FTW68D0193Accident · No injuriesClosedPiper PA-24 · Skiatook, OKAug 27, 1967 · N6452P · Substantial damage NTSB FTW68F0191Accident · Minor injuriesClosedCessna 170 · Okla.City, OKAug 26, 1967 · N4105V · Substantial damage NTSB FTW68F0189Accident · No injuriesClosedBeech A23-19 · Temple, OKAug 23, 1967 · N4788J · Substantial damage NTSB FTW68F0158Accident · No injuriesClosedPiper PA-24 · Mangum, OKAug 22, 1967 · N8721P · Substantial damage NTSB FTW68F0157Accident · No injuriesClosedLuscombe 8C · Norman, OKAug 22, 1967 · N2863K · Substantial damage NTSB FTW68D0154Accident · No injuriesClosedCessna 182 · Ketchum, OKAug 20, 1967 · N3430S · Substantial damage NTSB FTW68D0172Accident · No injuriesClosedCessna 206 · Afton, OKAug 19, 1967 · N2679X · Substantial damage