NTSB investigations
801 cases where the defining event was Runway excursion.
Cases, newest first
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 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 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 WPR13CA397Accident · No injuriesData collectionFinal reportCessna 172S · Deer Valley, AZThe student pilot's inadequate flare and the flight instructor's delayed remedial action and failure to maintain control of the airplane during a go-around. Contributing to the accident was the flight instructor's improper go-around procedures.NTSB ERA13CA393Accident · No injuriesData collectionFinal reportCessna 172E · Apex, NCThe pilot's failure to attain the proper touchdown point on the runway, which resulted in a runway overrun and subsequent aircraft noseover.NTSB ERA13CA378Accident · Minor injuriesData collectionFinal reportCessna 172R · Shelter Island, NYThe pilot did not attain the proper touchdown point on the runway, which resulted in a runway excursion.NTSB CEN13LA503Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Concord, WIThe pilot's failure to properly plan for a maximum performance takeoff by not fully addressing the elevated density altitude or the nonstandard runway surface conditions and his failure to properly configure the airplane's flap setting for the accident…NTSB DCA13WA137Accident · No injuriesForeign investigationFairchild SA227 · Sucre, BoliviaThe Direccion General De Aeronautica Civil (DGAC) has notified the NTSB of an incident involving a Fairchild SA227-DC, registration CP-2655, which occurred on August 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…NTSB CEN13CA499Accident · No injuriesData collectionFinal reportBeech 35 · Wheeling, ILThe pilot’s loss of control due to the passenger’s inadvertent application of left rudder during the takeoff roll.NTSB CEN13CA479Accident · Minor injuriesData collectionFinal reportKerr Matthew Starduster TOO · Frankenmuth, MIThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and subsequent impact with a corn field.NTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.NTSB CEN13CA469Accident · No injuriesData collectionFinal reportCessna 182T · Mackinac Island, MIThe pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.NTSB WPR13CA357Accident · No injuriesData collectionFinal reportChampion 7EC · Sonoma, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR13CA355Accident · No injuriesData collectionFinal reportMooney M20F · Helena, MTThe flight instructor's delayed decision to instruct the pilot to abort the landing which resulted in a runway excursion and collision with a fence.NTSB DCA13WA135Accident · No injuriesForeign investigationBoeing 737 · Surat Thani, ThailandThe Thailand Civil Aviation Authority (TCAA) has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on July 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TCAA's investigation under the…NTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.NTSB ERA13WA334Accident · 3 fatalForeign investigationBeech 58 · Manaus, BrazilNTSB WPR13CA328Accident · No injuriesData collectionFinal reportCessna 172S · Redlands, CAThe student pilot's improper flare and unsuccessful attempt to correct a bounced landing, which resulted in the overrun landing.NTSB WPR13CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Monroe, WAThe student pilot's failure to maintain directional control during the landing roll, and the flight instructor's delayed remedial action that resulted in a runway excursion.NTSB ERA13CA315Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Easton, PAThe pilot's improper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident was the pilot’s decision to land with a tailwind condition and his lack of recent experience.NTSB WPR13LA307Accident · Serious injuriesLimited investigationFinal reportBoson RV-4 · Hurricane, UTThe pilot’s incorrect approach/descent path with a tailwind, which resulted in a long landing at an excessive groundspeed and a subsequent runway excursion.NTSB CEN13LA520Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Boonville, MOThe pilot’s failure to maintain directional control of the airplane during landing on a gravel road.NTSB CEN13CA386Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Climax Springs, MOThe pilot’s inadequate planning and poor decision to attempt to take off on a runway from which the airplane could not obtain flight.NTSB CEN13CA385Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot did not attain a proper touchdown point during the landing. Contributing to the accident was the simulated altimeter and spoiler failure and the flight instructor's lack of remedial action.NTSB WPR13CA282Accident · No injuriesData collectionFinal reportCessna 170B · Rawlins, WYThe pilot’s delayed decision to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude, which resulted in a runway excursion and collision with terrain.NTSB ERA13IA294Incident · No injuriesIncident investigationFinal reportIai GULFSTREAM200 · Jamestown, NYThe pilots’ failure to effectively use the airplane's primary (brakes), secondary (thrust reversers), and emergency braking systems to decelerate the airplane, which resulted in a runway excursion. Contributing to the accident was the pilots’ failure to…NTSB DCA13WA123Incident · No injuriesClass 5 · ForeignEmbraer 145 · Shanghai, ChinaNTSB CEN13CA279Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Meriden, KSThe pilot electing to land at an airport with a runway environment that precluded a go-around with the tailwind weather conditions present which resulted in a runway excursion during the landing.NTSB WPR13LA210Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Bryce, UTThe pilot's failure to establish the minimum liftoff speed during takeoff with the airplane over its maximum gross weight, which resulted in the airplane’s failure to climb and a subsequent loss of directional control and a runway excursion.NTSB CEN13LA237Accident · 1 fatalLimited investigationFinal reportAlon A2 · Greenbrier, ARThe pilot's improper recovery from a bounced landing and porpoise. Contributing to the accident were the pilot's limited recent flying experience and proficiency and the challenging runway environment.NTSB WPR13LA145Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Kernville, CAThe pilot’s application of excessive pitch and his failure to achieve adequate airspeed during the go-around attempt, which resulted in an aerodynamic stall.NTSB CEN13LA188Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Olathe, KSThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB DCA13WA069Incident · No injuriesForeign investigationBoeing 727 · Porto Velho, BrazilThe Aeronautical Accident Prevention and Investigation Center (CENIPA) of Brazil has notified the NTSB of an accident involving a Boeing 727 that occurred on March 05, 2013. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's…NTSB CEN13CA151Accident · No injuriesData collectionFinal reportCessna 172 · Murphysboro, ILThe pilot’s failure to maintain control of the airplane during the takeoff roll.NTSB ERA13CA120Accident · No injuriesData collectionFinal reportMallory Christopher L RV-8 · Lake City, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.NTSB DCA13WA033Incident · No injuriesForeign investigationBoeing 737 · Shonai, JapanOn 8 December 2012, at approximately 1326 UTC (2236 local time), a Boeing 737-800, registration JA57AN, operated by All Nippon Airways, overran the runway after landing at Shonai Airport (RJSY), Yamagata, Japan, and came to rest in the grass area past the end…NTSB CEN13LA023Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Sturtevant, WIThe pilot's decision to continue the landing after touching down long and on a wet runway that reduced the airplane’s braking capability, which resulted in an overrun.NTSB DCA13WA007Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaOn October 19, 2012, Sriwijaya Air flight SJ182, a Boeing 737-4Q8, registration PK-CKN (msn 26281 built 1992), sustained damage after it overran the runway on landing at Supadio Airport, Pontianak, Indonesia, and reportedly suffered a nose undercarriage…NTSB ERA12LA586Accident · No injuriesLimited investigationFinal reportStewart Mw/Stewart JD Sonerai 2L · Titusville, FLThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a ditch.NTSB WPR12CA398Accident · No injuriesData collectionFinal reportLake John K MA-5 Charger · Eagle Mountain, UTThe airplane’s encounter with a large hole in the runway during the landing roll, which resulted in a loss of control and subsequent runway excursion.NTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.NTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.NTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.NTSB ERA12LA525Accident · No injuriesLimited investigationFinal reportCessna 152 · Ormond Beach, FLThe pilot's improper decision to take off again after a successful abort due to diminished airplane climb performance. Contributing to the accident was carburetor icing during the taxi, which resulted in the loss of engine performance.NTSB CEN12CA564Accident · Minor injuriesData collectionFinal reportCessna T210N · Boulder, COThe pilot’s decision to continue the unstable approach, which resulted in a loss of control during landing and a runway excursion.NTSB ERA12CA516Accident · Serious injuriesData collectionFinal reportBeech A23-19 · West Liberty, KYThe pilot's delayed decision to abort a takeoff, which resulted in a runway excursion.NTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.NTSB ANC12CA091Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Talkeetna, AKThe pilot's decision to land on a short, wet, off-airport landing site, which resulted in a runway excursion.NTSB WPR12CA360Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Coolin, IDThe pilot’s failure to attain a touchdown point sufficient to stop the airplane within the length of the runway.NTSB CEN12LA516Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe loss of directional control during landing roll, which resulted in a runway excursion. The reason for the loss of directional control could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have…NTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.NTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.