Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 FTW66D0464Accident · No injuriesClosedPiper PA-22 · Rosston, OKDec 29, 1965 · N2181A · Substantial damage NTSB FTW66F0483Accident · Minor injuriesClosedTaylorcraft BC12-D · Sand Springs, OKDec 26, 1965 · N95034 · Substantial damage NTSB FTW66F0482Accident · No injuriesClosedErcoupe 415-C · Fairview, OKDec 24, 1965 · N3750H · Substantial damage NTSB FTW66D0463Accident · No injuriesClosedBeechcraft B-55 · Oklahoma Cty, OKDec 24, 1965 · N145ZB · Substantial damage NTSB FTW66D0452Accident · No injuriesClosedCessna 172 · Altus, OKDec 24, 1965 · N5950R · Substantial damage NTSB FTW66F0481Accident · Minor injuriesClosedErcoupe 415-C · Lahoma, OKDec 22, 1965 · N93605 · Substantial damage NTSB FTW66F0450Accident · No injuriesClosedCessna 170 · Guthrie, OKDec 20, 1965 · N4192V · Substantial damage NTSB FTW66D0455Accident · No injuriesClosedBeechcraft M35 · Oklahomacity, OKDec 17, 1965 · N9927R · No damage NTSB FTW66D0449Accident · No injuriesClosedBeechcraft M-55 · Cushing, OKDec 17, 1965 · N109WB · Substantial damage NTSB FTW66F0458Accident · No injuriesClosedAero Cmdr 520 · Cleo Springs, OKDec 6, 1965 · N7834 · Substantial damage NTSB FTW66A0051Accident · Minor injuriesClosedHughes 269A · Enid, OKNov 26, 1965 · N8793F · Substantial damage NTSB FTW66F0434Accident · No injuriesClosedCessna 210 · El Reno, OKNov 24, 1965 · N9557T · Substantial damage NTSB FTW66D0440Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 24, 1965 · N6812X · Substantial damage NTSB FTW66D0433Accident · No injuriesClosedPiper PA-28 · Stigler, OKNov 22, 1965 · N5654W · Substantial damage NTSB FTW66F0445Accident · No injuriesClosedPiper PA-24 · Stillwater, OKNov 21, 1965 · N7192P · Substantial damage NTSB FTW66A0048Accident · 1 fatalClosedTaylorcraft BC-12 · Pearson, OKNov 20, 1965 · N29718 · Substantial damage NTSB FTW66F0422Accident · No injuriesClosedAero Cmdr 520 · Oklahoma City, OKNov 17, 1965 · N264RW · Substantial damage NTSB FTW66D0392Accident · No injuriesClosedPiper J-3 · Washita, OKNov 7, 1965 · N88468 · Substantial damage NTSB FTW66A0043Accident · 3 fatalClosedDouglas C-124 · Tulsa, OKNov 7, 1965 · AF52-942 · 2 aircraft · Substantial damage NTSB FTW66A0042Accident · No injuriesClosedBrantly B-2B · Wynne Wood, OKNov 6, 1965 · N2274U · Substantial damage NTSB FTW66A0041Accident · 2 fatalClosedCessna 182H · Moore, OKNov 5, 1965 · N1850X · Destroyed NTSB FTW66A0040Accident · 2 fatalClosedBeech 95-55 · Lawton, OKNov 3, 1965 · N1344Z · Destroyed NTSB FTW66F0346Accident · No injuriesClosedPiper PA-22 · Yukon, OKOct 28, 1965 · N7328D · Substantial damage NTSB FTW66A0038Accident · 1 fatalClosedLuscombe 8A · Guthrie, OKOct 24, 1965 · N39015 · Destroyed NTSB FTW66D0418Accident · No injuriesClosedPiper PA-24 · Tulsa, OKOct 15, 1965 · N7857P · Substantial damage NTSB FTW66F0352Accident · Minor injuriesClosedPiper J-3 · Randlett, OKOct 10, 1965 · N32905 · Substantial damage NTSB FTW66D0416Accident · No injuriesClosedPiper PA-30 · Tulsa, OKOct 10, 1965 · N7746Y · Substantial damage NTSB FTW66F0385Accident · No injuriesClosedCessna 172 · Tulsa, OKOct 9, 1965 · N5497R · Substantial damage NTSB FTW66F0339Accident · No injuriesClosedCessna 150 · Oklahoma Cty, OKOct 9, 1965 · N8761S · Substantial damage NTSB FTW66F0350Accident · No injuriesClosedMooney M20C · Bethany, OKOct 8, 1965 · N5848Q · Substantial damage NTSB FTW66A0035Accident · 1 fatalClosedCessna 182B · Tulsa, OKOct 7, 1965 · N2300G · Destroyed NTSB FTW66D0337Accident · No injuriesClosedBeechcraft 35-A33 · Moyer, OKOct 4, 1965 · N536T · Substantial damage NTSB FTW66F0335Accident · No injuriesClosedMooney M20A · Tulsa, OKOct 1, 1965 · N8369E · Substantial damage NTSB FTW66F0333Accident · Minor injuriesClosedLangley 2-4-90 · Tulsa, OKSep 26, 1965 · N51706 · Destroyed NTSB FTW66D0301Accident · No injuriesClosedBeechcraft J-35 · Ardmore, OKSep 24, 1965 · N3013C · Substantial damage NTSB UNK65X1535Accident · No injuriesClosedLockheed L-1049 · Ardmore, OKSep 20, 1965 · N9719C · Substantial damage NTSB FTW66A0012Accident · No injuriesClosedBrantly B2B · Yukon, OKSep 15, 1965 · N2252U · Substantial damage NTSB FTW66D0297Accident · No injuriesClosedPiper PA-25 · Hollis, OKSep 6, 1965 · N6474Z · Substantial damage NTSB FTW66D0296Accident · No injuriesClosedMooney M20C · Mangum, OKSep 5, 1965 · N6434U · Substantial damage NTSB FTW66F0307Accident · Minor injuriesClosedCessna 140 · Tulsa, OKSep 4, 1965 · N76029 · Substantial damage NTSB FTW66A0025Accident · No injuriesClosedBell 47G2A · Arnegie, OKSep 2, 1965 · N73259 · Substantial damage NTSB FTW66D0318Accident · No injuriesClosedCessna 172 · Vinita, OKAug 28, 1965 · N8809B · Substantial damage NTSB FTW66D0293Accident · No injuriesClosedCessna 182 · Perry, OKAug 22, 1965 · N1827X · Substantial damage NTSB FTW66F0254Accident · No injuriesClosedPiper PA-23 · Tulsa, OKAug 18, 1965 · N4982P · Substantial damage NTSB FTW66D0465Accident · No injuriesClosedPiper PA-22 · Yukon, OKAug 14, 1965 · N1962A · Substantial damage NTSB FTW66F0241Accident · Minor injuriesClosedPiper PA-25 · Fort Gibson, OKAug 4, 1965 · N6723Z · Substantial damage NTSB FTW66D0220Accident · Minor injuriesClosedCessna 150 · Wilson, OKAug 3, 1965 · N4163U · Substantial damage NTSB FTW66D0214Accident · No injuriesClosedCessna 182E · Tulsa, OKAug 1, 1965 · N3509Y · Substantial damage NTSB FTW66D0168Accident · No injuriesClosedPiper PA-28 · Yukon, OKJul 31, 1965 · N6600W · Substantial damage NTSB FTW66A0012Accident · 2 fatalClosedPiper J3C · Arnett, OKJul 31, 1965 · N24620 · Destroyed