NTSB investigations, 2015
8 cases where the defining event was Fuel related.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 8 |
| 2016 | 11 |
| 2017 | 15 |
| 2018 | 24 |
| 2019 | 26 |
| 2020 | 36 |
| 2021 | 28 |
| 2022 | 26 |
| 2023 | 23 |
| 2024 | 24 |
| 2025 | 16 |
| 2026 | 7 |
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '190')
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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '190') 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 DCA15WA202Incident · No injuriesForeign investigationBoeing 737 · Trivandrum, IndiaThe NTSB was notified of an incident involving a Boeing B737-800 aircraft, registration VT-JFA, that occurred on August 18, 2015, during landing at Trivandrum International Airport (TRV). The incident is being investigated by the Aircraft Accident…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 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 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 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.