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 ATL06LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hemmingway, SCA loss of engine power due to a total failure of the No.3 engine cylinder exhaust valve as a result of fatigue from over temperature resulting in a forced landing and collision with trees and the ground.NTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.NTSB DEN06CA075Accident · Minor injuriesData collectionFinal reportAviat A-1 · Alamosa, COthe pilot's failure to maintain aircraft control during the departure, resulting in an inadvertent stall.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB NYC06CA102Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Jeannette, PAExcessively worn brake pads and rotors, which resulted in a runway overrun and subsequent collision with a tree.NTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.NTSB CHI06CA132Accident · No injuriesData collectionFinal reportCessna 177B · Cleveland, OHThe pilot's misjudged flare which resulted in a bounced landing, and his inadequate recovery from the bounced landing that led to a hard landing.NTSB SEA06WA079Accident · No injuriesForeign investigationLake LA-4-200 · Lady Smith, CanadaNTSB MIA06LA089Accident · No injuriesLimited investigationFinal reportBeech C24R · Panama City, FLA flat tire which occurred for undetermined reasons that resulted an inadvertent loss of control during the landing roll.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB LAX06CA272Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Coalinga, CAthe pilot's misjudged landing flare, which resulted in a bounced landing, and his inadequate recovery technique that led to a hard landing.NTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.NTSB ATL06LA059Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Cullman, ALThe pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.NTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB CHI06CA098Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Holly, MIA loss of engine power due to undetermined reasons. Factors associated with the accident were the guard rail and the ditch which the airplane contacted during the forced landing.NTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.NTSB SEA06LA057Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Cottage Grove, ORFuel starvation while on approach for landing resulting in a loss of engine power, and an inadequately accomplished annual inspection. Incorrect hardware which impeded the movement of the fuel selector valve, improper fuel management and not identifying the…NTSB LAX06CA120Accident · No injuriesData collectionFinal reportCessna 177 · Carefree, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and his failure to refuel the airplane prior to the accident flight.NTSB LAX06CA119Accident · No injuriesData collectionFinal reportBeech 95 · Kingman, AZthe flight instructor's failure to perform the before landing checklist and extend the landing gear prior to touchdown. A contributing factor was the pilot's diverted attention with another airplane that had departed from the opposite runway.NTSB LAX06LA111Accident · Minor injuriesLimited investigationFinal reportBeech C23 · San Jose, CAfuel starvation due to the pilot's improper fuel system management and failure to select the proper fuel tank. A factor was the rough, uneven terrain.NTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…NTSB NYC06LA066Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Henderson, WVThe pilot's improper decision to attempt the off-airport takeoff; and his improper decision to continue the takeoff after striking a pole during the takeoff roll.NTSB MIA06LA049Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · West Palm Beach, FLA loss of engine power during descent due to an undetermined reason, which resulted in an off-airport forced landing and collision with a culvert.NTSB ATL06CA037Accident · Serious injuriesData collectionFinal reportBeech BE-76 · Hinesville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with trees.NTSB SEA06CA043Accident · No injuriesData collectionFinal reportAviat A1-A · Pine, IDThe pilot's failure to maintain clearance from terrain while maneuvering. Snow covered terrain and flat light conditions are contributing factors.NTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.NTSB ATL06FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Peachtree City, GAThe pilot's failure to maintain sufficient altitude while performing an instrument approach in instrument meteorological conditions, which resulted in an in-flight collision with trees and terrain.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB CHI06FA057Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · La Vista, NEThe non-instrument rated pilot not maintaining aircraft control and not maintaining altitude/clearance from terrain during takeoff into instrument meteorological conditions. Contributing factors were the low ceilings, night conditions present, and the pilot's…NTSB LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.NTSB MIA06CA040Accident · No injuriesData collectionFinal reportBeech BE23 · Palatka, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB NYC06LA045Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Chaplin, CTA complete loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the emergency landing.NTSB CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB LAX06CA050Accident · Minor injuriesData collectionFinal reportMooney M20A · China Lake, CAfuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.NTSB NYC06LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Lincoln Park, NJThe improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.NTSB LAX06CA052Accident · No injuriesData collectionFinal reportBeech C23 · Holbrook, AZThe student pilot's abrupt flare and failure to maintain airspeed, which resulted in a stall. The flight instructor's inadequate supervision of the flight was also causal.NTSB CHI06CA040Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marshall, MOAn in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.NTSB CHI06LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.NTSB ATL06CA016Accident · Minor injuriesData collectionFinal reportCessna 177 · New Bern, NCThe pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.NTSB CHI06LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Milwaukee, WIThe loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…NTSB ATL06CA013Accident · Minor injuriesData collectionFinal reportBeech BE-76 · Greer, SCThe pilot's misjudgment of altitude and distance which resulted in an undershoot of the runway, and the collision with trees.NTSB DFW06CA018Accident · No injuriesData collectionFinal reportPiper PA28A · Lubbock, TXThe pilot's inability to maintain directional control of the airplane while landing due to the separation of the nose landing gear tire assembly.NTSB CHI06CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Imperial, NEThe pilot not maintaining airplane control during the takeoff.NTSB CHI06LA005Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Union City, OHThe pilot's failure to perform a preflight weather evaluation which led to his inadvertent flight into instrument meteorological conditions and his spatial disorientation. The low ceilings and the dark night were contributing factors.NTSB CHI06CA002Accident · No injuriesData collectionFinal reportCreed RV-4 · Mitchell, SDThe mechanic's improper installation of the air filter assembly which resulted in foreign debris inside the carburetor. A factor associated with the accident was the rough terrain on which the airplane was landed.NTSB CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.NTSB ATL06CA002Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Pageland, SCThe pilots failure to maintain flying speed during the go-around, which resulted in a stall and the subsequent collision with trees.NTSB LAX05CA301Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Petaluma, CAa loss of engine power due to fuel exhaustion.NTSB CHI05CA265Accident · No injuriesData collectionFinal reportAviat A-1B · Drummond Island, MIThe pilot's failure to adequately compensate for the wind conditions, his failure to perform a go-around, and he flared improperly. Factors included the downdraft and the shoreline.