I’ve seen reports of this happening before in these forums, but I’ve never experienced this problem myself.
Although I’ve only used Integromat and direct API calls to add attachments into Airtable — I haven’t used Zapier to do this.
It’s very possible that it’s an Airtable bug, but it’s also possible that perhaps there is something wrong with the Zapier setup as well. For example, maybe the URL link is expiring before Airtable has a chance to finish uploading it? I’m just guessing.
Just for testing purposes, you may want to try Integromat to upload your attachments into Airtable to see if you get the same problem:
p.s. Also note that Airtable’s API will always overwrite old attachments when you send a new attachment into the field, unless you create an array that contains both the old attachment URL & the new attachment URL.