NTSB investigations: Lycoming 0-235 series, 2000

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, 2000 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\") = 2000
    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 LAX01FA024Accident · 2 fatalField investigationFinal reportCessna 152 · Alpine, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.Oct 24, 2000 · N24961 · DestroyedNTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.Oct 23, 2000 · N9375L · Substantial damageNTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…Jul 4, 2000 · N89043 · DestroyedNTSB IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.Jun 4, 2000 · N6340L · Substantial damageNTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.May 23, 2000 · N5712L · Substantial damageNTSB SEA00LA079Accident · No injuriesLimited investigationFinal reportMorton Christavia Mark I · Salem, ORThe pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…May 1, 2000 · N1143L · Substantial damageNTSB FTW00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Decatur, TXThe instructor pilot's failure to maintain the minimum controllable airspeed during a simulated emergency approach, which resulted in a stall.Mar 28, 2000 · N94912 · Substantial damageNTSB ANC00LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.Mar 19, 2000 · N96082 · Substantial damageNTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.Mar 15, 2000 · N569JH · Substantial damageNTSB FTW00LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.Mar 1, 2000 · N48821 · Substantial damage