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 DCA15WA127Incident · No injuriesForeign investigationBoeing 737 - 883 · Oslo, NorwayThe Accident Investigation Board Norway (AIBN) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on May 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AIBN investigation under the provisions of…NTSB GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.NTSB GAA15CA073Accident · No injuriesData collectionFinal reportCessna 182T · Newburyport, MAThe pilot's failure to recover from a bounced landing, which resulted in substantial damage to the airplane during the runway overrun.NTSB ERA15LA192Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Fort Myers, FLThe pilot's improper decision to land the airplane with a quartering, gusting tailwind and his subsequent failure to flare the airplane and maintain directional control after it bounced, which resulted in a runway excursion.NTSB GAA15CA055Accident · No injuriesData collectionFinal reportBeech C 50 · Honesdale, PAThe pilot's failure to stop the airplane on the runway during landing, resulting in an overrun, landing gear collapse and substantial damage to the airplane.NTSB GAA15CA040Accident · No injuriesData collectionFinal reportTrom Wayne Vans RV6A · LaFayette, GAThe pilot's failure to maintain directional control during the landing roll in variable, gusting wind conditions, resulting in a runway excursion, and substantial damage to the airplane.NTSB GAA15CA034Accident · Minor injuriesData collectionFinal reportCessna 182F · Portland, TNThe pilot's failure to perform a go-around in time to prevent a runway overrun and collision with terrain.NTSB GAA15CA030Accident · No injuriesData collectionFinal reportCessna R172E · Fort Meade, MDThe flight instructor's decision to land the airplane without sufficient runway to stop, resulting in a runway excursion and substantial damage to the right wing of the airplane.NTSB ERA15LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Woodstock, GAThe pilot's failure to attain the proper touchdown point on the short, wet, turf runway. Contributing to the accident was the pilot’s use of a high approach speed.NTSB GAA15CA072Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA40 · Fuquay-Varina, NCThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway overrun.NTSB WPR15CA114Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.NTSB CEN15LA053Accident · Minor injuriesLimited investigationFinal reportBeech 58P · San Antonio, TXThe pilot’s improper decision to land long (past the midpoint) on a wet runway and his failure to conduct a go-around when the airplane did not touch down at the approach end of the runway, which resulted in an overrun.NTSB ERA15CA045Accident · No injuriesData collectionFinal reportBeech V35B · Vicksburg, MSThe pilot's failure to maintain directional control while landing in variable wind conditions, resulting in a runway excursion and collision with an object.NTSB CEN15CA029Accident · No injuriesData collectionFinal reportDoubleday Donald Thorp TS-18CW · Reklaw, TXThe pilot's inadequate monitoring of the airplane's approach path which resulted in long landing and a subsequent runway excursion. Contributing to the accident was the pilot's delayed decision to apply the brakes, inflight traffic, and nearby pedestrians.NTSB CEN15TA019Accident · No injuriesFinal reportBAE Systems Hawk MK 67 · Oklahoma City, OKThe loss of directional control during the takeoff roll for reasons that could not be determined during postaccident examinations and testing.NTSB ANC15CA002Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cordova, AKThe pilots decision to land and failure to maintain control of the airplane during landing in gusty wind conditions.NTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.NTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…NTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.NTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.NTSB WPR14CA364Accident · No injuriesData collectionFinal reportFlight Design Ctls LSA · Grass Valley, CAThe pilot's inadequate flare which resulted in a loss of aircraft control during landing.NTSB CEN14CA483Accident · No injuriesData collectionFinal reportRoss Alfred K/Oneill Terrence Lancair 235 · Longmont, COThe pilot's inadvertent application of the brake which resulted in the loss of directional control during the landing roll.NTSB WPR14CA334Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Bakersfield, CAThe pilot's failure to maintain an adequate approach which resulted in a long landing and runway overrun.NTSB ERA14CA375Accident · Minor injuriesData collectionFinal reportCessna 172N · Valkaria, FLThe pilot's misjudgment of speed and distance on final approach during a precautionary landing, resulting in a touchdown off the departure end of the runway and collision with terrain. A factor in the accident was a partial loss of engine power for reasons…NTSB CEN14FA399Accident · 1 fatalField investigationFinal reportZimmerman Breezy · Oshkosh, WIThe pilot’s failure to maintain airplane control during landing while the air traffic controller was simultaneously coordinating the landing of three airplanes on the same runway, which resulted in the airplane exiting the runway and impacting a parked ground…NTSB ANC14LA058Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 · Talkeetna, AKThe pilot’s inadequate preflight inspection that did not detect that the bulk fuel tank was full and led to an unanticipated heavy airplane weight and his failure to use the entire soft, wet, and muddy airstrip length for takeoff, which resulted in a takeoff…NTSB WPR14CA294Accident · Minor injuriesData collectionFinal reportThrush S2RHG T65 · Parma, IDThe pilot's decision to take off with a tailwind, which resulted in the airplane not attaining sufficient airspeed for takeoff.NTSB WPR14LA250Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alturas, CAThe airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB ERA14MA271Accident · 7 fatalClass 1 · MajorFinal reportGulfstream Aerospace G IV · Bedford, MAThe flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…NTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.NTSB CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB WPR14CA210Accident · No injuriesData collectionFinal reportMeyers OTW 160 · Tehachapi, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with a fence.NTSB WPR14CA401Accident · No injuriesData collectionFinal reportPiper PA 22 · Roundup, MTThe pilot's delayed action to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude.NTSB ERA14LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · Elkton, MDThe pilot’s failure to attain the proper touchdown point during a no-flap landing to a wet, down-sloping runway, and the airplane's dynamic hydroplaning after touchdown, which resulted in a runway overrun. Contributing to the accident was a total loss of…NTSB DCA14WA115Accident · Minor injuriesForeign investigationBoeing 737-400 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving a Boeing 737-400 that occurred on May 8, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ACAA investigation under the provisions of ICAO…NTSB WPR14CA178Accident · Minor injuriesData collectionFinal reportElemdorf 1002 · Rexburg, IDThe pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.NTSB ERA14IA237Incident · No injuriesIncident investigationFinal reportCessna 525 · Port Orange, FLThe pilot's failure to attain a proper touchdown point during landing and his failure to go around when he recognized that he would not be able to stop the airplane on the runway, which resulted in a runway excursion.NTSB WPR14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Anacortes, WAThe pilot's improper application of brakes during the landing roll resulted in a runway excursion and nose over.NTSB WPR14CA156Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Mesa, AZThe student pilot's excessive speed during taxi which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate monitoring of the remaining runway length available during the landing roll.NTSB ERA14LA159Accident · No injuriesLimited investigationFinal reportCessna 500 · Zephyrhills, FLThe pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.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 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 DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaNTSB 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 WPR14CA043Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA 5B · Avalon, CAThe pilot's failure to maintain aircraft control while landing with a tailwind.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 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 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 CEN13CA549Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Conway, ARThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a blast fence.