NTSB investigations, 1986
22 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 21 |
| 1988 | 10 |
| 1989 | 14 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 8 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1986
AND 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 year(c."eventDate") = 1986 AND 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 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.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…