NTSB investigations, 1987
21 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\") = 1987
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") = 1987 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 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…