NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
Cases, newest first
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 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 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 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.NTSB IAD97LA119Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-F · Carrollton, OHThe pilot's inadequate preflight which resulted in fuel exhaustion.NTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…NTSB CHI97LA275Accident · Minor injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · Blakesburg, IALoss of engine power for undetermined reasons.NTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.NTSB CHI97FA272Accident · 1 fatalField investigationFinal reportKellums Sonerai 1 · Scottsburg, INa loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.NTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.NTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.NTSB FTW97LA327Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Terrell, TXthe student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).NTSB ATL97LA123Accident · 1 fatalLimited investigationFinal reportJurka P51D Mustang · Fort Pierce, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.NTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.NTSB ATL97LA122Accident · Minor injuriesLimited investigationFinal reportZenair 701 · Spruce Creek, FLThe failure of the engine for undetermined reasons, while maneuvering close to the ground. Factors included the soft terrain and the conditions favorable for carburetor icing.NTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.NTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.