NTSB investigations, 1997
170 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 257 |
|---|---|
| 1983 | 204 |
| 1984 | 161 |
| 1985 | 156 |
| 1986 | 193 |
| 1987 | 186 |
| 1988 | 136 |
| 1989 | 126 |
| 1990 | 120 |
| 1991 | 169 |
| 1992 | 142 |
| 1993 | 153 |
| 1994 | 173 |
| 1995 | 158 |
| 1996 | 178 |
| 1997 | 170 |
| 1998 | 205 |
| 1999 | 198 |
| 2000 | 169 |
| 2001 | 228 |
| 2002 | 222 |
| 2003 | 187 |
| 2004 | 177 |
| 2005 | 205 |
| 2006 | 162 |
| 2007 | 183 |
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\") = 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\" = 350)
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" = 350) 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 CHI98LA067Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · Troy, MIloss of engine power for undetermined reason(s). Factors associated with the accident were: the lack of a suitable forced landing site, and the embankment (dirt bank), which the airplane contacted.NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.NTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.NTSB NYC98LA044Accident · Minor injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Oxford, CTThe loss of power for undetermined reasons.NTSB CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.NTSB SEA98LA024Accident · No injuriesLimited investigationFinal reportBell 206L · Idaho Falls, IDloss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.NTSB FTW98LA069Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mckinney, TXThe pilot's inadequate in-flight/planning decision which resulted in continued flight until fuel exhaustion. Related factors were incorrect fuel gauge readings and trees.NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.NTSB SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.NTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.NTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.NTSB SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.NTSB FTW98LA065Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Worland, WYloss of engine power for undetermined reason(s). A related factor was the rough and uneven terrain on which the forced landing was made.NTSB ATL98LA020Accident · No injuriesLimited investigationFinal reportCessna 172B · Henderson, NCThe loss of engine power for undetermined reasons.NTSB LAX98LA049Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Union City, CABlockage of the fuel flow transducer, which resulted in fuel starvation and the loss of engine power. Unsuitable terrain for an emergency landing was a contributing factor.NTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.NTSB FTW98LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Watkins, COloss of engine power for undertermined reason(s).NTSB ATL98LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Waycross, GAa loss of engine power for undetermined reasons.NTSB FTW98LA053Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tomball, TXThe total loss of engine power resulting from the loss of oil and resultant seizure of a cylinder due to inadequate maintenance by maintenance personnel. A factor was the lack of suitable terrain for the forced landing and the low ceiling.NTSB LAX98LA038Accident · 1 fatalLimited investigationFinal reportAdams Sonerai II · Kingman, AZThe complete loss of engine power for undetermined reasons. A factor in the accident was the rough nature of the landing site terrain.NTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.NTSB MIA98LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Naples, FLLoss of engine power for undetermined reasons.NTSB FTW98LA047Accident · No injuriesLimited investigationFinal reportReid Capella XS · Leander, TXThe loss of engine power due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.NTSB LAX98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Santa Rosa, CALoss of engine power for undetermined reasons.NTSB CHI98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Lakeville, MNfuel starvation due a deteriorated grommet in an Adel clamp, and a loose mixture control cable.NTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.NTSB FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB LAX98LA021Accident · Serious injuriesLimited investigationFinal reportRevolution MINI-500 · Long Beach, CAloss of engine power and low rotor rpm for undeterminted reasons. The factory representative's recommendation to reduce the main rotor low pitch stop (from -1.8 degree to -0.5 degree) may have been a related factor.NTSB SEA98LA006Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Winston, MTFuel starvation due to fuel flow restriction from a failed carburetor automatic mixture control device. Factors include night light conditions for the forced landing.NTSB ATL98FA002Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Kennesaw, GAthe pilot's improper emergency procedures and subsequent loss of aircraft control, while attempting to maneuver for a precautionary landing. A factor relating to the accident was: partial loss of power in one or both engines for undetermined reason(s).NTSB MIA98TA011Accident · Minor injuriesFinal reportCessna 172P · Wiggins, MSLoss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.NTSB IAD98FA005Accident · 4 fatalField investigationFinal reportBell 206B · Sago, WVThe improper overhaul of the turbine governor by the manufacturer, which resulted in the loss of power.NTSB MIA98LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Gulf Of Mexicoloss of engine power for undetermined reason(s), which resulted in a forced landing (ditching) at sea.NTSB CHI98LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Liberty, NEA loss of engine power for undetermined reasons.NTSB FTW98LA007Accident · Serious injuriesLimited investigationFinal reportBeech G18S · Crosbyton, TXInadequate maintenance which resulted in diminished carburetor heat effectiveness due to missing alternate air doors. Contributing were conducive carburetor icing weather conditions, low ceilings during the emergency descent, and the lack of suitable terrain…NTSB FTW98LA005Accident · No injuriesLimited investigationFinal reportCessna 175A · Bentonville, ARThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB MIA98LA004Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Trenton, GAfailure of the pilot to abort the takeoff, when he observed an indication of less than full engine power on the tachometer from the beginning of the takeoff roll. Factors relating to the accident were: the inadequate preflight planning and preparation by the…NTSB LAX98LA001Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Burbank, CAA loss of engine power for undetermined reasons.NTSB IAD98LA002Accident · No injuriesLimited investigationFinal reportHughes 269A · Campbellsville, KYThe pilot refueled the helicopter with jet fuel instead of avgas, which resulted in a loss of engine power. A related factor was the unsuitable terrain.NTSB CHI97LA301Accident · No injuriesLimited investigationFinal reportUniversal D-16 · Howell, MIthe emergency landing gear extension system being impeded by flap extension. Factors contributing to this accident are the instructor pilot's intentional feathering of the airplane's left propeller, the instructor pilot's lack of familiarity with the…NTSB MIA97TA246Accident · No injuriesFinal reportHughes 269A · Tarpon Springs, FLthe loss of engine power for undetermined reasons.NTSB LAX97LA326Accident · Minor injuriesLimited investigationFinal reportLampert M500 · San Carlos, CAloss of engine power for undetermined reasons, and the pilot's improper use of the flight controls following the loss of power. The pilot's lack of training/certification in rotorcraft operations was a factor in this accident.NTSB FTW97LA344Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Horseshoe Bend, ARFuel starvation due to partially blocked fuel vents. Factors were: the pilot's inadequate preflight inspection of the airplane; the pilot's improper decision to continue operation of the airplane with known deficiencies; and the lack of suitable terrain for…NTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.NTSB FTW97LA359Accident · No injuriesLimited investigationFinal reportShutt Marquart MA-5 · Pecos, TXThe pilot's inadequate compensation for the crosswind during a forced landing following a loss of engine power due to fuel exhaustion for an undetermined reason. Factors were the gusty winds and rough/uneven terrain.NTSB IAD97FA117Accident · 5 fatalField investigationFinal reportCessna 182E · Smithfield, RIA loss of engine power for undetermined reason, and the pilot's failure to maintain control of the airplane.NTSB CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.NTSB LAX97LA319Accident · No injuriesLimited investigationFinal reportMooney M20E · Gulf Of Ca (Pacific Ocean)The loss of engine power for undetermined reasons.