NTSB investigations, 1992
133 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\") = 1992
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") = 1992 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 MIA93LA037Accident · Serious injuriesLimited investigationFinal reportBunn, Richard B. Swearingen SX300 · Montgomery, ALThe pilot in command's decision to operate the aircraft with known fuel leaks and his failure to monitor fuel quantity en route which resulted in loss of engine power due to fuel exhaustion.NTSB DEN93LA018Accident · No injuriesLimited investigationFinal reportCessna 172E · Ramah, COA total loss of engine power due to mechanical failure of the number one connecting rod. A factor was: a forced landing onto unsuitable terrain.NTSB LAX93LA071Accident · No injuriesLimited investigationFinal reportHughes 369D · Hilo, HIThe bearing failures due to the operator's use of improper maintenance inspection and overhaul procedures by installing an unserviceable compressor module in the helicopter engine. Factors in the accident were the unsuitable nature of the terrain for the…NTSB ATL93LA040Accident · No injuriesLimited investigationFinal reportShaw Velocity HXB · Savannah, GAThe disengagement of the idler gear, which interrupted fuel pump operation, and resulted in the total loss of engine power. Factors were the lack of suitable terrain and the water.NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB MIA93LA029Accident · Minor injuriesLimited investigationFinal reportHighcraft Buccaneer II · Rockledge, FLThe total failure of the engine-driven fuel pump on takeoff initial climb. A factor was unsuitable terrain.NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB LAX93LA062Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Kamuela, HIThe inadequate 100-hour inspection performed by company maintenance personnel. Factors contributing to this accident are the fuel control exceeding the manufacturers' service limits; the inoperative fuel filter; the overtemperature of the gas generator…NTSB ANC93LA016Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Hope, AKThe failure of the no. two cylinder connecting rod due to a slipped (spun) main crankshaft bearing which blocked off the oil hole to the connecting rod. A factor in the accident was the unsuitable terrain on which to perform a forced landing.NTSB LAX93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Rialto, CAThe pilot's poor preflight inspection and his failure to maintain flying speed during the forced landing. Conributing to this accident was the inadvertent stall, the preceding sand/dust storm, the engine assembly low compression due to sand in the intake and…NTSB LAX93LA051Accident · Serious injuriesLimited investigationFinal reportCessna 421C · Santa Maria, CA1) The internal failure of the left engine, left magneto due to inadequate maintenance and non compliance with the manufacturers service bulletins and recommendations, and 2) the failure of the pilot to attain the proper touchdown point during the landing…NTSB BFO93LA009Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Dublin, VAImproper adjustment of the fuel pressure regulator which produced an inadequate fuel flow and subsequent fuel starvation. Factors related to the accident were: the rough terrain and trees in the emergency landing area.NTSB LAX93FA042Accident · 2 fatalField investigationFinal reportCessna TU-206F · Clearlake, CAThe exhaust valve failing due to a complete fracture which resulted in the total lose of engine power. Factors in this accident were: 1) the terrain not being suitable for a forced landing, and 2) low ambient light which hampered the pilot's ability to see…NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB FTW93LA036Accident · No injuriesLimited investigationFinal reportCessna 210B · Mountain View, ARThe collapsed right main gear due to the gear locking mechanism not being engaged. A factor was the failed crankshaft.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB FTW93LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Liverpool, TXThe loss of engine power due to the failure of the engine blower. A factor was the lack of suitable terrain at the pilot's disposal.NTSB MIA93LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Pierce, FLAn engine failure over unsuitable terrain. The cause of the engine failure was fuel contamination by ferrous metal particles that prevented the fuel servo from operating properly. The origin of the contamination is unknown.NTSB LAX93LA016Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Globe, AZMaintenance personnel failing to comply with airworthiness directives pertaining to the airplane's fuel bladders resulting in fuel capacity being decreased causing fuel exhaustion and subsequent loss of engine power.NTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.NTSB SEA92LA216Accident · No injuriesLimited investigationFinal reportCessna 182L · Vancouver, WAThe partial loss of engine power from failure of the no 5 piston, and the soft terrain at the forced ldg site, resulting in collapse of the nose landing gear.NTSB LAX92IA397Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 10-10 · San Francisco, CAA fractured compressor assembly.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB ATL92LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Jasper, TNThe fractured valve which resulted in a total loss of engine power, while flying over terrain that was not suitable for a forced landing. A factor was the densely wooded, mountainous terrain.NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.NTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.NTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.NTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB LAX92LA377Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, CAThe unknown pilots improper use of the throttles which resulted in the overboosting of the engine. Contributing to the accident was the maintenance personnel improper maintenance in adjusting the turbocharger wastegate and the oil leaking from the engine…NTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…NTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.NTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.NTSB CHI92LA263Accident · No injuriesLimited investigationFinal reportCessna 402B · Almont, MIExcessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.NTSB LAX92LA368Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe shutdown of the engine due to the failure of the muffler and the resulting heat induced shorting of the magneto ground wires, and the inadequate maintenance inspection of the muffler and the engine exhaust system.NTSB ANC92LA142Accident · No injuriesLimited investigationFinal reportCessna 140 · Wasilla, AKThe partial loss of engine power due to the separation of the right hand exhaust stack. Contributing to the accident was the unsuitable terrain on which the forced landing was made.NTSB FTW92DPG14Accident · No injuriesFinal reportAir Tractor AT-300 · Wilmont, ARPower loss due to a failed cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.NTSB ATL92LA154Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Cobb, GAThe corroded, and separated, magnetic chip detector plug which allowed the loss of all engine oil and the engine's subsequent seizure. Factors were the inadequate 100 hour inspection, and the high vegetation in the forced landing field.NTSB CHI92LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Xenia, ILImproper engine overhaul and noncompliance with an airworthiness directive by other maintenance personnel.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB LAX92LA327Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Glendale, AZA loss of engine power due to excessive carbon deposits on the number one cylinder exhaust valve, and, the pilots attempted operation of the aircraft with known mechanical deficiencies.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.NTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.NTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…NTSB ANC92LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Wasilla, AKFailure of the engine crankshaft due to an oil passage hole being blocked. Contributing to the accident was the unsuitable terrain.