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 ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…Mar 21, 1986 · N4276H · Substantial damageNTSB CHI86LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNUpon initial touchdown the acft bounced. In the process of 're-flaring' the acft it drifted to the egde of the rwy. The solo student plt applied full power to go-around, however, during this maneuver the left wheel hit a snowbank along the edge of the rwy.…Mar 16, 1986 · N4633B · Substantial damageNTSB CHI86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Carmel, INThe student plt was on a x-country flt. He took off from an en route arpt with aprx 12 gal of fuel on board & was returning to his home base. Due to high winds at the destination arpt, the student diverted to an alternate arpt. While en route, the acft ran…Mar 9, 1986 · N93989 · Substantial damageNTSB ATL86LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post.Mar 9, 1986 · N5276M · Substantial damageNTSB DEN86LA093Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bountiful, UTAcccording to the student plt, touch and go landings were being practiced when the acft stalled on takeoff. Witnesses stated the plt lowered the nose in an attempt to recover from the stall, however, the acft contacted the rwy.Mar 7, 1986 · N91319 · Substantial damageNTSB DEN86LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wisdom, MTThe student plt departed minden, NV on an unauthorized x-co flt that terminated in the accident at Wisdom, MT. During the landing roll at an abandoned arpt at Wisdom, the nose of the acft dug into the snow covered runway and the acft nosed over. The plt…Mar 1, 1986 · N69043 · Substantial damageNTSB ATL86LLT07Accident · Serious injuriesFinal reportCessna 152 · Dyersburg, TNThe acft collided with trees on the edge of a 5000 ft open field during a precautionary landing after the student plt on his first solo x-country became lost & confused. He landed off arpt even though he still had about 3 hrs fuel. Wx was not threatening and…Feb 25, 1986 · N93472 · DestroyedNTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…Feb 24, 1986 · N303DW · Substantial damageNTSB FTW86LQA01Accident · Minor injuriesFinal reportCessna 152 · El Paso, TXThe acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt…Feb 24, 1986 · N67888 · Substantial damageNTSB LAX86LVM02Accident · No injuriesFinal reportBellanca 7ECA · San Jose, CAThe acft ground looped to the left after landing. The student plt said he attempted with rudder and aileron to regain directional control but failed. After rolling into the grass the acft nosed over. The plt said he should have held the stick back to assure…Feb 23, 1986 · N53893 · Substantial damageNTSB DEN86FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Berthoud, COStudent plt rented acft from flying club, acft was observed by witnesses to approach the lake from the south end at a low alt. Acft struck water with right main lnd gear and rt wing tip, and nosed over. The water was described as being 'glassy' and the sun…Feb 2, 1986 · N46193 · Substantial damageNTSB ANC86LA023Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that during the landing roll he lost directional control of the aircraft. The aircraft struck a row of trees of the end of the landing area.Jan 25, 1986 · N3992M · Substantial damageNTSB SEA86LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ellensburg, WAA gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the…Jan 20, 1986 · N5338Z · Substantial damageNTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.Jan 20, 1986 · N2361D · 2 aircraft · Substantial damageNTSB CHI86LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Warren, MNThe pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over.Jan 14, 1986 · N95636 · Substantial damageNTSB NYC86LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe purpose of instructional flight was to practice soft field landings and takeoffs, stall series and VOR naviagtion. After airwork, the pilot flew to robertson field for short and soft field landings and takeoffs. During final soft field takeoff, 10 degrees…Jan 10, 1986 · N6267Q · Substantial damageNTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…Jan 5, 1986 · N6422Q · Substantial damageNTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…Jan 3, 1986 · N50384 · Substantial damageNTSB DEN86LA052Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA-1A Yankee · Cloudcroft, NMThe plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg…Dec 23, 1985 · N9201L · Substantial damageNTSB MIA86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe instructor pilot simulated an engine failure after takeoff. The student pilot failed to lower the airplane nose to maintain flying speed. The instructor took over the controls and lowered the nose, but was unable to avert the hard landing and ensuing…Dec 22, 1985 · N2569L · Substantial damageNTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…Dec 9, 1985 · N64851 · Substantial damageNTSB FTW86LPA08Accident · No injuriesFinal reportCessna 152II · Frisco, TXThe student plt stated that he departed mckinney municipal arpt at aprx 1030 LCL en route to wichita falls, TX. He said he became disoriented while en route, but landed at wichita falls at aprx 1220 LCL. The plt did not refuel the acft. He then departed…Dec 8, 1985 · N4731H · Substantial damageNTSB DEN86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 II · Greeley, COAccording to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention.Dec 1, 1985 · N49209 · Substantial damageNTSB ATL86LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntsville, ALDuring a cross country flight, the pilot elected not to refuel at his proposed refueling point and continued to another airport. While on a visual approach to the runway, the aircraft lost power due to fuel exhaustion.Nov 24, 1985 · N45920 · Substantial damageNTSB SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.Nov 12, 1985 · N3534M · Substantial damageNTSB CHI86LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIThe acft struck wires during the recovery phase of a simulated forced landing apch. The plt continued the flt for aprx 1 hr after the wire strike and landed without incident. Examination of the acft revealed replacement of the right wing was needed.Nov 8, 1985 · N24457 · Substantial damageNTSB LAX86LA034Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Chandler, AZDuring a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short…Nov 6, 1985 · N42XX · 2 aircraft · Substantial damageNTSB MKC86LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Hughes, ARThe training flt progressed normally until a loss of pwr forced the student pilot and instructor to make a forced landing to a plowed field short of theri destination airport. The subsequent landing substaintially damaged their aircraft. An engine inspection…Nov 4, 1985 · N68414 · Substantial damageNTSB LAX86LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Angwin, CANear the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &…Nov 3, 1985 · N21491 · 2 aircraft · Minor damageNTSB ANC86LAG05Accident · Minor injuriesFinal reportBeech BE77 · Hope, AKThe acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.Oct 29, 1985 · N6753X · Substantial damageNTSB LAX86FA024Accident · 1 fatalField investigationFinal reportChampion 7ECA · Seal Beach, CABased upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…Oct 27, 1985 · N7547F · Substantial damageNTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.Oct 26, 1985 · N10769 · 2 aircraft · Substantial damageNTSB LAX86LA018Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Turlock, CAThe acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt…Oct 19, 1985 · N5059G · Substantial damageNTSB MKC86LA009Accident · No injuriesLimited investigationFinal reportCessna 140A · Pacific, MOThe airplane had rolled for 100 feet when the left wheel hit a mound of dirt left by a pocked gopher. The wheelpant bracket contacted the tire and acted as a brake. Airplane nosed forward to the inverted position.Oct 12, 1985 · N5382C · Substantial damageNTSB BFO86LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAccording to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear…Oct 12, 1985 · N49396 · Substantial damageNTSB FTW86LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner.Oct 3, 1985 · N67803 · Substantial damageNTSB CHI86LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHAccording to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft…Oct 1, 1985 · N5331P · Substantial damageNTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…Sep 30, 1985 · N1008E · Substantial damageNTSB CHI85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Delta, OHThe plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over.Sep 29, 1985 · N24278 · Substantial damageNTSB ATL85FLT13Accident · No injuriesFinal reportPiper PA-38-112 · Springfield, TNThe acft was substantially damaged after contacting thres during a landing following a loss of pwr on takeoff. Post accident inspection revealed the carburetor valve ass'y had separated from the lever ass'y allowing the valve to seat flat against the…Sep 26, 1985 · N2438C · Substantial damageNTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…Sep 15, 1985 · N2387P · Substantial damageNTSB MIA85FA253Accident · No injuriesField investigationFinal reportCessna 152 · Panama City, FLThe plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and…Sep 13, 1985 · N4894B · 2 aircraft · Substantial damageNTSB LAX85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Modesto, CAThe student plt reptd the final approach angle was too shallow. He added power and as the acft arrived over the threshold he reduced the power. The acft landed hard and bounced. When the acft became airborne the plt added power to execute a go-around. The…Sep 10, 1985 · N5477B · Substantial damageNTSB MKC85LA212Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOStudent plt on first solo takeoff experienced left yaw after liftoff. While plt attempted to correct for the yaw the acft touched down beside the rwy, traveled a short distance, collided with a dirt bank and nosed over. The plt said there was a left crosswind…Sep 8, 1985 · N67463 · Substantial damageNTSB DEN85FTK03Accident · No injuriesFinal reportCessna 152 · Tea, SDThe student & instructor plt (CFI) were practicing landings. After making 3 touch-&-go landings, the eng lost power at aprx 200 ft AGL as they were on their 4th takeoff. The CFI reported that he turned the acft about 25 deg in an attempt to glide to a bean…Sep 6, 1985 · N69125 · Substantial damageNTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.Sep 1, 1985 · N7559F · Substantial damageNTSB ATL85LA264Accident · No injuriesLimited investigationFinal reportPiper PA-18 105 · Hendersonville, NCDuring the takeoff phase of a touch & go landing, the CFR and private pilot lost directional control and ran off the side of the runway.Sep 1, 1985 · N323T · Substantial damageNTSB MIA85FA241Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Daytona Beach, FLPilot did not know how to turn on the instrument panel lights nor did he have a flash light available. He continued flight into darkness of night at which time he became disoriented and lost. He continued to fly until he exhausted all fuel on the aircraft and…Aug 29, 1985 · N6502L · Substantial damageNTSB NYC85LA233Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Wheatland, NYAcft departed leroy, NY, on an instructional flt to rochester, NY. Fifteen minutes after departure the flt made a forced landing in a bean field. Examination of the acft showed no useable fuel remained.Aug 28, 1985 · N9787U · Substantial damageNTSB LAX85LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAFollowing an uneventful flt,the pilot taxied towards his parking area. He said as he looked to his right for a parking space the acfts left wing impacted a hanger and the acft turned left nosing into the hanger door.Aug 20, 1985 · N4807B · Substantial damage