NTSB investigations: Lycoming 0-235 series, AZ

113 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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND 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.

NTSB LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.Jul 27, 1990 · N94494 · Substantial damageNTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.Sep 21, 1989 · N714VX · 2 aircraft · Substantial damageNTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.Mar 5, 1989 · N25620 · Substantial damageNTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…Aug 29, 1988 · N46972 · Substantial damageNTSB LAX88LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZWhile flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the…Jun 14, 1988 · N49792 · Substantial damageNTSB LAX87LA313Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Buckeye, AZA Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned…Aug 22, 1987 · N2483L · Substantial damageNTSB LAX87LA308Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Ehrenberg, AZWhile on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making…Aug 19, 1987 · N5753H · Substantial damageNTSB 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…May 10, 1987 · N2315V · Substantial damageNTSB LAX87LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZDuring a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…Feb 8, 1987 · N24317 · Substantial damageNTSB LAX87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZDuring a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the…Jan 28, 1987 · N95529 · Substantial damageNTSB LAX87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring a first solo instructional flight, the pilot was taking off from his third touch-and-go when at an altitude of approximately 10 feet AGL the right wing was suddenly rose. The aircraft then veered to the left. The left main gear then collided with a…Oct 22, 1986 · N67752 · Substantial damageNTSB LAX86LA034Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Chandler, AZDuring a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short…Nov 6, 1985 · N42XX · 2 aircraft · Substantial damageNTSB LAX85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sahuarita, AZAcft veered to the right during landing roll on an abandoned airstrip. Right wing contacted a tree aprx 1 ft inboard on right wing tip deforming the main spar. Trees lined both sides of the airstrip.Jan 23, 1985 · N2403A · Substantial damageNTSB LAX85LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZAccording to the flt instructor (CFI), the student plt demonstrated 4 good touch-&-go landings while on a dual instructional flt. The CFI decided to solo the student, who did not hold either a medical or student plt certificate. The CFI told the student to…Jan 22, 1985 · N65273 · Substantial damageNTSB LAX85LA047Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yuma, AZThe plt rptd that while en route to Yuma, AZ, the eng began running rough and subsequently quit. During the landing rollthe acft collided with a dirt embankment and nosed over. Examination of the wreckage disclosed both fuel tanks contained only residual…Nov 13, 1984 · N25854 · Substantial damageNTSB LAX84LA324Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZThe student plt entered the traffic pattern for a touch-&-go landing. During touchdown, the acft bounced. He applied full power & moved the flap selector to the 'up' position, but the acft yawed to the left. It veered off the rwy, traveled onto a graded…May 30, 1984 · N5190B · Substantial damageNTSB LAX84LA291Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZThe acft was landed 200 ft short of the rwy in bushes after the engine hesitated during the plts application of throttle in an attempt to reach the rwy. An FAA inspector found the magneto timing set to 23 plus degrees rather than the prescribed 20 degrees.May 13, 1984 · N2005U · Substantial damageNTSB 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…Jan 2, 1984 · N1050G · DestroyedNTSB LAX83LA402Accident · No injuriesLimited investigationFinal reportCessna 152 · Douglas, AZThe acft crashed during takeoff. The acft was observed in a nose high attitude estimated to be 65 degrees before it stalled at about 30 ft AGL. The right wing dropped and the acft contacted the ground about 250 ft west of the rwy skidded across a taxiway and…Aug 22, 1983 · N25593 · Substantial damageNTSB 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.…Jan 29, 1983 · N48406 · DestroyedNTSB 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…Dec 18, 1982 · N9692L · Substantial damageNTSB 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.Nov 7, 1982 · N69199 · Substantial damageNTSB 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…Oct 19, 1982 · N9897L · Substantial damageNTSB LAX82DA323Accident · No injuriesFinal reportCessna 152 · Chandler, AZStudent pilot during solo flight applied right brake to correct veer and aircraft veered right off runway. Aircraft collided with bushes and nosed over alongside runway. The right brake was locked after accident.Aug 28, 1982 · N47930 · Substantial damageNTSB LAX82DA317Accident · No injuriesFinal reportPiper PA-12 · Phoenix, AZThe aircraft collided with trees during takeoff from a 900 foot, dirt strip. The weather was VFR. The temperature was 102 degrees. No accident report was filed. The pilot had an expired medical certificate.Aug 21, 1982 · N98931 · DestroyedNTSB LAX82DA289Accident · No injuriesFinal reportCessna 152 · Phoenix, AZDuring a dual instructional flight, the instructor pilot (ip) initiated a forced landing for a student by pulling the mixture control out. The forced landing was taken to an altitude of about 400 ft AGL, then the ip pushed the mixture control in and told the…Aug 5, 1982 · N6349M · Substantial damageNTSB LAX82DA228Accident · No injuriesFinal reportCessna 152 · Scottsdale, AZDuring a dual instructional flight, the student pilot and instructor pilot (ip) were practicing touch and go landings. After practicing a soft field approach and landing, the student initiated a short field takeoff with full power and 10 degrees of flaps.…Jun 20, 1982 · N4947H · DestroyedNTSB LAX82DA160Accident · No injuriesFinal reportPiper PA-38 · Willcox, AZStudent pilot on first solo cross-country ground looped during an en route landing. The pilot's flight bag had fallen off the right seat and lodged itself between the rudder pedals. Rudder control was lost.May 6, 1982 · N2393B · Substantial damageNTSB LAX82AA106Accident · 6 fatalFinal reportBoeing KC-135A · Glendale, AZThe USAF KC-135 was on an IFR flt plan & executing a tacan 3L apch to luke afb. The AA-1 had departed sky harbour arpt &had been released by phoenix trsa. The AA-1 was heading westerly in airspace designated as a special traffic area & was required to have…Mar 13, 1982 · KC135 · 2 aircraft · DestroyedNTSB LAX82FA036Accident · 1 fatalField investigationFinal reportPiper PA-22 · Black Canyon Ci, AZThe wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.Jan 5, 1982 · N4696Z · DestroyedNTSB LAX82DUJ11Accident · Minor injuriesClosedCessna 152 · Wikieup, AZNov 22, 1981 · N69196 · Substantial damageNTSB LAX81DUJ77Accident · No injuriesClosedCessna 152 · Phoenix, AZJul 25, 1981 · N24864 · Substantial damageNTSB LAX81DUJ30Accident · No injuriesClosedCessna 152 · Scottsdale, AZJan 26, 1981 · N152MC · Substantial damageNTSB LAX80DUJ66Accident · Minor injuriesClosedCitabria 7GCBC · Safford, AZMay 31, 1980 · N9641S · Substantial damageNTSB LAX80DUJ39Accident · No injuriesClosedCessna 152 · Goodyear, AZMar 15, 1980 · N24864 · Substantial damageNTSB LAX80FUJ27Accident · No injuriesClosedCessna 152 · Goodyear, AZJan 25, 1980 · N48460 · Substantial damageNTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZDec 3, 1979 · N25763 · DestroyedNTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNov 27, 1979 · N48835 · DestroyedNTSB LAX80DUJ04Accident · No injuriesClosedCessna 152 · Springerville, AZOct 1, 1979 · N714XW · Substantial damageNTSB LAX79FUJ57Accident · No injuriesClosedCessna 152 · Phoenix, AZMar 14, 1979 · N67700 · Substantial damageNTSB LAX79DUJ32Accident · No injuriesClosedCessna 152 · Phoenix, AZDec 27, 1978 · N25058 · Substantial damageNTSB LAX79DUJ38Accident · No injuriesClosedGrum Amer AA1-A · Aguila, AZDec 17, 1978 · N9426L · Substantial damageNTSB LAX79DUJ16Accident · No injuriesClosedCessna 152 · Goodyear, AZNov 6, 1978 · N24864 · Substantial damageNTSB LAX78DUJ92Accident · Serious injuriesClosedCessna 152 · Parker, AZAug 20, 1978 · N65542 · DestroyedNTSB LAX78FA062Accident · 2 fatalClosedGrum Amer AA1C · Prescott, AZJul 13, 1978 · N39002 · DestroyedNTSB LAX78FUJ45Accident · No injuriesClosedCitabria 7KCAB · Phoenix, AZApr 16, 1978 · N36414 · 2 aircraft · Substantial damageNTSB LAX77DUJ30Accident · Minor injuriesClosedAmer Avco AA-1A · Tucson, AZFeb 13, 1977 · N6348L · Substantial damageNTSB LAX77DUJ23Accident · Minor injuriesClosedAmer Avco AA1-A · Mesa, AZJan 13, 1977 · N7264L · Substantial damageNTSB LAX76DUK08Accident · No injuriesClosedHickey SE5A · Phoenix, AZSep 12, 1976 · N596 · Substantial damageNTSB LAX76DUJ96Accident · No injuriesClosedLuscombe 8A · Bullhead City, AZJul 5, 1976 · N71751 · Substantial damage