OpenAirDocs.org

NTSB investigations: Lycoming 0-235 series, MD

6 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

19832026

Where

Open the map

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\" = 'MD' 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 BFO95LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDSeparation of the steering linkages on the nosegear which resulted in the pilot being unable to maintain directional control during landing and subsequent on ground collision with a ditch.Dec 27, 1994 · N93042 · Substantial damageNTSB BFO87DIG05Accident · No injuriesFinal reportCessna 152 · Baltimore, MDThe student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was…Jun 7, 1987 · N48935 · Substantial damageNTSB BFO87DIG01Accident · No injuriesFinal reportCessna 152C · Gaithersburg, MDWhile taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS.Feb 10, 1987 · N25846 · Substantial damageNTSB BFO87LA019Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up…Feb 7, 1987 · N94197 · Substantial damageNTSB BFO85LA020Accident · No injuriesLimited investigationFinal reportBellanca 7-ECA Citabria · Annapolis, MDDuring final apch to rwy 30, a go-around was executed due to a shift in wind direction, according to the plt. He subsequently entered the pattern for rwy 12, made a full stop lndg with no difficulties, and took off again for a planned touch and go on the next…Mar 3, 1985 · N8682V · Substantial damageNTSB ATL83LA306Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe acft nosed over after a solo student pilot lost directional control during landing. The wind was from the south at 5 to 10 KTS. Because of the wind and turbulence the CFI had flown one pattern with him. The student made the landing without assistance. The…Aug 1, 1983 · N24814 · Substantial damage