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.
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" 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 LAX87LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZDuring a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…NTSB MIA87LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLFull flap x-wind take off & landings were being conducted on rwy 13 with the winds at 210 to 220 degs at 10 KTS, or a right x-wind component of 80 to 90 degs. The student plt permitted the acft to get too slow while about 10 ft above the ground. A high sink…NTSB BFO87LA019Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up…NTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.NTSB NYC87LA074Accident · No injuriesLimited investigationFinal reportCessna 152C · Washington, CTThe flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…NTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…NTSB NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.NTSB LAX87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZDuring a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the…NTSB LAX87LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Tracy, CAJust after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…NTSB LAX87LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendora, CADuring a local pleasure flight, the engine lost power and the pilot made a forced landing on a golf course. Visual inspection of the fuel tanks revealed that both tanks were empty and no fuel drained from the sumps. No mechanical failure or malfunction with…NTSB NYC87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyertown, PAStudent pilot on a solo cross-country flight experienced fuel exhaustion, landed in a field and collided with a stonewall. The aircraft was substantially damaged and the pilot received minor injuries.NTSB NYC87LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Simsbury, CTThe aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface.NTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…NTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…NTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…NTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…NTSB CHI87LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INNose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given…NTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…NTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.NTSB FTW87FA041Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Robertson, TXWitnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction…NTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…NTSB MIA87LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident.NTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.NTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…NTSB MIA87LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…NTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…NTSB MKC87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Gretna, NEThe instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for…NTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…NTSB SEA87LA017Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Paisley, ORThe acft contacted power lines during a night forced landing on a highway following a loss of pwr. The power lines paralleled the road. Investigation revealed no discrepancies with the engine or fuel system. Planned fuel reserve was found in the tanks. The…NTSB NYC87LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Haverhill, MAThe student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full…NTSB MIA87LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe plt stated that he was about to conduct his first touch-&-go ldg after a local solo training flt. On the first ldg, he said he made a 'slight bounce' & he leveled the acft & set up for another flare. He said the acft touched down again on the mains but…NTSB LAX87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring a first solo instructional flight, the pilot was taking off from his third touch-and-go when at an altitude of approximately 10 feet AGL the right wing was suddenly rose. The aircraft then veered to the left. The left main gear then collided with a…NTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…NTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…NTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.NTSB NYC87LA017Accident · No injuriesLimited investigationFinal reportCessna C-152 · Port Jefferson, NYThe Cessna 152 experienced a total loss of power for unknown reason while leveling off at 1800 ft. the student pilot escaped without injury from the aircraft after it was ditched in long island sound. The aircraft was not recovered.NTSB LAX87LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAA Cessna 152 went out of control during takeoff ground run and then collided with a dirt bank and nosed over. The student plt indicated that he was practicing touch and go landings when the accident occurred. He had just applied takeoff power after landing…NTSB LAX87LA001Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe acft went out of control and ran off the rwy. The student plt indicated that on his first apch his altitude was too high and he was aligned to the left of the rwy. He initiated a go-around and made a second attempt. During the flare on his second apch the…NTSB MIA86LA253Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Deltona, FLThe pilot stated that while in cruise flight the engine failed and he executed a forced landing to a lake and ditched the aircraft. The aircraft was recovered and examination of the power plant and systems failed to reveal any malfunction/failure that would…NTSB DEN86LA253Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hurricane, UTUpon making a normal landing the aircraft groundlooped to the right, impacting with an embankment. Aircraft became airborne again and touched down in soft earth, nosed over and substantially damaged the aircraft. No injuries occurred on this VFR training…NTSB MIA86FA252Accident · 2 fatalField investigationFinal reportCessna 152II · Clewiston, FLPurpose of the flt was to spot stray cattle. The acft made a low pass after chasing a cow. According to witnesses, the acft stalled and descended to ground impact during the pull-up maneuver following the low pass.NTSB ANC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork Rive, AKThe pilot lost control of the aircraft and nosed over during landing on a gravel bar. The pilot stated that the airplane nosed over because he stood on the brakes hard during the landing roll to prevent traveling into the river. The plt could not be contacted…NTSB LAX86LA353Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe plt & passenger, each weighing 185 pounds, planned a local flight in the rented Cessna 152. The acft's fuel tanks were full. The plt reported that during his pretakeoff engine run up no mechanical difficulties/malfunctions were observed. The plt also…NTSB CHI86FEE07Accident · Minor injuriesFinal reportMurphy LONG-EZE · Princeton, ILThe pilot stated that he held the aircraft in a crabbed attitude throughout the touchdown phase of landing to compensate for a crosswind condition. On touchdown the nose and main landing gear collapsed and the aircraft slid on its belly for approximately 330…NTSB BFO86LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Mappsville, VAThe plt experienced a drop in engine power during cruise flight. He applied carburetor heat and power was regained. A precautionary landing was made at nearby accomack co arpt. Several engine runups were done and there was no problem detected. He departed the…NTSB ANC86LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big River, AKThe pilot attempted a touch and go landing to evaluate a questionable landing area. The area was too soft for a touch and go. The acft became mired in mod and nosed over.NTSB DEN86LA247Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Chinook, MTThe acft took off on a 3900-foot dry asphalt rwy. An uncommanded left yaw developed which the plt was unable to counter. The acft struck a fence off the left side of the rwy and nosed over.NTSB MKC86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Onawa, IAThe student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged.NTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.NTSB CHI86MA212Accident · 1 fatalMajor investigationFinal reportPiper PA-31-T1 · Montgomery, NYAfter canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he…