NTSB investigations
3,662 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 GAA17CA281Accident · No injuriesData collectionFinal reportPiper PA22 · South Boston, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ANC17CA023Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL 104 Wilga 80 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the pilot's lack of training and experience in the accident make and model airplane.NTSB CEN17LA185Accident · No injuriesLimited investigationFinal reportMooney M20TN · Grandby, COThe total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA277Accident · No injuriesData collectionFinal reportCessna 172 · Boca Raton, FLThe student pilot’s failure to maintain directional control of the airplane while landing with a tailwind.NTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB GAA17CA272Accident · No injuriesData collectionFinal reportJohn Murphy JSX-2 · Chesterfield, MOThe pilot’s failure to ensure that the canopy was properly secured before takeoff, which resulted in an unstable landing flare and hard landing.NTSB GAA17CA271Accident · No injuriesData collectionFinal reportCessna A185 · Big Rapids, MIThe pilot’s failure to obtain updated weather information while practicing takeoffs and landings and his subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA17CA284Accident · No injuriesData collectionFinal reportCessna 170 · Taos, NMThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA273Accident · No injuriesData collectionFinal reportAdrian George W Europa Classic · Wellington, KSThe pilot’s improper landing flare and exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA17CA257Accident · Minor injuriesData collectionFinal reportNelson Sydney Vans Acft RV8A · Englewood, COThe pilot's improper landing flare and inadvertent selection of the mixture control, which resulted in a hard, bounced landing during gusting crosswind wind conditions.NTSB GAA17CA266Accident · No injuriesData collectionFinal reportCessna T182 · Portage County Airport, OHThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB GAA17CA249Accident · No injuriesData collectionFinal reportCessna 177 · Marathon, NYThe pilot’s failure to maintain altitude and airspeed while maneuvering at a low altitude.NTSB GAA17CA248Accident · No injuriesData collectionFinal reportCessna 172S · Jean, NVThe pilot’s runway selection, which resulted in landing with a tailwind and an unstabilized approach and subsequent runway overrun.NTSB DCA17WA106Accident · No injuriesForeign investigationBoeing 737 · Keflavik, IcelandThe AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on April 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Iceland's investigation under the provisions of ICAO Annex…NTSB GAA17CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Van Nuys, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind.NTSB GAA17CA349Accident · No injuriesData collectionFinal reportPiper PA44 · Tulsa, OKThe pilot receiving instruction’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA238Accident · No injuriesData collectionFinal reportCheung David S Vans RV6 · Indianola, IAThe pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.NTSB GAA17CA231Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with crosswind conditions.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB DCA17WA105Accident · No injuriesForeign investigationBoeing 737 · Sibu Warawak, MalaysiaThe Malaysian Department of Civil Aviation (DCA) has notified the NTSB of an accident involving a Boeing 737, which occurred on April 8, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DCA investigation under the provisions of ICAO…NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB GAA17CA214Accident · Minor injuriesData collectionFinal reportRonald J Bender Baking Duce · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll after encountering a dirt devil.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB GAA17CA212Accident · No injuriesData collectionFinal reportThomas Craig E Wittman W-10 · Stevensville, MTThe pilot’s decision to take off with a known master brake cylinder leak and his subsequent failure to maintain directional control during landing.NTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA17CA137Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Cleveland, TNThe flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.NTSB GAA17CA203Accident · No injuriesData collectionFinal reportAeronca 11AC · Warroad, MNThe pilot’s improper landing flare and his subsequent failure to maintain directional control during the landing in tailwind conditions.NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…NTSB GAA17CA201Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot’s use of excessive airspeed during the approach, which resulted in a bounced, hard landing and subsequent loss of directional control during an attempted go-around.NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB GAA17CA195Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Mosby, MOThe student pilot's failure to maintain directional control during an attempted go-around.NTSB GAA17CA186Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.NTSB WPR17FA077Accident · 1 fatalField investigationFinal reportChallenger II · Oakdale, CAThe pilot's failure to attain a proper touchdown point and his subsequent loss of directional control during landing for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would…NTSB GAA17CA190Accident · Minor injuriesData collectionFinal reportDavis Frank R Xenos Motorglider · Minden, NVThe pilot’s failure to maintain directional control in variable wind conditions.NTSB GAA17CA182Accident · Serious injuriesData collectionFinal reportPedersen Bjarne Martin Sportsman GS-2 · Robbinsville, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB GAA17CA164Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prentiss, MSThe pilot's decision to take off with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.