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 DCA11RA100Accident · Serious injuriesForeign investigationEmbraer E190 · Quito, EcuadorOn September 16, 2011, an Ecuadoran Embraer EMB-190, registration HC-CEZ, overran runway 35 while landing at Quito, Ecuador. The airplane was substantially damaged and there were 5 serious injuries among the 97 passengers and 5 crew. The investigation is…NTSB CEN11CA655Accident · No injuriesData collectionFinal reportBeech B90 · Hillsboro, TXThe pilot's failure to obtain a proper touchdown point, which resulted in a runway undershoot.NTSB ERA11CA494Accident · No injuriesData collectionFinal reportMooney M20K · Anderson, SCThe pilot's failure to maintain directional control during an attempted go-around.NTSB ERA11CA492Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5A · Cleveland, GAThe pilot's poor decision to land with a tailwind, which resulted in a runway excursion.NTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.NTSB CEN11CA647Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Pinckneyville, ILThe pilot's failure to conduct a go-around due to his excessive airspeed while on approach to land, which resulted in a runway excursion.NTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.NTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB ANC11CA095Accident · No injuriesData collectionFinal reportCessna 170A · Anchorage, AKThe fracture of a hydraulic brake line fitting due to incorrect installation of the brake line by the pilot/owner, which resulted in a loss of brake pressure and subsequent loss of directional control during the landing roll.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB ERA11CA482Accident · No injuriesData collectionFinal reportQuestair Venture · Memphis, TNThe pilot's inability to maintain directional control during landing with a flat tire. Contributing to the accident was the failure of the left main landing gear tire for undetermined reasons.NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB WPR11CA433Accident · No injuriesData collectionFinal reportSherman Craig W Glasair III · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll, as a result of a flat left main landing gear tire.NTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB ENG11IA047Incident · No injuriesIncident investigationFinal reportEmbraer EMB145 · Moline, ILThe uncommanded left deflection of the airplane's nose wheel likely due to seal deterioration and subsequent contamination within the Electrohydraulic Servo Valve (EHSV). Contributing to the incident was the undersized condition of the filter plugs within the…NTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.NTSB ERA11CA471Accident · No injuriesData collectionFinal reportPayne/Foster Glasair · Ocala, FLThe failure of the tailwheel locking mechanism to remain engaged while landing in a crosswind, which resulted in a loss of directional control and runway excursion.NTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.NTSB CEN11LA558Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Alpine, TXThe pilot’s improper flare which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to fly the airplane with a known mechanical deficiency.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR11CA406Accident · No injuriesData collectionFinal reportCessna A185F · Polson, MTThe pilot's failure to maintain directional control during landing.NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB ANC11LA084Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKA loss of directional control during landing due to a rock lodged in the main landing gear wheel brake, resulting in a runway excursion and collision with terrain.NTSB ERA11CA478Accident · No injuriesData collectionFinal reportCano Dave Avid Flyer Mkiv · Smithville, TNThe pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.NTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.NTSB ERA11LA466Accident · No injuriesLimited investigationFinal reportPiper PA46 · Manasses, VAAn undetermined nose landing gear steering anomaly or anomalies, which resulted in the pilot's inability to maintain directional control of the airplane during the landing rollout. The damage to the nose landing gear precluded a determination of the cause of…NTSB ERA11CA452Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Front Royal, VAThe pilot’s failure to attain the proper touchdown point.NTSB ERA11CA455Accident · No injuriesData collectionFinal reportG-Dawg Just Acft Highlander · Abingdon, VAThe pilot's inadequate compensation for wind conditions during the aborted takeoff.NTSB ERA11CA453Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · West Liberty, KYThe pilot's failure to obtain the proper touchdown point during landing, which resulted in a runway excursion.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.NTSB ERA11CA446Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot's loss of directional control while attempting to close the airplane's door during takeoff roll.NTSB ERA11CA442Accident · No injuriesData collectionFinal reportDidier Siffer Arion Lightning · Farmingdale, NYThe pilot's failure to maintain directional control while landing in a strong quartering crosswind.NTSB ERA11CA440Accident · Minor injuriesData collectionFinal reportNelsen Lynn H Lightning · Frostproof, FLThe pilot's premature rotation during takeoff.NTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.NTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.NTSB WPR11CA358Accident · No injuriesData collectionFinal reportMcdonald Lynn B Avid Flyer Mark IV · Yamhill, ORThe pilot’s loss of directional control during landing rollout due to an unlocked tail wheel that was caused by a degradation of the tailwheel assembly mounting angle.NTSB DCA11RA092Accident · Serious injuriesForeign investigationBoeing 737 · Georgetown, GuyanaOn July 30, 2011, at 1:25 am local time (0525 UTC), a Boeing 737-800, Trinidad & Tobago registration 9Y-PBM, operated by Caribbean Airlines as flight 523, overran the runway upon landing at Cheddi Jagan International Airport, Georgetown, Guyana. Of the 156…NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.NTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.NTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.NTSB ERA11CA410Accident · Minor injuriesData collectionFinal reportSky International A-1C-180 · Fryeburg, METhe pilot's failure to maintain directional control while landing in gusty wind conditions.NTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.NTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.