NTSB investigations
3,659 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 CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB GAA25WA266Accident · 2 fatalClass 3 · ForeignLearjet 55 · La Guaira, VenezuelaNTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA25LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Blue Ridge, GAThe pilot’s failure to obtain the proper touchdown point, which resulted in a runway overrun.NTSB GAA25WA283AccidentClass 5 · ForeignGulfstream GIV · Singapore, SingaporeNTSB ERA25LA355Accident · No injuriesClass 4 · LimitedFinal reportLamphere David A Wittman Buttercup · Monterey, VAThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB ERA25LA353Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 525C · Mayfield, KYOn September 18, 2025, about 1640 central daylight time, a Cessna 525C, N577RT, was substantially damaged when it was involved in an accident near Mayfield, Kentucky. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA280Accident · No injuriesClass 4 · LimitedFinal reportWeaver Harmon Rocket · Hayden, IDThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ERA25LA349Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Virus 912 LSA · Lincoln Park, NJThe pilot’s inadequate compensation for variable wind conditions, which resulted in a hard landing and loss of directional control.NTSB DCA25WA328Incident · No injuriesClass 5 · ForeignBoeing 737 · Krakow, PolandNTSB CEN25LA375Accident · Minor injuriesClass 4 · LimitedFinal reportJust Highlander · Forest Lake, MNThe pilot’s failure to maintain directional control of the airplane during a gusty crosswind landing.NTSB DCA25WA319Incident · No injuriesClass 5 · ForeignBoeing 737 · Munster, GermanyNTSB CEN25LA365Accident · No injuriesClass 3 · LimitedPreliminary reportIsrael Aerospace Industriesltd Gulfstream G150 · Wheeling, ILOn September 3, 2025, at 1211 central daylight time, an Israel Aerospace Industries Ltd. Gulfstream G150, N1927G, was substantially damaged when it was involved in an accident at Chicago Executive Airport (PWK), Wheeling, Illinois. The pilot and copilot were…NTSB ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.NTSB ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.NTSB CEN25LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Baldwin City, KSThe pilot’s decision to continue the night landing without runway lights which resulted in the runway overrun.NTSB CEN25LA351Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nora Springs, IAThe pilot’s improper decision-making for the attempted landing, which resulted in a runway overrun due to inadequate runway landing distance with a quartering tailwind. Contributing to the accident was the wet condition of the runway.NTSB ERA25LA328Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Montauk, NYThe pilot’s failure to verify the wind direction and maintain an appropriate approach speed, which resulted in a long landing and subsequent runway excursion.NTSB CEN25LA407Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · Maryville, MOThe left landing gear collapsed on landing rollout due to a fractured retract bellcrank on the left landing gear lower fork assembly.NTSB ERA25LA317Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Knoxville, TNThe pilot’s failure to maintain directional control during landing roll in a crosswind, which resulted in a runway excursion and a subsequent ground loop.NTSB ERA25LA339Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Charleston, WVA flat left main landing gear tire, which resulted in a loss of directional control and runway excursion during landing.NTSB WPR25LA263Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Lakeview, ORThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB ERA25LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Fitchburg, MAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN25LA338Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Fargo, NDThe pilot’s failure to maintain directional control during landing with a gusting crosswind. Contributing to the accident was the closure of the wind aligned runway 27.NTSB ERA25LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Gaithersburg, MDThe flight instructor’s distraction during landing, which resulted in a long landing and subsequent runway excursion.NTSB WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.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 ERA25LA378Accident · Minor injuriesClass 3 · LimitedPreliminary reportThrush S2R-T660 · Albany, GAOn August 18, 2025, about 0944 EST, a Thrush Aircraft LLC S2R-T660, N7001B, was substantially damaged when it was involved in an accident at Southwest Georgia Regional Airport, Albany, Georgia. The commercial pilot sustained minor injuries. The airplane was…NTSB CEN25LA325Accident · No injuriesClass 4 · LimitedFinal reportHelio H-391B · Monroe, MIThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB ERA25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Rangeley, METhe pilot’s failure to maintain control of the airplane during landing, which resulted in a runway excursion and subsequent nose over.NTSB CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.NTSB ANC25LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Anchorage, AKThe pilot’s decision to continue an unstabilized approach, which resulted in a landing touchdown with insufficient runway remaining and a subsequent runway overrun and a collision with a fence.NTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB WPR25LA229Accident · No injuriesClass 4 · LimitedFinal reportLake Tahoe Properties CA 8 · Davenport, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.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 CEN25LA287Accident · No injuriesClass 4 · LimitedFinal reportAerotek Pitts S-2A · New Holstein, WIThe pilot’s loss of direction control during landing due to an unapproved tailwheel assembly and tail spring that resulted in a tailwheel shimmy and a subsequent ground loop.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 CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB ERA25LA276Accident · No injuriesClass 4 · LimitedFinal reportHoward DGA-15P · Farmingdale, NYThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ANC25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Gulkana, AKThe failure of the left rudder assembly which resulted in a runway excursion and ground loop.NTSB CEN25LA254Accident · No injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Russellville, INThe pilot’s failure to establish and maintain the airstrip centerline during takeoff, which resulted in the airplane’s right wingtips contacting the corn that bordered the airstrip.NTSB DCA25WA273Incident · No injuriesClass 5 · ForeignBoeing 737 · Port Harcourt, NigeriaNTSB ANC25LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Dillingham, AKThe pilot’s failure to maintain direction control during takeoff roll which resulted in a ground loop, and subsequent runway excursion.NTSB 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 CEN25LA246Accident · No injuriesClass 4 · LimitedFinal reportThorp T18 · Lake Elmo, MNThe pilot’s failure to maintain obstacle clearance during the go-around, that resulted in the tailwheel impacting a taxiway sign, a subsequent loss of control due to the damaged tailwheel, and a runway excursion during the landing.