NTSB investigations: Lycoming 0-235 series, 1990

11 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

19822026
NTSB investigations: Lycoming 0-235 series, 1990 per year, 1982–2026: 268 cases
198213
198321
198412
198512
198613
198711
198815
198917
199011
199115
199213
199318
19949
19955
199610
199711
19988
19995
200013
20016
20025
20038
20045
20055
20063
20074

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 year(c.\"eventDate\") = 1990
    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 MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.Dec 20, 1990 · N25945 · Substantial damageNTSB MIA91LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Palmetto, FLPoor preflight planning by the pilot due to his failure to purchase fuel before departure resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the inaccurate fuel gauges.Dec 16, 1990 · N67334 · Substantial damageNTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.Oct 19, 1990 · N23665 · Substantial damageNTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.Sep 15, 1990 · N67758 · Substantial damageNTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.Jul 18, 1990 · N6095M · DestroyedNTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.Jul 3, 1990 · N25899 · Substantial damageNTSB SEA90LA095Accident · 1 fatalLimited investigationFinal reportGrace Long EZ · La Grande, ORLoss of engine power due to fuel contamination which resulted from the pilot's inadequate preflight inspection of the aircraft.Jun 11, 1990 · N9175Y · DestroyedNTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.Apr 18, 1990 · N91309 · DestroyedNTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.Mar 16, 1990 · N4590P · Substantial damageNTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.Mar 14, 1990 · N66949 · Substantial damageNTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.Feb 24, 1990 · N48049 · Substantial damage