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 “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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2004 | 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\" = '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\" = 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" = '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" = 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 CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.NTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.NTSB CHI96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIFailure of the student pilot to maintain directional control of the airplane during the takeoff roll. The snowbank was a related factor.NTSB CHI95LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Owosso, MIthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the snow bank.NTSB CHI94LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainwell, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of total experience.NTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.NTSB CHI93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mason, MIThe pilot-in-command's failure to maintain directional control.NTSB CHI91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIDirectional control not maintained by the PIC.NTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…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 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 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 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 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…