It is on dbfs mount so in most scenarios you should prefix everything with /dbfs (or dbfs:/ in databricks native functions, in many is not even needed as they handle only dbfs like dbutils). So please try:

from zipfile import *
 
with ZipFile("/dbfs/FileStore/tables/flight_data.zip", "r") as zipObj:
    zipObj.extractall()