Applied ML Systems · Capstone brief
DS-06 · Where a delay at RIC actually comes from
Using tail numbers, can you quantify how much of a departure delay at Richmond International is inherited rather than locally caused?
The question
Airline delays propagate: a late inbound aircraft makes the next departure late. Using tail numbers, can you quantify how much of a departure delay at Richmond International is inherited rather than locally caused?
Data
BTS Marketing Carrier On-Time Performance (https://www.transtats.bts.gov/ONTIME/). NOAA weather for the same days (https://www.ncei.noaa.gov/products/land-based-station/global-historical-climatology-network-daily).
Expected failure modes
Cancelled flights are not delays and must not be treated as very large ones. Tail-number chaining requires careful same-day ordering and breaks across midnight. Delay cause codes are self-reported by carriers and are not ground truth. RIC is a small airport — sample sizes per carrier per month get thin fast.
Done looks like
A quantified decomposition of departure delay into inherited versus originated, with the chaining logic documented and validated on a sample by hand, and a statement of which carriers had enough flights to support a conclusion.
Five C's
CT: recognizing the self-reported cause codes are a claim, not a fact. CR: reconstructing aircraft rotations from flat records. CO: hand-validating a peer's chains. CM: an explanation a frequent flyer would find genuinely useful. CZ: who bears the cost of delay, and how compensation rules treat "weather" versus "carrier."
Mentor role
An operations analyst, airline or airport employee, or logistics professional reviews chaining at Checkpoint 1 and the decomposition at Checkpoint 2. School-supervised.
Rubric calibration
R1: scoped to RIC and a defined period. R2: cancellations handled explicitly. R3: a baseline attributing all delay locally. R4: hand-validation of the chain logic on real rows. R5: useful to a traveler. R6: treats carrier-reported causes skeptically.
Two ways this goes wrong
(a) Cancellations are coded as 999-minute delays and one storm week dominates every result. (b) The student trusts the cause codes, reports that weather causes most delay, and has reported what carriers chose to file.
Source moved or something unclear? Send feedback on this brief. Mentors are advisory; the school supervises. These briefs do not produce verified computer-science credit.