NTSB investigations, 1986
370 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 332 |
|---|---|
| 1983 | 466 |
| 1984 | 438 |
| 1985 | 425 |
| 1986 | 370 |
| 1987 | 348 |
| 1988 | 369 |
| 1989 | 320 |
| 1990 | 359 |
| 1991 | 354 |
| 1992 | 332 |
| 1993 | 304 |
| 1994 | 323 |
| 1995 | 280 |
| 1996 | 263 |
| 1997 | 264 |
| 1998 | 281 |
| 1999 | 263 |
| 2000 | 274 |
| 2001 | 248 |
| 2002 | 245 |
| 2003 | 279 |
| 2004 | 237 |
| 2005 | 281 |
| 2006 | 249 |
| 2007 | 299 |
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\" = 250)
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" = 250) 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 FTW87FA041Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Robertson, TXWitnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction…NTSB CHI87LA059Accident · No injuriesLimited investigationFinal reportCessna 172H · Mosinee, WIThe CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the…NTSB CHI87FA060Accident · 2 fatalField investigationFinal reportCessna 150L · Lakeview, MIWitnesses observed the aircraft buzzing a farm where a friend of the pilot resided. Following a low pass, the aircraft pulled up into a steep, left climbing turn. At the top of the climb, the nose dropped and the aircraft spiraled into the ground.NTSB SEA87LA039Accident · No injuriesLimited investigationFinal reportHughes 269 · Matlock, WADuring takeoff the aircraft nosed over inverted and then struck the ground. The pilot found after the accident that a strap had hooked under the skid of the aircraft.NTSB NYC87DNC04Accident · Serious injuriesFinal reportTaylorcraft BC12D · West Farmington, METhe aircraft climbed in a steep attitude after takeoff to an alt of aprx 100 ft AGL. The acft then stalled and impacted the terrain in a left wing low attitude.NTSB MIA87FA062Accident · 2 fatalField investigationFinal reportPiper PA-34 · Ft. Lauderdale, FLThe pvt plt had been cleared for 27R ILS apch and was on the localizer at 1,600 ft when the controller noticed the acft north of the localizer course and in a right turn headed east. The controller querried the plt as to his heading and the plt replied,…NTSB LAX87FA069Accident · 6 fatalField investigationFinal reportBeech E-55 · East Palo Alto, CAThe pilot and 5 passengers departed for a planned vacation in Mexico in dark night conditions. The aircraft was observedto depart from runway 30, turn from the crosswind to the downwind leg and the aircraft 'lost altitude rapidly' and impacted in the san…NTSB DEN87FA037Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Lewistown, MTOn the morning of the day of the accident the private plt/owner and his friend took off on an all day coyote hunting flt. When the acft failed to return that evening an air and ground search was begun. The burned wreckage of the acft was found 3 days later…NTSB ATL87FA047Accident · Serious injuriesField investigationFinal reportCessna 310N · Savannah, GADuring ILS rwy 9 appraoch acft disappeared from radar at one mile short of rwy. Acft impacted in level attitude with landing gear extended on a northerly heading one half mile short and about one quarter mile left of rwy centerline. Plt and CFI both stated…NTSB MIA87FA056Accident · 1 fatalField investigationFinal reportCessna 172N · Middleburg, FLThe flt was receiving flt following services from jacksonville apch control. Radar and radio contact was lost shortly after the plt reported to apch control he was descending out of 4,500 ft in preparation for his landing at st. augustine, FL. A witness…NTSB MKC87FA033Accident · 2 fatalField investigationFinal reportChampion 7ECA · Cambridge, NEThe low time PIC had been flying his acft over the farm land in search of coyotes. Several of the grd crew had flown as psngrs with him during the time period of this search. Witnesses stated that they saw the acft turn left and right as it was spotting the…NTSB SEA87LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Yamhill, ORThe plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed…NTSB MIA87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hollywood, FLThe plt stated that the acft tilted shortly after liftoff and he elected to abort the takeoff. While on roll out, when the brakes were applied, the acft veered to the left and ran off the rwy colliding with a fence. The plt reported no mechanical difficulties…NTSB CHI87LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Middleton, WIAt the completion of a period of instrument training and while returning to the airport of origin the CFI asked the private rated dual student to demonstrate a simulated forced landing to the runway. In an attempt to lose altitude on the final approach the…NTSB ATL87LA044Accident · No injuriesLimited investigationFinal reportHughes 269C · Bowling Green, KYWhile hovering in a grassy area near the hangar facility, the pilot experienced a complete loss of flight control. The helicopter struck the ground and sustained substantial damage. The helicopter component examination failed to disclose any system…NTSB LAX87DUJ03Accident · Minor injuriesFinal reportSolem KR-2 · Mesa, AZThe pilot said that shortly after takeoff the control stick shuddered and he felt 'back pressure' on the stick. The nose started pitching up so he pushed forward on the stick. He continued pushing the stick forward until it reached the forward stops. Despite…NTSB MIA87FA045Accident · 1 fatalField investigationFinal reportNorth American Rockwell 112 · Jacksonville, FLThe acft, being flown by a non-instrument rated plt, appeared over the arpt without making contact with the tower while the arpt was under instrument flt conditions and the control zone was in operation. After making several erratic passes the plt contacted…NTSB ANC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe pilot stated he encountered freezing rain and due to the build-up on the aircraft, he stalled and crashed in an open area next to the airport.NTSB NYC87FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, PAThe student pilot flying a Cessna 152 scheduled his flight period so it coincided with another student pilot flying a Cessna 172. The pilot of the Cessna 172 reported seeing the Cessna 152 enter a two turn spin and recover. He then said he lost sight of the…NTSB DEN87LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Havre, MTThe plt inadvertently stalled the acft during pull-up after making a pass 20 ft above coyotes on the ground. The acft impacted level terrain and slid through a wire fence.NTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…NTSB NYC87DFA02Accident · No injuriesFinal reportSchweizer SGS 2-33A · Wurtsboro, NYThe pilot was landing a Schweizer SGS-233 when he started to get into a pilot induced oscillation. The oscillations increased and the aircraft impacted in a nose low attitude. The pilot said the accident could have been prevented with less control input,…NTSB SEA87LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Kennewick, WAThe private pilot was seated in the right front seat with the student pilot in the left front seat. The pvt pilot allowed the student pilot to takeoff. The student over rotated and the stall warning was sounding. The pvt pilot took command of the aircraft but…NTSB SEA87LA033Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Waitsburg, WAThe pilot elected to circle coyotes at a very low altitude. During the second turn the aircraft felt mushy. The aircraft's left wing tip struck the ground followed by the aircraft striking the ground hard and flat.NTSB NYC87LA036Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman 75 · No.Andover, MAThree banners were laid out for pickup by two stearman aircraft. One banner was an extra. The two stearmans approached the banner pick up point as a flight of two. As the first aircraft made its pickup an extra banner became tangled with the designated pickup…NTSB FTW87FA021Accident · 1 fatalField investigationFinal reportMooney M20E · Arcola, TXThe plt departed Arcola, TX, VFR, on rwy 10, made a 180 degree left climbing turn and entered clouds at about the boundary line on the west side of the arpt. The radar operator stated the acft continued westbound one to two miles beyond the arpt then entered…NTSB BFO87LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Easton, MDThe student plt stated that the landing approach was normal until the acft was over the rwy threshold; at a height of 35 ft, he encountered moderate to strong turbulence and afterwards the acft pitched up ten degrees and entered into a moderately steep left…NTSB ANC87LA014Accident · Minor injuriesLimited investigationFinal reportCessna 305E · Barrow, AKThe pilot stated that during the takeoff he had full right aileron and left rudder. The pilot lost directional control of the aircraft and crashed off the left side of the runway. At the time of the accident the wind was five knots or less.NTSB LAX87FA045Accident · 2 fatalField investigationFinal reportCessna 150L · Lake Isabella, CAThe aircraft departed the kern valley airport, kernville, California, on a direct cross-country route to its home base at general william j. fox airfield, lancaster, California. The flight route was over mountainous terrain that was obscured by clouds. A…NTSB ANC87LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Big Lake, AKThe student plt stalled the acft at aprx 20 to 30 ft AGL during the initial climbout. Subsequently, the acft impacted the rwy & went off to the side.NTSB MIA87FA031Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Columbus, MSThe acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in…NTSB CHI87DEX01Accident · No injuriesFinal reportTurnbloom Kitfox · Crawfordsville, INThe plt rprtd that when he was preparing for the acft's 1st test flt, he made a hi speed run with the tail raised & acft control was good. On the next run, he planned to let the acft lift off the rwy, then let it settle back on the surface. He stated that he…NTSB MKC87FA017Accident · 1 fatalField investigationFinal reportBeech E18S · Texarkana, ARThe airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…NTSB MKC87FA015Accident · 1 fatalField investigationFinal reportCessna 310Q · Liberal, KSThe acft impacted the terrain just off the departure end of rwy 17 at Liberal, KS, while on a return flt to Texas. Dark night conditons prevailed and no horizon visual cue were available shortly after takeoff. Reliance on flt attitude instruments would have…NTSB MIA87FA022Accident · 1 fatalField investigationFinal reportGrumman G-164A · Orlando, FLWhile the plt was making a banner pick-up, witnesses saw the acft engage the banner & enter a climb. The plt released the banner, then the acft mushed into a partially built hangar, crashed & burned. The plt, who was on fire, exited the rgt canopy hatch.…NTSB CHI87DEE03Accident · Serious injuriesFinal reportQuicksilver MX II · Aurora, ILThe pilot was making a precautionary landing in the ultralight, when during the landing flare he stalled the aircraft and subsequently collided with the terrain.NTSB DEN87FA014Accident · 3 fatalField investigationFinal reportCessna 172M · Bozeman, MTThe plt and his 2 pax's went flying to spot elk in a canyon area. A witness observed the acft low over trees when it suddenly shuddered, banked sharply to the left, then entered a steep descent. The aircraft crashed in a wooded area on the side of the canyon.…NTSB ATL87LA148Accident · 1 fatalLimited investigationFinal reportCessna 150J · Memphis, TNPrior to its discovery on may 20, 1987, this acft had last been seen on x-wind leg on climb out after a touch and go at dewitt spain arpt. Parts of the acft were recovered from the Mississippi river northwest of the arpt. The plt's remains had not been…NTSB NYC87LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Haverhill, MAThe student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full…NTSB MKC87FA012Accident · 2 fatalField investigationFinal reportPiper PA-24 · Siloam Springs, ARThe plt had logged 3 hrs of simulated instrument training prior to this accident. He received a wx briefing which reported wx conditions nearby were IFR due to low ceilings and fog. Immediately after takeoff, the acft started a left turn and impacted terrain…NTSB ATL87FA016Accident · 1 fatalField investigationFinal reportKoons-Donald Sonerai II · Macon, GADuring climbout, the pilot allowed the aircraft to stall while turning to a left crosswind. The acft impacted the ground in a nose low attitude after colliding with two trees. The pilot was unable to exit the aircraft and local residents were unable to assist…NTSB DEN87FA011Accident · Serious injuriesField investigationFinal reportCessna 172P · Gallup, NMWhile flying at a low level spotting deer in mountainous terrain the plt attempted to fly over a ridgeline with terrain that rose faster than the acft climb capability. At low airspeed and altitude he initiated a turn to reverse course toward lower terrain.…NTSB CHI87DEM03Accident · No injuriesFinal reportRalley 3A · Gowen, MIThe pilot stated that the aircraft stalled while practicing an emergency landing. He also stated that he should have pulled up from the practice emergency procedure sooner.NTSB CHI87FA012Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Int'L Falls, MNThe acft was observed maneuvering over the passengers house just prior to the accident. The plt circled the residence with the acft wings almost perpendicular to the ground at an alt between 150 and 200 ft AGL. According to witnesses, as the wings reached the…NTSB BFO87LA005Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Harborton, VADuring an apch to land, the plt expereinced a loss of tail rotor effectiveness and the acft rotated to the right. The airspeed was reported as 30 mph with a descent rate of 150 fpm and the acft was less than 50 ft AGL. The acft then descended to a collision…NTSB ANC87FA009Accident · No injuriesField investigationFinal reportArtic Privateer S4 · Anchorage, AKThe acft desceded to terrain impact and nosed over following a loss of control as it climbed out of ground effect during takeoff. The plt reported he and his passengerds 'roped' frost off of the acft wings and other control surfaces prior to takeoff. Post…NTSB LAX87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring a first solo instructional flight, the pilot was taking off from his third touch-and-go when at an altitude of approximately 10 feet AGL the right wing was suddenly rose. The aircraft then veered to the left. The left main gear then collided with a…NTSB MKC87DCQ01Accident · 1 fatalFinal reportJames Olivier Quickie · Harper, KSA witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls.NTSB LAX87FA017Accident · 2 fatalField investigationFinal reportBell 206B-3 · Lompoc, CAThe helipad deck at the stern of the barge was covered with a loosely secured rope net and witnesses reported that as the helicopter lifted up to a hover the net came up 'caught on the rear of the left skid.' The acft was seen to hover for a moment with the…NTSB FTW87LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Caddo, TXPrivate pilot in Cessna T210 attempted take off from soft, unimproved field, pilot and 1 passenger, 80 gallons fuel, crosswind component of 12 knots. Pilot rotated aircraft prematurely. Acft settled back to ground and became airborne with approximately 20 ft…