You want a long exposure setup with small aperture for this job.
Try 5-10 seconds with F8 - F11 depending on the ambient light.
If it came out too bright, then use smaller aperture (higher F #) or shorter shutter speed, and vise versa.
Experiment and have fun.

Thanks guys!
The shutter setting was on 15 secs. I also tried 20 secs. All works. Longer the better I think but don't burn your cam censor lol.
I have a nikon. So I set it on interval mode. I just let it keep shooting while I fly. For canon cameras you'll need interval meter hope that helps and have fun!