NTSB investigations, TX
96 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 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.
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 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA16CA020Accident · No injuriesData collectionFinal reportBeech A36 · Jasper, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.NTSB CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15LA296Accident · Serious injuriesLimited investigationFinal reportColonial C 1 · Chico, TXA loss of engine power due to fuel exhaustion. Contributing to the accident was the unsnapped fuel bladder, which resulted in an inaccurate fuel quantity indication, and the pilot's inadequate preflight fuel planning, during which he relied solely on the fuel…NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB CEN15LA031Accident · No injuriesLimited investigationFinal reportCessna T210M · Brownsville, TXA loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight fuel planning.NTSB CEN14LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Mt. Vernon, TXThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14CA303Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Port Isabel, TXA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.NTSB CEN14LA290Accident · Serious injuriesLimited investigationFinal reportTeunis Starduster TOO SA300 · Fort Worth, TXThe non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.NTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.NTSB CEN14FA219Accident · 1 fatalField investigationFinal reportBellanca 17 30A · Sweetwater, TXThe pilot’s inadequate inflight fuel management, which led to a loss of engine power due to fuel exhaustion or starvation.NTSB CEN14CA027Accident · Serious injuriesData collectionFinal reportCessna 172M · Raymondville, TXThe operation of an airplane by a non-certificated pilot. Contributing to the accident was his failure to maintain airspeed following a total loss of engine power at low altitude, which resulted in an aerodynamic stall. Also contributing was the pilot's…NTSB CEN13FA338Accident · 1 fatalField investigationFinal reportPipistrel Alpha Trainer · Pampa, TXThe loss of engine power due to fuel exhaustion as a result of the manufacturer providing the incorrect Pilot’s Operating Handbook to the owner, which prevented the pilot from accurately calculating the fuel requirements before the flight. Contributing to the…NTSB CEN13LA293Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Longview, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight planning, which precluded him from locating his intended destination and led to fuel…NTSB CEN13CA197Accident · Minor injuriesData collectionFinal reportCessna 150G · Baytown, TXThe pilot’s poor in-flight decision-making and improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN13CA162Accident · No injuriesData collectionFinal reportBeech A60 · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN13FA075Accident · 1 fatalField investigationFinal reportHughes 369 · Childress, TXThe improper maintenance of the helicopter fuel system that resulted in erroneous fuel gauge indications and the pilot’s inadequate fuel management, both of which resulted in fuel exhaustion during a long-line hover. Also causal was the lack of company…NTSB CEN12LA169Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Cypress, TXThe pilot's improper preflight planning/preparation and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion during the approach to the destination airport.NTSB CEN12LA127Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Marion, TXA total loss of engine power due to fuel starvation as a result of a piece of metal in the fuel line, which blocked fuel flow to the engine.NTSB CEN12FA037Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Carrollton, TXThe pilot's failure to adequately preflight the airplane prior to departure, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…NTSB CEN11CA241Accident · Minor injuriesData collectionFinal reportCessna 150M · Garland, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA061Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Fruitvale, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB CEN11LA034Accident · No injuriesLimited investigationFinal reportCessna T210N · Presidio, TXA loss of engine power due to fuel exhaustion for undetermined reasons.NTSB CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA297Accident · Minor injuriesData collectionFinal reportCessna 180 · Humble, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN10FA139Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Cotulla, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning. Contributing to the accident was the low-altitude operating environment that would not allow for a successful autorotation after the loss of engine power.NTSB CEN10CA087Accident · No injuriesData collectionFinal reportMaule M-4-220C · Pearsall, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.NTSB CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.NTSB CEN10LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Mineola, TXA loss of engine power due to fuel exhaustion and the pilot's inadequate preflight planning.NTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN09CA419Accident · No injuriesData collectionFinal reportCessna 182Q · Ballinger, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning.NTSB CEN09LA400Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bastrop, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly verify the fuel load prior to departure.NTSB CEN09CA327Accident · No injuriesData collectionFinal reportCessna 177 · Houston, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel planning.NTSB CEN09LA274Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Addison, TXA loss of engine power in flight due to fuel starvation as a result of the pilots' inadequate fuel management.NTSB CEN09CA245Accident · No injuriesData collectionFinal reportCessna R182 · Granger, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.NTSB 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.NTSB 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.NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.NTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.