Jon/Adriano
You are thinking of Halifax DG396 of 295 Squadron. The Horsa it was towing (HS 102) did indeed end in the water, being claimed by Oberleutnant Dieter Meister (V/KG 40). For photos taken during the attack, plus written account visit:
http://www.raf38group.org/dg396b.htm
Brian