NTSB investigations: Lycoming 0-290 series, 1996

5 cases on aircraft whose registry engine model is Lycoming 0-290 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-290 series, 1996 per year, 1982–2026: 48 cases
19826
19836
19846
19855
19861
19882
19892
19901
19911
19931
19965
19971
19982
19991
20001
20012
20021
20031
20061
20072

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\") = 1996
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506')
      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 ATL97LA003Accident · Serious injuriesLimited investigationFinal reportHarper W-8 Tailwind · Macclenny, FLthe pilot's inadequate preflight inspection, which resulted in loss of engine power due to fuel contamination.Oct 13, 1996 · N91323 · Substantial damageNTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.Oct 5, 1996 · N5749H · DestroyedNTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.Sep 22, 1996 · N2982 · Substantial damageNTSB NYC96LA109Accident · Minor injuriesLimited investigationFinal reportMcCall WATCHA-MCCALL-IT · Steamburg, NYthe pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…May 18, 1996 · N111MC · Substantial damageNTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…Jan 8, 1996 · N86S · Destroyed