NTSB investigations, 2010, OK

9 cases where the sequence of events included Loss of engine power (total).

Cases per year

20082026
NTSB investigations, 2010, OK per year, 2008–2026: 60 cases
20085
20093
20109
20114
20122
20135
20143
20152
20164
20174
20184
20191
20202
20212
20223
20234
20241
20251
20261

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\" = '341' 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 CEN11LA101Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Claremore, OKA loss of engine power on both engines for undetermined reasons.Dec 3, 2010 · N211DS · Substantial damageNTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.Sep 1, 2010 · N3446B · Substantial damageNTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.Aug 16, 2010 · N513CM · Substantial damageNTSB CEN10LA440Accident · No injuriesLimited investigationFinal reportBeech F35 · Enid, OKA loss of engine power for undetermined reasons.Jul 27, 2010 · N3858B · 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 CEN10FA382Accident · 3 fatalField investigationFinal reportCessna 421 · Tulsa, OKThe pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.Jul 11, 2010 · N88DF · 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 CEN10LA241Accident · Minor injuriesLimited investigationFinal reportHager Clinton Ray Vans RV-8 · Prague, OKThe in-flight separation of a propeller blade for undetermined reasons.May 6, 2010 · N127TT · 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