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 LAX94FA165Accident · 2 fatalField investigationFinal reportAyres S-2R · Reno, NVAn undetermined problem with the engine oil system, a decision to fly the airplane with a known deficiency, and progressive (partial) failure of the engine master rod and bearing.NTSB SEA94LA082Accident · No injuriesLimited investigationFinal reportCessna 185 · Fort Lewis, WAThe fuel shutoff valve seized in a partially open position.NTSB MIA94LA090Accident · No injuriesLimited investigationFinal reportCessna TU206F · Crystal River, FLThe failure of the no 1 piston connecting rod for undetermined causes. The lack of suitable terrain for a forced landing was a factor.NTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.NTSB LAX94LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Borrego Springs, CA1) the pilot's decision to takeoff in an aircraft with a known, yet unresolved, engine performance deficiency, and 2) the pilot's failure to maintain an adequate airspeed while maneuvering back to the runway. A factor in the accident was the weld repair of…NTSB MIA94LA050Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350 · Lakeland, FLThe pilot-in-command's failure to follow the emergency procedure in the flight manual for governor malfunction. Contributing to the accident was inadequate written procedures in the flight manual by the aircraft manufacturer.NTSB ATL94LA025Accident · Minor injuriesLimited investigationFinal reportSikorsky H34-G · Walterboro, SCThe seizure of the aircraft throttle to engine linkage for unknown reasons.NTSB BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.NTSB BFO94LA001Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe 415E · Willis, VAthe failure of the airplane's throttle cable fitting due to undetermined reasons, which prevented the pilot from applying power above engine idle. A factor in this accident was the lack of suitable terrain for the pilot to complete a forced landing without…NTSB FTW93LA268Accident · No injuriesLimited investigationFinal reportCessna 182G · Baytown, TXThe fuel starvation power loss due to a sticking carburetor float. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93LA260Accident · No injuriesLimited investigationFinal reportCessna A188B · Manila, ARPartial loss of engine power due to the collapse of an air induction hose.NTSB CHI93LA359Accident · No injuriesLimited investigationFinal reportCessna 172F · Indianapolis, INThe failure of the left magneto, which resulted in a partial loss of engine power.NTSB ATL93LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Deatsville, ALWas a crack in no.3 cylinder head which resulted in the loss of engine power.NTSB MIA93FA190Accident · Serious injuriesField investigationFinal reportBeech 35 · Frisco, NCThe pilot's failure to maintain airspeed (vso) resulting in a stall/mush. Contributing to the accident was the near total loss of engine power due to separation of one of the two counterweights for undetermined reasons.NTSB LAX93LA345Accident · No injuriesLimited investigationFinal reportCessna 172G · Avalon, CAthe oil starvation related failure of the number 1 and 2 connecting rods due to improper torque of the crankcase through bolts at the number 2 cylinder, which allowed fretting of the bearing surfaces and the resulting closure of the oil ports. The under…NTSB BFO93LA162Accident · No injuriesLimited investigationFinal reportSterner Super CAT · Cherryville, PAThe movement of a thumbscrew on the fuel filter system which resulted in fuel flow blockage and subsequent partial power loss. A factor in this accident was the lack of suitable terrain for the emergency landing.NTSB FTW93FA251Accident · 3 fatalField investigationFinal reportCessna 182C · Porter, TXPartial loss of engine power for undetermined reasons. Factors in the accident which may have contributed were the distorted and separated muffler components resulting from improper maintenance by an unknown person.NTSB CHI93LA343Accident · No injuriesLimited investigationFinal reportCessna T210N · Lake In The Hil, ILChafing of a fuel system line.NTSB NYC93LA176Accident · Minor injuriesLimited investigationFinal reportChampion Citabria 7-GCBC · Fire Island, NYFailure of the #4 cylinder valve stem.NTSB SEA93LA181Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Auburn, WAFailure of the connecting rod bolt. The high vegetation was a factor.NTSB SEA93LA180Accident · No injuriesLimited investigationFinal reportBeech C23 · Lakeview, ORA fractured exhaust valve. The rough terrain was a factor.NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.NTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.NTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.NTSB FTW93LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Garwood, TXThe partial power loss for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Millard, NEImproper maintenance/inspection of the aircraft by (other) maintenance personnel, and subsequent blockage of the induction air system by an object (alternate air door) that was not removed during previous maintenance.NTSB FTW93FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Houston, TXCompany management's dispatch of an airplane with known deficiencies, their failure to correct the deficiencies, and the student pilot's inadvertent entry into a stall. Factors which contributed to the accident were: chafed wiring, fouled spark plugs, a…NTSB BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.NTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.NTSB FTW93LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Purcell, OKThe lack of suitable terrain onto which to execute the forced landing which was neccesitated by the partial power loss. The power loss was a result of the fatigue failure of the exhaust valve rocker arm attachment stud. A factor was the night conditions.NTSB CHI93DTG02Accident · No injuriesFinal reportAero Commander S2R · Hoople, NDA loss of engine power due to a cracked engine cylinder.NTSB CHI93LA256Accident · Minor injuriesLimited investigationFinal reportQuad City Challenger II Specia · Ottawa, ILThe pilot in command's failure to maintain proper clearance. Factors to the accident include an oil fouled spark plug and a power ground cable.NTSB LAX93LA286Accident · No injuriesLimited investigationFinal reportStephens VP2 · Lodi, CAthe grounding of the magneto coil to the magneto case due to a crack in the coil sheath.NTSB LAX93FA282Accident · Minor injuriesField investigationFinal reportPiper PA-34-200 · La Verne, CAThe flight instructor's failure to obtain/maintain best the single-engine rate-of-climb airspeed, and his failure to ensure that the landing gear was retracted. A factor related to the accident was contamination in the fuel system, which blocked fuel flow…NTSB FTW93LA201Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Spring, TXThe pilot's improperly planned approach and the resultant overshoot of the intended landing area. Factors were the partial power loss due to internal corrosion, and the inadvertent stall.NTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.NTSB FTW93LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Navasota, TXPartial power loss due to left magneto fluctuating due to loose coil. A factor was the lack of suitable terrain for the forced landingNTSB MIA93LA143Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Orlando, FLUnsuitable terrain encountered during the autorotative forced landing. Contributing to the accident was total loss of engine power due to seizure of the compressor impeller following failure of the no.2 bearing for undetermined reasons.NTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.NTSB ANC93IA093Incident · No injuriesIncident investigationFinal reportCessna 206 · Portage, AKThe failure of the number two cylinder connecting rod bearing due to the shifting of the bearing within its journal race which produced an oil starvation/thermal distress event.NTSB DEN93LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, COA partial power loss when the rocker box for one cylinder disengaged. A factor was: unsuitable terrain for a forced landing.NTSB FTW93LA178Accident · No injuriesLimited investigationFinal reportBell-Transworld 47G-2 · Wynne, ARPartial power loss due to the failure of one magneto. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Weiner, ARPartial power loss due to improper installation of the linkage control bracket. A factor was the lack of suitable terrain for the forced landing.NTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.NTSB FTW93LA152Accident · No injuriesLimited investigationFinal reportElliott B-80 · Amarillo, TXThe pilot's failure to compensate for wind conditions. Factors were the loss of engine power and the tailwindNTSB CHI93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Houghton Lake, MIThe pilot operating the airplane with a known deficiency.NTSB BFO93LA076Accident · Minor injuriesLimited investigationFinal reportHockenbury Bowers FLY Baby · Peapack, NJThe failure of the throttle valve actuating arm which resulted in partial opening of the throttle valve. A factor related to the accident was the unsuitable terrain available for landing.NTSB MIA93LA104Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Fort Pierce, FLFailure of the no. 2 cylinder in fatigue for undetermined reasons, over unsuitable terrain. The lack of suitale terrain for the forced landing was a factor.NTSB BFO93FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDThe pilot's improper in-flight planning/decision after selecting the wrong runway for a precautionary landing , which resulted in an inadvertent descent into transmission lines, while attempting to maneuver back to the runway. Factors related to the accident…NTSB SEA93LA092Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Spokane, WAFailure of the number 4 cylinder exhaust valve seat and the inadvertent stalling of the aircraft by the pilot in command. Factors contributing to the accident were buildings and power lines.