NTSB investigations: Lycoming 0-235 series, WY
30 cases on aircraft whose registry engine model is Lycoming 0-235 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 per year
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1993 | 3 |
| 1995 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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\" = 'WY' 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 ('41505'))
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" = 'WY' 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 ('41505'))
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 WPR26LA201Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican AA1 · Cowley, WYThe pilot's improper landing flare and subsequent loss of directional control during landing.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB WPR20LA110Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Pinedale, WYA loss of airplane control during approach for reasons that could not be determined based on available evidence.NTSB WPR10CA437Accident · No injuriesData collectionFinal reportHolt Herbert L Long EZ · Afton, WYThe pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.NTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…NTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.NTSB SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB SEA91LA097Accident · 1 fatalLimited investigationFinal reportGrumman AA-1B · Douglas, WYAn inadvertent stall with inadequate terrain clearance. Factors include flight in mountainous terrain at an altitude where remedial action was not possible.NTSB DEN86FA149Accident · Serious injuriesField investigationFinal reportAmerican AA-1 Yankee · Cheyenne, WYDuring takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB DEN84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12-115 · Riverton, WYThe plt stated that a convair 580 had landed before him. The plt flew a normal glide slope & planned to land on the approach end of the rwy. On short final at 50 ft AGL, the acft suddenly banked 'over 90 degrees' to the left out of control. The acft then hit…NTSB DEN83LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Afton, WYThe pilot stated that he touched down on the snow covered runway and the brakes were frozen. The aircraft hit bare pavement and veered to the left. Wheel dropped off edge of runway into a snow bank. The aircraft nosed over. An interview with the pilot…NTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYNTSB DEN81DTC23Accident · No injuriesClosedPiper PA-12 · Cody, WYNTSB DEN81FTC15Accident · No injuriesClosedCessna 152 · Gillette, WYNTSB DEN80FTC21Accident · No injuriesClosedPiper PA-16 · Rock Springs, WYNTSB DEN80FTC07Accident · No injuriesClosedCessna 152 · Lander, WYNTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYNTSB DEN78DTC14Accident · Minor injuriesClosedGrum Amer AA1A · Laramie, WYNTSB DEN78DTC12Accident · No injuriesClosedCessna 152 · Cheyenne, WYNTSB DEN77FTC23Accident · Minor injuriesClosedPiper PA16 · Douglas, WYNTSB DEN76DTC13Accident · No injuriesClosedChampion 7ECA · Gillette, WYNTSB DEN75DTC18Accident · No injuriesClosedPiper PA-18 · Douglas, WYNTSB DEN74DTC10Accident · Minor injuriesClosedPiper PA-18 · Rocky Point, WYNTSB DEN70DXA10Accident · No injuriesClosedChampion 7ECA · Newcastle, WYNTSB DEN66D0274Accident · No injuriesClosedPiper PA-18 · Seely, WYNTSB UNK64X0922Accident · No injuriesClosedPiper PA22 · Lander, WY