NTSB investigations: Lycoming 0-235 series, 2003, CA

7 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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

19642026
NTSB investigations: Lycoming 0-235 series, 2003, CA per year, 1964–2026: 494 cases
19647
19654
19666
19676
19687
19696
19707
19711
19727
19732
19745
19758
19765
197713
197812
197917
198022
198111
198213
198325
198416
198515
198610
198710
198816
198913
199010
19918
19923
199310
199412
199515
19968
19976
19986
19994
200012
20016
20029
20037
200410
20055
20067
200711
20089
200911
20103
20114
20124
201311
20145
20165
20172
20182
20195
20206
20213
20225
20231
20241
20252
20262

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'CA' 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'))
  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 LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…Dec 27, 2003 · N53879 · Substantial damageNTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.Oct 22, 2003 · N5968L · Substantial damageNTSB LAX03CA269Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Joshua Tree, CAthe student pilot failed to maintain directional control of the airplane during the takeoff roll.Aug 30, 2003 · N2318L · Substantial damageNTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.Aug 1, 2003 · N972V · Substantial damageNTSB LAX03LA148Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pala, CAthe dual student's delay in executing the proper recovery procedures and improper retraction of the flaps, the CFI's inadequate supervision during the recovery to normal flight, the CFI's delayed remedial action, and the failure of both pilots to maintain an…May 6, 2003 · N48796 · Substantial damageNTSB LAX03LA132Accident · Minor injuriesLimited investigationFinal reportDeer/Reffalt BD · Greenfield, CAThe loss of engine power during cruise flight for undetermined reasons.Apr 7, 2003 · N4365K · Substantial damageNTSB LAX03LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Salinas, CAThe student pilot's inadequate compensation and his failure to maintain directional control. Contributing factors were wet and dirt terrain.Jan 16, 2003 · N25562 · Substantial damage