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 FTW68D0154Accident · No injuriesClosedCessna 182 · Ketchum, OKAug 20, 1967 · N3430S · Substantial damage NTSB FTW68D0172Accident · No injuriesClosedCessna 206 · Afton, OKAug 19, 1967 · N2679X · Substantial damage NTSB FTW68D0134Accident · No injuriesClosedPiper PA-18 · Guthrie, OKAug 19, 1967 · N7072D · Substantial damage NTSB FTW68D0133Accident · Minor injuriesClosedPiper PA-18 · Crescent, OKAug 17, 1967 · N3779P · Substantial damage NTSB FTW68F0131Accident · Minor injuriesClosedCessna 180 · Tulsa, OKAug 13, 1967 · N9193T · Substantial damage NTSB FTW68A0017Accident · 1 fatalClosedPiper PA-25 · Coweta, OKAug 11, 1967 · N6135Z · Destroyed NTSB FTW68F0145Accident · No injuriesClosedPiper PA-23 · Hobart, OKAug 2, 1967 · N4225P · Substantial damage NTSB FTW68A0022Accident · No injuriesClosedCessna 182J · Hennessey, OKAug 2, 1967 · N2411Q · Substantial damage NTSB FTW68A0012Accident · 2 fatalClosedPiper PA-16 · Duncan, OKAug 2, 1967 · N5800H · Destroyed NTSB FTW68D0125Accident · No injuriesClosedPiper PA-25 · Lookeba, OKJul 28, 1967 · N6511Z · Substantial damage NTSB FTW68F0098Accident · No injuriesClosedCessna 150F · Wynnewood, OKJul 25, 1967 · N8284S · Substantial damage NTSB FTW68A0005Accident · 2 fatalClosedPiper PA-28 · Tonkawa, OKJul 16, 1967 · N8954J · Destroyed NTSB FTW68D0094Accident · No injuriesClosedCessna 175 · Oklahoma Cty, OKJul 14, 1967 · N7232M · Substantial damage NTSB FTW68D0093Accident · No injuriesClosedCessna 140 · Carrier, OKJul 13, 1967 · N72510 · Substantial damage NTSB FTW68D0091Accident · No injuriesClosedCessna 140 · Blackwell, OKJul 11, 1967 · N72750 · Substantial damage NTSB FTW68D0071Accident · No injuriesClosedBeech 23 · Mustang, OKJul 7, 1967 · N3520R · Substantial damage NTSB FTW68A0001Accident · No injuriesClosedDouglas A-26C · Tulsa, OKJul 6, 1967 · N910H · Substantial damage NTSB FTW68F0067Accident · Serious injuriesClosedBeech 35 · Mountainview, OKJul 5, 1967 · N434B · Destroyed NTSB FTW68F0045Accident · Minor injuriesClosedCessna 172G · Washington, OKJul 5, 1967 · N4346W · Substantial damage NTSB FTW67A0122Accident · No injuriesClosedHughes 269A · Tulsa, OKJun 30, 1967 · N8733F · Substantial damage NTSB FTW68F0028Accident · Minor injuriesClosedPiper PA-28 · Ponca City, OKJun 27, 1967 · N5400U · Destroyed NTSB FTW68D0027Accident · No injuriesClosedCessna 182 · Hammon, OKJun 22, 1967 · N3837D · Substantial damage NTSB FTW68D0015Accident · No injuriesClosedCessna 172 · Ponca City, OKJun 17, 1967 · N7982U · Substantial damage NTSB FTW68F0014Accident · No injuriesClosedBeech 35-A33 · Tulsa, OKJun 9, 1967 · N384D · Substantial damage NTSB FTW68D0012Accident · No injuriesClosedCessna 150F · Geronimo, OKJun 6, 1967 · N3579L · Destroyed NTSB FTW67F0645Accident · No injuriesClosedCessna 140 · Okla.City, OKJun 3, 1967 · N77053 · Substantial damage NTSB FTW67F0655Accident · Minor injuriesClosedCessna 172H · Bethany, OKJun 1, 1967 · N3783R · Substantial damage NTSB FTW67F0644Accident · No injuriesClosedAeronca 7AC · Bartelesvile, OKMay 30, 1967 · N84204 · Substantial damage NTSB FTW67F0656Accident · Serious injuriesClosedPiper PA-25 · Mooreland, OKMay 29, 1967 · N7575Z · Destroyed NTSB FTW67F0627Accident · Serious injuriesClosedCessna 150G · Stroud, OKMay 29, 1967 · N2277J · Substantial damage NTSB FTW67D0657Accident · No injuriesClosedPiper PA-28 · Muskogee, OKMay 28, 1967 · N6399R · Substantial damage NTSB FTW67F0623Accident · No injuriesClosedAeronca 7AC · Turley, OKMay 22, 1967 · N85464 · Substantial damage NTSB FTW68D0002Accident · No injuriesClosedPiper PA-28 · Pawhuska, OKMay 21, 1967 · N5815W · Substantial damage NTSB FTW67F0598Accident · No injuriesClosedBeech E35 · Duncan, OKMay 21, 1967 · N4554V · Substantial damage NTSB FTW67F0641Accident · No injuriesClosedPiper PA-24 · Kingfisher, OKMay 20, 1967 · N6212P · Substantial damage NTSB FTW67D0622Accident · No injuriesClosedBeech A23 · Rosedale, OKMay 20, 1967 · N5769V · Substantial damage NTSB FTW67F0619Accident · No injuriesClosedBeech A23 · Bethany, OKMay 19, 1967 · N3635Q · Substantial damage NTSB FTW67F0640Accident · No injuriesClosedMooney M20C · Okla City, OKMay 17, 1967 · N5627Q · Substantial damage NTSB FTW67F0639Accident · Serious injuriesClosedCessna 175 · Mangum, OKMay 16, 1967 · N7399M · Destroyed NTSB FTW67F0571Accident · No injuriesClosedCessna 140 · Tulsa, OKMay 8, 1967 · N4274N · Substantial damage NTSB FTW67F0612Accident · No injuriesClosedCessna 150 · Stillwater, OKMay 7, 1967 · N3797J · Substantial damage NTSB FTW67D0613Accident · No injuriesClosedCessna 150 · Oakwood, OKMay 7, 1967 · N3563T · Substantial damage NTSB FTW67D0589Accident · No injuriesClosedCessna 170 · Blackwell, OKMay 2, 1967 · N4042V · Substantial damage NTSB FTW67F0569Accident · No injuriesClosedCessna 180B · Chickasha, OKApr 28, 1967 · N1321 · Substantial damage NTSB FTW67F0568Accident · No injuriesClosedCessna 150 · Lone Grove, OKApr 27, 1967 · N2937J · Substantial damage NTSB FTW67F0543Accident · No injuriesClosedNavion B · Tahlequah, OKApr 23, 1967 · N5438K · Substantial damage NTSB FTW67D0564Accident · No injuriesClosedPiper PA-28 · Wagoner, OKApr 21, 1967 · N8091W · Substantial damage NTSB FTW67D0538Accident · No injuriesClosedCessna 182 · Jenks, OKApr 14, 1967 · N2506Q · Substantial damage NTSB FTW67F0537Accident · Minor injuriesClosedGlobe GC-1B · Stillwater, OKApr 13, 1967 · N3346K · Substantial damage NTSB FTW67F0556Accident · Minor injuriesClosedSnow 600 · Newkirk, OKApr 10, 1967 · N1617S · Destroyed