NTSB investigations: Lycoming 0-235 series

119 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “In flight collision with object”. 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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.

NTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.Nov 2, 1992 · N49180 · Substantial damageNTSB FTW92LA219Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ARThe pilot's inadequate visual lookout while maneuvering at low altitude.Aug 27, 1992 · N2659Z · Substantial damageNTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.Jul 25, 1992 · N7712H · Substantial damageNTSB NYC92FA133Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasant Mount, PAThe pilot's decision to perform low altitude maneuvers, resulting in a loss of airplane control and collision with trees. Factors related to the accident were the ostentatious display by the pilot, and his lack of total flight experience.Jun 29, 1992 · N757QN · DestroyedNTSB FTW92LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bryan, TXThe certified flight instructor's misjudging the runway remaining for the aborted landing. Factors were the student pilot's misjudging the touchdown point and inadequate supervision of the approach by the CFI.Jun 19, 1992 · N24611 · Substantial damageNTSB CHI92LA134Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · La Crosse, WIVisual lookout inadequate and diverted attention by the pilot. A factor related to the accident was transmission wires crossing flight path.Apr 27, 1992 · N53988 · Substantial damageNTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.Jun 26, 1991 · N60195 · DestroyedNTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.May 1, 1991 · N6301L · Substantial damageNTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.Feb 16, 1991 · N49123 · Substantial damageNTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.Nov 25, 1990 · N25053 · Substantial damageNTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.Jul 3, 1990 · N25759 · Substantial damageNTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.Jun 8, 1990 · N4755P · Substantial damageNTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.Feb 7, 1990 · N32744 · 2 aircraft · Substantial damageNTSB BFO90LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Front Royal, VAFailure of the instructor pilot (CFI) to maintain proper runway alignment with the runway. Contributing factors were: the student pilot's high and fast approach, the cfi's delay in initiating remedial action, the crosswind, and the runwaylight.Nov 14, 1989 · N96096 · Substantial damageNTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.Nov 7, 1989 · N6449M · Substantial damageNTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…Sep 30, 1989 · N24995 · Substantial damageNTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).Sep 26, 1989 · N3882M · Substantial damageNTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.May 18, 1989 · N24984 · Substantial damageNTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.Apr 22, 1989 · N2601A · Substantial damageNTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.Mar 7, 1989 · N8350V · Substantial damageNTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…Jul 17, 1988 · N295C · 2 aircraft · Minor damageNTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…Jun 27, 1988 · N23TW · Substantial damageNTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…Jun 19, 1988 · N95056 · Substantial damageNTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.Feb 29, 1988 · N21BL · Substantial damageNTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.Feb 6, 1988 · N5450Q · Substantial damageNTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…Nov 27, 1987 · N4523Z · Substantial damageNTSB ANC88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip.Oct 10, 1987 · N3651N · Substantial damageNTSB ANC87LA151Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Salcha, AKThe private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind…Sep 5, 1987 · N4183Y · Substantial damageNTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…Aug 5, 1987 · N2644G · Substantial damageNTSB 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…May 6, 1987 · N761ED · DestroyedNTSB 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.May 5, 1987 · N49752 · Substantial damageNTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…Jan 17, 1987 · N2430G · DestroyedNTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…Dec 27, 1986 · N78475 · DestroyedNTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…Dec 2, 1986 · N4784A · Substantial damageNTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…Nov 18, 1986 · N68328 · DestroyedNTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.Aug 30, 1986 · N5159T · Substantial damageNTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.Jul 10, 1986 · N2NH · Substantial damageNTSB LAX86LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Snellings, CAThe CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was…Apr 13, 1986 · N5150B · Substantial damageNTSB DEN86LA052Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA-1A Yankee · Cloudcroft, NMThe plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg…Dec 23, 1985 · N9201L · Substantial damageNTSB CHI86LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIThe acft struck wires during the recovery phase of a simulated forced landing apch. The plt continued the flt for aprx 1 hr after the wire strike and landed without incident. Examination of the acft revealed replacement of the right wing was needed.Nov 8, 1985 · N24457 · Substantial damageNTSB ANC86LAG05Accident · Minor injuriesFinal reportBeech BE77 · Hope, AKThe acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.Oct 29, 1985 · N6753X · Substantial damageNTSB 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…Aug 18, 1985 · N49282 · Substantial damageNTSB 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…Jun 30, 1985 · N757MP · Substantial damageNTSB 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…Apr 8, 1985 · N757QK · Substantial damageNTSB ANC85LA008Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Theodore River, AKThe acft crashed during a go-around attempt at Theodore River located 35 miles southwest of anchorage, AK. According to the plt, after landing on a gravel oil pad he realized that the acft would not stop before going over the edge into a swamp. He applied…Oct 19, 1984 · N78449 · Substantial damageNTSB CHI85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · St. Cloud, MNThe plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around.Oct 13, 1984 · N5221H · Substantial damageNTSB 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.…Aug 12, 1984 · N6321M · Substantial damageNTSB 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…Jul 29, 1984 · N15EZ · DestroyedNTSB 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…Jun 18, 1984 · N6273M · DestroyedNTSB NYC84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 152 · West Milford, NJThe plt stated that during the initial climb of a max performance takeoff the best angle rate of climb could not be maintained. The acft contacted trees and subsequently crashed in an abandoned parking lot.May 18, 1984 · N67809 · Substantial damage