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 SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.NTSB CHI87LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jenison, MIOn takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side…NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.NTSB NYC87LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cape May, NJThe Piper J3C-65 made an unsuccessful attempt at a banner pickup and was maneuvering at 400 ft in a climbing left turn for another pickup when a power loss occurred. The pilot made a forced landing in a marsh. The pilot reported the fuel quanity gauge was…NTSB NYC87LA190Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Kralltown, PAThe plt attempted to takeoff from a 2130 ft grass strip on a relatively hot & humid day with an air temp of 85 deg. About 2/3 of the way down the rwy, he rotated the acft to takeoff, but it would not climb sufficiently to clear a hill beyond the arpt boundry.…NTSB SEA87FA124Accident · 2 fatalField investigationFinal reportBeech 77 · Spokane, WAOn takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled…NTSB ATL87LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe comm plt held a helicopter rating and was training for his private pilot single-engine-land rating. He had flown approximately 10 hours in fixed wing aircraft with 6 hours as PIC. The pilot had completed two landings and on the thirdapproach stated he was…NTSB NYC87LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged.NTSB CHI87DEM08Accident · No injuriesFinal reportCessna 152 · Plainwell, MIThe aircraft experienced a total power failure and the pilot chose a wheat field on rising terrain for a forced landing. The field turned out to be rough and uneven. When the aircraft touched down, the nose gear failed and the aircraft nosed over. Subsequent…NTSB ANC87LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kvichak Bay, AKThe pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the…NTSB MIA87LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miramar, FLThe student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase.NTSB FTW87LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could…NTSB BFO87DIG05Accident · No injuriesFinal reportCessna 152 · Baltimore, MDThe student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was…NTSB ATL87LA156Accident · No injuriesLimited investigationFinal reportCessna C-152 · Bunn, NCThe airplane nosed over during a precautionary ldg in a soft, dirt field. The plt and a mechanic had been ferrying the airplane back to its base after replacing the starter and battery solenoids, and the battery. The pre-flt run-up had revealed no problems…NTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…NTSB MKC87LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Louis, MOThe pilot stated that he departed St. Louis downtown-parks airport (cps) on a round-robin flight with planned stops at st. clair memorial airport (K39), Missouri, and richland municipal airport (M034), Missouri. The return flight to cps included another stop…NTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…NTSB FTW87LA120Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sargent, TXThe plt decided to takeoff twd the NE on a pvt road (which he referred to as 'shell rd . . . Beach'). He used 10 deg of flaps & applied full power before releasing the brakes. He stated that after becoming airborne about 2 to 5 ft, the acft 'shifted slightly…NTSB CHI87LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNThe plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after…NTSB CHI87LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIAccording to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to…NTSB LAX87LA204Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring an instructional flt, the student plt had control of the acft during a soft field take-off. The student did not keep the acft aligned with the centerline even after the instructor told the student to add right rudder to stop the drift. Just prior to…NTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.NTSB CHI87LA123Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Gobles, MIDuring the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to…NTSB CHI87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Footville, WIPilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign.NTSB MIA87FA153Accident · No injuriesField investigationFinal reportCessna 152 · Lantana, FLThe plt stated that he was at 60 KTS. With full flaps & just about to flare when somthing forced the nose down. He then pulled back on the controls, hit the ground, veered off the left side of the runway & collided with a C152 that was holding for takeoff,…NTSB SEA87LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Renton, WADuring touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear.NTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…NTSB FTW87LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXA student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted.NTSB MIA87LA139Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot experienced an engine failure in flight and landed the aircraft in a pasture. He then restarted the engine and took off, after take off the engine failed two times and he restarted it. The engine failed the third time and he could not start…NTSB LAX87LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAWhile making practice landings, the student pilot failed to maintain flying speed during the final stages of his second approach. The aircraft stalled inadvertently about 15 feet above the runway and landed hard on the nose wheel.NTSB CHI87LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marine City, MIDuring a solo training flight, the student pilot landed too fast. The aircraft porpoised, the nose wheel collapsed and the plane nosed over.NTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…NTSB MKC87LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirksville, MODrg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged.NTSB SEA87LA072Accident · No injuriesLimited investigationFinal reportPiper PA 16 · Jean, NVThe plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks.NTSB LAX87FA167Accident · 2 fatalField investigationFinal reportChampion 7ECA · Upland, CAThe pilot took off from his home airport for a sight-seeing, local flight over nearby mountains. Although the rear seat passenger weighed 270 lbs and the aircraft's fuel tanks were assumed to be full, there is no evidence that the pilot calculated the…NTSB FTW87FA090Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Uvalde, TXOn 04-02-87, a Piper PA-38-112, N5540E, owned and operated by southwest Texas junior college, impacted the terrain near Uvalde, TX. The flight was conducted for training purposes. Visual meteorological conditions prevailed at the time of the accident. The…NTSB MIA87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe nose gear collapsed following a hard landing due to the student plts failure to adequately flare the acft.NTSB ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…NTSB DEN87LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over.NTSB NYC87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Du Bois, PAThe student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then…NTSB CHI87FA099Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Attica, INAfter completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that…NTSB MIA87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and…NTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…NTSB NYC87LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJWhen the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said…NTSB MIA87LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe student plt failed to flare the aircraft, landed hard, bounced 2-3 times, then landed on the nose gear causing it to collapse.NTSB MIA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Smyrna Bch, FLWhile in cruise flt at an alt of aprx 800 feet the plt reported that the eng began to lose RPM. Unable to maintain alt a forced landing was made on a road. The acft then ground looped due to contact with scrub oak trees, which resulted in severing of the left…NTSB FTW87LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXAccording to the pilot, the aircraft was substantially damaged when he lost control of the aircraft on touch down.NTSB NYC87LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Old Bridge, NJThe Cessna 152 took off and after becoming airborne, experienced a total loss of power. The student pilot who had made the takeoff turned control of the aircraft over to the flight instructor, who made an emergency landing in a drag strip parking lot which…NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.NTSB BFO87DIG01Accident · No injuriesFinal reportCessna 152C · Gaithersburg, MDWhile taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS.