Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 FTW72FPJ27Accident · Serious injuriesClosedMooney M20C · Blair, OKDec 28, 1971 · N7896V · Destroyed NTSB FTW72AF038Accident · No injuriesClosedLockheed 18 · Hobart, OKDec 22, 1971 · N10P · Substantial damage NTSB FTW72DPJ26Accident · No injuriesClosedBoeing A75N1 · Hollis, OKDec 15, 1971 · N50755 · Substantial damage NTSB FTW72FPM15Accident · No injuriesClosedCessna 172K · Jenks, OKDec 12, 1971 · N84691 · Substantial damage NTSB FTW72AF035Accident · 2 fatalClosedPiper J3C-65 · Marlow, OKDec 12, 1971 · N6382H · Destroyed NTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKDec 11, 1971 · N7025F · Destroyed NTSB FTW72AF034Accident · 1 fatalClosedPiper PA-28 · Piedmont, OKDec 11, 1971 · N5461S · Destroyed NTSB FTW72AF033Accident · 7 fatalClosedBeech 65-80 · Okla.City, OKDec 9, 1971 · N252Q · Destroyed NTSB FTW72FPM16Accident · No injuriesClosedLuscombe 8A · Cleveland, OKNov 30, 1971 · N1561K · Substantial damage NTSB FTW72FPJ23Accident · No injuriesClosedBeech A23-24 · Crescent, OKNov 24, 1971 · N5979S · Substantial damage NTSB FTW72DPJ24Accident · No injuriesClosedGrumman TBM-3U · Cushing, OKNov 14, 1971 · N108Q · Substantial damage NTSB FTW72DPM11Accident · No injuriesClosedPiper PA-28 · Morris, OKNov 9, 1971 · N4147J · Substantial damage NTSB FTW72FPM13Accident · No injuriesClosedBeech A23A · Maramec, OKNov 7, 1971 · N6942Q · Substantial damage NTSB FTW72FPM12Accident · Minor injuriesClosedStinson 108-1 · Calera, OKNov 7, 1971 · N97441 · Substantial damage NTSB FTW72FPM14Accident · No injuriesClosedCessna 182M · Tulsa, OKNov 6, 1971 · N71584 · Substantial damage NTSB FTW72FPJ22Accident · No injuriesClosedPiper PA-24 · Yukon, OKOct 29, 1971 · N8471P · Substantial damage NTSB FTW72AF022Accident · 3 fatalClosedBeech 65-B80 · Milo, OKOct 21, 1971 · N317K · Destroyed NTSB FTW72FPJ19Accident · No injuriesClosedChampion 7KCAB · Oklahoma Cty, OKOct 11, 1971 · N5099X · Substantial damage NTSB FTW72AF019Accident · 2 fatalClosedTaylorcraft BC12-D · Carmen, OKOct 10, 1971 · N43783 · Destroyed NTSB FTW72FPJ18Accident · 1 fatalClosedAeronca 11AC · Adams, OKOct 9, 1971 · N36605 · Substantial damage NTSB FTW72DPJ17Accident · No injuriesClosedCessna 182 · Walters, OKOct 6, 1971 · N3528F · Substantial damage NTSB FTW72FPJ21Accident · Serious injuriesClosedChampion 7ECA · Stratford, OKOct 4, 1971 · N516OT · Substantial damage NTSB FTW72FPJ16Accident · Minor injuriesClosedBensen B8M · El Reno, OKOct 4, 1971 · N22HE · Substantial damage NTSB FTW72DPJ20Accident · No injuriesClosedCessna 180 · Boise City, OKOct 2, 1971 · N5083E · Substantial damage NTSB FTW72FPJ15Accident · No injuriesClosedLuscombe 8A · Oklahoma Cty, OKSep 22, 1971 · N1942B · Substantial damage NTSB FTW72DPJ14Accident · No injuriesClosedCessna 182 · Bethany, OKSep 21, 1971 · N71132 · Substantial damage NTSB FTW72DPJ13Accident · No injuriesClosedPiper PA-24 · Midwest City, OKSep 16, 1971 · N5887P · Substantial damage NTSB FTW72FPM09Accident · Minor injuriesClosedErco 415-C · Tulsa, OKSep 12, 1971 · N99252 · Substantial damage NTSB FTW72FPM08Accident · No injuriesClosedPiper PA-22 · Tulsa, OKSep 6, 1971 · N1651A · Substantial damage NTSB FTW72DPM10Accident · No injuriesClosedCessna 182G · Sand Springs, OKSep 4, 1971 · N3786U · Substantial damage NTSB FTW72FPJ12Accident · Serious injuriesClosedPitts Spcl S1C · Cushing, OKAug 30, 1971 · N11MA · Substantial damage NTSB FTW72FPM07Accident · No injuriesClosedLuscombe 8A · Wann, OKAug 29, 1971 · N45792 · Destroyed NTSB FTW72DPM06Accident · No injuriesClosedCessna 150 · Skiatook, OKAug 28, 1971 · N3474J · Substantial damage NTSB FTW72FPJ10Accident · Minor injuriesClosedCessna 172H · Bethany, OKAug 27, 1971 · N2790L · Substantial damage NTSB FTW72FPM05Accident · No injuriesClosedPiper PA-25 · Atwood, OKAug 25, 1971 · N6531Z · Substantial damage NTSB FTW72AF011Accident · 2 fatalClosedPiper PA-18 · Broken Bow, OKAug 21, 1971 · N9571D · Destroyed NTSB FTW72DPJ09Accident · No injuriesClosedCessna 177 · Norman, OKAug 15, 1971 · N3274T · Substantial damage NTSB FTW72FPM04Accident · No injuriesClosedBeech D18S · Jenks, OKAug 9, 1971 · N80385 · Substantial damage NTSB FTW72FPJ08Accident · No injuriesClosedCessna 182G · Watonga, OKAug 4, 1971 · N3737U · Substantial damage NTSB FTW72FPJ11Accident · Serious injuriesClosedPiper PA-25 · Hardesty, OKAug 3, 1971 · N6115Z · Destroyed NTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKJul 31, 1971 · N6762S · Substantial damage NTSB FTW72DPJ06Accident · No injuriesClosedPiper PA-18 · Fort Sill, OKJul 31, 1971 · N6482D · Substantial damage NTSB FTW72DPJ05Accident · No injuriesClosedPiper PA-25 · Texhoma, OKJul 31, 1971 · N8687L · Substantial damage NTSB FTW72DPJ04Accident · No injuriesClosedCessna 195B · Gould, OKJul 23, 1971 · N3029B · Substantial damage NTSB FTW72DPJ03Accident · Minor injuriesClosedCessna 172 · Watonga, OKJul 16, 1971 · N1577Y · Substantial damage NTSB FTW72AF003Accident · 2 fatalClosedCessna 172 · Sasakwa, OKJul 12, 1971 · N5978R · Destroyed NTSB FTW72FPM02Accident · No injuriesClosedBellanca 14-13 · Collinsville, OKJul 10, 1971 · N86754 · Substantial damage NTSB FTW72DPM03Accident · No injuriesClosedPiper PA-28 · New Mannford, OKJul 9, 1971 · N7634J · Substantial damage NTSB FTW72FPJ02Accident · No injuriesClosedCessna 172 · Fort Supply, OKJul 5, 1971 · N3761L · Substantial damage NTSB FTW72FPM01Accident · Serious injuriesClosedCessna 150 · Wagoner, OKJul 3, 1971 · N50778 · Substantial damage