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 ATL01LA097Accident · 1 fatalLimited investigationFinal reportTroy A. Woodland Sky Raider II · NewSmyrna Beach, FLThe pilot's failure to maintain airspeed while performing an emergency maneuver, resulting in a stall and an uncontrolled descent, and the subsequent collision with terrain. A factors was, the loss of engine power for undetermined reasons.NTSB LAX01FA290Accident · No injuriesField investigationFinal reportPiper PA-32-301T · Fullerton, CAThe engine lost power for unknown reasons.NTSB CHI01LA293Accident · No injuriesLimited investigationFinal reportHughes 269B · Pontiac, MIthe checklist not compiled with by the operator and not verified by the operator’s pilot and the operator's flight instructor. An additional cause was the improper autorotation by the pilot in command. The out of calibration engine idle speed was a…NTSB SEA01LA157Accident · No injuriesLimited investigationFinal reportSuper Quickie 2 · Bonney Lake, WAImproper carburetor adjustment resulting in a total loss of engine power while in a descent configuration. Factors include an excessively lean mixture setting and unsuitable terrain for landing.NTSB FTW01LA199Accident · No injuriesLimited investigationFinal reportJohn Greenlee X-Aircamper · Healdton, OKThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat during the approach to land. Contributing factors were weather conditions conducive to carburetor icing conditions and the lack of suitable terrain for…NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB CHI01FA290Accident · 1 fatalField investigationFinal reportNavion L-17B · Newaygo, MIThe pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident…NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB ANC01LA120Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Kenai, AKThe total loss of engine power during takeoff for an undetermined reason.NTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.NTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.NTSB CHI01LA285Accident · Serious injuriesLimited investigationFinal reportWaters Avid Bandit · Northville, MIfuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.NTSB CHI01LA283Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sikeston, MOThe loss of engine power during the initial climb due to fuel contamination, water. A factor relating to the accident was the trees.NTSB DEN01LA144Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kemmerer, WYfuel exhaustion due to the pilot's failure to refuel the aircraft, which resulted in a loss of engine power. A contributing factor was the unsuitable steep terrain on which to make a forced landing.NTSB CHI01LA275Accident · Serious injuriesLimited investigationFinal reportSchuetz Miniplane DSA-1 · Michigan City, INAircraft control not being maintained by the pilot. Contributing factors to the accident were the pilot maneuvering at a low airspeed, the encountered stall/spin, and the recovery from the spin at a low altitude, which resulted in altitude/clearance not being…NTSB FTW01LA182Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe loss of engine power while maneuvering for undetermined reasons.NTSB FTW01LA189Accident · No injuriesLimited investigationFinal reportDonald A Chiasson FP-404 · Port Allen, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Milwaukee, WIthe rich fuel mixture and the unsuitable landing area encountered by the pilot. Contributing factors were the high output of the fuel pump and the low altitude.NTSB FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA205Accident · Serious injuriesLimited investigationFinal reportRans S-7 · Sydnorsville, VAA loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.NTSB LAX01LA273Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Fullerton, CAloss of engine power due to fuel contamination.NTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB DEN01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 320 · Falcon, COthe pilot's failure to abort the takeoff following a loss of right engine power. A factor was the loss of right engine power for undetermined reasons.NTSB CHI01LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Racine, WIThe total loss of engine power during cruise flight due to the number 3 cylinder thru-studs fatigue fractures, and the thru-stud's low hardness as a result improper heat treatment of the thru-studs, and the unsuitable terrain encountered during the forced…NTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.NTSB CHI01LA265Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WIThe unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.NTSB CHI01LA259Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Blooming Prairi, MNThe reported loss of engine power for undetermined reasons during a the cruise portion of a CFR part 137 observation, and the pilot not following the height/velocity charts data.NTSB SEA01LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Latah, WAthe failure of a cylinder head exhaust rocker shaft boss while the aircraft was performing aerial application. Factors include soft terrain and a drop-off in the field where the emergency landing took place.NTSB CHI01LA260Accident · No injuriesLimited investigationFinal reportHauck Moffra P-13 · Linden, INthe loss of engine power due to carburetor ice. Contributing to the accident was the rough/uneven terrain condition encountered during the landing.NTSB CHI01LA263Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Callaway, NEFuel exhaustion due to the pilot's inadequate preflight. Contributing to the accident was the muddy field and the unsuitable terrain encountered during the forced landing.NTSB MIA01LA204Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Edison, GAPartial loss of engine power for undetermined reasons during takeoff resulting in the airplane descending, colliding with the ground, and nosing over.NTSB FTW01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Tulsa, OKthe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA192Accident · Serious injuriesLimited investigationFinal reportMontgomery Teenie Two · Cambridge, OHthe pilot's improper maintenance which resulted in the engine retarding to idle, and subsequent forced landing. A factor was the tall grass in the field where the forced landing was performed.NTSB DEN01LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMthe pilot's failure to maintain clearance from the powerline while descending for an emergency landing. A contributing factor was the loss of engine power for an undetermined reason.NTSB DEN01LA128Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bountiful, UTthe loss of engine power for an undetermined reason. A contributing factor was inadequate clearance of an obstacle during the forced landing by the pilot.NTSB CHI01LA242Accident · No injuriesLimited investigationFinal reportAg-Cat G-164B · Wallace, NEThe inadequate preflight planning by the pilot, the pilot initiating the flight with an inadequate fuel supply, and the unsuitable terrain encountered during the forced landing. Factors were the fuel exhaustion, the low altitude and the soft field.NTSB NYC01LA188Accident · No injuriesLimited investigationFinal reportCessna 172P · Odenton, MDA loss of engine power for undetermined reasons.NTSB NYC01LA187Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Sandy Hook, NJA total loss of engine power for undetermined reasons.NTSB SEA01TA143Accident · No injuriesFinal reportBoeing Helicopters Div. H500D · Union Gap, WAThe complete loss of engine power at cruise for undetermined reasons. Factors include a landing area that was restricted/confined due to adjacent trees, and an intentional abrupt flare resulting in a hard landing.NTSB CHI01LA237Accident · 1 fatalLimited investigationFinal reportVeith Kolb Sling Shot · Goodview, MNThe loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…NTSB CHI01LA223Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, ILThe helicopter's loss of engine power for undetermined reasons while maneuvering close to the ground, and the low altitude and low airspeed. A factor relating to this accident was the pilot not being able to get into autorotation.NTSB ATL01LA088Accident · Serious injuriesLimited investigationFinal reportW. E. Simmons Max Air Drifter ARV 582 · Collington, NCThe internal seizing of the engine assembly that resulted in a total loss of engine power during climb out.NTSB MIA01FA192Accident · 1 fatalField investigationFinal reportBeech BE-35-F35 · Bamberg, SCthe failure of the pilot to maintain airspeed, while attempting a forced landing following a loss of engine power for undetermined reasons, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain. A factor in this accident was…NTSB CHI01LA225Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Freemont, MIThe broken throttle cable during cruise flight and the pilot's inadequate flare during the forced landing attempt. Factors relating to this accident were the low airspeed during the forced landing attempt and the short, corn stubble field.NTSB LAX01LA247Accident · No injuriesLimited investigationFinal reportBeech J35 · Las Vegas, NVThe pilot's failure to comply with the airplane flight manual, resulting in fuel starvation and subsequent forced landing on rough terrain.NTSB CHI01LA219Accident · No injuriesLimited investigationFinal reportCessna 172C · Grand Island, NEThe procedures for using carburetor heat not followed by the student pilot and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing conditions, the carburetor icing, the student pilot's lack of…NTSB ATL01LA085Accident · No injuriesLimited investigationFinal reportCessna 172M · Atlantic Ocean (Atlantic Ocean)The loss of engine power for undetermined reasons.NTSB ANC01TA087Accident · No injuriesFinal reportde Havilland DHC-2 · Willow, AKThe loss of engine power during cruise due to the separation of an engine cylinder.NTSB NYC01LA177Accident · Serious injuriesLimited investigationFinal reportRaum Rans S-12 · Waldorf, MDFuel contamination. A factor related to the accident was the builder’s decision to not install fuel tank drains.NTSB CHI01LA215Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Walker, MNthe loss of engine power for undetermined reasons during takeoff. Factors were the vehicles, the unsuitable terrain the pilot encountered, and the low altitude of the helicopter at the time of the loss of engine power.