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 CEN23LA152Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Goldsby, OKThe engine electronic ignition system became disconnected, which resulted in a partial loss of engine power.NTSB WPR23LA152Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Los Alamos, NMThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion and ground collision.NTSB ERA23LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 421C · Leesburg, VASeparation of the left man landing gear scissor hardware, which resulted in a loss of directional control and subsequent runway excursion during landing.NTSB ERA23LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · White Plains, NYThe pilot's failure to maintain directional control during the landing rollout in gusting wind, which resulted in a runway excursion and subsequent nose over.NTSB ERA23LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Canton, GAThe pilot’s failure to maintain directional control following a bounced landing, which resulted in a runway excursion and a nose over.NTSB ERA23LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 750 · Wall Township, NJThe pilots’ loss of directional control while landing in gusting wind conditions which resulted in a runway excursion. Also contributing was the flight crew’s decision to land at an airport where there was a rapidly approaching severe thunderstorm.NTSB ERA23LA177Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Leesburg, FLThe flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA23LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Mattituck, NYThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a hard landing and runway excursion.NTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA23LA165Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · St. Augustine, FLThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and an impact with a ditch.NTSB ERA23LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, NCA loss of directional control while landing, which resulted in a runway excursion and impact with a ditch.NTSB CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.NTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.NTSB DCA23WA204Incident · No injuriesClass 5 · ForeignBombardier BD500 · Riga, LatviaNTSB ERA23LA145Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Knoxville, TNThe pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.NTSB CEN23LA134Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Buena Vista, COThe pilot’s inability to maintain directional control during landing with a gusting left crosswind resulting in the runway excursion.NTSB GAA23WA088AccidentClass 5 · ForeignCessna 337G · Itzehoe, GermanyNTSB ERA23LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 182S · Labelle, FLA malfunction of the airplane’s right main wheel brake, which resulted in a loss of control and runway excursion during landing.NTSB CEN23LA121Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Oklahoma City, OKThe pilot’s failure to maintain directional control during the landing, that resulted in a runway excursion, and an impact with an obstacle.NTSB CEN23LA117Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Guthrie, OKThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Grand Prairie, TXThe pilot’s failure to extend the landing gear before landing.NTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB ERA23LA150Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fernandina Beach, FLThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions, with resulted in a runway excursion and collision with a runway identifier sign.NTSB CEN23LA112Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Houston, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the pilot’s decision to land with a crosswind that exceeded the limitation for the airplane.NTSB CEN23LA104Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SF50 · Waukesha, WIThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident was the pilot’s inadequate preflight inspection removal of the angle of attack vane cover.NTSB WPR23LA108Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Lander, WYThe pilot’s failure to maintain directional control during landing.NTSB ERA23LA125Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Pikeville, NCThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB CEN23LA109Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Montevideo, MNThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaNTSB ERA23LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46 · Port Orange, FLThe pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees.NTSB ANC23LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control while landing with a crosswind on an ice-covered runway, resulting in a loss of control and subsequent impact with a snowbank. A factor was the check airman’s inadequate supervision.NTSB CEN23LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Limon, COThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA23LA120Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Calhoun, GAA partial loss of engine power during the initial climb due to an improperly installed spark plug.NTSB DCA23WA143IncidentClass 5 · ForeignBoeing 777-319ER · Auckland, New ZealandNTSB CEN23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.NTSB CEN23LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Brush, COThe pilot’s failure to maintain directional control during the landing roll with strong gusty surface winds.NTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.NTSB DCA23WA127IncidentClass 5 · ForeignAirbus A330-323 · Amsterdam, NetherlandsNTSB ERA23LA102Accident · No injuriesClass 4 · LimitedFinal reportStray Goose Research Aircam · Calhoun, GAThe pilot’s inadvertent asymmetric throttle application, which resulted in a loss of directional control during the landing roll, runway excursion, and collision with ground equipment.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA23WA047Incident · No injuriesClass 3 · ForeignCessna 750 · Rionegro, ColombiaNTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.NTSB ERA23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ethel, WVThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB WPR23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 210N · Morgan, UTFailure of the brake system O-rings on the left landing gear trunnion, which allowed the hydraulic fluid to drain from the left brake system, resulting in a runway excursion and impact with a fence.NTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.NTSB GAA23WA094Accident · No injuriesClass 5 · ForeignMooney M20R · Vélez-Málaga, Spain