Fatal NTSB investigations, OK
12 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2013 | 2 |
|---|---|
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest cases
Query with SQL
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'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25FA320Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172L · Walters, OKOn August 14, 2025, about 0934 central daylight time, a Cessna 172L, N2860Q, was destroyed when it was involved in an accident near Walters, Oklahoma. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code of Federal Regulations as…NTSB CEN24FA148Accident · 3 fatalClass 3 · FieldFinal reportDavis DA-3 · Antlers, OKImpact with terrain for reasons that could not be determined.NTSB CEN23FA060Accident · 3 fatalClass 3 · FieldFinal reportBeech F33A · Yukon, OKThe pilot’s loss of airplane control for reasons that could not be determined.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB CEN20LA413Accident · FatalClass 3 · LimitedFinal reportCosmos Phase 3 · Wayne, OKA loss of control while taxiing for reasons that could not be determined based on available evidence.NTSB CEN18FA310Accident · 5 fatalClass 3 · FieldFinal reportExtra EA 400 · Ponca City, OKThe pilot's loss of control for reasons that could not be determined with the available evidence.NTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.NTSB CEN17FA138Accident · 1 fatalField investigationFinal reportBeech V35 · Union City, OKThe pilot's improper recovery from a spin.NTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…NTSB CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.