NTSB investigations, 1997
43 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
Latest 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\") = 1997
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") = 1997 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 LAX98LA053Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369HS · Saipan, IndiaThe failure of the maintenance facility to comply with the service bulletins, which resulted in the development of a corrosion pit, subsequent leakage and failure of the acceleration bellows of the fuel control.NTSB CHI98LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Lincoln, NEthe throttle linkage coming apart in flight, and the inadvertent stall.NTSB NYC98FA018Accident · No injuriesField investigationFinal reportEnstrom F-28C · Fairview, PAinadequate maintenance, which led to detonation and a melted piston, and subsequent power loss.NTSB MIA98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Jackson, MSA partial loss of engine power during the initial climb due to a blockage of the induction system by a piece of gasket material.NTSB ANC97LA158Accident · No injuriesLimited investigationFinal reportPilatus PC-6-350 · Palmer, AKAn underspeed of the propeller system.NTSB MIA97LA251Accident · No injuriesLimited investigationFinal reportCessna 170 · Troy, NCdelay of the pilot to abort the takeoff after noting sluggish acceleration during the takeoff roll. Factors relating to the accident were: improper timing of the magneto(s), and a malfunction of the carburetor.NTSB CHI97LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Champaign, ILan undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.NTSB NYC97LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Easton, NYmechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…NTSB MIA97LA250Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Miami, FLThe failure of the pilot to properly plan his descent and approach for a forced landing following partial loss of engine power resulting in the aircraft landing short of the intended landing runway. A factor in the accident was improper inspection of the…NTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…NTSB ANC97LA141Accident · No injuriesLimited investigationFinal reportCessna 150H · Yakutat, AKA partial blockage of the main fuel supply line to the engine, caused by improper manufacture of the fuel line by unknown maintenance personnel.NTSB ATL97LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clewiston, FLThe crack in the #8 cylinder head which led to the loss of power. A factor was the soft terrain.NTSB FTW97LA322Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Columbus, NMa loss of engine power due to failure of an exhaust side rocker box and valve mechanism, and pilot incapacitation due to loss of consciousness after being struck in the head by parts separating from the engine.NTSB MIA97LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Waynesboro, GAThe obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.NTSB SEA97LA186Accident · No injuriesLimited investigationFinal reportCessna 172M · Langley, WAA failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing. .NTSB FTW97LA298Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Castle Rock, COA partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.NTSB LAX97LA261Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZA partial loss of engine power due to a loose rocker arm adjustment nut on the number 6 cylinder. The loose adjustment nut was due to inadequate maintenance adjustment performed by the engine manufacturer.NTSB FTW97LA258Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Dallas, TXThe pilot-in-command's failure to follow emergency procedures to reduce drag and maintain best climb airspeed. Factors were the partial loss of engine power due to the cracks in the #1 and #4 cylinders as the result of an unapproved modification of their…NTSB ANC97FA099Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 · Skwentna, AKa loss of engine power due to the fatigue failure of the no.1 exhaust push rod. Factors contributing to the accident were: insufficient information on pushrod inspection and overhaul from the manufacturer, unsuitable terrain available for landing, and the…NTSB NYC97LA132Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Yates, NYThe failure of the cylinder bolts, and the lack of suitable terrain for a forced landing.NTSB SEA97LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Ogden, UTThe fracture of the no. 4 exhaust valve and subsequent loss of engine power. Factors contributing to the accident include a congested landing area, and rough terrain.NTSB CHI97FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Canton, MIA loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.NTSB LAX97LA224Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28-F · Riverside, CAfailure by unknown maintenance personnel to retorque the nuts on the retainer cover.NTSB NYC97LA128Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bellwood, PAthe total loss of engine power due to failed connecting rods.NTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.NTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA97LA182Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Waycross, GAthe private pilot's failure to maintain airspeed, while maneuvering in an attempt to reverse direction, which resulted in an inadvertent stall, and subsequent in-flight collision with terrain.NTSB IAD97LA085Accident · Serious injuriesLimited investigationFinal reportMc Ardle Kolb Mark III · Findlay, OHThe loss of power due to one of two carburetors disconnecting in flight for undetermined reasons, and the subsequent collision with the terrain during forced landing.NTSB NYC97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Preston, MDThe pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.NTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.NTSB FTW97LA185Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Torreon, NMfailure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…NTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…NTSB LAX97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tucson, AZThe partial blockage of the No. 2 cylinder injection line/nozzle by a transient contaminant, which induced an excessively lean mixture in that cylinder, and the subsequent overheating of the cylinder and intake valve. The engine power loss was due to the open…NTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.NTSB CHI97FA093Accident · 1 fatalField investigationFinal reportStinson 108 · Greenfield, INa loss of engine power due to restricted movement in the exhaust valve and rotted/weathered ignition harness, and the pilot's failure to maintain airspeed which resulted in an inadvertant stall.NTSB ANC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial loss of engine power due to a fractured connecting rod bolt, which was precipitated by fatigue. A factor associated with the accident was the snow covered terrain in the emergency landing site.NTSB FTW97LA117Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Newkirk, OKThe partial loss of engine power due to failure of the blower (integral supercharger). A factor was the power line over which the pilot had to maneuver during the forced landing which resulted in insufficient airspeed to flare the airplane.NTSB SEA97LA061Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morgan, UTDisconnection of the mixture control wire wound cable sheath. A factor was the abrupt, elevated edge of the highway pavement.NTSB ATL97IA035Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAfailure of the Stage 1 High Pressure Turbine due to a fatigue fracture in a disk blade retention lug.NTSB FTW97LA086Accident · Serious injuriesLimited investigationFinal reportMahan Starduster II · Atlanta, TXimproper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB LAX97LA088Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Kamuela, HIfuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…