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 WPR20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV-8 · McMinnville, ORThe pilot's failure to maintain directional control during takeoff which resulted in a collision with a runway marker.NTSB ERA20CA233Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 8 · Perkasie, PAThe pilot’s loss of directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and collision with a ditch.NTSB ANC20CA061Accident · No injuriesClass 4 · Data collectionFinal reportBeech A36 · Chignik Lagoon, AKThe pilot's improper approach, which resulted in a long landing and a runway overrun.NTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.NTSB ERA20LA230Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Williston, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion and nose landing gear collapse.NTSB ERA20CA215Accident · No injuriesClass 4 · Data collectionFinal reportPipistrel Pipistrel Sinus 912 · Brookline, NHThe pilot's failure to maintain airspeed while landing with a quartering tailwind, which resulted in a loss of control and a hard landing.NTSB ENG20WA036Accident · No injuriesClass 5 · ForeignDornier 228 · North Brabant, NetherlandsNTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.NTSB WPR20CA167Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Las Vegas, NVThe student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.NTSB DCA20WA112Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing MD11 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB CEN20CA202Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Arlington, TXThe pilot's failure to maintain airplane directional control during a gusty crosswind landing.NTSB ANC20CA057Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Palmer, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN20CA191Accident · No injuriesClass 4 · Data collectionFinal reportPietenpol Aircamper · Midland, MIThe pilot's loss of control during an aborted landing.NTSB ERA20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV8 · Hampton, GAA right main landing gear break malfunction during landing. Contributing to the accident was a worn right main landing gear caliper pin and pressure plate hole.NTSB ERA20CA189Accident · No injuriesClass 4 · Data collectionFinal reportZenith Zodiac CH 650 · Carthage, NCThe pilot's failure to attain the proper touchdown point during landing with a tail wind, which resulted in a runway excursion.NTSB CEN20LA174Accident · No injuriesClass 3 · LimitedFinal reportCessna T240 · Gonazales, TXThe pilot's failure to retract the speedbrakes during a delayed go-around attempt, which resulted in a runway excursion.NTSB CEN20CA163Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Longmont, COThe pilot's loss of control during a go around.NTSB CEN20CA161Accident · No injuriesData collectionFinal reportPiper PA 20 · Colorado Springs, COThe flight instructor's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control.NTSB ERA20LA163Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · East Hampton, NYThe partial loss of engine power after takeoff due to the formation of carburetor ice while on the ground. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB ERA20LA162Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 · Fort Lauderdale, FLThe pilot’s inadequate preflight planning, resulting in an attempted takeoff in excess of the airplane’s maximum allowable weight given it’s configuration and the temperature.NTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.NTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.NTSB CEN20CA158Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · El Campo, TXThe pilot's misjudgment of a ground spray rig’s position and his incorrect belief that a runway incursion might occur, which resulted in the pilot attempting and then aborting a go-around, which resulted in a runway excursion and collision with a fence.NTSB ERA20CA153Accident · No injuriesData collectionFinal reportLancair Super ES · Merritt Island, FLThe pilot's failure to maintain a stabilized approach and improper landing flare, which resulted in a porpoised landing.NTSB CEN20CA151Accident · No injuriesData collectionFinal reportEagle Eagle DW 1 · Hudson, COThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and nose-over.NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.NTSB CEN21WA076Accident · Serious injuriesClass 5 · ForeignCessna T303 · Annecy Meythetf, FranceNTSB CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.NTSB WPR20WA114Accident · 8 fatalForeign investigationIsrael Aircraft Industries 1124A · Manilla, PhilippinesThe government of the Philippines has notified the NTSB of an accident involving an Israel Aircraft Industries 1124A airplane that occurred on March 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the…NTSB WPR20LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sedona, AZThe pilot’s loss of pitch control while landing in crosswind conditions, which resulted in a collapsed nose gear and departure of the airplane from the runway.NTSB ANC20CA040Accident · No injuriesData collectionFinal reportPiper PA32 · Fairbanks, AKThe pilot's inadequate compensation for gusting crosswind conditions, which resulted in a loss of directional control, a runway excursion, and impact with a snowbank.NTSB ERA20CA142Accident · No injuriesData collectionFinal reportCirrus SR20 · Stow, MAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with vegetation.NTSB ANC20CA039Accident · No injuriesData collectionFinal reportWag-Aero Sportsman 2+2 · Wasilla, AKThe pilot's loss of directional control during takeoff from an icy ski strip in gusting wind conditions, which resulted in the left wing impacting a tree.NTSB CEN20LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Harrisville, MIThe pilot’s loss of directional control during landing rollout in gusty crosswind conditions, resulting in a runway excursion and collision with trees.NTSB CEN20CA128Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.NTSB ANC20CA034Accident · Minor injuriesData collectionFinal reportCessna 172 · Kahului, HIThe student pilot's failure to avoid wake turbulence while landing behind a heavy jet airplane, which resulted in a loss of roll control and subsequent hard landing.NTSB WPR20LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Scottsdale, AZThe pilot’s inability to maintain directional control during landing for undetermined reasons, which resulted in a runway excursion.NTSB WPR20CA138Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Tucson, AZThe student pilot's loss of directional control during landing, which resulted in a runway excursion, collision with a pole, and a subsequent ground loop.NTSB ERA20WA193Accident · 2 fatalClass 3 · ForeignCessna 525 · El Yaque, VenezuelaNTSB ERA20CA141Accident · No injuriesData collectionFinal reportCessna 172 · Ocean City, MDThe pilot's failure to maintain directional control during an attempted go-around to avoid birds, which resulted in a runway excursion and subsequent nose-over.NTSB CEN20CA117Accident · Minor injuriesData collectionFinal reportPiper PA28-180 · Eolia, MOThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing, loss of directional control, runway excursion, and impact with a tree.NTSB CEN20CA115Accident · No injuriesData collectionFinal reportMooney M20K · New Orleans, LAThe pilot's improper decision to turn the airplane from the runway onto the taxiway at an excessive speed, which resulted in a loss of directional control, runway excursion, and collision with a taxiway sign.NTSB WPR20CA112Accident · No injuriesData collectionFinal reportDe Havilland DHC6 · Boulder City, NVThe trainee pilot's loss of directional control during landing and his subsequent unintentional control interference with the brakes and/or rudder during the trainer pilot's attempted remedial action, which resulted in a runway excursion and collision with a…NTSB WPR20CA100Accident · No injuriesData collectionFinal reportPiper PA28R · Twin Falls, IDThe pilot's loss of directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and impact with a runway approach light.NTSB WPR20LA099Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Moab, UTThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and the airplane’s subsequent noseover.NTSB CEN20CA114Accident · No injuriesData collectionFinal reportVans RV8 · Harrison, OHThe malfunction of the steerable tailwheel, which resulted in a loss of directional control during the landing roll and subsequent impact with the precision approach path indicator lights system.