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 NYC05CA077Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Portland, MEA loss of engine power due to the pilot's improper decision not to land and refuel resulting in fuel exhaustion.NTSB ANC05CA069Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from a sign while taxiing from landing, which resulted in an on ground collision with the sign.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB MIA05CA097Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Pensacola, FLThe pilot misjudged his altitude and distance resulting in an overrun. Also causal was the pilot's failure to execute a go-around.NTSB CHI05CA089Accident · Serious injuriesData collectionFinal reportFranz RV-6 · Howell, MIThe pilot's failure to maintain directional control during the landing rollout which resulted in the aircraft departing the runway pavement and nosing over. An additional cause was the pilot's inadequate compensation for the crosswind condition. Contributing…NTSB NYC05CA065Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sussex, NJThe pilot's failure to insure adequate obstacle clearance while conducting a practice forced landing approach, and the flight instructor's failure to take remedial action, which resulted in an in-flight collision with wires.NTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB DEN05LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Rock Springs, WYthe pilot's improper flare and recovery from a bounced landing.NTSB MIA05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bradfordville, FLThe failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.NTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.NTSB LAX05FA106Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Yucaipa, CAThe failure of the private pilot and the flight instructor to maintain adequate terrain clearance while flying in unfamiliar mountainous terrain in dark night conditions.NTSB DEN05LA061Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Spanish Fork, UTthe student's failure to maintain control of the helicopter. Contributing factors were high airspeed, high rate of descent, the instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.NTSB ANC05LA035Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Koyukuk, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an in flight collision with the snow during takeoff initial climb. A factor contributing to the accident was soft snow conditions.NTSB CHI05CA060Accident · No injuriesData collectionFinal reportCessna 172RG · Berrien Springs, MIThe pilot not maintaining airspeed leading to an excessive sink rate during a simulated emergency landing after takeoff. An additional cause was the certified flight instructor's inadequate supervision.NTSB ATL05LA047Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roseboro, NCThe overload fracture of the engine oil cooler for undetermined reasons.NTSB LAX05CA071Accident · No injuriesData collectionFinal reportRobinson R22B · Rialto, CAthe student pilot's improper use of the cyclic control during a practice autorotation, and the inadequate supervision by the certified flight instructor.NTSB ATL05FA041Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Bradley, SCThe pilot's loss of control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with trees and the ground. A factor was the dark night conditions.NTSB LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.NTSB MIA05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Pierce, FLThe failure of the pilot of the Piper 181 to apply his parking brake when stopped awaiting departure and his failure to maintain a visual lookout resulting in his airplane rolling forward and colliding with the Piper 201 which was awaiting departure.NTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.NTSB MIA05LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Milton, FLA loss of engine power due to fuel starvation as a result of the improper fuel selector position.NTSB CHI05CA039Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lee's Summit, MOThe inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. Contributing factors were the muddy terrain and the vegetation.NTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB IAD05CA018Accident · No injuriesData collectionFinal reportPiper PA 28-181 · York, PAThe pilot's inadequate weather evaluation and his decision to depart from a rain-soaked runway with strong quartering tailwinds, which resulted in a runway overrun and collision with a fence during the aborted takeoff.NTSB CHI05LA030Accident · 1 fatalLimited investigationFinal reportHedge Bede-4 · Omaha, NEThe pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.NTSB CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB ANC05CA012Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep crusted snow.NTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.NTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.NTSB CHI05LA015Accident · 1 fatalLimited investigationFinal reportStrissel Pitts S1S · Liberal, KSThe pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.NTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.NTSB CHI05CA001Accident · Serious injuriesData collectionFinal reportPiper PA-23-180 · Beatrice, NEThe loss of right engine power undetermined reasons. Factors to the accident were the loss of engine power at a low altitude and below the single engine best rate of climb airspeed (Vyse), and the unsuitable terrain encountered during the subsequent forced…NTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.NTSB NYC04FA220Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Avondale, PAThe pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power.NTSB ATL04CA196Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Charlotte, NCThe pilot's misjudgment of speed and distance resulting in an overrun and collision with trees.NTSB ANC04CA119Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Haines, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a premature liftoff and subsequent uncontrolled descent and collision with the runway.NTSB ATL04CA193Accident · No injuriesData collectionFinal reportCessna 177 · Anderson, SCThe pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.NTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.NTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.NTSB IAD04CA042Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Ocean City, NJThe pilot's deliberate delay of rotation during the takeoff roll, and his subsequent loss of directional control.NTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.NTSB NYC04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Phillipsburg, PAA loss of partial engine power for undetermined reasons.