NTSB investigations, 2019, FL
10 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
Latest 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\") = 2019
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") = 2019 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 ERA20LA033Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · St. Augustine, FLA total loss of engine power for undetermined reasons.NTSB ERA20TA005Accident · No injuriesClass 3Final reportSilverlight AR-1 · Fort Meade, FLThe student pilot’s inadequate preflight inspection that failed to detect water contamination of the fuel and resulted in a total loss of engine power during cruise flight.NTSB CEN19LA317Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Boca Raton, FLThe total loss of engine power for reasons that could not be determined based on available evidence and the pilot’s decision to take off without fully troubleshooting the partial loss of engine power that occurred during the previous flight.NTSB ERA19LA258Accident · No injuriesClass 3 · LimitedFinal reportBeech F33 · Hobe Sound, FLA bearing shift, which resulted in a loss of lubrication to the crankshaft, the failure of the crankshaft, and a total loss of engine power.NTSB ERA19LA253Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity XL-5 · St. Cloud, FLThe pilot’s failure to properly secure the airplane electrical system’s positive/negative leads to the 24v battery, which resulted in a total loss of electrical and engine power in flight.NTSB CEN19LA147Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210 · Yankeetown, FLA loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.NTSB ERA19FA142Accident · 1 fatalField investigationFinal reportRobinson R44 II · Tampa, FLContamination of and an inadequate bond between the two layers of fabric comprising the helicopter engine's air induction inlet duct, which resulted a partial collapse of the duct, obstruction of the airflow into the engine, and a total loss of engine power.NTSB ERA19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Palatka, FLThe pilot’s improper management of his fuel supply, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the outcome was the improper maintenance of the airplane’s ballistic recovery parachute system, which resulted in its…NTSB ERA19LA097Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLThe pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…