Skip to content

NTSB investigations, 1976, OK

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKDec 14, 1976 · N6278L · Destroyed NTSB FTW77FPJ04Accident · Minor injuriesClosedGrum Amer AA1 · Oklahoma City, OKDec 4, 1976 · N5732L · Substantial damage NTSB FTW77DPJ03Accident · No injuriesClosedAero Comdr 690A · Oklahoma City, OKDec 2, 1976 · N81491 · Substantial damage NTSB FTW77FPJ02Accident · Serious injuriesClosedErco 415-C · Chattanooga, OKNov 28, 1976 · N93786 · Destroyed NTSB FTW77FPJ01Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 25, 1976 · N5473R · Substantial damage NTSB FTW77FA009Accident · 1 fatalClosedCessna 177B · Oklahoma City, OKOct 25, 1976 · N515BC · Destroyed NTSB FTW77DA003Accident · 1 fatalClosedPitts Spcl S-1S · Durant, OKOct 11, 1976 · N7WH · 2 aircraft · Minor damage NTSB FTW76FPM01Accident · No injuriesClosedSikorsky S-55B · Tulsa, OKOct 1, 1976 · N2305 · Substantial damage NTSB FTW76DPD61Accident · No injuriesClosedPiper PA-28R · Idabel, OKSep 30, 1976 · N1986T · Substantial damage NTSB FTW76AF126Accident · 1 fatalClosedPiper PA-28 · Greenfield, OKSep 26, 1976 · N55481 · Destroyed NTSB FTW76FPM30Accident · Serious injuriesClosedHughes 269C · Vinita, OKSep 25, 1976 · N7453F · Destroyed NTSB FTW76FPM31Accident · No injuriesClosedCessna 150 · Yanush, OKSep 24, 1976 · N6626T · Substantial damage NTSB FTW76FPJ51Accident · Serious injuriesClosedMooney M20F · Norman, OKSep 18, 1976 · N9521M · Destroyed NTSB FTW76AF124Accident · 1 fatalClosedBellanca 17-30 · Eagletown, OKSep 18, 1976 · N4885V · Destroyed NTSB FTW76DPJ47Accident · No injuriesClosedCessna 177RG · Ada, OKSep 13, 1976 · N1814Q · Substantial damage NTSB FTW76AF121Accident · 1 fatalClosedCessna 150M · Kiefer, OKSep 13, 1976 · N45690 · Destroyed NTSB FTW76FPJ46Accident · Serious injuriesClosedBrantley 305 · Chattanooga, OKSep 11, 1976 · N2231U · Destroyed NTSB FTW77AF118Accident · 2 fatalClosedBoeing A75 · Stroud, OKAug 29, 1976 · TG-LCM · Destroyed NTSB FTW76FPJ48Accident · No injuriesClosedPitts S-1S · Stroud, OKAug 29, 1976 · N921P · Substantial damage NTSB FTW76FPM29Accident · Minor injuriesClosedCessna 177 · Tulsa, OKAug 18, 1976 · N2283Y · Destroyed NTSB FTW76FPJ41Accident · No injuriesClosedGreat Lakes 2T-1A · Hunter, OKAug 18, 1976 · N508GL · Substantial damage NTSB FTW76DPJ49Accident · Minor injuriesClosedBell 47G-2 · Elgin, OKAug 14, 1976 · N13299 · Destroyed NTSB FTW76FPJ50Accident · Serious injuriesClosedCessna 172 · Hooker, OKAug 5, 1976 · N2534L · Destroyed NTSB FTW76DPJ43Accident · Minor injuriesClosedAeronca 7FC · Thomas, OKJul 31, 1976 · N8952R · Destroyed NTSB FTW76FPJ44Accident · Serious injuriesClosedCessna 402B · Elk City, OKJul 23, 1976 · N3775C · Substantial damage NTSB FTW76DPJ42Accident · Minor injuriesClosedBellanca 14-19 · Duncan, OKJul 20, 1976 · N7611E · Substantial damage NTSB FTW76FPJ40Accident · Minor injuriesClosedBellanca 8KCAB · Guthrie, OKJul 16, 1976 · N53915 · Destroyed NTSB FTW76FPJ39Accident · Serious injuriesClosedPiper PA-22 · Randlett, OKJul 15, 1976 · N6160D · Destroyed NTSB FTW76FPM27Accident · No injuriesClosedBeech 95-A55 · Grove, OKJul 2, 1976 · N920Q · Substantial damage NTSB FTW76DPJ37Accident · No injuriesClosedBoeing E75 · Sickles, OKJun 29, 1976 · N5188N · Substantial damage NTSB FTW76FPM27Accident · Minor injuriesClosedAmer Avco AA1-B · Jenks, OKJun 28, 1976 · N8956L · Substantial damage NTSB FTW76AF103Accident · 3 fatalClosedCessna 172M · Sperry, OKJun 18, 1976 · N13132 · 2 aircraft · Destroyed NTSB FTW76AF102Accident · 1 fatalClosedChampion 7KCAB · Goldsby, OKJun 15, 1976 · N5198X · Destroyed NTSB FTW76DPM26Accident · No injuriesClosedHughes 369HS · Vinita, OKJun 7, 1976 · N500PA · Substantial damage NTSB FTW76DPM25Accident · Serious injuriesClosedCessna 150 · Chelsea, OKJun 3, 1976 · N3579L · No damage NTSB FTW76DPJ38Accident · No injuriesClosedPiper PA-28 · Boise City, OKJun 3, 1976 · N8749N · Substantial damage NTSB FTW76DPM24Accident · No injuriesClosedBell 47G-4 · Kingston, OKJun 2, 1976 · N1157W · Substantial damage NTSB FTW76DPJ35Accident · No injuriesClosedCessna 150 · Clinton, OKMay 28, 1976 · N8054F · Substantial damage NTSB FTW76FPM23Accident · No injuriesClosedBeech 23 · Leonard, OKMay 23, 1976 · N2371J · Substantial damage NTSB FTW76FPJ34Accident · No injuriesClosedBell 47G · Oklahoma City, OKMay 20, 1976 · N379B · Destroyed NTSB FTW76FPM22Accident · 1 fatalClosedCessna 172F · Jenks, OKMay 14, 1976 · N8656U · No damage NTSB FTW76FPM21Accident · No injuriesClosedPiper PA-25 · Caddo, OKMay 12, 1976 · N6457Z · Substantial damage NTSB FTW76AF095Accident · 3 fatalClosedBeech 95 · Ardmore, OKMay 12, 1976 · N367B · Destroyed NTSB FTW76FPM20Accident · No injuriesClosedPiper PA-18 · Pryor Creek, OKMay 11, 1976 · N6767B · Substantial damage NTSB FTW76FPJ33Accident · No injuriesClosedBeech 23 · Lawton, OKMay 9, 1976 · N6077N · Substantial damage NTSB FTW76FPM19Accident · No injuriesClosedPiper PA-28 · Quinton, OKMay 4, 1976 · N15906 · Substantial damage NTSB FTW76DPJ32Accident · Serious injuriesClosedPiper PA-25 · Mcqueen, OKApr 29, 1976 · N6256Z · Destroyed NTSB FTW76AF090Accident · 3 fatalClosedCessna 310 · Ardmore, OKApr 27, 1976 · N1122Q · Destroyed NTSB FTW76DPJ36Accident · No injuriesClosedPiper PA-24 · Elk City, OKApr 26, 1976 · N6630P · Substantial damage NTSB FTW76DPJ31Accident · No injuriesClosedCessna 182 · Custer, OKApr 25, 1976 · N8426S · Substantial damage