NTSB investigations, CA
168 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 12 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 7 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 8 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 1 |
| 1998 | 9 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 1 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 6 |
| 2007 | 3 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 SEA07LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Redlands, CAThe restriction of the carburetor float as a result of a misadjusted retractor clip. A contributing factor was the fire.NTSB LAX07LA179Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Napa, CAFailure of the number 5 connecting rod due to oil starvation.NTSB ENG07IA018Incident · No injuriesIncident investigationFinal reportLearjet · Palm Springs, CAThe fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…NTSB LAX07LA040Accident · No injuriesLimited investigationFinal reportStinson 108-1 · San Jose, CAPartial loss of engine power due to a seized exhaust valve during cruise flight. Rough terrain at the forced landing site was a contributing factor.NTSB LAX07FA035Accident · 3 fatalField investigationFinal reportCessna 421B · Big Bear Lake, CAFailure of the turbine wheel shaft in the left turbocharger during the takeoff initial climb for undetermined reasons, and the pilot's failure to attain and maintain safe single engine airspeed that led to a loss of control.NTSB LAX07LA022Accident · Serious injuriesLimited investigationFinal reportFish Vans RV-6 · Turlock, CAa partial loss of engine power due to the broken piston rings in the no. 4 cylinder. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in a stall/mush.NTSB LAX06LA230Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAa loss of engine power due to the failure of maintenance personnel to tighten the top spark plugs, and install the leads for the ignition harness to the top spark plugs.NTSB LAX06CA191Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Alpine, CAa loss of engine power due to the aviation maintenance technician's failure to install the correct oil sump quick drain, which resulted in the inadvertent draining of engine oil during flight.NTSB LAX06CA088Accident · Serious injuriesData collectionFinal reportHuntington KIS · Camarillo, CAa partial loss of engine power due to the engine's electronic control system reverting to a designed reduced power mode of operation.NTSB LAX06CA035Accident · No injuriesData collectionFinal reportVans RV-4 · Apple Valley, CAa partial loss of engine power for undetermined reasons.NTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.NTSB LAX05CA285Accident · No injuriesData collectionFinal reportBellanca 7ECA · Malibu, CAa partial loss of engine power for undetermined reasons.NTSB LAX05LA173Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Sonoma, CAa partial loss of engine power, which resulted from the fuel servo leaking and generating an excessively rich fuel/air mixture. A factor was the owner's failure to comply with a service bulletin.NTSB LAX05LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Willows, CAthe loss of engine power due to the fractured piston pin boss on the number 5 cylinder.NTSB LAX05LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Yuba City, CAa partial loss of engine power due to multiple cracks in the number 7 cylinder. The reasons for the cracks were not determinedNTSB LAX05LA141Accident · Serious injuriesLimited investigationFinal reportBailey Lowing Loadster · Bakersfield, CAthe loss of engine power for undetermined reasons.NTSB LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.NTSB LAX05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Big Pine, CAoil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…NTSB LAX04LA267Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Richvale, CAthe loss of engine power during takeoff due to the engine's deteriorated fuel control unit's inner drive shaft bearing. The reason for the bearing's deteriorated condition could not be determined.NTSB LAX04FA187Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · Concord, CAa loss of engine power due to improper maintenance repair procedures and use of improper parts.NTSB LAX04LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Planada, CAthe partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…NTSB LAX03LA059Accident · Serious injuriesLimited investigationFinal reportFarmer R B DA5-A · Apple Valley, CAthe detonation of the number 1 and 3 cylinders and the subsequent over temperature of those cylinders and their corresponding pistons.NTSB LAX03LA004Accident · No injuriesLimited investigationFinal reportRans S-12 XL · Los Banos, CAThe loss of engine power for undetermined reasons and his failure to maintain adequate airspeed resulting in a stall. A contributing factor was the pilot's decision to conduct a downwind takeoff.NTSB LAX03GA001Accident · Serious injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAan engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…NTSB LAX02LA249Accident · Minor injuriesLimited investigationFinal reportArns Spacewalker II · Irvine, CALoss of engine power due to an exhaust system leak and vapor lock.NTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.NTSB LAX02LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Lake Thomas A., CAa partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…NTSB LAX02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Oak Shores, CAthe number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.NTSB LAX02LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lake Los Angele, CAa reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…NTSB LAX01FA199Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe student pilot's selection of a takeoff runway conducive to a tailwind weather condition and his failure to maintain airspeed and his inadvertent stall during takeoff initial climb. Factors in the accident were the partial loss engine power resulting from…NTSB LAX01LA195Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Butte City, CAa fatigue failure of a propeller bolt.NTSB LAX01LA161Accident · Serious injuriesLimited investigationFinal reportTaylor Bandit · Marysville, CAThe pilot performed an inadequate preflight inspection resulting in a loss of engine power at a low altitude because of water contamination.NTSB LAX01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Paradise, CAFuel exhaustion during a descent due to an inadequate fuel supply. Contributing factors were the pilot's improper preflight planning, his misjudged altitude while performing the emergency landing, and his lack of certificate qualification and recent flight…NTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB LAX00LA260Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Ana, CAThe loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.NTSB LAX00LA157Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Yreka, CAthe total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…NTSB LAX00LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Dos Palos, CAA partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.NTSB LAX00FA061Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Avalon, CAA loose pneumatic fitting caused the engine to go to flight idle power at a low altitude, which resulted in a forced landing in hilly terrain.NTSB LAX00LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150H · El Monte, CAA cracked No. 2 engine cylinder, which led to a loss of power. A factor was the ditch in the forced landing area.NTSB LAX99LA245Accident · No injuriesLimited investigationFinal reportHughes 369D · Oakdale, CAThe disintegration and failure of the oil pump drive spur gear aft bearing, which resulted in failure of the oil pump and subsequent oil starvation to the engine's turbine module. A factor in the accident was the failure of company maintenance personnel to…NTSB LAX99LA007Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lost Hills, CAA loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.NTSB LAX98LA265Accident · No injuriesLimited investigationFinal reportRaymond C. Voegele Mini IMP RC-2 · Sonoma, CAA loss of power due to a loose magneto cap and a binding throttle control cable. The deficiencies were the result of the owner/pilot's improper installation and/or adjustments.NTSB LAX98LA250Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Corona, CAThe loss of engine power due to a partially closed fuel shutoff valve as a result of improper maintenance installation.NTSB LAX98LA243Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Temecula, CAA partial loss of engine power due to a disconnected throttle linkage, which was the result of an inadequate maintenance installation/inspection.NTSB LAX98LA230Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hyampom, CAInadequate annual inspection that resulted in a partial loss of engine power due to a missing bolt, nut, and cotter pin from the throttle/carburetor assembly.NTSB LAX98LA182Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Livermore, CAThe missing nut/cotter pin on the throttle attachment assembly which resulted in the pilot's inability to control engine power, and the hidden obstruction (hole) in the landing area. A factor was the high vegetation.NTSB LAX98LA159Accident · No injuriesLimited investigationFinal reportBell 206B · Temecula, CAA loss of engine power due to a deteriorated compressor air seal which resulted in the fracture and separation of several stator vanes. Deterioration was not detected as a result of an inadequate maintenance inspection frequency.NTSB LAX98IA158Incident · No injuriesIncident investigationFinal reportNorth American NA265-65 · Palm Springs, CAthe fatigue failure and uncontained separation of the high pressure impeller in the No. 2 engine during the takeoff roll. While the impeller showed evidence of a subsurface fatigue origin, the percipient cause of the separation was not definitively determined.