NTSB investigations, 1987
25 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 19 |
| 1986 | 27 |
| 1987 | 25 |
| 1988 | 19 |
| 1989 | 10 |
| 1990 | 14 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 13 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 10 |
| 1997 | 9 |
| 1998 | 11 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 10 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 4 |
| 2005 | 12 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 100)
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" = 100) 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 BFO88FA007Accident · 2 fatalField investigationFinal reportCessna 152 · Warrenton, VAThe acft was observed to be flying straight and level when the sounds of the eng were heard to increase. The only witness saw the acft nose over and dive into the ground. Radar tracking of the acft flt path confirms this. Investigation revealed that the this…NTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…NTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…NTSB LAX87LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Long Beach, CAThe plt indicated that 10 min from his destination he became concerned that the fuel gauges read 'near zero.' The plt elected to divert to another aprt, which was closed. The plt maintained his alt in case of power loss. The plt stated, 'I also became glued…NTSB LAX87LA313Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Buckeye, AZA Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned…NTSB LAX87IA303Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Los Angeles, CADrg arr, japan airline flt 62 (Boeing 747, JA-8163) was initially vectored (by lax ARTCC) for an ILS rwy 24R apch in reduced visibility (haze). Bfr turning final, flt 62 was adzd of an acft that was 4 mi ahead. Flt 62 rprtd that they had the acft in sight.…NTSB LAX87FA286Accident · 2 fatalField investigationFinal reportLuscombe 8A · Oakdale, CAThe plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the…NTSB MIA87FA191Accident · 2 fatalField investigationFinal reportRockwell 690A · Hilliard, FLRadar data indicated the acft climbed normally to 9,200 feet at which time some manuever was performed with the acft. The acft then entered a near vertical dive and the last radar hit was at 6,900 feet. Examination of the acft revealed it experienced an…NTSB CHI87LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILWhile on final approach just past the threshold of runway 32 at about 10 feet AGL, a helicopter crossed in front of the Cessna 152. The student pilot added power and pulled back on the yoke. The instructor pilot then took the controls and attempted to get the…NTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…NTSB ATL87LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Sylva, NCThe CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his…NTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…NTSB SEA87FA106Accident · 1 fatalField investigationFinal reportHiller UH-12E · Shelton, WAThe pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…NTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…NTSB MKC87FA103Accident · 2 fatalField investigationFinal reportChampion 7EC · Delia, KSWitnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled…NTSB FTW87FA105Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Eagle Lake, TXOn April 25,1987 a Grumman American AA5B, N28846, impacted the terrain near Eagle Lake, Texas. The private pilot and her husband received fatal injuries. The aircraft was destroyed. Visual meteorological conditions prevailed at the time of the accident. The…NTSB DEN87FA090Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Berthold, NDThe plt took off to the east from a farm driveway to return home. Witnesses saw the airplane make an immediate right turn, followed by a left turn at aprx 35-50 ft AGL. The acft approached the farm at aprx 50-100 ft AGL. The acft suddenly pulled up, banked…NTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…NTSB DEN87LA075Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Columbus, MTA pre-solo student and CFI were practicing landings. The CFI reduced pwr on climbout at 300 to 400 feet. During the discussion of what to do in case of lost pwr on takeoff, the student executed a steep, 180 degree turn, toward the arpt. The acft stalled, and…NTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…NTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…NTSB ANC87FA043Accident · No injuriesField investigationFinal reportBell 47G-2 · Anchorage, AKA flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…NTSB BFO87LA021Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moundsville, WVOn touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley.NTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…NTSB DEN87FA042Accident · Serious injuriesField investigationFinal reportAero Commander 690A · Miles City, MTThe plt of the nonscheduled domestic pax air taxi flt was flying the vor/dme rwy 22 apch to wiley field, Miles City, MT. The plt said he turned on the autopilot and after turning inbound from the procedure turn towards the faf he engaged the apch mode. After…