The US Coast Guard in San Diego has ended its search for missing migrants after two smuggling boats capsized off California's coast over the weekend, leaving eight people dead in what one official called "one of the worst maritime smuggling tragedies" the city has seen.