Skip to content

NTSB investigations, 1966, OK

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKDec 30, 1966 · N6298T · Substantial damage NTSB FTW67D0379Accident · No injuriesClosedPitts 190 · Duncan, OKDec 29, 1966 · N97M · Substantial damage NTSB FTW67A0067Accident · No injuriesClosedCessna P206 · Chickasha, OKDec 29, 1966 · N2588X · Substantial damage NTSB FTW67D0377Accident · Serious injuriesClosedPiper PA-28 · Boise City, OKDec 26, 1966 · N9314J · Destroyed NTSB FTW67D0375Accident · No injuriesClosedPiper PA-28 · Enid, OKDec 24, 1966 · N8412W · Substantial damage NTSB FTW67D0374Accident · No injuriesClosedCessna 150B · Enid, OKDec 23, 1966 · N7390X · Substantial damage NTSB FTW67D0346Accident · No injuriesClosedBeech J35 · Lawton, OKDec 14, 1966 · N8355D · Substantial damage NTSB FTW67F0345Accident · Minor injuriesClosedPiper J3C-65 · Tulsa, OKDec 10, 1966 · N56274 · Substantial damage NTSB FTW67F0356Accident · No injuriesClosedBeech P35 · Enid, OKDec 9, 1966 · N8915M · Substantial damage NTSB FTW67D0322Accident · No injuriesClosedCessna U206 · Oklahoma Cty, OKDec 6, 1966 · N8001Z · Substantial damage NTSB FTW67A0060Accident · 1 fatalClosedCessna 182 · Ponca City, OKDec 4, 1966 · N8612T · Destroyed NTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKDec 1, 1966 · N16085 · Substantial damage NTSB FTW67D0338Accident · No injuriesClosedCessna 210 · Enid, OKNov 28, 1966 · N6593X · Substantial damage NTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNov 23, 1966 · N1422F · Substantial damage NTSB FTW67D0333Accident · No injuriesClosedCessna 172 · Enid, OKNov 20, 1966 · N4196L · No damage NTSB FTW67D0319Accident · No injuriesClosedCessna 172 · Norman, OKNov 20, 1966 · N5950R · Substantial damage NTSB FTW67D0318Accident · No injuriesClosedCessna 182C · Rose 3kla, OKNov 20, 1966 · N8552T · Substantial damage NTSB FTW67D0332Accident · No injuriesClosedCessna 182 · Felt, OKNov 19, 1966 · N2799G · Substantial damage NTSB FTW67A0053Accident · Minor injuriesClosedCessna 182H · Davis, OKNov 13, 1966 · N2024X · Substantial damage NTSB FTW67A0051Accident · No injuriesClosedBell 47G3B1 · Yukon, OKNov 10, 1966 · N1130W · Substantial damage NTSB FTW67D0287Accident · No injuriesClosedPiper PA-28 · Pond Creek, OKNov 9, 1966 · N4633R · Substantial damage NTSB FTW67F0328Accident · No injuriesClosedCessna 150E · Mannsville, OKNov 8, 1966 · N6251T · Substantial damage NTSB FTW67F0266Accident · No injuriesClosedMooney M20C · Oklahoma Cty, OKOct 28, 1966 · N6718U · Substantial damage NTSB FTW67F0264Accident · Minor injuriesClosedCessna 210E · Bunch, OKOct 19, 1966 · N7411C · Substantial damage NTSB FTW67D0274Accident · No injuriesClosedCessna 172 · Bartlesville, OKOct 14, 1966 · N4206L · Substantial damage NTSB FTW67F0247Accident · No injuriesClosedPiper PA-24 · Oklahoma City, OKOct 13, 1966 · N7483P · Substantial damage NTSB FTW67D0260Accident · No injuriesClosedCessna 182 · Pond Creek, OKOct 12, 1966 · N1948X · Substantial damage NTSB FTW67D0258Accident · No injuriesClosedCessna 182 · Blackwell, OKOct 9, 1966 · N2026X · Substantial damage NTSB FTW67F0225Accident · No injuriesClosedPiper PA-28 · Yukon, OKOct 5, 1966 · N9337J · Substantial damage NTSB FTW67D0224Accident · No injuriesClosedCessna 175 · Perry, OKOct 2, 1966 · N6593E · Destroyed NTSB FTW67F0222Accident · No injuriesClosedCessna 210 · Oklahoma Cty, OKSep 28, 1966 · N3705Y · Substantial damage NTSB FTW67D0217Accident · No injuriesClosedBeech 35 · Guymon, OKSep 21, 1966 · N8946M · Substantial damage NTSB FTW67A0042Accident · No injuriesClosedBell 47G2A1 · Vici, OKSep 12, 1966 · N73997 · Substantial damage NTSB FTW67D0200Accident · No injuriesClosedMooney M20C · Guthrie, OKSep 9, 1966 · N1316W · Substantial damage NTSB FTW67F0199Accident · Minor injuriesClosedCessna 172 · Yukon, OKSep 7, 1966 · N6686A · Substantial damage NTSB FTW67A0030Accident · No injuriesClosedBell 47G3B1 · Yukon, OKSep 6, 1966 · N8542F · Substantial damage NTSB FTW67A0027Accident · Minor injuriesClosedHughes 269A · Tulsa, OKSep 3, 1966 · N8733F · Destroyed NTSB FTW67D0210Accident · No injuriesClosedMooney M20E · Ada, OKSep 2, 1966 · N79838 · Substantial damage NTSB FTW67D0209Accident · No injuriesClosedBeech 23 · Lake Texoma, OKAug 31, 1966 · N2310L · Substantial damage NTSB FTW67A0025Accident · 1 fatalClosedPiper PA-18 · Kellyville, OKAug 21, 1966 · N5897D · Destroyed NTSB FTW67F0143Accident · No injuriesClosedNavion A · Oklahoma Cty, OKAug 13, 1966 · N91702 · Substantial damage NTSB FTW68F0033Accident · Serious injuriesClosedPiper PA-30 · Sand Springs, OKAug 11, 1966 · N7218Y · Destroyed NTSB FTW67D0175Accident · No injuriesClosedCessna 172 · Apache, OKAug 11, 1966 · N1613Y · Substantial damage NTSB FTW67D0174Accident · No injuriesClosedCessna 182 · Edmond, OKAug 11, 1966 · N3366Y · Substantial damage NTSB FTW67D0146Accident · No injuriesClosedBoeing E75N1 · Altus, OKAug 8, 1966 · N5268N · Substantial damage NTSB FTW67F0114Accident · Minor injuriesClosedTurner T-40A · Piedmont, OKAug 2, 1966 · N115ET · Substantial damage NTSB FTW67D0119Accident · No injuriesClosedCessna 150 · Erick, OKJul 30, 1966 · N8417G · Substantial damage NTSB FTW67A0020Accident · No injuriesClosedPiper PA-24 · El Reno, OKJul 29, 1966 · N8420P · Substantial damage NTSB FTW67F0113Accident · Serious injuriesClosedCessna 140A · Wilson, OKJul 24, 1966 · N1104D · Substantial damage NTSB FTW67F0109Accident · No injuriesClosedLuscombe 8A · Enid, OKJul 23, 1966 · N71533 · Substantial damage