NTSB investigations: Lycoming O-360 series
308 cases on aircraft whose registry engine model is Lycoming O-360 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 ('41575'))
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 ('41575'))
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 CEN14LA313Accident · Minor injuriesLimited investigationFinal reportRobinson R22 - Beta · Moscow Mills, MOThe flight instructor’s delayed remedial action to correct the student pilot’s use of an excessive descent rate during a practice autorotation, which resulted in a hard landing.NTSB ERA14CA265Accident · No injuriesData collectionFinal reportDivis S L/Waltrip A J RV 4 · Harpswell, METhe pilot's inadequate preflight and in-flight planning which resulted in total loss of engine power due to fuel exhaustion.NTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.NTSB WPR14FA111Accident · Serious injuriesField investigationFinal reportPiper PA 28-181 · Phoenix, AZThe student pilot’s inadvertent positioning of the fuel selector in an intermediate position, which resulted in a loss of engine power due to fuel starvation.NTSB ERA14CA102Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe certificated flight instructor's failure to maintain helicopter control during a run-on landing, resulting in a rollover and ground collision.NTSB CEN14CA061Accident · No injuriesData collectionFinal reportAviat A 1B · Cypress, TXThe pilot's failure to maintain control during landing which resulted in an impact with the runway surface.NTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).NTSB WPR13LA315Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alta, UTThe flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.NTSB ANC13CA060Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot's loss of situational awareness, which resulted in a wrong turn into a box canyon, and an in flight collision with terrain.NTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.NTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.NTSB WPR13CA107Accident · No injuriesData collectionFinal reportRobinson R22 · Kona, HIThe pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.NTSB ERA13FA070Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Apollo Beach, FLMast bumping for reasons that could not be determined because one main rotor blade was not recovered.NTSB WPR12CA405Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lake Newman, WAThe flight instructor's failure to maintain clearance from terrain while correcting for the student pilot's failure to maintain directional control of the helicopter.NTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.NTSB WPR12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe flight instructor’s delayed response in correcting the student pilot’s improper landing flare, which resulted in a hard landing.NTSB ANC12CA091Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Talkeetna, AKThe pilot's decision to land on a short, wet, off-airport landing site, which resulted in a runway excursion.NTSB WPR12LA348Accident · No injuriesLimited investigationFinal reportSantana PA-18 Replica · Ronan, MTA jammed tailwheel assembly, which resulted in the pilot’s inability to maintain directional control upon landing.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB WPR12CA307Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bountiful, UTThe student’s failure to maintain adequate rotor rpm and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB WPR12FA298Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Murrieta, CAThe pilot's failure to maintain clearance from high vegetation while making a hovering turn, which resulted in a dynamic rollover.NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB ERA12LA305Accident · Serious injuriesLimited investigationFinal reportAviat A-1B · Sylacauga, ALThe pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB WPR12LA109Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Antioch, CAThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…NTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11LA436Accident · No injuriesLimited investigationFinal reportTubbs S/Performance PA-18 225DD · Mile Hi Landing Strip, IDThe collapse of the left landing gear during landing for undetermined reasons.NTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.NTSB CEN11CA550Accident · Serious injuriesData collectionFinal reportAttaway Robert H RV6A · Colorado Springs, COThe pilot's failure to maintain control while landing.NTSB ERA11LA409Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Dayton, NJThe pilot's inadequate compensation for wind during an out-of-ground-effect hover, which resulted in a loss of control due to settling with power and loss of tail rotor effectiveness.NTSB WPR11CA264Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the helicopter during taxi, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.NTSB CEN11CA351Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILThe student pilot’s failure to maintain control of the helicopter while hovering.NTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.NTSB ERA11CA235Accident · No injuriesData collectionFinal reportRobinson R22 · Marlboro, MAThe student pilot's failure to maintain directional control during takeoff.NTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.NTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.NTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR11CA031Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe student pilot's failure to maintain the proper airspeed and the certificated flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing and rollover.NTSB WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.NTSB CEN10FA557Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Woodruff, WIThe pilot's decision to attempt an instrument approach in turbulent night instrument meteorological conditions with a recently-identified deficiency with his instrument flight proficiency, which resulted in a loss of airplane control as a result of spatial…NTSB ANC10CA075Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Talkeetna, AKThe pilot’s failure to maintain aircraft control during an off airport landing.NTSB CEN10CA466Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Pettus, TXThe pilot's decision to exit the helicopter with the engine running.NTSB WPR10CA358Accident · No injuriesData collectionFinal reportAviat A-1B · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.NTSB CEN10CA366Accident · No injuriesData collectionFinal reportAviat A-1B · Centennial, COThe student pilot's failure to maintain directional control and the certified flight instructor's delay in remedial action.