NTSB investigations, 2009
41 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 31 |
|---|---|
| 2009 | 41 |
| 2010 | 52 |
| 2011 | 43 |
| 2012 | 51 |
| 2013 | 41 |
| 2014 | 30 |
| 2015 | 37 |
| 2016 | 55 |
| 2017 | 43 |
| 2018 | 54 |
| 2019 | 29 |
| 2020 | 42 |
| 2021 | 44 |
| 2022 | 55 |
| 2023 | 35 |
| 2024 | 48 |
| 2025 | 32 |
| 2026 | 38 |
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\") = 2009
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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") = 2009 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.NTSB ERA10LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Luray, VAThe pilot's premature rotation and liftoff and her subsequent failure to recognize and correct for the influence of ground effect on the airplane's takeoff performance.NTSB ANC10LA005Accident · No injuriesLimited investigationFinal reportCessna P206C · Palmer, AKThe pilot's decision to land on a short gravel runway, and his failure to initiate a go-around, which resulted in an overrun and on-ground collision with a fence.NTSB ANC10CA001Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · King Salmon, AKThe pilot's selection of an unsuitable takeoff area, and his decision to takeoff with a tailwind.NTSB ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.NTSB ERA09CA539Accident · Minor injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe flight instructor's delayed decision to take control of the airplane and execute a missed approach. Contributing to the accident was the lack of communication between the certificated flight instructor and the pilot receiving instruction.NTSB WPR09CA477Accident · No injuriesData collectionFinal reportCessna 182 · Enterprise, ORThe pilot's failure to stop his airplane before it departed the end of the unimproved remote airstrip.NTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.NTSB ERA09LA530Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Fairmont, WVThe pilot's delay in aborting the takeoff, resulting in an overun. Contributing to the accident was the overweight condition of the airplane.NTSB ANC09CA101Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Tok, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a runway excursion and a nose over during takeoff.NTSB ERA09CA518Accident · No injuriesData collectionFinal reportPiper PA46 · Chamblee, GAThe pilot's failure to maintain aircraft control during landing. Contributing to the accident was pilot fatigue.NTSB CEN09CA569Accident · No injuriesData collectionFinal reportCessna T210 · Tulsa, OKA temporary loss of elevator pitch control for undetermined reasons.NTSB ANC09CA095Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Talkeetna, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a nose over during takeoff.NTSB WPR09CA439Accident · No injuriesData collectionFinal reportBellanca 17-30A · La Grande, ORThe pilot's improper flare, which resulted in a bounced landing.NTSB ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.NTSB WPR09CA424Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8A · Sandy, ORThe pilot's decision to continue the landing rather than execute a go-around. Contributing to the accident was the pilot's failure to maintain proper airspeed and altitude during the approach.NTSB ERA09CA439Accident · No injuriesData collectionFinal reportMooney M20S · Mayfield, KYThe pilot prematurely retracting the landing gear and flaps during the aborted landing.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB ERA11LA028Accident · Minor injuriesLimited investigationFinal reportBrown Thomas E Thorp T-18 · Lake Como, FLThe pilot's delayed decision to execute a go-around while landing with variable wind, which resulted in a runway overrun.NTSB WPR09CA351Accident · No injuriesData collectionFinal reportCox John Wiley Kitfox III · Laurel, MTThe pilot's failure to maintain directional control during an attempted go-around from a landing.NTSB CEN09LA446Accident · No injuriesLimited investigationFinal reportBeech S35 · Tuscola, ILThe pilot failure to maintain proper speed and distance during approach to land which resulted in landing long and subsequent runway excursion.NTSB ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.NTSB ANC09CA066Accident · No injuriesData collectionFinal reportBeech G18S · Yakutat, AKThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion, and main landing gear collapse.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.NTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.NTSB ERA09CA364Accident · No injuriesData collectionFinal reportPiper L-21B · Big Beaver, PAThe pilot's failure to maintain directional control during a landing rollout with a crosswind.NTSB WPR09CA300Accident · No injuriesData collectionFinal reportNorth American/Victoria MNT LT AT-6A · Olympia, WAThe pilot's inadequate compensation for the crosswind gust and failure to maintain directional control while landing.NTSB ERA09CA365Accident · No injuriesData collectionFinal reportCessna 172H · Lovingston, VAThe pilot's failure to maintain directional control during takeoff.NTSB ERA09LA339Accident · No injuriesLimited investigationFinal reportPilatus PC-12/47 · Bridgeport, CTThe flight crew's misjudgment of speed and distance, which resulted in an overrun of the wet runway.NTSB CEN09CA323Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Mendota, ILThe pilot's inadequate preflight planning and preparation and his failure to perform an aborted takeoff.NTSB ERA09CA309Accident · No injuriesData collectionFinal reportCessna 172A · Glenburn, METhe pilot's misjudgment of distance and speed during landing.NTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.NTSB CEN09CA316Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Charleston, MOThe pilot's failure to abort the takeoff resulting in a runway overrun and impact with terrain.NTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.NTSB ERA09LA258Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pinehurst, GAThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ANC09LA032Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's inability to maintain directional control due to the pilot's seat sliding back during takeoff as a result of maintenance personnel's incorrect installation of the seat's forward track stop.NTSB ERA09LA204Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Pittstown, NJThe pilot's inadequate compensation for the crosswind during landing.NTSB ANC09LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Buckland, AKThe pilot's failure to abort the landing while landing on a snow/ice-covered runway.NTSB WPR09CA132Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Fallbrook, CAThe pilot's improper use of the brakes and his failure to maintain control of the airplane during landing rollout.NTSB ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.NTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.