NTSB investigations: Lycoming 0-235 series

70 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, newest first

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.\"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 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 MIA85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLThe rated pilot and certified flt instructor stated that they were practicing agricultural dives and turns. During a dive, the pilot pulled out of the dive at about 5 feet and the aircraft contacted sawgrass and crashed. The instructor pilot initially stated…Oct 2, 1984 · N2427P · Substantial damageNTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…Aug 6, 1984 · N9549T · Substantial damageNTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…Aug 5, 1984 · N5406B · Substantial damageNTSB ANC84LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore Creek, AKThe plt stated that during takeoff ground run the wind shifted to a right tailwind & lift off was initiated to clear the trees. He attempted to land on the runway, however the nose wheel struck the grass & the acft flipped over upside down.Aug 1, 1984 · N6332P · Substantial damageNTSB ANC84LA108Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Knik Glacier, AKThe acft was climbing as the plt 'flew up' a Glacier. He stated that before the accident, he had made a check of the instruments & outside references & had determined that his rate of climb was adequate to easily clear the ridge. He stated, 'the next thing I…Jun 30, 1984 · N6167Q · Substantial damageNTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…Jan 27, 1984 · N3829D · DestroyedNTSB ANC83LA169Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Eagle River, AKThe acft collided with rising terrain while maneuvering during a training flt at an alt of 3000 ft MSL. The acft was destroyed and the 2 occupants seriously injured. The CFI stated that there were no mechanical malfunctions which contributed to the accident…Sep 11, 1983 · N94547 · DestroyedNTSB ATL83LA349Accident · Serious injuriesLimited investigationFinal reportJohnston Long E-Z · Pell City, ALThe acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff…Sep 5, 1983 · N82CJ · Substantial damageNTSB SEA83FYA02Accident · 1 fatalFinal reportPiper PA-22-108 · Nr Jackpot, NVPrior to the accident, the acft was observed maneuvering in the vicinity. Subsequently, the acft collided with the ground while it was being flown under a 40 ft power line. Both of the occupants had student plt certificates that had expired. One of the…Aug 14, 1983 · N5533Z · Substantial damageNTSB 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 CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…Jun 8, 1983 · N2563F · Substantial damageNTSB 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 FTW83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Krum, TXThe acft collided with the ground during a simulated forced landing and go-around. The acft's left main landing gear wassheared and the left wing dragged during ground contact. The CFI had given the student a simulated forced landing during the approach and…May 1, 1983 · N2495K · Substantial damageNTSB LAX83FUJ09Accident · 1 fatalFinal reportGrumman American AA-1B · Cornville, AZThe pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…Dec 18, 1982 · N9692L · Substantial damageNTSB DEN82DA158Accident · No injuriesFinal reportCessna 152 · Avondale, COThe student pilot was on a private pilot check flight with a designated flight examiner. While demonstrating balked landings, the go-around procedure was improper. Therefore, the examiner asked the student to repeat the procedure on the next approach (a short…Aug 9, 1982 · N757ES · Substantial damageNTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…Jul 5, 1982 · N4698L · DestroyedNTSB ANC82FAG30Accident · 2 fatalFinal reportPiper PA-18 · Near Dillingham, AKThe acft impacted a side of a mountain Near horseshoe pass at an elevation of 250 ft above sea level. The accident occurred during the hours of daylight with VMC prevailing.Jun 8, 1982 · N278T · DestroyedNTSB 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