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.
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" 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 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.NTSB 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.NTSB 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)…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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,…NTSB 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…NTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, CONTSB DEN81FA063Accident · 3 fatalClosedCessna TR182 · 17nne Durango, CONTSB DEN79DTE43Accident · No injuriesClosedPiper PA-25 · Eads, CONTSB DEN79FTE24Accident · Minor injuriesClosedPiper PA-24 · Silver Cliff, CONTSB DEN78FTE53Accident · No injuriesClosedPiper PA-25 · Yuma, CONTSB DEN78FTE06Accident · Serious injuriesClosedPiper PA-24 · Lake City, CONTSB DEN77FA056Accident · Minor injuriesClosedPiper PA-32T · Colorado Spgs, CONTSB DEN77FTE26Accident · No injuriesClosedPiper PA-24 · Wray, CONTSB DEN77FA026Accident · 2 fatalClosedPiper PA-24 · Broomfield, CONTSB DEN77FTE11Accident · No injuriesClosedPiper PA-28 · Pueblo, CONTSB DEN76FTE96Accident · No injuriesClosedPiper PA-24 · Lamar, CONTSB DEN76ATE13Accident · No injuriesClosedPiper PA-24 · Steamboat Spgs, CONTSB DEN75DTE57Accident · No injuriesClosedPiper PA-28 · Creede, CONTSB DEN75FTE52Accident · No injuriesClosedPiper PA-23 · Broomfield, CONTSB DEN75DTE37Accident · No injuriesClosedPiper PA-24 · Limon, CONTSB DEN75AD001Accident · 1 fatalClosedPiper PA-24 · Steamboat Sp, CONTSB DEN74DTE88Accident · No injuriesClosedPiper PA-24 · Center, CONTSB DEN74FTE25Accident · Serious injuriesClosedPiper PA-32 · Aspen, CONTSB DEN74FTE03Accident · No injuriesClosedPiper PA-24 · Littleton, CONTSB DEN73FTE66Accident · Serious injuriesClosedPiper PA-32 · Aurora, CONTSB DEN73FTE44Accident · No injuriesClosedPiper PA-32 · Broomfield, CONTSB DEN73DTE22Accident · No injuriesClosedPiper PA-25 · Eckley, CONTSB DEN73DTE12Accident · No injuriesClosedPiper PA-25 · Rocky Ford, CONTSB DEN73FTE02Accident · No injuriesClosedPiper PA-25 · Mead, CONTSB DEN72AD059Accident · 6 fatalClosedPiper PA-32 · Nucla, CONTSB DEN81FA070Accident · 1 fatalClosedPiper PA-23 · Estes Park, CONTSB DEN72FTE65Accident · No injuriesClosedPiper PA-25 · Merino, CONTSB DEN72FTE31Accident · No injuriesClosedPiper PA-28 · Littleton, CONTSB DEN72FTE11Accident · No injuriesClosedPiper PA-32 · Leadville, CONTSB DEN72DTE08Accident · No injuriesClosedPiper PA-25 · Blanca, CONTSB DEN71DTE12Accident · No injuriesClosedPiper PA-25 · Breen, CONTSB DEN71FTE10Accident · Serious injuriesClosedCallair A-9 · Firestone, CONTSB DEN71FXD44Accident · Minor injuriesClosedPiper PA-32 · Littleton, CONTSB DEN71FXD38Accident · No injuriesClosedPiper PA-24 · Aurora, CONTSB DEN70DXD22Accident · No injuriesClosedPiper PA-24 · Colorado Spg, CONTSB DEN70D0060Accident · No injuriesClosedPiper PA-24 · Lake City, CONTSB DEN70F0002Accident · No injuriesClosedPiper PA-23 · Denver, CO