NTSB investigations
244 cases where the first occurrence was “On ground/water encounter with weather”.
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\" = 330) 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" = 330) 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 DEN89LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Miles City, MTThe pilot's improper decision to land and attempt to taxi at an airport where strong winds would not permit safe ground handling of the aircraft.NTSB MKC89LA081Accident · No injuriesLimited investigationFinal reportRockwell S2R T34 · Heth, ARAircraft control not maintained by the pilot in command due to landing in a tailwind of excessive velocity which the pilot misjudged or failed to recognize.NTSB LAX89LA090Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Huntington Bch, CAThe pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors.NTSB DEN89LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYImproper planning/decision by the pilot. Factors related to the accident were the high wind and gusts, which he was unable to compensate for.NTSB DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, CONTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.NTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.NTSB DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMNTSB DEN88LA103Accident · No injuriesLimited investigationFinal reportCessna 172G · Las Vegas, NMThe private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of…NTSB CHI88LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Champaign, ILThe pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)…NTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…NTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…NTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…NTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…NTSB LAX88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Tracy, CAThe surface wind was strong when the pilot began taxiing for takeoff. He did not obtain a preflight weather briefing for the flight. As the aircraft taxied from behind a hangar the strong wind lifted one of the wings and the aircraft rolled over on its back.NTSB LAX88DUQ02Accident · Minor injuriesFinal reportIsgrigg Elite · Tehachapi, CAThe homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15…NTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…NTSB DEN87DTI01Accident · No injuriesFinal reportCessna A188B · Basin, WYThe plt was taking off on a private, 2300 ft, dirt, ag strip with a load of chemicals. The arpt elev was 4185 ft & the rprtd temp was 74 deg. The plt said the wind was calm when he began his takeoff roll, but about 3/4 of the way down the rwy, the acft…NTSB ATL87LA237Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksonville, ALThe plt departed Jacksonville in VFR conds without obtaining a wx briefing. While en route, she observed thunderstorm activity & elected to return to Jacksonville. By the time she returned, the wx had deteriorated & the wind had shifted to the south. The wind…NTSB ATL87LA227Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hopeful, GAThe plt was lndg on a unidirectional ag strip with a tail wind & a thunderstorm (tstm) nearby. He rprtd that drg the roll-out, a gust of wind from the tstm picked up the tail of the acft & flipped the plane over on its top. He estimated the wind was from the…NTSB DEN87LA202Accident · No injuriesLimited investigationFinal reportRushton Sophwith Camel · Carrington, NDThe canadian private plt made an unscheduled fuel stop while on a cross country flight. During taxi from landing, the aircraft encountered a strong gusting crosswind. The left wing lifted and the aircraft nosed over.NTSB MIA87LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLWhile taxiing from landing in reduced visibility the instructor plt stated that he was unable to establish whether or not the acft was on a taxiway. He was then attempting to reverse direction when the rt wing collided with a fence.NTSB SEA87LA117Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Reno, NVWhile soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno…NTSB CHI87LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Dodgeville, WIWhile landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground.NTSB LAX87LA206Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Carefree, AZAt the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…NTSB DEN87LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Missoula, MTThe private plt was practicing touch and go landings. While on a takeoff roll, a gust of wind lifted the right wing and pushed the acft off the rwy to the left. Directional control was lost and the acft taxied through high grass parallel to the rwy. The nose…NTSB LAX87LA201Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring and instructional flight on short and soft field landings, the pilot reported that during the landing roll an unobserved dust devil hit the aircraft. The aircraft was raised approximately 60 ft AGL. The instructor was unable to regain control and the…NTSB CHI87LA116Accident · No injuriesLimited investigationFinal reportCessna 172XP · Superior, WIUpon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were…NTSB MKC87LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Coeur, MOThe PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a…NTSB LAX87LA162Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Paula, CAAt the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the…NTSB LAX87LA159Accident · No injuriesLimited investigationFinal reportJones Pitts Special S1A · Franklin, CADuring the landing roll, the pilot was unable to maintain directional control when a gust of wind from the right pushed the aircraft off the left side of the runway. The aircraft collided with the terrain and nosed over. There was no mechanical failure or…NTSB FTW87FA080Accident · No injuriesField investigationFinal reportConvair CV-580 · Dallas, TXMetro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair…NTSB DEN87LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over.NTSB LAX87LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Lanai, HIThe Cessna 172K nosed over in strong winds while taxiing for departure on rwy 3. The plt indicated that he was 'back taxiing' on rwy 3 when the wind 'got under wing, then under tail, and plane turned upside down.' The plt also indicated that the winds were…NTSB NYC87LA047Accident · No injuriesLimited investigationFinal reportPiper J-3 · East Moriches, NYDuring the takeoff roll on an instructional solo flight, the flight encountered a crosswind which pushed the Piper off the runway to the left colliding with trees and bush.NTSB NYC87LA042Accident · Minor injuriesLimited investigationFinal reportRaven S60A · Montville, CTWhile landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage.NTSB ANC86LA165Accident · No injuriesLimited investigationFinal reportCessna A185F · Hanning Bay, AKThe pilot reported that during a landing, the airplane encountered a strong, gusty crosswind just after touchdown, then nosed over. The wind was reported to be from the northwest at 5 KTS with gusts and light turbulence.NTSB ANC86LA156Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKPilot lost control of aircraft after touchdown on runway due to strong crosswind gust, causing right wing tip to hit ground.NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…NTSB DEN86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Worland, WYOn landing, wind gust lifted left wing and tail section. Acft nosed over.NTSB ATL86LA215Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cumming, GAThe plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down…NTSB DEN86LA201Accident · No injuriesLimited investigationFinal reportGoertz Bushby Musting II · Ruidoso, NMN976J landed on rwy 18, which is 5,500 ft long and 75 wide and has a concrete surface. The wind was from 210 deg at 10 with gusts to 20 KTS. The plt reports that the crosswind caused a swerve to the right and the acft ran off the right side of the rwy. The…NTSB LAX86LA274Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ukiah, CAThe Piper PA-18-150 encountered turbulent wind conditions and dragged the left wing during a takeoff ground run from rwy 33. The plt reported that during the takeoff ground run, the right wing lifted causing the left wing to drag on the rwy. The aircraft then…NTSB CHI86LA237Accident · No injuriesLimited investigationFinal reportPitts S2A · Peru, ILPilot elected to land on runway 18 because the windsock was indicating wind to be fromthe south. Upon touchdown in the first third of the runway the aircraft skipped slightly. Pilot chose to try to stop rather than attempt a go-around and applied heavy…NTSB DEN86LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Cheyenne, WYThe student plt flew from alliance to Cheyenne on his solo x-country and flew locally at Cheyenne to make 3 landings at a twr controlled arpt. While he was in the pattern a cumulonimbus cloud moved into the vicinity of the arpt and the winds became gusty.…NTSB DEN86LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Great Falls, MTThe plt reported that after landing on rwy 24 he was back taxiing on rwy 06 when he encountered strong, gusty surface winds. He said he stopped and was looking for a place to tie down when a strong gust flipped the acft onto its back. Surface wind at the time…NTSB DEN86LA133Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Walsh, COThe plt reports that he was landing to the south on the turf rwy with calm winds when the accident occurred. He said the landing was normal until the acft slowed to 40 to 50 mph at which time a whirlwind was encountered which lifted the right wing. The left…NTSB NYC86LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Matawan, NJThe local sightseeing flight departed marlboro airport at about 1300 hours and returned at about 1400 hours. Entered pattern downwind and flew a normal pattern and approach. During flare, the aircraft was hit by a gust of wind. After touchdown and during…NTSB DEN86LA114Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S-1S · Loveland, COAccording to the plt, the acft encountered a tailwind during the landing roll. The plt said the acft nosed over onto its back when he applied brakes. The plt had indicated his total flt experience in this tail wheel acft to be aprx 4 hrs.