NTSB investigations: Lycoming 0-235 series, VA

5 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

19862026
NTSB investigations: Lycoming 0-235 series, VA per year, 1986–2026: 5 cases
19861
19971
19991
20011
20051

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\" = 'VA' 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 IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.Mar 16, 2005 · N64986 · Substantial damageNTSB NYC02LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Roanoke, VAThe failure of the pilot ensure the proper position of the fuel selector which resulted in fuel starvation. Factors were the improper placement of the fuel selector valve tank index, and the improper in-flight decision of the pilot to change tanks in…Nov 3, 2001 · N5207Z · Substantial damageNTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.Aug 19, 1999 · N49014 · Substantial damageNTSB IAD97LA097Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Culpeper, VAThe pilot's inadequate preflight planning which fail to provide an adequate fuel supplyJul 4, 1997 · N9883L · Substantial damageNTSB BFO86LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Mappsville, VAThe plt experienced a drop in engine power during cruise flight. He applied carburetor heat and power was regained. A precautionary landing was made at nearby accomack co arpt. Several engine runups were done and there was no problem detected. He departed the…Sep 10, 1986 · N64934 · Substantial damage