NTSB investigations
3,664 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA13CA189Accident · No injuriesData collectionFinal reportCessna 172R · Immokalee, FLThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA13CA185Accident · No injuriesData collectionFinal reportCessna 172N · Bally, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN13LA208Accident · No injuriesLimited investigationFinal reportCessna 421C · Amarillo, TXMaintenance personnel's failure to detect the misadjustment of the left landing gear actuator's switch after recent maintenance, which prevented the landing gear from locking in the extended position and resulted in the landing gear collapsing during landing.NTSB WPR13CA162Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR13LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Hillsboro, ORA runway overrun due to an insufficient stopping distance due to the downsloping runway during a rejected takeoff. Contributing to the accident was a cabin door that inadvertently opened during the takeoff roll.NTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.NTSB ERA13CA172Accident · No injuriesData collectionFinal reportMooney M20J · Springfield, TNThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB CEN13CA200Accident · No injuriesData collectionFinal reportCessna 172 · Kremmling, COThe student pilot’s failure to maintain directional control while landing.NTSB WPR13CA148Accident · Minor injuriesData collectionFinal reportPiper PA-24-400 · Minden, NVThe pilot's improper flare, which resulted in a bounced landing and a loss of directional control.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 WPR13CA146Accident · Minor injuriesData collectionFinal reportWaco UPF-7 · Paso Robles, CAThe pilot's failure to adequately compensate for crosswind conditions, which resulted in a loss of directional control during the landing roll.NTSB CEN13LA191Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beech Grove, ARThe pilot’s failure to maintain control of the airplane during the takeoff roll.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 CEN13IA177Incident · No injuriesIncident investigationFinal reportTTX Air Lancair · Indianapolis, INThe pilots' failure to verify landing gear extension before landing.NTSB CEN13LA167Accident · No injuriesLimited investigationFinal reportCessna 172L · Idabel, OKThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN13CA151Accident · No injuriesData collectionFinal reportCessna 172 · Murphysboro, ILThe pilot’s failure to maintain control of the airplane during the takeoff roll.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…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 CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.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 WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.NTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Indian Trail, NCThe flight instructor’s failure to maintain adequate glidepath and airspeed control during short final approach and the airplane’s improper touchdown point, which resulted in a runway overrun.NTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.NTSB WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.NTSB ERA13CA086Accident · Serious injuriesData collectionFinal reportCessna 172P · Murfreesboro, TNThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.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 ERA13CA079Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Easton, MDThe pilot's failure to maintain directional control while landing.NTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.NTSB WPR13LA060Accident · No injuriesLimited investigationFinal reportPiper PA30 · Phoenix, AZThe pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…NTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.NTSB CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.NTSB WPR13CA039Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Carlsbad, CAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with parked aircraft. Contributing to the accident was the pilot's lack of experience in the airplane make/model.NTSB CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…NTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.NTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.NTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.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 ERA13CA051Accident · No injuriesData collectionFinal reportCessna 150L · Seneca Falls, NYThe pilot’s inadequate compensation for wind conditions during landing, which resulted in an impact with a drainage ditch.NTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.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 CEN13LA011Accident · No injuriesLimited investigationFinal reportMeyers Little Toot · Roanoke, TXThe total loss of engine power due to partially obstructed fuel lines.NTSB ERA13CA016Accident · No injuriesData collectionFinal reportCessna 172P · Cedar Key, FLThe pilot's failure to attain the proper touchdown point, which resulted in a runway excursion.NTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.NTSB CEN13CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Eden Prairie, MNThe pilot’s inadequate braking action and decision to abort the landing near the departure end of the runway. Contributing to the accident was the pilot’s attempt to land near the midpoint of the runway.NTSB ERA12IA582Incident · No injuriesIncident investigationFinal reportLearjet 60 · Teterboro, NJFailure of the nosewheel steering computer strut servo for reasons that could not be determined or replicated during postincident testing.NTSB ERA12CA573Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Berlin, NJThe pilot’s failure to maintain directional control during landing.