NTSB investigations: Lycoming 0-235 series, CA

6 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power”. 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, CA per year, 1983–2026: 6 cases
19831
19941
19952
20031
20041

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\" = 'CA' 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\" = 350))
  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 LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.Apr 9, 2004 · N25645 · Substantial damageNTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.Oct 22, 2003 · N5968L · Substantial damageNTSB LAX96LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAloss of engine power for an undetermined reason.Nov 28, 1995 · N6349M · DestroyedNTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.Jun 10, 1995 · N48934 · DestroyedNTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.Aug 19, 1994 · N3415M · Substantial damageNTSB LAX83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Guadalupe, CAAfter practicing a series of power-on departure stalls at 3500 feet, the plt climbed to 6500 feet and practiced several power-off approach/landing stalls. At about 3000 feet the engine sputtered and quit. The plt was unable to restore power and made an…Apr 8, 1983 · N5542H · Substantial damage