NTSB investigations: Lycoming 0-235 series, 2002

10 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - in flight”. 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, 2002 per year, 1982–2026: 233 cases
19828
198319
198418
19857
198613
198710
19889
198915
19909
19918
19927
19934
19947
199510
19966
19976
19983
199910
200010
20017
200210
20037
20047
20059
200610
20074

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 year(c.\"eventDate\") = 2002
    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\" = 250))
  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 LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.Dec 28, 2002 · N777KL · Substantial damageNTSB LAX03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fallon, NVThe pilot's failure to maintain control of the airplane during a low altitude maneuver. Contributing factors were the inadequate passenger briefing regarding the flight controls and the passenger's inadvertent use of the rudder.Dec 13, 2002 · N87800 · Substantial damageNTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.Nov 8, 2002 · N4835B · Substantial damageNTSB NYC02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's failure to maintain airspeed and the flight instructor's delayed remedial action, which resulted in an inadvertent stall during a simulated forced landing. A factor was the rising terrain.Aug 5, 2002 · N89044 · Substantial damageNTSB ANC02FA070Accident · 2 fatalField investigationFinal reportZawada Super Cuby · Cantwell, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, and subsequent collision with terrain. A contributing factor was the pilot's impairment from the effects of prescription painkilling drugs.Jul 4, 2002 · N43Z · Substantial damageNTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.Jun 26, 2002 · N5684L · Substantial damageNTSB LAX02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kingman, AZthe CFI's failure to obtain/maintain an adequate airspeed during an attempted go-around, which resulted in a stall/mush condition. The high density altitude, tailwind, inadequate supervision, and overgross weight condition were factors.May 28, 2002 · N4326E · Substantial damageNTSB CHI02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hastings, MIThe failure to attain airspeed, inadequate supervision of the flight, and delayed remedial action which resulted in a stall.May 4, 2002 · N2494B · Substantial damageNTSB LAX02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Tehachapi, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.Jan 11, 2002 · N4895Z · Substantial damageNTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.Jan 7, 2002 · N25441 · Substantial damage