Fatal NTSB investigations, OK

6 cases where the sequence of events included Controlled flight into terr/obj (CFIT).

Cases per year

20092026
Fatal NTSB investigations, OK per year, 2009–2026: 6 cases
20093
20132
20151

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\" = '120' 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.

NTSB CEN15FA171Accident · 1 fatalField investigationFinal reportEurocopter AS 350 B2 · Eufaula, OKThe flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.Mar 13, 2015 · N919EM · DestroyedNTSB CEN14FA010Accident · 1 fatalField investigationFinal reportCessna 177 · Clayton, OKControlled flight into terrain for reasons that could not be determined from the available evidence.Oct 18, 2013 · N30495 · Substantial damageNTSB CEN13FA465Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Balko, OKThe pilot's failure maintain clearance from a meteorological tower while en route at a low altitude. Contributing to the accident was the sun's glare.Aug 5, 2013 · N3159B · DestroyedNTSB CEN10FA071Accident · 1 fatalField investigationFinal reportCessna 310R · Alva, OKThe pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…Dec 13, 2009 · N310CR · Substantial damageNTSB CEN10FA019Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Tahlequah, OKThe pilot's impairment due to recent heavy use of methamphetamine, recent use of a narcotic pain reliever, and fatigue. Contributing to the accident was the pilot's lack of instrument experience and training.Oct 14, 2009 · N3234G · DestroyedNTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.Sep 5, 2009 · N1228H · Destroyed