Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 FTW70A0044Accident · 1 fatalClosedPiper PA-24 · Boynton, OKDec 31, 1969 · N6011P · Destroyed NTSB FTW70F0347Accident · No injuriesClosedBeech C35 · Muskogee, OKDec 21, 1969 · N1900D · Substantial damage NTSB FTW70F0331Accident · No injuriesClosedCessna 140 · Sand Springs, OKDec 17, 1969 · N89240 · Substantial damage NTSB FTW70D0327Accident · No injuriesClosedLuscombe 8A · Wagoner, OKDec 14, 1969 · N2140K · Substantial damage NTSB FTW70F0307Accident · Minor injuriesClosedMooney M20C · Edmond, OKNov 27, 1969 · N3988N · Substantial damage NTSB FTW70D0322Accident · No injuriesClosedCessna 210 · Oklahoma Cty, OKNov 23, 1969 · N6878R · Substantial damage NTSB FTW70D0312Accident · No injuriesClosedCessna 172 · Pryor, OKNov 22, 1969 · N78142 · Substantial damage NTSB FTW70F0277Accident · No injuriesClosedBeech A23-19 · Bethany, OKNov 11, 1969 · N5998S · Substantial damage NTSB FTW70F0295Accident · Minor injuriesClosedCessna 182 · Seiling, OKNov 9, 1969 · N2397R · Substantial damage NTSB FTW70D0294Accident · No injuriesClosedCessna 182 · Stillwater, OKNov 9, 1969 · N3328F · Substantial damage NTSB FTW70F0290Accident · Serious injuriesClosedPiper J-3 · Muskogee, OKNov 8, 1969 · N6612H · Substantial damage NTSB FTW70D0289Accident · No injuriesClosedCessna 182 · Sweetwater, OKNov 6, 1969 · N34266 · Substantial damage NTSB FTW70D0297Accident · No injuriesClosedCessna 182 · Oklahoma Cty, OKNov 5, 1969 · N6246A · Substantial damage NTSB FTW70A0029Accident · 2 fatalClosedPiper PA-15 · Beaver, OKNov 3, 1969 · N5000H · Destroyed NTSB FTW70F0286Accident · Serious injuriesClosedCessna 150 · Purcell, OKOct 31, 1969 · N22975 · Destroyed NTSB FTW70F0270Accident · No injuriesClosedCessna 150B · Jenks, OKOct 21, 1969 · N1138Y · Destroyed NTSB FTW70F0262Accident · No injuriesClosedAeronca 7AC · Tulsa, OKOct 21, 1969 · N82621 · Substantial damage NTSB FTW70F0259Accident · Minor injuriesClosedCessna 175A · Lookeba, OKOct 21, 1969 · N6856E · Substantial damage NTSB FTW70D0250Accident · No injuriesClosedBeech 23-19 · Ardmore, OKOct 21, 1969 · N5998S · Substantial damage NTSB FTW70F0272Accident · No injuriesClosedAero Comdr 680FP · Okmulgee, OKOct 20, 1969 · N4262 · Substantial damage NTSB FTW70F0246Accident · No injuriesClosedMooney M-20C · Oklahoma Cty, OKOct 13, 1969 · N9289V · Substantial damage NTSB FTW70D0237Accident · Minor injuriesClosedGrumman 164 · Eva, OKOct 1, 1969 · N928X · Substantial damage NTSB FTW70F0227Accident · No injuriesClosedHarwood W8L · Tahlequah, OKSep 28, 1969 · N12034 · Substantial damage NTSB FTW70I0256Incident · No injuriesClosedMooney M-20F · Checotah, OKSep 26, 1969 · N2987L · Minor damage NTSB FTW70D0244Accident · No injuriesClosedPiper PA-16 · Norman, OKSep 25, 1969 · N5273H · Substantial damage NTSB FTW70F0229Accident · No injuriesClosedAero Comdr 500S · Bethany, OKSep 21, 1969 · XB-XAD · Substantial damage NTSB FTW70F0220Accident · 1 fatalClosedPiper PA-25 · Hollis, OKSep 17, 1969 · N6103Z · Destroyed NTSB FTW70D0210Accident · No injuriesClosedLuscombe 8A · Eakly, OKSep 17, 1969 · N1458K · Substantial damage NTSB FTW70D0225Accident · No injuriesClosedCessna 310L · Newkirk, OKSep 14, 1969 · N3346X · Substantial damage NTSB FTW70D0214Accident · No injuriesClosedAeronca 11AC · Tulsa, OKSep 7, 1969 · N9287E · Substantial damage NTSB FTW70F0209Accident · No injuriesClosedPiper PA-24 · Hominy, OKSep 2, 1969 · N5684P · Substantial damage NTSB FTW70F0194Accident · Serious injuriesClosedPiper PA-28R · Mooreland, OKSep 2, 1969 · N7689J · Substantial damage NTSB FTW70D0203Accident · No injuriesClosedBeech 23 · Norman, OKAug 31, 1969 · N2389Q · Substantial damage NTSB FTW70D0190Accident · No injuriesClosedCessna 140 · Enid, OKAug 31, 1969 · N2020N · Substantial damage NTSB FTW70D0202Accident · No injuriesClosedMooney M20C · Waurika, OKAug 28, 1969 · N5999Q · Substantial damage NTSB FTW70D0172Accident · No injuriesClosedCessna 150G · Jenks, OKAug 26, 1969 · N3183J · Substantial damage NTSB FTW70D0171Accident · No injuriesClosedBeech 35 · Hooker, OKAug 23, 1969 · N5101C · Substantial damage NTSB FTW70F0165Accident · No injuriesClosedCessna 150 · Norman, OKAug 20, 1969 · N51374 · Substantial damage NTSB FTW70D0178Accident · No injuriesClosedPiper PA-30 · Texhoma, OKAug 20, 1969 · N7065Y · Substantial damage NTSB FTW70D0200Accident · No injuriesClosedPiper PA-18A · Corn, OKAug 15, 1969 · N1984P · Substantial damage NTSB FTW70D0145Accident · No injuriesClosedBoeing E75N1 · Hollis, OKAug 7, 1969 · N5191N · Substantial damage NTSB FTW70D0135Accident · No injuriesClosedCessna 188 · Guymon, OKAug 2, 1969 · N5531S · Substantial damage NTSB FTW70D0120Accident · No injuriesClosedErco 415C · Sweetwater, OKJul 28, 1969 · N94343 · Substantial damage NTSB FTW70F0148Accident · 1 fatalClosedCougar 1 · Yukon, OKJul 27, 1969 · N7121 · Destroyed NTSB FTW70F0116Accident · No injuriesClosedCessna 175 · Oklahoma Cty, OKJul 20, 1969 · N8304T · Substantial damage NTSB FTW70F0105Accident · No injuriesClosedCessna 170 · Yukon, OKJul 19, 1969 · N9526A · Substantial damage NTSB FTW70D0138Accident · No injuriesClosedPiper PA-18A · Guymon, OKJul 7, 1969 · N8095D · Substantial damage NTSB FTW70A0001Accident · 2 fatalClosedMooney M20F · El Reno, OKJul 3, 1969 · N9143V · Destroyed NTSB FTW70D0065Accident · No injuriesClosedCessna 182 · Antlers, OKJun 30, 1969 · N2571R · Substantial damage NTSB FTW70D0075Accident · No injuriesClosedPiper PA-28 · Waynoka, OKJun 29, 1969 · N7382J · Substantial damage