It's definitely possible to skid the front wheel without flipping over the bars, particularly while turning and braking. Chest on seat, butt cantilevered over the rear wheel, the bike will not flip regardless how much front brake you use.
Now you don't want to lock the front wheel because front wheel skids are very difficult to recover from.
__________________
You could fall off a cliff and die.
You could get lost and die.
You could hit a tree and die.
OR YOU COULD STAY HOME AND FALL OFF THE COUCH AND DIE.