Skip to content

NTSB investigations, 1974, OK

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1974, OK per year, 1964–2026: 2,799 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	14

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") = 1974 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\") = 1974
    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") = 1974
  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 FTW75FPM09Accident · No injuriesClosedPiper PA-24 · Tulsa, OKDec 25, 1974 · N5008P · Substantial damage NTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKDec 2, 1974 · N51408 · Substantial damage NTSB FTW75FPJ13Accident · Minor injuriesClosedTaylorcraft BL · Poolville, OKDec 1, 1974 · N22283 · Substantial damage NTSB FTW75AF033Accident · 2 fatalClosedPiper PA-24 · Tulsa, OKNov 16, 1974 · N6922P · Destroyed NTSB FTW75FRJ10Accident · No injuriesClosedPiper PA-16 · Fairview, OKNov 11, 1974 · N5985H · Substantial damage NTSB FTW75FPJ12Accident · No injuriesClosedWittman W-8 · Fairview, OKNov 11, 1974 · N2834 · Substantial damage NTSB FTW75FPJ11Accident · Serious injuriesClosedPiper J-3 · Fairview, OKNov 11, 1974 · N1504N · Destroyed NTSB FTW75AF029Accident · 2 fatalClosedPiper PA-31 · Blair, OKOct 24, 1974 · N979L · Destroyed NTSB FTW75FPM10Accident · 1 fatalClosedCessna 310D · Tulsa, OKOct 16, 1974 · N310F · Substantial damage NTSB FTW75FPM08Accident · Minor injuriesClosedPiper PA-28 · Beggs, OKOct 1, 1974 · N9895W · Substantial damage NTSB FTW75DPJ07Accident · No injuriesClosedAmer Avco AA5 · Yukon, OKSep 30, 1974 · N9599L · Substantial damage NTSB FTW75DPJ08Accident · No injuriesClosedPiper PA-34 · Early, OKSep 29, 1974 · N16397 · Substantial damage NTSB FTW75DPJ09Accident · No injuriesClosedCessna 305A · Oklahoma Cty, OKSep 28, 1974 · N5228G · Substantial damage NTSB FTW75FPM07Accident · No injuriesClosedLuscombe 8A · Muskogee, OKSep 21, 1974 · N2685K · Substantial damage NTSB FTW75FPJ06Accident · Minor injuriesClosedCessna 182A · Stroud, OKSep 21, 1974 · N5945B · Substantial damage NTSB FTW75FPM06Accident · Minor injuriesClosedPiper PA-28 · Westport, OKSep 15, 1974 · N41763 · Substantial damage NTSB FTW75FPM05Accident · No injuriesClosedTern II · Tulsa, OKSep 14, 1974 · N250Z · Destroyed NTSB FTW75DPJ05Accident · No injuriesClosedPiper PA-16 · Ardmore, OKSep 14, 1974 · N5757H · Substantial damage NTSB FTW75AF019Accident · 1 fatalClosedBeech C23 · Stillwell, OKSep 12, 1974 · N24606 · Destroyed NTSB FTW75AK018Accident · 3 fatalClosedAero Comdr 100 · Inola, OKSep 10, 1974 · N2970T · Destroyed NTSB FTW75FPM04Accident · Minor injuriesClosedCessna A188B · Atoka, OKAug 31, 1974 · N8638G · Destroyed NTSB FTW75FPM03Accident · Serious injuriesClosedPiper PA-28 · Hugo, OKAug 31, 1974 · N8978J · Destroyed NTSB FTW75DPJ04Accident · No injuriesClosedPiper PA-28 · Duke, OKAug 30, 1974 · N8017N · Substantial damage NTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKAug 24, 1974 · N19030 · Substantial damage NTSB FTW75FPM01Accident · Serious injuriesClosedBellanca 17-30A · Shidler, OKAug 13, 1974 · N39830 · Substantial damage NTSB FTW75DPJ03Accident · No injuriesClosedCessna 180B · Medford, OKAug 7, 1974 · N5129E · Substantial damage NTSB FTW75DPJ01Accident · No injuriesClosedAir & Space 18A · Boise City, OKJul 24, 1974 · N6121S · Substantial damage NTSB FTW75DPJ02Accident · No injuriesClosedPiper PA-25 · Felt, OKJul 18, 1974 · N6997Z · Substantial damage NTSB FTW74FPM30Accident · No injuriesClosedHuffman 1 · Okmulgee, OKJun 22, 1974 · N2MH · Substantial damage NTSB FTW74FPM29Accident · No injuriesClosedEL Tomcat 47 · Zafra, OKJun 19, 1974 · N4227A · Destroyed NTSB FTW74DPM28Accident · No injuriesClosedGrumman G-164 · Atoka, OKJun 17, 1974 · N481Y · Substantial damage NTSB FTW74DPJ32Accident · Minor injuriesClosedPiper PA-34 · Duncan, OKJun 15, 1974 · N16575 · Destroyed NTSB FTW74DPJ31Accident · No injuriesClosedBeech V35 · Oklahoma Cty, OKJun 15, 1974 · N2789T · Substantial damage NTSB FTW74DPJ30Accident · No injuriesClosedCessna 182 · Perry, OKJun 15, 1974 · N1861X · Substantial damage NTSB FTW74FPM27Accident · No injuriesClosedCessna 188B · Dustin, OKJun 13, 1974 · N9541G · Destroyed NTSB FTW74FPJ29Accident · No injuriesClosedCessna 210 · Oklahoma Cty, OKJun 1, 1974 · N4680Q · Destroyed NTSB FTW74AF087Accident · 2 fatalClosedCessna 140 · Sand Springs, OKMay 27, 1974 · N76819 · Destroyed NTSB FTW74DPJ33Accident · No injuriesClosedPiper J-3 · Alva, OKMay 26, 1974 · N33201 · Substantial damage NTSB FTW74FDJ28Accident · Serious injuriesClosedCessna 185E · Yukon, OKMay 22, 1974 · N185LK · Destroyed NTSB FTW74DPM26Accident · No injuriesClosedBellanca 7KCAB · Okemah, OKMay 12, 1974 · N5099X · Substantial damage NTSB FTW74FPJ27Accident · Serious injuriesClosedAmer Avco AA1-B · Oklahoma Cty, OKMay 4, 1974 · N6261L · Substantial damage NTSB FTW74AF078Accident · 3 fatalClosedPiper PA-28 · Honobia, OKMay 3, 1974 · N6449J · Destroyed NTSB FTW74DPM25Accident · Minor injuriesClosedCessna 180 · Honobia, OKMay 2, 1974 · VP-HCC · Destroyed NTSB FTW74DPM23Accident · No injuriesClosedCessna 172 · Honobia, OKMay 2, 1974 · N3801R · Substantial damage NTSB FTW74FPM24Accident · Serious injuriesClosedCessna 172M · Bunch, OKMay 1, 1974 · N12093 · Substantial damage NTSB FTW74DPM22Accident · No injuriesClosedCessna 182D · Zafra, OKApr 29, 1974 · N9991T · Substantial damage NTSB FTW74DPJ26Accident · No injuriesClosedCessna 177 · Eakly, OKApr 24, 1974 · N30317 · Substantial damage NTSB FTW74DPJ25Accident · No injuriesClosedCessna 180 · Stroud, OKApr 19, 1974 · N7881A · Substantial damage NTSB FTW74DPJ24Accident · No injuriesClosedCessna U206F · Oklahoma Cty, OKApr 6, 1974 · N9610G · Substantial damage NTSB FTW74FPM21Accident · Minor injuriesClosedAeronca 7AC · Madill, OKMar 16, 1974 · N85391 · Substantial damage