Show HN: I'm an airline pilot – I built interactive graphs/globes of my flights
Logbooks, Data, and Tools
- Pilots are required to keep logbooks, though exact rules vary by country. In the US, only specific kinds of time must be logged, not “all flying hours.”
- Many still use paper; others use digital tools. The author uses LogTen, which stores data in SQLite and can export CSV; that DB was queried to drive the visualizations.
- Losing a logbook is described as a nightmare: reconstructing data from airlines, re-entering by hand, and seeking sign-offs.
- Tech stack discussed: Astro, Nivo, globe.gl, Flask/Python, SQLite. Some assumed Uber’s H3; others pointed to similar ADS‑B visualizations and hex-grid resources.
- A few commenters note performance issues (low framerate when zooming) and suggest label decluttering and alternate matrix/heatmap styles.
Routes, War Impacts, and Operations
- The long tail of flight duration is explained by Ukraine war–related reroutes: from the UK to East Asia they must detour via Turkey, and sometimes return via Alaska due to winds and ETOPS constraints.
- Some sectors are “shuttles” between non‑home airports; if schedules change, pilots may be “positioned” (deadhead) as passengers.
- Most flights start and end at London; clusters in Canada and Spain are from training and light-aircraft flying.
- Questions about actual vs great-circle distance arise; live ADS‑B/FlightAware data are suggested but not easily integrated at scale.
Pilot Life, Career Crossovers, and Safety
- There’s strong interest in the author’s path: computer science background, switching to a sponsored airline cadet program, choosing “professional pilot, hobbyist engineer” instead of the reverse.
- Many note the overlap between pilots and programmers; several pilots and ex-engineers chime in with similar trajectories.
- Age and retraining are discussed; commenters in their late 30s/40s debate switching into aviation or medicine.
- Long-haul pilots have rest breaks away from the cockpit; coding happens during layovers, not while actively on duty. Others argue that deep programming focus would conflict with the need to stay “mentally on.”
Health, Environment, and Additional Metrics
- Cabin pressure and ear issues: newer widebodies with lower cabin altitude are said to reduce discomfort; simple tricks like yawning or gum help.
- Several suggest tracking altitude, radiation exposure, CO₂ emissions, and passenger counts. Radiation modeling is seen as nontrivial; airlines sometimes provide aggregate dose figures.
- Some criticize the absence of carbon-footprint data alongside extensive flight stats.
Reception and Product Ideas
- Overall reaction is highly enthusiastic: multiple people call it inspiring, calming for fearful flyers, and a model of applying software to real life.
- Suggestions include turning it into a product for pilots, open‑sourcing the code, and adding training/safety‑related visualizations.