NTSB investigations: Lycoming 0-235 series, 2001

7 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, 2001 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\") = 2001
    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 CHI02LA046Accident · No injuriesLimited investigationFinal reportMiller Lancair 235 · Tecumseh, MIThe pilot's failure to maintain aircraft control during the takeoff. Factors relating to the accident were the crosswind and the wind gusts.Dec 5, 2001 · N417EM · Substantial damageNTSB MIA02FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Poplarville, MSThe pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…Nov 16, 2001 · N89645 · DestroyedNTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.Aug 17, 2001 · N757PZ · Substantial damageNTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.Aug 9, 2001 · N6182R · Substantial damageNTSB CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.Jul 23, 2001 · N23475 · DestroyedNTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.Jul 10, 2001 · N9616U · DestroyedNTSB MIA01LA149Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Greensboro, NCthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with trees.May 30, 2001 · N1669G · Substantial damage