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 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.Sep 3, 2011 · N17S · Substantial damageNTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Sep 3, 2011 · N30950 · Substantial damageNTSB WPR11CA422Accident · No injuriesData collectionFinal reportAir Creation Clipper 582S · Enumclaw, WAThe pilot’s failure to maintain directional control during landing.Sep 2, 2011 · N5099A · Substantial damageNTSB 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.Sep 1, 2011 · N83533 · Substantial damageNTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.Sep 1, 2011 · N46112 · Substantial damageNTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.Aug 31, 2011 · N10365 · Substantial damageNTSB WPR11CA414Accident · No injuriesData collectionFinal reportMaule M-6-235 · Hailey, IDThe pilot’s failure to maintain directional control during the landing rollout in a gusty, crosswind condition.Aug 29, 2011 · N6140B · Substantial damageNTSB 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…Aug 29, 2011 · N27152 · Minor damageNTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.Aug 26, 2011 · N3020M · Substantial damageNTSB CEN11LA595Accident · No injuriesLimited investigationFinal reportCessna 140 · Monmouth, ILThe pilot's loss of airplane control during the landing roll.Aug 25, 2011 · N72688 · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.Aug 22, 2011 · N4376Z · Substantial damageNTSB WPR11CA406Accident · No injuriesData collectionFinal reportCessna A185F · Polson, MTThe pilot's failure to maintain directional control during landing.Aug 21, 2011 · N61609 · Substantial damageNTSB 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.Aug 21, 2011 · N139F · Substantial damageNTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.Aug 20, 2011 · N3723D · Substantial damageNTSB 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.Aug 20, 2011 · N52CH · Substantial damageNTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.Aug 20, 2011 · N2997G · Substantial damageNTSB WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.Aug 19, 2011 · N53WY · Substantial damageNTSB 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…Aug 19, 2011 · N133SR · Substantial damageNTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.Aug 16, 2011 · N9742V · Substantial damageNTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2011 · N42860 · Substantial damageNTSB ANC11CA076Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's inadvertent application of the right brake pedal during the landing roll, which resulted in a nose-over.Aug 13, 2011 · N1258C · Substantial damageNTSB CEN11CA564Accident · No injuriesData collectionFinal reportBeech 35-C33 · Rockwall, TXThe pilot's loss of control while landing with a tailwind due to his misinterpretation of the wind conditions.Aug 11, 2011 · N12CA · Substantial damageNTSB WPR11LA389Accident · No injuriesLimited investigationFinal reportGlasair Sportsman · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll.Aug 8, 2011 · N117CE · Substantial damageNTSB ERA11CA442Accident · No injuriesData collectionFinal reportDidier Siffer Arion Lightning · Farmingdale, NYThe pilot's failure to maintain directional control while landing in a strong quartering crosswind.Aug 6, 2011 · N723AD · Substantial damageNTSB 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.Aug 3, 2011 · N8764S · Substantial damageNTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.Aug 2, 2011 · N3135J · Substantial damageNTSB 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.Aug 1, 2011 · N785TT · Substantial damageNTSB WPR11CA355Accident · No injuriesData collectionFinal reportCessna 170A · Mulino, ORThe certified flight instructor's inadequate oversight of his student, and delayed recovery efforts following the student's loss of directional control during landing rollout.Jul 30, 2011 · N9741A · Substantial damageNTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.Jul 23, 2011 · N8318K · Substantial damageNTSB ERA11CA410Accident · Minor injuriesData collectionFinal reportSky International A-1C-180 · Fryeburg, METhe pilot's failure to maintain directional control while landing in gusty wind conditions.Jul 20, 2011 · N52LK · Substantial damageNTSB CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.Jul 20, 2011 · N343A · Substantial damageNTSB CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.Jul 16, 2011 · N731JD · Substantial damageNTSB ERA11CA407Accident · No injuriesData collectionFinal reportCessna 180J · Schlater, MSThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion.Jul 15, 2011 · N9996N · Substantial damageNTSB WPR11CA328Accident · No injuriesData collectionFinal reportTaylorcraft F-22 · Payson, AZThe pilot's selection of a wrong runway to practice touch-and-go takeoffs and landings.Jul 14, 2011 · N191TC · Substantial damageNTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.Jul 6, 2011 · N2878S · Substantial damageNTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.Jul 6, 2011 · N65659 · Substantial damageNTSB WPR11CA310Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Whitefish, MTThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of recent experience in a tailwheel equipped airplane.Jul 5, 2011 · N40WP · Substantial damageNTSB CEN11CA462Accident · No injuriesData collectionFinal reportMooney M20S · Washington Island, WIThe pilot's failure to maintain aircraft control during the landing and his delayed remedial action to abort the landing.Jul 3, 2011 · N2234X · Substantial damageNTSB CEN11CA447Accident · Minor injuriesData collectionFinal reportArion Lightning LS-1 · Garden City, KSThe pilot's failure to maintain aircraft control while landing.Jul 3, 2011 · N125GD · Substantial damageNTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.Jul 2, 2011 · N79RA · Substantial damageNTSB WPR11CA301Accident · No injuriesData collectionFinal reportCessna A185F · Page, AZThe pilot's decision to take off with a gusty quartering tailwind.Jun 30, 2011 · N80293 · Substantial damageNTSB ANC11CA056Accident · No injuriesData collectionFinal reportHughes 500D · Ambler, AKThe pilot's misalignment of the helicopter on the landing structure.Jun 27, 2011 · C-GLHQ · Substantial damageNTSB WPR11CA293Accident · No injuriesData collectionFinal reportAviat A-1B · Livermore, CAThe pilot's failure to maintain directional control during a go-around.Jun 25, 2011 · N101HY · Substantial damageNTSB CEN11LA419Accident · No injuriesLimited investigationFinal reportVanDenburg Pietenpol Air Camper · Gwinn, MIThe pilot’s loss of directional control during the landing roll, which resulted in a ground loop.Jun 25, 2011 · N16DV · Substantial damageNTSB CEN11CA423Accident · No injuriesData collectionFinal reportHendricks George David JR RV8 · Angel Fire, NMThe pilot's loss of directional control during landing.Jun 24, 2011 · N678VR · Substantial damageNTSB WPR11CA281Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Havre, MTThe pilot's failure to maintain directional control during takeoff.Jun 23, 2011 · N57736 · Substantial damageNTSB WPR11LA280Accident · No injuriesLimited investigationFinal reportInhofe/ Davis Vans RV-8 · Sheridan, WYThe pilot's inadequate directional control during the landing roll.Jun 22, 2011 · N4546Y · Substantial damageNTSB ERA11CA356Accident · No injuriesData collectionFinal reportCessna A185F · Trinca, NJThe pilot's failure to maintain directional control, and the flight instructor's inadequate remedial action, which resulted in a ground-loop.Jun 18, 2011 · N714TX · Substantial damageNTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.Jun 18, 2011 · N735JY · Substantial damage