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 ANC84LA181Accident · No injuriesLimited investigationFinal reportCessna 152 II · Skwentna, AKFBO had been experiencing difficulties with spark plugs and magnetos in this acft. The plt had flown this acft before with recurrent rough running and diminished power symptoms. Eng began to run rough on this flt and plt landed on a sand bar (marked for acft…NTSB ANC84FA182Accident · No injuriesField investigationFinal reportCessna 152 II · Anchorage, AKThe student plt was performing touch-and-go lndg practice. On the second lndg touchdown, the left wing dipped. The plt applied right aileron and the acft continued toward taxi lights. Plt applied left rudder to avoid taxi lights and acft headed toward another…NTSB MIA84LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLThe pilot stated to the chief of the FAA control tower at Key West int'l arpt after the accident that she 'porpoised' on landing, striking the nose gear and causing it to collapse.NTSB FTW84LA396Accident · No injuriesLimited investigationFinal reportCessna 152 · Laporte, TXDuring the ldg flare the acft drifted left and touched down near the edge of the rwy. The plt did not correct the drift and the acft drifted off the left side of the rwy. After colliding with a ditch the acft nosed over coming to rest inverted.NTSB ANC84LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Tasnuna Valley, AKThe plt stated that they had just taken off from a gravel bar when they spotted a moose. He circled the moose in a left orbit at about 65 miles per hour. During one of the orbits the 'right wing fell in a downward direction and the nose of the acft pitched…NTSB MKC84LA273Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Pleasant Hill, MOThe acft settled into 10-15 ft tall trees during takeoff. The rwy was 1200 ft long and the wind was 2 KTS. The plt said the trees should be cut as a preventive measure. The plt also said there were no problems with the acft.NTSB LAX84LA476Accident · No injuriesLimited investigationFinal reportCessna 152 · Rialto, CAThe plt stated that this was the first flt after the eng had been overhauled. During the takeoff climb at an alt of 500 ft the eng lost pwr. The plt made a hard landing adjacent to the rwy. Exam of the eng after the accident revealed the exhaust rocker arm…NTSB NYC84LA301Accident · No injuriesLimited investigationFinal reportCessna 152II · Washington, PAFuel exhaustion occurred 3.3 hrs into flt. Plt stated tanks appeared to be full on preflight but acft records showed 0.6 hrs flown on previous flight and acft not subsequently refueled. Aprx 1.5 gals found in tanks on post-mishap inspection.NTSB MIA84LA243Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miami, FLWhile taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred.NTSB DEN84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirtland Afb, NMUpon touchdown a hard landing was made after which the acft bounced and became airborne. The acft contacted the rwy hard at which time the nose gear collapsed.NTSB MKC84LA286Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Beatrice, NEDuring the flare an uncontrolled rate of descent developed resulting in a touchdown short of the rwy threshold. The mainldg gear struck the 5 inch exposed rwy lip. Density alt was aprx 4,200 ft.NTSB MIA84FA240Accident · 1 fatalField investigationFinal reportCessna 152 · Pembroke Pines, FLOne min and 20 seconds after being cleared for takeoff, the plt transmitted on tower freq that he was 'coming in for a landing.' The acft was observed to bank to the left, enter a steep descent from 200 to 300 ft AGL & crash. An intense post-crash fire…NTSB FTW84LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKPlt lost control after a hard, right-wind-down landing. Acft porpoised, collapsing the nose gear and came to rest nose down.NTSB CHI84LA375Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INPlt stated the acft was 1/2 way down the rwy and had not touched down so back pressure on the yoke was released. The acft then bounced three times on the rwy. On the third bounce the nose gear collapsed and the acft nosed over. Plt stated airspeed was…NTSB ATL84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Hope, ALThe plt excessively flared the acft on landing at which time the acft ballooned. Recovery from the balloon was made but upon touchdown, the acft was not aligned with the rwy. The acft traveled off the left side of the rwy and contacted several small trees.NTSB CHI84LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cottage Grove, WIWhile over-flying a local arpt at aprx 200 ft AGL the eng lost power. A forced landing was made in an adjacent alfalfa field. The acft landed hard in a nose low attitude and came to rest about 90 ft from initial ground contact.NTSB NYC84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Caldwell, NJThe instructor plt stated that while he was giving instruction, he made a normal landing. When the wheels touched down, the right main gear snapped off & hit the side of the fuselage. The acft then skidded along the rwy until it came to rest.NTSB NYC84LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicottville, NYThe plt started taking off from an unimproved, grass covered fld, but the acft would not accelerate above 50 KTS. He aborted the takeoff, but the acft continued off the end of the rwy where the nose gear was torn off & the left main gear & right wing tip were…NTSB SEA84LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Juneau, AKOver a mountain pass the acft encountered turbulence the plt described as 'severe'. The acft lost 500 to 1,000 ft and turned 180 deg. A 180 deg climbing turn was initiated and the acft again flew into the turbulence. After the second encounter aileron and…NTSB MKC84LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe student plt elected to practice touch-&-go landings. On her 1st landing of that flt, the acft bounced & began to porpoise. She started to apply power for a go-around on the 3rd bounce, but the nose came down hard & the nose gear collapsed.NTSB NYC84LA272Accident · No injuriesLimited investigationFinal reportCessna 152II · E. Windsor, CTPlt failed to note inoperative airspeed indicator until well into takeoff run. When the defect was noted, takeoff abort procedures were performed but the acft continued beyond the airport boundary into a rough field and nosed over. Investigation revealed the…NTSB LAX84LA438Accident · No injuriesLimited investigationFinal reportCessna 152 · Cressey, CAWitnesses observed two acft making multiple low passes down the river. Each acft was seen flying under 3 electrical power lines at least 3 times. On the last pass, according to local law enforcement officers, one acft struck and severed all 3 power lines.…NTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…NTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…NTSB ANC84LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hope, AKThe acft collided with a ditch alongside a short strip used by hunters and fishermen. During interviews with the plt it was revealed that the acft was overloaded and out of CG. During the takeoff the plt decided to abort after passing his decision point but…NTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…NTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…NTSB NYC84LA244Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PADuring the initial climb at aprx 10 ft AGL the airspeed dropped to 40 KTS and the stall warning horn came on. The plt pushed the nose down to prevent a stall. The right wing dropped and the acft veered off the rwy on touchdown. The acft then contacted a tree…NTSB ANC84LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore Creek, AKThe plt stated that during takeoff ground run the wind shifted to a right tailwind & lift off was initiated to clear the trees. He attempted to land on the runway, however the nose wheel struck the grass & the acft flipped over upside down.NTSB CHI84FA321Accident · No injuriesField investigationFinal reportS.I. Briggs Varieze · Pickett, WIThe acft contacted a 25 ft AGL 2 strand 14000 v power line. After contacting the lines, the acft touched down in a corn field and traveled for aprx 210 ft. the acft then crossed a 2 lane road, struck a ditch separating the canard/gear and traveled an…NTSB ATL84LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Enterprise, ALThe student plt flared at about 40 ft AGL with pwr off. The CFI who was watching said he did not hear any sounds of pwr being applied until the acft was bouncing and then only heard partial power. This was the students 1st solo landing. Theinstructor said he…NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…NTSB CHI84LA310Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNDuring a touch & go landing the acft veered to the right, exiting the runway. The nose wheel struck a manhole cover which protruded 12 to 18 inches above the ground. The acft nosed over upon contacting the cover. The student pilot stated that he had allowed…NTSB FTW84LA320Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe acft nosed down after a bounced landing. The student plt had 1 hour PIC total. She said the acft ballooned and bounced during landing. She said she should have added power during the ballooning to reflare or completed a go-around.NTSB LAX84LA410Accident · No injuriesLimited investigationFinal reportCessna 152 · Salida, CAFailure of the number 3 exhaust push rod caused the power loss. The CFI took control of the acft and performed a forced ldg on a private airstrip. Due to a higher than optimum approach the acft landed long, overran the end of the rwy and collided wiht trees.NTSB SEA84LA179Accident · No injuriesLimited investigationFinal reportCessna 152II · Reno, NVAccording to the CFI, when he & his student were on approach for landing on rwy 16R, he received a report of wind shear. The CFI stated that he was instructing his student in the 'wing down' method for x-wind landings & the acft touched-downon its right wheel…NTSB ANC84FA120Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cantwell, AKImpact occurred at the 3,600 ft level on a steep slope of mountainous terrain. Instrument meteorological conditions were reported by pilots as well as ground personnel in the area. Loose and unstable terrain conditions limited the investigative effort.NTSB FTW84LA303Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Brookshire, TXThe acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop…NTSB SEA84LA165Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Juneau, AKThe cowling of the acft came loose and the plt reduced power because of the vibration. An emergency was declared and theplt attempted a 180 degree turn at an alt of 400 ft AGL. A stall was entered and the acft hit a channel where the water was about 10 ft…NTSB LAX84LA381Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe acft was landed hard on the third landing of the student pilot's first solo. During the ensuing bounce the nose gear collapsed & the acft sustained substantial damage.NTSB ANC84LA112Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Curry, AKThe acft swerved on the over grown rwy and when the plt partially corrected the swerving the acft went off the rwys end and nosed over. The plt said he had checked the airstrip out on a solo flt and had no problems. When he returned to the unmaintained strip…NTSB ANC84LA108Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Knik Glacier, AKThe acft was climbing as the plt 'flew up' a Glacier. He stated that before the accident, he had made a check of the instruments & outside references & had determined that his rate of climb was adequate to easily clear the ridge. He stated, 'the next thing I…NTSB MKC84LA196Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Wynne, ARShortly after landing on rwy 16 the pilot noticed an aerial application acft lined up to land on rwy 34. Heavy braking was applied. The acft struck a rwy light, nosed over and came to rest inverted. The aerial application acft did not have a radio. It…NTSB CHI84LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Wayne, INDuring a landing, the acft bounced & landed on the nose wheel, collapsing the nose gear.NTSB LAX84LA372Accident · No injuriesLimited investigationFinal reportCessna 152 · Paso Robles, CAThe plt was landing on a 3000 ft strip that had been scraped out of the ground by using a 'blade'. During the construction, a 1 1/2 ft berm was left on each side of the strip. While on the landing roll, the plt kept the nose wheeloff the ground with a left…NTSB CHI84LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Park Falls, WIThe plt reported that during his preflt run-up, everything seemed normal. Using short field takeoff procedures, he rotated at 40 KTS & reached an alt of about 10 ft AGL. However, he stated that the acft did not want to accelerate to the best angle of climb…NTSB SEA84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Haines, AKThe acft had landed on a short airstrip with a 10 kt headwind. When a takeoff was attempted the wind had stopped, according to the plt, and the acft would not become airborne. The acft went off the departure end of the rwy into underbrush and a gulley. The…NTSB LAX84LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe student plt was on his 5th landing when he encountered unfavorable wind & bounced hard. He stated that the wind got under the upwind wing & subsequently the acft pivoted nose down to the ground & was damaged. The student reported that the wind was from…NTSB CHI84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Webster, OHThe plt selected a farm field with obstructions at each end to practice short field takeoffs and landings. He had previously walked the field to check for obstacles and to get the owners permission. He said that during his approach toland everything seemed…NTSB MKC84LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, KSWhile performing practice engine out procedures the student plt positioned the acft for a simulated landing to a wheat field. At practice alt the eng was shut down to simulate eng out flt characteristics. The eng was re-started & left in idle position. At…