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 DEN86LA111Accident · No injuriesLimited investigationFinal reportCessna 170B · St George, UTThe plt stated the acft encountered a crosswind and ground looped during the landing touchdown.NTSB LAX86LA150Accident · No injuriesLimited investigationFinal reportCessna 172M · Rosamond, CAThe plt reported that he successfully touched down during conditions of a right, 90 deg. Crosswind. The plt stated that a gust was then encountered which 'weather cocked' his acft. As he attempted to realign the acft with the rwy the downwind wing contacted…NTSB LAX86LA162Accident · No injuriesLimited investigationFinal reportCessna 182J · Saint Johns, AZThe plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The…NTSB NYC86LA085Accident · Minor injuriesLimited investigationFinal reportRockwell 680FL · Houlton, METhe pilot-in-command landed on runway 5 which had approximately 1 inch of fresh snow. He reported that he encountered whiteout conditions during the landing & lost reference to the runway centerline. The aircraft touched down on the left side of the runway,…NTSB LAX86LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Apple Valley, CAA Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had…NTSB MKC86LA051Accident · No injuriesLimited investigationFinal reportBeech V35 · Bassett, NEWhile landing his acft at Bassett, Nebraska the plt rptd a gust of wind hit the acft fm behind and he lost directional control veering off into a snow bank. The plt stated that two witnesses who were walking near the rwy told him no wind was blowing when the…NTSB NYC86LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Bennington, VTAfter flying in the Bennington, Vermont area for awhile, the pilot decided to land for refueling. On landing the flight encountered strong gusty winds. The aircraft was pushed off to the side of the runway, before pilot could correct for the wind. The…NTSB ATL86FA029Accident · 3 fatalField investigationFinal reportCessna 182R · Bryson City, NCThe acft made a normal apch and had the flaps down to about 15 deg. Touch down as about one third down the rwy. There was a bounce and the right wing came up and the acft veered to the left off the rwy. Power was applied and the acft paralleled the rwy. The…NTSB MKC86LA007Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dumas, AROn landing at a pvt sod strip near Dumas, the plt stated he encountered a strong crosswind. The crosswind forced his acft to veer off the side of the rwy. After veering off the rwy the right wing struck the ground sustaining substantial damage to the wing…NTSB FTW85LA357Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ruston, LAThis 110 hour private pilot lost directional control of the aircraft while landing in a 90 degree cross wind and veered into a pickup truck spraying herbicide on the runway edge lights. Two city employees saw the aircraft coming towards them and escaped…NTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.NTSB SEA85LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Preston, IDThe acft landed at Preston, ID, for fuel in a x-wind of 15-20 KTS, gusting to 30 KTS. A gust at touchdown veered the acft to the rt. The plt attempted a go-around with full flaps. Flaps were reduced as a stall occurred. The acft hit the ground and bounced…NTSB SEA85LA184Accident · No injuriesLimited investigationFinal reportGrumman 164 · Klamath Falls, ORA landing was being made on an agricultural airstrip when a dust devil was encountered. During application of brakes the right brake failed due to a leaking o ring. The aircraft then veered right striking a fence.NTSB DEN85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Lordsburg, NMThe plt said he had encountered moderate turbulence while en route & his passengers became air sick. He decided to land at the nearest suitable arpt. The landing was made without incident. However, while taxiing to the ramp, the aircraft encountered what one…NTSB FTW85LA241Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Fort Worth, TXThe acft was taking off on a test flt to determine the aft c.g. limits in conjunction with an STC modification. As the acft was lifted off in a front skids high attitude, it entered an uncommanded right roll. Full left cyclic would not stop the roll and the…NTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…NTSB NYC85LA115Accident · Serious injuriesLimited investigationFinal reportCessna C172 · Poestenkill, NYCessna 172TD encountered strong gusty crosswind while taking from rensselaer airpark and directional control was lost. The aircraft verred off the left side off the run-way and collid with the terrain. Full right rudder was applied to correct the deviation.…NTSB SEA85LA102Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder City, NVDuring arrival, a person answering the UNICOM reported that rwy 3 was the active rwy & that the wind was 10 KTS. The plt made a wheel landing on rwy 3 in winds that were from 210 deg at 10 KTS. He stated that when the tailwheel came down during the landing…NTSB NYC85FA097Accident · 2 fatalField investigationFinal reportCessna 421B · Johnson City, NYAfter a heavy snow shower passed over the airport, the accident acft attempted a departure. Immediately after takeoff the plt transmitted that he was coming back to land. The acft crashed shortly thereafter, 1 mile southwest of the airport. Ground witnesses…NTSB FTW85LA166Accident · No injuriesLimited investigationFinal reportCessna TU206G · El Paso, TXAcft being taxiied to ramp after landing with wind 27 KTS gusting to 42 KTS. A gust of wind lifted the right wing and the acft nosed over.NTSB SEA85LA074Accident · No injuriesLimited investigationFinal reportGrumman 164A · Ritzville, WADuring landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver.NTSB NYC85LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Reading, PAThe acft overturned while awaiting takeoff from Reading,PA. Wind was reported from 310 degs at 16 KTS, gusting to 22 KTS. After engine up the tower advised N66RA tp hold for landing traffic which was a lear jet. Wind at this time was given as 310 KTS at 27…NTSB LAX85LA149Accident · No injuriesLimited investigationFinal reportCessna 172G · Mojave, CAPrior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position.NTSB CHI85LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Plainfield, ILRight wing of acft was lifted by wind while taxiing after landing. Plt was taxiing south then made turn into tie down area when accident occurred. Flaps were down and control wheel was held forward with left aileron input. Acft flipped over. Plt recommended,…NTSB DEN84LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · West Jordan, UTAccording to the plt, at midfield during the landing roll a gust of wind from the west caught the right wing. The acft ground looped collapsing the left main landing gear and damaging the left wing. While the nearest wx observation facility reported wind from…NTSB MKC84LU006Accident · Serious injuriesFinal reportRotec Rally 3 · Grand Island, NEBefore the flt, the instructor saw a thunderstorm approximatetly 20 mi north of the field, moving slowly to the south-southeast. He & the student elected to make a short flt. After taking off, they made a practice forced landing in an open field about 1 mi…NTSB NYC84LA166Accident · No injuriesLimited investigationFinal reportCessna C188 · Seneca Falls, NYPilot attempted to compensate for gusty wnd cond by lnding the acft tail high. The acft began to wx vane and in an effort to correct, the plt used excessive rt brake. The braking action combined with the gusty wnd exceeded the elevator authority and the acft…NTSB MIA84LA159Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · New Smyrna Bch, FLWhile the plt was taxing onto the rwy, the wind picked up the right wing & the acft was blown inverted. The winds were gusting 30 KTS.NTSB LAX84LA226Accident · No injuriesLimited investigationFinal reportCessna 172K · Lancaster, CAThe acft was blown over as it turned crosswind in gusts up to 40 KTS. The plt said he was using the procedures for taxiing in wind conditions. The Cessna 172 is limited to a 15 kt crosswind component for takeoff.NTSB LAX84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Mammoth Lakes, CAThe plt reported that the acft was blown over as he taxied for takeoff. Also, he reported the wind to be from 200 degrees at 20 KTS. The recorded wind from 180 degrees at KTS gusting to 40 KTS. The maximum demonstrated crosswind component for this acft is 15…NTSB ATL84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Charlotte, NCDuring a wx briefing, before takeoff, the plt was advised that the winds at Charlotte, NC were forcast to be from 230 at 13 gusting to 24 KTS. He was also advised to expect moderate to severe turbulence as well as high en route winds. While en route, he…NTSB LAX84LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Ocotillo Wells, CAThe plt reported that during arrival, he checked for the wind conditions & there appeared to be a light x-wing of appx 5 to 8 KTS. However, while on the landing roll, he encounter an unexpected wind that yawed the acft to the left. Subsequently, the acft…NTSB DEN83LA182Accident · No injuriesLimited investigationFinal reportHelio Courier H-295 · Salt Lake City, UTBefore starting his takeoff, the plt waited for other acft in the pattern to make touch-and-go landings. Immediately before & during his attempted takeoff, the plt saw 2 national guard helicopters hovering over a sod area, west of rwy 34. Reportedly, the 1st…NTSB FTW83LA283Accident · No injuriesLimited investigationFinal reportCessna A-188B · Branch, LAAccording to the plt, the acft was using a longer than normal takeoff roll while taking off with the last load of the day. When he realized it was too late to abort, he dumped his load & continued the takeoff. The landing gear went thru a fence at the end of…NTSB FTW83LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXThe student plt landed at an en route airport after completing the second leg of a solo cross-country flt. He stated that after landing, he taxied to a hanger in order to rest before departure. While preparing to depart, he taxied & stopped short of runway 31…NTSB FTW83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Lajitas, TXThe student plt was on a supervised cross-country flight flt. After arriving at an en route airport, he landed on runway 22 with an estimated crosswind from 310 deg at 10 gusting 20 KTS. After decelerating to taxi speed on the runway, a gust of wind was…NTSB ANC84LA001Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Togiak, AKAccording to the plt, he was assisted by a wing walker while taxiing to the takeoff position. The wind had been increasing steadily during his stop & it changed direction as he arrived at the takeoff position. As he turned the acft into position on rwy 27,…NTSB NYC83LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Middletown, PAAfter landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…NTSB DEN82DTK07Accident · Serious injuriesFinal reportRaven RX-7 · Phillip, SDAfter the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the…NTSB LAX82DA206Accident · No injuriesFinal reportCessna 172 · Mojave, CAWhile the pilot was boarding the aircraft, 2 linemen were holding the wings down. During taxi, the pilot was having difficulty controlling the aircraft. As the aircraft was turning to the runway heading, the wind raised the right wing, the spinning prop hit…NTSB DEN82DA043Accident · No injuriesFinal reportCessna 172 · Broomfield, COAfter landing the aircraft was taxiing to the ramp when a gust of wind lifted the left wing up and tipped the Cessna over on its back. Wind was gusting over 40 KTS.NTSB LAX82DA104Accident · Serious injuriesFinal reportCessna 172 · Las Vegas, NVWhile preparing to takeoff, the pilot was cautioned to beware of wake turbulence from a departing jet and was cleared into position to hold. Preceding the accident, the winds were reported to be from 230 deg gusting to 29 KTS. While turning to align with the…NTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…NTSB MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.