At least 40 people have drowned in a boat accident in northwest Nigeria, said President Bola Tinubu on Sunday.