NTSB investigations: Lycoming 0-235 series, NC

5 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19932026
NTSB investigations: Lycoming 0-235 series, NC per year, 1993–2026: 5 cases
19931
19941
19961
20021
20061

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\" = 'NC' 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\" = 353))
  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 ATL06CA091Accident · Serious injuriesData collectionFinal reportKearn Breezy · Dover, NCThe pilot's failure to ensure the airplane contained adequate fuel for the flight resulting in a loss of engine power due to fuel exhaustion.Jun 12, 2006 · N15WK · Substantial damageNTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.Jun 16, 2002 · N68437 · Substantial damageNTSB ATL96LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gatesville, NCThe pilot's inadequate preflight inspection which resulted in engine stoppage due to water contamination in the fuel system. A factor was the lack of suitable terrain for a forced landing.Jul 17, 1996 · N7168K · Substantial damageNTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…Nov 29, 1994 · N9260L · DestroyedNTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.Jan 14, 1993 · N25865 · Substantial damage