NTSB investigations, 2004
45 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 91 |
|---|---|
| 1983 | 77 |
| 1984 | 88 |
| 1985 | 82 |
| 1986 | 76 |
| 1987 | 58 |
| 1988 | 76 |
| 1989 | 67 |
| 1990 | 74 |
| 1991 | 62 |
| 1992 | 48 |
| 1993 | 53 |
| 1994 | 54 |
| 1995 | 60 |
| 1996 | 42 |
| 1997 | 43 |
| 1998 | 50 |
| 1999 | 35 |
| 2000 | 41 |
| 2001 | 28 |
| 2002 | 36 |
| 2003 | 24 |
| 2004 | 45 |
| 2005 | 33 |
| 2006 | 28 |
| 2007 | 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\") = 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\" = 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 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" = 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 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 SEA05LA032Accident · No injuriesLimited investigationFinal reportAerostar 601 · Hamilton, MTA partial loss of engine power due to the lack of lubrication and subsequent failure of the left engine's right turbocharger for undetermined reasons, and subsequent forced landing after takeoff. A factor was the unsuitable terrain for the forced landing.NTSB IAD05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150C · East Moriches, NYSeveral mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.NTSB NYC05LA030Accident · No injuriesLimited investigationFinal reportDay VP-2 · Warrenton, VAA loss of engine power for an undetermined reason.NTSB ATL05FA032Accident · 5 fatalField investigationFinal reportCessna 421B · Apison, TNThe pilot's improper identification of a partial loss of engine power on initial takeoff climb resulting in a collision with trees and the ground. A factor was a partial failure of the left engine starter adapter due to overload.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 CHI05CA036Accident · No injuriesData collectionFinal reportSpaulding Tailwind W-8 · Davey, NEThe loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.NTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB LAX05LA025Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Sierra Vista, AZAn inconsistency between the engines' two N2 sensor signals caused the fuel control to enter a fixed mode, which limited the power available. Contributing to the accident was the lack of altitude and airspeed available to give the pilot time to select a…NTSB LAX05LA002Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZa loss of engine power due to the fatigue fracture of the number 7 cylinder exhaust rocker arm as a result of a grinding operation during manufacture.NTSB ATL05LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Ashland, ALA total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.NTSB DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.NTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB CHI04CA261Accident · No injuriesData collectionFinal reportAbbott RAF 2000 · Pontiac, MIThe partial loss of engine power due to the scoring and overheating of the cylinders as a result of the pilot/owner's improper servicing of the modified engine cooling system. Additional factors included the pilot/owner modifying and servicing the engine…NTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.NTSB DEN04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Gillette, WYimproper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB MIA04LA123Accident · No injuriesLimited investigationFinal reportBell 206B3 · Panama City, FLInadequate maintenance inspection resulting in the partial loss of engine power due to a loose pneumatic line on the governor and ditching of the helicopter.NTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.NTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…NTSB NYC04LA192Accident · No injuriesLimited investigationFinal reportWaco QCF · Rhinebeck, NYA partial loss of engine power due to a magneto failure.NTSB DCA04IA066Incident · No injuriesIncident investigationFinal reportBoeing B-777 · Houston, TXthe failure of a high pressure turbine blade which damaged an oil seal and allowed smoke to enter the cabin. Contributing to the blade failure was the mis-labeling of the blade's part number by the manufacturer, which allowed the blade to remain in service…NTSB IAD04LA035Accident · Serious injuriesLimited investigationFinal reportGiles Mustang II · Rainelle, WVThe partial loss of engine power due to a broken throttle mechanism, which resulted in a forced landing over unsuitable terrainNTSB NYC04LA186Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Marlboro, MAThe loss of engine power due to a stuck cylinder exhaust valve. Factors were the tailwind and a jammed engine cylinder exhaust valve.NTSB SEA04LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Nyssa, ORThe failure (fracture) of the number four cylinder head during an aerial application run. Factors include the soft crop-covered terrain.NTSB DEN04LA112Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Rifle, COthe pilot's failure to maintain aircraft control during the aborted takeoff resulting in the airplane departing the runway and striking a runway light and two taxiway signs. Factors contributing to the accident were the broken sensor wire to the left engine's…NTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.NTSB DEN04CA101Accident · No injuriesData collectionFinal reportWhitlock Rotorway Exec 162F · Meeker, COaircraft control not maintained by the pilot. A contributing factor was the failure of the supercharger.NTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.NTSB NYC04LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brighton Beach, NYA partial loss of engine power during cruise flight for undetermined reasons.NTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB IAD04LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chatsworth, NJA blocked internal oil passage, which resulted in inadequate lubrication of the blower impeller shaft, and the subsequent partial loss of engine power.NTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.NTSB MIA04LA097Accident · No injuriesLimited investigationFinal reportGulfstream American AA5B · Crystal River, FLThe failure of the number three cylinder exhaust valve which resulted in the partial loss of engine power. The pilot's misjudgment of speed and distance resulted in an overrun of the runway.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 FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA04FA076Accident · 2 fatalField investigationFinal reportCessna 177RG · Tampa, FLImproper maintenance by other maintenance personnel, and the reinstallation of an unserviced magneto during an engine overhaul, which resulted in the magneto malfunctioning, a loss of engine power, and the airplane being ditched into the water.NTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.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 SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…NTSB SEA04LA064Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Belliigham, WAThe failure of the pilot to select the proper touchdown point while conducting a forced landing. Factors included the #1 engine malfunction, the right propeller oil control valve leak, and the shallow subsurface terrain condition.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 IAD04LA008Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Bedford, MAFailure of the #2 piston connecting rod cap, which resulted in a hole in the engine crankcase and a loss of engine power. A factor was dark night lighting condition.NTSB FTW04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Fort Worth, TXThe pilot's failure to maintain control and the partial loss of engine power as a result of an improperly installed mixture control linkage.