NTSB investigations, 2016, CA
13 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 31 |
|---|---|
| 2009 | 36 |
| 2010 | 21 |
| 2011 | 30 |
| 2012 | 24 |
| 2013 | 19 |
| 2014 | 13 |
| 2015 | 17 |
| 2016 | 13 |
| 2017 | 27 |
| 2018 | 12 |
| 2019 | 16 |
| 2020 | 17 |
| 2021 | 10 |
| 2022 | 9 |
| 2023 | 6 |
| 2024 | 12 |
| 2025 | 9 |
| 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\") = 2016
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2016 AND c."eventStateOrRegion" = 'CA' 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 WPR17LA036Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210M · Mecca, CAThe total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.NTSB GAA16CA408Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206 · Modesto, CAThe pilot's failure to maintain pitch control during an autorotation, which resulted in abnormal ground contact and main rotor contact with the tail boom. Contributing to the accident was the low fuel level which resulted in fuel starvation and a loss of…NTSB WPR16LA149Accident · No injuriesLimited investigationFinal reportSwartz Gene Titan T 51 Mustang · Lancaster, CAA total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.NTSB GAA16CA330Accident · Minor injuriesData collectionFinal reportCessna 152 · Clearlake Oaks, CAThe pilot's deviation from his original flight plan, which resulted in becoming lost in mountainous terrain at night, fuel exhaustion, loss of engine power, and a collision with power lines during a forced landing.NTSB WPR16LA125Accident · No injuriesLimited investigationFinal reportBell 206 · Bishop, CAThe pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…NTSB WPR16FA118Accident · 2 fatalField investigationFinal reportMoore Joseph O Varieze · Santa Paula, CAA total loss of engine power due to fatigue failure of the camshaft drive gear teeth.NTSB WPR16LA122Accident · Minor injuriesLimited investigationFinal reportRans S 5 · Lodi, CAA total loss of engine power due to fuel starvation as the result of a pinched fuel line. Contributing to the accident was the pilot’s maneuvering just before landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an…NTSB WPR16LA107Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Acampo, CAA total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…NTSB WPR16LA101Accident · No injuriesLimited investigationFinal reportAntonov AN2 · San Bernardino, CAThe mechanic’s failure to inspect the fine fuel filter gascolator as required during the most recent inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB WPR16LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Selma, CAThe total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.NTSB WPR16LA074Accident · No injuriesLimited investigationFinal reportMooney M20J · Pacoima, CAA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB WPR16LA066Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Santa Barbara, CAA total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.NTSB WPR16LA050Accident · 1 fatalLimited investigationFinal reportMoore Onex · Fresno, CAThe pilot/builder's failure to properly align the Force One Main Bearing, which resulted in a blockage of the oil transfer hole and culminated with a total engine power loss. Contributing to the accident was the pilot's failure to arrest the bank and sink…