Is something being possessed?
i.e., to show possession, you'd say "The Might Sullivan's car died at the end of the race." OR, if you were just saying the name, like "The Mighty Sullivans live here," there is no need for an apostrophe.
Does this help?