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 NYC87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oxford, MAThe plt rprtd that drg a lndg, the acft enctrd a gust of wind & veered into a ground loop before he could correct the situation. The acft then hit a snowbank at the side of the rwy & was damaged. The plt rprtd the wind was from 300 deg at 12 gusting 15 KTS.NTSB BFO87DIG01Accident · No injuriesFinal reportCessna 152C · Gaithersburg, MDWhile taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS.NTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…NTSB FTW87LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Bay City, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when he lost control of the aircraft due to a cross wind.NTSB NYC87LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &…NTSB NYC87LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Livingston, NYDuring landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank.NTSB NYC87LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Beverly, MAStudent pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and…NTSB FTW87FA061Accident · Serious injuriesField investigationFinal reportPiper PA-42 · Horseshoe Bay, TXThe pilot made a fairly long taxi from the ramp to the end of the runway and then started his takeoff roll with the parking brake still partially set. The brakes became very hot and the component parts expanded. After rolling almost 3,000 feet the brakes…NTSB BFO87LA019Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up…NTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.NTSB CHI87LA075Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Dodgeville, WIWhile taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots.NTSB LAX87LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Yuma, AZA Cessna 172M veered left during takeoff ground run on rwy 8 and nosed down on the rwy. The plt indicated that he encountered a left 90 degree x-wind gusting up to 20 KTS. The acft began to veer uncontrolled into the wind. He elected to abort the takeoff at…NTSB CHI87LA074Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntington, INWhile executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest…NTSB FTW87LA053Accident · No injuriesLimited investigationFinal reportBellanca Scout · Boyd, TXA private pilot landed on his private strip made of soft sandy soil, the aircraft ground looped breaking the left main gear 'u' bolt and center bolt. The aircraft's left wing contacted the ground causing substantial damage when the aircraft rolled over on its…NTSB LAX87LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Riverside, CAA Luscombe 8A ground looped on landing roll. The pilot indicated that during the landing roll after his third landing he heard a 'pop' sound. The aircraft veered right, collapsing the left main landing gear and damaging the left wing. After the accident the…NTSB BFO87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodbridge, VAThe student was attempting the last of 3 full stop landings. The landing was made at minimum airspeed. The acft touched down left of the rwy centerline where afterwards the l main gear hit a snowbank alongside the rwy. A loss of directional control occurred…NTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…NTSB ANC87LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Beluga, AKThe pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back.NTSB ANC87FA030Accident · No injuriesField investigationFinal reportCessna C-180-H · Delta Junction, AKThe pilot attempted a glacier landing in daylight conditions and was unable to maintain surface reference. He flew onto the ice and lost control in varying surface winds.NTSB NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.NTSB LAX87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZDuring a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the…NTSB CHI87LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILDuring second touch & go landing, plt encountered a crosswind. While attempting a go-around, after bouncing three times,the acft drifted to the left. The acft collided with a snowbank and nosed over.NTSB ATL87LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Delaware, OHThe student plt reported that he lost control of the acft while landing on rwy 28 in croswind conditions, after a solo x-c flt. The acft landed hard, veered off the rwy, and nosed over. According to the plt, the wind was from 360 at 10 KTS, gusting to 20 KTS.…NTSB DEN87LA045Accident · No injuriesLimited investigationFinal reportCessna 172B · Roswell, NMStudent plt obtained wx briefing from fort worth fss and filed VFR flt plan for x-country flt from plainview, tex, to Roswell, NM, via hobbs, NM,. Plt landed at Roswell, refueled, and filed return VFR flt plan. He did not obtain updated wx briefing. Cold…NTSB NYC87LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Simsbury, CTThe aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface.NTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…NTSB ANC87FA025Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKThe pilot stated that on the third touch and go he raised the flaps and applied power for takeoff when the aircraft started to skid to the left. He cut power, then lost directional control of the airplane causing the aircraft to strike the snow bank.NTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…NTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…NTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…NTSB FTW87LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Worth, TXThe nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.…NTSB BFO87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pungo, VAThe student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to…NTSB MKC87LA041Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Arkadelphia, ARThe student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the…NTSB ANC87LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Chena Hot Sprgs, AKThe pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop.NTSB LAX87LA089Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Paradise, CAWhile practicing touch and goes, the pilot stated that on his last approach a considerable amount of crabbing to the right was required on final approach to runway 35. Upon touchdown the right wing lifted, the pilot turned the control wheel to the right and…NTSB LAX87LA090Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Yucca Valley, CAThe pilot reported that during the takeoff roll, a wind gust caused the left wing to raise and the airplane veered to the right. He immediately applied left aileron and rudder, but to no avail. The airplane went off the runway, hit a tree and fence, and…NTSB SEA87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Deer Park, WAThe plt reported the acft veered to the left during roll out on the snow covered runway. The acft contacted a frozen snow bank and flipped inverted.NTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…NTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…NTSB LAX87LA080Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe student pilot stated that he had just finished practicing 4 touch-and-go with his flight instructor. The flight instructor then exited the aircraft and instructed the student to practice 5 solo touch-and-go. On the take-off run just prior to rotation, the…NTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.NTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…NTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…NTSB MIA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Tchula, MSThe plt stated that while attempting to land at a crop dusting strip he inadvertently landed off to the side of the runway in a plowed field, flipped over and came to rest inverted.NTSB FTW87DRD02Accident · No injuriesFinal reportCessna A-188-B · Ft.Polk, LAExamination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the…NTSB MIA87LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident.NTSB MIA87LA055Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Ocala, FLThe acft dragged a wing during lndg according to the plts statement. The acft came to rest beside the rwy. The plt said he lost control of the acft due to a fuel imbalance. After the accident the left wing tip tank was found full of fuel. According to the…NTSB MIA87LA053Accident · No injuriesLimited investigationFinal reportCessna 150F · Tunica, MSThe plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed.NTSB ANC87LA022Accident · No injuriesLimited investigationFinal reportCessna 206 · Ruby, AKThe pilot stated that during the landing roll on the frozen river, he lost control of the aircraft causing the aircraft to ground loop.NTSB NYC87DHA01Accident · No injuriesFinal reportPiper PA-28-180 · Lehighton, PAStudent pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch.