The public are entitled to know what led to a blunder that caused a major sewage spill onto a beach, a councillor says.