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 CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.NTSB ERA11CA407Accident · No injuriesData collectionFinal reportCessna 180J · Schlater, MSThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB ERA11CA404Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Adams, NYThe pilot's loss of directional control during landing.NTSB ERA11CA402Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crystal River, FLThe pilot's failure to attain the proper touchdown point, and his improper decision to perform a go-around with a tailwind and insufficient runway remaining.NTSB DCA11WA120Incident · No injuriesForeign investigationCessna 560 - XL · Port Harcout, NigeriaOn July 14, 2011 about 1853 UTC, 5N-BMM, Cessna 560XLS, operated by Bristow Helicopters Limited, was involved in a runway excursion while landing at Port Harcourt, Nigeria. There was no injuries to the six persons on board. The aircraft received minor damage.…NTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.NTSB CEN11CA470Accident · No injuriesData collectionFinal reportRans S7 · Cubero, NMThe pilot's failure to attain rotation speed prior to takeoff.NTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…NTSB WPR11CA323Accident · No injuriesData collectionFinal reportTL Ultralight Sro Stingsport · Soda Springs, IDThe pilot's improper landing flare and failure to maintain directional control during the landing.NTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.NTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.NTSB WPR11CA310Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Whitefish, MTThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of recent experience in a tailwheel equipped airplane.NTSB ERA11CA381Accident · Minor injuriesData collectionFinal reportSchleicher ASW-28 · Hugguenot, NYThe pilot's failure to attain the proper touchdown point during a tailwind landing.NTSB WPR11CA314Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Spanish Fork, UTThe pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control.NTSB CEN11CA462Accident · No injuriesData collectionFinal reportMooney M20S · Washington Island, WIThe pilot's failure to maintain aircraft control during the landing and his delayed remedial action to abort the landing.NTSB CEN11CA447Accident · Minor injuriesData collectionFinal reportArion Lightning LS-1 · Garden City, KSThe pilot's failure to maintain aircraft control while landing.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB ERA11LA386Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Louisville, KYThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a landing gear collapse.NTSB ERA11CA375Accident · No injuriesData collectionFinal reportTemco GC-1B · Sparta, TNThe improper installation of the right rudder control cable by maintenance personnel, which resulted in the pilot's inability to maintain directional control during takeoff.NTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.NTSB WPR11CA301Accident · No injuriesData collectionFinal reportCessna A185F · Page, AZThe pilot's decision to take off with a gusty quartering tailwind.NTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…NTSB CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.NTSB CEN11CA423Accident · No injuriesData collectionFinal reportHendricks George David JR RV8 · Angel Fire, NMThe pilot's loss of directional control during landing.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.NTSB ERA11CA372Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carbondale, PAThe pilot's inadequate recovery from a bounced landing, which resulted in a runway overrun. Contributing to the accident was that the pilot did not attain the proper landing point.NTSB ERA11LA345Accident · No injuriesLimited investigationFinal reportCessna 525A · Nashville, TNThe pilot-in-command's failure to execute a go-around when the airplane was high and fast on the final approach.NTSB WPR11LA260Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Buttonwillow, CAThe pilot's misjudgment of the landing approach and subsequent long landing and overrun of the runway resulting in a collision with ground obstacles. Contributing to the accident was the pilot's likely fatigue and dehydration.NTSB CEN11CA395Accident · No injuriesData collectionFinal reportNelson Dan H LONG-EZ · Moriarity, NMThe pilot's failure to maintain directional control during the landing.NTSB WPR11CA259Accident · No injuriesData collectionFinal reportCessna 172P · Palo Alto, CAThe pilot's failure to maintain directional control during the landing roll.NTSB ERA11CA329Accident · No injuriesData collectionFinal reportRemos Remos G-3/600 · Apoka, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a hangar.NTSB CEN11LA372Accident · Minor injuriesLimited investigationFinal reportMooney M20J · North Canton, OHThe pilot’s improper landing flare and recovery from a bounced landing, which resulted in a loss of control.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB CEN11LA371Accident · No injuriesLimited investigationFinal reportRedding David RV9A · Edgewood, NMThe pilot's failure to abort the takeoff roll.NTSB ERA11CA346Accident · No injuriesData collectionFinal reportCessna 177 · Boone, NCThe pilot's delay in executing a go-around.NTSB ERA11CA324Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Honea Path, SCThe student pilot's loss of control during the takeoff.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB ANC11LA048Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Bettles Field, AKThe pilot's selection of unsuitable terrain for the landing, which resulted in a loss of directional control.NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…NTSB WPR11CA237Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Sedona, AZThe pilot's failure to maintain directional control on the landing roll out. Contributing to the accident was the pilot's decision to attempt a landing in crosswind conditions that exceeded the maximum demonstrated capability of the airplane.NTSB WPR11FA236Accident · Serious injuriesField investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Sedona, AZThe pilots’ unstabilized approach and excessive airspeed during approach, which resulted in an insufficient landing distance to stop the airplane before overrunning the runway.NTSB ERA11CA315Accident · No injuriesData collectionFinal reportMorrisey 2150A · Cambridge, MDThe pilot's loss of directional control during landing on a soft, turf runway.NTSB DCA11PA075Accident · Minor injuriesFinal reportBoeing 707-321B · Point Mugu, CAthe failure of a midspar fitting, which was susceptible to fatigue cracking and should have been replaced with a newer, more fatigue-resistant version of the fitting as required by an airworthiness directive. Also causal was an erroneous maintenance entry…NTSB WPR11CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Kahlotus, WAThe pilot's failure to maintain directional control during takeoff.NTSB ANC11CA032Accident · No injuriesData collectionFinal reportCessna A185F · Talkeetna, AKThe pilot's failure to maintain directional control during landing.NTSB CEN11CA336Accident · Serious injuriesData collectionFinal reportReed Roderick KB3 Gyroplane · Scott, LAThe pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.NTSB DCA11WA061Incident · No injuriesForeign investigationBoeing MD-90 · Tao-Yuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an incident involving an MD-90 that occurred on May 12, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex 13 as…NTSB CEN11CA353Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Guymon, OKThe pilot's loss of directional control while landing in gusty, crosswind conditions.