NTSB investigations, 2020

232 cases where the sequence of events included Loss of control on ground.

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 year(c.\"eventDate\") = 2020
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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 CEN20LA413Accident · FatalClass 3 · LimitedFinal reportCosmos Phase 3 · Wayne, OKA loss of control while taxiing for reasons that could not be determined based on available evidence.Sep 19, 2020 · N7024L · Substantial damageNTSB CEN20CA394Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA46 · Englewood, COThe pilot's failure to maintain directional control during landing in gusting winds.Sep 15, 2020 · N596ST · Substantial damageNTSB CEN20CA393Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain directional control upon landing.Sep 13, 2020 · N7562F · Substantial damageNTSB ANC20CA094Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Kiana, AKThe pilot’s improper decision to perform a takeoff from an unsuitable surface, which resulted in a loss of control and nose over.Sep 13, 2020 · N3068A · Substantial damageNTSB ANC20CA096Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chitina, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Sep 12, 2020 · N416RK · Substantial damageNTSB WPR20CA307Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC11-160 · Big Creek, IDThe pilot’s failure to maintain directional control during the landing roll with a gusting wind, which resulted in a runway excursion and impact with a tree.Sep 11, 2020 · N682CC · Substantial damageNTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.Sep 7, 2020 · N186GC · Substantial damageNTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.Sep 5, 2020 · N232PA · Substantial damageNTSB CEN20CA382Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Bellaire, MIThe pilot's loss of directional control during the landing roll.Sep 4, 2020 · N185DK · Substantial damageNTSB WPR20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna Ector 305A · Amboy, CAThe pilot's failure to maintain directional control of the airplane during a precautionary landing which resulted in a ground loop.Sep 3, 2020 · N1832 · Substantial damageNTSB ERA20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 170 · Morrisville, VTThe pilot's failure to maintain directional control and subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall and collision with terrain.Sep 3, 2020 · N170JS · Substantial damageNTSB CEN20LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 414 · Ray, MIThe pilot’s loss of directional control on takeoff.Aug 30, 2020 · N698D · Substantial damageNTSB WPR20CA297Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Givens Hot Springs, IDPilot's failure to maintain directional control on takeoff.Aug 25, 2020 · N334SC · Substantial damageNTSB CEN20CA362Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Lebanon, MOThe pilot's failure to maintain directional control during landing.Aug 24, 2020 · N748P · Substantial damageNTSB WPR20CA287Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Tok, AKThe student pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with trees.Aug 22, 2020 · N7468D · Substantial damageNTSB CEN20CA359Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Corsicana, TXThe student pilot did not maintain control of the airplane during the takeoff roll.Aug 21, 2020 · N8267N · Substantial damageNTSB CEN20CA355Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Odessa, TXThe pilot's failure to maintain directional control of the airplane during landing.Aug 20, 2020 · N710NA · DestroyedNTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.Aug 19, 2020 · N386X · Substantial damageNTSB ANC20CA082Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 20 · Talkeetna, AKThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop.Aug 18, 2020 · N1526A · Substantial damageNTSB WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.Aug 16, 2020 · N62130 · Substantial damageNTSB CEN20CA344Accident · No injuriesClass 4 · Data collectionFinal reportBeech 35 · White Owl, SDThe pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and subsequent impact with an obstacle and terrain.Aug 16, 2020 · N6643Y · Substantial damageNTSB CEN20CA341Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G164 · Rice, MNThe pilot did not maintain control of the airplane during the landing.Aug 16, 2020 · N997QC · Substantial damageNTSB CEN20LA345Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Glenwood Springs, COThe pilot’s loss of directional control upon landing due to a sheared tailwheel locking pin.Aug 12, 2020 · N9726K · Substantial damageNTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.Aug 11, 2020 · N9917N · 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 CEN20CA333Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters Carbon CUB EX · Marion, ILThe pilot's failure to attain/maintain directional control during landing that resulted in a ground-loop and collision with terrain.Aug 7, 2020 · N3737R · Substantial damageNTSB ERA20CA293Accident · Minor injuriesClass 4 · Data collectionFinal reportWag Aero Cubby · Pell City, ALThe flight instructor’s inadequate remedial action following the student pilot’s loss of directional control during landing, which resulted in a runway excursion and subsequent nose over.Aug 6, 2020 · N30492 · Substantial damageNTSB ANC20LA077Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Kenai, AKThe pilot’s improper decision to place a passenger and baggage in the rear baggage compartment, which resulted in an aft center of gravity, an increase in directional instability, and affected the pilot’s ability to maintain directional control, resulting in…Aug 5, 2020 · N9712G · Substantial damageNTSB ANC20CA078Accident · No injuriesClass 4 · Data collectionFinal reportGreg Miller GOT Rocks · Minchumina, AKThe pilot's failure to maintain directional control during landing in gusting wind conditions, which resulted in an impact with a large hole and a nose-over.Aug 5, 2020 · N9015U · Substantial damageNTSB ANC20CA076Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a runway excursion and collision with trees.Aug 4, 2020 · N82566 · Substantial damageNTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.Aug 1, 2020 · N60934 · Substantial damageNTSB CEN20CA349Accident · No injuriesClass 4 · Data collectionFinal reportCessna T206 · Bentonville, ARThe pilot's misjudgment of the landing flare which resulted in a bounced landing.Aug 1, 2020 · N829PA · Substantial damageNTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.Jul 29, 2020 · N1049P · Substantial damageNTSB ANC20CA080Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18 · Fairbanks, AKThe pilot's improper decision to depart from an off-airport surface that had standing water, which resulted in a loss of control and impact with terrain.Jul 27, 2020 · N1277A · Substantial damageNTSB ERA20CA276Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lakeland, FLThe pilot’s failure to maintain control of the airplane during the attempted engine start.Jul 26, 2020 · N2629V · Substantial damageNTSB WPR20LA237Accident · 1 fatalClass 3 · LimitedFinal reportVans Vans RV-8 · Tehachapi, CAThe pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at too low of an altitude to recover.Jul 24, 2020 · N138PM · Substantial damageNTSB CEN20CA299Accident · No injuriesClass 4 · Data collectionFinal reportRockwell 112 · Tomball, TXThe pilot did not maintain control of the airplane during the landing and subsequent go around.Jul 22, 2020 · N1013J · Substantial damageNTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.Jul 21, 2020 · N284M · Substantial damageNTSB CEN20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Cambridge, MNThe pilot's loss of directional control while landing a tailwheel airplane with a slight left quartering a tailwind. Contributing to the accident was the flight instructor's delayed remedial action.Jul 21, 2020 · N2943C · Substantial damageNTSB CEN20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170B · Bloomington, INThe pilot's failure to attain/maintain directional control during landing that resulted in a ground loop and impact with terrain.Jul 20, 2020 · N8193A · Substantial damageNTSB WPR20CA230Accident · No injuriesClass 4 · Data collectionFinal reportSeele XPA-18 · Reno, NVAn inadequate flare which resulted in a bounced landing and the pilot's failure to maintain directional control.Jul 18, 2020 · N113MX · Substantial damageNTSB ERA20CA264Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Block Island, RIA hard landing and subsequent loss of control.Jul 18, 2020 · N58066 · Substantial damageNTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.Jul 18, 2020 · N140AB · Substantial damageNTSB CEN20CA317Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Osceola, WIThe pilots did not maintain directional control of the airplane during landing.Jul 17, 2020 · N1926N · Substantial damageNTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.Jul 17, 2020 · N86WM · Substantial damageNTSB ERA20CA253Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Washington, NCThe pilot's failure to maintain directional during landing on a wet grass runway.Jul 15, 2020 · N2038Q · Substantial damageNTSB CEN20CA285Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Rochester, INThe pilot's failure to maintain directional control during landing resulting in a ground loop.Jul 15, 2020 · N2231T · Substantial damageNTSB WPR20CA222Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hayward, CAThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the flight instructor's delayed remedial action, which resulted in the left wing striking the runway.Jul 14, 2020 · N530CA · Substantial damageNTSB CEN20CA284Accident · No injuriesClass 4 · Data collectionFinal reportBeech 95 55 · Spring, TXExcessive wear of the left brake liners which reduced brake effectiveness resulting in a runway excursion.Jul 14, 2020 · N1332Z · Substantial damageNTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.Jul 14, 2020 · N72EB · Substantial damage