Fatal NTSB investigations: Lycoming IO-540 series
276 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.\"highestInjuryLevel\" = 'Fatal'
AND 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."highestInjuryLevel" = 'Fatal'
AND 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 ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaNTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB CEN15FA305Accident · 2 fatalField investigationFinal reportPiper PA 32-300 · Brazoria, TXThe student pilot's failure to arrest the descent in a timely manner and the flight instructor's failure to safely intervene in the routine training maneuver for reasons that could not be determined based on the information available.NTSB CEN15FA268Accident · 1 fatalField investigationFinal reportPiper PA 32 · Cuba, MOThe pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…NTSB ERA15FA025Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Frederick, MDThe failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…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 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 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 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 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 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 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 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 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 ANC12FA083Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Hoonah, AKThe pilot's failure to maintain clearance from trees and terrain while in cruise flight in marginal visual meteorological conditions.NTSB ANC12FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Fairbanks, AKThe noninstrument-rated pilot's decision to continue visual flight into instrument meteorological conditions likely leading to spatial disorientation, which resulted in a loss of airplane control and in-flight structural failure.NTSB WPR12LA259Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · East Wenatchee, WAThe pilot’s failure to adequately monitor the environment and maintain clearance from the power lines while maneuvering at low altitude.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB CEN12FA139Accident · 2 fatalField investigationFinal reportRobinson R44 II · Centerville, LAThe pilot allowed the helicopter to settle with power while maneuvering at low altitude.NTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.NTSB ERA12FA012Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Peru, WVThe non-instrument rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent in-flight collision with mountainous terrain.NTSB WPR11FA474Accident · 1 fatalField investigationFinal reportPoe G L/Poe S Y 540 · Chualar, CAThe pilot’s incapacitation due either to g-induced loss of consciousness alone or in combination with a cardiac arrhythmia. Contributing to the accident was the pilot’s use of several medications.NTSB ERA11FA512Accident · 1 fatalField investigationFinal reportHeronimus Kevin A Glasair III · Falls of Rough, KYThe failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.NTSB WPR11FA395Accident · 1 fatalField investigationFinal reportMaule M-7-235C · Brookings, ORThe pilot’s improper decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in a collision with trees while on approach for landing.NTSB ERA11FA412Accident · 2 fatalField investigationFinal reportCessna 182S · Erwin, NCThe pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.NTSB CEN11LA399Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Highmore, SDThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB ERA11FA272Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Indiana, PAThe pilot's operation of the helicopter at a low-forward airspeed out of ground effect, which resulted in the helicopter’s loss of translational lift and tail rotor authority and the pilot’s subsequent loss of helicopter control.NTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…NTSB CEN11LA066Accident · 1 fatalLimited investigationFinal reportGearn Geary D Swearingen SX300 · Milford, IAA loss of control for undetermined reasons.NTSB ERA11LA048Accident · 2 fatalLimited investigationFinal reportBean R E/R B Weld Glasair III · Winchester, TNThe pilot's inadvertent climb and entry into instrument meteorological conditions during a course reversal, which resulted in spatial disorientation and a loss of control.NTSB WPR11FA027Accident · 2 fatalField investigationFinal reportReed Glasair III SH-3R · Lake Mathews, CAThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude beneath a cloud layer.NTSB ERA10FA471Accident · 1 fatalField investigationFinal reportCessna 182T · Helena, GAThe pilot’s continuance of the GPS approach below the minimum descent altitude while landing in instrument meteorological conditions.NTSB WPR10FA449Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Las Vegas, NVThe pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.NTSB ERA10FA409Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Washington, GAThe manufacturer's inadequate quality control and improper manufacture of the fuel servo diaphragm assembly, which resulted in fatigue cracking of the hub stud and subsequent loss of engine power due to fuel starvation.NTSB WPR10LA354Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Salt Lake City, UTThe pilot's loss of directional control while attempting to move the helicopter laterally without first lifting it fully off its landing platform.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB WPR10GA231Accident · 1 fatalFinal reportCessna T206H · Borrego Springs, CAThe pilot suffered a sudden incapacitating event as a result of his severe cardiovascular disease.NTSB WPR10LA195Accident · 1 fatalLimited investigationFinal reportSnow Rocket F1 · Borrego Springs, CAThe pilot's inability to maintain control due to the in-flight failure and separation of the pilot's flight control stick. The reason for the flight control stick failure could not be determined.NTSB ERA10WA133Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Restauracion, Dominican Republic, Dominican RepublicOn February 4, 2010, about 1940 Atlantic standard time, a Robinson R44II helicopter, N7535F, impacted the side of Mount Jina Mocha, in the city of Restauracion, Dominican Republic, at night, while en route from Port Au Prince, Haiti to Cibao International…NTSB ERA10LA113Accident · 1 fatalLimited investigationFinal reportFoster John Glasair III · Oxford, CTThe pilot's failure to maintain a proper approach path during visual conditions at dusk, which resulted in an in-flight collision with power lines.NTSB ERA10LA082Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Memphis, TNThe pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…NTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.NTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.NTSB WPR09FA385Accident · 1 fatalField investigationFinal reportCessna 182S · Napa, CAThe instrument-rated pilot’s loss of situational awareness and failure to follow the prescribed instrument departure clearance/procedure, which resulted in an in-flight collision with the terrain.NTSB CEN09LA427Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540 · Tarkio, MOThe pilot's failure to maintain aircraft control during the aerobatic flight.NTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.NTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.