NTSB investigations
805 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.\"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."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 WPR21FA352Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28R-200 · Page, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN21LA418Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Magnolia, TXA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.NTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.NTSB CEN21LA406Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Kingsley, IAThe total loss of engine power due to fuel exhaustion as a result of an unsecured fuel bladder, which reduced the fuel capacity of the affected tank.NTSB ERA21LA393Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Delray, FLThe pilot’s inadequate preflight inspection and improper fuel planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CEN21LA386Accident · No injuriesClass 3 · LimitedFinal reportAcro Sport II · Fishers, INThe airplane’s total loss of engine power due to fuel exhaustion as a result of leaking fuel from a loose fuel inlet fitting to the fuel control unit.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.NTSB CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.NTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.NTSB CEN21LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe pilot’s inaccurate estimate of the fuel level during his preflight inspection, which resulted in fuel exhaustion during cruise flight and a total loss of engine power.NTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA184Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Las Vegas, NVA total loss of engine power due to fuel exhaustion.NTSB WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.NTSB ERA21LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 421B · Old Bethpage, NYThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a forced landing.NTSB CEN21LA103Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Cypress, TXA total loss of engine power due to fuel exhaustion.NTSB ERA21LA042Accident · Serious injuriesClass 3 · LimitedFinal reportRepublic RC3 · Advance, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chandler, AZThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21FA029Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dunnellon, FLA total loss of engine power due to fuel exhaustion. Contributing was the pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and loss of control.NTSB WPR21LA022Accident · No injuriesClass 4 · LimitedFinal reportPiper J3-C65 · El Cajon, CAThe pilot's inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.NTSB CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA333Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Jackson, TNThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA20LA328Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Hamilton, GAThe pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA331Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Fort Lauderdale, FLThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s decision to continue to the destination following the loss of engine power to the first engine.NTSB CEN20LA397Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montgomery City, MOThe pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.NTSB WPR20LA308Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Billings, MTThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA313Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Jackson, TNThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB ERA20LA297Accident · 2 fatalClass 3 · LimitedFinal reportRockwell 500 · Pembroke Park, FLA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.NTSB WPR20LA249Accident · 2 fatalClass 3 · LimitedFinal reportNorth American Navion · Cedar City, UTA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s improper fuel planning and failure to see and avoid the communications tower support guy wire.NTSB CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA20LA245Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Falmouth, KYThe pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.NTSB CEN20CA274Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Springfield, OHThe pilot’s inadequate inflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB CEN20LA265Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado · Marksville, LAThe student pilot’s failure to ensure sufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion, which resulted in impact with terrain.NTSB ERA20LA229Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206 · Coconut Creek, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to recognize the illumination of the low-fuel caution light.NTSB ERA20CA226Accident · No injuriesClass 4 · Data collectionFinal reportCessna 150 · Shelby, NCThe pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.NTSB WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.NTSB CEN20CA249Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Lahoma, OKThe loss of engine power due to fuel exhaustion and the pilot’s improper fuel planning before the flight.NTSB ERA20LA197Accident · 1 fatalClass 3 · LimitedFinal reportSchweizer 269C-1 · Ozark, ALA total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.NTSB ERA20CA176Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 402 · Hampton, GAA dual total loss of engine power as a result of fuel exhaustion.