NTSB investigations, OR
17 cases where the sequence of events included Fuel exhaustion.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 4 |
| 2023 | 5 |
| 2024 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'OR' 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" = 'OR' 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 WPR24LA294Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Bend, ORA failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.NTSB WPR24LA031Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK27-2 · Pendleton, ORThe operator’s use of an insufficiently charged battery that resulted in a total loss of engine power and subsequent impact with terrain.NTSB WPR24LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Baker City, ORThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA303Accident · Minor injuriesClass 3 · LimitedFinal reportAldinger Albert John Cozy Mark III · McDermitt, ORThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Dune City, ORThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and impact with terrain.NTSB WPR23LA115Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Mulino, ORThe pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC19LA032Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Newport, ORThe pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB WPR19LA097Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Newberg, ORThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR17LA147Accident · No injuriesLimited investigationFinal reportCessna 180 · Baker City, ORThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning.NTSB GAA17CA331Accident · Minor injuriesData collectionFinal reportPiper PA25 · Hood River, ORThe pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.NTSB GAA16LA100Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28 · Ritter Butte, ORThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.NTSB WPR13LA396Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Sisters, ORThe pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…NTSB WPR11CA329Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Albany, ORThe pilot's inadequate preflight inspection and failure to ensure the fuel cap was secured after refueling, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR10CA314Accident · No injuriesData collectionFinal reportBell 206B · Rickreall, ORA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to ensure that adequate fuel was aboard for the flight.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA 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. Contributing to the accident was a malfunctioning fuel gage.