NTSB investigations, 2012
16 cases where NTSB found Power plant.
Cases per year
| 2008 | 25 |
|---|---|
| 2009 | 24 |
| 2010 | 31 |
| 2011 | 17 |
| 2012 | 16 |
| 2013 | 8 |
| 2014 | 10 |
| 2015 | 8 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 7 |
| 2019 | 20 |
| 2020 | 13 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 14 |
| 2024 | 25 |
| 2025 | 4 |
| 2026 | 1 |
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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010571'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010571')) 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 CEN13LA072Accident · Serious injuriesLimited investigationFinal reportBeech S35 · DeRidder, LAA total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…NTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe 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 CEN13IA008Incident · No injuriesIncident investigationFinal reportMueller Michael Walter Challenger II CW SPC · Sandwich, ILA total loss of engine power due to significant engine corrosion. Contributing to the accident was inadequate engine maintenance.NTSB CEN12LA650Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Rio Vista, TXThe catastrophic failure and disintegration of the No. 6 engine piston, which resulted in a total loss of engine power.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 ERA12LA503Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Homerville, GAThe loss of engine power due to debris within the engine-driven fuel pump.NTSB CEN12CA474Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Houston, TXThe pilot’s inadequate preflight inspection, which failed to detect the unsecured cowling latches and resulted in the in-flight opening of an engine cowling.NTSB ANC12LA068Accident · No injuriesLimited investigationFinal reportShorey Timothy A Preceptor Stol King · North Pole, AKA total loss of engine power due to a binding drive belt while in the airport traffic pattern.NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB CEN12LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Frankenmuth, MIA partial loss of engine power for undetermined reasons and the pilot’s failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB WPR12LA182Accident · No injuriesLimited investigationFinal reportMays Kitfox Lite 2 · Cedarville, CAA loss of engine power during cruise flight due to air in the fuel system. Contributing to the accident was the pilot’s incorrect maintenance that did not properly secure the fuel lines.NTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.NTSB CEN12LA224Accident · No injuriesLimited investigationFinal reportCessna U206B · Winterset, IAThe loss of oil pressure to the No. 4 connecting rod journal and the subsequent loss of engine power.NTSB CEN12FA217Accident · 1 fatalField investigationFinal reportOliver Joseph Zodiac CH 601XL · Belmont, OHThe loss of engine power and the pilot’s diverted attention to the engine power loss, which resulted in a rapid descent and impact with terrain.NTSB CEN13WA102Incident · No injuriesForeign investigationRobinson Helicopter R44 · Oosterschelde, NetherlandsOn January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…NTSB ERA12FA143Accident · Serious injuriesField investigationFinal reportCessna 150G · Fitchburg, MAA partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.