NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) 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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.NTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…NTSB DEN87LA083Accident · No injuriesLimited investigationFinal reportCessna 180B · Boulder, COThe plt reports that he was landing with a lt x-wind at 10 to 15 KTS. He said that at or just after touchdown a gust of wind lifted the lt wing and the acft swerved to the lt off the rwy and nosed over.NTSB MIA87LA127Accident · No injuriesLimited investigationFinal reportCessna 180H · Frostproof, FLUpon touchdown the rt landing gear tire blew due to the side load placed upon it after the acft was blown sideways by the direct crosswind. The landing gear was then sheared off, after which, the acft slid off the rwy into the grass & came to rest.NTSB DEN87LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COAn 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to…NTSB SEA87LA072Accident · No injuriesLimited investigationFinal reportPiper PA 16 · Jean, NVThe plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks.NTSB NYC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bridgeport, NJThe pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees.NTSB DEN87LA077Accident · Serious injuriesLimited investigationFinal reportPitts Special S2C · Deming, NMThe acft swerved during takeoff and the swerve severity increased during acceleration. The plt lifted off before reaching proper speed to sustain flt. The acft stall mushed into the ground to the left of the rwy, bounced into the air and stalled again. The…NTSB FTW87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Palestine, TXDuring flare/touchdown the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted some trees off the right side of the runway causing substantial damage to the wings, tail and landing gear.NTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.NTSB DEN87LA072Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Greeley, CODuring landing roll, after a normal pattern, an unusual noise was heard by the pilot. He described it as a 'thud' or a loud 'pop' noise. The pilot lost directional control and departed the runway to the left. The landing gear was severely damaged. No prempact…NTSB ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…NTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.NTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.NTSB ANC87LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot stated that during taxi for takeoff he lost directional control of the aircraft causing the aircraft to exit the taxiway and strike a snowbank.NTSB ANC87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Fairbanks, AKThe student pilot lost control of the acft which ground looped during a stop and go landing roll. Inspection revealed the right brake master cylinder actuator rod failed.NTSB MIA87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and…NTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…NTSB BFO87LA030Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Norfolk, VAThe tower cleared the aircraft to land on runway 35 at Norfolk international airport with winds from 010 degrees at 20 to 25 knots. The pilot stated that all other traffic was using runway 05. During landing roll the aircraft started to drift to the right,…NTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…NTSB ANC87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot elected to make an off airport landing in his ski-equipped Piper PA18 airplane. He landed the acft successfully, but the right ski attachment and left gear leg collapsed on take off from the uneven terrain. The acft was substantially…NTSB ANC87LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot stated that after touchdown and about 150 feet of the roll, the pilot lost directional control causing the aircraft to exit the gravel runway and striking two parked aircraft.NTSB ANC87LA047Accident · No injuriesLimited investigationFinal reportCessna 150D · Anchorage, AKThe pilot-in-command was a certificated flight instructor with prior experience in tail wheel airplanes, but had not flown a Cessna 150 tail wheel conversion and wished to familarize himself with the airplane by a series of touch and go landings. The pilot…NTSB MIA87LA105Accident · No injuriesLimited investigationFinal reportCessna A152 · Cocoa, FLThe plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident…NTSB MKC87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Point Lookout, MOThe student plt landed the acft and allowed it to slow before applying brakes. The student stated, the acft then began veering to the right side of the rwy. Attempts by the student and CFI to correct the situation were ineffective and the acft departed the…NTSB CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.NTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…NTSB NYC87LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Danbury, CTStudent pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank.NTSB LAX87LA130Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Prescott, AZDuring a local solo instructional flight, the pilot reported that on landing, the aircraft touched-down on the nosewheel first and bounced. The aircraft swerved to the right and the pilot added power to initiate a go-around, however, the aircraft did not…NTSB BFO87LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Charlottesville, VAAfter climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft…NTSB ANC87LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter…NTSB ANC87LA041Accident · No injuriesLimited investigationFinal reportCessna 180B · Palmer, AKThe pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on…NTSB LAX87LA129Accident · No injuriesLimited investigationFinal reportCessna 182Q · Springerville, AZA Cessna 182 collided with a snow bank after veering off runway 3. The pilot indicated that after touchdown the aircraft began to drift right and he was unable to correct it by applying left pedal. The aircraft suddenly veered left and the pilot applied right…NTSB LAX87LA127Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Roosevelt, AZAt the end of a pleasure cross-country flight, the pilot reported that during the landing roll, the passenger was moving around in the back seat and accidentally pressed on the right brake. Before the pilot could get the aircraft under control, the aircraft…NTSB DEN87LA060Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Englewood, COThe rwy was plowed aprx 15 minutes prior to this takeoff. One-half inch of snow still remained along the rwy centerline with up to 3 1/2 inches along the edge of the rwy. The acft veered to the left side of the rwy during the takeoff run and continued aprx 80…NTSB DEN87IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-2A6 · Durango, COAmerica west airlines flt 166, a Boeing 737, departed phoenix, AZ, en route to Durango, CO. During the ILS apch to Durango's rwy 02 in IMC, the captain used a 10-15 degree crab angle to maintain the localizer course. Upon touchdown aprx 1000-1300 ft from rwy…NTSB CHI87FA087Accident · No injuriesField investigationFinal reportRockwell NA265-65 · East Alton, ILAfter landing pilot lost directional control of the aircraft during rollout. Aircraft struck taxiway edge and taxiway marker sign causing substantial damage to aircraft. Post accident testing of the anti-skid system did not reveal any functional defects.NTSB ANC87LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot successfully landed his ski equipped tailwheel airplane on a frozen lake in gusty wind conditions but lost control of the airplane while attempting to taxi from upwind to downwind. The airplane struck its left wing and elevator on the lake ice and…NTSB NYC87LA093Accident · No injuriesLimited investigationFinal reportMooney M20J · Plainville, CTDuring landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the…NTSB FTW87LA068Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Braunfels, TXAcft had been parked in an open field and when the plt returned he noticed that the left skid had sunk into the mud. After eng start and run up, the plt attempted to takeoff with right cyclic applied to un-stick the left skid. The acft lifted off with a right…NTSB NYC87LA096Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYDuring landing roll out, the pilot lost directional control as the aircraft veered to the right side of the runway and collided with a snowbank.NTSB LAX87LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Petaluma, CAAt the end of a pleasure cross-country flt, the plt reported he was downwind to rwy 29 and noted the wind was light from 110 degs. On final apch the plt was following another acft and noted that the acft had a slight crab to the right. The plt observed that…NTSB ATL87LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hixson, TNDuring ldg roll on solo instructional flt, stu plt stated that he applied hand brakes and acft swerved to the left. Skid marks found at the site led from near the rwy centerline to a parked C-172 struck during the sequence. Subsequent inspection of the brake…NTSB ANC87LA038Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe student pilot was practicing touch and go landings on a runway partially covered with snow and ice when he lost control of the aircraft and struck a runway perimeter snow berm. And nosed over.NTSB ANC87LA037Accident · No injuriesLimited investigationFinal reportCessna A152 · Chugiak, AKThe student pilot was practicing touch and go landings on a snow covered runway when the pilot lost control of the aircraft, struck a runway perimeter snow berm and nosed over.NTSB FTW87LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXAccording to the pilot, the aircraft was substantially damaged when he lost control of the aircraft on touch down.NTSB NYC87LA091Accident · No injuriesLimited investigationFinal reportCessna 172-M · Endicott, NYThe Cessna 172 was making a landing on runway 21 when it veered off the runway to the right and struck a snow bank. The aircraft received substantial damage and the sole occupant, the pilot, was uninjured. The winds were reported to be from 330' at less than…NTSB NYC87LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Albion, NYThe student pilot in a Cessna 152 was making a supervised solo and had completed 4 full stop landing without problem when on the fifth landing, the pilot lost control on the ground and hit a snow bank, flipping over. The pilot reported turbulent wind just as…NTSB NYC87LA088Accident · Minor injuriesLimited investigationFinal reportCessna 180H · New Paltz, NYThe Cessna 180/H was departing the runway at night with two passengers on board. The pilot lost control of the aircraft as the tail came up and veered left into a snow bank. After striking the left snow bank, the aircraft veered right and struck the right…NTSB DEN87IA056Incident · No injuriesIncident investigationFinal reportPiper PA-31 · Denver, COWhile taxiing from a cargo ramp for takeoff on an IFR flt, the acft taxied off the ramp into the infield on the arpt and came to rest with the engines running. Ramp personnel boarded the acft, shut the engines down and summoned medical help for the plt who…