NTSB investigations, CA
357 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 15 |
|---|---|
| 1983 | 10 |
| 1984 | 15 |
| 1985 | 18 |
| 1986 | 14 |
| 1987 | 14 |
| 1988 | 25 |
| 1989 | 17 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 18 |
| 1993 | 10 |
| 1994 | 8 |
| 1995 | 12 |
| 1996 | 17 |
| 1997 | 9 |
| 1998 | 14 |
| 1999 | 29 |
| 2000 | 9 |
| 2001 | 10 |
| 2002 | 13 |
| 2003 | 9 |
| 2004 | 13 |
| 2005 | 9 |
| 2006 | 8 |
| 2007 | 10 |
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\" = 351)
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" = 351) 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 SEA08LA033Accident · No injuriesLimited investigationFinal reportBeech A36 · El Centro, CAThe failure of maintenance personnel to properly secure the #2 cylinder through bolts. A contributing factor was the lack of suitable terrain for landing.NTSB LAX07TA277Accident · No injuriesFinal reportAir Tractor AT-802A · Big Bear City, CALoss of engine power while maneuvering due to the failure of the number 1 bearing that was caused by electrical discharge damage to the bearing originating from the starter-generator. Contributing to the accident was the operator's failure to follow the…NTSB LAX07LA236Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Goleta, CAThe oil starvation and failure of the number one piston connecting rod and bearing that was due to the fragmentation of the number 2 main bearing, which then obstructed the engine oil pickup tube and restricted the flow of oil through the engine.NTSB LAX07LA234Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ramona, CAA total loss of engine power due to a short circuit between both magneto ground leads. A factor in the accident was the inadequate annual/100-hour maintenance inspection regarding the wires.NTSB LAX07LA218Accident · Minor injuriesLimited investigationFinal reportClement Zenith Zodiac CH601 · Rosamond, CAA total loss of engine power during approach due to the improper idle screw/stop adjustment. A factor contributing to the accident was deteriorated fuel.NTSB SEA07LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chowchilla, CAThe loss of engine power as the result of the fatigue fracture and separation of two compressor turbine blades, which induced a catastrophic failure of the compressor turbine section.NTSB SEA07LA172Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Oceanside, CAThe improper installation of the propeller governor (gasket) by maintenance personnel, which resulted in a oil exhaustion induced total loss of engine power. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA07CA144Accident · No injuriesData collectionFinal reportBillings/Humbyrd Thorpe T-18 · Corona, CAA loss of engine power during the initial climb due to a fuel system malfunction. The pilot's incorrect maintenance modification to the fuel system and continued operation with known deficiencies were factors.NTSB LAX07CA181Accident · No injuriesData collectionFinal reportDutton Air Camper · Atwater, CAa loss of power due to the failure of the number 2 connecting rod.NTSB LAX07CA146Accident · Minor injuriesData collectionFinal reportCessna 177RG · Perris, CAa loss of engine power while in cruise flight due to an improperly installed magneto housing by the owner/pilot.NTSB LAX07LA031Accident · No injuriesLimited investigationFinal reportRyan Navion B · Riverside, CAA leak in the fuel selector valve and gascolator that resulted in fuel starvation on takeoff due to air leakage into the fuel system. A contributing factor in the accident was the inadequate annual inspection performed by other maintenance personnel.NTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.NTSB LAX07LA005Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Upland, CADisconnection of the throttle control linkage due to improper maintenance, which resulted in a loss of engine power during initial climb.NTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.NTSB ENG06IA018Incident · No injuriesIncident investigationFinal reportBoeing 767-223(ER) · Los Angeles, CAThe HPT stage 1 disk failed from an intergranular fatigue crack because of GE's inadequate design of the CF6-80 series HPT stage 1 disk. The inadequate design of the disk resulted in a high stress area in the blade slot bottom aft corner that was at or nearly…NTSB LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.NTSB LAX06LA103Accident · No injuriesLimited investigationFinal reportHarwood Kenneth Lancair 360A · Thermal, CAA loss of engine power caused by the separation of the number three cylinder due to the improper torque on the hold down nuts.NTSB LAX06LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Mariposa, CAThe failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.NTSB LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.NTSB LAX05LA273Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palos Verdes, CAa loss of engine power due to the cyclic fatigue failure and separation of the number 4 piston.NTSB LAX05FA264Accident · 1 fatalField investigationFinal reportSan Joaquin Helicopters OH-58A+ · Lancaster, CAThe pinion to turbine shaft coupling failed in fatigue due to a misaligned turbine shaft, which resulted in a loss of engine power.NTSB LAX05GA231Accident · 2 fatalFinal reportEurocopter France EC120B · Fair Oaks, CAThe failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…NTSB LAX05LA208Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Pasadena, CAa fuel starvation induced loss of engine power due a failure of the electric fuel pump. A factor in the accident was the dark night lighting conditions.NTSB LAX05LA172Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Geyserville, CAA loss of engine power due to failure of the number 1 connecting rod bearing due to a probable oil starvation.NTSB LAX05LA140Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Paso Robles, CAthe separation of the number 4 engine cylinder due to improperly torqued cylinder hold down nuts. A finding in this accident was the lack of a shoulder restraint system in the airplane, which contributed to the occupants' injuries.NTSB LAX05LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Pauma Valley, CAthe loss of engine power due to an undetermined obstruction in the vent system for the fuel tanks and failure of the fuel caps to vent.NTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…NTSB LAX04LA292Accident · No injuriesLimited investigationFinal reportAmerican Champion 7ECA · Manchester, CAmaintenance personnel's failure to adequately torque the top spark plug on the number one cylinder, which resulted in a separation of that plug and a loss of engine power.NTSB LAX04LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ontario, CAa catastrophic engine failure due to the overheating of a connecting rod bearing, and the resulting failure of the rod, for undetermined reasons.NTSB LAX04LA257Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Castaic, CAa catastrophic engine failure due to oil exhaustion, which was caused by the failure of maintenance personnel to completely tighten the oil screen.NTSB LAX04LA251Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Perris, CAA loss of engine power due to oil exhaustion as a result of the mechanic's use of an incorrect gasket during the installation of the vacuum pump.NTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.NTSB LAX04TA202Accident · No injuriesFinal reportBell OH-58A+ · Bakersfield, CAloss of engine power due to the separation of the diaphragm portion of the repaired second-stage turbine nozzle from the rim portion due to the use of an inadequate cleaning method to clean the joint prior to the braze repair during overhaul by the…NTSB LAX04LA171Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Paso Robles, CAfuel system vapor lock due to the failure of the left exhaust stack clamp pin, which caused a separation of the exhaust stack from the muffler and the porting of hot exhaust gases onto the fuel lines.NTSB LAX04LA169Accident · Minor injuriesLimited investigationFinal reportStanley Glasair SH-2 · San Luis Obispo, CAThe loss of engine power due to the failure of the #3 cylinder piston and connecting rod for undetermined reasons.NTSB LAX04LA141Accident · No injuriesLimited investigationFinal reportVogt KR2S · Lompoc, CAa failure of the fuel pump, which induced a total loss of engine power.NTSB LAX04LA132Accident · 1 fatalLimited investigationFinal reportGillespie Sport Copter Vortex · Yuba City, CAa loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…NTSB LAX04LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Santa Rosa, CAthe failure of the number 2 cylinder barrel due to fatigue. The lack of suitable landing terrain was a factor in the accident.NTSB LAX04LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Riverside, CAengine oil exhaustion due to the extrusion of an oil filter converter plate gasket and the failure of the aircraft owner to comply with a mandatory Service Bulletin and a Federal Aviation Administration emergency Airworthiness Directive.NTSB LAX04LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Snelling, CAThe total loss of engine power due to oil starvation caused by the failure of the engine driven oil pump.NTSB LAX04LA039Accident · Serious injuriesLimited investigationFinal reportZivko Edge 540-T · King City, CAThe after market manufacturer's improper application of a crankshaft , which exceeded the original manufacturer's intended use. A factor in the accident was the oil covering the windscreen, which restricted the pilot's ability to see.NTSB LAX04LA029Accident · 1 fatalLimited investigationFinal reportNorth American T-28B · Hornbrook, CAa catastrophic engine failure from oil exhaustion due to inadequate maintenance installation of the lubricating system hoses.NTSB LAX04LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAA loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.NTSB LAX04LA015Accident · No injuriesLimited investigationFinal reportBell UH-1B · Durham, CASeparation of the power turbine shaft retaining bolt resulting in extensive power turbine area damage and a loss of shaft output power.NTSB LAX04TA018Accident · No injuriesFinal reportBell UH-1H · Sacramento, CAThe loss of engine power due to the fatigue failure of a planetary reduction gear.NTSB LAX03LA300Accident · 2 fatalLimited investigationFinal reportMcClanahan Stits Playmate SA-11 · Fontana, CAa loss of engine power due to oil starvation that was the result of misaligned main bearing halves that obstructed the oil galley passages. Since the history of the engine could not be reconstructed, the person or entity responsible for the bearing…NTSB LAX03LA226Accident · No injuriesLimited investigationFinal reportBell 47 G5 · Salinas, CAThe failure of a piston connecting rod during an aerial application, which resulted in a total loss of engine power and subsequent forced landing.NTSB LAX03LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Anaheim, CAFailure of company maintenance personnel to correctly install and safety wire the oil drain plug, which led to a loss of engine oil and a catastrophic internal failure of the engine.NTSB LAX03LA056Accident · No injuriesLimited investigationFinal reportNicholson Lancair 320 · Corona, CAThe pilot/builder's improper maintenance procedure for reattaching a high-pressure oil line, which resulted in the oil line disconnecting during flight, followed by a loss of oil and engine seizure.