[Prince] Andrew, unfortunately, exhibited classic symptoms of what is scientifically recognised as the Dunning-Kruger effect, the cognitive bias in which people come to believe that they are smarter and more capable than they really are. The combination of minimal self-awareness and dim wattage leads sufferers of this condition to overestimate their own capabilities.
Source: wiktionary