NTSB investigations
1,176 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
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\" = 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 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 BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.NTSB NYC91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Urbana, OHThe pilot's failure to follow procedures and directives which resulted in the failure of the pilot to recognize the stoppage of the rear engine prior to take off. Additionally the lack of total engine power resulted in the inability of the pilot to maintain…NTSB CHI91LA274Accident · No injuriesLimited investigationFinal reportCessna 150 · Camden, MIPartial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.NTSB NYC91FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Marlboro, NJThe pilot's improper aircraft handling which resulted in an inadvertent stall and loss of control at an altitude insufficient for recovery. Factors related to the accident were an engine failure due to fuel exhaustion and improper preflight preparation.NTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.NTSB ANC91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Angoon, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was pilot's intentional abrupt maneuvering at a low altitude and the flaps that retracted a knotch.NTSB BFO91FA072Accident · 1 fatalField investigationFinal reportCessna 210N · Petersburg, VAThe pilot's inadequate pre-takeoff check and his failure to abort the takeoff. Inadequate maintenance of the engine was a factor.NTSB NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.NTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.NTSB ATL91LA143Accident · No injuriesLimited investigationFinal reportHinton Kitfox · Killen, ALWeather conditions conducive to carburetor icing. A factor was the lack of a carburetor heat system on the engine.NTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.NTSB LAX91LA311Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ramona, CAThe pilot-in-command's improper preflight planning preparation and fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion, forced landing and in flight collision with a residence.NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB MIA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valparaiso, FLPartial loss of engine power due to fuel contamination due to an inadequate preflight by the pilot in command and failure of the pilot to extend the landing gear during the forced landing.NTSB SEA91LA154Accident · 1 fatalLimited investigationFinal reportJerrell RV-4 · Yellowstonepark, WYA collapsed induction air duct. Factors include inadequate design by the manufacturer/builder, and a misjudged rate of descent by the pilot.NTSB SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.NTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.NTSB FTW91DRA04Accident · No injuriesFinal reportCessna 188B · Wallis, TXThe partial power loss during a critical phase of flight. A factor was the lack of suitable terrain onto which a successful forced landing could have been executed.NTSB LAX91LA263Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain Hills, AZThe failure of the student pilot and instructor pilot to correctly configure the aircraft for the attempted go around. Contributing to the accident was the improper supervision of the flight by the flight instructor.NTSB LAX91FA252Accident · 3 fatalField investigationFinal reportCessna 182 · Bermuda Dunes, CAThe pilot-in-command's failure to maintain airspeed while maneuvering to return to the departure airport, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors related to the accident were: partial loss of engine…NTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.NTSB ANC91LA066Accident · No injuriesLimited investigationFinal reportCessna 207A · Eek, AKWas fuel contamination. Contributing factors are the engine vibrations and the rough vegetation upon which the airplane landed.NTSB DEN91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Fayetteville, ARThe pilot failed to apply carburetor heat.NTSB LAX91LA236Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Fort Ord, CAPartial loss of engine power for undetermined reasons.NTSB CHI91DEE05Accident · Minor injuriesFinal reportCharles Raucci, JR. Firebolt · Schaumburg, ILThe pilot not following the specification for installation of the fuel tank vent.NTSB MIA91LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Quincy, FLThe pilot's inadequate preflight inspection and the blocked vent line.NTSB CHI91LA168Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, MNPartial loss of engine power due to improper use of carburetor heat and a stall encountered by the pilot.NTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…NTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.NTSB LAX91LA216Accident · No injuriesLimited investigationFinal reportCessna C-150L · Groveland, CAThe pilots neglect to calculate the aircrafts fuel consumption and his failure to service the aircraft with fuel prior to the last takeoff. The wire across the aircrafts flight path during the forced landing was a factor in the accident.NTSB CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.NTSB ATL91LA078Accident · 1 fatalLimited investigationFinal reportLewis Challenger II · Thomaston, GAThe pilot's failure to properly maintain the airplane in accordance with prescribed procedures which resulted in fuel contamination, fouled spark plugs, and a loss of engine power. The pilot also failed to follow normal emergency procedures for the loss of…NTSB ANC91LA047Accident · No injuriesLimited investigationFinal reportCessna 180F · Yukon River, AKA carburetor fuel leak due to inadequate annual inspection. Contributing to the accident was the snow covered terrain.NTSB FTW91LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Spring, TXPower loss due to carburetor ice, the pilot's failure to use carburetor heat, and his failure to apply adequate cushioning collective pitch during the flare segment of the autorotation. A factor in the accident was the pilot's improper autorotation technique.NTSB DEN91LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Watkins, COLoss of engine power for an undetermined reason, and failure of the pilot to maintain airspeed during the forced landing, which resulted in a stall/mush.NTSB MIA91LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Quincy, FLThe pilot's inadequate preflight.NTSB MIA91LA108Accident · Minor injuriesLimited investigationFinal reportGlassair SH-2TD · Bay St. Louis, MSThe loss of power due to vapor lock of the fuel system on takeoff. Contributing to the cause of the accident was the improper decision of the pilot-in-command to attempt to take off with known deficiencies in the airplane.NTSB NYC91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phillipsburg, PACarburetor ice and the pilot's improper use of carburetor heat. Factors related to the accident were: the carburetor icing (weather) conditions and the lack of suitable terrain for a forced landing.NTSB MIA91LA099Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Panama City, FLCarburetor icing due to improper use of carburetor heat by the pilot, resulting in a forced landing and ditching.NTSB LAX91LA128Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Farmington, CAThe contamination of the engine induction air filter. Soft terrain during the touchdown was a factor in the accident.NTSB MIA91IA091Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Jacksonville, FLInadequate engine performance in the designed airplane flight envelopes.NTSB LAX91LA112Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Los Angeles, CAThe poor preflight planning performed by the pilot-in-command in accurately determining the weight and fuel consumption of the airplane which resulted in loss of engine power due to fuel exhaustion.NTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.NTSB NYC91LA071Accident · No injuriesLimited investigationFinal reportRobinson R-22 Alpha · Coram, NYThe pilot-in-command's failure to maintain rotor RPM and misjudging the height of the flare during a precautionary autorotative landing, resulting in a roll over during the landing flare touchdown.NTSB SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.NTSB LAX91LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 369D · Keanae, HIFuel starvation caused by a loose fuel line 'b' nut, due to improper maintenance; and the failure of the pilot to correctly judge the landing flare during the autorotation.NTSB NYC91LA050Accident · No injuriesLimited investigationFinal reportCessna 210 · Warwick, NYA power failure for undetermined reasons, resulting in a forced landing in unsuitable terrain.NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB CHI91DEX01Accident · Minor injuriesFinal reportCessna 210G · Indianapolis, INInadequate maintenance and inspection of the airplane resulting in an engine power loss due to water and fuel contamination. A contributing factor was the dark night.NTSB NYC91LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · West Nyack, NYThe improper use of carburetor heat control, which resulted in a loss of engine power and subsequent emergency forced landing and collision with a fence. A factor to the accident was weather conditions suitable to formation of carburetor icing.