NTSB investigations: Lycoming 0-235 series, AZ

5 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

19852026
NTSB investigations: Lycoming 0-235 series, AZ per year, 1985–2026: 5 cases
19851
19881
19911
19931
20011

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\" = 'AZ' 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 LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.Apr 18, 2001 · N5377M · Substantial damageNTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.Aug 21, 1993 · N6596P · Substantial damageNTSB LAX91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe student pilot's improper bounced landing recovery technique. A factor in the accident was the pilot's limited flight experience.Jan 24, 1991 · N93574 · Substantial damageNTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…Aug 29, 1988 · N46972 · Substantial damageNTSB LAX85LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZAccording to the flt instructor (CFI), the student plt demonstrated 4 good touch-&-go landings while on a dual instructional flt. The CFI decided to solo the student, who did not hold either a medical or student plt certificate. The CFI told the student to…Jan 22, 1985 · N65273 · Substantial damage