flat tired

adj.

Drunk, with the result that your legs have lost pressure and every journey requires roadside assistance.

Charles-eric was flat tired by half ten, leaning against the bar as though awaiting a mechanic.

Source: Wiktionary