NTSB investigations: Lycoming 0-235 series, IL
160 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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, newest first
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'))
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'))
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 CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…NTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…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 CHI86FEE07Accident · Minor injuriesFinal reportMurphy LONG-EZE · Princeton, ILThe pilot stated that he held the aircraft in a crabbed attitude throughout the touchdown phase of landing to compensate for a crosswind condition. On touchdown the nose and main landing gear collapsed and the aircraft slid on its belly for approximately 330…NTSB CHI86FEE06Accident · Minor injuriesFinal reportFriling/Cothern Longeze · Plainfield, ILThe pilot made a steep right bank while entering the downwind leg on approach to land when the engine quit and the pilot was forced to make an emergency landing in a field short of the runway. Upon examination of the fuel system there was a lack of fuel in…NTSB CHI86FA183Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Plainfield, ILWitnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,…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 CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…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 CHI84FA402Accident · Serious injuriesField investigationFinal reportCessna 152 · Wheeling, ILWitnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student…NTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…NTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.NTSB CHI84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · East Peoria, ILAt about 10 ft AGL a 300-400 RPM decrease in power occurred. The plt elected to land straight ahead into a cut bean field. He touched down about 400 ft from the end of the rwy, traveled about 500 ft further where a large rut was struck. About 10 flt hours…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.NTSB CHI83LA384Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blue Island, ILAcft ran off side of rwy & the left wing collided with corn stalks causing the acft to spin 180 deg.NTSB CHI84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILThe student plt stated that when approaching over wires she 'powered up and ended up coming in too fast.' The acft made initial contact on the nose wheel. Subst damage to the eng mount area and the left wing.NTSB CHI83LA303Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe acft was damaged in a forced landing after a power loss during takeoff. This was a dual instructional flt. The CFI stated that the engine lost power at about 100 ft AGL & he made a forced landing straight ahead. The fixed base operatorstated that…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB CHI83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILThe student plt was on a round robin, cross-country training flt. His first landing was made on rwy 4 at the greater Kankakee arpt. During touchdown in a strong cross-wind, the acft bounced, then veered off the rwy. The acft then encountered soft terrain and…NTSB CHI83LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student pilot with his instructor on board were performing touch and go landings. After the third takeoff the engine quit at approximately 150 ft AGL. The pilot made an emergency landing between the two runways at Rockford. Examination of the engine…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…NTSB CHI82DA270Accident · Serious injuriesFinal reportAustin S.E. 5A · Bolingbrook, ILThe pilots of an Austin s.e. 5A and a folker (both ww I replica aircraft) agreed to make a photo fly-by. The pilot of the Austin took off as number one, but instead of remaining in the traffic pattern, he turned out of the pattern. The folker pilot followed…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.NTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…NTSB CHI82DEE02Accident · No injuriesClosedPiper PA-38 · Joliet, ILNTSB CHI81FA082Accident · 2 fatalClosedBellanca 7ECA · Delevan, ILNTSB CHI81DEV12Accident · No injuriesClosedCessna 152 · Urbana, ILNTSB CHI81FEE09Accident · No injuriesClosedCessna 152 · Crystal Lake, ILNTSB CHI81DEV05Accident · No injuriesClosedCessna 152 · St Francisvill, ILNTSB CHI80DEE52Accident · No injuriesClosedCessna 152 · Lockport, ILNTSB CHI80FEE50Accident · No injuriesClosedCessna 152 · Aurora, ILNTSB CHI80DEE27Accident · No injuriesClosedCessna 152 · Wheeling, ILNTSB CHI79FEV32Accident · No injuriesClosedPiper PA-38 · Jerseyville, ILNTSB CHI79DEE80Accident · No injuriesClosedCessna 152 · Dwight, ILNTSB CHI79DEE59Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILNTSB CHI79DEE45Accident · No injuriesClosedPiper PA-38 · Lockport, ILNTSB CHI79DEE41Accident · No injuriesClosedGrumman AA1C · Plainfield, ILNTSB CHI79DEE26Accident · No injuriesClosedPiper PA-38 · Frankfort, ILNTSB CHI79DEE25Accident · No injuriesClosedPiper PA-38 · Schaumburg, ILNTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILNTSB CHI78FEE49Accident · Serious injuriesClosedGrum Amer AA1-A · Hillsdale, ILNTSB CHI78FCA02Accident · Serious injuriesClosedPiper PA-16 · Columbia, ILNTSB CHI78FEE46Accident · No injuriesClosedCessna 152 · Chicago, ILNTSB CHI78FEE36Accident · No injuriesClosedCessna 152 · Belvidere, ILNTSB CHI78FEV23Accident · No injuriesClosedCessna 152 · Monmouth, ILNTSB CHI78DEV13Accident · No injuriesClosedCessna 152 · Mt Vernon, IL