NTSB investigations
3,664 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 ERA11CA171Accident · No injuriesData collectionFinal reportAerostar PA-60-601P · Princeton, NJThe pilot’s failure to stop the airplane resulting in a runway overrun.NTSB CEN11FA220Accident · No injuriesField investigationFinal reportMooney M20J · Romeoville, ILThe collapse of the left main landing gear during the landing roll for undetermined reasons.NTSB CEN11FA193Accident · No injuriesField investigationFinal reportGulfstream Aerospace GV-SP · Appleton, WIThe pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…NTSB WPR11CA134Accident · No injuriesData collectionFinal reportBal-Air Inc/Wayne John K Christen Eagle · Groveland, CAThe pilot's failure to compensate for crosswind conditions and maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.NTSB CEN11CA181Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lansing, ILThe pilot’s loss of directional control during the landing.NTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.NTSB CEN11LA178Accident · No injuriesLimited investigationFinal reportBeech A36 · Danville, ILThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.NTSB WPR11CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Minden, NVThe pilot's loss of directional control during landing.NTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.NTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.NTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.NTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.NTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.NTSB WPR11CA109Accident · No injuriesData collectionFinal reportCessna 180H · Helena, MTThe certified flight instructor's loss of airplane control during the landing roll in a gusting crosswind.NTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA11CA125Accident · No injuriesData collectionFinal reportCessna 210K · Crestview, FLThe pilot's inability to maintain control of the airplane during landing due to the failure of the right main tire.NTSB CEN11CA165Accident · No injuriesData collectionFinal reportCulver Glenn Kitfox III · Terlingua, TXThe pilot's loss of directional control on takeoff.NTSB ERA11CA123Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Jasper, ALThe pilot's loss of directional control on a wet runway during takeoff from a touch and go landing resulting in a runway excursion.NTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.NTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.NTSB WPR11CA099Accident · No injuriesData collectionFinal reportDiamond DA20C1 · Spanish Fork, UTThe pilot’s failure to maintain directional control during landing.NTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.NTSB ERA11CA109Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lancaster, SCThe pilot's failure to maintain directional control during an attempted go-around maneuver after landing.NTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…NTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.NTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.NTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB CEN11CA140Accident · No injuriesData collectionFinal reportRockwell International 114A · North Lima, OHThe pilot’s failure to maintain directional control during the landing touchdown.NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB ERA11CA096Accident · No injuriesData collectionFinal reportCessna 172S · Fort Myers, FLThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot’s attempt to take off with full flaps.NTSB ANC11LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Saint Michael, AKThe loss of directional control during landing due to a flat nose wheel tire, resulting in a runway excursion and collision with trees.NTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…NTSB CEN11LA109Accident · Minor injuriesLimited investigationFinal reportCessna T182T · Moline, ILThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and noseover.NTSB DCA11WA067Incident · No injuriesForeign investigationBoeing 747 · Medina, Saudi ArabiaOn December 12, 2010, a Boeing 747-400, Saudi registration HZ-AWA1, serial number 27672, operated by Alwafeer Air as flight 1336, exited the left side of the runway after landing at Prince Mohammed Airport, Medina, Saudi Arabia. Two of the right hand main…NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA11LA084Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Rochester, NHThe out-of-rig condition of the tailwheel lock, which resulted in a loss of directional control on landing.NTSB DCA11WA010Incident · No injuriesForeign investigationBoeing 737-823 · Montreal, CanadaOn November 30, 2010, American Airlines flight AAL802, a Boeing 737-800, N901AN, departed the left side of runway 24R and stopped in the grass approximately 6600 feet down the runway while completing its landing roll at Montreal Pierre Elliott Trudeau…NTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.NTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.NTSB WPR11IA055Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Jackson, WYThe flight crew's inability to stop the airplane during landing roll on a snow- and ice-contaminated runway. Contributing to the runway overrun were the deteriorating runway conditions.NTSB WPR11FA052Accident · No injuriesField investigationFinal reportGates Lear Jet 25B · Portland, ORThe failure of the flight crew to stop the airplane on the runway due to the flying pilot’s failure to attain the proper touchdown point. Contributing to the accident was an anti-skid system that was not performing optimally, which allowed the airplane to…NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB ERA11WA073Accident · Minor injuriesForeign investigationSwearingen SA227 · Andahuaylas, PeruNTSB ERA11LA063Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Merritt Island, FLThe pilot's failure to maintain directional control while landing, which resulted in a main landing gear collapse and subsequent runway excursion.NTSB WPR11CA037Accident · No injuriesData collectionFinal reportCessna 172S · Port Townsend, WAThe pilot's improper flare/touchdown while landing, resulting in a loss of directional control and a runway excursion.NTSB WPR11CA035Accident · No injuriesData collectionFinal reportCessna 172S · Branscomb, CAThe pilot's failure to maintain clearance from trees during the landing roll on an unimproved airstrip.