NTSB investigations
3,663 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 ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.NTSB WPR14CA125Accident · No injuriesData collectionFinal reportCessna 172K · Eastsound, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing in gusty wind conditions.NTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.NTSB WPR14CA103Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · Renton, WAThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA14CA102Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe certificated flight instructor's failure to maintain helicopter control during a run-on landing, resulting in a rollover and ground collision.NTSB DCA14WA050Incident · No injuriesForeign investigationFairchild Industries SA226-TC · Archerfield, AustraliaOn January 23, 2014, a Fairchild Industries SA226-TC, registration number VH-OGX, experienced a runway excursion following landing at the Archerfield Airport (YBAF), Archerfield, Queensland, Australia. The airplane sustained minor damage and there were no…NTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.NTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.NTSB ERA14CA095Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Milledgeville, GAThe student pilots inadequate landing flare, which resulted in a hard landing.NTSB CEN14TA116Accident · Minor injuriesFinal reportAutogyro Mtosport · Spring, TXThe pilot’s failure to maintain the gyroplane’s rotor control during the landing roll in gusting crosswind conditions.NTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB ANC14CA013Accident · No injuriesData collectionFinal reportPiper PA 20 · Platinum, AKThe pilot's failure to maintain directional control during a crosswind landing.NTSB WPR14CA073Accident · No injuriesData collectionFinal reportCessna A185F · Carson City, NVThe pilot's failure to maintain directional control during landing which resulted in the airplane veering off the runway and nosing over.NTSB ERA14LA072Accident · No injuriesLimited investigationFinal reportCessna 182T · Burlington, NCA loss of airplane control during takeoff for reasons that could not be determined due to the postaccident condition of the elevator control system.NTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…NTSB ANC14LA011Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB WPR14CA067Accident · Serious injuriesData collectionFinal reportBeech 58P · Kalispell, MTThe pilot's failure to maintain airplane control during the landing sequence.NTSB DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaNTSB ERA14LA071Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Monroe, NCThe pilot’s operation of the airplane with underinflated tires, which resulted in the right tire’s failure during takeoff and a subsequent runway excursion.NTSB DCA14WA013Accident · No injuriesForeign investigationEmbraer ERJ190 - Undesignat · Buenos Aires, ArgentinaThe Junta de Investigaciones de Accidentes de Aviacion Civil (JIAAC) of the Republic of Argentina has notified the NTSB of an accident involving an Embraer E-190, which occurred on November 15, 2013. The NTSB has appointed a U.S. Accredited Representative to…NTSB ERA15WA034Accident · No injuriesForeign investigationBombardier CL 600 2B16 · Charallave, VenezuelaNTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.NTSB WPR14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Carefree, AZThe failure of the left brake master cylinder seal, which rendered the left brake inoperative during landing.NTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.NTSB WPR14CA043Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA 5B · Avalon, CAThe pilot's failure to maintain aircraft control while landing with a tailwind.NTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.NTSB CEN14CA055Accident · Minor injuriesData collectionFinal reportCessna 172N · Loveland, COA dragging right brake, which resulted in an un-commanded right turn, and subsequent ground loop.NTSB WPR14LA040Accident · Serious injuriesLimited investigationFinal reportMikoyan Gurevich MIG 21 UM · Reno, NVThe loss of brake control due to the fracture of the front brake pawl engagement spring, which resulted in a runway overrun.NTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.NTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.NTSB ERA14CA025Accident · No injuriesData collectionFinal reportMooney M20TN · Tylertown, MSThe pilot's misjudgment of speed and distance on final approach resulting in touchdown prior to the runway, a runway excursion down the right side of the runway, and a collision with an embankment.NTSB WPR14CA026Accident · No injuriesData collectionFinal reportCessna T210 - H · Lodi, CAThe student pilot's inadequate flare and failure to maintain directional control during landing.NTSB ERA14CA017Accident · Serious injuriesData collectionFinal reportBeech A36 · Burnsville, NCThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway excursion.NTSB ERA14CA016Accident · No injuriesData collectionFinal reportDenisar Richard A Lancair 320 · Lumberton, NJA hard landing by the pilot, which resulted in overload failure of landing gear components and surrounding structure.NTSB ERA14CA030Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Charleston, MSThe pilot's failure to maintain directional control, which resulted in a runway excursion and collision with a fence.NTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.NTSB ERA14LA005Accident · No injuriesLimited investigationFinal reportAerotek Pitts S 1T · Punta Gorda, FLThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot’s decision to operate the airplane with known ergonomic restrictions due to his size.NTSB ERA14LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Franklin, NCThe failure of the left main landing gear brake line during landing due to the loss of hydraulic fluid. Contributing to the accident was a fatigue crack through the brake line that had formed due to contact with a swaged sleeve as a result of exfoliation…NTSB WPR14CA018Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Las Vegas, NVThe collapse of a main landing gear for reasons that could not be determined due to no postaccident examination of the airframe.NTSB CEN14LA008Accident · No injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Wichita, KSThe pilot’s improper brake application during landing, which resulted in a loss of directional control.NTSB ERA14CA037Accident · No injuriesData collectionFinal reportPiper PA 28-150 · Newport, NHThe pilot's incorrect glide path, which resulted in a landing area overshoot and a runway excursion.NTSB WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.NTSB CEN14LA006Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Xenia, OHThe nose landing gear failure as a result of a fatigue fracture of the engine mount nose gear actuator feet in an area detailed in a service bulletin. Contributing to the accident was maintenance personnel’s inadequate completion of the inspection specified…NTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.NTSB CEN14WA083Accident · No injuriesForeign investigationRockwell Commander · Stockholm, Sweden, SwedenOn October 4, 2013, about 1250 UTC, a Rockwell Commander 112, SE-FLS (s/n 350) was involved in a runway excursion after landing when the pilot was unable to maintain directional control during roll out. The airplane was substantially damaged and there were no…NTSB WPR13FA430Accident · 4 fatalField investigationFinal reportCessna 525A · Santa Monica, CAThe pilot’s failure to adequately decrease the airplane’s ground speed or maintain directional control during the landing roll, which resulted in a runway excursion and collision with an airport sign and structure and a subsequent postcrash fire.NTSB WPR13LA419Accident · No injuriesLimited investigationFinal reportPiper PA60 602P · Sandpoint, IDThe pilot's failure to fly the approach at the appropriate landing speed and attain the correct touchdown point, which resulted in a runway overrun.NTSB CEN13LA567Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12 D · Laguna Park, TXThe pilot’s inadequate flare during landing, which resulted in a hard landing and the subsequent collapse of the left main landing gear.