NTSB investigations, 2009

58 cases where the sequence of events included Fuel exhaustion.

Cases, newest first

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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '192' 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 WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.Feb 9, 2009 · N2404Y · Substantial damageNTSB WPR09CA103Accident · No injuriesData collectionFinal reportAeronca 7BC · Half Moon Bay, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to perform an accurate visual fuel quantity check prior to initiating the flight.Jan 29, 2009 · N2805E · DestroyedNTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jan 25, 2009 · N48570 · Substantial damageNTSB CEN09LA143Accident · No injuriesLimited investigationFinal reportCessna 172E · Plano, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jan 23, 2009 · N5420T · Substantial damageNTSB CEN09LA128Accident · 1 fatalLimited investigationFinal reportProbst Baby Ace D · Kilgore, TXA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning. Contributing to the accident was the pilot's failure to maintain situational awareness, resulting in him being lost.Jan 12, 2009 · N610DD · Substantial damageNTSB ERA09LA131Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Pensacola, FLThe pilot’s failure to maintain airspeed following a total loss of engine power during a low-level approach, which resulted in an aerodynamic stall. Contributing to the accident was fuel exhaustion due to the pilot’s inadequate preflight planning.Jan 6, 2009 · N7160Z · Substantial damageNTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.Jan 4, 2009 · N815MA · Substantial damageNTSB WPR09LA071Accident · Minor injuriesLimited investigationFinal reportPZL PZL-104 35A · Oakland, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.Jan 3, 2009 · N226PF · Substantial damage