NTSB investigations: Lycoming 0-235 series

4,598 cases on aircraft whose registry engine model is Lycoming 0-235 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
  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 MIA88FA191Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe 25 yr old student plt was practicing take-offs & ldgs on rwy 11L in preparation for his pvt plt flt test. When he departed, about 1.9 hrs prior to the accident, the winds were 090 degs at 13 knts. At the time of the accident the winds had increased to 18…Jun 14, 1988 · N2387T · Substantial damageNTSB LAX88LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZWhile flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the…Jun 14, 1988 · N49792 · Substantial damageNTSB LAX88LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Redding, CADuring a solo instructional flt, the pilot stated that he may have had his foot on the left rudder pedal on landing. When the airplane touched down it veered to the left off the runway and into a ditch. There were no reported mechanical failures or…Jun 10, 1988 · N25409 · Substantial damageNTSB ATL88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · East Liverpool, OHThe student pilot reported that he flared late during ldg. The airplane ballooned and started drifting to the right. The student added pwr and left rudder in an attempt to maintain control; he 'overcompensated' with left rudder input, and lost directional…Jun 8, 1988 · N89059 · Substantial damageNTSB LAX88LA210Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Hemet, CADuring the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path…Jun 4, 1988 · N6181L · Substantial damageNTSB ANC88LA091Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Nikolai Creek, AKA pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch.Jun 2, 1988 · N9895L · Substantial damageNTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…Jun 1, 1988 · N25352 · Substantial damageNTSB MIA88LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLWhile on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off…May 31, 1988 · N25516 · Substantial damageNTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.May 28, 1988 · N4139Y · Substantial damageNTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…May 28, 1988 · N4812B · Substantial damageNTSB NYC88LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner, METhe pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and…May 23, 1988 · N46413 · Substantial damageNTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WIMay 21, 1988 · N9686S · Substantial damageNTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…May 20, 1988 · N25934 · DestroyedNTSB ATL88LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Florence, SCThe accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of…May 18, 1988 · N757VH · Substantial damageNTSB LAX88LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Carlos, CADuring a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…May 15, 1988 · N9601L · Substantial damageNTSB ATL88LA166Accident · 1 fatalLimited investigationFinal reportPiper J5C · Gulf Shores, ALA witness reported that the airplane encountered a 'downdraft' while attempting to pick up a banner. The main ldg gear caught the banner pick-up line and carried the banner aloft. The witness radioed the plt to advise him of the situation, but received no…May 6, 1988 · N41333 · Substantial damageNTSB ATL88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, OHThe plt reported that the engine began to run rough about 2 hrs & 45 minutes into the low-level aerial photo flt. The engine subsequently lost power altogether and the plt made a forced ldg in a marsh. The airplane nosed over during the ldg. Post-crash exam…Apr 26, 1988 · N4835B · Substantial damageNTSB MIA88LA155Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mcdavid, FLThe plt stated that the flt was 15 miles from the destination & had been diverted due to haze. While flying at an alt of aprox 2,000 ft, the eng quit due to non-mechanical reasons. He was unable to restart it. The plt landed the a/c on a road, during which…Apr 18, 1988 · N2322F · Substantial damageNTSB BFO88FIG01Accident · Minor injuriesFinal reportCessna 152 · Annapolis, MDThe stu & instr were returning to mitchellville after doing several touch & go landings at stevensville. The acft was level at 1700 ft when a power loss occurred. Attempts to restart the engine were unsuccessful. The instr took control of the acft and landed…Apr 17, 1988 · N5269H · Substantial damageNTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.Apr 16, 1988 · N4830B · Substantial damageNTSB ATL88LA145Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barnwell, SCDuring initial climb after takeoff right side of the engine cowling unfastened and began fluttering violently. The instructor assumed control of acft & made a forced landing straight ahead into a cultivated field. The acft nosed up sustaining substantial…Apr 16, 1988 · N4233E · Substantial damageNTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…Apr 15, 1988 · N93802 · Minor damageNTSB LAX88LA158Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Temecula, CAWhile on final approach, the pilot encountered crosswind conditions and was unable to maintain the runway centerline. The pilot advanced the throttle and remembered hearing the stall horn. The aircraft cleared a building by 10 feet off the side of the runway…Apr 12, 1988 · N5518H · Substantial damageNTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…Apr 12, 1988 · N5089P · Substantial damageNTSB FTW88LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…Apr 2, 1988 · N9213T · Substantial damageNTSB LAX88LA147Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Apple Valley, CADrg a flt from hawthorne to delano, CA, the plt became lost, saw an arpt & landed. After landing, she learned she was at the depue arpt, lenwood, CA. No fuel was available, so she elected to fly to Apple Valley, a distance of about 17 mi. However, before…Apr 1, 1988 · N2498D · Substantial damageNTSB MIA88LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student plt completed 5 touch & go's with his instructor before dropping her off for first supervised solo flight. On the first touch & go landing , the acft bounced after touchdown on the main landing gear. The student plt added power, lowered the nose…Mar 31, 1988 · N89224 · Substantial damageNTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.Mar 27, 1988 · N9097L · Substantial damageNTSB MIA88LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Dorado, PRWhile on a personal flt in normal cruise at an alt of 1000 ft aprx 2 miles southeast of the arpt, the eng began to misfire and the cabin filled with smoke. The plt elected to land in a clearing. The plt also stated that the eng was losing pwr and tht a/c…Mar 14, 1988 · N5611Z · Substantial damageNTSB DEN88LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe private plt was performing a night solo training flight in the local area. After several stop and go landings, the plt was returning to her home airport. At 6300FT MSL, in cruise flight, the plt reported that the engine quit. Attempts to restart were not…Mar 9, 1988 · N47567 · Substantial damageNTSB NYC88LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJDuring a landing rollout, the flight encountered strong gusty crosswinds. The aircraft ran off the right side of the runway. The nose wheel dug into mud and the prop and left wing tip made contact with the ground.Mar 7, 1988 · N48900 · Substantial damageNTSB ANC88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe flight instructor was giving dual instruction to a student pilot on night landings. On the sixth touch-and-go landing, the instructor turned the landing light off for a no-light landing. The student landed the aircraft to the right of centerline, and…Mar 4, 1988 · N96082 · Substantial damageNTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.Feb 29, 1988 · N21BL · Substantial damageNTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.Feb 27, 1988 · N5135T · Substantial damageNTSB FTW88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXThe student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…Feb 23, 1988 · N24447 · Substantial damageNTSB ATL88LA098Accident · No injuriesLimited investigationFinal reportBeech 77 · Concord, GAPIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…Feb 21, 1988 · N623CH · Substantial damageNTSB FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…Feb 19, 1988 · N9331T · Substantial damageNTSB NYC88LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, NHThe student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck…Feb 18, 1988 · N6341H · Substantial damageNTSB DEN88LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Hurricane, UTThe student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…Feb 18, 1988 · N67515 · Substantial damageNTSB ATL88LA091Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…Feb 17, 1988 · N9265T · Substantial damageNTSB FTW88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Maud, TXThe acft took off from a 1800 ft private, turf, strip. The takeoff was to the sw and the wind was strong and gusty from the nw. There are trees along the right or upwind side of the rwy. Shortly after takeoff, the acft encountered turbulence and collided with…Feb 14, 1988 · N9319T · DestroyedNTSB LAX88LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAThe student pilot was on his second supervised solo and had executed a go-around on his first attempted touch & go maneuver. The plt reentered the traffic pattern and landed on runway 34L. The airplane exited to the left of the runway onto the grass. With the…Feb 10, 1988 · N25732 · Substantial damageNTSB FTW88LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot experienced a complete loss of engine power while on the final approach. The damage to the aircraft occurred when he had to land on unsuitable terrain during the forced landing. Examination of the aircraft fuel system showed that a fuel line to the…Feb 10, 1988 · N68806 · Substantial damageNTSB SEA88LA045Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palamino Valley, NVThe student pilot was practicing 's' turns over a roadway when engine power loss occurred. Forced landing attempt on the road resulted in a high flare and hard landing, shearing the nose gear. The acft flipped inverted. Engine inspection and test run revealed…Feb 8, 1988 · N48890 · Substantial damageNTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.Feb 6, 1988 · N5450Q · Substantial damageNTSB LAX88LA104Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAAt the end of a local pleasure flight, during the landing roll, the pilot lost control of the aircraft and ground looped. There were no reported mechanical failures or malfunctions of the aircraft.Jan 31, 1988 · N5058K · Substantial damageNTSB LAX88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · El Toro, CAThe student plt was practicing touch-&-go landings & was cleared for an apch behind a C-130. He stated that he noted the touchdown point of the C-130 & planned his apch to remain above the C-130'S flt path. However, just before landing, when the acft was at…Jan 27, 1988 · N4914H · DestroyedNTSB ATL88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and…Jan 12, 1988 · N757AS · Substantial damageNTSB DEN88LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…Jan 8, 1988 · N280SV · Substantial damageNTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…Dec 28, 1987 · N89126 · Substantial damage