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 ATL07CA046Accident · Serious injuriesData collectionFinal reportRobinson R-44 · Covington, GAThe student pilot's failure to maintain control of the helicopter during liftoff, which resulted in an in-flight collision with the ground.NTSB LAX07CA091Accident · No injuriesData collectionFinal reportMaule M-7-235B · Prescott, AZThe pilot's inadequate preflight inspection, and his failure to maintain sufficient airspeed to avoid a stall/mush during an aborted takeoff, which resulted in a loss of control, and an in-flight collision with terrain. Factors associated with the accident…NTSB NYC07FA055Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Jamestown, NYThe pilot's incorrect selection of the right engine fuel selector position, which resulted in fuel starvation of the right engine, a loss of the right engine's power, and a loss of control during initial climb. Contributing to the accident were the pilot's…NTSB CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…NTSB LAX07LA054Accident · 2 fatalLimited investigationFinal reportJohn Lauer Harmon Rocket II · Bakersfield, CAThe pilot's failure to maintain terrain clearance during an aerobatic maneuver.NTSB NYC07LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Bardstown, KYThe loss of engine power for undetermined reasons.NTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.NTSB ATL06LA133Accident · No injuriesLimited investigationFinal reportRobinson R44 · Beaufort, NCThe loss of engine power for undetermined reasons.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB DFW06CA203Accident · No injuriesData collectionFinal reportPiper 601P · Lubbock, TXThe pilot's failure to extend the landing gear while on final approach.NTSB ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.NTSB MIA06CA131Accident · No injuriesData collectionFinal reportCessna 182S · Fort Myers, FLThe pilot's failure to maintain control during the landing rollout during gusting wind conditions, which resulted in the airplane veering off the runway.NTSB SEA06FA159Accident · 3 fatalField investigationFinal reportRobinson R44 II · Warrenton, ORThe pilot's intentional flight into instrument meteorological conditions while maneuvering which resulted in an in flight collision with terrain/water.NTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaNTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.NTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.NTSB LAX06LA229Accident · No injuriesLimited investigationFinal reportVelocity 173/RG-XL · Modesto, CAthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a hard landing and landing gear collapse. A contributing factor was the pilot/builder's inadequate adjustment of the landing gear cable tension.NTSB LAX06LA228Accident · No injuriesLimited investigationFinal reportPalmer Seawind 3000 · Havasu Lake, CAan electrical fire due to improper wiring of the electrical system by other maintenance personnel.NTSB CHI06CA181Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Indianapolis, INThe failure of the tug driver to maintain clearance from the airplane taxiing on an active taxiway. A factor was the night conditions.NTSB DFW06LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Midland, TXThe partial loss of engine power as result of the maintenance personnel's failure to comply with a manufacture's Service Bulletin (SB). A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06CA212Accident · No injuriesData collectionFinal reportMaule M-7-235C · La Verne, CAthe pilot's failure to obtain/maintain directional control on the landing rollout.NTSB CHI06CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Jackson, MIThe pilot's inadvertent wheels up landing.NTSB CHI06LA137Accident · No injuriesLimited investigationFinal reportMaule MT-7-235 · Flushing, MIThe pilot's selection of unsuitable terrain for landing, which resulted in the collapse of the amphibian float's nose wheels, and a nose over during the landing roll. Factors associated with the accident were the soft grass runway, and the collapse of the…NTSB CHI06CA125Accident · No injuriesData collectionFinal reportBangham Barracuda · Monett, MORupture of the hydraulic hose and deformation of the hydraulic cylinder piston rods for undetermined reasons, which resulted in a failure of the landing gear extension system. Contributing factors were the pilot's premature shutdown of the engine on short…NTSB ATL06CA073Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Rocky Point, NCThe pilot's inadequate visual lookout during a precautionary landing which resulted in an in-flight collision with a transmission wire.NTSB CHI06CA122Accident · No injuriesData collectionFinal reportCessna 182T · Madison, WIThe student pilot's failure to maintain directional control during landing which resulted in a runway excursion and collapse of the nose landing gear. A contributing factor was the pilot's inadequate compensation for the crosswind condition. Additional…NTSB DFW06FA102Accident · 2 fatalField investigationFinal reportRobinson R44 II · Fredericksburg, TXThe pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.NTSB LAX06LA141Accident · 1 fatalLimited investigationFinal reportVelocity XL-RG · Pearce, AZa departure from controlled flight for undetermined reasons, resulting in a collision with terrain.NTSB CHI06CA103Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Grayslake, ILThe pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.NTSB ANC06LA029Accident · 1 fatalLimited investigationFinal reportCooper Harmon Rocket ll · McKittrick, CAThe pilot's failure to maintain altitude/clearance while performing intentional low altitude aerobatic flight maneuvers. Factors associated with the accident are the low altitude aerobatic flight maneuvers.NTSB ANC06LA025Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ilimana, AKThe pilot's continued flight into adverse weather conditions, and his spatial disorientation and loss of control during a subsequent landing attempt. Factors associated with the accident are flat light and whiteout conditions, fog, and snow-covered terrain.NTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.NTSB SEA06WA045Accident · 4 fatalForeign investigationEADS Socata TB-20 Trinidad · Bourdeau, FranceNTSB ATL06LA027Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Maiden, NCThe total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.NTSB MIA06WA035Accident · 4 fatalForeign investigationPiper PA-23-250 · South Caicos, Turks & Caicos IslandsNTSB DEN06CA027Accident · No injuriesData collectionFinal reportMaule M-7-235 · Moriarty, NMthe pilot's failure to maintain directional control during the landing. Contributing factors included the pilot's inadequate in-flight decision making and the high velocity, gusty winds.NTSB LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.NTSB DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.NTSB NYC06FA034Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Burlington, VTThe pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…NTSB LAX06CA039Accident · No injuriesData collectionFinal reportCessna 182T · Livermore, CAsubstantial damage to the airplane during unknown phase of flight for undetermined reasons.NTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.NTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.NTSB IAD05CA143Accident · No injuriesData collectionFinal reportMaule MT7-235 · Capon Bridge, WVThe pilot's misjudged distance/speed which resulted in an overrun and a subsequent impact with trees.NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB IAD05FA125Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · West Chester, PAThe pilot's improper decision to abort the landing after the airplane contacted the runway. A factor in the accident was the pilot's failure to ensure the landing gear was extended during the landing.NTSB IAD05LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Smoketown, PAA loss of engine power during the climb for undetermined reasons, resulting in a forced landing.NTSB DFW05LA193Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540-T · Denison, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the low altitude.NTSB ANC05CA102Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Karluk, AKA collision with a deer on the runway during the landing roll, which resulted in substantial damage to the tail of the airplane.