NTSB investigations: Lycoming 0-235 series, MA
12 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
| 1984 | 2 |
|---|---|
| 1986 | 2 |
| 1987 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 2002 | 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\" = 'MA' 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" = 'MA' 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 NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.NTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.NTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.NTSB NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.NTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…NTSB NYC86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, MAThe plt rprtd he encountered a gust of wind & a wind shift during the flare to land. Subsequently, he lost directional control & the acft went off the side of the rwy, collided with a man-made pyramid of stone & rotated upside down. The plt rprtd the winds…NTSB NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…NTSB NYC84LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Hopedale, MADuring the sixth landing on the dual instructional flt, the acft veered to the left. The instructor took over the controls and applied right rudder but the acft contacted a snow bank and nosed over.NTSB NYC84LA120Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Lawrence, MAThe plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud.