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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB LAX88LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAFailure to adequately supervise the flight and recover from the student pilot's bounced landing.NTSB 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…NTSB 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…NTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WINTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…