EquationDB

Airlines and travel disruption

For airline analysts, travel operations and transport investors

A snowstorm or a wind event at one big hub can ripple across a whole network. See which hubs had heavy snow or damaging gusts, how snowy each winter was in Chicago, follow the winds at two hubs, and measure what the airlines did after snowstorms at O'Hare and JFK.

  • Weather
  • 5 steps
  • Runs on live data

How EquationDB answers it

Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.

  1. Snow and gusts at the big hubs

    Every heavy-snow day and damaging gust at Chicago O'Hare, Atlanta, Dallas–Fort Worth, Denver and JFK since 2024, newest first.

    EVENTS heavy_snow, damaging_gust IN (KORD, KATL, KDFW, KDEN, KJFK) SINCE 2024-01-01 SORT date DESC
    Try it →
  2. Chicago snowfall, winter by winter

    Total snowfall at O'Hare each year: how rough each season was for the busiest hub in the Midwest.

    SERIES weather:KORD.snow SINCE 2015-01-01 ALIGN yearly
    Try it →
  3. Wind at two hubs

    The day's fastest wind at O'Hare and Denver for three months: gusts above about 40 mph are when ground stops become likely.

    SERIES weather:KORD.gust, weather:KDEN.gust LAST 3mo
    Try it →
  4. Airlines after O'Hare snowstorms

    What Delta, United, American and the airlines fund did 1, 5 and 20 sessions after each heavy snow at O'Hare since 2010, from the first session after it.

    OUTCOMES AFTER weather:KORD.heavy_snow IN (DAL, UAL, AAL, JETS) FWD 1d, 5d, 20d SINCE 2010-01-01
    Try it →
  5. Airlines after JFK snowstorms

    The same test at JFK, with JetBlue in place of American: a carrier concentrated in New York shows the storm's effect more clearly.

    OUTCOMES AFTER weather:KJFK.heavy_snow IN (DAL, UAL, JBLU, JETS) FWD 1d, 5d, 20d SINCE 2010-01-01
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More weather use cases