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 WPR11CA425Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Gerlach, NVThe pilot’s decision to land at an unknown off-airport location.NTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.NTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.NTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.NTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB ANC11LA099Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Unalaska, AKA loss of engine power in cruise flight for undetermined reasons.NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB CEN11LA555Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Millsap, TXA sudden loss of engine thrust due to the separation of a propeller blade in cruise flight due to high cycle fatigue.NTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.NTSB ERA11FA422Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Berne, NYThe pilot's continued visual flight into instrument meteorological conditions, which resulted in a collision with trees and rising terrain while attempting to reverse course. Contributing to the accident was the pilot's failure to obtain a preflight weather…NTSB WPR11CA357Accident · No injuriesData collectionFinal reportCessna 175 · Greer, AZThe pilot’s improper flare and inadequate recovery from a bounced landing which resulted in a nose gear collapse.NTSB WPR11FA335Accident · 3 fatalField investigationFinal reportMooney M20C · Grace, IDThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.NTSB CEN11LA451Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · New Carlisle, OHThe pilot's failure to conduct a go-around once he recognized he was going to land long on the runway.NTSB CEN11CA461Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Amarillo, TXThe pilot's failure to lower the landing gear prior to landing.NTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.NTSB CEN11LA430Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Barron, WIThe loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.NTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.NTSB CEN11CA377Accident · Minor injuriesData collectionFinal reportKamtz Russell H RV-6A · Dexter, NMThe pilot's failure to maintain clearance from a fence while landing at night.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.NTSB ERA11LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ERA11CA271Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe student pilot’s failure to maintain directional control during landing and the pilot’s inadequate remedial action, which resulted in a runway excursion.NTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.NTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.NTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.NTSB ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB ERA11LA154Accident · No injuriesLimited investigationFinal reportCessna 177B · Reading, PAInadequate maintenance inspection of the airplane which resulted in a shift of the shock mounted portion of the pilot's instrument panel, causing an interference of the pitch control during takeoff.NTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.NTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB CEN11LA086Accident · 1 fatalLimited investigationFinal reportMaule M-5-180C · Emory, TXThe pilot's loss of control and failure to attain/maintain adequate airspeed during an attempted go-around after a hard bounced landing, resulting in an aerodynamic stall. Contributing to the accident was the pilot’s recent minimal experience in airplane…NTSB WPR11CA065Accident · No injuriesData collectionFinal reportAviat A-1B · North Bend, WAThe pilot's failure to predetermine the depth of the snow on the runway.NTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.NTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.NTSB CEN11FA079Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Norfolk, NEThe pilot’s decision to continue the flight into instrumental meteorological conditions which resulted in a collision with a tree.NTSB ERA11GA066Accident · 3 fatalFinal reportCessna M337B · Avon Park, FLThe pilot's inadvertent encounter with an unexpected intense rain shower with severe turbulence at night.NTSB CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB ERA10CA460Accident · No injuriesData collectionFinal reportCessna 177B · Ocean City, MDThe pilot's improper recovery from a bounced downwind landing.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.