NTSB investigations, 2010, OK

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.Dec 4, 2010 · N8320R · Substantial damageNTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.Nov 24, 2010 · N4428Q · DestroyedNTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.Nov 18, 2010 · N314DP · Substantial damageNTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.Sep 28, 2010 · N5145U · DestroyedNTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.Aug 28, 2010 · N52071 · Substantial damageNTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.Aug 16, 2010 · N513CM · Substantial damageNTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.Aug 4, 2010 · N414TT · Substantial damageNTSB CEN10FA424Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Kingfisher, OKThe pilot’s impaired judgment, due to medications, which led to an abrupt low-level maneuver and subsequent impact with trees and terrain.Jul 23, 2010 · N918EM · Substantial damageNTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…Jul 12, 2010 · N345MT · Substantial damageNTSB CEN10LA276Accident · 2 fatalLimited investigationFinal reportCovell Kevin Scott Vans RV-4 · Collinsville, OKA loss of engine power shortly after takeoff for undetermined reasons. Contributing to the accident was the pilot's decision to make a 180-degree turn at low level.May 29, 2010 · N74RV · Substantial damageNTSB CEN10CA199Accident · Serious injuriesData collectionFinal reportCessna 172 · Lawton, OKThe private pilot's failure to maintain adequate airspeed, which resulted in a stall, and the failure of both pilots to initiate a go-around. Contributing to the severity of both pilots' injuries was the lack of available shoulder harnesses.Apr 9, 2010 · N12614 · Substantial damageNTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.Mar 14, 2010 · N4974F · Substantial damage