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 ERA11CA494Accident · No injuriesData collectionFinal reportMooney M20K · Anderson, SCThe pilot's failure to maintain directional control during an attempted go-around.NTSB ERA11CA492Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Cleveland, GAThe pilot's poor decision to land with a tailwind, which resulted in a runway excursion.NTSB CEN11CA647Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Pinckneyville, ILThe pilot's failure to conduct a go-around due to his excessive airspeed while on approach to land, which resulted in a runway excursion.NTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB ERA11CA452Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Front Royal, VAThe pilot’s failure to attain the proper touchdown point.NTSB ERA11CA455Accident · No injuriesData collectionFinal reportG-Dawg Just Acft Highlander · Abingdon, VAThe pilot's inadequate compensation for wind conditions during the aborted takeoff.NTSB DCA11RA092Accident · Serious injuriesForeign investigationBoeing 737 · Georgetown, GuyanaOn July 30, 2011, at 1:25 am local time (0525 UTC), a Boeing 737-800, Trinidad & Tobago registration 9Y-PBM, operated by Caribbean Airlines as flight 523, overran the runway upon landing at Cheddi Jagan International Airport, Georgetown, Guyana. Of the 156…NTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB ERA11CA402Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crystal River, FLThe pilot's failure to attain the proper touchdown point, and his improper decision to perform a go-around with a tailwind and insufficient runway remaining.NTSB DCA11WA120Incident · No injuriesForeign investigationCessna 560 - XL · Port Harcout, NigeriaOn July 14, 2011 about 1853 UTC, 5N-BMM, Cessna 560XLS, operated by Bristow Helicopters Limited, was involved in a runway excursion while landing at Port Harcourt, Nigeria. There was no injuries to the six persons on board. The aircraft received minor damage.…NTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…NTSB WPR11LA260Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Buttonwillow, CAThe pilot's misjudgment of the landing approach and subsequent long landing and overrun of the runway resulting in a collision with ground obstacles. Contributing to the accident was the pilot's likely fatigue and dehydration.NTSB WPR11CA259Accident · No injuriesData collectionFinal reportCessna 172P · Palo Alto, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11LA371Accident · No injuriesLimited investigationFinal reportRedding David RV9A · Edgewood, NMThe pilot's failure to abort the takeoff roll.NTSB WPR11FA236Accident · Serious injuriesField investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Sedona, AZThe pilots’ unstabilized approach and excessive airspeed during approach, which resulted in an insufficient landing distance to stop the airplane before overrunning the runway.NTSB CEN11CA336Accident · Serious injuriesData collectionFinal reportReed Roderick KB3 Gyroplane · Scott, LAThe pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.NTSB DCA11WA061Incident · No injuriesForeign investigationBoeing MD-90 · Tao-Yuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an incident involving an MD-90 that occurred on May 12, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex 13 as…NTSB WPR11CA219Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Scottsdale, AZThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.NTSB ERA11CA192Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot's failure to maintain directional control during the landing rollout.NTSB DCA11WA068Incident · No injuriesForeign investigationBombardier BD-100-1A10 · Iqaluit, CanadaOn March 12, 2011, a Bombardier BD100, registration N818RC, operated by Tri Marine Logistics, departed the runway to the right while landing on runway 35 at Iqaluit Airport (CYFB), Iqaluit, Nunavut, Canada. The airplane stopped about 100 feet from the edge of…NTSB ERA11CA176Accident · No injuriesData collectionFinal reportCessna 172L · Fayetteville, GAThe pilot's decision to land with excessive speed in gusting, tailwind conditions, resulting in a runway overrun.NTSB ERA11CA171Accident · No injuriesData collectionFinal reportAerostar PA-60-601P · Princeton, NJThe pilot’s failure to stop the airplane resulting in a runway overrun.NTSB WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.NTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.NTSB ANC11LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Saint Michael, AKThe loss of directional control during landing due to a flat nose wheel tire, resulting in a runway excursion and collision with trees.NTSB DCA11WA067Incident · No injuriesForeign investigationBoeing 747 · Medina, Saudi ArabiaOn December 12, 2010, a Boeing 747-400, Saudi registration HZ-AWA1, serial number 27672, operated by Alwafeer Air as flight 1336, exited the left side of the runway after landing at Prince Mohammed Airport, Medina, Saudi Arabia. Two of the right hand main…NTSB DCA11WA010Incident · No injuriesForeign investigationBoeing 737-823 · Montreal, CanadaOn November 30, 2010, American Airlines flight AAL802, a Boeing 737-800, N901AN, departed the left side of runway 24R and stopped in the grass approximately 6600 feet down the runway while completing its landing roll at Montreal Pierre Elliott Trudeau…NTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.NTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB WPR11CA024Accident · No injuriesData collectionFinal reportCessna 185 · Fort Thomas, AZThe airplane's encounter with a dust devil during landing rollout, which resulted in the pilot not being able to maintain directional control.NTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB CEN11CA032Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rose Hill, KSThe pilot's improper touchdown point during landing, which resulted in a runway overrun.NTSB ERA11IA006Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe pilot-in-command's failure to attain the proper touchdown point while landing with a gusting crosswind and failure to initiate a go-around, which resulted in a landing more than halfway down the runway and a subsequent runway overrun. Contributing to the…NTSB ANC10CA085Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Coldfoot, AKThe pilot's selection of an unsuitable (short) off-airport site for takeoff.NTSB CEN10CA527Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-34R · Hampshire, ILThe pilot’s failure to attain the proper touchdown point, resulting in a runway overrun.NTSB DCA10WA093Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanOn September 2, 2010, at 1337 UTC, an Eva Airways Boeing 747-400 ran off the edge of runway 24 upon landing at Tao Yuan International Airport, Taipei, Taiwan. The aircraft was registered in Taiwan a B-16410 and was on a scheduled passenger flight from Poo…NTSB CEN10CA518Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Anderson, INThe pilot’s failure to abort the takeoff due to degraded airplane performance.NTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.NTSB ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.NTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR10LA365Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Prescott, WAThe airplane’s inability to maintain a positive rate of climb after takeoff for undetermined reasons. Contributing to the accident was the pilot’s delayed reaction to initiate an emergency release of the spray mixture.NTSB ERA10CA369Accident · No injuriesData collectionFinal reportCessna 152 · Indian Head, MDThe pilot's loss of control while landing in gusting crosswind conditions.