For most people these days, at least in the western world, they die in the drugged stupor of pallative care, or else they die in a traumatic accident...
Neither situation would seem to be ideal for "remaining aware whilst the body and brain dies" even if you wanted to do that...