NTSB investigations
18 cases where NTSB found Runway lighting.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 4 |
| 2025 | 1 |
| 2026 | 2 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03017015')) ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03017015')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.NTSB ERA26LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Castle, DEThe pilots’ failure to properly identify the assigned runway during the landing approach, which resulted in the airplane landing on a closed, snow-covered runway. Contributing was the illumination of the closed runway’s edge lighting.NTSB CEN25LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Baldwin City, KSThe pilot’s decision to continue the night landing without runway lights which resulted in the runway overrun.NTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…NTSB DCA23LA125Incident · No injuriesClass 1 · LimitedFinal reportBoeing 737-900ER · Queens, NYThe American Airlines flight 106 (AAL106) crew’s surface navigation error due to distractions caused by their performance of concurrent operational tasks during taxi, which resulted in a loss of situational awareness. Contributing to the incident was the air…NTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.NTSB CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.NTSB ERA21LA020Accident · 1 fatalClass 3 · LimitedFinal reportAero Commander 100 · Citra, FLThe student pilot’s inadequate preflight planning likely due to impairment from ethanol, which resulted in a total loss of engine power due to fuel exhaustion. Contributing was his improper decision to depart from an unlit airstrip in dark night conditions.NTSB GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.NTSB GAA16CA005Accident · No injuriesData collectionFinal reportRaytheon A36 · Monterey, CAThe pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.NTSB CEN15LA229Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Chesterfield, MOThe collision of the helicopter's skid shoe with the runway centerline light during landing, which abruptly stopped the helicopter and resulted in damage to the fuselage.NTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…NTSB WPR10CA035Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Angwin, CAThe pilot's failure to properly identify the runway surface for takeoff and his subsequent failure to abort the takeoff when he realized he was not on the runway. Contributing to the accident was the pilot’s failure to select the appropriate radio frequency…NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.