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 ATL92FA111Accident · 1 fatalField investigationFinal reportCessna 152 · Lake Waccamaw, NCThe failure of the pilot to follow proper procedures while operating the aircraft in weather conditions favorable to carburetor icing. A factor in the accident was the weather condition, which was favorable for the formation of carburetor ice.NTSB MIA92LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLTotal loss of engine power due to improper placement of the fuel selector by the pilot-in-command following partial loss of engine power due to partial blockage of a fuel line. Contributing to the accident was the dark night condition and improper maintenance…NTSB CHI92FA145Accident · 3 fatalField investigationFinal reportPiper PA-18 · Arnold, NEThe pilot's failure to maintain airspeed. Factors in the accident were improper adjustment of the carburetor float level by an unknown person, and the pilot's disregarding weight-and-balance.NTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB LAX92LA200Accident · No injuriesLimited investigationFinal reportPiper PA23-150 · Modesto, CAAn engine power loss due to fuel contamination.NTSB ATL92LA092Accident · No injuriesLimited investigationFinal reportCessna 172E · Concord, NCThe loss of engine power because of the formation of carburetor ice.NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.NTSB FTW92LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Acton, TXThe excessive airspeed during the landing. Factors were the carburetor icing conditions, the carburetor ice induced power loss, and the pilot's delayed use of carburetor heat.NTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.NTSB CHI92LA129Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Iron Mountain, MIThe presence of water in the air induction system.NTSB CHI92LA128Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Lee'S Summit, MOA delayed aborted takeoff by the pilot in command. A factor in the accident is the presence of carburetor icing conditions.NTSB SEA92LA072Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Missoula, MTPartial blockage of the left engine induction air filter, inability to maintain the proper rate of descent, and delayed extension of the landing gear. Factors contributing to the accident were icing conditions, wing ice, and rough/uneven terrain.NTSB DEN92LA041Accident · Minor injuriesLimited investigationFinal reportEnstrom F28 · Lakewood, COThe premature use of collective by the pilot during an autorotation. Factors were: the disconnection and subsequent collapse of the induction air line.NTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.NTSB SEA92LA052Accident · No injuriesLimited investigationFinal reportCessna 150L · Mulino, ORCarburetor ice and improper use of the carburetor heat. Factors to the accident were: carburetor icing conditions and an inadequate weather evaluation.NTSB FTW92LA075Accident · No injuriesLimited investigationFinal reportBell 206B III · Grand IsleHeavy sea state due to the high winds. A factor was the power loss.NTSB LAX92LA125Accident · No injuriesLimited investigationFinal reportCessna 182N · San Ardo, CAThe pilot's inadequate preflight inspection. Contributing to this accident was water contamination in the fuel and the soft soil landing area.NTSB NYC92LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-20 · Isle Au Haut, MEFuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.NTSB LAX92LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Sacramento, CAThe failure of the CFI to properly use carburetor heat in conditions conducive to the formation of carburetor ice. Factors in this accident were: 1) weather conditions conducive to carburetor icing and 2) the lack of suitable terrain to complete the forced…NTSB NYC92LA056Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Caldonia, NYThe pilot's improper use of carburetor heat which resulted in a loss of engine power. A factor relating to the accident was weather conducive to carburetor icing.NTSB MIA92LA097Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Church Hill, MSThe pilot's failure to clear his engine during descent resulting in the spark plugs becoming fouled which resulted in loss of engine power.NTSB MIA92LA069Accident · No injuriesLimited investigationFinal reportBell 47D1 · Cross City, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.NTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.NTSB LAX92FA094Accident · 2 fatalField investigationFinal reportMooney M-20-C · Santa Monica, CAFuel contamination by water due to the; 1) failure of the fuel caps to properly seal against water ingestion, 2) the pilots failure to adequately perform a preflight inspection of the aircraft sufficient to detect the presence of water in the fuel tanks.…NTSB BFO92FA022Accident · 1 fatalField investigationFinal reportHughes 369D · Edison, NJThe blockage of the fuel nozzle which resulted in partial loss of engine power. Contributing was the pilot's failure to maintain rotor RPM.NTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.NTSB ANC92LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe failure of the pilot to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident were the partial loss of engine power for undetermined reasons, the icy runway condition, and the pilot's lack of total…NTSB FTW92LA053Accident · No injuriesLimited investigationFinal reportBeech B19 · Bonham, TXInadvertent stall during the forced landing approach. A factor was the partial loss of power for undetermined reasons.NTSB BFO92FA013Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · North Salem, NYA loss of control due to a distraction caused by a partial loss of power. Contributing to the accident was adverse weather near the destination airport.NTSB ATL92FA032Accident · Serious injuriesField investigationFinal reportPiper PA 28-140 · Blythe, GAThe pilot's failure to apply carburetor heat during the before takeoff check as part of the ground check. A factor was weather conditions favorable for the formation of carburetor ice.NTSB NYC92FA049Accident · 1 fatalField investigationFinal reportCessna 182P · Hanging Rock, OHThe pilot's improper use of carburetor heat, which resulted in the formation of carburetor ice and a loss of engine power and subsequent forced landing in trees.NTSB NYC92LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Goshen, NYThe loss of engine power resulting from the ingestion of a foreign object into the carburetor and the subsequent forced landing in trees. A factor related to the accident was the maintenance performed on the airplane by unauthorized personnel.NTSB ANC92LA019Accident · 1 fatalLimited investigationFinal reportCessna 185 · Ketchikan, AKAn inadvertent stall while maneuvering for a precautionary landing. Factors include a partial loss of engine power for undetermined reasons, and inadequate altitude for the maneuver.NTSB LAX92LA062Accident · No injuriesLimited investigationFinal reportCessna 210M · Palo Alto, CAAn engine power loss due to a partial blockage of the fuel selector valve with debris.NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.NTSB LAX92LA061Accident · No injuriesLimited investigationFinal reportNorth American-Kenney T-28D-5, NA-260 · Bermuda Dunes, CAAn inadequate annual inspection performed by the mechanic. Contributing to this accident was the deterioration of the fuel bladder self-sealing lining and partial blockage of the fuel screens.NTSB NYC92LA037Accident · Minor injuriesLimited investigationFinal reportConvair CV-240 · Akron, OHThe use of an improper grade of fuel, which was approved by the captain and resulted in a loss of engine power duirng climbout and an in flight collision with terrain.NTSB MIA92LA038Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hilliard, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the low ceiling encountered and reduced in-flight planning decision time by the pilot-in-command.NTSB MIA92LA029Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Florida City, FLPartial loss of engine power due to a loose intake manifold. Also, improper maintenance by an unknown person.NTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.NTSB NYC92LA019Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Manchester, VTThe pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.NTSB LAX92LA016Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Reno, NVA partial loss of engine power for undetermined non-mechanical reasons.NTSB SEA92LA005Accident · No injuriesLimited investigationFinal reportHughes 269B · Hillsboro, ORThe failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.NTSB LAX92LA005Accident · No injuriesLimited investigationFinal reportRobinson R22B · Honolulu, HIThe improper use of the flight controls by the instructor pilot ND the failure to maintain proper rotor RPM.NTSB LAX92LA002Accident · No injuriesLimited investigationFinal reportCano Avid Flyer · Sonora, CAFuel starvation due to vapor lock.NTSB DEN91FA135Accident · 1 fatalField investigationFinal reportCessna P210N · Pagosa Springs, COFailure of the pilot to maintain clearance from trees during an approach for a precautionary landing. His improper use of the mixture control was a related factor concerning the partial loss of engine power.NTSB DEN91LA133Accident · Minor injuriesLimited investigationFinal reportJoseph A. Mullan Dragon FLY · Fort Collins, COUndetermined. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB SEA91LA238Accident · No injuriesLimited investigationFinal reportChampion 7EC · Coeur D'Alene, IDA blocked fuel system vent, and an inadequate aircraft preflight by the pilot. Rough terrain in the emergency landing area was a related factor.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.