NTSB investigations, 2011
17 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\") = 2011
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") = 2011 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 WPR12CA069Accident · Minor injuriesData collectionFinal reportCessna 208 · Mesquite, NVThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ENG12IA003Incident · No injuriesIncident investigationFinal reportBoeing 747-451 · Detroit, MIThe penetration of turbine blade fragments through the rear turbine case, which punctured the No. 4 bearing oil pressure supply tube, allowing misted oil to contact the hot engine case and ignite the undercowl fire. Contributing to the incident was the…NTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB ENG11IA051Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Denver, CO**This probable cause was modified on 4/5/2012. Please see the public docket for this accident to view the original probable cause.** The initial damage to the fan blades was caused by the ingestion of a Red-Tailed Hawk that caused one or more fan blades to…NTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.NTSB ERA11LA416Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hinesville, GAThe total loss of engine power due to the improper installation of the carburetor air filter by maintenance personnel, which resulted in the filter becoming dislodged and obstructing the carburetor. Contributing to the accident was the pilot did not maintain…NTSB WPR11FA348Accident · Minor injuriesField investigationFinal reportCessna 210-5(205) · Darby, MTThe fatigue failure of the aluminum air intake duct, which resulted in material being ingested into the engine cylinders and a subsequent loss of engine power during cruise flight.NTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…NTSB WPR11LA265Accident · No injuriesLimited investigationFinal reportAerovodochody L-29 Delfin · Reno, NVThe failure of a modified engine mount to keep the engine properly aligned, which resulted in partial failure of the rudder support structure due to the deflection of the jet engine exhaust.NTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB ERA11LA307Accident · No injuriesLimited investigationFinal reportFlightstar Flightstar II · Grantville, GAA total loss of engine power while maneuvering due to a seized piston.NTSB WPR11FA182Accident · 1 fatalField investigationFinal reportPiper PA-28RT · Cherry Valley, CAThe pilot’s continued flight in an area of low ceiling and visibility, which resulted in a collision with mountainous/hilly terrain.NTSB WPR11LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta II · North Las Vegas, NVThe partial loss of engine power for undetermined reasons. Contributing to the accident was the certified flight instructor's decision to continue the flight after the helicopter exhibited inadequate performance capabilities and an unresolved power production…NTSB WPR11LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Big Bear City, CAThe pilot’s failure to maintain the minimum single-engine control speed while on final approach for landing. Contributing to the accident was the pilot's decision to fly with a known deficiency in one engine and a loss of power in that engine for reasons that…NTSB WPR11FA114Accident · 1 fatalField investigationFinal reportMooney M20J · Furnace Creek, CAThe magneto clamps were not securely fastened to the mount, which led to a partial loss of engine power and a subsequent forced landing on unsuitable terrain.NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.