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 FTW67F0535Accident · No injuriesClosedPiper PA-24 · Chickasha, OKApr 10, 1967 · N8097P · Substantial damage NTSB FTW67D0554Accident · No injuriesClosedMooney M20A · Oklahoma Cty, OKApr 9, 1967 · N1083C · Substantial damage NTSB FTW67F0553Accident · Minor injuriesClosedPiper J-3 · Fairview, OKApr 7, 1967 · N26853 · Destroyed NTSB FTW67D0511Accident · No injuriesClosedCessna 150 · Enid, OKMar 29, 1967 · N6457F · Substantial damage NTSB FTW67F0490Accident · No injuriesClosedAero Comdr 520 · Oklahoma Cty, OKMar 26, 1967 · N158V · Substantial damage NTSB FTW67D0578Accident · No injuriesClosedBeech N35 · Wagoner, OKMar 26, 1967 · N172X · Substantial damage NTSB FTW67F0507Accident · No injuriesClosedPiper PA-23 · Okla.City, OKMar 24, 1967 · N2194P · Substantial damage NTSB FTW67D0548Accident · No injuriesClosedCessna 182 · Pond Creek, OKMar 24, 1967 · N8681 · Substantial damage NTSB FTW67F0488Accident · No injuriesClosedBeech E18S · Tulsa, OKMar 22, 1967 · N3765B · Substantial damage NTSB FTW67F0521Accident · No injuriesClosedBeech G35 · Tulsa, OKMar 19, 1967 · N4257D · Substantial damage NTSB FTW67F0520Accident · Minor injuriesClosedBeech 95-B55 · Mooreland, OKMar 18, 1967 · N414K · Substantial damage NTSB FTW67D0519Accident · No injuriesClosedCessna 182H · Port Ketchum, OKMar 16, 1967 · N2398X · Substantial damage NTSB FTW67F0517Accident · No injuriesClosedMooney M20C · Thomas, OKMar 13, 1967 · N5838Q · Substantial damage NTSB FTW67D0497Accident · No injuriesClosedPiper J-3C · Colony, OKMar 12, 1967 · N42996 · Substantial damage NTSB FTW67A0092Accident · No injuriesClosedMooney M20C · Mangum, OKMar 12, 1967 · N6874U · Substantial damage NTSB FTW67D0485Accident · No injuriesClosedBeech 35-A33 · Muskogee, OKMar 9, 1967 · N384D · Substantial damage NTSB FTW67A0090Accident · 1 fatalClosedCessna 172 · Lequire, OKMar 5, 1967 · N7058A · Destroyed NTSB FTW67F0481Accident · Serious injuriesClosedCessna 140 · Marlow, OKMar 3, 1967 · N90045 · Substantial damage NTSB FTW68F0247Accident · No injuriesClosedPiper PA-30 · Guymon, OKFeb 24, 1967 · N8000Y · Substantial damage NTSB FTW67F0503Accident · No injuriesClosedPiper PA-24 · Shawnee, OKFeb 15, 1967 · N7545P · Substantial damage NTSB FTW67D0452Accident · No injuriesClosedCessna 172 · Ardmore, OKFeb 14, 1967 · N2468Y · Substantial damage NTSB FTW67F0492Accident · No injuriesClosedBeech 35 · Marietta, OKFeb 11, 1967 · N432B · Substantial damage NTSB FTW67D0444Accident · No injuriesClosedCessna 172 · Newkirk, OKFeb 10, 1967 · N3683L · Substantial damage NTSB FTW67F0441Accident · No injuriesClosedCessna 172 · Oklahoma Cy, OKFeb 5, 1967 · N7970U · Substantial damage NTSB FTW67D0442Accident · No injuriesClosedBeech C-45H · Tulsa, OKFeb 5, 1967 · N3657G · Substantial damage NTSB FTW67D0440Accident · No injuriesClosedAeronca 7AC · Yukon, OKFeb 5, 1967 · N83718 · Substantial damage NTSB FTW67F0411Accident · Minor injuriesClosedCessna 150 · Jenks, OKJan 15, 1967 · N3635J · Substantial damage NTSB FTW67A0072Accident · 2 fatalClosedBeech B95 · Checotah, OKJan 10, 1967 · N9693R · Destroyed NTSB FTW67A0071Accident · 2 fatalClosedCessna 150G · Lawton, OKJan 8, 1967 · N3110J · Destroyed NTSB FTW67F0365Accident · No injuriesClosedCessna 175 · Tulsa, OKJan 6, 1967 · N7285M · Substantial damage NTSB FTW67D0401Accident · No injuriesClosedPiper PA-24 · Bartlesville, OKJan 4, 1967 · N5328P · Substantial damage NTSB FTW67F0381Accident · Minor injuriesClosedCessna 182G · Barnsdall, OKJan 2, 1967 · N2087R · Substantial damage NTSB FTW67D0400Accident · No injuriesClosedCessna 172 · Lawton, OKJan 2, 1967 · N3693S · Substantial damage NTSB FTW67D0382Accident · No injuriesClosedPiper PA-22 · Enid, OKJan 2, 1967 · N4517Z · Substantial damage NTSB FTW67A0068Accident · 4 fatalClosedMooney M20E · Ardmore, OKJan 2, 1967 · N7130U · Destroyed NTSB FTW67D0362Accident · No injuriesClosedCessna 150 · Stillwater, OKJan 1, 1967 · N3920J · Substantial damage NTSB FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKDec 30, 1966 · N6298T · Substantial damage NTSB FTW67D0379Accident · No injuriesClosedPitts 190 · Duncan, OKDec 29, 1966 · N97M · Substantial damage NTSB FTW67A0067Accident · No injuriesClosedCessna P206 · Chickasha, OKDec 29, 1966 · N2588X · Substantial damage NTSB FTW67D0377Accident · Serious injuriesClosedPiper PA-28 · Boise City, OKDec 26, 1966 · N9314J · Destroyed NTSB FTW67D0375Accident · No injuriesClosedPiper PA-28 · Enid, OKDec 24, 1966 · N8412W · Substantial damage NTSB FTW67D0374Accident · No injuriesClosedCessna 150B · Enid, OKDec 23, 1966 · N7390X · Substantial damage NTSB FTW67D0346Accident · No injuriesClosedBeech J35 · Lawton, OKDec 14, 1966 · N8355D · Substantial damage NTSB FTW67F0345Accident · Minor injuriesClosedPiper J3C-65 · Tulsa, OKDec 10, 1966 · N56274 · Substantial damage NTSB FTW67F0356Accident · No injuriesClosedBeech P35 · Enid, OKDec 9, 1966 · N8915M · Substantial damage NTSB FTW67D0322Accident · No injuriesClosedCessna U206 · Oklahoma Cty, OKDec 6, 1966 · N8001Z · Substantial damage NTSB FTW67A0060Accident · 1 fatalClosedCessna 182 · Ponca City, OKDec 4, 1966 · N8612T · Destroyed NTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKDec 1, 1966 · N16085 · Substantial damage NTSB FTW67D0338Accident · No injuriesClosedCessna 210 · Enid, OKNov 28, 1966 · N6593X · Substantial damage NTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNov 23, 1966 · N1422F · Substantial damage