NTSB investigations, CO
19 cases where the sequence of events included Fuel starvation.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 3 |
Where
Open the mapLatest 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\" = 'CO' 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\" = '191' 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" = 'CO' 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" = '191' 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 CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.NTSB CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB CEN21LA261Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Lafayette, COThe flight crew’s improper fuel management that resulted in fuel starvation and the loss of engine power.NTSB CEN20LA424Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox Speedster · Leadville, COA partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB CEN19TA280Accident · Serious injuriesClass 3Final reportBell 47G · Montrose, COA loss of engine power due to fuel starvation, which resulted from attitude-induced unporting of the fuel.NTSB CEN18LA381Accident · No injuriesLimited investigationFinal reportPiper PA28 · Pagosa Springs, COThe student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…NTSB CEN18LA142Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado Springs, COThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA236Accident · Minor injuriesLimited investigationFinal reportWells John L JR Stol CH 701 · Canon City, COFuel starvation due to the deterioration of a fuel hose.NTSB CEN17LA220Accident · Serious injuriesLimited investigationFinal reportBellanca 17 30 · Watkins, COThe pilot's in-flight fuel mismanagement, which resulted in fuel starvation and a total loss of engine power.NTSB CEN17LA162Accident · No injuriesLimited investigationFinal reportCessna 210 · Salida, COThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN16FA011Accident · 2 fatalField investigationFinal reportBeech G35 · Eaton, COThe pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…NTSB CEN13LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Eagle, COThe pilots’ improper fuel management, which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was worn and corroded fuel senders, which transmitted inaccurate fuel readings to the fuel monitoring system.NTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.NTSB CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.NTSB CEN10CA327Accident · Minor injuriesData collectionFinal reportRose-Rhinehart A4-C · Longmont, COA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel valve, resulting a loss of engine power after takeoff. Contributing to the accident was the pilot's overall lack of experience in the airplane make/model.NTSB CEN09LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28C-235 · Falcon, COA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.