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 DEN87LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Upton, WYThe plt reported completing a cross wind landing with strong gusts. While taxiing from landing, the wind lifted the acft from the right and it nosed over. The rwy used was 13, and the FBO reported winds as 210 degrees at 20 knots, gusting to 40 knots.NTSB DEN87LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe student plt had finished practicing touch and go landings on an unsupervised solo flt. During taxi to parking, a gust of wind lifted the left wing and the acft was pushed off the taxiway to the right. The nose gear dropped off a culvert and the right main…NTSB MKC87LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Knobel, ARThe PIC stated that the acft was struck by a gust of wind, and he lost control. The PIC applied rt rudder towards a 1OFT ditch in an att to get over it. The acft was too heavy to fly over the ditch and the acft impacted into the ditch. A review of wx cond's…NTSB FTW87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student plt rprtd that drg a lndg, the wind shifted from a headwind to a left crosswind. Subsequently, the acft veered off the left side of the rwy & enctrd soft mud, then the nose gear collapsed & the acft nosed over.NTSB LAX87LA211Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tucson, AZA Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located…NTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…NTSB ANC87FA070Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKThe pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop.NTSB SEA87LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Orvado, NVDuring landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted.NTSB NYC87LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgartown, MAThe plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was…NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.NTSB LAX87LA204Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring an instructional flt, the student plt had control of the acft during a soft field take-off. The student did not keep the acft aligned with the centerline even after the instructor told the student to add right rudder to stop the drift. Just prior to…NTSB SEA87IA093Incident · No injuriesIncident investigationFinal reportStinson 108-1 · Idaho Falls, IDDuring a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut…NTSB DEN87LA122Accident · No injuriesLimited investigationFinal reportBeausoleil Acro Sport · Englewood, COThe commercial plt was flying his experimental acro sport 1 in the local area. After about an hour of acrobatic practice, he returned for landing to his home arpt. The plt accepted rwy 28 due to heavy traffic. The winds were reported as 050 degrees at 8…NTSB CHI87LA125Accident · No injuriesLimited investigationFinal reportCessna 120 · Lebanon, INWhile landing on runway 18, pilot lost directional control and veered off left side of runway into a gully. The pilot stated prior to landing he received winds reported from 220 degrees at 11 knots through ATIS.NTSB SEA87LA090Accident · Minor injuriesLimited investigationFinal reportRutan VARI-EZE · Renton, WAWhile being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied…NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.NTSB NYC87LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Allaire, NJDuring landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged.NTSB DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was…NTSB FTW87LA112Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Arcola, TXDuring landing roll the aircraft swerved to the right. The pilot applied the left brake and the aircraft nosed over inverted causing substantial damage. The pilot stated that the left brake locked. The reason for the brake seizure is undetermined.NTSB ANC87LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Pt. Mackenzie, AKThe pilot stated that during the takeoff roll on the beach the aircraft struck a sand bar causing the aircraft to nose over on the beach.NTSB DEN87LA115Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Roosevelt, UTDuring landing, as the acft neared the taxiway leading to the parking ramp, the plt applied brakes and the acft veered to the off the rwy. The plt then applied pwr in an attempt to takeoff. The acft paralleled the rwy for a short distance and after crossing a…NTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…NTSB ANC87LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB SEA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blakely Island, WAThe plt landed with excess airspeed past the first third of the downhill runway. The aircraft bounced and the pilot added a little power. The aircraft then struck the runway with the nose gear. Since the plt feared going off the end of the runway into the…NTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…NTSB LAX87LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Fullerton, CAThe pilot reported that a gust of wind turned the aircraft left just prior to touchdown on runway 24. He was unable to maintain directional control during the landing roll and the aircraft ran off the left side of the runway. The reported surface winds were…NTSB FTW87LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXA student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted.NTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.NTSB MIA87LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Daytona Beach, FLThe plt stated that during the landing roll, after depressing both brakes evenly, the rt brake locked up causing the acft to leave the rwy. The arpt was Beach regional airport, Daytona Beach, Florida, the acft collided with a taxiway marker sign & came to…NTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…NTSB ANC87LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Theodore River, AKThe pilot stated that during the landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB MIA87LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadoa, FLDuring the landing roll the plt diverted his attention from taxiing the acft to raising the flaps and turning off the carb heat. The rt wing was then lifted by the cross wind, after which, the plt applied excessive rt rudder. The acft left the rwy, fell into…NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…NTSB MIA87LA140Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe plt stated that after landing he allowed the coplt to taxi the acft though he followed him through on the controls due to his lack of experience on tailwheel acft. The acft veered off the left side of the rwy and before control could be re-established by…NTSB FTW87LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Waring, TXThe newly certificated private pilot landed on runway 17 at a small privately owned airport at Waring, TX. There was a wire fence located 18 feet from the left edge of the landing runway. The pilot allowed the aircraft to drift left off the runway and collide…NTSB ANC87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Goose Bay, AKThe pilot stated that during the takeoff roll at a gravel air strip he lost directional control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Talkeetna, AKOn acceleration for takeoff the front seat adjusting catch became disengaged sliding aft to the rear. The pilot lost directional control of the aircraft causing the aircraft to nose over on its back. Examination of the left seat track shows the track was worn…NTSB NYC87LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Manchester, NHThe Cessna 152 was making a touch and go on rwy 35 with the winds reported to be 170 degrees at 11 knots. The pilot lost control after touchdown and veered off the runway to the left. The aircraft struck a runway light and flipped over receiving substantial…NTSB DEN87LA099Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Erie, COThe private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed…NTSB DEN87LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenrock, WYThe private plt planned a takeoff from the unimproved ranch rwy for a local flt. Elevator trim was not set for takeoff according to the plt. When the tailwheel came up during the takeoff roll, the acft swerved left, and the plt attempted to correct with…NTSB MKC87LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brewster, KSThe PIC rptd verring left and off the side of the sod strip where he was attempting a lndg. The PIC stated that the lndg gear began sinking into soft grnd off the side and the acft slowed rapidly. After slowing the nose wheel collapsed rearward flipping the…NTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN87LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Idalia, COAn ag plt was attempting a takeoff on a dirt road for an aerial application flt. The wind was from the northwest and the acft was aligned to the south. During the takeoff ground run a gust from the rear lifted the acft. The acft departed the road to the left,…NTSB DEN87LA092Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Gillette, WYThe plt reports that just after the tail was raised on the takeoff roll, his seat slid full aft on the rails. He said he was unable to reach the rudder pedals and the acft swerved to the lt, ground looped, and nosed over. The plt was not injured but the…NTSB CHI87LA111Accident · No injuriesLimited investigationFinal reportCessna 150M · Pontiac, ILThe plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm.NTSB BFO87LA029Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Midland, VAThe plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,…NTSB ATL87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Vidalia, GAThe plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed…NTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…NTSB SEA87LA077Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Scott Mills, ORWith a gusting crosswind from the left the pilot allowed the student pilot to make the take off. The student pilot rotated prematurely and the aircraft weathercocked to the left. The pilot then took the controls of the aircraft but by then it was pointed 90…NTSB LAX87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Calexico, CAAt the end of a pleasure cross country flight, the plt reported that upon landing, the acft veered to the left, the plt corrected to the right. The acft veered to the left again and the plt corrected to the right. The acft then began to turn in a clockwise…