Skip to content

NTSB investigations, OK

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, newest first

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 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 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 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 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 NTSB FTW72DPJ30Accident · No injuriesClosedPiper PA-28 · Duncan, OKJan 29, 1972 · N5074W · Substantial damage NTSB FTW72FPM17Accident · Minor injuriesClosedCessna 150 · Kiefer, OKJan 26, 1972 · N5788G · Substantial damage NTSB FTW72DPJ31Accident · No injuriesClosedCessna 172 · Oklahoma Cty, OKJan 23, 1972 · N1423F · Substantial damage NTSB FTW72AF048Accident · 4 fatalClosedCessna 182A · Octavia, OKJan 18, 1972 · N6173B · Destroyed NTSB FTW72DPJ29Accident · No injuriesClosedBeech 35-33 · Bethany, OKJan 9, 1972 · N856R · Substantial damage NTSB FTW72DPJ28Accident · No injuriesClosedCessna 140 · Boise City, OKJan 7, 1972 · N2397V · Substantial damage NTSB FTW72FPJ27Accident · Serious injuriesClosedMooney M20C · Blair, OKDec 28, 1971 · N7896V · Destroyed NTSB FTW72AF038Accident · No injuriesClosedLockheed 18 · Hobart, OKDec 22, 1971 · N10P · Substantial damage NTSB FTW72DPJ26Accident · No injuriesClosedBoeing A75N1 · Hollis, OKDec 15, 1971 · N50755 · Substantial damage NTSB FTW72FPM15Accident · No injuriesClosedCessna 172K · Jenks, OKDec 12, 1971 · N84691 · Substantial damage NTSB FTW72AF035Accident · 2 fatalClosedPiper J3C-65 · Marlow, OKDec 12, 1971 · N6382H · Destroyed NTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKDec 11, 1971 · N7025F · Destroyed NTSB FTW72AF034Accident · 1 fatalClosedPiper PA-28 · Piedmont, OKDec 11, 1971 · N5461S · Destroyed NTSB FTW72AF033Accident · 7 fatalClosedBeech 65-80 · Okla.City, OKDec 9, 1971 · N252Q · Destroyed NTSB FTW72FPM16Accident · No injuriesClosedLuscombe 8A · Cleveland, OKNov 30, 1971 · N1561K · Substantial damage NTSB FTW72FPJ23Accident · No injuriesClosedBeech A23-24 · Crescent, OKNov 24, 1971 · N5979S · Substantial damage NTSB FTW72DPJ24Accident · No injuriesClosedGrumman TBM-3U · Cushing, OKNov 14, 1971 · N108Q · Substantial damage NTSB FTW72DPM11Accident · No injuriesClosedPiper PA-28 · Morris, OKNov 9, 1971 · N4147J · Substantial damage NTSB FTW72FPM13Accident · No injuriesClosedBeech A23A · Maramec, OKNov 7, 1971 · N6942Q · Substantial damage NTSB FTW72FPM12Accident · Minor injuriesClosedStinson 108-1 · Calera, OKNov 7, 1971 · N97441 · Substantial damage NTSB FTW72FPM14Accident · No injuriesClosedCessna 182M · Tulsa, OKNov 6, 1971 · N71584 · Substantial damage NTSB FTW72FPJ22Accident · No injuriesClosedPiper PA-24 · Yukon, OKOct 29, 1971 · N8471P · Substantial damage NTSB FTW72AF022Accident · 3 fatalClosedBeech 65-B80 · Milo, OKOct 21, 1971 · N317K · Destroyed NTSB FTW72FPJ19Accident · No injuriesClosedChampion 7KCAB · Oklahoma Cty, OKOct 11, 1971 · N5099X · Substantial damage NTSB FTW72AF019Accident · 2 fatalClosedTaylorcraft BC12-D · Carmen, OKOct 10, 1971 · N43783 · Destroyed NTSB FTW72FPJ18Accident · 1 fatalClosedAeronca 11AC · Adams, OKOct 9, 1971 · N36605 · Substantial damage NTSB FTW72DPJ17Accident · No injuriesClosedCessna 182 · Walters, OKOct 6, 1971 · N3528F · Substantial damage NTSB FTW72FPJ21Accident · Serious injuriesClosedChampion 7ECA · Stratford, OKOct 4, 1971 · N516OT · Substantial damage NTSB FTW72FPJ16Accident · Minor injuriesClosedBensen B8M · El Reno, OKOct 4, 1971 · N22HE · Substantial damage NTSB FTW72DPJ20Accident · No injuriesClosedCessna 180 · Boise City, OKOct 2, 1971 · N5083E · Substantial damage NTSB FTW72FPJ15Accident · No injuriesClosedLuscombe 8A · Oklahoma Cty, OKSep 22, 1971 · N1942B · Substantial damage NTSB FTW72DPJ14Accident · No injuriesClosedCessna 182 · Bethany, OKSep 21, 1971 · N71132 · Substantial damage NTSB FTW72DPJ13Accident · No injuriesClosedPiper PA-24 · Midwest City, OKSep 16, 1971 · N5887P · Substantial damage NTSB FTW72FPM09Accident · Minor injuriesClosedErco 415-C · Tulsa, OKSep 12, 1971 · N99252 · Substantial damage NTSB FTW72FPM08Accident · No injuriesClosedPiper PA-22 · Tulsa, OKSep 6, 1971 · N1651A · Substantial damage NTSB FTW72DPM10Accident · No injuriesClosedCessna 182G · Sand Springs, OKSep 4, 1971 · N3786U · Substantial damage