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 NYC92FA055Accident · 1 fatalField investigationFinal reportAero Commander 500S · Richmond Hts., OHThe pilot's improper emergency procedures and failure to maintain control of the airplane, which resulted in an inadvertent spin at too low an altitude to allow recovery. Factors in this accident were; a power loss in the left engine as result of the exhaust…NTSB FTW92LA065Accident · No injuriesLimited investigationFinal reportCessna 150L · Searcy, ARThe pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.NTSB BFO92LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · West Hempstead, NYLoss of engine power for an unknown reason. The lack of suitable terrain for an emergency landing was a related factor.NTSB LAX92LA100Accident · Serious injuriesLimited investigationFinal reportJames Houston KR2 · Chandler, AZThe pilot's improper emergency procedures, misjudging the airplane's altitude, failure to attain the proper touchdown point and excessive airspeed. Contributing to this accident was an undetermined loss of power and the pilot's lack of familiarity with the…NTSB BFO92LA024Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbus, OHFuel starvation in both engines, due to the pilot's improper positioning of the engine or fuel controls.NTSB FTW92LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXFouled spark plugs, loose spark plug ignition lead, exhaust leak, and cylinder leak. Factors were an inadequate annual inspection, poor maintenance, and operation by the pilot with known mechanical deficiencies.NTSB CHI92LA073Accident · No injuriesLimited investigationFinal reportCessna 177RG · Indianapolis, INEngine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB MIA92LA061Accident · 1 fatalLimited investigationFinal reportCessna 172G · Atlantic Ocean (Atlantic Ocean)Loss of engine power due to undetermined reasons.NTSB BFO92LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB LAX92LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lodi, CAThe pilot's improper use of the carburetor heat control and delay in flaring the helicopter for an autorotative touchdown. Carburetor icing conditions and the soft terrain were contributing factors in the accident.NTSB FTW92LA050Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Tyler, TXThe pilot's failure to feather the propeller and maintain directional control. Factors were the lose of power on one engine for undetermined reasons and the soft terrain.NTSB CHI92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Alpha, ILInadequate preflight planning and refueling not performed by the pilot.NTSB ATL92FA031Accident · 5 fatalField investigationFinal reportBeech 58TC · Bluffton, SCThe pilot's failure to maintain minimum controllable airspeed after a reported engine power loss, resulting in a loss of aircraft control. A factor was the loss of power on the left engine. The reason for the left engine power loss could not be determined.NTSB LAX92LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA34-200T · San Andreas, CAThe failure of the nonmultiengine/instrument rated pilot in command to accomplish the proper emergency procedure during a loss of engine power. Contributing to the accident was the pilot's improper training, lack of instrument experience, heavy fog reported…NTSB MIA92LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Daytona Beach, FLTotal loss of engine power for undetermined reasons.NTSB LAX92FA064Accident · 1 fatalField investigationFinal reportGlasair SH-2R · Nuevo, CAThe failure of the pilot to perform preventative maintenance on the airplane's powerplant which resulted in a loss of performance during an unknown phase of operation. Contributing to the accident was fouled spark plugs and the partial loss of aircraft…NTSB ATL92LA027Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Statesville, NCLoss of engine power for undetermined reasons. A factor was the lack of a suitable landing site.NTSB CHI92FA027Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Coffeyville, KSThe pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).NTSB LAX92LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · San Diego, CAThe total loss of engine power due to unknown reason(s). A factor in this accident was the lack of suitable terrain to land the airplane, without incurring damage to the airplane.NTSB FTW92LA016Accident · Serious injuriesLimited investigationFinal reportBalkema/Boven Kestrel Hawk · West Memphis, ARThe pilot allowed the aircraft to enter an inadvertent stall during flare at excessive altitude while executing the forced landing. Factors were the pilot in command and unauthorized person performed carburetor maintenance adjustments prior to flight, and the…NTSB CHI92FA020Accident · Serious injuriesField investigationFinal reportCessna 172P · Zion, ILWater contamination of the fuel, and the pilot's inadequate preflight of the aircraft. Factors related to the accident were: darkness and obstructions (trees & transmission lines) in the emergency landing area.NTSB NYC92LA017Accident · No injuriesLimited investigationFinal reportBeech A23 · Fairfield, NJThe loss of engine power for undetermined reason's which resulted in a forced landing on unsuitable terrain.NTSB CHI92LA014Accident · No injuriesLimited investigationFinal reportCessna C-210G · Freeport, ILImproper installation of a line fitting by other maintenance personnel.NTSB CHI92LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maple Lake, MNThe loss of engine power for an undetermined reason.NTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.NTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.NTSB MIA92LA009Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Panama City, FLLoss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.NTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.NTSB MIA92LA007Accident · Minor injuriesLimited investigationFinal reportO'Dell, Herbert L. Evans VP-1 · Summerfield, FLTotal loss of engine power due to fuel exhaustion and inadequate preflight by the pilot-in-command.NTSB LAX92LA010Accident · No injuriesLimited investigationFinal reportHill RL Breezy · Buckeye, AZA loss of engine power for undetermined reasons.NTSB FTW92LA003Accident · No injuriesLimited investigationFinal reportBeech C-45H · Edinburg, TXPower loss due to a loss of oil pressure for undetermined reasons. A factor was the lack of suitable terrain for forced landing.NTSB FTW92LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Henryetta, OKLoss of engine power for an unknown reason.NTSB ATL92LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sanford, NCThe loss of engine power due to unknown reasons.NTSB ANC91LA156Accident · No injuriesLimited investigationFinal reportAeronca Sedan 15AC · Anchorage, AKFailure of the pilot to ensure that the fuel caps were secure, which restuled in a fuel leak and subsequent fuel exhaustion.NTSB MIA91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Atlantic Ocean (Atlantic Ocean)Total loss of engine power due to undetermined reasons.NTSB SEA91LA243Accident · No injuriesLimited investigationFinal reportDonald W. Sorrels Vans RV-6 · Kennewick, WAThe loss of power due to the pilot/builder's improper adjustment of the engine idle speed. A factor relating to the accident was the soft terrain at the accident site.NTSB LAX91FA393Accident · 3 fatalField investigationFinal reportCessna T210L · Lakewood, CAAn undetermined loss of engine power and the pilot's failure to maintain airspeed during the forced landing.NTSB CHI91LA287Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Lake Elmo, MNA loss of engine power for undetermined reasons. A factor contributing to the accident was the unsuitable terrain on which the pilot had to land.NTSB NYC91LA238Accident · No injuriesLimited investigationFinal reportCessna 182RG · Robbinsville, NJA detached heli coil from the number 6 cylinder, resulting in a loss of engine power and subsequent forced landing in a corn field.NTSB LAX91LA388Accident · 1 fatalLimited investigationFinal reportTexas Helicopter M74 · Farmington, CALoss of engine power for an undetermined reason. Factors related to the accident were: the excessive gross weight of the helicopter, and the pilot's improper use of flight controls due to impairment from use of a drug (marijuanna).NTSB LAX91LA390Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Chula Vista, CAThe pilot's failure to maintain the proper airspeed and misjudging the landing flare altitude. The powerplant failure for an undetermined reason and the unsuitable terrain for the float equipped helicopter were factors in the accident.NTSB NYC91FA230Accident · 1 fatalField investigationFinal reportBoeing PT-17 · Tranquility, NJLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall. The lack of altitude for a recovery from the stall was a related factor.NTSB MIA91LA214Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · De Funiak Spgs, FLThe loss of engine power for undetermined reasons which resulted in an inflight collision with a tree and the ground during the subsequent forced landing.NTSB MIA91FA210Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe failure of the pilot to adequately drain the fuel system of water. A contributing factor was the pilot's decision to continue the takeoff with a known deficiency. The pilot's selection of a forced landing area was poor in that a better landing area was…NTSB DEN91LA121Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Parker, COPartial failure of the aircraft powerplant for undetermined reasons. A related factor was: the soft terrain.NTSB NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.NTSB FTW91LA159Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Benton, ARA loss of engine power for unknown reasons.NTSB CHI91LA275Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Jenison, MIFailure of the pilot to perform remedial action during fuel system carburetor icing.NTSB ANC91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen Creek, AKThe partial loss of power for undetermined reasons and the rough terrain.