Someone or something whose potential greatness was not achieved.
Someone who has never achieved anything (in a particular field); one who has had an unsuccessful career