NTSB investigations: Lycoming 0-320 series, IL

465 cases on aircraft whose registry engine model is Lycoming 0-320 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\" = 'IL' 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'))
  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 CHI94LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kankakee, ILThe pilot's poor preflight planning preparation by the improper loading of the airplane.Jul 16, 1994 · N7079R · Substantial damageNTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.Mar 23, 1994 · N97650 · Substantial damageNTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.Dec 26, 1992 · N4328D · Substantial damageNTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.Sep 23, 1992 · N2484Y · Substantial damageNTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.Sep 17, 1992 · N30076 · DestroyedNTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.Sep 13, 1992 · N738KX · Substantial damageNTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.Aug 25, 1992 · N5544J · Substantial damageNTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.Jun 14, 1992 · N56311 · Substantial damageNTSB CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…Mar 8, 1992 · N242CF · Substantial damageNTSB CHI91DEV05Accident · No injuriesFinal reportUllman Vari Viggen · Greenville, ILImproper maintenance installation of the propeller.Sep 29, 1991 · N22VV · Substantial damageNTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.Aug 23, 1991 · N8479F · Substantial damageNTSB CHI91LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILInadequate compensation for wind conditions and directional control was not maintained by the pilot. Factors related to the accident were a gusty crosswind landing environment and a ditch.Aug 2, 1991 · N97650 · Substantial damageNTSB CHI91LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILDirectional control was not maintained by the cfi/pic. Factors related to the accident were a gusty cross wind and an airport facility, VASI light.Jul 20, 1991 · N99515 · Substantial damageNTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.Jun 5, 1991 · N91MG · Substantial damageNTSB CHI91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grayslake, ILThe instructor's inadequate compensation for wind conditions. Factors were the wind gusts and the instructor's failure to maintain airspeed.Apr 20, 1991 · N4VT · Substantial damageNTSB CHI91LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe mechanic's not understanding the identifying marks on the replacement part. A factor in the accident was that the mechanic was provided with an improper part.Apr 5, 1991 · N2366W · Substantial damageNTSB CHI90DCA01Accident · Serious injuriesFinal reportZengel RV-4 · Columbia, ILThe pilot's failure to maintain a proper glidepath to touchdown on the runway.May 5, 1990 · N371FZ · Substantial damageNTSB CHI90LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILThe student's improper flare, improper recovery from a bounced landing, and failure to maintain directional control. The crosswind was a related factor.May 2, 1990 · N54093 · Substantial damageNTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.Apr 8, 1990 · N55JJ · Substantial damageNTSB CHI90LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Savanna, ILImproper planning/decision by the pilot. The strong/gusty crosswind was a related factor.Apr 8, 1990 · N89594 · Substantial damageNTSB CHI90DEV02Accident · Serious injuriesFinal reportPiper PA-25-150 · Sullivan, ILThe pilot-in-command's failure to maintain adequate terrain clearance during a turn at low altitude, resulting in ground collision. Contributing to the severity of the pilot's injury was his failure to use the installed shoulder harness.Mar 17, 1990 · N6340Z · DestroyedNTSB CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.Jan 6, 1990 · N98923 · Substantial damageNTSB CHI90LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Chicago, ILFailure of the solo student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student pilot's lack of total inexperience, and the runway lights.Dec 10, 1989 · N4372S · Substantial damageNTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.Oct 29, 1989 · N1316U · Substantial damageNTSB CHI89DEE04Accident · No injuriesFinal reportRenninger Mustang II · Kirkland, ILFuel starvation (possibly from vapor lock), which resulted in loss of engine power, and the pilot's misjudgement of ground clearance during a final turn to land.Jun 25, 1989 · N11WR · DestroyedNTSB CHI89DCA01Accident · Minor injuriesFinal reportZengel RV-4 · Columbia, ILThe improper routing of engine fuel lines resulting in over temperature of the lines which resulted in the fuel flow to carburetor to fluctuate and cause over rich condition and loss of engine power.May 21, 1989 · N371FZ · Substantial damageNTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.Apr 25, 1989 · N98923 · Substantial damageNTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…Apr 4, 1989 · N2944P · Substantial damageNTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.Oct 8, 1988 · N4608R · DestroyedNTSB CHI88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crestwood, ILAug 7, 1988 · N2098R · Substantial damageNTSB CHI88DEE08Accident · No injuriesFinal reportTownson Starduster SA100 · Monee, ILPilot failing to maintain control of the airplane during landing touchdown and roll out.Jul 31, 1988 · N9119R · Substantial damageNTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…Apr 6, 1988 · N64508 · Substantial damageNTSB CHI87LA208Accident · No injuriesLimited investigationFinal reportCessna 172PC · Jerseyville, ILThe pilot and one passenger were returning from a local flight. It had become dark during their flight and as the pilot was approaching to land on runway 36 the landing gear of the aircraft struck a drainage ditch approximately 2-3 feet short of the runway.…Sep 9, 1987 · N5343K · Substantial damageNTSB CHI87FA212Accident · No injuriesField investigationFinal reportCessna 177 · Genoa, ILThe plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…Sep 3, 1987 · N2295Y · Substantial damageNTSB CHI87LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILAccording to the plt, the lndg was normal until after touchdown when the acft bgn to 'track' toward the rgt side of the rwy. The plt said he applied left rudder, but the acft contd off the rgt side, went into a drainage ditch with standing water & nosed over.Aug 29, 1987 · N54452 · Substantial damageNTSB CHI87DEE07Accident · No injuriesFinal reportCessna 172 · Lansing, ILThe pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the…Apr 6, 1987 · N80379 · Substantial damageNTSB CHI87IA110Incident · 1 fatalIncident investigationFinal reportCessna 172L · Plainfield, ILThe pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a…Mar 29, 1987 · N4211Q · No damageNTSB CHI87LA093Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa, ILThe aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.Mar 8, 1987 · N4200J · Substantial damageNTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…Nov 17, 1986 · N1631E · DestroyedNTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…Jul 26, 1986 · N64HW · DestroyedNTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…Apr 26, 1986 · N2285Y · Substantial damageNTSB CHI86LA116Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Seneca, ILThe plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft…Apr 6, 1986 · N6829H · Substantial damageNTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.Mar 27, 1986 · N3187T · Substantial damageNTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…Mar 23, 1986 · N97266 · Substantial damageNTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…Mar 8, 1986 · N72MA · 2 aircraft · DestroyedNTSB CHI85FEE01Accident · Minor injuriesFinal reportPiper PA-28-161 · Schaumburg, ILThe student plt & instructor (CFI) were practicing touch-&-go landings. The CFI reported that after about 1 hr of flt, the eng lost power after a touch-&-go as the acft was climbing thru about 200 to 300 ft AGL. A town & some bldgs were ahead, so the CFI made…Apr 5, 1985 · N8243S · DestroyedNTSB CHI85LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILThe plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose…Mar 15, 1985 · N3421E · Substantial damageNTSB CHI85LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Champaign, ILDuring a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…Mar 8, 1985 · N4332Q · Substantial damageNTSB CHI85LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt Sterling, ILThe plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted.Jan 2, 1985 · N9484H · Substantial damageNTSB CHI85FA054Accident · No injuriesField investigationFinal reportCessna 172P · Waukegan, ILThe acft collided with the terrain during a forced landing following a loss of power during takeoff. Investigation revealed that two days previously a loss of power had occured during a test flt which was virtually identical to the power loss experienced…Nov 23, 1984 · N53134 · Substantial damage