Подрядчик совета The incident was among "abysmal failures" of care by a council contractor, an investigation finds.