Skip to content

NTSB investigations, 1968, OK

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

19642026

NTSB investigations, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 FTW69F0330Accident · Serious injuriesClosedPiper PA-22 · Mcalester, OKDec 24, 1968 · N8723C · Substantial damage NTSB FTW69D0329Accident · No injuriesClosedCessna 172 · Miami, OKDec 22, 1968 · N5322T · Substantial damage NTSB FTW69D0338Accident · No injuriesClosedCessna 182 · Perry, OKDec 20, 1968 · N3328F · Substantial damage NTSB FTW69D0328Accident · No injuriesClosedBeech V35A · Boise City, OKDec 19, 1968 · N862S · Substantial damage NTSB FTW69F0324Accident · No injuriesClosedCessna 172K · Oklahoma Cty, OKDec 12, 1968 · N78622 · Substantial damage NTSB FTW69D0298Accident · No injuriesClosedCessna 150 · Durant, OKDec 2, 1968 · N50399 · Substantial damage NTSB FTW69A0037Accident · 2 fatalClosedCessna 310B · Cache, OKNov 30, 1968 · N3603D · Destroyed NTSB FTW69F0322Accident · Serious injuriesClosedCessna 150 · Calumet, OKNov 28, 1968 · N8265F · Substantial damage NTSB FTW69F0295Accident · Minor injuriesClosedPiper PA-28 · Oklahoma Cty, OKNov 22, 1968 · N9565W · Substantial damage NTSB FTW69A0033Accident · 1 fatalClosedPiper J3C-65 · Temple, OKNov 17, 1968 · N70753 · Destroyed NTSB FTW69A0032Accident · 1 fatalClosedMooney M20 · Wayne, OKNov 13, 1968 · N873B · Destroyed NTSB FTW69F0291Accident · No injuriesClosedCessna 150 · Omega, OKNov 8, 1968 · N4695X · Substantial damage NTSB FTW69F0279Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNov 7, 1968 · N7443J · Substantial damage NTSB FTW69D0310Accident · No injuriesClosedPiper J-3 · Douglas, OKNov 5, 1968 · N35355 · Substantial damage NTSB FTW69D0275Accident · No injuriesClosedCessna 182 · Tulsa, OKNov 4, 1968 · N3202S · Substantial damage NTSB FTW69F0277Accident · Minor injuriesClosedCessna 310F · Stroud, OKOct 28, 1968 · N6736X · Substantial damage NTSB FTW69D0264Accident · Serious injuriesClosedCessna 170 · Crescent, OKOct 27, 1968 · N4419V · Destroyed NTSB FTW69F0274Accident · No injuriesClosedCessna 177 · Tulsa, OKOct 26, 1968 · N3318T · Substantial damage NTSB FTW69D0289Accident · Minor injuriesClosedLuscombe 8A · Cushing, OKOct 26, 1968 · N71153 · Substantial damage NTSB FTW69D0267Accident · No injuriesClosedPiper PA-18 · Chattanooga, OKOct 26, 1968 · N6477D · Substantial damage NTSB FTW69A0030Accident · 1 fatalClosedFunk B85C · Carnegie, OKOct 26, 1968 · N1602N · Destroyed NTSB FTW69F0273Accident · No injuriesClosedPiper PA-31 · Okla.City, OKOct 25, 1968 · N9011Y · Substantial damage NTSB FTW69D0225Accident · Minor injuriesClosedLuscombe 8F · Drumright, OKOct 13, 1968 · N3541G · Substantial damage NTSB FTW69F0250Accident · No injuriesClosedPiper PA-24 · Oklahoma Cty, OKOct 10, 1968 · N5809P · Substantial damage NTSB FTW69D0214Accident · No injuriesClosedCessna 150F · Hobart, OKOct 6, 1968 · N7709F · Substantial damage NTSB FTW69F0224Accident · No injuriesClosedPiper PA-22 · Yukon, OKOct 1, 1968 · N1429C · Substantial damage NTSB FTW69D0218Accident · No injuriesClosedChampion 7EC · Enid, OKSep 29, 1968 · N11026 · Substantial damage NTSB FTW69D0213Accident · No injuriesClosedCessna 182A · Mill Creek, OKSep 29, 1968 · N2201G · Substantial damage NTSB FTW69A0019Accident · 1 fatalClosedMooney M20E · Hugo, OKSep 27, 1968 · N2570W · Destroyed NTSB FTW69D0220Accident · No injuriesClosedCessna 180A · Stroud, OKSep 26, 1968 · N7881A · Substantial damage NTSB FTW69D0212Accident · No injuriesClosedCessna 150 · Altus, OKSep 25, 1968 · N6566F · Substantial damage NTSB FTW69D0188Accident · No injuriesClosedCessna 150 · Norman, OKSep 25, 1968 · N23149 · Substantial damage NTSB FTW69D0210Accident · No injuriesClosedCessna 140 · Perkins, OKSep 20, 1968 · N1699V · Substantial damage NTSB FTW69D0208Accident · No injuriesClosedCessna 182 · Yukon, OKSep 16, 1968 · N2337G · Substantial damage NTSB FTW69A0017Accident · 1 fatalClosedPiper J-3 · Vinita, OKSep 15, 1968 · N6430H · Destroyed NTSB FTW69F0206Accident · Minor injuriesClosedCessna 150 · Okla.City, OKSep 14, 1968 · N2277J · Destroyed NTSB FTW69F0187Accident · No injuriesClosedCessna 140 · Afton, OKSep 13, 1968 · N72438 · Substantial damage NTSB FTW69D0186Accident · Minor injuriesClosedPiper PA-28 · Stigler, OKSep 11, 1968 · N5066W · Substantial damage NTSB FTW69F0180Accident · No injuriesClosedBeech 35 · Okla.City, OKSep 3, 1968 · N3046V · Substantial damage NTSB FTW69F0174Accident · No injuriesClosedPiper PA-22 · Yukon, OKAug 31, 1968 · N1320C · Substantial damage NTSB FTW69F0173Accident · No injuriesClosedPiper PA-25 · Crescent, OKAug 31, 1968 · N6593Z · Substantial damage NTSB FTW69A0014Accident · 2 fatalClosedAeronca 11AC · Idabel, OKAug 31, 1968 · N85811 · Destroyed NTSB FTW69A0013Accident · No injuriesClosedLockheed T-33 · Okla.City, OKAug 28, 1968 · N155 · Substantial damage NTSB FTW69D0168Accident · No injuriesClosedCessna 150 · Thomas, OKAug 26, 1968 · N7140F · Substantial damage NTSB FTW69D0182Accident · Minor injuriesClosedMooney M20E · Henryetta, OKAug 21, 1968 · N79328 · Substantial damage NTSB FTW69A0009Accident · 6 fatalClosedCessna U206C · Miami, OKAug 19, 1968 · N3996G · Destroyed NTSB FTW69F0159Accident · Serious injuriesClosedPiper PA-24 · Minco, OKAug 15, 1968 · N8097P · Destroyed NTSB FTW69D0153Accident · No injuriesClosedPiper PA-24 · Guymon, OKAug 14, 1968 · N6498P · Substantial damage NTSB FTW69F0142Accident · Minor injuriesClosedGlobe GC-1B · Okla.City, OKAug 10, 1968 · N2421B · Substantial damage NTSB FTW69D0139Accident · No injuriesClosedPiper PA-22 · Lamont, OKAug 6, 1968 · N1703P · Substantial damage