I don't think you will hear the frequency "one last time", before it fades away. More likely you will slowly lose your range of hearing from high to low frequency.
Hair cells in the cochlea are arranged in a spiral on the basilar membrane, with high frequency cells at the apex. For some reason, high frequency cells are more sensitive to damage, either by loud noises, drugs (including certain antibiotics that cause deafness), or old age. By adulthood, humans have already lost a significant portion of their high-frequency hearing (children hear up to 22kHz, adults 16-18kHz from memory).
Significant hearing loss can also be caused by the loss of outer hair cells, which act as a cochlea amplifier, or loss of the type I spiral ganglion neurons that connect the hair cells to the brain. But typically age-related hearing loss is normally caused by the death of Inner Hair Cells.