NTSB investigations, 2015
5 cases where NTSB found Engine controls.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 27 |
| 2010 | 9 |
| 2011 | 21 |
| 2012 | 14 |
| 2013 | 12 |
| 2014 | 10 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 13 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 7 |
| 2022 | 8 |
| 2023 | 7 |
| 2024 | 8 |
| 2025 | 6 |
| 2026 | 1 |
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\") = 2015
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010576'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010576')) 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 CEN15LA308Accident · Serious injuriesLimited investigationFinal reportDevoe Clip Wing · Melbourne, ARThe loss of engine power for reasons that could not be determined based on the available evidence and the postaccident engine examination, which led to a forced landing on unsuitable terrain due to the pilot’s decision not to deploy the ballistic parachute…NTSB WPR15LA162Accident · No injuriesLimited investigationFinal reportEarl Allen Miglet · Corning, CAThe partial loss of engine power during initial climb due to a loose set screw, which allowed the throttle cable rig within the connector to slip.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 CEN15LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Lonoke county, ARThe loss of engine power due to fuel starvation.NTSB ERA15CA095Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, METhe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.