NTSB investigations: Lycoming 0-235 series, MT
8 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 | 1 |
|---|---|
| 1985 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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\" = 'MT' 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" = 'MT' 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 SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.NTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.NTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB SEA96LA096Accident · No injuriesLimited investigationFinal reportTilbert Baby Great Lakes · Stevensville, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the adverse wind conditions (crosswind and gusts),…NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB DEN85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalispell, MTThe acft collided with a snowbank during the landing roll following a loss of directional control. The plt reported that the left brake froze or locked up when it was applied during the landing. Inspection revealed that there was a substantial amount of ice…NTSB DEN84LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDuring a crosswind takeoff the right wing began to raise just as the plt was thinking about rotating. This startled him & he aborted the takeoff. The acft departed the left side of the rwy & flipped over on its back.