NTSB investigations, 2002
54 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\") = 2002
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") = 2002 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 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.NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB SEA03LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Boise, IDThe failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the…NTSB ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB LAX03LA052Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Los Banos, CAThe improper engine overhaul by other maintenance personnel, which resulted in an exhaust valve failure and a total loss of engine power while in maneuvering flight.NTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…NTSB LAX03TA043Accident · No injuriesFinal reportBell 47G-3B-1 · Panaca, NVseparation of the no. 6 cylinder intake valve head from the valve stem, which resulted in a loss of engine power. The mechanism responsible for the valve failure is unknown.NTSB FTW03FA044Accident · 1 fatalField investigationFinal reportCessna 210L · Kentwood, LAThe failure of the #1 and #2 connecting rods during climb to cruise due to overheating, resulting from oil starvation. A contributing factor was the low cloud conditions limiting the pilot's visibility during the ensuing emergency landing.NTSB IAD03LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Middlesboro, KYThe pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.NTSB NYC03FA008Accident · Minor injuriesField investigationFinal reportPilatus PC-12/45 · Trenton, NJA power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.NTSB IAD03LA006Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · South Vienna, OHThe improper installation of the single drive, dual magneto, which resulted in its separation from the engine and a subsequent total loss of engine power. Factors included the crops in the forced landing field, and the night lighting conditions.NTSB LAX03FA005Accident · 1 fatalField investigationFinal reportGrumman AA-5A · Phoenix, AZfailure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.NTSB ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.NTSB LAX02LA292Accident · No injuriesLimited investigationFinal reportCessna 172RG · Del Mar, CAThe loss of engine power due to failure of the number three connecting rod cap. Also causal was the failure of the pilot of a previous flight to report an engine overspeed event precluding the performance of the appropriate maintenance inspection.NTSB LAX02LA279Accident · Serious injuriesLimited investigationFinal reportLockamy Sonex · Oxnard, CAthe loosening of the tapered spacer, which resulted in the propeller hub separating from the crankshaft. A factor in the accident was the unsuitable terrain for landing.NTSB IAD02FA091Accident · 2 fatalField investigationFinal reportPiper PA 32R-301T · Byram Township, NJthe improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…NTSB LAX02LA275Accident · No injuriesLimited investigationFinal reportHuene Velocity XL-RG · Fresno, CAAn in-flight exhaust stack separation during descent for landing resulting in loss of engine power and a forced landing to an open field.NTSB LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…NTSB SEA02LA161Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Rigby, IDThe failure of one or more compressor turbine blades resulting in a shutdown of the engine during initial climb resulting in a forced landing. Contributing factors were the eroded condition of the compressor turbine guide vane nozzles and the ditch which the…NTSB CHI02LA254Accident · No injuriesLimited investigationFinal reportGrumman C-1A · Roseville, ILThe failure and the resulting separation of the engine cylinder, which severed both electrical propeller control systems on the affected engine. A factor to the accident was the cornfield.NTSB ATL02LA159Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Haleyville, ALThe failure of maintenance personnel to perform an adequate inspection of loose intake components, which resulted in a total loss of engine power and subsequent emergency descent, forced landing, and collision with terrain in dark night conditions.NTSB CHI02LA246Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Roodhouse, ILThe loss of engine power due to the separation of a valve lifter.NTSB MIA02LA147Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Gainesboro, TNa total loss of engine power due to the failure of the main bearing, a loss of oil pressure and the seizure of a connecting rod, resulting in damage to the airplane during the subsequent forced landing.NTSB CHI02FA243Accident · Minor injuriesField investigationFinal reportCorken/Guillet Christen Eagle II · Kaneville, ILLoss of engine power due to an engine bearing failure.NTSB CHI02FA231Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Benton Harbor, MIThe pilot's failure to maintain airspeed above stall speed resulting in a stall/spin. Additional causes were the pilot not maintaining best glide airspeed and optimal glidepath following the loss of engine power. A factor to the accident was the engine…NTSB NYC02LA139Accident · No injuriesLimited investigationFinal reportMicket Avid Aerobat · Chesapeake, VAA total loss of engine power due to a seized cylinder, and the pilot's improper decision to conduct the flight with a known deficiency to the engine.NTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.NTSB SEA02LA123Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Weiser, IDThe fracture of the number 3 cylinder exhaust pushrod resulting in the exhaust valve's inability to open during the exhaust cycle and the subsequent engine stoppage. Contributing factors were the ditch and elevated roadway which the aircraft crossed during…NTSB MIA02LA121Accident · Minor injuriesLimited investigationFinal reportKenneth Parmerter Loehle 5151 Mustang · Lake Placid, FLThe pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…NTSB CHI02LA179Accident · No injuriesLimited investigationFinal reportWaltz RV-8 · Omaha, NEA loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.NTSB CHI02FA177Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Steward, ILA loss of engine power due to the fatigue failure of several number three cylinder through bolts and case studs, which resulted in the separation of the number three engine cylinder. A factor contributing to the accident was the rough terrain.NTSB LAX02GA209Accident · Serious injuriesFinal reportMcDonnell Douglas 369E · Ontario, CAThe mechanic's improper maintenance procedures (FOD prevention) during a 100-hour inspection, which resulted in foreign object damage (FOD) to the compressor section and catastrophic engine failure. Factors were the presence of vehicles and power lines…NTSB LAX02LA204Accident · No injuriesLimited investigationFinal reportBeech V35A · Cottonwood, AZThe loss of engine power as a result of the failure of the #1 lower connecting rod bolt due to fatigue.NTSB DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.NTSB LAX02LA197Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Brownsville, CAa loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed during a turn to reverse course back to the runway, resulting in a stall and collision with terrain.NTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.NTSB MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.NTSB MIA02FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Fort Lauderdale, FLThe excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.NTSB ATL02LA103Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Charleston, SCTotal loss of engine power due to oil system starvation. A factor was the transmission wire encountered during emergency descent.NTSB ANC02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKA total engine failure during cruise flight due to the disentegration of the number five cylinder piston. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB LAX02FA163Accident · 2 fatalField investigationFinal reportCessna T210M · Groveland, CAa catastrophic engine failure due to the fatigue fracture and failure of the crankshaft. A factor contributing to the accident was the unsuitable nature of the mountainous terrain for a successful forced landing. The precipitating cause of the fatigue…NTSB LAX02FA144Accident · Minor injuriesField investigationFinal reportCessna 177B · Fullerton, CAThe total loss of engine power during cruise flight resulting from oil exhaustion. The oil exhaustion resulted from deterioration and total failure of the oil filter converter plate gasket, which had not been replaced due to maintenance personnel's failure to…NTSB LAX02LA143Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Olivehurst, CAFuel starvation due to the failure of an engine accessory component. A contributing factor was the rough terrain.NTSB SEA02LA073Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Goshen, ORThe failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…NTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB NYC02LA077Accident · No injuriesLimited investigationFinal reportPiper J4A · Cincinnati, OHThe maintenance technician's failure to properly adjust the carburetor float. Factors were the unsuitable terrain.NTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…NTSB LAX02FA097Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Pomona, CAa total loss of engine power due to an excessively rich mixture setting in the carburetor. The overly rich operation of the carburetor was due to the overhaul shop's failure to obtain the proper clearance between the float and chamber walls, which allowed the…