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 CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.NTSB MIA01LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bennettsville, SCThe pilot failure to obtain the proper touchdown point on the runway resulting in the airplane landing long, over running the runway, colliding with a telephone pole separating the right wing, and coming to rest in the parking lot of a restaurant.NTSB LAX01FA308Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lytle Creek, CAThe pilot's inadequate decision to fly into an area of rising terrain.NTSB LAX01FA199Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe student pilot's selection of a takeoff runway conducive to a tailwind weather condition and his failure to maintain airspeed and his inadvertent stall during takeoff initial climb. Factors in the accident were the partial loss engine power resulting from…NTSB ANC01LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Minto, AKThe pilot's selection of unsuitable terrain for takeoff, and an excessive descent rate resulting in a hard landing during an aborted takeoff. Factors in the accident were a collision of the airplane's float assembly with an unknown object, and the pilot's…NTSB FTW01LA126Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Tulsa, OKthe dual student pilot's failure to maintain clearance from the hangar while taxing.NTSB ATL01LA058Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Brooksville, FLThe fatigue failure of the left main landing gear strut that resulted in collapse of the landing gear.NTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB DEN01FA096Accident · 2 fatalField investigationFinal reportBeech 76 · Gunnison, COintentional buzzing by both pilots and their failure to maintain clearance with transmission wires. A contributing factor was the sun glare.NTSB LAX01LA170Accident · No injuriesLimited investigationFinal reportAviat A-1B · Apex, NVThe pilot's failure to maintain directional control during landing rollout in a gusty and crosswind condition.NTSB FTW01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Washington, OKthe in-flight fire for an undetermined reason, which resulted in a forced landing. A contributory factor was the lack of suitable terrain for the forced landing.NTSB LAX01LA163Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Maria, CAA stall/mush inadvertently encountered by the pilot-in-command. Failure to maintain adequate airspeed for flight and inadequate remedial action contributed to the accident.NTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…NTSB CHI01LA120Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Culver, INthe wrong runway selected by the pilot which resulted in a tailwind landing condition. Factors to the accident were the tailwind, the wet runway, the reduced braking action, and the airport perimeter fence.NTSB SEA01LA074Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hagerman, IDThe pilot's failure to maintain proper runway alignment during an attempted go-around, resulting in an inflight collision with a wind sock. Factors were a short runway/landing area condition, the pilot's excessive airspeed on final approach, and the wind sock.NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.NTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.NTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.NTSB ATL01LA046Accident · 1 fatalLimited investigationFinal reportJacques J. Mistrot Skybolt · Smithfield, NCThe pilot's failure to maintain control of the airplane during climb out that resulted in the in-flight collision with the ground. A factor was the physical impairment.NTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.NTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.NTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.NTSB LAX01LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Stanford, CAFailure of company maintenance personnel to properly install and safety wire the oil filter, which subsequently lead to a loss of engine power.NTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…NTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…NTSB SEA01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · North Bend, ORThe pilot's failure to maintain clearance from the delivery truck while taxing. The pilot being distracted is a factor.NTSB MIA01FA075Accident · 2 fatalField investigationFinal reportBrantly B-2B · Archer, FLThe flight crew's loss of control for undermined reasons.NTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.NTSB IAD01LA033Accident · No injuriesLimited investigationFinal reportMooney M20C · Peckville, PAloss of engine power for undetermined reasons.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB MIA01LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Milton, FLa loss of right engine power due to chaffed and frayed wiring on the right and left magnetos on the right engine resulting in a forced landing, an inadvertent stall, and subsequent impact with the ground.NTSB MIA01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20C · Jacksonville, FLThe failure of maintenance personnel to properly reconnect the aircraft's elevator control system, resulting in an in-flight disconnection of the elevator control and jamming of the rudder control during climb, the subsequent in-flight loss of control, and…NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB FTW01LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sunnyvale, TXThe flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.NTSB LAX01LA058Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot-in-command's inadequate supervision of the second pilot and delay taking control of the aircraft and implementing remedial action. A factor in the accident was the second pilot's interference with the pilot-in-command's operation of the collective…NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB NYC01LA039Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Montauk, NYThe pilot's failure to maintain runway alignment during touchdown and rollout. Factors in the accident were the pilot's inadequate crosswind compensation, and inadequate flare.NTSB MIA01LA025Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · St. Marys, GAThe pilot's failure to maintain directional control during landing, resulting in a sideward skid, a collapsed main landing gear strut, and wing strike.NTSB NYC01LA029Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Prosperity, PAThe failure of the dual magneto ignition system points to open.NTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.NTSB FTW01FA015Accident · 2 fatalField investigationFinal reportBeech BE-76 · Tulsa, OKthe instructor pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around, which resulted in his loss of control of the airplane. Contributory factors were the engine fire, the pilot's failure to follow the…NTSB IAD01WA011Accident · No injuriesForeign investigationRobinson R 22 · Wallforf, GermanyNTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.