NTSB investigations
799 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 ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.NTSB WPR25FA223Accident · 2 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · West Glacier, MTOn July 26, 2025, about 0942 mountain daylight time, a Grumman AA-5, N1342R, was destroyed when it was involved in an accident near West Glacier, Montana. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Windham, CTThe pilot’s inadequate preflight planning, which resulted in a rejected takeoff and subsequent runway excursion.NTSB DCA25WA273Incident · No injuriesClass 5 · ForeignBoeing 737 · Port Harcourt, NigeriaNTSB CEN25LA244Accident · Minor injuriesClass 4 · LimitedFinal reportCessna LC41-550FG · Lambertville, MIThe pilot’s failure to land at the manufacturer’s recommended approach speed, which resulted in a runway excursion, and impact with trees.NTSB WPR25LA187Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Kayenta, AZThe pilots’ failure to maintain airplane control during takeoff in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN25LA202Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26C · Hampshire, ILThe pilot’s failure to maintain a proper altitude during the approach, which resulted in overshooting the landing area, a runway excursion, and impact with terrain.NTSB GAA25WA179Accident · No injuriesClass 5 · ForeignCessna 310 · Lake Evella Aerodrome, AustraliaNTSB ANC25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Snohomish, WAThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun and collision with a fence.NTSB ERA25LA212Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Fremont, OHThe pilot’s inadequate takeoff performance planning, which resulted in a runway overrun and collision with terrain.NTSB ERA25LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Murfreesboro, TNThe pilot’s failure to maintain directional control of the airplane while attempting to take off in a gusty crosswind, which resulted in a runway excursion.NTSB WPR25LA160Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47 · Henderson, NVThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB WPR25LA157Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fullerton, CAThe pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB DCA25WA193Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Dushanbe, TajikistanNTSB WPR25LA124Accident · Serious injuriesClass 3 · LimitedPreliminary reportHonda HA-420 · North Bend, OROn April 7, 2025, at 0606 Pacific daylight time, a Honda Aircraft Company HA-420, N826E, was substantially damaged when it was involved in an accident in North Bend, Oregon. The pilot and three passengers sustained minor injuries; one passenger sustained…NTSB CEN25LA109Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · San Antonio, TXThe pilot’s failure to maintain directional control during a gusty crosswind landing.NTSB WPR25FA088Accident · 1 fatalClass 2 · FieldPreliminary reportGates Learjet 35A · Scottsdale, AZOn February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously…NTSB GAA25WA065Accident · No injuriesClass 5 · ForeignCessna 425 · Höxter, GermanyNTSB GAA25WA184Accident · No injuriesClass 5 · ForeignCessna 510 · Bankstown Aerodrome, AustraliaNTSB DCA25WA072Accident · 173 fatalClass 2 · ForeignBoeing 737 · Muan County, South KoreaNTSB DCA25WA073Accident · No injuriesClass 4 · ForeignBoeing 737 · Oslo, NorwayNTSB CEN25LA074Accident · No injuriesClass 3 · LimitedFinal reportCessna 560 · Pagosa Springs, COThe pilot’s inadequate preflight planning and poor preflight inspection and decision-making, which led to a takeoff attempt above the airplane’s certified maximum takeoff weight with snow-contaminated wings, resulting in a rejected takeoff at an airspeed…NTSB DCA25WA063Incident · No injuriesClass 5 · ForeignBoeing 737 · Molde, NorwayNTSB DCA25WA042OccurrenceClass 5 · ForeignBoeing 767 · Vancouver, CanadaNTSB GAA25WA062AccidentClass 5 · ForeignShort Bros SD3-60 · Roadtown, British Virgin IslandsNTSB CEN25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Willis, MIThe pilot’s failure to maintain a stabilized approach, that resulted in a runway excursion and subsequent collision with trees. Contributing to the accident, was the pilot’s decision to attempt to land to a closed runway.NTSB ERA25LA022Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Blountville, TNThe pilot’s failure to maintain directional control during takeoff and subsequent rejected takeoff, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to verify rudder trim setting prior to takeoff.NTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilNTSB DCA25WA289IncidentClass 5 · ForeignBoeing 737 · Phuket, ThailandNTSB DCA24WA306Accident · Serious injuriesClass 3 · ForeignATR ATR42 · Serui, IndonesiaNTSB ERA24LA373Accident · Minor injuriesClass 4 · LimitedFinal reportRaytheon 58 · Griffin, GAThe pilot’s failure to conduct a timely aborted landing, which resulted in a runway overrun.NTSB CEN24LA357Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA42 · Mandan, NDThe pilot’s failure to perform a go-around following an unstable approach while landing with a tailwind, which resulted in the airplane touching down long on the runway with insufficient distance to stop. Contributing to the accident was the pilot’s selected…NTSB DCA24WA305AccidentClass 3 · ForeignBoeing 737 · Malabo, Equatorial GuineaNTSB DCA24WA283Incident · No injuriesClass 5 · ForeignBoeing 737 · Monrovia, LiberiaNTSB GAA24WA310Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Suffolk, United KingdomNTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB CEN24LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lockhart, TXThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun.NTSB DCA24WA251Incident · No injuriesClass 5 · ForeignAirbus A332 · Katunayake, Sri LankaNTSB GAA24WA219Accident · No injuriesClass 5 · ForeignCessna 182 · Sapareva Banya, BulgariaNTSB CEN24LA256Accident · Minor injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Lone Oak, TXThe pilot having to take evasive action during the takeoff run to avoid another airplane being pushed onto the runway in front of him, which resulted in the airplane overrunning the runway and impacting a fence.NTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.NTSB DCA24WA212OccurrenceClass 5 · ForeignBoeing 737 · Bariloche, Río Negro, ArgentinaNTSB DCA24WA215OccurrenceClass 5 · ForeignBoeing 737 · Suvarnabhumi, ThailandNTSB CEN24LA234Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Ava, MOThe pilot’s failure to maintain control of the airplane resulting in a runway excursion during landing. Contributing to the accident was the degraded brake system on the airplane.NTSB CEN24LA214Accident · Minor injuriesClass 4 · LimitedFinal reportStinson Vultee V-77 · Slaton, TXThe pilot’s failure to maintain directional control after landing in gusting wind conditions which resulted in a runway excursion and the airplane nosing over. Contributing was the pilot’s decision to conduct the flight in very strong, gusting wind conditions.NTSB ERA24LA280Accident · No injuriesClass 4 · LimitedFinal reportLancair LC42-550FG · Beaufort, NCThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway overrun.NTSB DCA24WA198AccidentClass 5 · ForeignAirbus A320 · Christchurch, New ZealandNTSB ERA24LA231Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172S · Pierson, FLThe flight instructor’s failure to attain a proper touchdown point during a precautionary landing, which resulted in a runway excursion during landing.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.