NTSB investigations: Lycoming 0-235 series, 2004

11 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

19822026
NTSB investigations: Lycoming 0-235 series, 2004 per year, 1982–2026: 159 cases
198210
19838
19844
19853
19865
19874
19885
19891
19905
19918
19926
19933
19943
19953
19963
19977
199810
19995
20009
20017
20024
20039
200411
200510
20065
200711

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\") = 2004
    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 DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.Nov 25, 2004 · N234BW · Substantial damageNTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.Oct 30, 2004 · N57388 · Substantial damageNTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.Sep 16, 2004 · N4647Z · Substantial damageNTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.Sep 11, 2004 · N35FD · Substantial damageNTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…Jul 25, 2004 · N5667L · DestroyedNTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.Jul 7, 2004 · N2489M · Substantial damageNTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..May 10, 2004 · N24007 · Substantial damageNTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.May 9, 2004 · N2368M · Substantial damageNTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.Apr 9, 2004 · N25645 · Substantial damageNTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.Mar 21, 2004 · N4468V · Substantial damageNTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.Feb 24, 2004 · N4669L · Substantial damage