NTSB investigations

3,846 cases where the defining event was 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
  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 WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.Dec 6, 2009 · N20186 · Substantial damageNTSB CEN10CA062Accident · No injuriesData collectionFinal reportCessna 172S · Mt. Comfort, INThe pilot's failure to maintain directional control of the airplane while touching down during the landing.Dec 2, 2009 · N6036Y · Substantial damageNTSB ERA10CA083Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 · Indian Key, FLThe pilot's failure to secure the collective control prior to departing the helicopter, which resulted in an unmanned departure and subsequent crash of the helicopter.Nov 28, 2009 · N324GS · Substantial damageNTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.Nov 22, 2009 · N35638 · Substantial damageNTSB CEN10CA061Accident · No injuriesData collectionFinal reportCessna 305A · Rochester, INThe pilot's failure to maintain directional control during landing.Nov 22, 2009 · N1172D · Substantial damageNTSB WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.Nov 21, 2009 · N8504B · Substantial damageNTSB WPR10CA061Accident · Minor injuriesData collectionFinal reportBoeing A75N1 · Deer Valley, AZThe pilot's failure to maintain directional control.Nov 21, 2009 · N56099 · Substantial damageNTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.Nov 19, 2009 · N95JR · Substantial damageNTSB ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.Nov 16, 2009 · N89B · Substantial damageNTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.Nov 16, 2009 · N335BW · Substantial damageNTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.Nov 14, 2009 · N3823 · Substantial damageNTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.Nov 14, 2009 · N74632 · Substantial damageNTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.Nov 14, 2009 · N3797Z · Substantial damageNTSB ERA10CA061Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Clarksville, TNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident was his decision to take off with a left quartering tailwind.Nov 12, 2009 · N315AC · Substantial damageNTSB WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.Nov 8, 2009 · N48N · Substantial damageNTSB CEN10CA048Accident · No injuriesData collectionFinal reportCessna 150L · Galion, OHThe student pilot's failure to maintain directional control.Nov 8, 2009 · N66006 · Substantial damageNTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.Nov 7, 2009 · N134B · Substantial damageNTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.Nov 7, 2009 · N100LW · Substantial damageNTSB WPR10LA040Accident · Serious injuriesLimited investigationFinal reportHallbauer Dragonfly Mark II · Las Vegas, NVThe CFI's failure to maintain directional control of the airplane during takeoff.Oct 30, 2009 · N555RX · Substantial damageNTSB WPR10CA038Accident · No injuriesData collectionFinal reportMooney M20F · Palm Springs, CAThe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.Oct 29, 2009 · N400EB · Substantial damageNTSB CEN10CA033Accident · No injuriesData collectionFinal reportCessna 172N · Marysville, OHThe student pilot's failure to maintain directional control during landing.Oct 26, 2009 · N4753D · Substantial damageNTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.Oct 24, 2009 · N24536 · Substantial damageNTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damageNTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.Oct 24, 2009 · N822U · Substantial damageNTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.Oct 19, 2009 · N2719D · Substantial damageNTSB WPR10CA024Accident · No injuriesData collectionFinal reportCessna A185F · Sand Coulee, MTThe pilot's failure to maintain directional control during landing with a crosswind.Oct 18, 2009 · N1677R · Substantial damageNTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damageNTSB CEN10CA109Accident · No injuriesData collectionFinal reportSkistmas George Pietnpol Aircamper · Toledo, OHThe pilot's failure to maintain directional control during landing.Oct 18, 2009 · N6186L · Substantial damageNTSB WPR10CA017Accident · No injuriesData collectionFinal reportCessna 182F · Elko, NVThe pilot's failure to maintain directional control while taking off in known gusty wind conditions.Oct 12, 2009 · N3567Y · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB CEN10CA020Accident · No injuriesData collectionFinal reportFranklin Pitts Special S-1 · Alamosa, COThe pilot’s failure to maintain directional control on takeoff.Oct 9, 2009 · N59JT · Substantial damageNTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.Oct 7, 2009 · N54088 · Substantial damageNTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Oct 7, 2009 · N2219E · Substantial damageNTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.Sep 29, 2009 · N3260N · Substantial damageNTSB WPR09LA472Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · Fresno, CAThe pilot's failure to maintain directional control during the landing roll.Sep 28, 2009 · N18MK · Substantial damageNTSB ANC09CA107Accident · No injuriesData collectionFinal reportPiper PA-20 · Fairbanks, AKThe student pilot's decision to attempt an off-airport landing and his failure to maintain directional control during the landing roll.Sep 27, 2009 · N5540A · Substantial damageNTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.Sep 26, 2009 · N9204E · Substantial damageNTSB ANC09CA109Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series · Skwentna, AKThe pilot's failure to maintain directional control while landing on a rough, soft, and narrow airstrip.Sep 26, 2009 · N754BD · Substantial damageNTSB WPR09CA465Accident · No injuriesData collectionFinal reportCessna 195A · Upland, CAThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Sep 25, 2009 · N195MD · Substantial damageNTSB ANC09CA108Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll at an off-airport site.Sep 25, 2009 · N5037C · Substantial damageNTSB ERA09CA535Accident · No injuriesData collectionFinal reportC A Tecnam P2002 Sier · Enterprise, ALThe student pilot's failure to maintain control during the landing roll.Sep 23, 2009 · N246TS · Substantial damageNTSB ANC09CA105Accident · No injuriesData collectionFinal reportPiper PA-22 · Seward, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control and a nose over during the takeoff roll.Sep 21, 2009 · N2601P · Substantial damageNTSB ERA09CA534Accident · No injuriesData collectionFinal reportAeromot AMT200 · Wheeling, WVThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the pilot's failure to properly secure the canopy latch which resulted in an in-flight canopy opening.Sep 20, 2009 · N46068 · Substantial damageNTSB CEN09CA596Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Princeton, MNThe pilot's failure to maintain directional control during landing.Sep 19, 2009 · N52PH · Substantial damageNTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.Sep 18, 2009 · N999DJ · Substantial damageNTSB ANC09LA104Accident · No injuriesLimited investigationFinal reportCASA 212-200 · Savoonga, AKThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind.Sep 18, 2009 · N349TA · Substantial damageNTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.Sep 16, 2009 · N2594M · Substantial damageNTSB ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.Sep 15, 2009 · N93772 · Substantial damageNTSB WPR09LA475Accident · No injuriesLimited investigationFinal reportWaco QCF-2 · Bend, ORThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Sep 14, 2009 · N11241 · Substantial damageNTSB WPR09CA444Accident · No injuriesData collectionFinal reportBeech V35 · Hailey, IDThe pilot’s failure to maintain directional control of the airplane during landing in crosswind conditions.Sep 13, 2009 · N81895 · Substantial damage