Air India has dismissed a pilot who flew a flight from overseas to India while under the influence of alcohol.