Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 FTW73AF034Accident · 2 fatalClosedPiper PA-28 · Octavia, OKDec 28, 1972 · N4899T · Destroyed NTSB FTW73FPM05Accident · No injuriesClosedCessna 210F · Mannford, OKDec 8, 1972 · N1870F · Substantial damage NTSB FTW73FPM05Accident · No injuriesClosedPiper PA-31 · Tulsa, OKDec 3, 1972 · N6629L · Substantial damage NTSB FTW73IFO15Incident · No injuriesClosedDouglas DC-10 · Tulsa, OKOct 30, 1972 · N106AA · Minor damage NTSB FTW73DPJ06Accident · No injuriesClosedCessna 180 · Enid, OKOct 22, 1972 · N2207C · Substantial damage NTSB FTW73AF012Accident · 1 fatalClosedNavion A · Talihina, OKOct 9, 1972 · N8523H · Destroyed NTSB FTW73AF011Accident · 6 fatalClosedPiper PA-32 · Norman, OKSep 30, 1972 · N8662N · Destroyed NTSB FTW73DPJ05Accident · No injuriesClosedPiper PA-28 · Yukon, OKSep 23, 1972 · N9349W · Substantial damage NTSB FTW73DPJ03Accident · No injuriesClosedCessna 337 · Lawton, OKSep 19, 1972 · N2477S · Substantial damage NTSB FTW73DPJ04Accident · No injuriesClosedAeronca 7AC · Ponca City, OKSep 16, 1972 · N82434 · Substantial damage NTSB FTW73DPJ02Accident · No injuriesClosedCessna 182 · Oklahoma Cty, OKSep 15, 1972 · N70827 · Substantial damage NTSB FTW73FPM04Accident · Serious injuriesClosedPiper J-3L · Wetumka, OKAug 20, 1972 · N37939 · Destroyed NTSB FTW73DPJ01Accident · No injuriesClosedPipep PA-25 · Guymon, OKAug 17, 1972 · N4959Y · Substantial damage NTSB FTW73AF004Accident · 1 fatalClosedDehavilland DH82A · Jenks, OKJul 23, 1972 · N3549 · Destroyed NTSB FTW73DPM03Accident · No injuriesClosedCessna A188A · Ashland, OKJul 14, 1972 · N9955G · Substantial damage NTSB FTW73DPM01Accident · No injuriesClosedPiper PA-28 · Tulsa, OKJul 8, 1972 · N5535U · Substantial damage NTSB FTW72DPM02Accident · No injuriesClosedCessna 172A · Muskogee, OKJul 8, 1972 · N7197T · Substantial damage NTSB FTW72FPJ44Accident · Minor injuriesClosedCessna 150 · Weatherford, OKJun 30, 1972 · N60827 · Substantial damage NTSB FTW72FPM35Accident · No injuriesClosedBeech V35 · Bartlesville, OKJun 27, 1972 · N8393N · Substantial damage NTSB FTW72FPJ43Accident · Minor injuriesClosedCessna 182A · Bison, OKJun 26, 1972 · N3712D · Substantial damage NTSB FTW72DPJ45Accident · No injuriesClosedCessna 140 · Woodward, OKJun 25, 1972 · N76568 · Substantial damage NTSB FTW72FPM34Accident · No injuriesClosedCessna 170 · Pawhuska, OKJun 24, 1972 · N2518D · Substantial damage NTSB FTW72FPM33Accident · No injuriesClosedBoeing A75 · Blocker, OKJun 17, 1972 · N53390 · Substantial damage NTSB FTW72FPJ41Accident · Minor injuriesClosedPiper PA-28R · Lindsay, OKJun 16, 1972 · N4999J · Substantial damage NTSB FTW72DPJ42Accident · No injuriesClosedBoeing E75N1 · Lookeba, OKJun 16, 1972 · N5188N · Substantial damage NTSB FTW72DPM32Accident · No injuriesClosedBeech 35 · Talihina, OKMay 31, 1972 · N9437S · Substantial damage NTSB FTW72FPM31Accident · Minor injuriesClosedCessna 172D · Grove, OKMay 21, 1972 · N2406Y · Substantial damage NTSB FTW72AF079Accident · No injuriesClosedHiller Acft FH1100 · Yukon, OKMay 19, 1972 · N748FH · Destroyed NTSB FTW72DPJ40Accident · Minor injuriesClosedCessna 188 · Arnett, OKMay 15, 1972 · N3528Q · Substantial damage NTSB FTW72AF077Accident · Minor injuriesClosedBell 47G3B2 · Yukon, OKMay 15, 1972 · N2905W · Substantial damage NTSB FTW72FPM30Accident · Serious injuriesClosedStinson 108-2 · Catoosa, OKMay 12, 1972 · N395C · Substantial damage NTSB FTW72FPM29Accident · No injuriesClosedCessna 177 · Disney, OKMay 11, 1972 · N2903X · Substantial damage NTSB FTW72DPJ39Accident · No injuriesClosedCessna 140 · Yukon, OKMay 2, 1972 · N2875N · Substantial damage NTSB FTW72DPJ38Accident · No injuriesClosedPiper PA-25 · Lindsay, OKApr 28, 1972 · N7386Z · Substantial damage NTSB FTW72AF071Accident · 2 fatalClosedPiper PA-24 · Sand Springs, OKApr 25, 1972 · N7705P · Destroyed NTSB CHI72AC082Accident · 1 fatalClosedCessna 150 · Kellyville, OKApr 12, 1972 · N60311 · Destroyed NTSB FTW72DPM26Accident · No injuriesClosedBell 47G · Wynona, OKApr 5, 1972 · N993B · Substantial damage NTSB FTW72DPJ37Accident · No injuriesClosedBoeing A75N1 · Konawa, OKMar 29, 1972 · N51854 · Substantial damage NTSB FTW72FPM27Accident · No injuriesClosedCessna 310A · Inola, OKMar 25, 1972 · N4266 · Substantial damage NTSB FTW72FPJ36Accident · Minor injuriesClosedPiper PA-24 · Stillwater, OKMar 22, 1972 · N8877P · Destroyed NTSB FTW72DPM23Accident · No injuriesClosedTaylorcraft BC-65 · Bartlesville, OKMar 17, 1972 · N27671 · Substantial damage NTSB FTW72DPM24Accident · No injuriesClosedCessna 150K · Tulsa, OKMar 16, 1972 · N5866G · Substantial damage NTSB FTW72FPJ35Accident · 1 fatalClosedPiper PA-25 · Davis, OKMar 15, 1972 · N6178Z · Destroyed NTSB FTW72FPM25Accident · Minor injuriesClosedPiper PA-28 · Atoka, OKMar 12, 1972 · N4335J · Substantial damage NTSB FTW72DPM22Accident · No injuriesClosedCessna 172 · Cookson, OKMar 4, 1972 · N46743 · Substantial damage NTSB FTW72DPM20Accident · No injuriesClosedPiper PA-32 · Grove, OKFeb 26, 1972 · N2772P · Substantial damage NTSB FTW72FPM19Accident · No injuriesClosedAeronca 7AC · Tulsa, OKFeb 20, 1972 · N82558 · Substantial damage NTSB FTW72FPJ34Accident · No injuriesClosedCessna 421A · Oklahoma Cty, OKFeb 20, 1972 · N2217Q · Substantial damage NTSB FTW72DPJ32Accident · No injuriesClosedPiper PA-28 · Alva, OKFeb 13, 1972 · N3962R · No damage NTSB FTW72FPM18Accident · No injuriesClosedBeech 23 · Durant, OKFeb 10, 1972 · N2304Q · Substantial damage