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 GAA21WA131Accident · No injuriesClass 5 · ForeignCessna 340 · Essex, United KingdomNTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.NTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.NTSB CEN21LA236Accident · No injuriesClass 4 · LimitedFinal reportBerry TX-11C · Longmont, COThe pilot’s loss of directional control when his foot became stuck on a protruding bolt in the airplane’s floorboard.NTSB CEN21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · McAllen, TXThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a runway sign.NTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.NTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.NTSB CEN21LA228Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Pinecreek, MNThe pilot’s failure to maintain control of the airplane in gusting crosswind conditions.NTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.NTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.NTSB CEN21LA227Accident · No injuriesClass 4 · LimitedFinal reportVarner David L Vans RV-8 · Watkins, COThe pilot’s failure to maintain control of the airplane during landing.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB ANC21LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cold Bay, AKThe pilot’s failure to maintain directional control during takeoff in a gusty crosswind condition.NTSB ERA21LA208Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aerospace Industries Gulfstream G150 · Ridgeland, SCThe flight crew’s continuation of an unstable approach and the failure of the ground air brakes to deploy upon touchdown, both of which resulted in the runway overrun. Contributing was the crew’s motivation and response to external pressures to complete the…NTSB ERA21LA204Accident · Minor injuriesClass 4 · LimitedFinal reportJabiru Aircraft PTY J170-D · Winchester, VAThe pilot’s loss of directional control on landing. Contributing to the outcome was the pilot’s decision to continue the aborted landing after the airplane had departed the runway surface.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB ERA21LA205Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Columbia, KYThe pilot’s failure to obtain a proper touchdown point on the runway, which resulted in a runway excursion.NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB GAA21WA090Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Buckinghamshire, United KingdomNTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB GAA21WA082Accident · 1 fatalClass 5 · ForeignLearjet 35 · Belo Horizonte, BrazilNTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA181Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Stockbridge, GAThe flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.NTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.NTSB ERA21LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Fayetteville, NCThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.NTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.NTSB ERA21LA162Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 1730 · Bessemer, ALThe pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.NTSB ERA21LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · West Chester, PAThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with airport lights and a hangar.NTSB DCA21WA099Accident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB CEN21LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Watkins, COThe pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB ERA21LA156Accident · Serious injuriesClass 3 · LimitedFinal reportSchempp-Hirth K G MINI-NIMBUS C · Groveland, FLThe pilot’s unsuccessful initial attempt to release from the tow plane at the start of an unstable takeoff roll, which resulted in a runway excursion and collision with a parked vehicle. Contributing to the severity of the accident was the vehicle’s proximity…NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB CEN21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Port Aransas, TXThe pilot’s failure to maintain proper airspeed on approach and his attempt to land on a wet runway with insufficient runway remaining, resulting in an overrun and loss of directional control.NTSB ERA21LA152Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Franklin, NCThe reason for this accident could not be determined based on the available information.NTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.NTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.NTSB GAA21WA046Incident · No injuriesClass 4 · ForeignHawker Beechcraft 4000 · Plettenburg Bay Airfield, South AfricaNTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB ERA21LA134Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · St. Marys, PAThe pilot’s decision to continue the approach to a snow-covered runway in low-visibility conditions with limited ability to visually differentiate the left runway edge from the snow berm that ran along that side of the runway.NTSB CEN21LA137Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · Kansas City, MOThe loss of directional control during landing for reasons that could not be determined.NTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…