NTSB investigations: Lycoming O&VO-360 series
5,181 cases on aircraft whose registry engine model is Lycoming O&VO-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 ('41514'))
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 ('41514'))
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 ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.NTSB DEN08LA163Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Duncan, OKA total loss of engine power due to the fatigue failure of the engine crankshaft. Contributing to the accident were the improper maintenance to the engine crankshaft, improper reassembly of the engine, and failure to follow the engine manufacturer's overhaul…NTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…NTSB NYC08LA317Accident · Serious injuriesLimited investigationFinal reportSorrell Skybolt · Williamstown, KYA loss of engine power due to oil starvation as a result of improper servicing (removal of preserving fluid) of the engine after it had been returned from storage.NTSB DEN08LA159Accident · No injuriesLimited investigationFinal reportCessna 172RG · St. Louis, MOThe improper maintenance performed resulting in a jammed nose landing gear door preventing the extension of the nose landing gear.NTSB CHI08CA283Accident · Minor injuriesData collectionFinal reportMooney M20C · Bolingbrook, ILThe non-mechanical loss of engine power due to the pilot's incorrect positioning of the fuel tank selector prior to takeoff and the subsequent fuel starvation during takeoff.NTSB SEA08CA199AccidentData collectionFinal reportCessna 177B · Truckee, CAThe pilot's improper decision to take off in a heavily loaded airplane under the ambient conditions that existed at the time. Contributing to the accident was the mountainous/hilly terrain, a high density altitude, gusty winds and downdrafts.NTSB DFW08CA230AccidentData collectionFinal reportMooney M20D · Grand Saline, TXA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB NYC08CA312Accident · No injuriesData collectionFinal reportCessna 177 · Warwick, NYThe pilot's failure to obtain the proper touchdown point while landing.NTSB MIA08LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wallace, NCThe pilot's failure to abort the takeoff when the engine failed to develop full power. Contributing to the accident was the pilot's failure to remove the intake plugs prior to takeoff.NTSB ANC08CA117Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe student pilot's inadequate recovery from a bounced landing.NTSB NYC08FA298Accident · 1 fatalField investigationFinal reportMooney M20C · Lawrenceburg, TNA loss of engine power due to fuel exhaustion.NTSB CHI08LA273Accident · No injuriesLimited investigationFinal reportBeech C23 · Grayslake, ILThe inadequate flare by the student pilot and the inadequate supervision and delayed go-around performed by the flight instructor. Contributing to the accident were the student pilot's failure to attain/maintain a stabilized approach.NTSB LAX08CA280Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Wasco, ORThe pilot's failure to maintain directional control while landing.NTSB CHI08CA298Accident · No injuriesData collectionFinal reportLake LA-4 · Algonac, MIThe amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.NTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.NTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.NTSB SEA08FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Monticello, UTThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the low altitude.NTSB DEN08CA133Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe student pilot's failure to maintain control of the airplane. Contributing to the accident were the flight instructor's inadequate supervision, turbulence, airspeed was not maintained, and compensation for the wind conditions was inadequate.NTSB MIA08CA153Accident · No injuriesData collectionFinal reportBeech C23 · Winter Haven, FLThe student pilot's improper recovery from a bounced landing.NTSB CHI08LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Tomahawk, WIA total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB LAX08LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAA partial loss of engine power due to the disconnection of the throttle control cable from the throttle arm due to the operator's improper maintenance. Contributing to the accident was unsuitable terrain for a forced landing.NTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.NTSB SEA08LA158Accident · 1 fatalLimited investigationFinal reportMauck RV-6A · Sierraville, CAThe pilot's failure to maintain clearance with trees and terrain while maneuvering Contributing to the accident was the reduced visibility in the area due to smoke.NTSB CHI08CA174Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Greenwood, ILThe student pilot's inadequate compensation for the gusting crosswind, and the flight instructor's delayed remedial actions that resulted in a loss of control during the go-around maneuver. Contributing to the accident was the gusting wind condition.NTSB ANC08CA084Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.NTSB ANC08LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain directional control during the takeoff roll and liftoff, which resulted in a collision with trees and the ground.NTSB LAX08CA194Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Angwin, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX08CA171Accident · No injuriesData collectionFinal reportPiper Cub Crafters PA-18-150 · Fall RiverMills, CAThe pilot's selection of an unsuitable takeoff/landing area.NTSB CHI08LA160Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Battle Creek, MIThe in-flight separation of the tip of a propeller blade due to metal fatigue that resulted from an inadequate inspection and repair.NTSB ANC08CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Anchorage, AKThe pilot's inadequate recovery from a bounced landing. Contributing to the accident was a crosswind.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.NTSB CHI08CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Naperville, ILThe pilot's failure to execute a go-around. Contributing to the accident was the pilot's excessive airspeed during touchdown, which resulted in the runway overrun.NTSB DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.NTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.NTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.NTSB DEN08CA083Accident · No injuriesData collectionFinal reportBeech 76 · Cleburne, TXThe failure of the flight instructor and student pilot to extend the landing gear prior to the airplane touching down on the runway.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB DFW08LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Paducah, TXFatigue failure and separation of the propeller during cruise flight. Contributing to the accident was the owner's failure to comply with a long standing Airworthiness Directive.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB DFW08CA082Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Horseshoe Bay, TXThe certified flight instructor's delay in taking remedial action which resulted in an unsuccessful autorotation.NTSB LAX08CA075Accident · No injuriesData collectionFinal reportBeech C23 · Marble Canyon, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed during the flare. Contributing to the accident were wind gusts and a crosswind.