NTSB investigations, CO

135 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.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
    AND 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.

NTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.Oct 5, 2020 · N3370E · Substantial damageNTSB CEN20CA340Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Englewood, COThe student pilot misjudged the landing flare which resulted in a loss of control and a hard bounced landing.Aug 8, 2020 · N79110 · Substantial damageNTSB CEN20CA332Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Englewood, COThe flight instructor did not maintain a proper approach path and landing flare during a landing with a tailwind, which resulted in a hard landing and damaged landing gear. During the subsequent landing with damaged landing gear, the flight instructor lost…Aug 8, 2020 · N4964S · Substantial damageNTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.Jun 1, 2020 · N6518M · Substantial damageNTSB CEN20CA163Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Longmont, COThe pilot's loss of control during a go around.Apr 28, 2020 · N41498 · Substantial damageNTSB CEN20CA161Accident · No injuriesData collectionFinal reportPiper PA 20 · Colorado Springs, COThe flight instructor's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control.Apr 26, 2020 · N1598A · Substantial damageNTSB CEN20CA151Accident · No injuriesData collectionFinal reportEagle Eagle DW 1 · Hudson, COThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and nose-over.Apr 18, 2020 · N8810T · Substantial damageNTSB CEN20CA128Accident · No injuriesData collectionFinal reportCessna 172 · Denver, COThe pilot's incorrect right rudder application during a touch-and go-landing, which resulted in a loss of directional control, runway excursion, and a collision with a runway sign.Mar 18, 2020 · N1132W · Substantial damageNTSB CEN20LA083Accident · No injuriesClass 3 · LimitedFinal reportPiaggio P180 · Broomfield, COThe pilot’s loss of directional control on the snow-covered runway, which resulted in a runway excursion.Feb 13, 2020 · N677P · Substantial damageNTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.Sep 3, 2019 · N2XF · Substantial damageNTSB CEN19LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Denver, COA total loss of electrical power for reasons that could not be determined, and the student pilot’s subsequent runway overrun during a no-flap landing.Aug 29, 2019 · N53432 · Substantial damageNTSB GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.Aug 7, 2019 · N979DA · Substantial damageNTSB GAA19CA165Accident · No injuriesData collectionFinal reportCirrus SR20 · Akron, COThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a drainage culvert.Mar 12, 2019 · N418DE · Substantial damageNTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…Nov 20, 2018 · N27LA · Substantial damageNTSB GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.Oct 27, 2018 · N4500W · Substantial damageNTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.Jul 22, 2018 · N99243 · Substantial damageNTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.May 16, 2018 · N4EJ · Substantial damageNTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.May 7, 2018 · N3292Y · Substantial damageNTSB GAA18CA135Accident · No injuriesData collectionFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.Feb 17, 2018 · N13453 · Substantial damageNTSB CEN17LA367Accident · Serious injuriesLimited investigationFinal reportMiller Steven M RV6 A · Elbert, COThe pilot’s improper landing flare in strong gusting wind conditions, which resulted in a bounced landing, and his loss of directional control during an attempted go-around, which resulted in a runway excursion and impact with objects.Sep 13, 2017 · N812SM · Substantial damageNTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.Sep 9, 2017 · N89732 · Substantial damageNTSB CEN17LA306Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Denver, COThe pilot’s failure to maintain directional control while landing.Jul 31, 2017 · N2146R · Substantial damageNTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…Jul 15, 2017 · N181AL · DestroyedNTSB CEN17LA185Accident · No injuriesLimited investigationFinal reportMooney M20TN · Grandby, COThe total loss of engine power for reasons that could not be determined based on the available information.May 13, 2017 · N9306 · Substantial damageNTSB GAA17CA257Accident · Minor injuriesData collectionFinal reportNelson Sydney Vans Acft RV8A · Englewood, COThe pilot's improper landing flare and inadvertent selection of the mixture control, which resulted in a hard, bounced landing during gusting crosswind wind conditions.May 4, 2017 · N832SD · Substantial damageNTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damageNTSB GAA17CA125Accident · No injuriesData collectionFinal reportGreat Lakes 2T1A · Canon City, COThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s unstabilized approach.Jan 28, 2017 · N16GL · Substantial damageNTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.Jan 24, 2017 · N216CS · Substantial damageNTSB CEN17LA047Accident · No injuriesLimited investigationFinal reportCessna Citation 500 · Gunnison, COThe pilot’s failure to fly a stabilized approach and his inadequate landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to ensure that the airplane was properly serviced with fuel before departing on the…Dec 5, 2016 · N332SE · Substantial damageNTSB GAA17CA016Accident · No injuriesData collectionFinal reportRobinson Stewart J Bearhawk · Calhan, COThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.Oct 7, 2016 · N507SR · Substantial damageNTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Oct 6, 2016 · N4210C · Substantial damageNTSB GAA16CA378Accident · No injuriesData collectionFinal reportPiper PA46R · Denver, COThe pilot's improper nose down pitch attitude during touchdown resulting in a propeller strike, hard bounced landing, and nose landing gear collapse.Jul 14, 2016 · N465BP · Substantial damageNTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.Jun 9, 2016 · N9915Y · Substantial damageNTSB GAA16CA270Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Mack, COThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, impact with a ditch, and nose over.May 29, 2016 · N273BC · Substantial damageNTSB GAA16CA214Accident · No injuriesData collectionFinal reportRockwell International 112TC · Durango, COThe instructed pilot's interference with the flight controls during landing, which resulted in the flight instructor's inability to maintain directional control, resulting in a runway excursion and substantial damage to the firewall and left wing spar.May 4, 2016 · N513CA · Substantial damageNTSB GAA15CA293Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's loss of directional control during the takeoff, which resulted in a collision with a parked airplane and impact with terrain.Sep 29, 2015 · N319PT · Substantial damageNTSB GAA15CA194Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Monte Vista, COThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with objects.Jul 22, 2015 · N402KN · Substantial damageNTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.Jun 5, 2015 · N914FM · Substantial damageNTSB GAA15CA011Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Boulder, COThe pilot's loss of directional control during a bounced landing, which resulted in a runway excursion.Mar 16, 2015 · N4785F · Substantial damageNTSB CEN14CA483Accident · No injuriesData collectionFinal reportRoss Alfred K/Oneill Terrence Lancair 235 · Longmont, COThe pilot's inadvertent application of the brake which resulted in the loss of directional control during the landing roll.Sep 3, 2014 · N211AL · Substantial damageNTSB CEN14CA364Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's failure to maintain control during landing.Jul 14, 2014 · N562BG · Substantial damageNTSB CEN14LA245Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Yuma, COThe pilot's failure to maintain directional control after the airplane encountered a wind gust during takeoff roll. Contributing to the accident was the pilot inadvertently using a runway that resulted in a gusty tailwind condition.May 19, 2014 · N9631C · Substantial damageNTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.Nov 3, 2013 · N981PA · Substantial damageNTSB CEN14CA055Accident · Minor injuriesData collectionFinal reportCessna 172N · Loveland, COA dragging right brake, which resulted in an un-commanded right turn, and subsequent ground loop.Nov 2, 2013 · N6303E · Substantial damageNTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.Aug 12, 2013 · N15EG · Substantial damageNTSB CEN13LA358Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Durango, COThe pilot's improper decision to take off with a tailwind at a high-density altitude, which resulted in the airplane’s failure to maintain the initial climb rate.Jun 18, 2013 · N7444J · Substantial damageNTSB CEN13CA200Accident · No injuriesData collectionFinal reportCessna 172 · Kremmling, COThe student pilot’s failure to maintain directional control while landing.Mar 16, 2013 · N7407A · Substantial damageNTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damageNTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.Dec 2, 2012 · N562BG · Substantial damageNTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.Sep 4, 2012 · N6744J · Substantial damage