NTSB investigations, 1997
44 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 33 |
|---|---|
| 1983 | 43 |
| 1984 | 74 |
| 1985 | 60 |
| 1986 | 60 |
| 1987 | 55 |
| 1988 | 64 |
| 1989 | 44 |
| 1990 | 48 |
| 1991 | 67 |
| 1992 | 52 |
| 1993 | 45 |
| 1994 | 53 |
| 1995 | 44 |
| 1996 | 27 |
| 1997 | 44 |
| 1998 | 35 |
| 1999 | 37 |
| 2000 | 45 |
| 2001 | 37 |
| 2002 | 29 |
| 2003 | 39 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 29 |
| 2007 | 34 |
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\" = 354)
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" = 354) 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 NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.NTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…NTSB ANC98LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Alakanuk, AKthe pilot's mismanagement of the airplane's fuel which led to the loss of engine power due to fuel starvation.NTSB FTW98LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Galveston, TXinadequate maintenance and/or preflight inspection of the airplane, and subsequent blockage of the fuel filters, which led to fuel starvation, partial loss of engine power in both engines, and a forced landing. A related factor was the lack of suitable…NTSB FTW97LA367Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Mora, NMloss of power in the right engine for undetermined reason(s). Related factors were: that the power loss occurred above the airplane's single engine service ceiling (at high density altitude), and the lack of suitable terrain for a forced landing.NTSB ATL97LA138Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairview, NCfuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.NTSB ANC97LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel tanks. Factors were the worn gaskets on the fuel tank caps, and the pilot's decision to abort the partial power precautionary landing.NTSB LAX97LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-180 · Reno, NVThe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush. Factors in the accident were: the pilot's lack of qualification in the aircraft; the FAA pilot certification system's failure to transfer the…NTSB ANC97LA139Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Paxson, AKThe pilot's improper use of carburetor heat during a takeoff in carburetor icing conditions. Factors associated with the accident were the pilot's decision to operate the airplane with known deficiencies (a disabled stall warning horn), an inadvertent stall,…NTSB LAX97FA292Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Kernville, CAThe partial loss of engine power due to the operator's inadequate engine maintenance relating to excessively rich mixtures (high fuel flow rates) and spark plug/magneto deficiencies. Contributing factors were degraded climb performance resulting from the high…NTSB ATL97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Milan, TNThe loss of partial engine power due to undetermined reasons. A factor was the favorable atmospheric conditions for carburetor icing.NTSB LAX97FA272Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Hesperia, CAfailure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…NTSB CHI97LA226Accident · No injuriesLimited investigationFinal reportBeech D50A · Mitchell, NEthe pilot's improper fuel selector position and the fuel starvation. Factors contributing to the accident were: the pilot's inattentiveness of the refueling, inadequate aircraft preflight, and the rough terrain/ditch.NTSB MIA97FA217Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Naples, FLleaking fuel cap(s), due to inadequate maintenance/repair, which resulted in water contamination of the fuel; inadequate preflight by the flight crew; and improper planning/decision by the flight crew. Factors relating to the accident were: high obstructions…NTSB SEA97LA173Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Graham, WAInadequate aircraft preflight by the pilot-in-command, and water contamination in the fuel resulting in a loss of engine power. A factor was a power transmission line in the forced landing area.NTSB FTW97LA270Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Amelia, LApartial loss of engine power due to frog(s) being ingested into the engine. Factors relating to the accident were: the lack of altitude and lack of suitable terrain for a forced landing.NTSB ANC97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKwater contamination of the fuel supply. Soft, unsuitable terrain for the precautionary landing were factors.NTSB NYC97LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Wildwood, NJThe pilot's inadequate use of carburetor heat, which resulted in carburetor icing.NTSB CHI97TA198Accident · Minor injuriesFinal reportCessna 182R · Peoria, ILthe pilot's improper use of carburetor heat and the carburetor icing conditions which existed at the time of the accident. Factors were the ditch and poles which the airplane contacted.NTSB CHI97LA197Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Middleville, MIfuel contamination, due to improper servicing of the aircraft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a inadvertent stall and collision with the terrain. The pilot's failure to ensure a proper…NTSB ATL97LA097Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Cross City, FLThe pilot's inadequate preflight planning that resulted in loss of power in flight due to fuel exhaustion.NTSB SEA97LA151Accident · No injuriesLimited investigationFinal reportCessna 182P · Yakima, WAThe loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.NTSB CHI97LA172Accident · No injuriesLimited investigationFinal reportCessna 150K · Ypsilanti, MIthe pilot's failure to use carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Factors relating to this accident were: the icing (weather) condition and sign(s) in the emergency landing area.NTSB FTW97LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-300T · Del Norte, COThe pilot's failure to attain proper runway alignment. Factors were his attention being diverted by a rough running engine because the fuel injectors were partially blocked.NTSB IAD97LA086Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-A · Annapolis, MDthe pilot's failure to use carburetor heat, which resulted in accumulation of carburetor ice and subsequent loss of engine power. Related factors were: carburetor icing conditions, and trees in the emergency landing area.NTSB ATL97LA083Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Orangeburg, SCThe pilot experienced a partial loss of engine power for undetermined reason. The pilot failed to maintain flying airspeed which resulted in a stall and then subsequent collision with the ground. A factor was, conditions were favorable for the formation of…NTSB ATL97LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sophia, NCimproper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…NTSB MIA97LA166Accident · Serious injuriesLimited investigationFinal reportTravis C. Elmore B2B/582 · Haines City, FLThe pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…NTSB LAX97IA180Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · San Luis Obispo, CACompressor stalls of both engines due to in-service compressor contamination. Factors in the compressor stall of the right engine were an atmospheric temperature inversion and a transient fuel flow condition produced when the constant thrust on takeoff (CTOT)…NTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…NTSB CHI97LA115Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Duluth, MNthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control.NTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…NTSB MIA97LA130Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Lake Wales, FLThe partial loss of engine power for undetermined reasons.NTSB MIA97GA119Accident · Serious injuriesFinal reportAerospatiale AS 350B · West Palm Beach, FLFailure of the pilot-in-command to recognize that the main rotor rpm was decreasing and his failure to maintain the main rotor rpm during the autorotative landing resulting in a hard landing. Contributing to the accident was the partial loss of engine power…NTSB CHI97FA083Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-87 · Detroit, MIthe captains failure to have the airplane deiced prior to takeoff which resulted in ice ingestion into both engines. Factors associated with the accident were the icing weather conditions, wing ice, an inadequate detection of the ice during the preflight, and…NTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.NTSB ATL97LA047Accident · Minor injuriesLimited investigationFinal reportConvair 240-27 · Hampton, GAa partial loss of power on one engine for undetermined reason(s), and the pilot's failure to follow aircraft emergency procedures. A factor was inadequate transition/upgrade training.NTSB ANC97FA031Accident · 2 fatalField investigationFinal reportBuesing SX-300 · Sitka, AKthe pilot's failure to properly evaluate the presence of icing conditions, and his failure to comply with procedures to use alternate engine air in icing conditions. Factors relating to the accident were: icing (weather) conditions, the pilot's improper…NTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.NTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.NTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.NTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.