NTSB investigations, CA
42 cases where the defining event was Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 6 |
| 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340') 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 ENG27LA001Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · San Francisco, CANTSB ENG25WA011IncidentClass 5 · ForeignAirbus A330 · Los Angeles, CANTSB WPR24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-201T · Sacramento, CAA loss of engine power during the initial climb due to the detachment of the turbocharger’s inlet sleeve as a result of the installation of an incorrect sleeve clamp.NTSB WPR24LA261Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Winchester, CAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.NTSB WPR24LA210Accident · No injuriesClass 3 · LimitedFinal reportLancair LC42-550FG · Humboldt Bay, CAMaintenance personnel’s incorrect installation of an engine rocker cover gasket, which resulted in oil exhaustion and subsequent loss of engine power during the initial climb.NTSB WPR24LA121Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series 5 · Yucca Grove, CAThe pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB WPR20LA193Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · Upland, CAThe inflight separation of the propeller assembly due to a fatigue fracture of the crankshaft. Contributing to the accident was the pilot’s restricted visibility during landing, which resulted in an excessive approach speed, a long landing, and subsequent…NTSB WPR19TA186Accident · No injuriesClass 3Final reportGlasair SH II · San Bernardino, CAA fuel leak caused by age-degraded fuel hoses, which resulted in a total loss of engine power and fire before takeoff. Contributing to the accident was inadequate maintenance.NTSB WPR19LA137Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Sutter, CAA loss of engine power due to the in-flight separation of the fuel control unit interconnect rod for reasons that could not be determined due to lack of available evidence.NTSB WPR19LA108Accident · Serious injuriesClass 3 · LimitedFinal reportEuropa XS · Winters, CAThe pilot's failure to properly install a wrist pin circlip, which resulted in internal damage to the No. 5 cylinder and a subsequent total loss of engine power.NTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…NTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…NTSB WPR18LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Redding, CAThe fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence.NTSB WPR18LA018Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Blythe, CAMaintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing.NTSB WPR17LA174Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Brawley, CAThe partial loss of engine power due to the overstress separation of three supercharger drive gear teeth.NTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.NTSB WPR17LA048Accident · No injuriesLimited investigationFinal reportSchosanski John H Cozy MK IV R · Napa, CAA partial loss of power due to missing apex seals.NTSB WPR16LA096Accident · No injuriesLimited investigationFinal reportDG Flugzeugbau DG 800B · Clements, CAThe motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…NTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.NTSB WPR15LA175Accident · No injuriesLimited investigationFinal reportMooney M20K · Fresno, CAA total loss of engine power during cruise flight due to a failure of the No. 1 piston and connecting rod assembly.NTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…NTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.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 WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.NTSB WPR11GA431Accident · Minor injuriesFinal reportBell 205 · Tehachapi, CAThe pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…NTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.NTSB WPR11LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · San Luis Obispo, CAThe loss of engine power due to the fatigue fracture of one attachment bolt for the left idler gear shaft, which resulted from an insufficient preload on both attachment bolts.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 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 WPR10FA056Accident · 1 fatalField investigationFinal reportBeech A36 · San Gabriel, CAFailure of the exhaust band V-clamp during cruise flight, which resulted in an in-flight fire and a subsequent forced landing.NTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.NTSB WPR09LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Oceanside, CAA total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.NTSB LAX08LA195Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58C · Fresno, CAThe loss of engine power due to fatigue failure of a second stage compressor blade.NTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…