NTSB investigations, 2009, TX

5 cases where the sequence of events included Fuel starvation.

Cases per year

20082026
NTSB investigations, 2009, TX per year, 2008–2026: 90 cases
20081
20095
20102
20118
20123
20134
20142
20153
20166
20174
20185
20197
20205
20217
20226
20236
20248
20256
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\" = '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\" = '191' 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 CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.Oct 2, 2009 · N991PP · Substantial damageNTSB CEN09CA382Accident · Serious injuriesData collectionFinal reportBakeng Deuce · Beach City, TXThe loss of engine power due to fuel starvation resulting from a partially crimped fuel tank vent tube.Jun 24, 2009 · N26MR · Substantial damageNTSB CEN09LA341Accident · Minor injuriesLimited investigationFinal reportHuston Charles D Pitts S-12 · Spicewood, TXA total loss of engine power due to fuel starvation as a result of the presence of an unidentified contaminant in the fuel system which clogged the fuel flow sensor. Contributing to the accident was the manufacturer’s installation of the fuel flow sensor…Jun 5, 2009 · N922TP · Substantial damageNTSB 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 damageNTSB CEN09LA227Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Laredo, TXThe certificated flight instructor's improper fuel management resulting in an engine failure due to fuel starvation. Contributing to the accident was the flight instructor's failure to properly complete the restart checklist.Mar 21, 2009 · N8120R · Substantial damage