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 CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…NTSB CHI93LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sparta, MIthe separation of the rear landing light gasket into the air induction path.NTSB BFO93LA117Accident · Serious injuriesLimited investigationFinal reportHolmes Special · Chavies, KYFuel starvation due to the pilot's improper decision to take off with a low fuel level. Factors related to the accident were the low fuel level, the pilot's lack of familiarity with the characteristics of the fuel system, and the uneven terrain in the…NTSB LAX93LA280Accident · No injuriesLimited investigationFinal reportCessna 172N · Truckee, CAThe partial loss of engine power during the takeoff initial climb for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for a forced landing.NTSB ATL93LA117Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Cleveland, GAThe pilot's improper use of carburetor heat, resulting in a partial loss of engine power during the initial climb. Factors were the carburetor icing conditions, and the trees located at the departure end of the airstrip.NTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.NTSB ATL93LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Statesville, NCThe improper use of carburetor heat by the pilot. A factor in the accident was the carburetor icing conditions.NTSB ANC93LA094Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Dry Creek, AKThe loss of engine power for undetermined reasons.NTSB ATL93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Ridgeland, SCThe pilot's improper use of carburetor heat, which resulted in a partial loss of engine power. Factors were the carburetor icing conditions, and the soft terrain at the forced landing site.NTSB ATL93LA102Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Greensboro, NCThe pilot's improper use of carburetor heat during the flight. Factors were the carburetor icing conditions at the time of the accident, and trees at the forced landing siteNTSB ATL93LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Cummings, GAThe loss of engine power resulting from the formation of carburetor ice during the ground operation. A factor was the pilot's failure to obtain a weather briefing.NTSB MIA93LA125Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Sarasota, FLThe pilot-in-command's improper application of the flight controls during an autorotative landing, resulting in an in-flight collision with wires and terrain. Contributing to the accident was the improper inspection of the engine fuel system (carburetor) by…NTSB CHI93LA174Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Springport, MIA partial loss of engine power for undetermined reasons.NTSB FTW93LA149Accident · Minor injuriesLimited investigationFinal reportHaltom Avid Flyer · Houston, TXEngine power loss with cause undetermined. A factor was the lack of suitable terrainNTSB DEN93LA051Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Truman, ARA power loss for undetermined reasons. A factor was: the lack of suitable terrain for the forced landing.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.NTSB MIA93LA088Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S1-T · Naples, FLThe installation of an improper designed intake tube and air filter by the nonmechanic rated pilot-in-command, which resulted in moisture build up and collapse of the air filter, which resulted in blockage of air flow to the engine and loss of engine power.…NTSB FTW93LA106Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Mena, ARThe pilot's improper in-flight planning/decision. Factors related to the accident were: the adverse weather conditions, the pilot's improper use of carburetor heat, his improper IFR procedures, darkness, and the high (mountainous) terrain.NTSB SEA93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Riverton, WYThe pilot did not perform an abort of the takeoff after observing a partial loss of power. Factors include improper use of the mixture control.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.NTSB MIA93LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Pascagoula, MSLoss of engine power due to undetected foreign matter contamination of the engine fuel control. The lack of a suitable landing area was a facotr in the accident.NTSB LAX93FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Eloy, AZPartial loss of engine power due to fuel system contamination and a partially obstructed carburetor venturi, and the pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight inspection.NTSB LAX93FA097Accident · 2 fatalField investigationFinal reportBeech A35 · Tulare, CAThe installation of an unapproved wing tip fuel tank system; an inadequate annual inspection which did not note, or correct, the unapproved fuel system addition; a wing tank fuel selector valve installation without adequate placards to show position or…NTSB FTW93LA069Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Godley, TXThe partial power loss due to the pilot's delayed application of carburetor heat. Factors were carburetor ice, and the sloping terrainNTSB BFO93LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Manorhaven, NYThe partial power loss due to induction system icing and the pilots failure to apply carburetor heat during weather conducive to induction system icing.NTSB CHI93LA049Accident · No injuriesLimited investigationFinal reportCessna 150F · Oshtemo, MIImproper use of carburetor heat by the pilot-in-command.NTSB LAX93LA050Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Hilo, HIThe pilot's intentional flight in and near a volcanic gas cloud which induced a partial loss of engine power due to a lack of combustible oxygen in the atmosphere.NTSB CHI93LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aurora, MOThe pilot's lack of familiarity with the airplane, a switched off fuel selector and fuel starvation.NTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.NTSB LAX93LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Quartzsite, AZEngine failure for an undetermined reason. Contributing to this accident was the rough/uneven terrain.NTSB LAX92LA409Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Minden, NVPilot's and mechanic's inadequate inspection of the aircraft and the pilot's poor inflight decision by not returning to the departure airport after experiencing the initial engine loss of power on takeoff. Contributing to this accident was fuel starvation due…NTSB BFO92LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenville, WVThe pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees.NTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB CHI92LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Moran, MIThe pilot-in-command's improper selection of fuel tank resulting in fuel starvation. A factor was the pilot-in-command's encounter with unsuitable terrain.NTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.NTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.NTSB NYC92LA169Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Put-In-Bay, OHThe pilot's improper use of carburetor heat, resulting in a loss of engine power and subsequent forced landing in trees.NTSB ATL92FA162Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Lawrenceville, GAThe pilot's failure to maintain aircraft control which resulted in an inadvertent stall, and his improper execution of emergency procedures. Factors were the pilot's overconfidence, his inadequate preflight inspection when he failed to drain the gascolator,…NTSB FTW92LA196Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Granbury, TXThe pilot's inadvertent use of carburetor heat during takeoff. The lack of suitable terrain for a forced landing was a factor.NTSB FTW92DPA01Accident · Serious injuriesFinal reportAir Tractor AT-301 · Dekalb, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ANC92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot's inadvertent stalling of the airplane and an inadequate altitude in which he could recover. Factor relating to the accident was the water in the fuel.NTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.NTSB LAX92LA278Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Mesa, AZA partial loss of engine power due to unknown reason (s). Factors in this accident were 1) low altitude when the partial loss of power occurred 2) low rotor RPM as a result of the loss of power, and 3) the pilot not being able to take remedial action due to…NTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.NTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.NTSB NYC92LA109Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAThe student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…NTSB LAX92LA234Accident · Serious injuriesLimited investigationFinal reportJacanin Great Lakes · Gila Bend, AZFuel starvation due to the pilot's failure to properly position the fuel selector in the full 'on' setting. A factor in the accident was the design of the fuel selector valve and the location of the temporary radio installation which limited the pilot's view…NTSB NYC92LA096Accident · No injuriesLimited investigationFinal reportCessna 140A · Vincentown, NJThe loss of engine power for undetermined reasons resulting in a collision with wires during a forced landing.