NTSB investigations, 2004
63 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 175 |
|---|---|
| 1983 | 165 |
| 1984 | 138 |
| 1985 | 155 |
| 1986 | 126 |
| 1987 | 129 |
| 1988 | 160 |
| 1989 | 129 |
| 1990 | 123 |
| 1991 | 128 |
| 1992 | 133 |
| 1993 | 115 |
| 1994 | 129 |
| 1995 | 151 |
| 1996 | 119 |
| 1997 | 91 |
| 1998 | 78 |
| 1999 | 91 |
| 2000 | 92 |
| 2001 | 70 |
| 2002 | 54 |
| 2003 | 78 |
| 2004 | 63 |
| 2005 | 65 |
| 2006 | 62 |
| 2007 | 59 |
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\") = 2004
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 year(c."eventDate") = 2004 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 CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…NTSB DFW05FA032Accident · Serious injuriesField investigationFinal reportHughes 369D · Zachary, LAThe loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…NTSB MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…NTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…NTSB ATL05LA026Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T-Bird II · Dunlap, TNThe pilot's improper flare during forced landing following a loss of engine power for undetermined reasons, which resulted in a hard landing. A factor was the separation of a fuel line, which resulted in fuel starvation to the engine.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB ATL05FA013Accident · 4 fatalField investigationFinal reportBeech BE-60 · Asheville, NCThe pilot's failure to follow emergency procedures and to maintain airspeed following a loss of engine power during takeoff, which resulted in an inadvertent stall/spin and subsequent uncontrolled impact with terrain. Contributing to the cause was inadequate…NTSB LAX05TA018Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZThe loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…NTSB ATL05LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Guntersville, ALTotal loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.NTSB DFW05LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Denton, TXThe loss of engine power due to the separation of the accessory drive gear bolts, and the failure of the starter-clutch assembly. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.NTSB FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…NTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.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 CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…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 DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…NTSB CHI04LA185Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Winterset, IAThe inadequate supervision by the certified flight instructor, fuel starvation, visual/aural detection precluded by the certified flight instructor's seat position, and the inadequate crew coordination of both pilots during the instructional flight. A…NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…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 CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…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 CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.NTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB CHI04LA147Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Manitowoc, WIFailure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…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 CHI04CA142Accident · No injuriesData collectionFinal reportKauffman Bede IV · Acme, MIEngine oil starvation and inadequate maintenance by the pilot.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 DEN04FA064Accident · Minor injuriesField investigationFinal reportCessna 150H · Boulder, COthe failed magneto and the lack of suitable terrain (lake) for a forced landing.NTSB FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.NTSB NYC04LA105Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Taylor, PAThe failure of the number 2 connecting rod, after a main bearing shift, which resulted in a catastrophic engine failure.NTSB MIA04LA067Accident · No injuriesLimited investigationFinal reportCessna 206 · Clewiston, FLThe failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.