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 DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…NTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB MIA00LA207Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Boone, NCThe failure of the inter-cooler duct connecting the inter-cooler to the engine due to inadequate attachment of the inter-cooler to the aircraft which resulted in loss of turbocharger air overboard and loss of engine power and damage to the aircraft during a…NTSB FTW00LA190Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Whitney, TXThe partial loss of engine power, which resulted from the worn carburetor.NTSB LAX00LA260Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Ana, CAThe loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.NTSB FTW00LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXthe loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA160Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Kaufman, TXThe failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.NTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.NTSB NYC00LA129Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, PAA crack in the crankcase which resulted in a partial power loss.NTSB FTW00LA138Accident · Minor injuriesLimited investigationFinal reportNoteman RV6-A · Kanab, UTThe partial loss of engine power as result of the failure of an exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB NYC00FA122Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJStress rupture of the 2nd-stage low pressure turbine anti-rotation nozzle locks, resulting from inadequate nozzle lock design.NTSB ATL00LA046Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401-B · Lawrenceburg, TNThe loss of engine power due to a stuck exhaust valve that resulted in the collision with a tree while maneuvering for the forced landing.NTSB LAX00LA157Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Yreka, CAthe total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…NTSB FTW00TA116Accident · Minor injuriesFinal reportHughes OH-6A · El Paso, TXThe failure of the pilot to maintain rotor rpm during an autorotation, which resulted in a hard landing. A factor was the partial loss of engine power resulting from the separation of the power control line due to fatigue, as a consequence of improper…NTSB FTW00LA108Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Bridgeport, TXThe partial loss of engine power for an undetermined reason.NTSB FTW00LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Maud, OKthe loss of engine power while maneuvering as a result of the separation of the exhaust rocker arm retaining stud due to fatigue, which resulted in a precautionary landing.NTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.NTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.NTSB ATL00LA030Accident · Minor injuriesLimited investigationFinal reportBurak Stanley A XF4 · Brooksville, FLThe owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.NTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.NTSB LAX00LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Dos Palos, CAA partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.NTSB LAX00FA061Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Avalon, CAA loose pneumatic fitting caused the engine to go to flight idle power at a low altitude, which resulted in a forced landing in hilly terrain.NTSB CHI00LA056Accident · No injuriesLimited investigationFinal reportCessna 210 · South Lyon, MIthe failure of the throttle and the unsuitable terrain encountered by the pilot in the taxi area. Factors were the collapsed nose gear and the rough terrain,NTSB MIA00LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Fort Lauderdale, FLThe failure of the pilot to maintain minimum flying airspeed, (Vso) during takeoff following a partial loss of engine power resulting in the aircraft stalling, an uncontrolled descent, and collision with trees. A factor in the accident was the failure of the…NTSB DEN00GA022Accident · No injuriesFinal reportBell 206 L-3 · Rifle, COa forced landing on rough, unsuitable terrain. A contributing factor was the partial loss of engine power, which resulted from improper maintenance by repair station personnel.NTSB ATL00LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Bay Springs, MSThe pilot's failure to maintain flying speed that resulted in a loss of control and stall. A factor was a stuck exhaust valve.NTSB LAX00LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150H · El Monte, CAA cracked No. 2 engine cylinder, which led to a loss of power. A factor was the ditch in the forced landing area.NTSB DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.NTSB FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.NTSB ATL99LA130Accident · No injuriesLimited investigationFinal reportCessna 182P · Summerville, GAThe missing throttle linkage bolt from the carburetor due to an improper engine installation by maintenance personnel. Factors were the tailwind present during the landing roll and the trees.NTSB MIA99FA252Accident · No injuriesField investigationFinal reportBoeing B737-300 · West Palm Beach, FLThe fatigue fracture and separation of the high pressure turbine forward rotating air seal due to a manufacturing defect in a bolt hole that was not detected by the engine manufacturer due to inadequate and ineffective inspection techniques. Contributing to…NTSB FTW99LA247Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power resulting from a cylinder that failed for an undetermined reason.NTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB MIA99LA228Accident · No injuriesLimited investigationFinal reportWilliam John Schulz WJS Jaybird · Tangerine, FLthe pilot's improper torqueing of a rocker arm adjusting jam nut, that resulted in the adjuster loosening, and a partial loss of engine power. This resulted in the pilot making an off airport precautionary landing and subsequent nose over, during which the…NTSB CHI99LA277Accident · No injuriesLimited investigationFinal reportCessna 150M · Sikeston, MOthe loss of engine power due to the stuck exhaust valve. A factor was the lack of suitable terrain available for the forced landing.NTSB DEN99LA131Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Fairplay, COA partial loss of engine power due to a partial failure of the turbocharger.NTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.NTSB FTW99FA199Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Bethany, OKThe pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.NTSB SEA99FA113Accident · 1 fatalField investigationFinal reportAlexander VAN'S RV-8 · Lafayette, ORFatigue of the number two connecting rod end resulting in a fracture at the rod end and release from the crankshaft, an ensuing in-flight fuel fed fire, followed by the pilot's abandoning the aircraft in flight. A contributing factor was pressure on the pilot…NTSB SEA99LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · New Plymouth, IDLoss of engine power due to failure of the supercharger impeller. A contributing factor was the ditch.NTSB FTW99LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Pocahontas, ARThe failure of the carburetor heat control cable which resulted in a partial loss of engine power during initial takeoff climb. A factor was the lack of suitable terrain for the forced landing.NTSB LAX99LA245Accident · No injuriesLimited investigationFinal reportHughes 369D · Oakdale, CAThe disintegration and failure of the oil pump drive spur gear aft bearing, which resulted in failure of the oil pump and subsequent oil starvation to the engine's turbine module. A factor in the accident was the failure of company maintenance personnel to…NTSB ANC99LA082Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Mcgrath, AKA separation of the number 4 engine cylinder, and a fracture of the number 4 engine connecting rod.NTSB FTW99LA168Accident · No injuriesLimited investigationFinal reportCessna T188C · Panhandle, TXThe partial loss of engine power as a result of the low compression in the number 5 cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Rolling Fork, MSImproper torqueing of the connecting rod bolts which resulted in the bolts being loose and rubbing in the dowel area which resulted in fatigue emanation and cracking and separation of the number 3 connecting rod after bolt failure.NTSB CHI99FA163Accident · 4 fatalField investigationFinal reportCessna 421B · Jefferson City, MOthe pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.NTSB CHI99LA162Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Buxton, NDthe number one cylinder's separation, the pilot's visual lookout not possible through the oil given off by the number one cylinder, and the embankment. A factor in the accident was the oil.