Skip to content

NTSB investigations, 1980, 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, 1980, 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") = 1980 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\") = 1980
    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") = 1980
  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 FTW81FA019Accident · 1 fatalClosedPiper PA-22 · Oklahoma City, OKDec 21, 1980 · N2524P · Destroyed NTSB FTW81FPM05Accident · Serious injuriesClosedMooney M20K · Afton, OKDec 17, 1980 · N231KX · Destroyed NTSB FTW81FPM03Accident · No injuriesClosedCessna R172K · Lenapah, OKNov 30, 1980 · N758BN · Substantial damage NTSB FTW81DPJ07Accident · No injuriesClosedCessna 150 · Beaver, OKNov 30, 1980 · N7723E · Substantial damage NTSB FTW81FPM04Accident · No injuriesClosedBeech E18S · Tulsa, OKNov 26, 1980 · N202GW · Substantial damage NTSB FTW81FPM02Accident · Minor injuriesClosedCessna 310Q · Tulsa, OKNov 11, 1980 · N69606 · Substantial damage NTSB FTW81DPJ06Accident · No injuriesClosedHughes 269B · Guymon, OKNov 8, 1980 · N9301F · Destroyed NTSB FTW81FPJ05Accident · No injuriesClosedMaule M-5 · Meno, OKNov 2, 1980 · N5638L · Substantial damage NTSB FTW81FPJ04Accident · Serious injuriesClosedAero Comdr 100 · Hobart, OKOct 26, 1980 · N3701X · Destroyed NTSB FTW81FPJ03Accident · Serious injuriesClosedPiper PA-38 · Hammon, OKOct 19, 1980 · N2476L · Destroyed NTSB FTW81FPJ02Accident · No injuriesClosedWaco YPF-7 · Oklahoma City, OKOct 19, 1980 · N32077 · Substantial damage NTSB FTW81FA005Accident · 4 fatalClosedGrum Amer AA-5B · Madill, OKOct 16, 1980 · N28252 · Destroyed NTSB FTW81FPJ01Accident · Minor injuriesClosedPiper PA-38 · Stillwater, OKOct 11, 1980 · N2592B · Destroyed NTSB FTW81FPM01Accident · 1 fatalClosedBenson B8M · Tulsa, OKOct 9, 1980 · N475 · Destroyed NTSB FTW80FA122Accident · 2 fatalClosedCessna 150L · Hendrix, OKSep 25, 1980 · N11424 · Destroyed NTSB FTW80FPJ36Accident · Serious injuriesClosedCessna 188B · Altus, OKSep 24, 1980 · N8979G · Destroyed NTSB FTW80FPJ34Accident · No injuriesClosedCessna 195B · Newcastle, OKSep 12, 1980 · N195JW · Substantial damage NTSB FTW80FPM19Accident · Serious injuriesClosedWeatherly 201C · Commerce, OKSep 4, 1980 · N9080W · Destroyed NTSB FTW80DPM18Accident · No injuriesClosedCessna 180 · Langley, OKAug 30, 1980 · N9211C · Destroyed NTSB FTW80FPM17Accident · No injuriesClosedPiper PA-25 · Henryetta, OKAug 23, 1980 · N9558P · Substantial damage NTSB FTW80FPJ32Accident · No injuriesClosedCessna 150G · Norman, OKAug 21, 1980 · N3661J · Substantial damage NTSB FTW81DPJ31Accident · No injuriesClosedScorpion 133 · Oklahoma City, OKAug 17, 1980 · N5586N · Substantial damage NTSB FTW80FPJ33Accident · No injuriesClosedBeech 23 · Griggs, OKAug 16, 1980 · N6017L · Destroyed NTSB FTW80FA105Accident · 2 fatalClosedCessna 172M · Caddo, OKAug 16, 1980 · N12906 · Destroyed NTSB FTW80FPM16Accident · No injuriesClosedCessna 182 · Sand Springs, OKJul 31, 1980 · N2474X · Substantial damage NTSB FTW80FPM15Accident · Serious injuriesClosedAngel SPL · Wagoner, OKJul 27, 1980 · N6929C · Substantial damage NTSB FTW80DPJ29Accident · No injuriesClosedCessna 172M · Hobart, OKJul 18, 1980 · N80117 · Substantial damage NTSB FTW80FPM13Accident · No injuriesClosedBell 206B · Tulsa, OKJul 17, 1980 · N17HC · Substantial damage NTSB FTW80FPM14Accident · 1 fatalClosedBell 47G · Calvin, OKJul 16, 1980 · N16657 · Destroyed NTSB FTW80FPM12Accident · Minor injuriesClosedCessna 172L · Leach, OKJun 29, 1980 · N7822G · Substantial damage NTSB FTW80DPJ27Accident · Minor injuriesClosedCessna 152 · Gage, OKJun 27, 1980 · N48976 · Substantial damage NTSB FTW80FPJ26Accident · Minor injuriesClosedCessna 177 · Watonga, OKJun 25, 1980 · N2167C · Substantial damage NTSB FTW80FPJ24Accident · 1 fatalClosedBenson B8M · Frederick, OKJun 20, 1980 · N4355 · Destroyed NTSB FTW80FPJ23Accident · Serious injuriesClosedCessna 195 · Lexington, OKJun 20, 1980 · N1585D · Substantial damage NTSB FTW80FA085Accident · 3 fatalClosedCessna 172N · Boise City, OKJun 15, 1980 · N4929G · Destroyed NTSB FTW80FPM11Accident · No injuriesClosedPiper PA-28 · Okmulgee, OKJun 8, 1980 · N44752 · Substantial damage NTSB FTW80FA083Accident · 1 fatalClosedCessna 172L · Boise City, OKJun 8, 1980 · N6808Q · Destroyed NTSB FTW80DPJ25Accident · No injuriesClosedCallair A-9B · Ponca City, OKJun 4, 1980 · N7798V · Substantial damage NTSB FTW80FPJ21Accident · No injuriesClosedCessna 152 · Grandfield, OKJun 3, 1980 · N757YQ · Substantial damage NTSB FTW80DPJ22Accident · No injuriesClosedGrumman G-164 · Fairview, OKJun 3, 1980 · N10256 · Substantial damage NTSB FTW80DPJ20Accident · No injuriesClosedHiller Acft HU-12D · Norman, OKMay 13, 1980 · N102BC · Substantial damage NTSB FTW80FPJ18Accident · Minor injuriesClosedCessna 182 · El Reno, OKMay 8, 1980 · N2412G · Substantial damage NTSB FTW80FA070Accident · 1 fatalClosedCessna 150 · Tulsa, OKMay 7, 1980 · N2970V · 2 aircraft · Destroyed NTSB FTW80FPJ17Accident · No injuriesClosedBellanca 8GCBC · Enid, OKMay 6, 1980 · N86782 · Destroyed NTSB FTW80FPJ16Accident · No injuriesClosedBrantly B-2 · Frederick, OKMay 3, 1980 · N2112U · Destroyed NTSB FTW80FPJ14Accident · No injuriesClosedCessna 188 · Olustee, OKApr 29, 1980 · N5635G · Substantial damage NTSB FTW80DPJ15Accident · No injuriesClosedErco 415 · Guthrie, OKApr 19, 1980 · N6588Q · Substantial damage NTSB FTW80FA062Accident · 1 fatalClosedPiper PA-28 · Wagoner, OKApr 9, 1980 · N8747N · Destroyed NTSB FTW80FPM10Accident · No injuriesClosedJunkster 1 · Tulsa, OKApr 7, 1980 · N451M · Substantial damage NTSB FTW80FPM09Accident · No injuriesClosedBeech 95-C55 · Tulsa, OKApr 7, 1980 · N5925S · Substantial damage