NTSB investigations: Lycoming 0-235 series, IL
13 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 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 3 |
| 1997 | 1 |
| 2001 | 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\" = 'IL' 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" = 'IL' 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 CHI01LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Mattoon, ILthe pilot's failure to maintain directional control. Factors were the crosswind, the pilots lack of total experience, and the snow covered terrain adjacent to the runway.NTSB CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.NTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.NTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.NTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.NTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…NTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…NTSB CHI86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Effingham, ILAcft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of…NTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…NTSB CHI85LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Alton, ILWhile on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy…NTSB CHI83LA416Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankfort, ILThe plt stated that he touched down with a slight angle to the rwy and went off to the left side into the grass. He misjudged the distance to the trees and the left wing contacted a tree.