Never fly through JFK/CDG
This winter break, I flew with my wife and family to India, and made the colossal mistake of splitting up my flights into three segments. First, from Ausin to New York JFK, JFK to Paris, and finally from Paris to Mumbai. Each stop inexplicably required that I go through security again (even when our departure gate was in the same terminal!), and for this reason JFK and Charles de Gaulle may be the worst airports for international travel I’ve ever been through.
In general, splitting up the 30 or so hour trip into three segments is a bad idea, but we were left with basically no choice. Scanning the excellent database of flights/airlines/airports at Openflights, it turns out there are not so many ways to fly from Austin to Mumbai with only one stop. In fact, there are just two:
These two routes are
- Austin (AUS) – Newark (EWR) – Mumbai (BOM)
- Austin (AUS) – London Heathrow (LHR) – Mumbai (BOM)
Obviously either of these is better than the route my wife and I took, but knowing this the airlines priced both of these several hundred dollars more expensive than the AUS-JFK-CDG-BOM route we took ($2500 vs. just under $1800 per ticket). Frankly I was surprised that there were only two options for flying to Mumbai from Austin with a single stop. Bigger, nearby, cities like Houston (11 ways) or Dallas (8 ways) have many more options, but Austin’s surprising lack of direct connection to many of the bigger European/Asian hubs (like Frankfurt, Amsterdam, Munich, Dubai, Tokyo, etc.) means that there aren’t many ways to get to India with just a single stop.
Austin to Mumbai with two stops
If you’re willing to stop twice along the way, there are plenty more options that are shown on the map below:
There are some crazy itineraries here. For example, since you can fly directly from Newark/London to Mumbai, there are flights that take you through various American cities before heading to Newark/London. Austin-Seattle-Paris-Mumbai is a particularly ludicrous one. Some of my favorites are the four or five that fly through Cancun on their way to Frankfurt/Paris/London/Munich, or the several that connect through Johannesburg. I think it’s safe to say that of all of the available three-segment routes to get to Mumbai, Austin-JFK-Paris-Mumbai is one of the better ones.
Inter-city connectivity graph
This led me to wonder how connected the graph of cities around the world linked by flights is. So, I populated an adjacency matrix, , whose entries are defined as
The vertices in this graph are cities, and the edges are flights between them. There are a total of 2,327 airports on this list (there are a few more in the OpenFlights database that are air force bases and so are not connected to anything). The average city is connected to 14.1 other cities, with the most connected city is Amsterdam with 246 cities one direct flight away.
A natural question to ask is how many cities the average city is 2, 3, or 4-flights connected to. This is easy to compute using powers of the adjacency matrix. The degree of a vertex in the graph is the row sum of , and tells you the number of cities is directly connected to. To get the number of cities is connected to with 2 flights, just take the square of the adjacency matrix, and sum up the number of non-zeros in the row. In general, to get the number of cities that are connected by flights to ,
As you might imagine, the graphs get more and more dense as increases, and this is shown in the four pictures below. Going from left to right, these pictures depiect the sparisty patterns .
With a direct flight, the average city is only connected to about 14 other cities, or about 0.6% of the world. From this perspective, this is a pretty disconnected world. But, if you allow one stop along the way, the average city is connected to 228 other world cities. Allow two stops, and this number jumps to 1,077. Three (1,950) and four stops (2,229), and you’re just about connected to the entire network of 2,327 cities.
What sort of cities are connected by a minimum of five flights, you might ask? It’s usually obscure places on one continent and obscure places on another. For example, it takes a minimum of five flights to get from Port Moresby, Papuaa New Guinea to Lakselv, Norway. These are itineraries you likely cannot even purchase on Expedia or Kayak (I couldn’t). I have yet to get their routing algorithm to return any itinerary that has more than 3 stops.
In conclusion, it is interesting to me how disconnected, on average, the world still seems to be. The hub-and-spoke routing model’s prevalence means that there are relatively few direct flights between cities, but almost all regional cities are within 2 flights of one another (source -> hub -> destination), almost all domestic cities are within 3 flights of one another (source -> hub -> hub -> destination), and finally almost all international cities are within 4 flights of one another (source -> domestic hub -> international hub -> domestic hub -> destination). It would be really interesting if OpenFlights had historical routing data to watch the time-evolution of the graph, as its topology undoubtedly changes to react to economic booms/busts, population migration, and growth in developing countries. In any case, the clear takeaway is that if you’re going to fly three segments to Mumbai from Austin, definitely plan to fly through Cancun instead of New York Kennedy. Lesson learned.