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 CHI95LA309Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Walworth, WIloss of engine power which occurred for an undetermined reason. A factor was the soft terrain in the emergency landing site.NTSB FTW95LA375Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bonham, TXThe partial loss of engine power for undetermined reasons. Factors were the high density altitude and lack of suitable terrain for the forced landing.NTSB ATL95LA161Accident · Serious injuriesLimited investigationFinal reportRonsrans R 12 · Clanton, ALThe pilot's failure to maintain proper flying speed, and the improper mixture of the fuel.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB LAX95LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Overgaard, AZthe pilot's improper use of the mixture controls, failure to maintain a proper glidepath, failure to maintain an adequate approach airspeed, and failure to maintain directional control of the aircraft.NTSB ANC95LA132Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's abrupt (improper) use of the throttle.NTSB CHI95LA246Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Springfield, MOthe partial loss of engine power due to fouled spark plugs as a result of an improper fuel/air mixture. A factor in the accident was the powerlines.NTSB CHI95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Poplar Bluff, MOthe pilot's inadequate preflight/planning preparation. Factors in the accident were: the loss of engine power due to carburetor icing, the wet runway, and the ditch.NTSB ATL95LA141Accident · Minor injuriesLimited investigationFinal reportWheeler Fisher Classic · Marietta, GAimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power; and the pilot's failure to maintain adequate airspeed, while turning to make a forced landing, which resulted in a stall and impact with the terrain.NTSB ANC95LA111Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's improper use of carburetor heat which led to carburetor icing and a partial loss of engine power. Factors contributing to the accident are prevailing carburetor icing conditions, and the pilot's failure to properly judge the airplane's distance…NTSB CHI95LA223Accident · No injuriesLimited investigationFinal reportCessna 182C · Derby, KSthe pilot's improper use of the powerplant controls, which resulted in a rough running engine and partial loss of engine power.NTSB ATL95LA131Accident · Serious injuriesLimited investigationFinal reportPZL Koliber -150A · Pickens, SCthe inadequate design and operation of the induction airbox. A factor in the accident was the carburetor icing weather conditions.NTSB MIA95LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe failure of the pilot-in-command [CFI] to use carburetor heat during reduced power descent.NTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.NTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.NTSB MIA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sarasota, FLThe pilot's improper draining of the fuel sumps during preflight inspection of the airplane. This resulted in a partial loss of engine power on the left engine on initial take off climb due to water contamination, subsequent forced landing, collapse of the…NTSB CHI95LA193Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Rapid City, SDthe pilot's failure to feather the propeller on the left engine during the descent. A factor was the carburetor icing weather condition.NTSB MIA95FA141Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Opa-Locka, FLA loss of engine power due to water contamination of the fuel, the pilot's inadequate preflight, and his intentional operation of the airplane with known deficiencies in equipment which resulted in an inadvertent stall at an altitude inadequate for recovery.…NTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.NTSB SEA95FA079Accident · 1 fatalField investigationFinal reportCessna 182P · Index, WAthe pilot's continued flight into known adverse weather, and his improper use of carburetor heat. Factors include: weather conditions conducive to carburetor icing and airframe icing, airframe ice, and mountainous/hilly terrain in the area of the forced…NTSB ATL95LA081Accident · Serious injuriesLimited investigationFinal reportEccker, Donald E. Rans S-10 · Wilson, NCThe pilot's failure to maintain control of the airplane during the touchdown phase of the emergency landing to the runway. The lack of a carburetor heat system and the carburetor icing weather conditions were factors.NTSB NYC95LA077Accident · No injuriesLimited investigationFinal reportCessna 150J · Slatington, PAThe pilot's improper use of carburetor heat which resulted in carburetor icing and a subsequent loss of engine power. A factor is carburetor icing conditions.NTSB ANC95LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Skwentna, AKA frozen engine breather tube which resulted in a loss of oil and engine power.NTSB LAX95FA119Accident · Serious injuriesField investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's improper climb attitude which resulted in a momentary loss of engine power due to fuel starvation.NTSB CHI95LA085Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Benton Harbor, MIthe pilot's improper use of carburetor heat. Factors were carburetor icing conditions, snow, and blowing snow.NTSB CHI95LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Nevis, MNthe loss of engine power due to a blockage caused by ice. A factor in the accident was the snow.NTSB LAX95FA088Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe pilot's improper preflight inspection during which he failed to insure removal of the induction air system inlet covers. This action resulted in a partial loss of engine power during initial climb. A factor which contributed to the accident was the…NTSB ANC95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKA failure of the pilot to perform an adequate pre-flight inspection of the airplane. Factors in the accident were a frozen gascolator, and restricted fuel supply.NTSB FTW95LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Monahans, TXThe pilot's failure to use the carburetor heat and failure to maintain airspeed. A factor was the icing conditions.NTSB CHI95LA051Accident · 2 fatalLimited investigationFinal reportP. D. Chambers Swift PC-1V8 · Lincoln, NEThe pilot's failure to maintain control of the airplane, resulting in a stall-spin. Factors were an inadequate preflight and the loss of engine power resulting from water contamination in the automotive fuel.NTSB ANC95LA005Accident · No injuriesLimited investigationFinal reportAeronca Sedan AR-15 · Nikolai, AKThe pilot's continued flight into adverse weather. Factors to the accident were falling snow, an obstruction of the fuel system vents, restriction of the fuel flow and lack of a suitable landing area.NTSB CHI95LA014Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Aberdeen, SDthe pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…NTSB FTW95FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Eunice, LAThe pilot's failure to properly use carburetor heat, the formation of carburetor ice, and failure of the pilot to maintain rotor RPM after loss of engine power, which resulted in a loss of control and collision with terrain. A factor related to the accident…NTSB FTW95LA007Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Houston, TXThe pilot's selection of unsuitable terrain.NTSB ATL94LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Lancaster, SCThe pilot's delay in taking remedial action when the engine failed to develop takeoff RPM. A factor was conditions favorable for the formation of carburetor ice.NTSB SEA94LA223Accident · Serious injuriesLimited investigationFinal reportCessna 320B · Hood River, ORThe pilot's failure to insure that the fuel selector was in the proper position which resulted in fuel starvation.NTSB FTW94LA285Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Amarillo, TXThe pilot's failure to attain proper alignment of the airplane with the runway during the landing flare/touchdown. A factor was the partial loss of engine power due to undetermined reasons.NTSB CHI94LA297Accident · No injuriesLimited investigationFinal reportBellanca 7EAC · Alexandria, MNThe second pilot's failure to remove carburetor heat during the takeoff phase resulting in a loss of power and inadvertent stall.NTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.NTSB NYC94LA158Accident · No injuriesLimited investigationFinal reportStulp Starduster SA 300 · Ottawa, OHinadequate maintenance which resulted in a corroded gascolator fuel screen restriction fuel flow and resulted in fuel starvation.NTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.NTSB MIA94LA185Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe pilot-in-command's improper use of carburetor heat. The carburetor icing conditions were a factor.NTSB LAX94LA300Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Elko, NVa loss of engine power from fuel exhaustion due to the pilot's improper preflight and fuel consumption calculations while operating with known equipment malfunctions.NTSB ANC94LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe failure of the throttle control lever arm as a result of the improper 100 hour inspection by company maintenance personnel.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB FTW94LA221Accident · No injuriesLimited investigationFinal reportBell OH-13E · Mountain View, ARThe fuel exhaustion as result of a struck fuel drain valve. Factors were the high density altitude, and the unsuitable terrain at the pilot's disposal for the forced landing.NTSB NYC94LA108Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bristol, NHthe failure of maintenance personnel to remove an object from the carburetor heat duct during annual inspection which blocked induction air and resulted in the loss of engine power, and the subsequent collision with the terrain during a forced landing.NTSB MIA94FA167Accident · 2 fatalField investigationFinal reportPiper PA-31-325 · Lantana, FLThe pilot's impairment of judgment and performance due to drugs, his failure to abort the takeoff after experiencing reduced takeoff performance, and his failure to maintain minimum control speed. Factors in the accident were: a partial loss of engine power…NTSB CHI94LA196Accident · Serious injuriesLimited investigationFinal reportPopehn Arthur J. Coot A · Circle Pines, MNthe pilot-in-command's inattention to the fuel supply. Factors were the pilot-in-command's diverted attention, his not performing refueling, and rough/uneven terrain.NTSB ANC94LA065Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Wassila-Cheri, AKCarburetor ice collecting in the carburetor throat and the pilot's failure to use carburetor heat during the extended water taxi.