NTSB investigations
2,723 cases where NTSB found Aircraft power plant.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0105')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0105')) 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 CEN25FA056Accident · Serious injuriesClass 3 · FieldFinal reportZenith Zodiac CH601 · Columbia, ILThe pilot’s failure to secure the engine oil filter following maintenance, which resulted in oil starvation, a total loss of engine power, and impact with terrain.NTSB CEN25LA053Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boscobel, WIThe ice obstruction of the engine oil breather tube and alternate air outlet, which resulted in a failure of the crankcase oil seal and loss of engine oil. Contributing to the accident was the incorrect engine oil breather tube installed in the airplane by…NTSB CEN25LA054Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1B · Brenham, TXA partial loss of engine power due to an obstructed induction system from a mud dauber nest.NTSB ERA25LA062Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski BOT Journey · Ocean Isle Beach, NCMaintenance personnel’s failure to identify and remediate a buildup of oxides in one of the engine’s carburetors, which resulted in the seizure of the carburetor’s piston slide and a subsequent total loss of engine power during initial climb.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…NTSB ERA25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportJames A Gray Just Aircraft Highlander · Fountain Inn, SCA total loss of engine power for undetermined reasons.NTSB ERA25LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Huntington, WVThe pilot’s failure to utilize carburetor heat while operating the engine at low power and in conditions conducive to the formation of carburetor ice, which resulted in a total loss of engine power due to carburetor icing.NTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.NTSB WPR25LA039Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Pomona, CAA total loss of engine power during final approach for reasons that could not be determined.NTSB CEN25LA046Accident · Serious injuriesClass 4 · LimitedFinal reportRotor Flight Dynamics Dominator · Gilbert, MNA total loss of engine power and subsequent autorotation to a swamp, that resulted in a rollover. Contributing to the pilot’s delayed egression from the gyroplane, was the lack of a restraint system cutting device.NTSB CEN25LA038Accident · Minor injuriesClass 4 · LimitedFinal reportComposite FX Mosquito XE · Waco, TXThe total loss of engine power and subsequent impact with terrain during an autorotation. Contributing to the accident was the improper sealing of the liquid cooling system.NTSB ERA25LA056Accident · No injuriesClass 4 · LimitedFinal reportFinn Lassen RV-4 · O'Brien, FLA total loss of engine power and navigational equipment as a result of a faulty battery.NTSB ERA25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 310K · Alcoa, TNThe failure of the left engine throttle control shaft bushing during taxi, resulting in a full asymmetric power condition and a taxiway excursion.NTSB ERA25LA041Accident · Minor injuriesClass 3 · LimitedFinal reportAnderson Kitfox 4 · New Castle, PAA partial loss of engine power due to a split fuel line that resulted in a fuel leak and reduced fuel supply to the aft carburetor.NTSB WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…NTSB WPR25LA027Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · St. George, UTA partial loss of power for reasons that could not be determined due to postimpact fire damage.NTSB CEN25LA025Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Denton, TXThe partial loss of engine power during the initial climb and the pilot’s failure to maintain directional control during the forced landing with a tailwind.NTSB CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB ERA25LA012Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYA total loss of engine power for undetermined reasons.NTSB ERA25LA011Accident · No injuriesClass 3 · LimitedFinal reportSaint Glasair II SFT · Forest, VAThe installation of a non-failsafe coupler that resulted in the separation of the throttle cable from the throttle arm and a subsequent partial loss of engine power.NTSB WPR25LA010Accident · No injuriesClass 4 · LimitedFinal reportEnstrom Helicopter 280C · Vale, ORThe pilot’s failure to maintain engine and rotor rpm during takeoff, that resulted in a hard landing.NTSB WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.NTSB CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.NTSB ERA25LA004Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Parsonsburg, MDA total loss of engine power for reasons that were not determined.NTSB CEN24LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Caro, MIA total loss of engine power due to maintenance personnel’s failure to properly tighten the fuel supply line B-nut at the fuel servo.NTSB ERA24LA392Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · LaGrange, GAImproper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.NTSB ERA24LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172K · Spartanburg, SCMaintenance personnel’s failure to follow the engine manufacturer’s maintenance guidance, which resulted in the assembly of the engine with an obstructed oil passage, a subsequent lack of lubrication to the front main bearing, and a total loss of engine power.NTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.NTSB ERA24LA380Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Baltimore, MDThe undetected worn internal parts of the on-condition carburetor, which restricted movement of the float, resulting in fuel starvation. Contributing to the severity of the accident was the pilot’s delayed reduction of the throttle when performing a forced…NTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB CEN24LA354Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170A · Marshall, INThe fatigue fracture of the No. 6 piston connecting rod, which resulted in a loss of engine power.NTSB CEN24LA350Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Englewood, COA partial loss of engine power due to fuel-oil contamination of the fuel injection servo.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB CEN24LA341Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D · Trojan, SDThe partial loss of engine power due to a loose magneto and subsequent impact with terrain.NTSB CEN24LA337Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · East Troy, WIThe pilot/mechanic’s improper torquing of the fuel hose fitting while replacing the fuel pump, which allowed air to enter the fuel system and resulted in a loss of engine power during initial climb. Contributing to the accident was the pilot/mechanic’s…NTSB CEN24LA333Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH601 XL · Odessa, MOOverheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB WPR24LA294Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Bend, ORA failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lynchburg, VAA total loss of engine power for undetermined reasons.NTSB ERA24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 65-TAC · Clearwater, FLThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the outcome, was the pilot’s inability to control the engine following the loss of directional control due to the separation of a knob from the engine’s throttle…NTSB WPR24FA287Accident · Serious injuriesClass 3 · FieldFinal reportPitts S1 · Santa Paula, CAThe total loss of engine power at low altitude for reasons that could not be determined.NTSB CEN24LA317Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Guthrie, OKA loss of engine power due to the separation and ingestion of an air filter retaining bracket into the engine cylinder.NTSB ERA24LA355Accident · No injuriesClass 4 · LimitedFinal reportYates Elden H Avipro Bearhawk · Roxbury, METhe pilot’s unstable approach which resulted in a landing with insufficient runway remaining to stop and subsequent impact with a river embankment. Contributing was the engine coolant system anomaly.NTSB CEN24LA313Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Dyess, ARThe improper overhaul of the carburetor and the malfunction of left magneto which resulted in a partial loss of engine power.NTSB WPR24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-201T · Sacramento, CAA loss of engine power during the initial climb due to the detachment of the turbocharger’s inlet sleeve as a result of the installation of an incorrect sleeve clamp.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB ERA24LA335Accident · Serious injuriesClass 3 · LimitedFinal reportHendrickson Glasair 3 · Oxford, MEA loss of engine power for reasons that could not be determined.NTSB CEN24LA303Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Bryant, IAA loss of engine power during takeoff for reasons that could not be determined, resulting in impact with terrain.NTSB ANC24LA073Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC2 · Anchorage, AKA partial loss of power during takeoff climb for undetermined reasons.