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 FTW75FPM19Accident · No injuriesClosedCessna 150F · Kansas, OKJun 21, 1975 · N3028X · Substantial damage NTSB FTW75DPJ24Accident · Serious injuriesClosedPiper PA-18 · Hough, OKJun 7, 1975 · N7301L · Destroyed NTSB FTW75AF071Accident · 2 fatalClosedPiper PA-22 · Gore, OKJun 6, 1975 · N7030D · Destroyed NTSB FTW75DPJ23Accident · No injuriesClosedPiper PA-28 · Beaver, OKMay 27, 1975 · N5227L · Substantial damage NTSB FTW75FPM18Accident · Minor injuriesClosedBensen B-8M · Bartlesville, OKMay 18, 1975 · N4355 · Substantial damage NTSB FTW75FPM17Accident · No injuriesClosedCessna 180 · Ketchum, OKMay 4, 1975 · N2188Z · Substantial damage NTSB FTW75FPJ22Accident · No injuriesClosedCessna 172 · Ada, OKMay 3, 1975 · N6035A · Substantial damage NTSB FTW75DPJ21Accident · No injuriesClosedCessna 180 · Ringling, OKApr 25, 1975 · N2935A · Substantial damage NTSB FTW75FPM16Accident · No injuriesClosedWillie II · Tulsa, OKApr 21, 1975 · N113BT · Destroyed NTSB FTW75FPM15Accident · No injuriesClosedPiper PA-28 · Boley, OKApr 20, 1975 · N5329S · Substantial damage NTSB FTW75FPM14Accident · No injuriesClosedMarrs Midget · Tulsa, OKApr 5, 1975 · N54044 · Substantial damage NTSB FTW75FPM13Accident · No injuriesClosedPiper PA-28 · Tulsa, OKApr 1, 1975 · N5749U · Substantial damage NTSB FTW75DPJ20Accident · No injuriesClosedCessna U206 · Bethany, OKMar 26, 1975 · N4994F · Substantial damage NTSB FTW75FPM12Accident · No injuriesClosedPiper PA-22 · Tulsa, OKMar 21, 1975 · N7633D · Substantial damage NTSB FTW75DPJ19Accident · Minor injuriesClosedPiper PA-28 · Kingfisher, OKFeb 28, 1975 · N41763 · Destroyed NTSB FTW75FPJ18Accident · No injuriesClosedMooney M20C · Porter Hill, OKFeb 27, 1975 · N6475U · Substantial damage NTSB FTW75DPJ17Accident · No injuriesClosedBeech 65-90 · Gage, OKFeb 14, 1975 · N724N · Substantial damage NTSB FTW75DPJ16Accident · No injuriesClosedPiper PA-23 · Guymon, OKJan 31, 1975 · N5445Y · Substantial damage NTSB FTW75FPM10Accident · No injuriesClosedAmer Avco AA5 · Afton, OKJan 25, 1975 · N7199L · Substantial damage NTSB FTW75DPJ15Accident · No injuriesClosedCessna 195 · Ponca City, OKJan 1, 1975 · N4346N · Substantial damage NTSB FTW75DPG14Accident · No injuriesClosedPiper PA-24 · Seiling, OKJan 1, 1975 · N7451P · Substantial damage NTSB FTW75FPM09Accident · No injuriesClosedPiper PA-24 · Tulsa, OKDec 25, 1974 · N5008P · Substantial damage NTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKDec 2, 1974 · N51408 · Substantial damage NTSB FTW75FPJ13Accident · Minor injuriesClosedTaylorcraft BL · Poolville, OKDec 1, 1974 · N22283 · Substantial damage NTSB FTW75AF033Accident · 2 fatalClosedPiper PA-24 · Tulsa, OKNov 16, 1974 · N6922P · Destroyed NTSB FTW75FRJ10Accident · No injuriesClosedPiper PA-16 · Fairview, OKNov 11, 1974 · N5985H · Substantial damage NTSB FTW75FPJ12Accident · No injuriesClosedWittman W-8 · Fairview, OKNov 11, 1974 · N2834 · Substantial damage NTSB FTW75FPJ11Accident · Serious injuriesClosedPiper J-3 · Fairview, OKNov 11, 1974 · N1504N · Destroyed NTSB FTW75AF029Accident · 2 fatalClosedPiper PA-31 · Blair, OKOct 24, 1974 · N979L · Destroyed NTSB FTW75FPM10Accident · 1 fatalClosedCessna 310D · Tulsa, OKOct 16, 1974 · N310F · Substantial damage NTSB FTW75FPM08Accident · Minor injuriesClosedPiper PA-28 · Beggs, OKOct 1, 1974 · N9895W · Substantial damage NTSB FTW75DPJ07Accident · No injuriesClosedAmer Avco AA5 · Yukon, OKSep 30, 1974 · N9599L · Substantial damage NTSB FTW75DPJ08Accident · No injuriesClosedPiper PA-34 · Early, OKSep 29, 1974 · N16397 · Substantial damage NTSB FTW75DPJ09Accident · No injuriesClosedCessna 305A · Oklahoma Cty, OKSep 28, 1974 · N5228G · Substantial damage NTSB FTW75FPM07Accident · No injuriesClosedLuscombe 8A · Muskogee, OKSep 21, 1974 · N2685K · Substantial damage NTSB FTW75FPJ06Accident · Minor injuriesClosedCessna 182A · Stroud, OKSep 21, 1974 · N5945B · Substantial damage NTSB FTW75FPM06Accident · Minor injuriesClosedPiper PA-28 · Westport, OKSep 15, 1974 · N41763 · Substantial damage NTSB FTW75FPM05Accident · No injuriesClosedTern II · Tulsa, OKSep 14, 1974 · N250Z · Destroyed NTSB FTW75DPJ05Accident · No injuriesClosedPiper PA-16 · Ardmore, OKSep 14, 1974 · N5757H · Substantial damage NTSB FTW75AF019Accident · 1 fatalClosedBeech C23 · Stillwell, OKSep 12, 1974 · N24606 · Destroyed NTSB FTW75AK018Accident · 3 fatalClosedAero Comdr 100 · Inola, OKSep 10, 1974 · N2970T · Destroyed NTSB FTW75FPM04Accident · Minor injuriesClosedCessna A188B · Atoka, OKAug 31, 1974 · N8638G · Destroyed NTSB FTW75FPM03Accident · Serious injuriesClosedPiper PA-28 · Hugo, OKAug 31, 1974 · N8978J · Destroyed NTSB FTW75DPJ04Accident · No injuriesClosedPiper PA-28 · Duke, OKAug 30, 1974 · N8017N · Substantial damage NTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKAug 24, 1974 · N19030 · Substantial damage NTSB FTW75FPM01Accident · Serious injuriesClosedBellanca 17-30A · Shidler, OKAug 13, 1974 · N39830 · Substantial damage NTSB FTW75DPJ03Accident · No injuriesClosedCessna 180B · Medford, OKAug 7, 1974 · N5129E · Substantial damage NTSB FTW75DPJ01Accident · No injuriesClosedAir & Space 18A · Boise City, OKJul 24, 1974 · N6121S · Substantial damage NTSB FTW75DPJ02Accident · No injuriesClosedPiper PA-25 · Felt, OKJul 18, 1974 · N6997Z · Substantial damage NTSB FTW74FPM30Accident · No injuriesClosedHuffman 1 · Okmulgee, OKJun 22, 1974 · N2MH · Substantial damage