NTSB investigations, 2015, FL
9 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 14 |
| 2010 | 5 |
| 2011 | 8 |
| 2012 | 10 |
| 2013 | 7 |
| 2014 | 5 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 14 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 7 |
| 2024 | 6 |
| 2025 | 10 |
| 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.\"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\" = '342' 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" = '342' 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 ERA16LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Key Biscayne, FLThe fatigue failure of the No. 1 cylinder intake valve, which resulted in the partial loss of engine power.NTSB ERA15LA373Accident · Minor injuriesLimited investigationFinal reportVanek Jim Sport Copter Vortex · Lake Wales, FLA loss of engine power due to a lean fuel/air mixture as a result of a disconnected fuel primer line.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 ERA15LA318Accident · No injuriesLimited investigationFinal reportCessna 172K · Chiefland, FLThe partial loss of engine power during cruise flight for reasons that could not be determined because a postaccident airframe and engine examination and engine test run revealed no evidence of mechanical malfunctions or failures.NTSB ERA15FA308Accident · 2 fatalField investigationFinal reportBeech N35 · Weirsdale, FLA partial loss of engine power during takeoff. The reason for the partial loss of power could not be determined due to the extensive fire and impact damage to the engine.NTSB ERA15LA306Accident · Serious injuriesLimited investigationFinal reportWright Daniel J Volksplane VP-1 · Brooksville, FLThe pilot's failure to abort the takeoff after determining that the engine was not producing adequate power. Contributing to the accident was the engine's inability to produce adequate power for reasons that could not be determined due to extensive postimpact…NTSB ERA15LA248Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA15LA166Accident · Minor injuriesClass 3 · LimitedFinal reportHawker Beechcraft G36 · Inverness, FLThe pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA15FA139Accident · 1 fatalField investigationFinal reportAdams Donald L DA1 · Sebring, FLA partial loss of engine power for reasons that could not be determined based on the available evidence.