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

10 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, 2004, 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\") = 2004
    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 LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.Dec 31, 2004 · N321EZ · Substantial damageNTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.Oct 26, 2004 · N4734B · Substantial damageNTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.Oct 17, 2004 · N5272H · Substantial damageNTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.Oct 4, 2004 · N24373 · Substantial damageNTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.Aug 23, 2004 · N53879 · 2 aircraft · DestroyedNTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.Apr 9, 2004 · N25645 · Substantial damageNTSB LAX04CA181Accident · No injuriesData collectionFinal reportPiper PA-38-112 · McKinleyville, CAa loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…Apr 8, 2004 · N2609F · Substantial damageNTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.Mar 13, 2004 · N6175L · Substantial damageNTSB LAX04CA134Accident · No injuriesData collectionFinal reportBellanca 7ECA · Groveland, CAthe pilot's failure to maintain a proper glide path and misjudged landing flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, resulting in a loss of directional control and collision with terrainFeb 7, 2004 · N5032G · Substantial damageNTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.Jan 11, 2004 · N67844 · Substantial damage