NTSB investigations: Lycoming 0-235 series, 2004

61 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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, newest first

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\") = 2004
    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'))
  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 ATL04LA087Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development Alarus CH2T · Bay Minette, ALThe pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.Mar 28, 2004 · N605AM · Substantial damageNTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.Mar 21, 2004 · N4468V · Substantial damageNTSB LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…Mar 19, 2004 · N2421D · DestroyedNTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.Mar 13, 2004 · N6175L · Substantial damageNTSB FTW04LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Sugar Land, TXThe pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.Mar 2, 2004 · N2588A · Substantial damageNTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.Feb 29, 2004 · N86715 · Substantial damageNTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.Feb 24, 2004 · N7321K · Substantial damageNTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.Feb 24, 2004 · N4669L · Substantial damageNTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…Feb 12, 2004 · N66952 · Substantial damageNTSB LAX04CA134Accident · No injuriesData collectionFinal reportBellanca 7ECA · Groveland, CAthe pilot's failure to maintain a proper glide path and misjudged landing flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, resulting in a loss of directional control and collision with terrainFeb 7, 2004 · N5032G · Substantial damageNTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.Jan 11, 2004 · N67844 · Substantial damage