Skip to content

NTSB investigations, 1975, OK

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 FTW76FPJ21Accident · No injuriesClosedPiper PA-32 · Stroud, OKDec 31, 1975 · N8640N · Substantial damage NTSB FTW76DPJ20Accident · No injuriesClosedCessna 182 · Goldsby, OKDec 21, 1975 · N2005X · Substantial damage NTSB FTW76DPJ17Accident · No injuriesClosedTaylorcraft 19 · Oklahoma City, OKDec 14, 1975 · N3551T · Substantial damage NTSB FTW76FPJ19Accident · No injuriesClosedHiller Acft UH-12A · Ada, OKDec 13, 1975 · N8117H · Substantial damage NTSB FTW76FPJ18Accident · Minor injuriesClosedBrantly B2B · Frederick, OKDec 9, 1975 · N2180U · Substantial damage NTSB FTW76AF046Accident · 1 fatalClosedBeech V35A · Davenport, OKNov 21, 1975 · N7798R · Destroyed NTSB FTW76FPM11Accident · No injuriesClosedLuscombe T8F · Mcalester, OKNov 15, 1975 · N1847B · Substantial damage NTSB FTW76FPM10Accident · Minor injuriesClosedBoeing A75N1 · Blanco, OKNov 9, 1975 · N62146 · Substantial damage NTSB FTW76DPJ16Accident · No injuriesClosedCessna 205 · Norman, OKNov 4, 1975 · OB-T-944 · Substantial damage NTSB FTW76FPM12Accident · No injuriesClosedMooney M20C · Tulsa, OKNov 2, 1975 · N7865V · Substantial damage NTSB FTW76DPJ15Accident · No injuriesClosedLuscombe 8A · Waukomis, OKOct 27, 1975 · N37005 · Substantial damage NTSB FTW76DPJ14Accident · No injuriesClosedCessna 180B · Blackwell, OKOct 27, 1975 · N4US · Substantial damage NTSB FTW76FPM09Accident · No injuriesClosedGrum Amer AA5 · Grove, OKOct 5, 1975 · N5470L · Substantial damage NTSB FTW76FPJ13Accident · No injuriesClosedPiper PA-28 · Hennessey, OKOct 2, 1975 · N6143W · Substantial damage NTSB FTW76FPM08Accident · Minor injuriesClosedBoeing A75N1 · Hartsharne, OKSep 21, 1975 · N49709 · Substantial damage NTSB FTW76FPM07Accident · No injuriesClosedCessna 170B · Tahlequah, OKSep 17, 1975 · N2551C · Substantial damage NTSB FTW76FPM06Accident · No injuriesClosedBellanca 7ECA · Keifer, OKSep 3, 1975 · N90968 · Substantial damage NTSB FTW76DPJ11Accident · No injuriesClosedCessna A188B · Albert, OKSep 1, 1975 · N53144 · Substantial damage NTSB FTW76AF016Accident · 5 fatalClosedPiper PA-32 · Davis, OKAug 31, 1975 · N95593 · Destroyed NTSB FTW76FPJ10Accident · 1 fatalClosedBoeing E75 · Fort Cobb, OKAug 30, 1975 · N1771B · Substantial damage NTSB FTW76FPJ09Accident · Serious injuriesClosedBreezy CSA1 · Oklahoma City, OKAug 29, 1975 · N1CH · Destroyed NTSB FTW76DPJ08Accident · No injuriesClosedBeech 23 · Okalhoma City, OKAug 25, 1975 · N69RW · Substantial damage NTSB FTW76FPJ07Accident · Minor injuriesClosedPiper PA-28R · Cushing, OKAug 20, 1975 · N4999J · Substantial damage NTSB FTW75DPJ06Accident · Minor injuriesClosedGrumman G-164 · Pauls Valley, OKAug 15, 1975 · N957X · Substantial damage NTSB FTW76AF010Accident · 2 fatalClosedAmer Avco AA1-B · Beggs, OKAug 10, 1975 · N9623L · Destroyed NTSB FTW75DPJ05Accident · No injuriesClosedPiper PA-28 · Goldsby, OKAug 5, 1975 · N5552W · Substantial damage NTSB FTW76DPJ04Accident · No injuriesClosedCessna 150G · Marlow, OKJul 31, 1975 · N3830J · Destroyed NTSB FTW75FPM05Accident · No injuriesClosedBoeing A75 · Tishomingo, OKJul 29, 1975 · N562 · Substantial damage NTSB FTW76FPJ03Accident · 1 fatalClosedCallair A-9 · Guymon, OKJul 26, 1975 · N9649Z · Destroyed NTSB FTW76FPM04Accident · 1 fatalClosedCessna 210L · Nowata, OKJul 17, 1975 · N59102 · Destroyed NTSB FTW76FPM03Accident · Serious injuriesClosedPiper PA-28 · Tulsa, OKJul 17, 1975 · N98350 · Substantial damage NTSB FTW76FPM02Accident · No injuriesClosedBeech G33 · Okmulgee, OKJul 15, 1975 · N9270Q · Substantial damage NTSB FTW76FPJ02Accident · Minor injuriesClosedCessna 182B · Norman, OKJul 11, 1975 · N2732G · Substantial damage NTSB FTW76FPM01Accident · Minor injuriesClosedCessna 120 · Sand Springs, OKJul 4, 1975 · N1886N · Substantial damage NTSB FTW76FPJ01Accident · No injuriesClosedCessna 182H · Hydro, OKJul 2, 1975 · N2362X · Substantial damage NTSB FTW76AF001Accident · 2 fatalClosedBeech C-45H · Tulsa, OKJul 2, 1975 · N9911Z · Destroyed NTSB FTW75FPJ27Accident · 1 fatalClosedCessna 172A · Enid, OKJun 28, 1975 · N7686T · Destroyed NTSB FTW75DPJ26Accident · No injuriesClosedCessna 150A · Ada, OKJun 26, 1975 · N13888 · Substantial damage NTSB FTW75DPM20Accident · No injuriesClosedBoeing A75 · Allen, OKJun 24, 1975 · N51854 · Substantial damage NTSB FTW75FPM19Accident · No injuriesClosedCessna 150F · Kansas, OKJun 21, 1975 · N3028X · Substantial damage NTSB FTW75DPJ24Accident · Serious injuriesClosedPiper PA-18 · Hough, OKJun 7, 1975 · N7301L · Destroyed NTSB FTW75AF071Accident · 2 fatalClosedPiper PA-22 · Gore, OKJun 6, 1975 · N7030D · Destroyed NTSB FTW75DPJ23Accident · No injuriesClosedPiper PA-28 · Beaver, OKMay 27, 1975 · N5227L · Substantial damage NTSB FTW75FPM18Accident · Minor injuriesClosedBensen B-8M · Bartlesville, OKMay 18, 1975 · N4355 · Substantial damage NTSB FTW75FPM17Accident · No injuriesClosedCessna 180 · Ketchum, OKMay 4, 1975 · N2188Z · Substantial damage NTSB FTW75FPJ22Accident · No injuriesClosedCessna 172 · Ada, OKMay 3, 1975 · N6035A · Substantial damage NTSB FTW75DPJ21Accident · No injuriesClosedCessna 180 · Ringling, OKApr 25, 1975 · N2935A · Substantial damage NTSB FTW75FPM16Accident · No injuriesClosedWillie II · Tulsa, OKApr 21, 1975 · N113BT · Destroyed NTSB FTW75FPM15Accident · No injuriesClosedPiper PA-28 · Boley, OKApr 20, 1975 · N5329S · Substantial damage NTSB FTW75FPM14Accident · No injuriesClosedMarrs Midget · Tulsa, OKApr 5, 1975 · N54044 · Substantial damage