NTSB investigations: Lycoming 0-235 series, MI
149 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\" = 'MI' 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" = 'MI' 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 CHI87LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jenison, MIOn takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side…NTSB CHI87DEM08Accident · No injuriesFinal reportCessna 152 · Plainwell, MIThe aircraft experienced a total power failure and the pilot chose a wheat field on rising terrain for a forced landing. The field turned out to be rough and uneven. When the aircraft touched down, the nose gear failed and the aircraft nosed over. Subsequent…NTSB CHI87LA123Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Gobles, MIDuring the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to…NTSB CHI87LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marine City, MIDuring a solo training flight, the student pilot landed too fast. The aircraft porpoised, the nose wheel collapsed and the plane nosed over.NTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…NTSB CHI86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fraser, MIAircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.NTSB CHI86LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIThe acft struck wires during the recovery phase of a simulated forced landing apch. The plt continued the flt for aprx 1 hr after the wire strike and landed without incident. Examination of the acft revealed replacement of the right wing was needed.NTSB CHI85LA343Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlette, MIThe student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually…NTSB CHI85LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Almont, MIThe student plt stated that during touchdown the acft bounced back into the air. On the second touchdown, the acft swerved to the left and departed the rwy. It then rolled until the left wing struck a small tree, causing substantial damage to that wing. The…NTSB CHI84LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Marine City, MIThe student plt reached down to adjust the trim after touchdown & the acft became airborne again. The acft then bounced hard, 2 times, & the student made a go-around. He did not realize the extent of the nose gear damage until after the next landing. During…NTSB CHI84LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · South Branch, MIThe student plt was on a solo x-country flt. He reported that when he landed, the acft bounced twice. After the 2nd bounce, the nose gear collapsed & the acft nosed over. The plt reported that the grass strip was rough & not well maintained & that the ground…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…NTSB CHI83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe acft bounced during landing and collapsed the nose gear. The student pilot was practicing landings and had been successful on 4. The fifth in the series was intended to be the last one. The pilots recommendation for prevention was to go around as soon as…NTSB CHI83LA307Accident · No injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Leslie, MIThe acft landed hard and bounced. The acft drifted left off the rwy and nosed over in a plowed area. The landing was on rwy 18 and the wind was from 270 degrees at 8 KTS. The student pilot said he needed more dual time in crosswind landings. He had 11 hours…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.NTSB CHI82IA364Incident · No injuriesIncident investigationFinal reportCessna 152 · Pontiac, MIThe pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was…NTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…NTSB CHI82DA116Accident · No injuriesFinal reportCessna 152 · Pontiac, MIWhile the student pilot was on his fifth touch and go pattern, the plane veered to the left after touchdown. The left main gear then encountered snow and pulled the aircraft further left into a snowbank. The student claimed that the owners had advised him to…NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…NTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…NTSB CHI82DEC07Accident · No injuriesClosedCessna 152 · Howell, MINTSB CHI81DEM26Accident · No injuriesClosedCessna 152 · S.Manitou Is, MINTSB CHI81FEM27Accident · Minor injuriesClosedPiper PA-22 · Alma, MINTSB CHI81FEC27Accident · No injuriesClosedCessna 152 · Almont, MINTSB CHI81FEM17Accident · No injuriesClosedCessna 152 · Shepard, MINTSB CHI81FEM16Accident · No injuriesClosedCessna 152 · Portland, MINTSB CHI81FEC23Accident · Minor injuriesClosedCessna 152 · Hadley, MINTSB CHI81FEM08Accident · No injuriesClosedCessna 152 · Lowell, MINTSB CHI81DEC08Accident · No injuriesClosedCessna 152A · Salem, MINTSB CHI80FEM36Accident · Serious injuriesClosedGrum-Amer AA-1 · Midland, MINTSB CHI80FET19Accident · No injuriesClosedBellanca 7ECA · Berrien Sprgs, MINTSB CHI80FET08Accident · No injuriesClosedCessna 152 · Three Oaks, MINTSB CHI80FEC08Accident · No injuriesClosedCessna 152 · Frasher, MINTSB CHI80FEC02Accident · No injuriesClosedCessna 152 · Jackson, MINTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MINTSB CHI79FEC57Accident · 2 fatalClosedBreezy RLU-1 · Frazer, MINTSB CHI79DEC53Accident · No injuriesClosedCessna 152 · Detroit, MINTSB CHI79DEM36Accident · No injuriesClosedGrumman AA1B · Harrisville, MINTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MINTSB CHI79FEC34Accident · No injuriesClosedBellanca 7ECA · Owossow, MINTSB CHI79FEC24Accident · No injuriesClosedCessna 152 · Fraser, MINTSB CHI79DET20Accident · No injuriesClosedCessna 152 · Berrien Sprgs, MINTSB CHI79DEC19Accident · No injuriesClosedPiper PA-38 · Lapeer, MINTSB CHI78FEC55Accident · No injuriesClosedCessna 152 · Plymouth, MINTSB CHI78FEC51Accident · No injuriesClosedCessna 152 · Clawson, MI