Skip to content

NTSB investigations, 1979, OK

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 FTW80DPM06Accident · Minor injuriesClosedMaule M-5 · Vinitta, OKDec 26, 1979 · N51624 · Substantial damage NTSB FTW80FPJ05Accident · No injuriesClosedPiper PA-38 · Guymon, OKDec 8, 1979 · N4387E · Substantial damage NTSB FTW80FPJ06Accident · No injuriesClosedBeech J35 · Wellston, OKDec 7, 1979 · N3018C · Substantial damage NTSB FTW80FA020Accident · Serious injuriesClosedPiper PA-32 · Harrah, OKDec 5, 1979 · N4097R · Destroyed NTSB FTW80FPM05Accident · No injuriesClosedCessna 152 · Tulsa, OKDec 1, 1979 · N25475 · Substantial damage NTSB FTW80FPJ04Accident · No injuriesClosedCessna 172K · Norman, OKNov 24, 1979 · N84907 · Substantial damage NTSB FTW80FPM03Accident · 1 fatalClosedBenson B8M · Sand Springs, OKNov 19, 1979 · N6933 · Destroyed NTSB FTW80DPJ35Accident · No injuriesClosedCessna 120 · Leedey, OKNov 14, 1979 · N90085 · Substantial damage NTSB FTW80FPM04Accident · Minor injuriesClosedNavion B · Smithville, OKNov 8, 1979 · N4860K · Substantial damage NTSB FTW80FPJ03Accident · 2 fatalClosedMustang II · Nedmond, OKNov 3, 1979 · N9056U · Destroyed NTSB FTW80FPM02Accident · No injuriesClosedCessna 188B · Henryetta, OKOct 19, 1979 · N4727Q · Destroyed NTSB FTW80DPM01Accident · No injuriesClosedMaule M-5 · Henryetta, OKOct 9, 1979 · N6194M · Substantial damage NTSB FTW80DPJ01Accident · No injuriesClosedBrantly B-2B · Guymon, OKOct 1, 1979 · N2191U · Substantial damage NTSB FTW79DPJ39Accident · Minor injuriesClosedBeech 23 · Waukomis, OKSep 30, 1979 · N2332L · Substantial damage NTSB FTW79FPM16Accident · No injuriesClosedPitts S-1C · Bartlesville, OKSep 29, 1979 · N111CW · Substantial damage NTSB FTW79FPM17Accident · No injuriesClosedErco 415-C · Atoka, OKSep 28, 1979 · N99813 · Substantial damage NTSB FTW79FPM15Accident · No injuriesClosedPiper PA-28R · Tulsa, OKSep 27, 1979 · N1073X · Substantial damage NTSB FTW79DPJ38Accident · No injuriesClosedCessna R172K · El Reno, OKSep 19, 1979 · N4634K · Substantial damage NTSB FTW79FPM14Accident · No injuriesClosedPiper PA-28 · Tahlequah, OKSep 13, 1979 · N7049W · Substantial damage NTSB FTW79DPJ37Accident · No injuriesClosedBell 47D1 · Ardmore, OKSep 12, 1979 · N3575 · Substantial damage NTSB FTW79FPM13Accident · Minor injuriesClosedPiper PA-38 · Mannford, OKAug 25, 1979 · N9700T · Destroyed NTSB FTW79DPJ36Accident · No injuriesClosedPiper PA-22 · Pauls Valley, OKAug 21, 1979 · N652A · Destroyed NTSB FTW79DPJ38Accident · Serious injuriesClosedPiper PA-22 · O'Keene, OKAug 8, 1979 · N3808P · Substantial damage NTSB FTW79DPJ34Accident · No injuriesClosedPiper PA-25 · Boise City, OKAug 6, 1979 · N9580P · Substantial damage NTSB FTW79DPJ33Accident · No injuriesClosedBellanca 7KCAB · Lawton, OKJul 29, 1979 · N8509 · Substantial damage NTSB FTW79FPM12Accident · Serious injuriesClosedErco 415-CD · Grove, OKJul 27, 1979 · N3224H · No damage NTSB FTW79DPJ31Accident · No injuriesClosedPiper PA-25 · Hollis, OKJul 27, 1979 · N7756Z · Substantial damage NTSB FTW79DPJ32Accident · No injuriesClosedCessna 150G · Anadarko, OKJul 26, 1979 · N3248X · Substantial damage NTSB FTW79FA028Accident · 2 fatalClosedCessna T210N · Kingfisher, OKJul 22, 1979 · N5364A · Destroyed NTSB FTW79DA095Accident · 1 fatalClosedCessna 150J · Crescent, OKJul 16, 1979 · N51008 · Destroyed NTSB FTW80DPJ29Accident · No injuriesClosedPiper PA-25 · Clinton, OKJul 10, 1979 · N9582P · Substantial damage NTSB FTW79FPM11Accident · Serious injuriesClosedPiper PA-25 · Coweta, OKJul 2, 1979 · N46084 · Substantial damage NTSB FTW79DPJ25Accident · No injuriesClosedCessna 152 · Lawton, OKJun 23, 1979 · N47053 · Substantial damage NTSB FTW79FPJ26Accident · Minor injuriesClosedHiller UH12L4 · Elk City, OKJun 22, 1979 · N90453 · Substantial damage NTSB FTW79FPM10Accident · No injuriesClosedCessna 150 · Vinita, OKJun 10, 1979 · N50254 · Substantial damage NTSB FTW79FPJ24Accident · Serious injuriesClosedNavion 8 · Edmond, OKJun 6, 1979 · N5391K · Substantial damage NTSB FTW79FPM09Accident · Minor injuriesClosedPiper PA-25 · Chouteau, OKMay 31, 1979 · N7161Z · Destroyed NTSB FTW79FPJ23Accident · No injuriesClosedBalloon WKS FRFLY7 · Norman, OKMay 31, 1979 · N2451H · Substantial damage NTSB FTW79DPJ20Accident · Minor injuriesClosedPiper PA-25 · Tonkawa, OKMay 29, 1979 · N8624L · Substantial damage NTSB FTW79DPJ22Accident · No injuriesClosedPiper PA-25 · Perkins, OKMay 28, 1979 · N6436Z · Substantial damage NTSB FTW79FPJ19Accident · 1 fatalClosedPiper PA-36 · Boise City, OKMay 27, 1979 · N9978P · Destroyed NTSB FTW79FA082Accident · 1 fatalClosedBellanca 7KCAB · Morris, OKMay 27, 1979 · N1077E · Destroyed NTSB FTW79DPJ21Accident · No injuriesClosedCessna A188B · Cushing, OKMay 26, 1979 · N8358G · Substantial damage NTSB FTW79DPJ18Accident · Minor injuriesClosedCessna 150 · Shawnee, OKMay 24, 1979 · N9170U · Substantial damage NTSB FTW79DPJ17Accident · No injuriesClosedGrumman G-164B · Ft.Cobb, OKMay 16, 1979 · N6686Q · Substantial damage NTSB FTW79DPJ16Accident · No injuriesClosedPiper PA-25 · Sharon, OKMay 11, 1979 · N4742Y · Substantial damage NTSB FTW79DPJ15Accident · Minor injuriesClosedHughes 269A · Alva, OKMay 5, 1979 · N8892F · Substantial damage NTSB FTW79FPJ13Accident · No injuriesClosedCessna 172 · Minco, OKApr 27, 1979 · N5233F · Substantial damage NTSB FTW79FPJ12Accident · 1 fatalClosedPiper PA-28 · Purcell, OKApr 26, 1979 · N8530W · Destroyed NTSB FTW79FA075Accident · 2 fatalClosedPiper PA-20 · Tulsa, OKApr 21, 1979 · N189N · Destroyed