That pinprick you spotted mid-flight
Why Do Airplane Windows Have a Tiny Hole?
A hole in an airplane window sounds alarming. It is actually a pressure-management feature that helps the window layers handle cabin pressure safely.
Quick answer
That hole is called a bleed hole, and it's doing an important job. Airplane windows have three layers. The outer pane is the structural one — it takes the full force of cabin pressure against the thin air outside. The bleed hole sits in the middle pane and lets cabin air slowly seep into the gap between panes, so the pressure hits the outer layer gradually rather than all at once. Less sudden load means less risk of cracking. It also vents moisture and keeps your window from fogging up. It's not a flaw. It's engineered.
The hole does not mean the window is leaking or unsafe. It is intentionally placed there on every commercial aircraft.

Official name
Bleed hole or breather hole
Which pane
The middle pane
Main job
Pressure load management
Safe?
Yes — it's by design
Next tiny mystery
More things hiding in plain sight

You noticed the tiny hole
Why Do Pen Caps Have Holes?
Another small engineered hole that exists for a safety reason most people don't know.

That little hole in every prong
Why Do Electrical Plugs Have Holes in the Prongs?
Another hidden hole with a real function that looks like a defect.

That famous interview question — answered properly
Why Are Manhole Covers Round?
Another everyday structural design choice where the reason is more layered than it first appears.