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 SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…NTSB CHI85LA343Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlette, MIThe student plt was cleared by his CFI for his second solo flt immediately following a period of dual traffic pattern instruction. As he began his takeoff run he failed to use sufficient right rudder quickly enough to prevent the acft from eventually…NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…NTSB FTW85LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Katy, TXThe plt stated he had his destination arpt in sight and then lost sight of it. While attempting to locate the arpt the eng lost pwr. He attempted a emergency landing on an interstate hwy 10 west of houston, TX. After touchdown and during rollout the right…NTSB ATL85LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Hilton Head Is., SCThe commercial/cfi plt and a passenger were flying just off shore at about 700 ft when the engine quit. He could not clear trees along the shore and the beach was unusable due to fallen trees. The plt landed in the ocean and both occupants swam to shore. The…NTSB CHI85LA322Accident · No injuriesLimited investigationFinal reportCessna 152II · Indianapolis, INThe student plt lost directional control on rollout following a bounced landing. The CFI attempted to regain control but was not able to before the acft departed the rwy and nosed over.NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB NYC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Livingston, NYThe acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the…NTSB ATL85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt Sterling, KYThe insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer…NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…NTSB MKC85LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrison, ARAfter an en route stop, on a x-country flt, the student plt was taxiing to takeoff again. While proceeding northbound with a left x-wind, the plt applied braking action to slow the acft for a turn. At about that time, the acft veered to the right, went down…NTSB LAX85LA318Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Paso Robles, CAThe Paso Robles (prb) flight service station air traffic control specialist reptd that the pilot radioed that the aircraft ran out of fuel abt 5 miles so of prb. Examination of the wreckage disclsed both wing fuel tanks contained less that 1 gallon of fuel in…NTSB ANC85FA125Accident · No injuriesField investigationFinal reportCessna 152 · Big Lake, AKThe glider plt was in training for a single eng land rating & was indorsed for solo flt. During her training, she & her instructor plt had landed at the Big Lake arpt. She thought that that was her approval to land there solo. However, there were sandy soft…NTSB CHI85LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochester, MNThe student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down.NTSB CHI85LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Almont, MIThe student plt stated that during touchdown the acft bounced back into the air. On the second touchdown, the acft swerved to the left and departed the rwy. It then rolled until the left wing struck a small tree, causing substantial damage to that wing. The…NTSB LAX85FA310Accident · 2 fatalField investigationFinal reportPolliwagen Unknown · Bakersfield, CAOn July 7, 1985, at 1917 PDT, a Polliwagen, N81PW, collided with the ground during an attempted go around at bakersfieldairpark, Bakersfield, California, while on a personal flight. VMC prevailed at the time; no flight plan was filed. The aircraft was…NTSB DEN85LQA02Accident · No injuriesFinal reportCessna 152 · Santa Teresa, NMThe helcopter plt was on a solo instructional flt in the Cessna 152 airplane. He had only 9 hrs flt time in fixed wing acft. While on a touch-&-go landing, the acft bounced as it touched down. It then bounced 2 more times with each bounce becoming…NTSB MKC85LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, ARThe student plt became disoriented while on a solo cross country flt. When the acft became low on fuel the plt decided to land on a plowed fld. The fld was soft and the acft nosed over shortly after touchdown.NTSB NYC85LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Hartford, CTThe acft nosed over following a loss of control during landing. The student plt stated the acft bounced three times on touchdown. The propeller then contacted the rwy and the acft nosed over.NTSB BFO85LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDAfter not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt…NTSB ANC85FA111Accident · 3 fatalField investigationFinal reportPiper PA-12 · Chugiak, AKThe acft crashed in a wooded residential area following a loss of pwr on takeoff. Post accident inspection of the airframe and powerplant disclosed automotive fuel was being used in the acft. Lab tests indicated the fuel was subjectedto high temps which…NTSB ANC85LA116Accident · No injuriesLimited investigationFinal reportPiper J-3/100 · Port Lions, AKThe plt lost directional control of the acft during a touch and go landing. The acft veered off the rwy and contacted boulders. The plt reported to bystanders at the accident site that it had been a long time since he had flown an acft equipped with heel…NTSB MKC85FA137Accident · Serious injuriesField investigationFinal reportCessna 152 · Independence, MOStudent pilot and instructor were practicing pre-solo landings. When airplane was 30 feet AGL and on very short final approach, airplane dropped to ground, went through top of two dikes and two ditches, impacted bank of second ditch and flipped forward to…NTSB FTW85FA261Accident · 1 fatalField investigationFinal reportCessna 150 · Temple, TXA midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by…NTSB CHI85LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Starbuck, MNPlt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.NTSB SEA85LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Las Vegas, NVDuring a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at…NTSB ATL85LA178Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSPlt was returning to arpt with known low fuel state. The planned landing was to be on rwy 18 but while approaching the arpt, the eng missed. The plt elected to land on rwy 36 with a tailwind and conflicting traffic. The conflicting traffic cleared the rwy and…NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.NTSB SEA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Concord, CAThe acft contacted power lines during a night forced landing following fuel exhaustion. The plt had flown from Concord, CA, to reno, NV, and was returning to Concord when the accident occurred. The plt was recently checked out in the acft and was used to…NTSB MKC85LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Adams, NEPlt was making first landing at an ag strip and collided with 30 foot high utility wires which cross the apch end of thestrip. The wires are not marked.NTSB BFO85LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe plt prefldd the acft iaw a checklist and did not note any abnormalities. Following a normal tkof the plt remained in the traffic pattern, experiencing no complications until touchdown. The winds recorded at bwi were out of 220 degrees at 8 knots. The plt…NTSB LAX85LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAOn the student plt's third supervised solo flt he landed the acft. After touchdown he applied pwr to make a touch & go, & then raised the flaps. The acft veered left, rolled off the rwy, collided with a small dirt mound & nosed over. The student had 18.2…NTSB CHI85LA192Accident · No injuriesLimited investigationFinal reportCessna A152 · West Bend, WIPlt departed fondulac, WI, with full fuel (24.5 gallons usable) and flew aprx 25 miles south where 2 1/2 hrs were spent taking aerial photographs. Flt then proceeded aprx 60 miles to manitowoc, WI where a landing was made. Departure was then made with aprx 9…NTSB ATL85LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Ozark, ALThe plt was on a x-country flt from Ozark, AL to columbia, SC & return. He used 22 gal of fuel en route to columbia. Before returning, he refueled the acft to its full capacity of 24.5 usable gals. However, on the return flt, he encountered headwinds, did not…NTSB FTW85LA208Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student plt was on a local instructional flt practicing solo landings. He stated he made a hard landing and the acft bounced with the nose gear ass'y separating allowing the acft to be substantially damaged. The left wing ass'y received substantial damage.NTSB CHI85FA185Accident · No injuriesField investigationFinal reportBeech B35 · Sussex, WIA student plt was on his 1st solo x-country flt in a Cessna 152, N6464L. After taking off at the brookfield arpt (elev 850 ft), he had climbed to 2000 ft MSL & was heading 350 deg when he saw a Beech B35 (bonanza), N5182C, converging from his right. The…NTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…NTSB ATL85FA147Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Monroe, NCThe acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to…NTSB MIA85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLDuring a student trng flt the instructor pilot stated that he reduced throttle on takeoff at about 75 ft AGL, to simulate an engine failure. The student pilot pitched the nose of the acft up and the instructor pilot took over control of the acft, lowered the…NTSB SEA85LA092Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Hampton, ORThe student plt made a precautionary landing due to being lost and low on fuel. The airstrips surface was 1000 ft of dirt and sand with a fence at the departure end. Takeoff data based on gross weight, zero wind, 4000 ft elevation at 80 degrees, on a hard…NTSB FTW85FA176Accident · Serious injuriesField investigationFinal reportCessna 152 · Arlington, TXAcft on traffic patrol watch was observed for several minutes before crash at low altitude doing slow flt and flying erratic prior to acft stalling ans spinning into apt building no evidence of pre-impact failure or malfunction of the acft was found.NTSB MKC85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Herington, KSAcft tookoff from a 1900 ft long, sod, farm strip. Plt said acft became airborne at mid-field but felt mushy and would not climb. Acft collided with fence and bush at end of strip and sustained substantial damage. Acft remained airborne and continued to…NTSB DEN85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTThe student plt was on his 1st solo flt. His instructor plt reported that the student made a high & fast apch. The acft touched down on its main gear, bounced, then came down on the nose gear which collapsed. After the nose gear collapsed, the acft skidded…NTSB LAX85FVG01Accident · No injuriesFinal reportCessna 152 · Lower Lake, CAThe acft contacted trees while attempting to land at hoberg airstrip.NTSB CHI85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, INWhile on a solo training flt the student plt allowed the acft to bounce during touchdown. The acft then became airborne & stalled while several feet above the rwy. During the ensuing hard landing the nose gear strut collapsed & the acft veered to the left…NTSB MIA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLThe student pilot was practicing touch-&-go landings on rwy 11. Due to a wind shift, the active rwy was changed to rwy 4. The student stated that during his 1st pattern for a landing on rwy 4, his apch was high & fast. As the acft touched down, he lost…NTSB LAX85LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Grass Valley, CAAccording to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also…NTSB ATL85LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Memphis, TNAcft bounced during lndg in 10KT x-wind. The stu plt was on his 3rd unsupvr solo. The acft went off the rwy on the rt side & collapsed the nose lndg gear. The student had 28 hrs total flt time with a logbook restriction entered by his instructor to restrict…