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 FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…NTSB SEA84LA052Accident · No injuriesLimited investigationFinal reportCessna 152II · Minden, NVThe acft landed fast and during subsequent bouncing the nose gear broke off. This student plt had only about 3 hours of solo flt experience.NTSB NYC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Easton, PAThe student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover.NTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.NTSB CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.NTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.NTSB CHI84LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit Lakes, MNThe acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…NTSB LAX84LA154Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Healdsburg, CAThe plt reported that a gust of wind pushed up the left wing & the acft veered off the rwy. The acft then went down a shallow grade & impacted bushes. He reported the wind was from 330 deg at 10 gusting 18 KTS.NTSB MKC84LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOThe acft bounced during a touch and go landing. The plt was unable to control the bouncing and the acft received damage to the nose gear, propeller and wing tips.NTSB CHI84LA089Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Hawley, MNThe acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation.NTSB CHI84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Holman, WIAfter flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of…NTSB MKC84FA058Accident · 1 fatalField investigationFinal reportCessna 152 · St. Charles, MOThe acft was progressing from a touch-and-go landing when it collided with transmission wires, 926 ft from the rwy at about 27 ft AGL. The weather was conducive to carburetor icing and the carburetor heat control was found partially open. Several gallons of…NTSB NYC84LA067Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Monson, MEOn a crosscountry VFR flight the pilot inadvertently encountered instrument conditions. During a climb to clear surrounding mountains the acft struck trees and crashed. The pilot had been briefed on the deteriorating weather prior to the flight. The pilot and…NTSB DEN84LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Homestead, MTThe acft crashed from an altitude of 200 ft while maneuvering over a creek. The acft was overloaded by 135 lbs with 2 occupants and full fuel. There were no FAA records found on the plt.NTSB LAX84FA129Accident · 2 fatalField investigationFinal reportYaple, Robert G. VARI-EZE · Bowie, AZDespite 2 wx briefings forecasting marginal VFR conditions with reports of icing, the plt departed on a flt in the non-ifr equipped acft. Just prior to the accident, transmissions between the plt & ATC indicated that the acft was in a snow shower between…NTSB DEN84LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, COAfter returning from a maintenance test flt, the plt made a normal apch to land on a snow covered rwy. According to the plt & his passenger, the acft touched down along the right side of the rwy in snow. The plane then veered to the right & nosed over. No…NTSB LAX84LA120Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Murrieta, CAThe acft nosed over during landing rollout. The plt reported the acft speed on final was 80 mph which is faster than normal. The acft touched down about 900 ft down the 2682 ft rwy. The landing was on rwy 15 and the wind was from 045 degrees at 4 KTS. The plt…NTSB CHI84LA072Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Covington, INThe acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained…NTSB DEN84LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe acft collided with a snow bank during landing and nosed down. This was the student's first solo landing. The studentthought the landing was all right except that the acft kept going to the left in spite of right rudder. Some power was still on the acft.…NTSB MIA84FA044Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, FLThis was the first flt for the prospective student plt. He stated that during the second trafic pattern over the gulf, the acft appeared to hit a gust of wind, pitched up, & entered a spin. Winds were gusting 27 KTS, & severe wx was forecast & arrived later…NTSB FTW84LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winslow, ARDuring a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had…NTSB FTW84LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXDuring a touch-&-go landing, the acft bounced back in teh air after touching down. At that time, the sudent plt reacted by pushing forward on the control yoke. The acft then impacted, nose down, & the nose gear collapsed.NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB MKC84LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · David City, NEThe instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.…NTSB LAX84LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fairfield, CAAfter taking off & while climbing thru about 100 to 300 ft, the eng lost power. During a forced landing, the acft impacted a fence & a berm, and went over railroad tracks, then came to rest inverted in a ditch. An exam of the acft revealed corrosion in the…NTSB NYC84LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlborough, MAThe acft collided with trees during final approach to land. The acft was on a short final to rwy 32 at marborough when the left wheel and left wing struck tree tops a short way from the rwy threshold. The acft turned about 70 degrees to the left and collided…NTSB NYC84FA039Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Wellsville, PAPrior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an…NTSB LAX84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Oceanside, CAThe acft collided with a fence during landing roll. The private plt receiving instruction in conventional gear acft was making his second landing. After rolling 150 ft the acft made a skidding right turn and veered off the right side of therwy. The CFI was…NTSB ATL84LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntington, WVAcft ballooned during the landing portion of a touch-&-go. The student added power & the acft stalled in a nose high attitude. The acft dropped to the rwy from about 10 ft.NTSB MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB LAX84LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe plt, who was on his fist solo stated he 'started to flare out bit high, bounced a few times, lost directional control and went off runway 30, to the right. The acft went up on its right wing, then back down, and came to rest upright.'NTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.NTSB LAX84FA057Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Inglewood, CAThe student said that the eng lost power & he initiated an emergency landing. He switched fuel tanks, applied carburetor heat & checked the magnetos. However, before landing, the eng restarted & the student applied full power & began to climb, not realizing…NTSB CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…NTSB LAX84FA046Accident · No injuriesField investigationFinal reportPiper PA38-112 · Corona, CAThe acft landing gear collapsed during an off rwy but on arpt forced landing. The pilot had just completed the annual inspection and was testing the acft. At 150 ft AGL during takeoff the engine quit. The plt landed on rough terrain ABOUT1/4 mile west of the…NTSB NYC84LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Skaneateles, NYThe pilot stated that after returning from a x-ctry flight he was unable to activate the arpt rwy lights. Low on fuel, the engine quit while he searched for a place to land. He executed a forced landing into an open field. The pilot statedhe should not have…NTSB FTW84LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Weslaco, TXThe student was practicing touch & go landings on a solo flt. On his 1st apch, the acft touched down on the left side of the rwy. The student reported that when he added power to go around, the acft veered to the left. He reported that he applied excessive…NTSB MIA84LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Milton, FLThe acft was obsvd during a touch and go lndg to be high and fast. Aft bouncing on initial touchdown the plt lowered the nose and during the second touchdown the gear collapsed.NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB MIA84LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe acft nosed over after the nose gear collapsed during a hard landing. The student pilot was making touch and go practice landings. This touchdown was hard and on the nose gear. The weather was VMC but the wind was from 330 degrees at 12 KTS. The landing…NTSB LAX84LA024Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Groveland, CAThe acft called in on radio to land on rwy 27 but landed on rwy 09. The acft landed fast, bounced, and went off the end of the rwy. The nose gear collapsed and the acft nosed over.NTSB MKC84LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Clear Lake, IAThe student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing…NTSB FTW84LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 Special · Wichita Falls, TXThe plt reported that during a landing with a quartering left head wind, the right brake did not hold & the acft veered to the left. He added power in an attempt to avoid a ground loop; however, the acft went in a wet, plowed field & nosed over. Reportedly,…NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…NTSB CHI84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · East Peoria, ILAt about 10 ft AGL a 300-400 RPM decrease in power occurred. The plt elected to land straight ahead into a cut bean field. He touched down about 400 ft from the end of the rwy, traveled about 500 ft further where a large rut was struck. About 10 flt hours…NTSB CHI84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · East Liverpool, OHThe plt stated that while landing on a downhill grass strip he touched down long. While attempting to apply brakes, the heel of his boot got caught under the rudder pedal & he was unable to stop the acft before it went off the end of the strip down a steep…NTSB ATL84LA008Accident · No injuriesLimited investigationFinal reportCessna 152II · Hamilton, ALThe acft made a hard landing during a x-country flt. The acft was seen to make a slow approach and stall prior to touchdown. The acft landed hard and bounced after which the nose gear was damaged. The student plt had not landed at this arpt before.NTSB ATL83LA383Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Apison, TNThe acft collided with trees and crashed during takeoff from a short grass strip in a downwind direction. The wind velocity was 9 KTS. The strip was 2300 ft long with 75 ft trees at the end. Under the existing conditions the takeoff could not be accomplished…