NTSB investigations
1,408 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
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\" = 352) 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" = 352) 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 CHI96LA006Accident · No injuriesLimited investigationFinal reportCessna 172F · Danbury, WIthe partial failure of the left magneto, the road sign, and the road embankment. A factor relating to this accident is the brush which obscured the road sign.NTSB NYC95LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Warminster, PAthe pilot's improper positioning of the fuel selector which resulted in a total loss of engine power due to fuel starvation. A contributing factor was pilot distraction.NTSB ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.NTSB MIA95IA243Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · New Smyrna Bch, FLfatigue failure of the piston assembly (piston and piston pin).NTSB LAX95FA322Accident · 2 fatalField investigationFinal reportFloyd Lancair 200 SE · Georgetown, CAa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff in a timely manner. The tailwind was a factor.NTSB CHI95LA293Accident · Serious injuriesLimited investigationFinal reportPatin Challenger II · Cedar Springs, MIinadequate engine maintenance by the owner/pilot-mechanic. Factors associated with the accident were fouled spark plugs and the pilot not being able to maintain proper altitude/clearance between his airplane and the electrical power lines during his landing…NTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.NTSB MIA95LA206Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Caribbean SeaLoss of engine power for undetermined reasons. Contributing to the accident was the inability of the pilot to feather the propeller.NTSB CHI95LA283Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Ironwood, MIthe pilot's failure to maintain control of the airplane during the aborted takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB LAX95LA290Accident · Serious injuriesLimited investigationFinal reportPiper PA-30-B · Wickenberg, AZthe pilot's improper emergency procedures. The pilot's diverted attention, and the magnetos clearance and timing were factors in this accident.NTSB MIA95FA200Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pulaski, TNFailure of the pilot to perform the before-takeoff checklist, and his failure to abort the takeoff due to inadequate acceleration. Contributing to the accident was an inadequate annual inspection by maintenance personnel for failure to safety the carburetor…NTSB LAX95LA287Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Chino, CAa forced landing into unsuitable terrain due to an engine failure for undetermined reasons.NTSB CHI95LA284Accident · No injuriesLimited investigationFinal reportVan Zwoll Viking · Decker, INthe failure of the head gasket resulting in a coolant leak and subsequent engine overtemperature. A factor was the unsuitable terrain encountered in the cornfield.NTSB BFO95LA079Accident · 1 fatalLimited investigationFinal reportHughlett Challenger II · Madisonville, KYan intermittent short of the ignition system, due to improper maintenance/modification of the engine, which resulted in partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision…NTSB NYC95LA184Accident · No injuriesLimited investigationFinal reportMooney M20C · Montgomery, PAThe partial loss of engine power, as a result of an excessively rich fuel flow in the carburetor, and a subsequent forced landing. A factor relating to the accident was the malfunction of the landing gear.NTSB MIA95LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring Hill, FLThe pilot's premature decision to perform a precautionary landing. Contributing to the accident was partial loss of engine power due to failure of one of the two magnetos.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB CHI95LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Aurora, NEthe cracked engine assembly that caused the power loss during a critical phase of flight. Factors associated with this accident were the restricted airplane performance due to the power loss, the airplane's altitude was too low, and remedial action, by, the…NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.NTSB MIA95LA189Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Callahan, FLLoss of engine power due to failure of the magnetos. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB FTW95LA313Accident · No injuriesLimited investigationFinal reportSteinke Early Bird · Akron, COFailure of the pilot to properly flare the airplane for landing during an emergency landing after takeoff. Factors relating to the accidents were: a malfunction of the side rave valve, an excessively rich fuel mixture, and the high density altitude, which…NTSB FTW95LA312Accident · No injuriesLimited investigationFinal reportPiper J3C · Englewood, COA partial power loss due to a stuck number four exhaust valve. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Wyandotte, INthe number three intake valve became stuck (seized), which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB ANC95LA107Accident · No injuriesLimited investigationFinal reportHughes 500D · Paxson, AKFuel starvation due to acrylamide contamination in the fuel control inlet filter. The lack of suitable terrain for a forced landing was a related factor.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95FA226Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Festus, MOan improper annual inspection, the fouled spark plugs, the arcing magneto distributor, and the pilot's attempt to take off with known deficiencies.NTSB ATL95LA134Accident · Minor injuriesLimited investigationFinal reportStafford Aerosport Scamp · Abbeville, SCThe improper engine overhaul which resulted in metal contamination of the engine assembly.NTSB MIA95LA181Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Lambert, MSUnsuitable terrain encountered during the forced landing. Contributing to the accident was the partial loss of engine power due to failure of the no. 4 cylinder intake valve rocker arm bosses.NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95FA277Accident · 4 fatalField investigationFinal reportBellanca 17-31A · Hot Springs, ARThe partial loss of engine power as a result of the disengagement of the throttle cable housing due to improper maintenance. Factors were the night condition and the lack of suitable terrain.NTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.NTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95FA270Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Lake Dallas, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall/spin. A factor was inadequate maintenance resulting in the partial loss of engine power due to the number one cylinder exhaust valve being stuck open.NTSB MIA95LA151Accident · No injuriesLimited investigationFinal reportBeech C24R · Houston, MSPartial loss of engine power due to a fuel injector being clogged with carbon. This resulted in a landing on unsuitable terrain.NTSB CHI95LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brooklyn, MIthe pilot operating the airplane with a known deficiency. A factor was the pilot not maintaining control of the airplane.NTSB SEA95LA118Accident · No injuriesLimited investigationFinal reportEnstrom 280C · The Dalles, ORA partial loss of engine power due to one set of ignition points becoming loose during flight. Factors included the low altitude flight and maneuvering required to conduct the operation and the resulting lack of suitable terrain for a forced landing.NTSB CHI95LA160Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Clarks, NEa partial failure of the engine supercharger.NTSB MIA95LA138Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Arcadia, FLLoss of engine power due to separation of 3 connecting rods from the master rod for undetermined reasons(s).NTSB FTW95LA211Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lissie, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB NYC95LA112Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Clarkson, NYFailure of the engine fuel pump, which resulted in fuel starvation and loss of engine power over an unsuitable landing area. Factors relating to the accident were: the airplane manufacture did not list the use of the installed electric boost pumps, nor did…NTSB ATL95LA095Accident · No injuriesLimited investigationFinal reportKolb Firestar II · Cumming, GAThe pilot/owner's failure to inspect the aircraft, which resulted in a loose spark plug lead. A factor was the rough terrain conditions at the landing area.NTSB CHI95FA148Accident · 1 fatalField investigationFinal reportCessna 177B · Nappanee, INairplane control was not maintained by the pilot during the his turn to an emergency landing area. Factors associated with this accident were the pilot not complying with the manufacturer's mandatory service bulletin, and an excessive fuel flow caused by the…NTSB ANC95LA052Accident · No injuriesLimited investigationFinal reportCessna 205 · Anchorage, AKA failure of the engine driven fuel pump. Factors in the accident were the pilots' inadequate in-flight planning and unsuitable terrain in the area of the forced landing.NTSB CHI95LA145Accident · Minor injuriesLimited investigationFinal reportFranklin EAA BI-PLANE/P1 · Rockville, INthe pilot's improper maintenance installation and his inadvertent takeoff. A factor was the pilot's inadequate pre-flight planning.NTSB CHI95IA142Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILfailure of the safety wire and/or safety wire lug arm on one of the stage one to two disk flange bolts due to an inadequate safetying method.NTSB ATL95FA090Accident · 2 fatalField investigationFinal reportAxell, Charles Glasair RG-2 · Elberta, ALThe pilot's failure to maintain flying speed which resulted in a stall. A factor was the loss of engine power due to a blocked fuel injector nozzle.NTSB MIA95FA115Accident · 5 fatalField investigationFinal reportPiper PA-28-180 · Quincy, FLAn undetermined fuel system problem that resulted in a fuel leak, an engine compartment fire, and a partial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a forced landing. An exhaust leak from the fracture of an…NTSB FTW95LA161Accident · Minor injuriesLimited investigationFinal reportGardner Varieze · Addison, TXThe jammed throttle. Factors were the knob becoming loose and separating from the throttle lever, and the lack of suitable terrain available for the forced landing.NTSB LAX95LA149Accident · No injuriesLimited investigationFinal reportBulsky Skybolt · Goodyear, AZfuel starvation due to the partial failure of the fuel pump caused by the broken crankshaft idler gear attachment screw lockplate. The unsuitable terrain and trees were factors in this accident.