Final NTSB investigations, 2015
13 cases where the sequence of events included Fuel related.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 2 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 5 |
| 2015 | 13 |
| 2016 | 16 |
| 2017 | 20 |
| 2018 | 29 |
| 2019 | 27 |
| 2020 | 37 |
| 2021 | 34 |
| 2022 | 25 |
| 2023 | 25 |
| 2024 | 23 |
| 2025 | 13 |
| 2026 | 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 year(c.\"eventDate\") = 2015
AND c.\"completionStatus\" = 'Completed'
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 year(c."eventDate") = 2015 AND c."completionStatus" = 'Completed' 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 CEN15LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA 22-160 · Tyler, MNThe student pilot's failure to adequately ensure the carburetor was clear of ice before takeoff, which resulted in a partial loss of engine power during takeoff due to carburetor icing.NTSB CEN15LA381Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Pontiac, MIThe pilot's failure to maintain airplane control while landing with a left quartering tailwind. Contributing to the accident was the pilot's inability to conduct a go-around because of a loss of engine power due to carburetor icing.NTSB ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.NTSB CEN15LA333Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Watertown, WIThe total loss of engine power due to carburetor icing.NTSB WPR15LA209Accident · No injuriesLimited investigationFinal reportMooney M 20G · Phoenix, AZThe pilots' failure to apply carburetor heat during the approach for landing, which resulted in a total loss of engine power due to carburetor icing.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 CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.NTSB CEN15LA451Accident · No injuriesLimited investigationFinal reportCessna 150L · Carthage, INThe partial loss of engine power due to carburetor icing.NTSB GAA15CA091Accident · Minor injuriesData collectionFinal reportLefever Paul M RV12 · Caledonia, MOThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a nose over.NTSB ERA15FA221Accident · 1 fatalField investigationFinal reportBR Legend Turbine Legend · West Columbia, SCAn engine flame-out due to fuel starvation as the result of an improperly-installed auxiliary fuel pump fitting, and the pilot's failure to promptly feather the propeller following the engine-flame out, which resulted in decreased glide capability and impact…NTSB ANC15FA021Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe pilot's decision to continue flight into known icing conditions, contrary to the airplane’s limitations, which resulted in a total loss of engine power due to icing.NTSB WPR15LA089Accident · No injuriesLimited investigationFinal reportCirrus SR22 - NO Series · Maui (Pacific Ocean)The pilot's inability to transfer fuel from the aft auxiliary fuel tank to the main fuel tanks for reasons that could not be determined because the airplane was ditched and not recovered.NTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…