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 ANC89LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe instructor pilot was demonstrating a soft-field landing to his student pilot when he flared the airplane too high, and allowed the crosswind to carry the airplane off the left side of the runway where it hit a runway light and a snow berm, then nosed…Nov 8, 1988 · N48943 · Substantial damageNTSB NYC89FA021Accident · 2 fatalField investigationFinal reportCessna 152 · Smithfield, RIFailure of the pilot to maintain airspeed after beginning an ascent from a low pass, which resulted in a stall & loss of aircraft control. Inadequate altitude to recover from a stall was considered to be a contributing factor.Nov 6, 1988 · N5462B · DestroyedNTSB FTW89LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskogee, OKAcft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the…Oct 26, 1988 · N4715B · Substantial damageNTSB ATL89LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe student plt reported that the airplane nose '...was wanting to come up sooner than it should' during the takeoff roll on his first solo flt; he checked the elevator trim and found it properly set. He elected to abort the takeoff. He reduced the pwr and…Oct 26, 1988 · N4713B · Substantial damageNTSB MKC89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Marion, NEShortly after takeoff from a farm field, the acft's left wing dropped & the acft descended striking the terrain. Witnesses said that immediately after takeoff, the plt attempted to make a steep climbing, left turn. A post acdnt inspn revealed no preimpact…Oct 16, 1988 · N288T · Substantial damageNTSB CHI89LA002Accident · No injuriesLimited investigationFinal reportCessna 152II · Ashland, OHWhile enroute on a cross country flight from buffalo, new york to mansfield, Ohio, the aircraft experienced a total loss of engine power. The pilot performed emergency procedures and executed a forced landing in a farmer's open field. The pilot stated that…Oct 9, 1988 · N49135 · Substantial damageNTSB LAX89LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Palmdale, CAAt approximately 6000 ft MSL two airplanes collided in flight. N49382 was climbing to altitude, N31386 was descending in a shallow left turn. The airplane descending colliding with the climbing airplane from behind and to the right. Both airplanes were able…Oct 2, 1988 · N31386 · 2 aircraft · Substantial damageNTSB MKC88LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bertrand, NEThe plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,…Sep 26, 1988 · N3390M · Substantial damageNTSB NYC88LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt.Holly, NJSeveral landings and takeoffs were performed. On the last landing, the aircraft touched down first on the right main gear and then the left main gear. The pilot stated that the aircraft seemed to slide or skid to the right and continued onto the grassy area…Sep 18, 1988 · N714YY · Substantial damageNTSB NYC88DNA02Accident · Serious injuriesFinal reportDillinger Long E-Z · Lawrence, MAThe plt depd provincetown on a rtrn flt to his home arpt at aprx 0230 EDT & arrived at his destn about 1 hr later. He rprtd he was unable to activate the plt-ctld rwy lights. He checked the lighted wind sock & decided the night was bright & clear enough to…Sep 12, 1988 · N84WD · Substantial damageNTSB ANC88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe private pilot stated that he was attempting to land on a gravel bar when the airplane encountered a soft spot and nosed over. He said that a contributing factor in the accident was that he had applied his brakes too strongly early in the landing roll, and…Sep 12, 1988 · N3148M · Substantial damageNTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…Sep 6, 1988 · N5458P · Substantial damageNTSB NYC88LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Windham, CTThe student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not…Sep 1, 1988 · N94502 · Substantial damageNTSB LAX88LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Dunsmuir, CAJust after takeoff, the airplane gained just enough altitude to clear trees at the end of the runway. The pilot turned up a valley to gain altitude. The airplane was gaining altitude at 150 fpm, however, the valley turned into a box canyon and the airplane…Aug 29, 1988 · N5058K · Substantial damageNTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…Aug 29, 1988 · N46972 · Substantial damageNTSB BFO88LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe student pilot reported that he allowed the airspeed to deteriorate on final apch. The acft touched down nosewheel first and began to porpoise on the runway. The acft porpoised 3 or 4 times before the propeller and right wing contacted the runway.Aug 28, 1988 · N49572 · Substantial damageNTSB LAX88LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chino, CAWhile on final approach, the instructor noticed the airspeed fall below 55 knots. He took control of the airplane from the student. The instructor pushed forward on the yoke and added full power to regain airspeed. He lost control of the airplane and it…Aug 27, 1988 · N67649 · Substantial damageNTSB SEA88LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe student pilot reported that during cruise while on a solo cross country training flight the engine began to surge. He called ATC and was directed to the nearest available airport. The student pilot landed long and fast and departed theend of the runway.…Aug 25, 1988 · N94649 · Substantial damageNTSB SEA88LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the…Aug 23, 1988 · N6419M · Substantial damageNTSB NYC88LA222Accident · No injuriesLimited investigationFinal reportCessna 152 II · Coatesville, PAThe student plt was returning to the airport following a 1 hr local flight. He stated that the engine sputtered and lost power. The plt selected a field for a forced landing and approached it from west to east. The plane struck a road short of the field and…Aug 19, 1988 · N49142 · Substantial damageNTSB DEN88LA187Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leadville, COThe student plt was lost during a solo cross country instructional flight. After landing and refueling at Leadville, Colorado, he attempted to fly through a mountain pass towards his destination. He climbed the acft to 12,000 and tried to continue the climb.…Aug 19, 1988 · N93538 · Substantial damageNTSB NYC88LA220Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Lakeville, MAAccording to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.…Aug 17, 1988 · N9022L · Substantial damageNTSB NYC88LA212Accident · 1 fatalLimited investigationFinal reportCessna 152 · Swanton, VTThe plt took the passenger (his wife) on a short flt, which was her 1st flt. She was described as apprehensive. Before going back to the parking area after landing, the plt taxied to the terminal bldg for his wife to deplane. He stopped the acft with the left…Aug 10, 1988 · N757LD · Minor damageNTSB ANC88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Galena, AKThe student pilot lost directional control of the airplane during landing on the tundra. During the rollout the airplane nosed over on its back. The pilot could not be found to accomplish the required accident report.Aug 8, 1988 · N7964H · Substantial damageNTSB FTW88LA144Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kingsland, TXThe tail-dragger touched down on the left gear, then the right gear. The pilot applied power for a go-around but he said he then cut it off because he was going to be going so close to the hangar. The airplane went off the left side of the runway and…Aug 7, 1988 · N57430 · Substantial damageNTSB FTW88DPJ09Accident · No injuriesFinal reportCessna 152 · Skiatook, OKThe student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient…Aug 6, 1988 · N53321 · Substantial damageNTSB LAX88LA280Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAAll of the pilot's prior flight training was done in tailwheel type aircraft. The pilot had made four full stop landings during the pattern practice instructional session and he said that he experienced directional control problems during each of the…Aug 5, 1988 · N8662V · Substantial damageNTSB SEA88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter.Aug 3, 1988 · N4651P · Substantial damageNTSB CHI88LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIAug 3, 1988 · N93411 · Substantial damageNTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.Aug 3, 1988 · N2956Z · DestroyedNTSB ATL88LA224Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Reidsville, NCThe student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right…Aug 2, 1988 · N26045 · Substantial damageNTSB NYC88LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsville, PAEngine power loss due to fuel starvation which resulted in an emergency landing in a field.Aug 1, 1988 · N4609L · DestroyedNTSB SEA88LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lewis, WAThe pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire…Jul 29, 1988 · N24995 · Substantial damageNTSB LAX88LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CAThe student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed.Jul 25, 1988 · N68342 · Substantial damageNTSB LAX88LA265Accident · No injuriesLimited investigationFinal reportCessna 152 · Dixon, CAThe plts stated that while they were cruising in close formation, the rgt wing of one acft (Cessna 152, N6469M) raised up & collided with the left main lndg gear of the other acft (Cessna 152, N6239H). N6469M received substantial damage to the wing & N6239H…Jul 20, 1988 · N6469M · 2 aircraft · Substantial damageNTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…Jul 17, 1988 · N295C · 2 aircraft · Minor damageNTSB DEN88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallup, NMPrior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude…Jul 14, 1988 · N48055 · Substantial damageNTSB DEN88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aurora, COThis was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The…Jul 9, 1988 · N67712 · Substantial damageNTSB SEA88LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Roche Harbor, WAPlt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover.Jul 8, 1988 · N4590P · Substantial damageNTSB MIA88LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees.Jul 5, 1988 · N2608F · DestroyedNTSB LAX88FA246Accident · 1 fatalField investigationFinal reportCessna 152 · Verdi, NVFailure of the pilot to gain sufficient altitude prior to negotiating mountainous terrain with forecast high winds. Contributing to this accident was the weather phenomena known as 'mountain wave' which created downdrafts that exceeded the aircraft's climb…Jul 4, 1988 · N49787 · DestroyedNTSB MIA88LA211Accident · No injuriesLimited investigationFinal reportCessna 152 · Marathon, FLThe student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure…Jul 2, 1988 · N25057 · Substantial damageNTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…Jul 2, 1988 · N2496K · Substantial damageNTSB DEN88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTJun 30, 1988 · N6392Q · Substantial damageNTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…Jun 27, 1988 · N23TW · Substantial damageNTSB ANC88LA072Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Creek, AKAccording to the pilot he made a landing on the gravel bar. Shortly after touchdown the pilot lost directional control and ground looped. The acft struck a tree stump and collapsed the left lndg gear.Jun 25, 1988 · N2987G · Substantial damageNTSB ANC88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Bethel, AKThe 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted…Jun 23, 1988 · N5630H · Substantial damageNTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MIJun 22, 1988 · N757CD · Substantial damageNTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…Jun 19, 1988 · N95056 · Substantial damageNTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…Jun 19, 1988 · N49207 · Substantial damage