Storytelling mini-project

Airline safety improved by building systems around failure.

Passengers grew by roughly 495x from 1945 to 2019 while annual crash records stayed roughly flat to declining. The safety story is not one magic invention: safer engines, warning systems, better crew training, computer-assisted controls, airline audits, and formal risk management all layered defenses onto a fast-growing passenger industry.

1908-2009requested crash sheet coverage; last record is Jun 8, 2009
~495x passengersfrom IATA's 1945 world-airline milestone to pre-COVID 2019
40 to <2US fatal accidents per million departures, 1959 to roughly 1969, cited by Allianz
0.23 in 2014global jet hull-loss accidents per million flights, cited by Allianz / IATA
A single graph with recorded crash counts from 1908, passenger growth context, and lay-person aviation-safety milestones from safer engines to risk-management systems.

Read this as a teaching chart, not a formal accident-rate database. Red columns are yearly records in the requested Google Sheet tab and stop after the partial 2009 sheet year; the shaded region after that is passenger data only. Blue shows airline passenger growth: the annual World Bank / ICAO series starts in 1970, while 1945 and 1955 are sparse IATA anchor points, not annual data. Green callouts name safety changes in plain language. The top safety-rate tiles use different denominators, departures and flights, so the inset shows a separate passenger-denominator view for intuition rather than direct comparison.