NTSB investigations: Lycoming 0-235 series, CO

7 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Hard landing”. 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
NTSB investigations: Lycoming 0-235 series, CO per year, 1983–2026: 7 cases
19832
19861
19882
19951
20001

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\" = 'CO' 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\" = 200))
  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 DEN00LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Erie, COInadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…Sep 29, 2000 · N9622L · Substantial damageNTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.May 14, 1995 · N67492 · Substantial damageNTSB DEN89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe student plt was practicing touch and go landings during an unsupervised solo flight. Runway 26 was in use, with winds reported as 320 deg at 5 KTS. At the first landing, the acft touched down nose first, thirty feet left of the center line. The acft…Dec 4, 1988 · N4782B · Substantial damageNTSB DEN88LA187Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leadville, COThe student plt was lost during a solo cross country instructional flight. After landing and refueling at Leadville, Colorado, he attempted to fly through a mountain pass towards his destination. He climbed the acft to 12,000 and tried to continue the climb.…Aug 19, 1988 · N93538 · Substantial damageNTSB DEN86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAccording to the student plt, he flared too high during landing & landed hard, collapsing the nose gear.May 1, 1986 · N94703 · Substantial damageNTSB DEN84LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe acft collided with a snow bank during landing and nosed down. This was the student's first solo landing. The studentthought the landing was all right except that the acft kept going to the left in spite of right rudder. Some power was still on the acft.…Dec 18, 1983 · N93271 · Substantial damageNTSB DEN83LA192Accident · No injuriesLimited investigationFinal reportCessna 152 · Akron, COThe acft nose gear collapsed during landing. The plt said he made a normal landing and when the nose was lowered the gear shook violently and collapsed. A witness, who is a CFI said the acft landed and bounce about 3 times and came down hard on the nose gear.…Aug 18, 1983 · N4877P · Substantial damage