Real Madrid's dreams of a Champions League final at their Bernabeu home were crushed by Lyon last night as the Spanish giants were knocked out at the last-16 stage for the sixth successive season.