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 object”. 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
19861
19881
19901
19921
19931
19941
19971
20001
20021
20041
20061
20071

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\" = 220))
  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 SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.Apr 17, 2007 · N49902 · DestroyedNTSB LAX06LA235Accident · Minor injuriesLimited investigationFinal reportAlfred Long-EZ · Hesperia, CAThe pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.Jul 11, 2006 · N1014A · Substantial damageNTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.Oct 4, 2004 · N24373 · Substantial damageNTSB LAX02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.Apr 4, 2002 · N69000 · Substantial damageNTSB LAX00LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Borrego Springs, CAThe pilot's inadequate compensation for a crosswind condition during initial takeoff climb, which resulted a failure to maintain alignment and the airplane drifting into a nearby tree.May 15, 2000 · N25213 · Substantial damageNTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…Oct 12, 1997 · N11860 · DestroyedNTSB LAX94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Warner Springs, CAthe pilot's inadequate visual lookout for livestock during takeoff.Aug 9, 1994 · N25871 · Substantial damageNTSB LAX93LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Hesperia, CAThe pilot in command not maintaining a proper glidepath. Factors pertaining to this accident were: the pilot in command not obtaining a weather forecast for the return flight, and the lack of total experieince in night flying.Sep 16, 1993 · N49813 · Substantial damageNTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.Nov 2, 1992 · N49180 · Substantial damageNTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.Feb 7, 1990 · N32744 · 2 aircraft · Substantial damageNTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…Jun 27, 1988 · N23TW · Substantial damageNTSB LAX86LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Snellings, CAThe CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was…Apr 13, 1986 · N5150B · Substantial damageNTSB LAX84LA438Accident · No injuriesLimited investigationFinal reportCessna 152 · Cressey, CAWitnesses observed two acft making multiple low passes down the river. Each acft was seen flying under 3 electrical power lines at least 3 times. On the last pass, according to local law enforcement officers, one acft struck and severed all 3 power lines.…Aug 12, 1984 · N6321M · Substantial damageNTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…Jul 22, 1983 · N5737Z · DestroyedNTSB LAX83FVG13Accident · Serious injuriesFinal reportChampion 7ECA · Shingle Springs, CAThe acft collided with an oak tree while maneuvering at low alt. The weather was VMC. The pilot stated that he was flying to maintain a battery charge. He said he climbed to about 1600-1700 ft MSL and flew southeast. The average elevation along this route is…Jul 10, 1983 · N1882G · DestroyedNTSB LAX82DA214Accident · No injuriesFinal reportCessna 152 · San Andreas, CAThe student pilot was a foreign national that was scheduled for a solo cross-country flight. He departed with a passenger that was a private pilot with a ground instructor rating. According to the passenger, the student had not flown for 8 days and was afraid…Jun 6, 1982 · N6341M · Substantial damage