A pilot has died after the plane he was flying as part of a gender reveal party in Mexico crashed on Sunday.