NTSB investigations, 2018, TX

8 cases where the sequence of events included Fuel exhaustion.

Cases per year

20082026
NTSB investigations, 2018, TX per year, 2008–2026: 96 cases
20084
200910
20109
20114
20122
20135
20149
20153
20166
20175
20188
20193
20207
20213
20223
20233
20243
20255
20264

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\") = 2018
    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\" = '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 CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.Dec 29, 2018 · N6202M · Substantial damageNTSB GAA19CA067Accident · No injuriesData collectionFinal reportJabiru J230-SP · Center, TXThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 18, 2018 · N667J · Substantial damageNTSB GAA19CA048Accident · Minor injuriesData collectionFinal reportCessna 172 · Cleburne, TXThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.Nov 1, 2018 · N3984L · Substantial damageNTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 27, 2018 · N1701Q · Substantial damageNTSB CEN18LA167Accident · Serious injuriesLimited investigationFinal reportEnstrom Helicopter 280C · Kerens, TXThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.May 10, 2018 · N67RE · Substantial damageNTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.May 8, 2018 · N642RJ · Substantial damageNTSB GAA18CA152Accident · Minor injuriesData collectionFinal reportPiper PA 32R · Big Spring, TXThe pilot’s failure to manage the airplane’s fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s decision to attempt the flight with an inoperative fuel gauge.Mar 9, 2018 · N8191B · Substantial damageNTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.Mar 1, 2018 · N77MM · Substantial damage