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 WPR09CA136Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Ogden, UTThe loss of directional control during the landing roll due to the separation of the tailwheel spring retaining clip for unknown reasons.Feb 21, 2009 · N8637D · Substantial damageNTSB ERA09CA165Accident · No injuriesData collectionFinal reportHelio H-295 · Clemson, SCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.Feb 9, 2009 · N99PM · Substantial damageNTSB ERA09CA160Accident · No injuriesData collectionFinal reportCessna 172M · Le Roy, NYThe pilot's inadequate compensation for a crosswind during an aborted landing. Contributing to the accident was the pilot's decision to land in gusting crosswinds in excess of the manufacturer's recommended crosswind limit.Feb 7, 2009 · N3554Q · Substantial damageNTSB ERA09CA159Accident · No injuriesData collectionFinal reportCessna 170B · Lake Placid, FLThe pilot's failure to maintain directional control during the landing. Contributing was the flight instructor's delayed remedial action.Feb 7, 2009 · N1825C · Substantial damageNTSB WPR09CA109Accident · No injuriesData collectionFinal reportSeher Bearhawk · Reno, NVThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during takeoff. Contributing to the accident were a crosswind and the pilot's delayed decision to abort the takeoff.Feb 5, 2009 · N846BH · Substantial damageNTSB WPR09LA108Accident · No injuriesLimited investigationFinal reportDouglas DC-3/65AR · Mojave, CAThe student pilot failed to follow the checklist and set the takeoff trim properly prior to takeoff resulting in a loss of directional control. Contributing to the accident were the certified flight instructor's inadequate supervision and delayed remedial…Feb 4, 2009 · N834TP · Substantial damageNTSB CEN09IA153Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-500T · Aspen, COThe pilot's inability to maintain directional control of the airplane during landing for undetermined reasons.Feb 4, 2009 · N535JR · Minor damageNTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.Feb 2, 2009 · N95606 · Substantial damageNTSB ERA09CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lexington, KYThe pilot's failure to maintain control of the helicopter during takeoff. Contributing to this accident was the interference of the flight controls by the heavy coat and boots the pilot was wearing.Feb 1, 2009 · N2620C · Substantial damageNTSB WPR09CA099Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bisbee, AZThe student pilot's failure to maintain directional control during takeoff and the flight instructor's inadequate supervision of the flight and delay in remedial action.Jan 24, 2009 · N5117L · Substantial damageNTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.Jan 21, 2009 · N396JD · Substantial damageNTSB ERA09CA136Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Akron, ALThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.Jan 18, 2009 · N1052U · Substantial damageNTSB CEN09CA141Accident · No injuriesData collectionFinal reportCessna 172S · Emporia, KSThe pilot's inadequate compensation for the wind conditions during the touch-and-go. Contributing to the accident were the gusty crosswinds.Jan 18, 2009 · N2465H · Substantial damageNTSB WPR09CA094Accident · No injuriesData collectionFinal reportJones Rodney V Wittman TA · Yucca Valley, CAA loss of directional control due to a weld joint failure of the left rudder pedal.Jan 16, 2009 · N90086 · Substantial damageNTSB ERA09CA135Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Merritt Island, FLThe pilot's failure to maintain aircraft control during landing in windy conditions.Jan 16, 2009 · N7861B · Substantial damageNTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.Jan 14, 2009 · N9428G · Substantial damageNTSB CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.Jan 10, 2009 · N2553S · Substantial damageNTSB WPR09CA081Accident · No injuriesData collectionFinal reportParker 77 · Phoenix, AZThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.Jan 9, 2009 · N60DE · Substantial damageNTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.Jan 5, 2009 · N45969 · DestroyedNTSB ERA09CA119Accident · No injuriesData collectionFinal reportCessna 172SP · Lancaster, NYThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the student pilot's lack of solo flight experience and the snow bank located off the left side of the runway.Jan 1, 2009 · N2228L · Substantial damageNTSB ERA09CA118Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Brunswick, GAThe pilot's failure to maintain control of the airplane during the landing flare. Contributing to the accident were the gusting winds.Dec 31, 2008 · N7138L · Substantial damageNTSB WPR09CA067Accident · No injuriesData collectionFinal reportCessna 208B · Rock Springs, WYThe pilot's failure to maintain control of the airplane while taxiing. Contributing to the accident were the gusty winds.Dec 27, 2008 · N890FE · Substantial damageNTSB CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.Dec 24, 2008 · N89418 · Substantial damageNTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Dec 24, 2008 · N732DK · Substantial damageNTSB CEN09LA100Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Lewistown, MOThe pilot's loss of directional control during landing on an ice-contaminated runway.Dec 23, 2008 · N20NL · Substantial damageNTSB WPR09CA066Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Idaho Falls, IDThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the icy runway conditions and a snow bank.Dec 22, 2008 · N379P · Substantial damageNTSB WPR09CA063Accident · No injuriesData collectionFinal reportCessna 180C · Great Falls, MTThe pilot's failure to maintain directional control during the landing roll.Dec 21, 2008 · C-FIWA · Substantial damageNTSB WPR09LA057Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · Santa Clarita, CAThe helicopter's encounter with a gusty crosswind condition during engine start that exceeded the helicopter's demonstrated wind envelope.Dec 17, 2008 · N267KA · Substantial damageNTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.Dec 17, 2008 · N845D · Substantial damageNTSB ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.Dec 13, 2008 · N212DK · Substantial damageNTSB WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.Dec 5, 2008 · N268ML · Substantial damageNTSB ERA09LA079Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Punta Gorda, FLThe pilot's failure to maintain control of the airplane during a rejected takeoff. Contributing to the accident was a gust of wind.Dec 5, 2008 · N370CT · Substantial damageNTSB CEN09CA081Accident · No injuriesData collectionFinal reportCessna A185F · Alton, ILThe pilot's failure to compensate for the crosswind during landing, resulting in loss of control of the aircraft and the subsequent nose-over of the airplane. Contributing to the accident was the crosswind.Dec 5, 2008 · N185KS · Substantial damageNTSB ERA09CA065Accident · No injuriesData collectionFinal reportPiper PA46 · Oak Island, NCThe pilot's failure to maintain directional control during takeoff. Contributing to the accident were gusting crosswinds.Nov 18, 2008 · N6913Z · Substantial damageNTSB CEN09CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Colorado Springs, COFailure of the pilot to maintain directional control and his failure to compensate for wind conditions. Contributing to the accident were gusting winds with a wind shear warning in effect.Nov 18, 2008 · N905CC · Substantial damageNTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.Nov 16, 2008 · N4157 · Substantial damageNTSB CEN09CA085Accident · No injuriesData collectionFinal reportDavis Daniel T Cozy · Monte Vista, COThe flight instructor's failure to maintain control of the airplane during landing.Nov 15, 2008 · N149CZ · Substantial damageNTSB CEN09CA072Accident · No injuriesData collectionFinal reportCessna 172I · Osh Kosh, NEThe pilot's failure to maintain control of the airplane while taxing in strong winds.Nov 14, 2008 · N35667 · Substantial damageNTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.Nov 14, 2008 · N5432Z · Substantial damageNTSB ERA09CA048Accident · No injuriesData collectionFinal reportCessna 172 · Groton, CTThe student pilot's failure to maintain directional control during landing.Nov 11, 2008 · N91HF · Substantial damageNTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 10, 2008 · N5263G · Substantial damageNTSB CEN09CA042Accident · No injuriesData collectionFinal reportCessna 172H · Ingleside, TXThe pilot's decision to land in crosswind conditions, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Oct 27, 2008 · N1714F · Substantial damageNTSB CEN09LA036Accident · No injuriesLimited investigationFinal reportCessna 180 · Justin, TXThe pilot's failure to maintain control of the airplane during landing.Oct 26, 2008 · N1846Z · Substantial damageNTSB CEN09CA044Accident · No injuriesData collectionFinal reportCessna 172M · Carroll, IAThe improper preflight planning/decision made by the pilot in attempting a taxi in high wind conditions. Contributing to the accident was the winds.Oct 26, 2008 · N333AE · Substantial damageNTSB ERA09CA104Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Tallahasee, FLThe pilot's failure to maintain aircraft control after touchdown. Contributing to the accident were the gusting winds.Oct 24, 2008 · N34LM · Substantial damageNTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.Oct 24, 2008 · N5773C · Substantial damageNTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.Oct 20, 2008 · N201EN · DestroyedNTSB CEN09CA028Accident · No injuriesData collectionFinal reportHoward Super Sky Raider · Tuscola, ILThe pilot failed to maintain directional control during takeoff roll. A contributing factor was the cornfield and the pilot's lack of recent experience.Oct 20, 2008 · N3903B · Substantial damageNTSB WPR09CA018Accident · Minor injuriesData collectionFinal reportBeech F33A · Big Bear, CAThe pilot's failure to maintain directional control of the airplane during landing.Oct 19, 2008 · N65HP · Substantial damageNTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.Oct 19, 2008 · N7324K · Substantial damage