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.
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" 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 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.NTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…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 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 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 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 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.NTSB 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.NTSB 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…NTSB 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.…NTSB 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.NTSB 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…NTSB 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.NTSB LAX82DUJ11Accident · Minor injuriesClosedCessna 152 · Wikieup, AZNTSB LAX81DUJ77Accident · No injuriesClosedCessna 152 · Phoenix, AZNTSB LAX81DUJ30Accident · No injuriesClosedCessna 152 · Scottsdale, AZNTSB LAX80DUJ66Accident · Minor injuriesClosedCitabria 7GCBC · Safford, AZNTSB LAX80DUJ39Accident · No injuriesClosedCessna 152 · Goodyear, AZNTSB LAX80FUJ27Accident · No injuriesClosedCessna 152 · Goodyear, AZNTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZNTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNTSB LAX80DUJ04Accident · No injuriesClosedCessna 152 · Springerville, AZNTSB LAX79FUJ57Accident · No injuriesClosedCessna 152 · Phoenix, AZNTSB LAX79DUJ32Accident · No injuriesClosedCessna 152 · Phoenix, AZNTSB LAX79DUJ38Accident · No injuriesClosedGrum Amer AA1-A · Aguila, AZNTSB LAX79DUJ16Accident · No injuriesClosedCessna 152 · Goodyear, AZNTSB LAX78DUJ92Accident · Serious injuriesClosedCessna 152 · Parker, AZNTSB LAX78FA062Accident · 2 fatalClosedGrum Amer AA1C · Prescott, AZNTSB LAX78FUJ45Accident · No injuriesClosedCitabria 7KCAB · Phoenix, AZNTSB LAX77DUJ30Accident · Minor injuriesClosedAmer Avco AA-1A · Tucson, AZNTSB LAX77DUJ23Accident · Minor injuriesClosedAmer Avco AA1-A · Mesa, AZNTSB LAX76DUK08Accident · No injuriesClosedHickey SE5A · Phoenix, AZNTSB LAX76DUJ96Accident · No injuriesClosedLuscombe 8A · Bullhead City, AZ