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 CEN09CA027Accident · Minor injuriesData collectionFinal reportCessna 180 · Denton, TXThe pilot's loss of directional control and subsequent "ground-loop."Oct 19, 2008 · N1729F · Substantial damageNTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.Oct 15, 2008 · N20745 · Substantial damageNTSB WPR09CA007Accident · No injuriesData collectionFinal reportCessna T206H · Henderson, NVThe pilot's inadequate compensation for the crosswind conditions.Oct 9, 2008 · N206TT · Substantial damageNTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.Oct 7, 2008 · N808SP · No damageNTSB CEN09CA005Accident · No injuriesData collectionFinal reportCessna 180A · St. Louis, MOThe flight instructor's failure to maintain directional control during the landing.Oct 6, 2008 · N6180 · Substantial damageNTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.Oct 3, 2008 · N2146M · Substantial damageNTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.Oct 3, 2008 · N5172J · Substantial damageNTSB CEN09CA001Accident · No injuriesData collectionFinal reportLuscombe 8A · Greeley, COThe pilot's failure to maintain directional control during the landing roll resulting in a ground loop. Contributing to the accident was the lack of remedial action from the flight instructor.Oct 3, 2008 · N25342 · Substantial damageNTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.Oct 1, 2008 · N39313 · Substantial damageNTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…Oct 1, 2008 · N251ND · Substantial damageNTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.Sep 30, 2008 · N10402 · Substantial damageNTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.Sep 28, 2008 · N9272C · Substantial damageNTSB CHI08LA286Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Delaware, OHThe student pilot's failure to maintain directional control during landing.Sep 24, 2008 · N63DH · Substantial damageNTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.Sep 19, 2008 · N18ND · Substantial damageNTSB SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.Sep 18, 2008 · N554BG · Substantial damageNTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.Sep 18, 2008 · N8276G · Substantial damageNTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.Sep 16, 2008 · N8963K · Substantial damageNTSB ANC08CA124Accident · No injuriesData collectionFinal reportPiper PA-12 · Slana, AKThe pilot's excessive application of the brakes during the landing roll, resulting in a nose over and substantial damage.Sep 14, 2008 · N3348M · Substantial damageNTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.Sep 13, 2008 · N24342 · Substantial damageNTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.Sep 12, 2008 · N4757V · Substantial damageNTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.Sep 12, 2008 · N901LA · Substantial damageNTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.Sep 11, 2008 · N644DC · Substantial damageNTSB DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.Sep 5, 2008 · N9813C · Substantial damageNTSB ANC08CA118Accident · No injuriesData collectionFinal reportDiehl William A S-4 · Galena, AKThe pilot's failure to maintain pitch control of the airplane during takeoff, and the pilot's inadequate preflight inspection of the airplane.Sep 5, 2008 · N4BZ · Substantial damageNTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.Sep 4, 2008 · N185ZZ · Substantial damageNTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.Sep 1, 2008 · N7253D · Substantial damageNTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.Aug 31, 2008 · N4143D · Substantial damageNTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.Aug 31, 2008 · N1005W · Substantial damageNTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.Aug 29, 2008 · N8137K · Substantial damageNTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.Aug 28, 2008 · N190RV · Substantial damageNTSB LAX08CA280Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Wasco, ORThe pilot's failure to maintain directional control while landing.Aug 23, 2008 · N2870D · Substantial damageNTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.Aug 23, 2008 · N773D · Substantial damageNTSB NYC08LA291Accident · No injuriesLimited investigationFinal reportCessna 441 · Baltimore, MDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the pilot's attempted takeoff with a propeller start lock inadvertently engaged.Aug 20, 2008 · N441VB · Substantial damageNTSB LAX08CA270Accident · No injuriesData collectionFinal reportCessna 182Q · Mesa, AZThe pilot's failure to maintain directional control during landing.Aug 20, 2008 · N95841 · Substantial damageNTSB ANC08TA107Accident · No injuriesFinal reportPiper PA-18-150 · Slana, AKThe pilot's failure to maintain directional control during an aborted takeoff.Aug 19, 2008 · N4151T · Substantial damageNTSB SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.Aug 17, 2008 · N39124 · Substantial damageNTSB SEA08CA186Accident · No injuriesData collectionFinal reportCessna 140A · Lowman, IDThe pilot's failure to maintain directional control during the landing roll.Aug 16, 2008 · N1161D · Substantial damageNTSB CHI08CA256Accident · Minor injuriesData collectionFinal reportCessna 172N · Huntington, INThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the pilot's inadvertent use of the toe brake.Aug 16, 2008 · N733KC · Substantial damageNTSB NYC08CA283Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Cleveland, GAThe pilot's improper decision to land with a tailwind, and his failure to maintain aircraft control during the landing. Contributing to the accident was the tailwind.Aug 15, 2008 · N8906D · Substantial damageNTSB ANC08CA105Accident · Minor injuriesData collectionFinal reportWalker AK Bush Flyer · Deadhorse, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor contributing to the accident was a tailwind.Aug 14, 2008 · N799CC · Substantial damageNTSB DEN08CA142Accident · No injuriesData collectionFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control during takeoff. Contributing to the accident were wind gusts and rough terrain.Aug 13, 2008 · N362JW · Substantial damageNTSB DEN08CA136Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dexter, NMThe pilot's failure to maintain directional control of the airplane.Aug 9, 2008 · N4555Y · Substantial damageNTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…Aug 9, 2008 · N69X · Substantial damageNTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.Aug 9, 2008 · N1289R · Substantial damageNTSB ANC08CA102Accident · No injuriesData collectionFinal reportCessna 182 · Cantwell, AKThe pilot's misjudged distance while step-taxiing after landing. Factors in the accident were rain showers, wind, and spray from the airplane's propeller.Aug 9, 2008 · N82Y · Substantial damageNTSB ANC08LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's excessive speed and excessive application of brakes during the landing roll on soft, sandy terrain.Aug 7, 2008 · N82057 · Substantial damageNTSB ANC08TA099Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Aug 6, 2008 · N7055 · Substantial damageNTSB SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.Aug 4, 2008 · N53BV · Substantial damageNTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.Aug 3, 2008 · N73594 · Substantial damageNTSB LAX08CA255Accident · No injuriesData collectionFinal reportPiper PA-20 · Grass Valley, CAThe pilot's failure to maintain directional control due to his foot slipping off one rudder pedal while braking.Aug 3, 2008 · N7635K · Substantial damage