Thread by @BDDataplan

✈️Flying during COVID19 - the numbers

COVID19-figures on aviation are rare.
A thread about (the search for) this data.

We've collected 4.400 flights with at least one contagious(!) person.

Corona spreads its wings… ⬇️🧵

✈️Flying during COVID19 - the numbers

COVID19 & variants spread worldwide, also by aviation.
Despite precautions like PCR- and Antigen-tests.

Why are there no figures?
● Commercial interests?
● Inconvenient? (we want to travel)
● Too difficult?

No... it's not too difficult.

✈️Flying during COVID19 - the numbers

Fortunately, some countries share flights with contagious COVID19-persons, to alert other passengers.

From 5 websites we've collected:
● 4.428 international "affected"-flights
● 962 flightnumbers
● 98 airlines
● 82 countries

Coverage:

✈️Flying during COVID19 - the numbers

Detail: Canada

Percentage of incoming affected flights:

April 2021 (image 1):
● #India 100% = every flight!
● #UAE 70%
● #Qatar 58%

Per month, in 2021 (image 2):
● #Delhi (IN): 183 flights = 67%
● #Amsterdam (NL): 54 flights = 19%

✈️Flying during COVID19 - the numbers

How many affected persons per flight?

Hard to tell for the Canada-data. It mentions 3 "rows" around the person.
E.g. an affected person (or group, like a family) is on row 5, the site reports: "Rows 2 to 8".

Often you see several blocks:

✈️Flying during COVID19 - the numbers

Do other sources mention the number of affected persons per flight?

● #Australia: only the rows
● #Norway: no details
but...
● #HongKong: the exact number of affected persons on board can be calculated

E.g. 3 persons on flight CX2780:

✈️Flying during COVID19 - the numbers

Detail: Hong Kong (1/2)

Top-12 flights with the most affected persons on board:
● Highest number per flight: 47 people
● 3 flights in April 2021
● only 5 different countries
● 5x #Emirates in 2.5 weeks (16 June 20 - 4 July 20)

✈️Flying during COVID19 - the numbers

Detail: Hong Kong (2/2)

Average number of contagious persons on board:
● by airline: #Vistara: 8.3 (image 1)
● by country of departure: #Nepal: 5.1 (image 2)

✈️Flying during COVID19 - the numbers

Currently #travelbans are discussed.
Is a ban effective?

It depends, some bans can be avoided with a stopover.
With all the extra risks that come along like extra traveltime, tests, hotel, airport.
E.g. India to The Netherlands via stopover

✈️Flying during COVID19 - the numbers

The flights, interactive charts and tables can be found on our website:
bddataplan.nl/corona/covidfl…

With 4.428 flights this table is (I believe) the only open data source with this kind of flight data. The data may be used.

✈️Flying during COVID19 - the numbers

The data is gathered from hundreds of screens, files and documents, and manually corrected.

Thanks a million🙏
● @CPHO_Canada, @newsgovhk, @Folkehelseinst, @NSWHealth and @WAHealth for publishing this data
● @internetarchive
● #Flightera