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 ANC24LA026Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Paso Robles, CAThe flight instructor’s failure to maintain adequate airspeed during landing which resulted in a loss of directional control and runway excursion. Contributing to the accident was the pilot receiving instructions failure to maintain runway alignment.NTSB GAA24WA151Accident · No injuriesClass 5 · ForeignPiper PA28R · West End, BahamasNTSB CEN24LA156Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Monroe, LAThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA154Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Council Bluffs, IAThe pilot's failure to maintain directional control during the takeoff with a direct gusting crosswind.NTSB ERA24LA214Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · St. Augustine, FLThe incomplete extension of the landing gear into the down-and-locked position for reasons that could not be determined. .NTSB ERA24LA183Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Conyers, GAAn encounter with shifting wind conditions, which resulted in the airplane using more runway than anticipated, an aborted takeoff, and subsequent runway excursion. Contributing to the accident was the pilot’s failure account for the potential of variable and…NTSB WPR24LA120Accident · No injuriesClass 4 · LimitedFinal reportBeecraft Bonanza · Angel Fire, NMThe pilot's failure to maintain directional control of the airplane during takeoff with a gusting crosswind..NTSB ERA24LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech A23 24 · Somerset, PAThe student pilot’s failure to maintain directional control, and the flight instructor’s lack of remedial action during a landing attempt in a gusty wind, which resulted in a loss of directional control and runway excursion.NTSB ERA24LA145Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Melbourne, FLThe student pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA24LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Logan, WVThe pilot’s delayed decision to perform a go-around while attempting to land on a wet runway with a tailwind, which resulted in a runway overrun and collision with trees.NTSB CEN24LA134Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T182T · Lapeer, MIThe pilot’s failure to maintain aircraft control while landing in a gusting crosswind condition.NTSB GAA24WA112AccidentClass 5 · ForeignAir Tractor AT502 · San Alberto, Costa RicaNTSB ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA132Accident · No injuriesClass 4 · LimitedFinal reportPietenpol Aircamper · Lockhart, TXThe pilot’s failure to maintain control during after takeoff.NTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Paragould, ARThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.NTSB ERA24LA123Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Moultonborough, NHThe pilots’ failure to maintain directional control of the airplane during the landing.NTSB CEN24LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Watertown, SDThe stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing due to an undersized exhaust valve guide. Contributing to the accident were the improper manufacture of the engine cylinders, and the operation of…NTSB GAA24WA316Incident · No injuriesClass 4 · ForeignCirrus Design SF50 · Costa-Brava, Ghardaïa, AlgeriaNTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB WPR24LA097Accident · No injuriesClass 4 · LimitedFinal reportMark G Ellingson Kitfox IV · Mesa, AZThe pilot’s failure to maintain directional control during landing.NTSB CEN24LA115Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 400 · Bentonville, ARImproper rigging of the elevator cable over the upper guard pin, which resulted in a cable separation and loss of elevator control.NTSB ERA24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Melbourne, FLThe pilot receiving instruction’s failure to correctly identify the runway centerline prior to initiating the nighttime takeoff, which resulted in a collision with a runway edge light and subsequent runway excursion. Contributing to the accident was the…NTSB WPR24LA089Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Madera, CAThe pilot’s failure to maintain directional control during landing.NTSB DCA24LA095Incident · No injuriesClass 2 · LimitedFinal reportBoeing 737-823 · Dallas, TXImproper maintenance due to human error during a braking system modification diminished braking performance. Contributing to the diminished braking performance was the lack of a functional check to verify the flexible hydraulic hoses and transducer wiring…NTSB CEN24LA187Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Poole, NEThe non-certificated pilot’s failure to configure the airplane for takeoff, which resulted in a runway excursion.NTSB WPR24LA087Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20K · Burley, IDThe failure of the pilot to fly a stabilized approach during an emergency landing with a tailwind, which resulted in a bounced landing and subsequent runway excursion during the landing roll. Contributing to the accident was the pilot’s inadequate preflight…NTSB DCA24WA098Accident · No injuriesClass 5 · ForeignMcdonnell Douglas MD-82 · Malakal, SudanNTSB ERA24LA112Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30 · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind.NTSB ERA24LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301T · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll in a gusting crosswind.NTSB ERA24LA107Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Elizabethtown, NCThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, right main landing gear collapse, and a collision with a ditch.NTSB ERA24LA100Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Orlando, FLThe failure of the pilot flying to maintain directional control after touchdown with wind gusts that exceeded the airplane’s crosswind limitation. Contributing to the accident were the flightcrew’s continued approach to the runway despite the consistent wind…NTSB WPR24LA078Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Grass Valley, CALoss of control during the landing roll due to a malfunctioning brake for undetermined reasons.NTSB WPR24LA075Accident · Serious injuriesClass 3 · LimitedFinal reportHarmon Rocket II · Mesquite, NVThe pilot’s loss of control on the landing roll, which led to the airplane coming to rest inverted.NTSB WPR24LA071Accident · Minor injuriesClass 4 · LimitedFinal reportLearjet 55 · Livingston, MTThe flight crew’s decision to land on a snow-covered runway with a tailwind, resulting in a runway excursion and subsequent impact with terrain. Contributing to the accident, was the failure of the airport authority to plow the runway.NTSB ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…NTSB WPR24LA066Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Byron, CAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN24LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Middleton, WIThe student pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN24LA085Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · San Marcos, TXThe captain’s failure to perform a go-around following an unstable approach while landing with a gusty tailwind, which resulted in the airplane touching down long on the wet runway with insufficient distance to stop. Contributing to the accident was the…NTSB CEN24LA078Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 210M · Gulfport, MSThe pilot’s failure to maintain directional control during the go-around with a crosswind.NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.NTSB CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.NTSB CEN24LA056Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Fordyce, ARThe pilot’s failure to attain a proper touchdown point following an unidentified electrical system failure and subsequent partial loss of engine power, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s…NTSB WPR24LA046Accident · Serious injuriesClass 3 · LimitedFinal reportCessna P210N · Big Bear, CAA loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.NTSB GAA24WA054Accident · No injuriesClass 5 · ForeignCessna A188 · Ipiranga do Norte, Brazil