The rocket barrel from Donkey Kong Country Returns.
It floats in the air. Mario can jump into it to enter it. When the player presses the jump button thrice, the barrel will activate and it will fly in an arc. The player can make the barrel fly higher by pressing the jump button mid-flight, however, they have little control over the barrel's horizontal speed. It will explode if it touches an object or another sprite.
If the barrel reaches a specific screen, it will drop Mario and fall offscreen. The screen it needs to reach can be set per-sprite using the extra byte (the extension field in Lunar Magic's "Add Sprite Manual" dialog).