NTSB investigations: Lycoming 0-235 series, CA

16 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “In flight collision with terrain/water”. 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, CA per year, 1982–2026: 16 cases
19821
19832
19841
19852
19861
19871
19902
19951
19971
19981
19991
20021
20041

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 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')
      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\" = 230))
  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 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 LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.Jan 5, 2002 · N24223 · DestroyedNTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.Mar 22, 1999 · N67821 · DestroyedNTSB LAX99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAContinued VFR flight by the pilot into instrument meteorological conditions (IMC) at night over mountainous terrain. The pilot's use of unclear language when stating his intentions to air traffic control was a factor.Oct 2, 1998 · N957AF · DestroyedNTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…Apr 6, 1997 · N64845 · DestroyedNTSB LAX95LA179Accident · 1 fatalLimited investigationFinal reportCessna 152 · Palos Verdes, CAthat the pilot initiated the flight into known adverse weather, and inadvertent flight into instrument meteorological conditions.Apr 28, 1995 · N49058 · DestroyedNTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…Oct 29, 1990 · N5052Z · DestroyedNTSB LAX90DVG05Accident · No injuriesFinal reportLerstang Long EZE · Willows, CAThe pilots misjudgement of the correct landing spot and allowed the aircraft to descend into the ground without taking proper and timely corrective action.May 3, 1990 · N2069G · Substantial damageNTSB LAX87FA167Accident · 2 fatalField investigationFinal reportChampion 7ECA · Upland, CAThe pilot took off from his home airport for a sight-seeing, local flight over nearby mountains. Although the rear seat passenger weighed 270 lbs and the aircraft's fuel tanks were assumed to be full, there is no evidence that the pilot calculated the…Apr 2, 1987 · N9655S · DestroyedNTSB LAX86FA289Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Santa Paula, CAAfter working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…Jul 13, 1986 · N6339L · DestroyedNTSB LAX86FA024Accident · 1 fatalField investigationFinal reportChampion 7ECA · Seal Beach, CABased upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…Oct 27, 1985 · N7547F · Substantial damageNTSB LAX85FVG01Accident · No injuriesFinal reportCessna 152 · Lower Lake, CAThe acft contacted trees while attempting to land at hoberg airstrip.Apr 2, 1985 · N4602L · Substantial damageNTSB LAX85FA074Accident · 2 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe acft departed on a local primary dual instructional flt at about 1030 hrs. The student was in a pre-solo phase & the lesson was to consist of a review of high airwork. The instructor (CFI) had recently become interested in & was working on aerobatics. At…Dec 16, 1984 · N95337 · DestroyedNTSB LAX83FA371Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasanton, CAThe acft crashed in a steep nose down attitude in hilly terrain. Debris was scattered for about 100 ft but the acft did not travel after initial impact. The fuel tanks were ruptured and no fuel remained. The sheriff's deputies said no odor of fuel was noted…Jul 31, 1983 · N6599L · DestroyedNTSB LAX83LA272Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Temecula, CAThe student & instructor (CFI) were on a dual instructional flt in preparation for the student's 1st solo flt. After returning from flt in the local area, they entered the traffic pattern to land on rwy 12. During a final apch to land, the student flew the…Jun 4, 1983 · N2334V · Substantial damageNTSB LAX82DA146Accident · 1 fatalFinal reportPiper PA-38-112 · Apple Valley, CAWitnesses observed the aircraft to be gliding on final approach with the engine at idle when it abruptly pitched nose down and struck the ground. The engine and both leading edges of the wings contacted the ground at the same time with no turning movement.…Apr 22, 1982 · N24082 · Destroyed