NTSB investigations: Lycoming 0-320 series, MI
34 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 5 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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 ('41508')
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 ('41508')
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 CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB CHI06LA006Accident · No injuriesLimited investigationFinal reportBeech 19A · Jackson, MIThe student pilot's inadvertent porpoise during landing, which resulted in a loss of control and a collision with a sign.NTSB CHI04CA176Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake City, MIThe pilot's failure to maintain directional control during landing.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.NTSB CHI01LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · South Haven, MIThe pilot not maintaining aircraft control during the landing. Factors to the accident were the pilot not performing a go-around and the ditch.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.NTSB CHI99LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rogers City, MIThe pilot's inadequate compensation for the crosswind.NTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB CHI97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rogers City, MIthe disconnection of the tailwheel spring which resulted in the pilot's inability to maintain directional control of the airplane.NTSB CHI97LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hart, MIthe pilot's failure to maintain directional control on rollout.NTSB CHI95LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit, MIthe student pilot's failure to maintain directional control during the takeoff ground run. A factor associated with the accident was the soft terrain.NTSB CHI95LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Alma, MIthe flight instructor's inadequate remedial action during the approach to landing/landing roll. Related factors are the flight instructor's inadequate supervision, the dual student's wrong runway selection, the tailwind, and the dual student's failure to…NTSB CHI94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Dowagiac, MIwas the pilot not maintaining directional control during the takeoff ground roll. Factors related to the accident were the icy, snow covered runway and poor preflight planning/preparation.NTSB CHI93LA336Accident · No injuriesLimited investigationFinal reportCessna 172M · Adrian, MIan excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.NTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.NTSB CHI90LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harbor Springs, MIThe student pilot's failure to maintian adequate directional control of the aircraft. The unfavorable wind was a related factor.NTSB CHI88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sault Ste Marie, MIDuring taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…NTSB CHI88LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-140D · Whittemore, MIWhile landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock.NTSB CHI88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake City, MIThe student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…NTSB CHI87LA043Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Marquette, MIWhile on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure.NTSB CHI85LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Pontiac, MIThe acft nosed over after a loss of control during landing roll portion of a touch & go lndg. The low flt time student plt was practicing endings solo when control was lost and the acft left the rwy. The plt reported that he was resetting the carb heat &…NTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.NTSB CHI84LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Port Huron, MIThe plt stated that shortly after touchdown several deer came out of the nearby woods & stopped on the left side of the rwy. He attempted to slow the acft down while staying on the right side of the rwy but went off the rwy & collided with a raised concrete…NTSB CHI83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Berrien Springs, MIThe plt reported that when he landed, the wind was variable from west to north at 12 to 15 KTS. He stated that after touchdown, he held the tail up in the slip stream. Reportedly, directional control was good until the acft entered an area that was not…NTSB CHI83LA283Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Alma, MIThe acft collided with the VASI lights during landing. The pilot was landing on rwy 27 with winds from 210 degrees at 12 KTS. He reported gusty winds but gave no estimated velocity of the gusts. He said he touched down on the right main gear with the left…NTSB CHI83LA259Accident · No injuriesLimited investigationFinal reportCessna 172 · Gaylord, MIThe plt initially departed grayling, MI with intermediate stops in alba, Gaylord, alba again, & finally terminating at grayling. The plt stated he landed short at alba. He also stated that while practicing landings at Gaylord he ran off the side of the rwy.…NTSB CHI83LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ironwood, MIThe acft drifted to the right on the rwy during a crosswind landing and collided with a rwy light.NTSB CHI83LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Hope, MIThe pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The…NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…NTSB CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…