NTSB investigations, 1986
27 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\") = 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\" = 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") = 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" = 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 FTW87DQA01Accident · 1 fatalFinal reportBeggs Pitts S-1 · El Paso, TXCommercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX.NTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…NTSB LAX87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Davis, CAA Cessna 152 nosed over in a rough plowed field after a partial loss of power while on a night VFR pleasure flight. The pilot indicated that he was on a date with his girl friend and offered to demonstrate negative gravity to her. He slowed the aircraft and…NTSB CHI87LA041Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Vergenns, ILAccording to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the…NTSB NYC87LA035Accident · No injuriesLimited investigationFinal reportCessna 185F · Ithaca, NYThe pilot of the landing Cessna 185 swerved to avoid hitting a deer that was crossing the runway at night. The left wing tip and elevator contacted the runway as the aircraft ground looped. The aircraft received substantial damage, however, it was able to…NTSB DEN87LA013Accident · No injuriesLimited investigationFinal reportPitts S-1D · Shelby, MTThe plt took off with little or no warmup, pushed the acft to max performance at 10 ft, performed a max performance climb to 300 to 400 ft and reduced throttle to idle. As the acft reached stall speed, the plt dived at a 45 degree angle and impacted the…NTSB CHI87DEM01Accident · 1 fatalFinal reportBrown Acro Sport II · Grand Haven, MIAccording to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a…NTSB MKC86LA199Accident · No injuriesLimited investigationFinal reportBell 206A · Texarkana, ARThe pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1 , and the throttle at flight idle. When the helicopter achieved…NTSB DEN86FA252Accident · 1 fatalField investigationFinal reportCessna 172M · Bennett, COThe plt, a bail bondsman, flew to goodland, KS, reportedly in search of an accused felon. On the afternoon of the accident, the plt obtained a wx briefing from the fss and filed a VFR flt plan back to the brighton-van aire airport in Colorado. Wx was cavu.…NTSB SEA86FA245Accident · 2 fatalField investigationFinal reportCessna 150M · Carbonado, WAThe instructor and passenger departed on either an introductory flight, initial instructional flight, (or combination thereof). During the flight the aircraft was flown down a canyon which the instructor had flown down previously. As the aircraft approached…NTSB NYC86FA219Accident · 1 fatalField investigationFinal reportCessna 152 · Bargaintown, NJThe student pilot on a supervised solo cross country, diverted from his planned route and was observed flying low over a residential area performing maneuvers at or below tree top level. The pilot apparently lost control of the aircraft. Aircraft impacted the…NTSB FTW86FA142Accident · Serious injuriesField investigationFinal reportBell 206B · Watson, OKPilot of Bell 206B conducting forestry operations experienced problem with fire dispensing apparatus being slung beneath aircraft while returning to helipad for fuel. Pilot landed, released external load, and got out of aircraft to release electrical…NTSB NYC86FNC07Accident · Serious injuriesFinal reportCessna 150M · Nashua, NHThe CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from…NTSB NYC86FHD02Accident · Minor injuriesFinal reportCessna 172K · Jobstown, NJWhile on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but…NTSB DEN86LA178Accident · No injuriesLimited investigationFinal reportCessna 182F · Joliet, MTAccording to the plt, horses ran in front of him during landing and he was forced to make evasive maneuvers. During the evasive maneuvers, the acft ground looped and was substantially damaged.NTSB DEN86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Provo, UTThe student & instructor (CFI) were practicing touch-&-go lndgs. The CFI rprtd that drg a lndg, when the acft was aprx 6 inches above the rwy, the student suddenly applied full left rudder. The acft yawed sharply to the left & the CFI attempted corrective…NTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…NTSB DEN86FA146Accident · 1 fatalField investigationFinal reportBauer'S Mitchell Wing U-2 · Cheyenne, WYThis was an experimental amateur-built acft. Witnesses reported seeing the acft in a steep right bank when the eng lost power. The acft was then seen to stall and enter a right spin. Witnesses said the plt recovered but entered a second stall and dove…NTSB BFO86FID08Accident · 1 fatalFinal reportMilliken Gyrocopter B-80 · Suffolk, VAAccording to a plt witness the accident plt was attempting to compensate for an increase in wind velocity when the accident occurred. The witness stated the plt entered a steep dive to compensate for the increase lift followed by the gyrocopter ballooning due…NTSB NYC86FA112Accident · 1 fatalField investigationFinal reportCessna 310 · Lincoln, RIThe air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated…NTSB FTW86FA051Accident · 4 fatalField investigationFinal reportCessna 172N · Del Rio, TXThe pilot was doing aerobatic maneuvers in the Cessna 172 airplane with three passengers and a heavy load of fuel aboard. The maneuvers consisted of buzzing boats on the lake at very low altitude, at least one complete aileron roll, several very abrupt…NTSB ATL86FA102Accident · 2 fatalField investigationFinal reportNorth American NA219 (T28B) · Luthersville, GAAfter takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an…NTSB FTW86FA050Accident · 3 fatalField investigationFinal reportLockheed L-402-2 (LASA-60) · Seagoville, TXAcft crashed immediately after takeoff on a flt to discharge jumpers over a drop zone located on the arpt. Witnesses stated that shortly after liftoff the acft entered a steep left bank estimated between 45 and 70 degs. After about 120 degs of turn the acft…NTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…NTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…NTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…NTSB NYC86FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Andover, NJThe student plt had difficulty landing the acft and instructor had devoted training session to landing technique. The difficulty was reported to be a tendency to over-flare prior to touchdown. Satisfied the student had corrected his problem area, the third…