NTSB investigations, 2015, FL
15 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 16 |
|---|---|
| 2009 | 19 |
| 2010 | 21 |
| 2011 | 13 |
| 2012 | 23 |
| 2013 | 19 |
| 2014 | 22 |
| 2015 | 15 |
| 2016 | 21 |
| 2017 | 18 |
| 2018 | 15 |
| 2019 | 10 |
| 2020 | 14 |
| 2021 | 16 |
| 2022 | 9 |
| 2023 | 7 |
| 2024 | 6 |
| 2025 | 18 |
| 2026 | 11 |
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.\"eventStateOrRegion\" = 'FL' 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\" = '341' 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."eventStateOrRegion" = 'FL' 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" = '341' 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 ERA16LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Opa Locka, FLMaintenance personnel's inadequate inspection of the exhaust system, which resulted in the escape of exhaust gases into the engine compartment and a subsequent total loss of engine power.NTSB ERA16LA026Accident · 1 fatalLimited investigationFinal reportPiper PA31 · Weston, FLThe pilot's feathering of the incorrect propeller following a total loss of right engine power due to fuel starvation, which resulted from maintenance personnel’s failure to reinstall the flapper valve in the right main fuel tank. Contributing to the accident…NTSB ERA16LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami Beach, FLA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean after the ditching.NTSB ERA15FA378Accident · 1 fatalField investigationFinal reportPiper PA 30 · St. Petersburg, FLThe pilot's failure to maintain single-engine minimum controllable airspeed following a loss of right engine power during initial climb. Also causal was the loss of right engine power for reasons that could not be determined because examination of the…NTSB ERA15LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15LA332Accident · Serious injuriesLimited investigationFinal reportLancair IV · Fort Lauderdale, FLThe mechanic's improper installation of the turbocharger assembly, which resulted in oil starvation and a subsequent total loss of the engine power.NTSB ERA15CA327Accident · No injuriesData collectionFinal reportCessna 172 · Riviera Beach, FLThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.NTSB ERA15FA191Accident · Serious injuriesField investigationFinal reportMooney M20TN · Lakeland, FLThe total loss of engine power for reasons that could not be determined due to thermal damage and because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB ERA15LA189Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Titusville, FLAn inflight fire and a total loss of engine power due to oil starvation, after separation of the No. 3 cylinder exhaust valve rocker box cover for reasons that could not be determined based on the available information.NTSB ERA15LA168Accident · Minor injuriesLimited investigationFinal reportTrick Trikes 582 Cyclone Storm · Live Oak, FLThe student pilot applicant’s failure to clear the engine during a prolonged descent of a simulated engine failure and his subsequent rapid throttle input at the completion of the maneuver, which resulted in the engine’s failure to respond. Contributing to…NTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…NTSB ERA15LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Fort Myers, FLThe pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.NTSB ERA15LA145Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident testing of the engine revealed no anomalies.NTSB ERA15LA142Accident · No injuriesLimited investigationFinal reportPiper PA28 · Jacksonville, FLThe total loss of engine power due to carburetor ice.NTSB ERA15LA090Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Key West, FLA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.