Final NTSB investigations
604 cases where the sequence of events included Powerplant sys/comp malf/fail.
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.NTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.NTSB ERA22LA297Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G-164A · Hopewell Township, NJA partial loss of engine power while maneuvering at low altitude due to a failure of the airplane’s supercharger.NTSB ERA22LA277Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hunter · Wilmington, NCA bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.NTSB ANC22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Palmer, AKThe loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat.NTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.NTSB CEN22LA253Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T206H · Austin, TXA total loss of engine power due to an engine fire that resulted from failure of the turbocharger exhaust clamp, which allowed hot exhaust gases to damage other vital engine components.NTSB ERA22FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201 · Panama City, FLMaintenance personnel’s failure to follow the avionics installation guidance for the oil pressure sensor, which resulted in the high-cycle fatigue failure of an line, oil starvation, and the subsequent loss of engine power. Contributing to the accident was…NTSB CEN22LA234Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Henderson, TXThe partial loss of engine power in a hover due to a stuck exhaust valve.NTSB CEN22LA233Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Amarillo, TXThe loss of engine power due to a leak in the fuel control assembly. Contributing to the accident was the inadequate maintenance of the fuel control assembly.NTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.NTSB WPR22LA177Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Enterprise, ORThe inadequate maintenance and inspection of the crankshaft expansion plug, which resulted in the separation of the expansion plug from the crankshaft and the subsequent loss of oil and windshield obstruction during departure.NTSB ERA22LA224Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Somerville, TNThe inadequate inspection and maintenance of the engine exhaust system, which resulted in an in-flight fire.NTSB ERA22LA268Accident · No injuriesClass 3 · LimitedFinal reportWingren Norman Escapade · Brasstown, NCThe failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.NTSB CEN22LA128Accident · No injuriesClass 3 · LimitedFinal reportRyan L17 · Livingston, ILA total loss of engine power due to fuel injection system contamination from an unknown source.NTSB CEN22LA123Accident · Serious injuriesClass 3 · LimitedFinal reportPitts S-1T · Spring, TXThe failure of maintenance personnel to properly connect the throttle cable, which led to the pilot’s inability to control engine power during the initial climb. Contributing to the accident was the pilot’s misjudgment of the headwind during the forced…NTSB DCA22FA082Accident · No injuriesClass 3 · FieldFinal reportJoby Aero JAS4-2 · Jolon, CAThe separation of a propeller blade during expansion flight testing that resulted in cascading effects to include the separation of multiple propulsion motor/propeller assemblies and the loss of remote pilot control of the aircraft. Contributing to the…NTSB CEN22LA117Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Lincoln, NEThe pilot’s decision to continue the flight with abnormal engine indications and the subsequent failure of the No. 5 cylinder connecting rod for unknown reasons.NTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.NTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.NTSB CEN22LA085Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · West Helena, ARThe malfunction of the propeller autofeather system after takeoff for undetermined reasons, which resulted in both propellers going into feather and a hard landing.NTSB ERA22LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Brent, ALThe inadequate maintenance of the oil filter adapter, which resulted in in an engine oil leak and subsequent loss engine oil pressure, and the subsequent off-airport landing.NTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB CEN21LA472Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · East Sparta, OHA total loss of engine power due to a fatigue failure of the No. 2 cylinder exhaust valve.NTSB ERA21LA356Accident · No injuriesClass 3 · LimitedFinal reportWaco GXE · Burt, NYThe improper magneto timing, which resulted in the engine’s inability to produce full power during the takeoff.NTSB ERA21LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Venice, FLMaintenance personnel’s failure to use the correct throttle linkage hardware when reinstalling the engine, resulting in a disconnection of the throttle during flight.NTSB CEN21LA402Accident · No injuriesClass 3 · LimitedFinal reportMurphy Renegade II · Sheridan, ILA total loss of engine power during initial climb due to a piston seizure.NTSB ANC21LA094Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-3 · Bettles, AKThe seizure of the engine during flight for undetermined reasons, which led to a total loss of engine power.NTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.NTSB WPR21LA301Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Amado, AZThe inflight separation of a section of a propeller blade due to a fatigue crack, which resulted in a forced landing.NTSB CEN21LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Patterson, LAThe mechanic’s failure to properly secure the throttle arm rendering it loose and inoperable after takeoff, which resulted in a total loss of engine power.NTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB CEN21LA264Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Elwood, NEThe failure of the engine master rod, resulting in a total loss of engine power and a forced landing.NTSB WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.NTSB CEN21LA222Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Racine, WIThe fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.NTSB ANC21LA038Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F-28F · Palmer, AKA loss of drive to the rotor system due to the disengagement of the main belt drive tensioning system, which resulted in a forced landing. The disengagement was due to inadequate clearance between the clutch handle and the roll pin in the handle bellcrank…NTSB CEN21LA138Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182F · Millville, IAThe inadequate maintenance/inspection of the airplane, which resulted in a total loss of engine power due to oil starvation.NTSB DCA21FA085Incident · No injuriesClass 3 · FieldFinal reportBoeing 777-222 · Broomfield, COThe fatigue failure of the right engine fan blade. Contributing to the fan blade failure was the inadequate inspection of the blades, which failed to identify low-level indications of cracking, and the insufficient frequency of the manufacturer’s inspection…NTSB CEN21FA130Accident · 2 fatalClass 3 · FieldFinal reportVelocity Vtwin · Janesville, WIThe exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…NTSB ERA21LA109Accident · Serious injuriesClass 3 · LimitedFinal reportPlante Challenger II · Minneola, FLFailure of the engine/propeller drive belt.NTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.NTSB ENG21LA011Incident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Opa Locka, FLAn uncontained left engine failure caused by a low cycle fatigue crack that originated from a manufacturing machining groove on the high pressure compressor impeller aft face. Contributing to the incident was service bulletin borescope inspection criteria…NTSB CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.