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 FTW01LA057Accident · Minor injuriesLimited investigationFinal reportBeech BE-58 · Brinkley, ARthe pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB ATL01LA028Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Concord, NCThe pilots failure to follow the auxiliary fuel tank procedures, which resulted in the fuel starvation and the loss of engine power.NTSB MIA01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tifton, GAThe pilot's failure to properly judge his altitude (too high) during a forced landing to a runway. The pilot made a 270-degree turn in an attempt to lose altitude resulting in a forced landing in a swampy/marshy area short of the runway. Contributing to the…NTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.NTSB ATL01FA027Accident · 4 fatalField investigationFinal reportBeech F90-42 · Nashville, TNThe pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.NTSB ATL01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-A-150 · Sun City, FLThe loss of engine power for undetermined reasons, a factor was weather conditions favorable for carburetor icingNTSB MIA01LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Milton, FLa loss of right engine power due to chaffed and frayed wiring on the right and left magnetos on the right engine resulting in a forced landing, an inadvertent stall, and subsequent impact with the ground.NTSB FTW01LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Fort Worth, TXthe loss of power to both engines for undetermined reasons during approach. Contributing factors were the pilot's failure to properly position the fuel selector in accordance with the landing checklist and the lack of suitable terrain for the forced landing.NTSB SEA01LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Cottage Grove, ORThe flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…NTSB CHI01TA063Accident · Serious injuriesFinal reportPiper PA-23 · Griffith, INThe unsuitable terrain for landing encountered by the pilot. Factors included the loss of power for undetermined reasons and the rough terrain.NTSB FTW01FA048Accident · 1 fatalField investigationFinal reportBell 206B · Mineral Wells, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA01LA059Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCThe loss of engine power during a normal descent due to fuel starvation for undetermined reasons.NTSB SEA01LA035Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Eastsound, WAThe pilot's failure to use carburetor heat prior to reducing engine power to idle while operating in serious carburetor icing conditions. Factors include serious carburetor icing conditions, and trees in the area where the pilot found it necessary to attempt…NTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.NTSB SEA01LA031Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 Mk. I · Kirkland, WAA malfunction of the aircraft's fuel selector valve and subsequent fuel starvation. Factors included a short emergency landing area, a wet landing surface, and a fence.NTSB LAX01LA062Accident · No injuriesLimited investigationFinal reportCessna 177RG · San Carlos, CAA loss of engine power for undetermined reasons during an extended downwind leg in the landing pattern.NTSB MIA01LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Pierce, FLThe pilot's improper approach for landing while making a landing following a reported momentary partial loss of engine power for undetermined reasons and his decision to make a go-around from the approach resulting in a landing in a field and collapse of the…NTSB CHI01LA049Accident · No injuriesLimited investigationFinal reportCessna 210C · Indianapolis, INThe reason for the loss of engine power is undetermined. A factor was the rough terrain.NTSB ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.NTSB SEA01LA025Accident · No injuriesLimited investigationFinal reportCessna A185F · Lynwood, WAFuel exhaustion due to refueling was not performed by the pilot-in-command. Trees and a fence were factors.NTSB ATL01LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNA loss of engine power during takeoff due to carburetor ice. A factor was unsuitable terrain.NTSB ATL01LA011Accident · No injuriesLimited investigationFinal reportMooney M20E · Fort Myers, FLFuel system contamination that resulted in fuel starvation.NTSB SEA01LA024Accident · No injuriesLimited investigationFinal reportBell 206 B3 · Lake Kachess, WAThe pilot's failure to comply with the flight manual regarding the use of an induction system deflector kit (snow baffles) while operating in snow, and the ingestion of foreign material/snow that resulted in an engine flameout while hovering. A snow baffle…NTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.NTSB CHI01LA038Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, WIThe cause of the loss of engine power is undetermined. Factors in the accident included the fence and the localizer antennas.NTSB LAX01LA043Accident · No injuriesLimited investigationFinal reportCessna 210K · Oxnard, CAFailure of the internal cam gear in the remanufactured engine. A factor was the congested obstacles in the forced landing area.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB FTW01LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Laporte, TXThe loss of engine power for undetermined reasons. Factors were the bright night light condition, and the lack of suitable terrain for the forced landing.NTSB LAX01LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Carson City, NVFuel starvation precipitated by the pilot's continued use of the fuel selector valve that was not seating in the detents properly.NTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.NTSB DEN01LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Greeley, COCarburetor ice formation due to the pilot's improper use of the carburetor heat control. Factors were the fence and fence post.NTSB FTW01FA014Accident · 1 fatalField investigationFinal reportCessna 150L · Rockport, TXthe loss of engine power for undetermined reasons, and the pilot's subsequent failure to maintain control of the airplane during the ensuing forced landing.NTSB LAX01LA022Accident · Serious injuriesLimited investigationFinal reportBeech 35B33 · Bullhead City, AZThe pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.NTSB CHI01LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Minier, ILthe carburetor ice and after takeoff, the unsuitable terrain the pilot encountered during the forced landing. Factors were the carburetor icing conditions and the plowed field condition.NTSB NYC01LA022Accident · Serious injuriesLimited investigationFinal reportHoward Weedhopper · Fordsville, KYAn engine failure for undetermined reasons and the pilot's low altitude flight.NTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…NTSB CHI01LA018Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · New Ulm, MNThe engine failure for undetermined reasons, the pilot not attaining proper runway alignment, and the misjudged flare by the pilot. A factor was the runway light.NTSB NYC01LA015Accident · Serious injuriesLimited investigationFinal reportMoore Starduster SA-300 · Erwinna, PAA total loss of engine power during initial climb for undetermined reasons.NTSB MIA01FA004Accident · 2 fatalField investigationFinal reportRobinson R-22 · Pembroke Pines, FLThe pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…NTSB LAX01LA012Accident · Minor injuriesLimited investigationFinal reportTolle Venture Model 20 · Madera, CAThe mechanical failure of a fuel sump tank check valve, during takeoff initial climb, that resulted in fuel starvation.NTSB MIA01LA002Accident · No injuriesLimited investigationFinal reportHarwell/Gardner WAG-AERO Cubby · Stockbridge, GAThe pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.NTSB CHI01LA003Accident · No injuriesLimited investigationFinal reportCessna 182 · Noblesville, INCarburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.NTSB SEA01LA004Accident · No injuriesLimited investigationFinal reportMooney M20K · Monroe, WAOil Pump drive gear shaft separated in shear. A collision with a tree stump during the landing roll was a factor.NTSB ATL01LA003Accident · 1 fatalLimited investigationFinal reportUniversity of Alabama MINI-500 · Tuscaloosa, ALThe loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.NTSB SEA00LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miles City, MTA loss of engine power for undetermined reasons.NTSB MIA00LA272Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Gulfport, MSa loss of power on both engines, during a simulated engine out approach, resulting in a forced landing and the subsequent on ground impact with a pole.NTSB SEA00LA185Accident · Serious injuriesLimited investigationFinal reportRowe Pietenpol · Raymond, WAThe pilot's failure to maintain an airspeed above power-off stall speed (Vso) while attempting a forced landing after a total loss of engine power, and his failure to move the fuel selector switch to the 'ON' position prior to takeoff. Factors include the…NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB LAX00FA342Accident · Minor injuriesField investigationFinal reportSikorsky/Orlando S-55 · Hoover Dam, AZ**This report was modified on 2/23/2016. Please refer to the public docket for this accident for more information.** The failure of Papillon maintenance personnel to recognize the significance of the increasing metal in the oil analysis test results and the…NTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.