NTSB investigations: Lycoming 0-235 series, AZ

12 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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 per year

19822026
NTSB investigations: Lycoming 0-235 series, AZ per year, 1982–2026: 12 cases
19822
19872
19881
19901
19931
19941
19971
20021
20031
20041

Latest cases

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')
      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\" = 260))
  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 LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.Oct 23, 2004 · N856ER · Substantial damageNTSB LAX03LA071Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZfailure of the pilot to maintain directional control of the airplane during landing.Jan 18, 2003 · N2005U · Substantial damageNTSB LAX03LA002Accident · No injuriesLimited investigationFinal reportKline KSE5A · Sedona, AZthe pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…Oct 7, 2002 · N589D · Substantial damageNTSB LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.Oct 28, 1997 · N49788 · Substantial damageNTSB LAX94LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe student pilot's failure to maintain directional control of the aircraft.May 8, 1994 · N4594B · Substantial damageNTSB LAX93LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe student pilot's failure to maintain directional control of the aircraft and his improper remedial action to correct the situation. A factor in the accident was the student's lack of total experience.Mar 19, 1993 · N89681 · Substantial damageNTSB 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 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 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 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 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 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 damage