Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 FTW78FPJ10Accident · No injuriesClosedPiper PA-32 · Oklahoma City, OKDec 22, 1977 · N3476W · Substantial damage NTSB FTW78DPM02Accident · No injuriesClosedCessna 150 · Claremore, OKDec 22, 1977 · N9141U · Substantial damage NTSB FTW78FPJ09Accident · No injuriesClosedPiper PA-24 · Oklahoma City, OKDec 14, 1977 · N8636P · Substantial damage NTSB FTW78FA014Accident · 1 fatalClosedPiper PA-28 · Langley, OKDec 4, 1977 · N41737 · Destroyed NTSB FTW78DPM01Accident · No injuriesClosedPiper PA-28 · Big Cedar, OKNov 30, 1977 · N8261N · Substantial damage NTSB FTW78FPJ08Accident · Minor injuriesClosedPiper PA-22 · Victory, OKNov 26, 1977 · N5921Z · Destroyed NTSB FTW78FPJ07Accident · No injuriesClosedBellanca 14-19 · Oklahoma City, OKNov 7, 1977 · N9817B · Substantial damage NTSB FTW78FA010Accident · Serious injuriesClosedPiper PA-34 · Tulsa, OKNov 6, 1977 · N33041 · Destroyed NTSB FTW78FPJ05Accident · 1 fatalClosedCessna A188B · Thomas, OKNov 3, 1977 · N4833R · Destroyed NTSB FTW78FPJ06Accident · Serious injuriesClosedCessna 172 · Nobel, OKOct 29, 1977 · N733DK · Destroyed NTSB FTW78FPJ04Accident · 1 fatalClosedPiper PA-36 · Garber, OKOct 25, 1977 · N57782 · Destroyed NTSB FTW78FA006Accident · 2 fatalClosedPiper PA-30 · Wetumka, OKOct 23, 1977 · N7623Y · Destroyed NTSB FTW78FPJ03Accident · No injuriesClosedCessna 177RG · Willow, OKOct 22, 1977 · N1594H · Substantial damage NTSB FTW78FA004Accident · 2 fatalClosedCessna 150L · Dewey, OKOct 16, 1977 · N1632Q · Destroyed NTSB FTW78FA001Accident · 5 fatalClosedPilatus PC6CH2 · Oklahoma City, OKOct 5, 1977 · N331V · Destroyed NTSB FTW78DPJ01Accident · No injuriesClosedCessna A188B · Albert, OKOct 5, 1977 · N6090G · Substantial damage NTSB FTW77FPJ37Accident · Minor injuriesClosedCessna 150 · Enid, OKSep 25, 1977 · N10854 · Destroyed NTSB FTW77FPJ35Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKSep 14, 1977 · N16547 · Substantial damage NTSB FTW77FA074Accident · 3 fatalClosedBeech V35A · Idabel, OKSep 12, 1977 · N800SC · Destroyed NTSB FTW77FPM21Accident · Minor injuriesClosedCessna 150 · Tulsa, OKSep 4, 1977 · N6686F · Substantial damage NTSB FTW77DPJ33Accident · Minor injuriesClosedCessna 177D · Waynoka, OKSep 3, 1977 · N34607 · Substantial damage NTSB FTW77DPJ34Accident · No injuriesClosedBell 206L · El Reno, OKSep 1, 1977 · N66LJ · Substantial damage NTSB FTW77FA073Accident · 3 fatalClosedPiper PA-28R · Hugo, OKAug 28, 1977 · N33862 · Destroyed NTSB FTW77FPM19Accident · No injuriesClosedAeronca 11AC · Tulsa, OKAug 23, 1977 · N9153E · Substantial damage NTSB FTW77FPM20Accident · Serious injuriesClosedJodette JD-9 · Wagoner, OKAug 21, 1977 · N2811J · Substantial damage NTSB FTW77FPM18Accident · No injuriesClosedHughes 269A · Council Hill, OKAug 21, 1977 · N8716F · Substantial damage NTSB FTW77FPJ38Accident · No injuriesClosedPiper PA-28 · Oklahoma City, OKAug 21, 1977 · N5790W · Substantial damage NTSB FTW77FA071Accident · 1 fatalClosedPiper PA-28R · Healdton, OKAug 19, 1977 · N38140 · Destroyed NTSB FTW77FA068Accident · Serious injuriesClosedHoward 500 · Pawhuska, OKAug 13, 1977 · N44HH · Destroyed NTSB FTW77FPM17Accident · No injuriesClosedCessna 150 · Tulsa, OKAug 2, 1977 · N6341K · Substantial damage NTSB FTW77DPJ32Accident · No injuriesClosedCessna 150 · Olustee, OKJul 24, 1977 · N66636 · Substantial damage NTSB FTW77FPM16Accident · No injuriesClosedCessna 150 · Tulsa, OKJul 20, 1977 · N704NS · Substantial damage NTSB FTW77FPJ31Accident · No injuriesClosedCessna 337G · Oklahoma City, OKJul 17, 1977 · N72473 · Substantial damage NTSB FTW77DPJ30Accident · No injuriesClosedGrumman G-164B · Carnegie, OKJul 15, 1977 · N6616Q · Destroyed NTSB FTW77FPJ29Accident · Minor injuriesClosedVolksplane VP-1 · Oklahoma City, OKJul 9, 1977 · N64619 · Substantial damage NTSB FTW77FPJ28Accident · Minor injuriesClosedPiper J3C-65 · Yukon, OKJul 3, 1977 · N87791 · Substantial damage NTSB FTW77FPM15Accident · No injuriesClosedCessna 120 · Bristow, OKJul 2, 1977 · N3067N · Substantial damage NTSB FTW77FPJ27Accident · No injuriesClosedCessna 172L · Cherokee, OKJul 1, 1977 · N1091M · Substantial damage NTSB FTW77DPJ24Accident · No injuriesClosedCessna 182 · Felts, OKJul 1, 1977 · N21074 · Substantial damage NTSB FTW77DPJ25Accident · No injuriesClosedSchweizer SGS233 · Lawton, OKJun 25, 1977 · N7757S · Substantial damage NTSB FTW77FPM14Accident · No injuriesClosedBeech C23 · Afton, OKJun 17, 1977 · N9294S · Substantial damage NTSB FTW77DPJ23Accident · No injuriesClosedRockwell S2R · Tyrone, OKJun 17, 1977 · N5615X · Substantial damage NTSB FTW77FPM13Accident · No injuriesClosedBell 47G · Copan, OKJun 15, 1977 · N16657 · Substantial damage NTSB FTW77DDJ22Accident · No injuriesClosedCessna 177 · Cache, OKJun 12, 1977 · N30144 · Substantial damage NTSB FTW77FPM12Accident · Minor injuriesClosedCessna 177 · Sapulpa, OKJun 9, 1977 · N3466T · Substantial damage NTSB FTW77FPJ20Accident · Serious injuriesClosedCessna A188B · Cherokee, OKJun 3, 1977 · N8210G · Destroyed NTSB FTW77DPJ21Accident · Minor injuriesClosedCessna A188 · Lawton, OKJun 3, 1977 · N9367R · Substantial damage NTSB FTW77FPJ19Accident · Minor injuriesClosedPiper PA-25 · Perry, OKJun 2, 1977 · N6452Z · Substantial damage NTSB FTW77FPM11Accident · No injuriesClosedPiper PA-25 · Pryor, OKMay 28, 1977 · N4646Y · Substantial damage NTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKMay 24, 1977 · N6355H · Destroyed