Limiting distributions of randomly accelerated motions