NTSB investigations: Lycoming O&VO-360 series, 2004
78 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 year(c.\"eventDate\") = 2004
AND 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 year(c."eventDate") = 2004
AND 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 LAX04FA205Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Julian, CAThe incorrect use of an abbreviated callsign by the TRACON sector radar controller to issue a descent clearance to N434PA and the sector controllers failure to detect that the clearance had been read back with the full callsign by the pilot of N304PA. Also…NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.NTSB ATL04CA108Accident · No injuriesData collectionFinal reportSawyer Skybolt · Philadelphia, MSThe pilot's failure to see and avoid a guy wire which resulted in an in-flight collision.NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB LAX04LA297Accident · No injuriesLimited investigationFinal reportAviat A-1A · Visalia, CAthe pilot's failure to maintain an adequate airspeed on final approach, which resulted in an inadvertent stall and a hard landing.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI04CA106Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Columbia, MOThe pilot inadvertently became lost and over flew his destination in cruise flight and selected an unsuitable landing area for his precautionary landing. Factors were the rough/uneven terrain, the barbed wire fence, and the fence post encountered during the…NTSB LAX04LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · San Jose, CAthe pilot's encounter with jet blast effects. Factors in the accident were the pilots' inadequate situational awareness of the potential for the jet blast encounter after hearing the Global Express airplane on the frequency call ready for taxi, and, the…NTSB CHI04LA100Accident · 1 fatalLimited investigationFinal reportChristen A-1 · Curtis, NEThe pilot's ostentatious display of a "hammerhead stall" during intial climb and his failure to maintain clearance from terrain. A factor was the post impact fire.NTSB NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.NTSB DEN04LA065Accident · No injuriesLimited investigationFinal reportMooney M20C · Clovis, NMthe pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…NTSB LAX04LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, NVthe pilot's premature flare and failure to maintain adequate airspeed resulted in an inadvertent stall and a hard landing, which collapsed the landing gear.NTSB LAX04CA146Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAthe student pilot's improper use of the cyclic control and the certified flight instructor's inadequate supervision, which resulted in a rollover.NTSB LAX04LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mariposa, CAThe total loss of engine power for undetermined reasons.NTSB CHI04FA069Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Rich Hill, MOSpatial disorientation experienced by the non-instrument rated pilot due to a lack of visual references and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's intentional flight into adverse weather conditions,…NTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB ATL04FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Alma, GAThe pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.NTSB LAX04CA118Accident · No injuriesData collectionFinal reportMooney M20C · Mesa, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a collision with an airport sign.NTSB LAX04LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palmdale, CAloss of engine power for undetermined reasons.NTSB LAX04CA107Accident · No injuriesData collectionFinal reportPiper PA-28-180C · Minden, NVThe student pilot's failure to maintain directional control during the landing roll.NTSB SEA04LA033Accident · No injuriesLimited investigationFinal reportCessna 172RG · Enumclaw, WAA loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.NTSB FTW04LA060Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encino, TXThe pilot's failure to maintain clearance from a tree while hovering.NTSB DEN04FA038Accident · 2 fatalField investigationFinal reportBeech B95 · Cedar City, UTthe pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.NTSB FTW04WA154Accident · No injuriesForeign investigationMooney M20C · Mazamitla, MexicoNTSB LAX04CA088Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Groveland, CAthe pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.NTSB FTW04FA055Accident · 1 fatalField investigationFinal reportMooney M20C · Amarillo, TXThe pilot's incapacitation due to chest pains, resulting in a loss of control.