NTSB investigations: Lycoming 0-235 series, IN
11 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 |
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 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\" = 'IN' 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" = 'IN' 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 CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.NTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.NTSB CHI95DEX01Accident · Minor injuriesFinal reportCraig Long E-Z · Shelbyville, INthe pilot's improper recovery from a bounced landing which resulted in the nose wheel striking the runway first. A factor associated with the accident was excessive airspeed during the landing.NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.NTSB CHI85LA322Accident · No injuriesLimited investigationFinal reportCessna 152II · Indianapolis, INThe student plt lost directional control on rollout following a bounced landing. The CFI attempted to regain control but was not able to before the acft departed the rwy and nosed over.NTSB CHI85LA002Accident · Minor injuriesLimited investigationFinal reportBrewer Corsair · Ft. Wayne, INAfter touchdown and an initial rollout of aprx 480 ft, the acft began veering to the right. The acft departed the right side of the rwy and contacted a plowed trench, 29 ft from the rwy, where it nosed over.