NTSB investigations: Lycoming 0-235 series, MS
6 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
| 1986 | 1 |
|---|---|
| 1988 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2004 | 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\" = 'MS' 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" = 'MS' 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 MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.NTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.NTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…