NTSB investigations: Lycoming O&VO-360 series, CO
166 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.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
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 FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB FTW97LA283Accident · No injuriesLimited investigationFinal reportWonder RV-6 · Franktown, COthe pilot's failure to maintain control of the aircraft during landing roll. A factor was the uneven runway surface.NTSB FTW97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Collins, COThe pilot's failure to remove completely ice/frost from the wing, impeding the airplane's aerodynamic performance. Factors were wing contamination by frost and ice.NTSB FTW97LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28C-180 · Sterling, COimproper starting procedure used by the airport employee. Factors relating to the accident were: the inoperative starter, and failure of the pilot to seek proper assistance.NTSB FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB FTW96LA270Accident · Minor injuriesLimited investigationFinal reportAmerican AG5B · Longmont, COAn inadvertent stall spin. Factors were the pilot's intentional maneuver at an altitude insufficient to ensure a safe recovery, and overconfidence in his personal ability.NTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.NTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.NTSB FTW95LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure by the pilot to properly plan his flight and check NOTAMS prior to departure. A factor was obstructions in the runway construction zone.NTSB FTW95LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was: a misreading or misunderstanding of the NOTAMS.NTSB FTW95LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind condition.NTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.NTSB FTW95LA315Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Silvercliff, COFailure by the pilot to fuel the aircraft which resulted in fuel exhaustion. A factor was unsuitable terrain for a forced landing.NTSB FTW95LA279Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wellington, COFatigue failure of the left main landing gear (spring strut), due to the improper maintenance (grinding) by unknown maintenance personnel.NTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.NTSB FTW94LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Trinidad, COThe pilot's failure to maintain terrain clearance.NTSB FTW94LA116Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Steamboat Sprgs, COAn inadvertent stall after liftoff. Factors were an unfavorable wind and high density altitude.NTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB DEN92LA043Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COUndetermined.NTSB DEN92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Longmont, COThe pilot's failure to maintain directional control during landing. Factors were: a snow bank alongside the runway, and gusty crosswind.NTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.NTSB DEN90LA190Accident · No injuriesLimited investigationFinal reportMooney M20B · Glenwood Spring, COWrong runway selection by the pilot, resulting in an overrun and a collision with a fence during landing roll. The prevailing tailwind, runway information and markings, and the pilot's failure to use the proper touchdown point are factors.NTSB DEN89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Durango, COThe pilot failed to maintain directional control, which resulted in an inadvertent groundloop/swerve. A factor related to the accident was: the adverse wind condition.NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, CONTSB DEN88LA101Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, CONTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.NTSB DEN87LA171Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Cripple Creek, COThis acdt occurred when the plt attempted to takeoff on a 2600 ft long rwy when the density altitude was about 13,500 ft. the acft overran the rwy and collided with a highway. The plt said that the field was too high and too short and it was too hot.NTSB DEN87LA099Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Erie, COThe private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed…NTSB DEN87LA034Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Ovid, COThe plt saw smoke from engine compartment on climb to cruise. He made a forced landing after cirling the field. During landing roll, the plt applied excessive braking and the acft nosed over. There was a post accident fire.NTSB DEN86LA233Accident · No injuriesLimited investigationFinal reportCessna 177B · Broomfield, COThe plt said that he was on a high final approach for landing and just prior to touchdown, the acft was hit by a strong gust of wind. After touchdown, the plt lost control of the acft and it went off the left side of the rwy. The acft sustained substantial…NTSB DEN86FA160Accident · Serious injuriesField investigationFinal reportBeech C23 · Lamar, CODuring the takeoff climb, the plt's door came open. The pvt plt with 2 hours flying experience in C-23 acft made a close in traffic pattern to return for landing. During the turn from base leg to final the nose of the acft suddenly dropped and the acft…NTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.NTSB DEN85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Yoder, COEngine quit during cruise flight. Pilot made forced landing on dirt road during which the acft veered off the road and collided with a fence post. Fire department officials reported no evidence of fuel either in the fuel tanks or around the acft.NTSB DEN84FA188Accident · 1 fatalField investigationFinal reportRockwell 100-180 · Franktown, COThe plt attempted to takeoff downwind (wind 310 degrees @22 knots) with a density altitude calculated to be 9190 ft MSL. According to the acft manufacturer, the acft would require 2,535 ft for a ground run. Rwy 17, a grass strip used for the takeoff was 1800…NTSB DEN84FA027Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Boulder, COAccording to witnesses, the plt had made 3 attempts to land & during each attempt he overshot his approach & executed a go-around without touching down. On the fourth attempt he did touch down but appeared to be too fast & the acft skipped & bounced. After…NTSB DEN83LA196Accident · No injuriesLimited investigationFinal reportBeech C23 · Longmont, COThe student plt, a foreign national, and the instructor plt (CFI) took off from broomfield, CO & flew to Longmont, CO where they began practicing touch & go landings. After the 3rd touch & go landing, the acft was climbing at about 300 ft AGL when the student…NTSB DEN83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Erie, CODuring a second touch & go the acft ran off the side of the rwy. The plt last flew on 10/4/82 for about a 1 hr flt.NTSB DEN83LA031Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Leadville, COThe aircraft was taking off in snow with wheel pants installed. The pants filled with snow and plane pulled to left. In attempt to recover directional control and get back on the runway the aircraft hit the asphalt ridge on the edge of the runway separating…NTSB DEN82DA141Accident · Minor injuriesFinal reportAmerican AA5B · Broomfield, COThe pilot was conducting local area pleasure sightseeing flights when the aircraft failed to climb during a normal departure. She landed the aircraft in a plowed field. Investigation revealed the flight was conducted at a density altitude approximately 8,750…NTSB DEN82DA120Accident · No injuriesFinal reportAero Commander 100 · Firestone, COThe pilot had just purchased the aircraft and was ferrying it from California to Colorado. He stated that during the landing at Firestone, Colorado, the seat was too FAR aft and he was unable to apply the brakes. The aircraft ran off the end of the runway,…NTSB DEN81FTE67Accident · Minor injuriesClosedCessna 172RG · Walden, CONTSB DEN81FA049Accident · 4 fatalClosedGulf-Amer AA-5B · Crested Butte, CONTSB DEN81DTE31Accident · Minor injuriesClosedPiper PA-28 · Hugo, CONTSB DEN80FTE72Accident · Serious injuriesClosedGrum-Amer AA-5B · Boulder, CONTSB DEN80FTE66Accident · Minor injuriesClosedBede 4 · Englewood, CONTSB DEN80FTE46Accident · 2 fatalClosedBullen Bede 4 · Colorado Sprgs, CONTSB DEN80FTE43Accident · No injuriesClosedPiper PA-18 · Boulder, CO