NTSB investigations, 2010
28 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 62 |
|---|---|
| 2009 | 57 |
| 2010 | 28 |
| 2011 | 37 |
| 2012 | 36 |
| 2013 | 40 |
| 2014 | 36 |
| 2015 | 36 |
| 2016 | 50 |
| 2017 | 40 |
| 2018 | 38 |
| 2019 | 46 |
| 2020 | 30 |
| 2021 | 35 |
| 2022 | 55 |
| 2023 | 57 |
| 2024 | 60 |
| 2025 | 41 |
| 2026 | 37 |
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\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' 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") = 2010 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' 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 DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB ENG11IA011Incident · No injuriesIncident investigationFinal reportBoeing 737 · San Francisco, CAThe probable cause of the undercowl in-flight engine fire was the insufficient installation torque of the bolts that secure the fuel manifold cover to the fuel manifold. Engine vibrations and fuel pressure cycles caused the bolts to gradually loosen further…NTSB WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.NTSB CEN11CA030Accident · No injuriesData collectionFinal reportConrad Theodore J Thorp T-18 · Fredericksburg, TXThe malfunction of the throttle clamp, which resulted in the pilot's inability to control the engine's power setting.NTSB ERA11CA013Accident · Minor injuriesData collectionFinal reportPiper PA28 · Louisville, KYThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and loss of engine power.NTSB ERA10TA493Accident · Minor injuriesFinal reportBell 412 · Brooklyn, NYThe fatigue fracture of the reduction gearbox output drive gear, which resulted in the loss of power output from the engines to the helicopter rotor blade system and a subsequent forced landing. The fracture of the output drive gear was caused by a fatigue…NTSB WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.NTSB CEN10CA541Accident · Minor injuriesData collectionFinal reportAerolite Bearcat · Mineola, TXFailure of the oil injection pump resulting in a total loss of engine power.NTSB WPR10LA419Accident · No injuriesLimited investigationFinal reportHummel / Finberg Ultra Cruiser · Canby, ORThe loss of engine power due to low cylinder compression.NTSB WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.NTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.NTSB ERA10LA376Accident · No injuriesLimited investigationFinal reportBeech K35 · Philadelphia, MSA throttle control malfunction during landing for undetermined reasons, resulting in a runway overrun.NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.NTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.NTSB CEN10LA295Accident · Minor injuriesLimited investigationFinal reportPitts Aerobatics S-2B · Amarillo, TXThe fracture of the fuel pump housing for undetermined reasons.NTSB ERA10TA261Accident · No injuriesFinal reportBell 407 · Abingdon, VAThe improper repair of an engine component by a repair facility, which resulted in a complete loss of engine power. Contributing to the accident was the failure of the repair facility to recognize that an improper repair had been accomplished, which allowed…NTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.NTSB ERA10LA229Accident · No injuriesLimited investigationFinal reportDalin Ronald K T-51 Mustang · Lakeland, FLThe builder’s use of inadequate material for the exhaust manifold adapters resulting in heat damage and chafing of the crankshaft synchronizer and timing wires that rendered an inoperative ignition system and loss of engine power.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB ERA10LA207Accident · 1 fatalLimited investigationFinal reportLuciano Edison HA-2 Sportster · Humacao, PRThe failure of the pilot to maintain control of the gyrocraft while maneuvering after takeoff. Contributing to the accident was the pilot’s operation of the gyrocraft with an inoperative right magneto.NTSB CEN10LA188Accident · Serious injuriesLimited investigationFinal reportBeech 95 · Eden Prairie, MNThe fatigue failure of an intake valve spring on the right engine, which resulted in a partial loss of engine power on takeoff.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.NTSB ERA10LA175Accident · 1 fatalLimited investigationFinal reportSmith Edward I Lancair IV-P · Hilton Head Island, SCA loss of engine power due to the failure of the crankshaft as a result of a previous propeller strike.NTSB CEN10LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Genoa City, WIA total loss of engine power due to the failure of the bolts that held in place the connecting rods to the engine's No. 3 and No. 4 cylinders as a result of the engine overhaul facility's improper installation of the bolts during a recent overhaul.NTSB WPR10LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Dolan Springs, AZThe fuel flow divider inlet line nut coming loose during cruise flight, resulting in a fuel leak and in-flight fire. The root cause of the loose B-nut fitting could not be determined. Contributing to the accident was the pilot's decision to fly the airplane…NTSB WPR10LA127Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Los Banos, CAA partial loss of engine power due to a failure of the throttle interconnect hardware, which resulted in a hard landing.NTSB WPR10LA126Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Escalon, CAA loss of engine power during cruise flight due to the fatigue failure of the pneumatic fuel-to-governor control line. Also causal was the inadequate installation of the pneumatic line by maintenance personnel, and the pilot’s decision to continue flight with…NTSB CEN10CA111Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Reserve, NMAn in-flight fire due to a fuel leak from the No. 5 cylinder's broken fuel injector/line.