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 ATL97LA047Accident · Minor injuriesLimited investigationFinal reportConvair 240-27 · Hampton, GAa partial loss of power on one engine for undetermined reason(s), and the pilot's failure to follow aircraft emergency procedures. A factor was inadequate transition/upgrade training.NTSB ANC97FA031Accident · 2 fatalField investigationFinal reportBuesing SX-300 · Sitka, AKthe pilot's failure to properly evaluate the presence of icing conditions, and his failure to comply with procedures to use alternate engine air in icing conditions. Factors relating to the accident were: icing (weather) conditions, the pilot's improper…NTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.NTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.NTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.NTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.NTSB MIA97LA035Accident · No injuriesLimited investigationFinal reportHoster/Volmer VJ22 (Sportsman) · Seminole, FLinadequate maintenance/inspection of the airplane by the pilot/owner, and fuel contamination that resulted in fuel starvation.NTSB MIA97LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Homerville, GAcarburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.NTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.NTSB LAX97LA029Accident · No injuriesLimited investigationFinal reportCessna 310H · Show Low, AZwater/ice contamination in the fuel system and/or fuel filters due to failure of the maintenance facility that performed the annual inspection to identify and replace four cracked and deteriorated fuel filler cap O-rings. A factor in this accident was the…NTSB FTW97LA016Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Venice, LAa loss of engine power due to frogs being ingested into the engine as a result of the pilots failure to perform a thorough preflight, and the pilot's improper touchdown technique.NTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.NTSB ANC96LA145Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Kenai, AKthe pilot's improper fuel managment, which resulted in loss of engine power due to fuel exhaustion.NTSB CHI96LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Grant City, MOlow oil level which resulted in the partial loss of engine power, the pilot's intentional operation of the airplane with a known mechanical deficiency, and the hay bale. Factors relating to this accident were the owner/pilot mechanic's failure to comply with…NTSB SEA96LA198Accident · Serious injuriesLimited investigationFinal reportBell 206B · Glenns Ferry, IDfuel contamination, due to improper servicing of the helicopter, which resulted in an intermittent loss of engine power. A factor relating to the accident was: the pilot's inadequate control of the helicopter, during autorotation with intermittent engine…NTSB CHI96FA290Accident · 2 fatalField investigationFinal reportAeronca 11AC · Charlotte, MIthe pilot's improper use of engine controls (carburetor heat and/or throttle), while making a relatively high speed approach, low pass, and pull-up, which resulted in partial loss of engine power; and failure of the pilot to maintain sufficient airspeed after…NTSB MIA96LA201Accident · Serious injuriesLimited investigationFinal reportHernandez Challenger Special II · Toa Baja, PRwater contamination in the fuel system, which resulted in a partial loss of engine power shortly after takeoff. Factors relating to the accident were: the lack of a quick draining feature in the fuel system, the pilot's failure (or inability) to detect water…NTSB CHI96LA273Accident · Minor injuriesLimited investigationFinal reportBeech 77 · South Elgin, ILwater contamination in the carburetor.NTSB MIA96LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Victoria, MSThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.NTSB MIA96LA163Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Callahan, FLthe pilot's premature decision to reduce power, following application of carburetor heat, when engine operation became rougher after experiencing roughness due to carburetor icing. The weather (carburetor icing) conditions and carburetor ice were related…NTSB FTW96LA260Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Prescott, ARThe loss of engine power due to improper fuel. Factors were the pilot's inadequate preflight and lack of suitable terrain for the forced landing.NTSB IAD96LA096Accident · Minor injuriesLimited investigationFinal reportLittle Scamp · Worthington, KYwas the loss of engine power for undetermined reasons shortly after liftoff. A related factor was the unsuitable terrain encountered during the forced landing.NTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI96LA203Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Oslo, MNthe pilot not using carburetor heat when the engine began to lose power. Factors in this accident were carburetor ice formation and the soft landing surface the pilot had to use for landing.NTSB LAX96LA198Accident · No injuriesLimited investigationFinal reportBeech 58 · Los Angeles, CAan interruption of fuel flow to the right engine for undetermined nonmechanical reasons. A contributing factor was the pilot's failure to keep the right engine's propeller feathered which reduced the airplane single engine performance capabilities.NTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.NTSB LAX96FA177Accident · 1 fatalField investigationFinal reportHughes 269C · San Diego, CAthe decision of the pilot to fly at low altitude and low airspeed within a hazardous performance area published in the pilot operating handbook. Factors in the accident were tailwinds, lack of operator preventative maintenance impairing engine power,…NTSB LAX96LA168Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVthe partial loss of engine power and the pilot's misjudged flare during an autorotation landing in soft dirt with excessive forward speed. The power loss resulted from flight operations in an environment which debris contaminated the engine's nozzle port and…NTSB MIA96FA100Accident · 5 fatalField investigationFinal reportCessna U206G · Key West, FLThe pilot's improper decision to continue the flight rather than making an immediate water landing due to the low altitude of the airplane and obstructions ahead, which led to his intentional maneuver to avoid the obstructions and subsequent inadvertent stall…NTSB MIA96LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe failure of the pilot-in-command to apply caburetor heat before reducing the throttle to simulate an engine failure. Contributing to the accident was the carburetor icing conditions and the unsuitable terrain encountered during the emergency descent.NTSB SEA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Vancouver, WAthe pilot's failure to use carburetor heat, and his delay in aborting the takeoff after noting sluggish acceleration. Factors were: the carburetor icing conditions, the trees off the end of the runway, and the soft ground conditions in the forced landing area.NTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…NTSB ANC96LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanana, AKThe icing of the induction/intake screen and the pilot's improper planning/decision by electing to takeoff into suspended snow and ice crystals.NTSB LAX96LA084Accident · Minor injuriesLimited investigationFinal reportNicholson Sonerai II · Ramona, CAan interruption of fuel flow to the engine due to a misrouted fuel vent line.NTSB LAX96FA082Accident · No injuriesField investigationFinal reportCessna 152 · Long Beach, CAa partial power loss due to carburetor icing resulting from existing environmental conditions and the pilot's failure to apply carburetor heat during descent.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB CHI96LA055Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Mason, MIthe improper application of the throttle by the pilot resulting in a delayed engine response, and the improper decision by the pilot to make a long fast touchdown requiring the need to take off under powerlines.NTSB ANC96TA016Accident · No injuriesFinal reportCessna 182H · Koyuk, AKThe pilot's delayed application of carburetor heat. Factors in the accident were carburetor icing conditions and lack of suitable terrain for a forced landing.NTSB MIA96LA028Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Jasper, FLImproper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…NTSB BFO96LA021Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Manassas, VAfailure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…NTSB LAX96LA026Accident · No injuriesLimited investigationFinal reportCessna 172H · Borrego Springs, CAthe pilot's inadequate preflight inspection which failed to detect a bird's nest in the air induction system. Factors in the accident were carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB FTW96LA026Accident · No injuriesLimited investigationFinal reportBeech 23 · Strasburg, COThe pilot's delayed application of carburetor heat. A factor was the unsuitable terrain.NTSB CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.NTSB MIA96LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Covington, GAthe pilot's failure to divert to an alternate airport after recognizing a low fuel state existed and his delay to declare an emergency with ATC. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Spring Hill, FLThe pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…NTSB MIA95FA239Accident · 1 fatalField investigationFinal reportBeech 58 · Greer, SCoperation of the aircraft by the pilot with a known deficiency (failed mixture control linkage in the right engine), which resulted in loss of power in the right engine; and his failure to maintain control of the airplane during the initial climb after…NTSB CHI95LA336Accident · No injuriesLimited investigationFinal reportCessna T210M · Dodge City, KSthe pilot's improper use of the auxiliary fuel boost pump during descent which led to fuel flooding and loss of combustion.NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.