If the drive has failed mechanically, system profiler would still detect it....
if it has failed electrically, then it would appear to be missing to the system profiler.
Does the drive make any sounds or lights at all ?
Perhaps the power connector to the drive has come loose......any rough/tough situations lately, like slamming, bumping or dropping ?