NTSB investigations: Lycoming I0360 SER A&C

60 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C, where the first occurrence was “Loss of control - in flight”. 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 ('41511')
      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\" = 250))
  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 LAX86DVA04Accident · 1 fatalFinal reportGlen Davis Glasair · Chinese Camp, CAA glasair homebuilt aircraft collided with a barn shortly after takeoff on a night time business trip. The aircraft departed from the extreme left side of the runway which had a high growth of vegetation. The aircraft was observed to be about 40 to 50 ft…Mar 23, 1986 · N84GD · DestroyedNTSB DEN85FTE09Accident · Minor injuriesFinal reportConover'S Steen Skybolt · Strasburg, COThe acft was observed during landing by a witness who said that the acft bounced once before nosing over to an inverted position on the rt side of the rwy. Investigation revealed that the rt landing gear was wrapped tight with weeds that bordered the side.…Sep 5, 1985 · N200FC · Substantial damageNTSB LAX85LA288Accident · Serious injuriesLimited investigationFinal reportStarduster II · Glendale, AZThe plt crossed the arpt at midfield and made a left turn for a close in downwind. Witnesses estimated that he made a 180 deg descending turn to final. While on final the plt observed another acft which was already on final slightly aheadand slightly below…Jun 23, 1985 · N17RM · DestroyedNTSB SEA85LA130Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Truckee, CAContrary to common departure practice, the pilot commenced his takeoff from the lake headed westbound and towards rising terrain. Additionally, he failed to use all the takeoff surface available. The density altitude at donner lake at the time of the accident…Jun 9, 1985 · N80030 · DestroyedNTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…Sep 19, 1984 · N201RT · DestroyedNTSB CHI83LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Warren, MNThe pilot was practicing a short field takeoff. The acft came off the ground nose high at low airspeed. At about 40 feetagl the pilot retracted the landing gear and while doing this he inadvertantly raised the flaps. The acft mushed back tothe surface. The…Mar 28, 1983 · N1170G · Substantial damageNTSB MIA83FA093Accident · Serious injuriesField investigationFinal reportMooney M20J · Tampa, FLThe accident occurred during an instrument takeoff in IMC. The sky was obscured & visibility zero. After lift-off the acft began to settle. The plt stated he aggravated the situation by advancing down trim which was his routine to establish a 5 deg climb…Mar 20, 1983 · N1166U · DestroyedNTSB SEA83FA045Accident · 1 fatalField investigationFinal reportCromwell/Pitts S-1S · Athol, IDThe plt tookoff with an estimated 7 gal of fuel on board. While performing aerobatic maneuver, he entered a vertical, climbing, power-on maneuver. Witnesses reported that the acft climbed to zero airspeed at about 2500 ft AGL. Reportedly, the acft then slid…Jan 24, 1983 · N56T · DestroyedNTSB LAX82DA204Accident · No injuriesFinal reportBeech C-24R · Big Bear, CAA witness observed the aircraft to pitch and roll while on final approach. At about 30-40 feet above the ground the nose pitched downward and the aircraft collided with the runway. Moderate turbulence and gusty winds were reported on final approach.May 31, 1982 · N6716T · Substantial damageNTSB LAX82FUJ27Accident · 1 fatalFinal reportMooney M20J · Paradise Valley, AZThe pilot picked up the new aircraft from the factory at kerrville, Texas on the day of the accident. He was ferrying the plane to his home in new jersey by way of las vegas, Nevada. He declined an offer to be checked out in the plane and departed kerrville…Feb 4, 1982 · N11578 · Destroyed