I've found this bug in my child's soil pit in school, it's just like a small sand pit but full of soil.
It's like a bumble bee but the top half is completely orange and the bottom completely yellow, it has two small stumps for wings that were slightly furry, did not appear to have a stinger as it crawled all over my arm and a few of the kids and no sting.
The only thing I could think of is maybe some kind of deformed bee but how it ended up inside the school and up in a soil pit with no wings is beyond me and it was quite big so surprised it was not noticed.
Yes, probably a hover fly.
The arrangement of the eyes (separated) suggest it is a female.
The deformed wings are probably due to it only just having emerged from pupation, its wings still being inflated. That would also account for its bright colours, being fresh.
This is a very good page on UK hover flies, though it does not help with your one
It is something like Arctophila superbiens
But that species is not quite right (the black antennae, for instance).
And it is not the other species of Arctophila.
...We need a fly man on this one...
Thanks for the help guys would appear to be a narcissus bulb fly which would explain it being in the soil pit which does have a few new bulbs in it and it would appear that its wings have not dried out yet hence the deformed wings.
Yes - well done - that's a pretty good fit - Merodon equestris, and probably var. flavicans
BTW, your last image is a different species; it is a bee.