Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 FTW74FPM16Accident · No injuriesClosedCessna 150K · Sand Springs, OKDec 26, 1973 · N6032G · No damage NTSB FTW74FPM15Accident · No injuriesClosedHughes 269B · Tulsa, OKDec 22, 1973 · N11XC · Substantial damage NTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKDec 18, 1973 · N14099 · Destroyed NTSB FTW74AF043Accident · 2 fatalClosedAeronca 7BCM · Grainola, OKDec 16, 1973 · N75068 · Destroyed NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB FTW74FPM14Accident · No injuriesClosedBoeing A75 · Tulsa, OKDec 14, 1973 · N61492 · Substantial damage NTSB FTW74AF041Accident · No injuriesClosedBeech E18S · Oklahoma Cty, OKDec 13, 1973 · N2939B · Substantial damage NTSB FTW74FPJ17Accident · No injuriesClosedPiper PA-32 · Stillwater, OKDec 9, 1973 · N8953N · Substantial damage NTSB FTW74FPJ15Accident · No injuriesClosedCessna 177 · Norman, OKDec 2, 1973 · N3274T · Substantial damage NTSB FTW74FPJ14Accident · No injuriesClosedPiper PA-28 · Sayre, OKNov 29, 1973 · N8540N · Substantial damage NTSB FTW74FPJ13Accident · Minor injuriesClosedAeronca 7AC · Wynnewood, OKNov 27, 1973 · N1020E · Substantial damage NTSB FTW74AF037Accident · 1 fatalClosedCessna 180B · Enid, OKNov 23, 1973 · N5083E · Destroyed NTSB FTW74FPM11Accident · No injuriesClosedPiper PA-24 · Tulsa, OKNov 18, 1973 · N8272P · Substantial damage NTSB FTW74FPM12Accident · 2 fatalClosedCameron Skyblt · Sand Springs, OKNov 10, 1973 · N711PC · Destroyed NTSB FTW74FPM10Accident · Serious injuriesClosedMooney M22 · Sand Springs, OKNov 5, 1973 · N7737M · Destroyed NTSB FTW74FPJ12Accident · Serious injuriesClosedBeech 35-33 · Cushing, OKNov 2, 1973 · N938T · Destroyed NTSB FTW74AF025Accident · 2 fatalClosedCessna 175 · Wister, OKOct 27, 1973 · N7685M · Destroyed NTSB FTW74AF024Accident · 1 fatalClosedBeech 95-C55 · Sallisaw, OKOct 25, 1973 · N24ST · Destroyed NTSB FTW74FPJ11Accident · 1 fatalClosedPiper J-3 · Elk City, OKOct 12, 1973 · N59625 · Destroyed NTSB FTW74DPJ10Accident · No injuriesClosedHelio Acft H-295 · Olustee, OKSep 28, 1973 · N6473V · Substantial damage NTSB FTW74DPM09Accident · No injuriesClosedCessna 150 · Bristow, OKSep 25, 1973 · N23369 · Substantial damage NTSB FTW74DPM08Accident · No injuriesClosedBoeing A75 · Coleman, OKSep 23, 1973 · N4564N · Substantial damage NTSB FTW74DPM07Accident · No injuriesClosedErco 415-C · Silver City, OKSep 9, 1973 · N93319 · Substantial damage NTSB FTW74AF014Accident · 2 fatalClosedBeech P35 · Achille, OKSep 6, 1973 · N1479G · Destroyed NTSB FTW74FPJ09Accident · No injuriesClosedCessna 140A · Bethany, OKSep 3, 1973 · N1108D · Substantial damage NTSB FTW74FPM06Accident · No injuriesClosedPiper PA-30 · Tulsa, OKAug 31, 1973 · N8328Y · Substantial damage NTSB FTW74AF010Accident · No injuriesClosedErco 415-C · Page, OKAug 22, 1973 · N93394 · Substantial damage NTSB FTW74AF009Accident · 2 fatalClosedAero Comdr 690A · Alex, OKAug 22, 1973 · N333CA · Destroyed NTSB FTW74FPJ06Accident · 1 fatalClosedEL Tomcat MK5 · Springer, OKAug 16, 1973 · N11VH · Substantial damage NTSB FTW74FPM05Accident · No injuriesClosedPiper PA-22 · Tulsa, OKAug 14, 1973 · N8039D · Substantial damage NTSB FTW74DPJ07Accident · No injuriesClosedChampion 7GCBC · Seminole, OKAug 14, 1973 · N5242X · Substantial damage NTSB FTW74DPJ05Accident · No injuriesClosedLuscombe 8A · Optima, OKAug 6, 1973 · N72004 · Substantial damage NTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKAug 4, 1973 · N6251T · Substantial damage NTSB FTW74DPJ04Accident · No injuriesClosedBoeing A75N1 · Minco, OKAug 3, 1973 · N75321 · Substantial damage NTSB FTW74FPM03Accident · No injuriesClosedHughes 269C · Shidler, OKAug 1, 1973 · N9662F · Substantial damage NTSB FTW74DPJ03Accident · No injuriesClosedPiper PA-25 · Blanchard, OKJul 31, 1973 · N6189Z · Substantial damage NTSB FTW74AF005Accident · 3 fatalClosedBoeing 727 · Yukon, OKJul 27, 1973 · N127 · 2 aircraft · Substantial damage NTSB FTW74FPM02Accident · No injuriesClosedCessna 180 · Tulsa, OKJul 26, 1973 · N11118 · Substantial damage NTSB FTW74FPM01Accident · No injuriesClosedPiper PA-28 · Stilwell, OKJul 25, 1973 · N15917 · Substantial damage NTSB FTW74FPJ02Accident · Serious injuriesClosedBeech V35 · Oklahoma Cty, OKJul 12, 1973 · N630AW · Substantial damage NTSB FTW74FPJ01Accident · Serious injuriesClosedPiper PA-25 · Tonkawa, OKJul 11, 1973 · N6197Z · Destroyed NTSB FTW73FPM19Accident · Minor injuriesClosedBoeing B75N1 · Stuart, OKJun 28, 1973 · N5409N · Substantial damage NTSB FTW73FPJ25Accident · Minor injuriesClosedCessna 310Q · El Reno, OKJun 27, 1973 · N7935Q · Destroyed NTSB FTW73FPJ24Accident · Serious injuriesClosedCessna 172A · Canton, OKJun 23, 1973 · N7518T · Substantial damage NTSB FTW73FPM18Accident · No injuriesClosedErco 415-C · Tulsa, OKJun 22, 1973 · N99121 · Substantial damage NTSB FTW73DPJ23Accident · No injuriesClosedCessna 177 · El Reno, OKJun 20, 1973 · N3498T · Substantial damage NTSB FTW73FPM17Accident · Minor injuriesClosedCessna A188 · Centrahoma, OKJun 17, 1973 · N9905G · Substantial damage NTSB FTW73FPM16Accident · No injuriesClosedAero Comdr A-9B · Hallett, OKJun 13, 1973 · N7650V · Substantial damage NTSB FTW73FPM14Accident · No injuriesClosedCessna 182A · Kingston, OKJun 8, 1973 · N2146G · Destroyed NTSB FTW73FPM15Accident · 1 fatalClosedPiper PA-18A · Welch, OKJun 7, 1973 · N9290D · Destroyed