NTSB investigations, 2025
11 cases where the defining event was Landing area undershoot.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 6 |
| 2010 | 11 |
| 2011 | 11 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 12 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 8 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 11 |
| 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 year(c.\"eventDate\") = 2025
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '370')
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 year(c."eventDate") = 2025 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '370') 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 WPR26MA063Accident · 7 fatalClass 2 · MajorPreliminary reportCessna 550 · Statesville, NCOn December 18, 2025, at 1015 eastern standard time, a Cessna Citation 550, N257BW, was destroyed when it was involved in an accident near Statesville, North Carolina. The pilot and 6 passengers were fatally injured. The airplane was operated as a Title 14…NTSB DCA26WA031Incident · No injuriesClass 5 · ForeignBoeing 747 · N'Djamena, ChadNTSB ERA25LA363Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · White Plains, NYThe pilot’s failure to maintain proper glidepath during a night visual approach, which resulted in a collision with the runway lighting system. Contributing to the outcome was the pilot’s momentary disorientation due to glare from the runway approach lighting…NTSB CEN25LA406Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Beaman, IAThe pilot’s failure to maintain a proper glidepath during landing which resulted in a landing short of the runway.NTSB DCA25LA291Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus A319 · Nashville, TNOn August 14, 2025, about 1724 central daylight time (CDT), Air Canada Rouge flight ROU1717, an Airbus A319 airplane, registration C-GSJB, touched down short of runway 20L while landing at the Nashville International airport (BNA), Nashville, TN. There were…NTSB ERA25LA224Accident · No injuriesClass 4 · LimitedFinal reportShoemaker Ronald R Pazmany PL-2 · Reading, PAThe pilot’s failure to maintain a proper descent rate, resulting in a hard landing short of the runway and collapse of the right main landing gear.NTSB GAA25WA137Accident · Serious injuriesClass 5 · ForeignGulfstream Aerospace G-V · Cabo San Lucas, MexicoNTSB DCA25WA199IncidentClass 5 · ForeignBoeing 737-400 · Puerto Inírida, ColombiaNTSB CEN25LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Lakeview, ARThe pilot landed short of the runway.NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB ERA25LA118Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s failure to maintain an appropriate glide path and the flight instructor’s inadequate monitoring of the landing approach, which resulted in the airplane contacting the ground short of the runway.