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 FTW83FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · La Grange, TXThe plt elected to takeoff to the north on a downsloping paved road. He reported that the wind was variable from the southwest at 2 to 4 KTS, gusting 4 to 6 KTS. At austin, TX, the wind was from 190 deg at 13 gusting 20 KTS & at college station, TX, it was…NTSB LAX83LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Corona, CAThe acft was landed hard twice and on the 2nd touchdown the nose gear collapsed. The 1st landing had been nose gear 1st,followed by a go-around and the gear appeared bent. On the second landing the nose gear again hit first and this time itcollapsed. This was…NTSB NYC83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blairstown, NJThe plt lost directional control & the acft swerved into a snowbank.NTSB MIA83LA080Accident · No injuriesLimited investigationFinal reportCessna C-152 · Yeehaw Junction, FLAccording to the student pilot the aircraft was fueled to maximum capacity prior to departure on a cross country flight. Approximately 3.2 hours later the engine quit and the pilot was forced to make an emergency landing in a wooded area. Subsequent engine…NTSB ATL83LA109Accident · No injuriesLimited investigationFinal reportPiper J-3C · Stockbridge, GAThe acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the…NTSB FTW83LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Tyler, TXWhile making a short field approach, the acft touched down hard & the nose gear failed.NTSB CHI83LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Bellefontaine, OHThe acft ground looped off the runway during a takeoff. The solo student said he encountered nosewheel shimmy during thetakeoff roll. He raised the nose to stop the shimmy and looked at his airspeed indicator. At about that time, the acft weathervaned to the…NTSB CHI83LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNDuring final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.NTSB ANC83FAG04Accident · No injuriesFinal reportCessna 140 · Iliamna, AKThe aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a…NTSB MKC83LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedan, KSThe student pilot was on the return leg of a round robin cross country when the encountered clouds and diverted to cushing, OK. Later, when he departed from cushing, he forgot to reset his directional gyro to correspond with the magnetic compass. When his…NTSB LAX83LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tucson, AZThe acft crashed about one mile north of the runway after engine failure during a go-around. The student pilot on a solotraining flight had returned to Tucson international airport and could not land because of cross-winds. He diverted to davis-monthan afb.…NTSB NYC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student plt was taking off on rwy 08 with a wind from the northeast at 11 KTS. He reported that he was aprx 100 ft into the takeoff roll when the acft swerved to the left. Subsequently, the acft collided with a snowbank on the left edge of the rwy.NTSB MKC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Ord, NEThe student pilot reported that on his third touch-and-go, he was momentarily distracted and looked down inside the aircraft. He inadvertentently pushed the left rudder and was unable to regain directional control before the left main wheel ran off the side…NTSB CHI83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Springfield, OHThe acft swerved during landing and the landing gear sheared off. This was a supervised solo flt and the pilot had made one sucessful touch and go landing. During the 2nd landing the acft swerved to the left and the landing gear collapsed.NTSB LAX83LXQ03Accident · No injuriesFinal reportCessna 152 · 2 Mi East Mina, NVThe aircraft made a forced landing on a dirt road, collided with some rocks and nosed over. The engine had failed because of fuel exhaustion. The pilot said he refueled the previous day but did not physically check the fuel the day of the accident. The…NTSB CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.NTSB MKC83LA048Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olathe, KSThe aircraft was on downwind when the engine stopped. The aircraft touched down 1000 ft short of the runway. Investigation revealed there was no fuel in the fuel tanks.NTSB LAX83FUJ09Accident · 1 fatalFinal reportGrumman American AA-1B · Cornville, AZThe pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…NTSB MIA83LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, FLThe student was practicing touch and go landings. On the second landing the aircraft landed hard in a nose first attitude. The nose gear collapsed.NTSB DEN83LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Afton, WYThe pilot stated that he touched down on the snow covered runway and the brakes were frozen. The aircraft hit bare pavement and veered to the left. Wheel dropped off edge of runway into a snow bank. The aircraft nosed over. An interview with the pilot…NTSB ANC83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe plt stated that during an earlier takeoff from a frozen lake that he struck an unknown object imbedded in deep snow. He noticed that his right gear & ski were damaged, & continued his flight to Anchorage. Approaching Anchorage he was advised by lake hood…NTSB CHI83LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student pilot with his instructor on board were performing touch and go landings. After the third takeoff the engine quit at approximately 150 ft AGL. The pilot made an emergency landing between the two runways at Rockford. Examination of the engine…NTSB FTW83LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot on her 2nd solo flight failed to flare during landing. A hard landing and improper recovery from bounced landing followed. The aircraft left the runway and nosed over.NTSB MKC83LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAStudent pilot tried to contact tower on incorrect frequency. Approach was high and long. Stalled aircraft 25 feet AGL half way down runway.NTSB FTW83FPM03Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKOn the day before the accident the plt flew the acft to excelsor springs, MO for refueling, returning to liberty. On 11/7/82 at 1545 the flt departedliberty on an IFR flt plan. Approximately 7 mi north of Tulsa intl arpt the plt elected to land at Tulsa for…NTSB LAX83DA031Accident · No injuriesFinal reportCessna 152 · Marana, AZDuring cruise the aircraft ran out of fuel prior to reaching the pilot's intended point of landing. The pilot attempted a forced landing in the desert. Records indicated the aircraft had flown about 5.3 hours since it was last refueled.NTSB DEN83LA014Accident · Minor injuriesLimited investigationFinal reportGrumman AA1 · Bicknell, UTThe pilot stated that shortly after departing the Bicknell airport, a strong downdraft forced the aircraft into the ground while approaching the lee side of a ridge line. He indicated the aircraft was at about 100 mph indicated airspeed when ground contact…NTSB MKC83LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · 1nm N. Or Mcgre, NEUpon discovering his intended point of landing was closed, the pilot chose to land the aircraft on a nearby road. During his final approach the pilot saw a power line and dove under it landing short. The aircraft collided with road signs during the landing…NTSB ATL83FKG02Accident · No injuriesFinal reportCessna 152 · Doraville, GAThe pilot was on an IFR flight plan and made a missed approach at the destination. While on a second approach, the aircraft ran out of fuel. During a forced landing, the nose gear collapsed and the left wing and right aileron were damaged.NTSB FTW83LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Aztec, NMThe aircraft was involved in a hard bouncing landing when the student pilot allowed the aircraft to porpoise during landing. The nose gear failed during this sequence and the aircraft was damaged. The pilot was uninjured. The pilot did not file an accident…NTSB LAX83FUJ01Accident · 1 fatalFinal reportGrumman American AA-1B · New River, AZAfter entering the traffic pattern, the aircraft was observed in a steep descending turn from downwind to final approach. A witness reported that the pilot kept increasing the bank, while turning to final, as if to keep from overshooting the final approach…NTSB NYC83LA009Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Jamestown, NYThe student pilot was practicing touch-and-go landings on runway 13 with a reported wind from 180 degrees at 15 KTS. He reported that during a landing, he flared too high and bounced. Reportedly, power was applied to go-around, but the plane began to…NTSB CHI83LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNWhile performing a touch-and-go landing, the pilot used a higher than normal speed. After touching down, the aircraft became airborne again, then began to porpoise. After about the 3rd or 4th bounce, the nose gear failed.NTSB FTW83LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXWhile practicing touch & go landings the student plt lost directional control, ran off the side of the rwy into a ditch collapsing the nose gear & turning over.NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB MIA83LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe student pilot was practicing touch-and-go landings. According to him, the nose gear collapsed as he lowered the nose on his third landing. The propeller struck the runway surface and the plane veered to the left. After departing the left side of the…NTSB CHI83LA005Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INAfter takeoff from a touch & go the eng lost power. The #1 cyl upper plug lead nut had backed off & the lead was found resting in the plug. The #2 & #4 cyl upper plug lead nuts had backed off & both leads were not in the spark plugs but were resting on the…NTSB NYC83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bernville, PAThe pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more…NTSB MKC83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSThe pilot estimated there was about 10 gallons of fuel on board before he took off. After making three takeoffs and landings, he picked up a passenger and flew in the local area. After flying about one hour and 17 minutes, the engine lost power. While landing…NTSB MIA83LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe student pilot was practicing touch-and-go landings. After touching down on his first landing, he configured the aircraft for takeoff. Immediately after applying power, he observed another plane (unknown make & model) landing from the opposite direction.…NTSB SEA83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Salmon, IDThe plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard…NTSB FTW82DA400Accident · No injuriesFinal reportCessna 152 · Dumas, TXDuring the student's first solo takeoff & landing, she was not lined up with the runway & elected to go around. Power was applied & the flaps were fully retracted. The acft immediately dropped to the ground left of the runway.NTSB ANC82DA099Accident · No injuriesFinal reportPiper PA-12 · Nr. White Mount, AKThe aircraft collided with the tundra during a forced landing in marginal weather. The pilot said the engine continued to lose engine RPM even though he used carburetor heat. The carburetor heat hose was found to be badly deteriorated during post accident…NTSB CHI82IA364Incident · No injuriesIncident investigationFinal reportCessna 152 · Pontiac, MIThe pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was…NTSB FTW82DA392Accident · No injuriesFinal reportCessna 152 · Parks, LAThe pilot stated that the aircraft ran out of fuel. The fuel gauges were still registering 1/4 full on both tanks when the engine quit. In addition the pilot stated, "if I had dipped the tanks on preflight I would have known exactly how much fuel was in the…NTSB NYC82DA231Accident · No injuriesFinal reportPiper PA-38-112 · Pomona, NJWhile taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.NTSB DEN82DA183Accident · 1 fatalFinal reportAmerican AA1 · Opheim, MTThe pilot tookoff and made a pass over the airport. At about 500 feet the aircraft began to roll and spun to ground impact. Investigation revealed the pilot was apparently maneuvering and wing dipping for his friends on the ground when the stall occurred.NTSB FTW82DA360Accident · No injuriesFinal reportAmerican AA-1A · Georgetown, TXAt 50 feet AGL the instructor pilot closed the throttle to simulate engine failure during takeoff. He expected a low speed, low altitude, steep 120 degree turn to land on runway 29 by the private pilot receiving familiarization on the AA-1A aircraft. The…NTSB FTW82DA357Accident · No injuriesFinal reportCessna 152 · College Station, TXAfter the CFI cut power for a simulated forced landing, the student set up an approach to a road. When power was added at the bottom of the approach the engine accelerated to about 75% power & then decelerated back to idle. On touchdown on the road the left…