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 FTW91DPG13Accident · Serious injuriesFinal reportGrumman G-164B · Mc Crory, ARLoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB LAX91LA266Accident · Serious injuriesLimited investigationFinal reportGrumman HU-16E · Pacific Ocean (Pacific Ocean)Improper touchdown in the water causing substantial damage. Loss of power on the number 2 engine and the pilot's lack of qualifications were factors in the accident.NTSB CHI91LA196Accident · No injuriesLimited investigationFinal reportCessna 172RG · Hawley, MNInattentiveness of both the flight instructor and the student pilot, and failure to use carburetor heat. A factor related to the accident is the unsuitable terrain encountered during the forced landing.NTSB LAX91LA260Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Sonita, AZA loss of engine power due to a broken piston ring in the number 3 cylinder, which resulted in the aircraft's inability to maintain level flight.NTSB FTW91LA100Accident · No injuriesLimited investigationFinal reportCessna 150 · Berryville, ARThe loss of engine power for unknown reasons and the pilot's improper flare which resulted in a hard landing.NTSB SEA91LA130Accident · Minor injuriesLimited investigationFinal reportHughes 269A-1 · Canby, ORA hard landing after an undetermined loss of power. Factors include an excessive emergency descent rate.NTSB CHI91DCQ06Accident · No injuriesFinal reportPiper PA-36-300 · Oakley, KSA loss of engine power for an undetermined reason(s).NTSB LAX91LA253Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Hollister, CAThe pilot's intentional bailing out of his airplane. Contributing factors are related to the possible onset of a rough running engine.NTSB LAX91LA249Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAThat unknown pilot(s) impoperly used the throttle control which caused an overspeed condition. Contributing to this accident was the connecting rod bolt fatigue failure.NTSB BFO91FA053Accident · Serious injuriesField investigationFinal reportBeech B65 · California, MDThe loss of power in one engine for undetermined reasons.NTSB BFO91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Elkins, WVThe loss of engine power for undetermined reasons.NTSB LAX91LA228Accident · No injuriesLimited investigationFinal reportBeech C-45H · Lake Elsinore, CAFuel starvation due to an improper modification of the fuel system and the pilot's failure to ensure that the aircraft was airworthy prior to flight.NTSB CHI91LA170Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Albany, MNThe cfi's failure to take timely and proper remedial action when the student pilot lost directional control during the takeoff roll. Factors in the accident are the tall grass edging the runway, and the student pilot's lack of total experience.NTSB FTW91DRD05Accident · No injuriesFinal reportBell 47-D1 · Sun, LAThe total loss of power for undetermined reasons and the failure of the pilot to maintain rotor RPM. A factor was the lack of suitable terrain.NTSB BFO91LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Danville, VAAn inadequate preflight inspection which resulted in water contaminated fuel. Contributing was noncompliance with an airworthiness directive.NTSB NYC91LA139Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Caribou, METhe failure of the engine driven fuel pump, which resulted in a total loss of engine power and subsequent forced landing on rough terrain. Factors related to the accident were the decision by the pilot to takeoff with known mechanical deficiencies; the…NTSB SEA91LA112Accident · No injuriesLimited investigationFinal reportCessna 172P · Alva, WYThe pilot's overconfidence in his personal ability, overconfidence in the aircraft's ability. Contributing to the accident was the engine failure.NTSB LAX91LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAFuel starvation due to the flight instructor's improper use of the fuel selector valve and his failure to properly supervise the conduct of the flight.NTSB NYC91DGT03Accident · Serious injuriesFinal reportBell 47-G3B1 · Hughesville, PAThe loss of engine power for undetermined reasons and the pilot's selection of the forced landing area.NTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.NTSB FTW91FA078Accident · 2 fatalField investigationFinal reportBeech A36 · Caldwell, TXThe pilot-in-command's failure to properly position the fuel selector handle resulting in a fuel starvation power loss. A factor was the inadvertent stall.NTSB FTW91DRD04Accident · Serious injuriesFinal reportAir Tractor AT 301 · Lake Providence, LAA loss of engine power for undetermined reasons resulting in a forced landing and nose over on landing.NTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.NTSB FTW91DRA01Accident · No injuriesFinal reportRockwell S2R-600 · Beaumont, TXThe failure of the engine for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough terrain that was encountered.NTSB LAX91LA198Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Keanae, HIThe total failure in fatigue of the helicopter's spur adapter gearshaft. A contributing factor was related to the lack of a suitable emergency landing site.NTSB LAX91LA196Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · King City, CAThe total loss of engine power which resulted from the drain valve fitting on a newly installed gascolator dislodging during cruise flight.NTSB BFO91LA047Accident · No injuriesLimited investigationFinal reportAerospace Tech. of Australia N22B · Richardsville, KYThe loss of engine power brought on by a failure of the no.2 main engine bearing. Contributing to the accident was the lack of sufficient power on the remaining engine to maintain level flight.NTSB BFO91LA046Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Christiansburg, VAInadequate maintenance. Contributing was an obstructed air filter.NTSB NYC91IA133Incident · No injuriesIncident investigationFinal reportBoeing 747SP · Churchville, NYA failure of the sixth rotating airseal which led to an uncontained engine failure.NTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.NTSB MIA91LA128Accident · 1 fatalLimited investigationFinal reportDonald L. Hedeman SONERAI-II · Jacksonville, FLThe pilot's improper adjustment of the carburetor.NTSB MIA91LA127Accident · No injuriesLimited investigationFinal reportTravel Air 2000 · Homestead, FLAn on ground encounter with weather conditions that were favorable for carburetor icing at a low power setting (glide power), and failure of the pilot to abort the takeoff after recognizing that the eng was not developing full power during the initial climb.NTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.NTSB ATL91LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Bern, NCThe aircraft engine loss of power for an undetermined reason. Factors related to the accident were the dark night, and the inadvertent stall of the aircraft.NTSB CHI91DEE04Accident · No injuriesFinal reportBeech 35-A33 · Vernon Hills, ILWater contamination of the fuel, and the pilot's inadequate preflight inspection.NTSB MIA91LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Clewiston, FLDisintegration of the impeller for undetermined reasons resulting in the total loss of engine power necessitating the forced landing.NTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.NTSB NYC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182F · Carrabassett Vy, MEImproper use of the carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB NYC91FA103Accident · 1 fatalField investigationFinal reportBellanca 17-31 ATC · Gt. Barrington, MAThe mechanic's improper use of anti-seize compound on the injector nozzle threads which resulted in an engine failure.NTSB SEA91LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Wenatchee, WACarburetor ice as a result of the pilot's improper use of carburetor heat.NTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.NTSB BFO91FA040Accident · 2 fatalField investigationFinal reportCessna 195 · California, MDThe loss of power for undetermined reasons.NTSB MIA91LA116Accident · No injuriesLimited investigationFinal reportCessna 150H · Orlando, FLTotal loss of engine power due to fuel exhaustion and failure of the pilot to refuel the fuel tanks before departure.NTSB BFO91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Chesapeake, VAThe pilot's failue to maintain adequate airspeed after the loss of engine power for undetermined reasons.NTSB SEA91LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wamic, ORThe pilot's selection of an empty fuel tank for takeoff.NTSB NYC91LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, METhe engine lost power for an undetermined reason.NTSB BFO91LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Clinton, MDThe lost of engine power for undetermined reasons.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL91LA070Accident · No injuriesLimited investigationFinal reportCessna 150G · Villa Rica, GAA loss of engine power for undetermined reasons.NTSB BFO91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 152 · California, MDThe loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with terrain.