NTSB investigations, CO
11 cases where the sequence of events included Fuel related.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 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\" = '190' 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" = '190' 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 CEN24LA362Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172N · Arboles, COA loss of engine power due to carburetor ice.NTSB CEN24LA226Accident · Serious injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006T · Larkspur, COThe flight instructor’s failure to apply carburetor heat, which resulted in a loss of left engine power due to carburetor icing.NTSB CEN24LA206Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to use the carburetor heat during a descent that resulted in the loss of engine power due to carburetor icing.NTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.NTSB CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.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 CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB CEN16LA239Accident · Minor injuriesLimited investigationFinal reportPiper J3F 65 · Strasburg, COA partial loss of engine power due to carburetor ice accumulation.NTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.NTSB CEN09LA546Accident · No injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Boulder, COA partial loss of engine power during initial climb due to carburetor icing.NTSB DEN08LA131Accident · Serious injuriesLimited investigationFinal reportFlynn Van Munk · Erie, COA loss of engine power due to carburetor icing. The reason for the loss of aircraft control was not determined.