NTSB investigations: Lycoming 0-235 series, CO
9 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 2 |
|---|---|
| 1985 | 2 |
| 1988 | 2 |
| 1994 | 1 |
| 1998 | 1 |
| 2001 | 1 |
Where
Latest 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\" = '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 ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 DEN01LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Junction, COthe student pilot's failure to recover from a bounced landing, which resulted in porpoising and subsequently a nose over.NTSB FTW98LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COthe student pilot's improper use of the rudder controls, which resulted in loss of directional control, a ground swerve, an encounter with soft terrain, and a nose over. The soft terrain was a related factor.NTSB FTW95LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder, COThe pilot's loss of directional control.NTSB DEN88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aurora, COThis was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The…NTSB DEN88LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…NTSB DEN86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 II · Greeley, COAccording to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention.NTSB DEN85LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe student plt lost directional control of the acft when pwr was added to takeoff during a touch and go landing. The plt stated the acft began to veer right when pwr was added and he applied 'too much right rudder' to correct. The acft veered left and…NTSB DEN84LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, COAfter returning from a maintenance test flt, the plt made a normal apch to land on a snow covered rwy. According to the plt & his passenger, the acft touched down along the right side of the rwy in snow. The plane then veered to the right & nosed over. No…NTSB DEN83LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe aircraft piloted by a solo student ran off the runway and nosed over in a snow bank during landing. The pilot was practicing short field landings. The accident occurred during the first touch and go. The landing was good and the pilotretracted flaps to 10…