NTSB investigations, 2009, OK

6 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2009, OK per year, 2008–2026: 148 cases
200811
20096
201012
20117
201210
201314
20146
20158
201613
201712
201810
20197
20206
20216
20227
20236
20244
20251
20262

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 year(c.\"eventDate\") = 2009
    AND c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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 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 · DestroyedNTSB CEN09FA462Accident · 1 fatalField investigationFinal reportBeech V35 · Oklahoma City, OKThe pilot’s decision to operate an airplane with known deficiencies, and the loss of engine power during climb for undetermined reasons.Jul 25, 2009 · N9112S · Substantial damageNTSB CEN09CA287Accident · Serious injuriesData collectionFinal reportPitts Aerobatics S-2B · Muskogee, OKInadequate supervision by the certified flight instructor, resulting in a delayed stall recovery attempt.May 9, 2009 · N6027V · Substantial damageNTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.May 6, 2009 · N7271J · Substantial damageNTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Mar 27, 2009 · N373E · Substantial damageNTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.Feb 14, 2009 · N6300Q · Substantial damage