NTSB investigations: Lycoming 0-540 series, CO

123 cases on aircraft whose registry engine model is Lycoming 0-540 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 ('41532'))
  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.

NTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.Sep 11, 1990 · N9571P · Substantial damageNTSB DEN90LA148Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Broomfield, COThe failure of the pilot to extend the landing gear for landing. Contributing factors were the pilot diverting his attention from the task at hand and failure to use a checklist.Jun 29, 1990 · N6391P · Substantial damageNTSB DEN89LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Dove Creek, COImproper planning/decision by the pilot. Factors related to the accident were: high density altitude, uphill sloping runway, failure of the pilot to follow the checklist and use all of the available runway, and the rising terrain and obstruction (power line)…Aug 19, 1989 · N56654 · Substantial damageNTSB DEN89LA133Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COFailure of the pilot to follow warnings provided by a NOTAM & flags on the taxiway. Factors related to the accident were: darkness and the ditch.May 24, 1989 · N999HP · Substantial damageNTSB DEN89LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COThe student plt was practicing a touch and go landing. During a turn to final, the plt heard an acft report final for a straight in. He said he became distracted and failed to extend the landing gear. The acft landed with the gear up and slid 500 feet, coming…Dec 18, 1988 · N6843P · Substantial damageNTSB DEN88LA116Accident · Serious injuriesLimited investigationFinal reportCessna TR-182RG · Englewood, COThe CFI, a private rated dual student, and one passenger were preparing to depart on a training flight. The CFI attempted to hand prop the airplane when the battery was found to be inoperative. During the attempt, the CFI was struck in the back of the head.Jun 1, 1988 · N999HP · No damageNTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…Jan 28, 1988 · N1246T · Substantial damageNTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…Jul 11, 1987 · N7858P · DestroyedNTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…Jul 26, 1986 · N4346L · 2 aircraft · DestroyedNTSB DEN85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-25-260-C · Ordway, COThe airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the…Jun 1, 1985 · N4926Y · DestroyedNTSB DEN84FA019Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Kim, COThe acft collided with the ground in a wing down nose low attitude. The plt had been advised that VFR flt was not recommended for his route of flt. The non-instrument rated plt went anyway and encountered weather. In maneuvering to get below or out of the…Oct 8, 1983 · N2174M · DestroyedNTSB DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…Jul 27, 1983 · N9378W · DestroyedNTSB DEN82DA080Accident · No injuriesFinal reportPiper PA-23 · Erie, COThe aircraft lost power during takeoff climb and was landed straight ahead resulting in substantial damage. The fuel selector valve was hard to move and during tests moving it caused the engines to quit. Piper AD 80-18-10 warns that scott manufactured…May 1, 1982 · N13845 · Substantial damageNTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, COOct 3, 1981 · N3900W · Substantial damageNTSB DEN81FA063Accident · 3 fatalClosedCessna TR182 · 17nne Durango, COAug 31, 1981 · N736KV · DestroyedNTSB DEN79DTE43Accident · No injuriesClosedPiper PA-25 · Eads, COJun 12, 1979 · N6496Z · Substantial damageNTSB DEN79FTE24Accident · Minor injuriesClosedPiper PA-24 · Silver Cliff, COFeb 10, 1979 · N6428P · DestroyedNTSB DEN78FTE53Accident · No injuriesClosedPiper PA-25 · Yuma, COMay 10, 1978 · N8605L · Substantial damageNTSB DEN78FTE06Accident · Serious injuriesClosedPiper PA-24 · Lake City, COOct 25, 1977 · N7083P · DestroyedNTSB DEN77FA056Accident · Minor injuriesClosedPiper PA-32T · Colorado Spgs, COAug 5, 1977 · N4864S · Substantial damageNTSB DEN77FTE26Accident · No injuriesClosedPiper PA-24 · Wray, COMar 13, 1977 · N6212P · Substantial damageNTSB DEN77FA026Accident · 2 fatalClosedPiper PA-24 · Broomfield, COFeb 26, 1977 · N7237P · DestroyedNTSB DEN77FTE11Accident · No injuriesClosedPiper PA-28 · Pueblo, CODec 18, 1976 · N44558 · Substantial damageNTSB DEN76FTE96Accident · No injuriesClosedPiper PA-24 · Lamar, COSep 17, 1976 · N7951P · Substantial damageNTSB DEN76ATE13Accident · No injuriesClosedPiper PA-24 · Steamboat Spgs, COAug 7, 1975 · N5950P · Substantial damageNTSB DEN75DTE57Accident · No injuriesClosedPiper PA-28 · Creede, COMar 21, 1975 · N32452 · Substantial damageNTSB DEN75FTE52Accident · No injuriesClosedPiper PA-23 · Broomfield, COFeb 18, 1975 · N4519P · Substantial damageNTSB DEN75DTE37Accident · No injuriesClosedPiper PA-24 · Limon, CODec 9, 1974 · N7136P · Substantial damageNTSB DEN75AD001Accident · 1 fatalClosedPiper PA-24 · Steamboat Sp, COJul 16, 1974 · N6881P · DestroyedNTSB DEN74DTE88Accident · No injuriesClosedPiper PA-24 · Center, COJun 21, 1974 · N5242P · Substantial damageNTSB DEN74FTE25Accident · Serious injuriesClosedPiper PA-32 · Aspen, COOct 7, 1973 · N3234W · Substantial damageNTSB DEN74FTE03Accident · No injuriesClosedPiper PA-24 · Littleton, COJul 6, 1973 · N7744P · Substantial damageNTSB DEN73FTE66Accident · Serious injuriesClosedPiper PA-32 · Aurora, COMar 14, 1973 · N3234W · Minor damageNTSB DEN73FTE44Accident · No injuriesClosedPiper PA-32 · Broomfield, COJan 12, 1973 · N3700W · Substantial damageNTSB DEN73DTE22Accident · No injuriesClosedPiper PA-25 · Eckley, COAug 22, 1972 · N7705Z · Substantial damageNTSB DEN73DTE12Accident · No injuriesClosedPiper PA-25 · Rocky Ford, COAug 2, 1972 · N8825L · Substantial damageNTSB DEN73FTE02Accident · No injuriesClosedPiper PA-25 · Mead, COJul 7, 1972 · N4999Y · Substantial damageNTSB DEN72AD059Accident · 6 fatalClosedPiper PA-32 · Nucla, COJun 8, 1972 · N3681W · DestroyedNTSB DEN81FA070Accident · 1 fatalClosedPiper PA-23 · Estes Park, COMay 9, 1972 · N4909P · DestroyedNTSB DEN72FTE65Accident · No injuriesClosedPiper PA-25 · Merino, COApr 5, 1972 · N7712Z · Substantial damageNTSB DEN72FTE31Accident · No injuriesClosedPiper PA-28 · Littleton, COSep 11, 1971 · N9162W · Substantial damageNTSB DEN72FTE11Accident · No injuriesClosedPiper PA-32 · Leadville, COAug 7, 1971 · N3649W · Substantial damageNTSB DEN72DTE08Accident · No injuriesClosedPiper PA-25 · Blanca, COAug 6, 1971 · N7191Z · Substantial damageNTSB DEN71DTE12Accident · No injuriesClosedPiper PA-25 · Breen, COJun 11, 1971 · N6629Z · Substantial damageNTSB DEN71FTE10Accident · Serious injuriesClosedCallair A-9 · Firestone, COJun 5, 1971 · N9648Z · DestroyedNTSB DEN71FXD44Accident · Minor injuriesClosedPiper PA-32 · Littleton, COJan 4, 1971 · N3935W · Substantial damageNTSB DEN71FXD38Accident · No injuriesClosedPiper PA-24 · Aurora, CONov 22, 1970 · N7864P · Substantial damageNTSB DEN70DXD22Accident · No injuriesClosedPiper PA-24 · Colorado Spg, COApr 4, 1970 · N5221P · Substantial damageNTSB DEN70D0060Accident · No injuriesClosedPiper PA-24 · Lake City, COJul 4, 1969 · N7335P · Substantial damageNTSB DEN70F0002Accident · No injuriesClosedPiper PA-23 · Denver, COFeb 10, 1969 · N5293Y · Substantial damage