OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, WI

18 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

19822026

Where

Open the map

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\" = 'WI' 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.

NTSB CHI06CA228Accident · No injuriesData collectionFinal reportPiper PA-18 · Waukesha, WIThe pilot's inadequate compensation for the crosswind and failure to maintain directional control which resulted in a groundloop. Factors included the closed runway and the crosswind condition.Aug 7, 2006 · N2396J · Substantial damageNTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.Aug 5, 2005 · N515KG · Substantial damageNTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…Feb 26, 2005 · N7325G · Substantial damageNTSB CHI02LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Appleton, WIThe pilots failure to maintain directional control of the airplane during the takeoff roll resulting in the subsequent impact with terrain.Apr 10, 2002 · N733PX · Substantial damageNTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.Jan 21, 2001 · N53118 · Substantial damageNTSB CHI98LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Stone Lake, WIthe lack of effective braking due to hydroplaning. Contributing factors to the accident were the trees off the end of the runway that made a go-around not possible and the ditch off the end of the runway.Jun 29, 1998 · N6596D · Substantial damageNTSB CHI97LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIthe pilot's inadequate compensation for wind conditions which resulted in a loss of directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions and the VASI lights.May 16, 1997 · N738LM · Substantial damageNTSB CHI96LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIthe pilot's failure to maintain directional control of the airplane during landing. A factor was the delayed go-around.Jun 27, 1996 · N1674E · Substantial damageNTSB CHI96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Middleton, WIfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty crosswind condition, the pilot's excessive lowering of flaps, and the…Apr 21, 1996 · N739BN · Substantial damageNTSB CHI93LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, WIThe student pilot's failure to maintain aircraft directional control during the takeoff ground run.Feb 25, 1993 · N3044N · Substantial damageNTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.Jul 12, 1990 · N82676 · Substantial damageNTSB CHI89FA174Accident · Serious injuriesField investigationFinal reportCessna 172P · Superior, WIThe failure of the pilot to maintain directional control.Aug 17, 1989 · N98584 · Substantial damageNTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.Mar 5, 1989 · N5315D · Substantial damageNTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…Mar 26, 1988 · N73954 · Substantial damageNTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…Jan 25, 1986 · N46675 · Substantial damageNTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…Jun 8, 1985 · N1644P · Substantial damageNTSB CHI85LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Berlin, WIThe plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable…Oct 21, 1984 · N46407 · Substantial damageNTSB CHI82DA216Accident · Minor injuriesFinal reportPiper PA-28-140 · Dodgeville, WIThe student pilot was on a cross-country flight and had made four landings that day. After visually sighting Dodgeville, the pilot cancelled her VFR flight plan with the flight service station. She reported that nobody answered her numerous calls on UNICOM…Jun 19, 1982 · N95464 · Substantial damage