Try this - in the phpvms fieldvalues table, using phpMyAdmin, find this FOREIGN KEY:
phpvms_fieldvalues_ibfk_2
Delete that... Probably when the pilots table was duplicated, there was a second key added which didn't get removed. The error is coming from that field values action though, so that's a good thing