NTSB investigations: Lycoming 0-235 series, MI
17 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Hard landing”. 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 | 3 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 3 |
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\" = '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')
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\" = 200))
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')
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" = 200))
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 CHI03LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe student pilot's inadequate recovery from the bounced landing. Factors contributing to the accident were the variable crosswind, the misjudged flare that resulted in the bounced landing and the subsequent collapse of the nose landing gear.NTSB CHI03LA233Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Brooklyn, MIThe pilot's failure to attain the proper touchdown point, and his failure to maintain control of the airplane.NTSB CHI03LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Traverse City, MIThe student pilot's improper rerecovery from a bounced landing and his improper flare. Factors were the gusting crosswinds, the misjudged flare and the collapse of the nose landing gear.NTSB CHI96LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIthe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. Factors associated with the accident were the misjudged landing flare and the raised taxiway edge which the airplane contacted.NTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.NTSB CHI92LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · East Tawas, MIThe pilot's failure to adequately compensate for the wind conditions and failure to properly flare the airplane. Contributing to the accident was the crosswind condition.NTSB CHI91LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIRecovery from a bounced landing was improper by the pilot. Factors related to the accident were lack of recent experience by the pilot.NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MINTSB CHI87LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIOn touchdown the aircraft ballooned and bounced up about 5-7 feet off the runway. The aircraft then landed on the nose wheel and the prop struck the ground.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 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 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 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.