NTSB investigations: Lycoming IO-540 series
1,056 cases on aircraft whose registry engine model is Lycoming IO-540 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.NTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.NTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.NTSB WPR14LA345Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-236 · Salmon, IDMaintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…NTSB ERA14LA369Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Helena, ALA total loss of engine power for reasons that could not be determined due to postcrash fire damage.NTSB CEN14CA422Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Warsaw, INThe pilot failed to maintain directional control during landing.NTSB ERA14LA330Accident · 1 fatalLimited investigationFinal reportZubair S Khan Raven · Mattituck, NYThe pilot's failure to ensure that the airplane was loaded within its calculated center of gravity limits, which resulted in longitudinal instability and a subsequent unrecoverable stall.NTSB WPR14TA278Accident · No injuriesFinal reportRockwell International 500 S · Willcox, AZThe pilot’s failure to compensate for tailwind conditions and maintain directional control during landing, which resulted in a runway excursion.NTSB WPR14CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Quincy, WAThe pilot's failure to maintain clearance from a wind generator tower while drying cherries, which resulted in a loss of aircraft control and subsequent hard landing.NTSB ERA14LA311Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Nashville, TNThe pilot’s failure to maintain rotor rpm during an autorotation after a perceived partial loss of power, which resulted in a hard landing. Contributing to the accident was radio frequency interference with the governor controller, which resulted in an…NTSB ANC14CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Coldfoot, AKThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in an emergency landing on uneven terrain.NTSB CEN14CA318Accident · No injuriesData collectionFinal reportMeyer Geoffrey A Goat · Wolcott, COThe failure of an oil line leading to the oil pressure transducer which resulted in oil starvation and subsequent loss of engine power.NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB WPR14FA218Accident · 2 fatalField investigationFinal reportNebert Vans RV-10 · Toledo, ORA total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…NTSB ANC14FA030Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Chugiak, AKThe pilot's loss of control of the helicopter due to impairment or incapacitation from a sudden, acute cardiac event.NTSB ERA14LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · Elkton, MDThe pilot’s failure to attain the proper touchdown point during a no-flap landing to a wet, down-sloping runway, and the airplane's dynamic hydroplaning after touchdown, which resulted in a runway overrun. Contributing to the accident was a total loss of…NTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.NTSB CEN14CA223Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Liberty, MOThe pilot's failure to maintain directional control while operating in gusty wind conditions at a low altitude.NTSB ERA14FA163Accident · 1 fatalField investigationFinal reportDehavilland DHC-1 · Vonore, TNThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…NTSB CEN14CA142Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Bonham, TXThe pilot's inadequate recovery from a loss of tail rotor effectiveness during a low altitude downwind hover in a gusty wind condition resulting in the helicopter contacting the ground and rolling over.NTSB ERA14FA115Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Panacea, FLThe pilot’s failure to maintain adequate clearance from trees during a takeoff at night. Contributing to the accident was the pilot’s lack of recent night flight experience.NTSB ERA14LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Millen, GAThe pilot's failure to fully seat the fuel selector in the left tank position before takeoff, which resulted in fuel starvation and a subsequent loss of engine power.NTSB WPR14LA071Accident · No injuriesLimited investigationFinal reportPiper PA 32-301 · Los Angeles, CAThe total loss of engine power during takeoff due to fuel starvation, which resulted from the pilot’s failure to adequately manage the fuel supply.NTSB ERA14CA055Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Tunica, MSThe student pilot's failure to maintain control of the helicopter during the attempted takeoff, and the flight instructor's inadequate supervision of the student pilot.NTSB CEN14FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Kirksville, MOA loss of control due to spatial disorientation. Contributing to the accident were the private pilot's impairment due to a sedating antihistamine and both pilots' fatigue.NTSB CEN14FA014Accident · 2 fatalField investigationFinal reportPiper PA 32R-301 · Huntsville, ARThe noninstrument-rated pilot’s continued flight into an area of known rain with reduced visibility and his failure to maintain airplane control while maneuvering the airplane after entering these conditions.NTSB WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.NTSB WPR13CA403Accident · No injuriesData collectionFinal reportMaule M-7-260C · Nashua, MTThe pilot's failure to maintain clearance from a berm during the takeoff, which resulted in a loss of directional control.NTSB WPR13FA343Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Thompson Falls, MTThe pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.NTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.NTSB WPR13CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · The Dalles, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB WPR13LA217Accident · No injuriesLimited investigationFinal reportRobinson R44 II · Pomeroy, WAThe pilot's failure to ensure that the helicopter was properly loaded, which resulted in the helicopter being in excess of its maximum allowable gross weight and led to a loss of main rotor rpm on takeoff. Contributing to the accident were the ground…NTSB CEN13LA233Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Paris, TXThe improper installation of the connecting rod bolts, which resulted in an engine failure.NTSB CEN13LA228Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Buffalo, SDThe pilot’s failure to maintain adequate main rotor rpm while maneuvering at a low altitude in gusting wind conditions, which resulted in an emergency landing on uneven terrain.NTSB WPR13LA188Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ocean Shores, WAThe pilots’ loss of helicopter control during the approach to landing.NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.NTSB CEN13LA194Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Eagle Nest, NMA total loss of engine power due to a rapid throttle change during autorotation, which the flight instructor initiated in response to a low rotor rpm warning, which resulted from the separation of one of the magnets used to provide rotor rpm indications from…NTSB CEN13FA182Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Broomfield, COLoss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the fuel gauge to indicate the actual amount of fuel on board the airplane and the design of the airplane's fuel system, which precluded a visual confirmation of the…NTSB ERA13CA123Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Lancaster, PAThe pilot’s failure to maintain clearance from a parked vehicle while taxiing from landing.NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.NTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…NTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.NTSB WPR13LA023Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R-44 II · Toutle, WAThe pilot’s failure to maintain precise altitude control, which resulted in the helicopter entering a settling with power condition while hovering out of ground effect.NTSB WPR13CA021Accident · No injuriesData collectionFinal reportPiper PA24 · Lake Tahoe, CAThe pilot's failure to ensure that the landing gear was extended before landing.NTSB WPR12CA431Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · McMinnville, ORThe pilot's aggressive takeoff maneuver, which resulted in a loss of control.NTSB ERA12CA553Accident · No injuriesData collectionFinal reportCessna 182T · Marion, SCThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12LA573Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Belgium, WIThe pilot’s failure to maintain control of the helicopter while landing in gusting wind conditions, which resulted in a hard landing.