NTSB investigations, 2009, TX

12 cases where the sequence of events included Loss of engine power (partial).

Cases per year

20082026
NTSB investigations, 2009, TX per year, 2008–2026: 168 cases
20087
200912
20109
20117
201215
201311
201411
201510
20168
201710
20189
201913
20208
20219
20225
20234
20246
20258
20266

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\" = 'TX' 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\" = '342' 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 CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…Nov 14, 2009 · N10DA · Substantial damageNTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.Nov 4, 2009 · N725GS · Substantial damageNTSB CEN10LA008Accident · Minor injuriesLimited investigationFinal reportCrawford Alan R Glasair II · San Saba, TXA partial loss of engine power for undetermined reasons.Oct 3, 2009 · N550AC · Substantial damageNTSB CEN09LA575Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Preston, TXThe loss of engine power for undetermined reasons.Sep 5, 2009 · N626LH · Substantial damageNTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.Aug 3, 2009 · N1644R · Substantial damageNTSB CEN09CA431Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Porter, TXThe partial loss of engine power due to carburetor icing resulting in the pilot's inability to clear the wires.Jul 13, 2009 · N70455 · Substantial damageNTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.Jun 17, 2009 · N66016 · Substantial damageNTSB CEN09LA330Accident · Serious injuriesLimited investigationFinal reportFrey FLY Baby · Keller, TXA partial loss of engine power due to an obstruction of the air intake, as reported by the pilot. Contributing to the accident was the pilot's insufficient preflight inspection.May 31, 2009 · N59357 · Substantial damageNTSB CEN09LA284Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Alpine, TXThe loss of engine power due to disengagement of the magneto idler gear support pin.May 8, 2009 · N60HG · Substantial damageNTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.May 8, 2009 · N172SV · Substantial damageNTSB CEN09FA241Accident · 1 fatalField investigationFinal reportCessna T210N · Edinburg, TXA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select a suitable alternate landing site.Apr 9, 2009 · N127TC · DestroyedNTSB CEN09LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Georgetown, TXA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management. Contributing to the accident was the pilot's improper engine restart procedures.Mar 29, 2009 · N210BF · Substantial damage