NTSB investigations, 2012, CA
12 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 18 |
| 2010 | 16 |
| 2011 | 12 |
| 2012 | 12 |
| 2013 | 7 |
| 2014 | 14 |
| 2015 | 10 |
| 2016 | 10 |
| 2017 | 13 |
| 2018 | 10 |
| 2019 | 6 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 4 |
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\") = 2012
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\" = '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") = 2012 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" = '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 WPR13LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Modesto, CAFailure of the throttle control cable during maneuvering flight, which resulted in a partial loss of engine power.NTSB WPR12LA411Accident · No injuriesLimited investigationFinal reportCessna A185F · Cambria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB WPR12LA414Accident · No injuriesLimited investigationFinal reportCessna T210N · Bakersfield, CAA partial loss of engine power during the initial climb due to an in-flight fire of undetermined origin.NTSB WPR12LA321Accident · No injuriesLimited investigationFinal reportLoflin RV-7A · Novato, CAThe partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s failure to…NTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…NTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA228Accident · No injuriesLimited investigationFinal reportCessna 150L · Tulare, CAA partial loss of engine power, which was likely the result of carburetor icing.NTSB WPR12FA222Accident · Minor injuriesField investigationFinal reportCessna P210N · Glendale, CAThe partial loss of engine power during descent for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.NTSB WPR12LA141Accident · No injuriesLimited investigationFinal reportGrimm RV-9A · Santa Maria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…