NTSB investigations, 1986
159 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
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\" = 230)
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" = 230) 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 DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.NTSB LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…NTSB MIA87LA059Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Key West, FLShortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,…NTSB DEN87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Nathrop, COThe canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial…NTSB LAX87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Chico, CADuring an ILS apch to rwy 13L, the plt thinking he was at the missed apch point collided with the terrain 200 yrds west of the arpt. The route of flt was determined to be in a north westerly direction. Exam of the navigational instruments revealed that the…NTSB CHI87LA051Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Bloominton, INAccording to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…NTSB CHI87FA050Accident · 1 fatalField investigationFinal reportCessna 182P · Durand, ILStudent pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there…NTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.NTSB SEA87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 414A · Murtaugh, IDDuring the transition from a DME arc to the ILS final apch course, the plt allowed the acft to prematurely descend into the ground. The reason for the descent could not be determined. However, no pre-impact mechanical malfunction with the acft was found nor…NTSB ANC87LA018Accident · No injuriesLimited investigationFinal reportCessna U206G · Uganik Pass, AKThe pilot stated that he encountered a complete white-out condition; he started a turn to the left and struck the top of the ridge at the 1780 foot level.NTSB DEN87FA023Accident · 5 fatalField investigationFinal reportBeech A36TC · Steamboat Sprgs, COPlt and four paxs were returning home from a ski vacation. A witness at the arpt observed a normal takeoff and saw the acft turn towards an area of high terrain located approximately 1.5 miles from the Steamboat arpt. The witness observed N36TS continue on a…NTSB LAX87FA055Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Eloy, AZIn cavu weather conditions, the acft crashed into open, level desert terrain at a 30 deg, nose low and near wings level attitude. No pre-impact mechanical malfunctions were found with the aircraft. There were no witnesses to the accident.NTSB NYC87FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glen Mawr, PADrg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.…NTSB SEA87FA027Accident · 1 fatalField investigationFinal reportCessna U206F · Moose Creek, IDAfter departure and during the initial cruise climb the plt and pax heard a metallic clicking described as sounding like a 'valve tap' in an automobile and coming from the eng area. The plt executed an immediate course reversal back to the airstrip while…NTSB CHI87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Minneapolis, MNThe pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.NTSB MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…NTSB MIA87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homestead, FLThe plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway…NTSB FTW87LA012Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Clarendon, TXThe plt was attempting a takeoff with a 12 kt quartering tailwind when the accident occurred. Immediately following rotation and gear retraction, the acft settled and impacted the terrain.NTSB LAX87FA028Accident · Serious injuriesField investigationFinal reportFairchild Swearingen SA-226TC · Santa Barbara, CAOn a dark night, in cavu weather, the captain directed the first officer (who was flying) to disarm the landing gear warning horn system by pulling its circuit breaker. The f/o complied & did not challenge the captain. On final approach the f/o failed to…NTSB DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…NTSB FTW87LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pollok, TXThe dual student was receiving emergency landing training. Power was reduced while on approach which resulted in a loss of airspeed and a high sink rate. Corrective action was initiated too late and the aircraft touched down a few feet short. The landing gear…NTSB BFO87FA004Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Mount Pleasant, MDThe acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which…NTSB CHI87FA009Accident · 1 fatalField investigationFinal reportCessna 441 · West Chicago, ILThe plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very…NTSB ANC87LA006Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Nightmute, AKAccording to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to…NTSB MKC87LA009Accident · No injuriesLimited investigationFinal reportCessna 501 · Little Rock, ARThe PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further…NTSB LAX87MA018Accident · 2 fatalMajor investigationFinal reportCessna 172N · Altadena, CAWhile rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…NTSB MIA87LA008Accident · No injuriesLimited investigationFinal reportCessna 210 · Kissimmee, FLThe plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in…NTSB SEA87LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Perrydale, ORThe acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.NTSB ANC87LA002Accident · No injuriesLimited investigationFinal reportTeal TSC-1A2 · Lewis River, AKThe plt stated that he landed the amphibious acft on the Lewis River with the gear in the extended position. Shortly after touchdown, the acft nosed over on its top. FAA records showed the plt had a total flying time of aprx 710 hrs.NTSB MIA87FA004Accident · No injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Jacksonville, FLReportedly, during an ILS approach to land, the pilot did not use the company approved checklist and landed with the gear retracted.NTSB LAX87LA012Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dolan Springs, AZThe pilot stated that he was climbing the helicopter up a dry wash and planned to cross a 3000 foot high ridge at about 10 feet above the terrain. As he approached the ridge the helicopter yawed to the right about 70 degrees and the acft main rotor lost RPM.…NTSB MKC87FA002Accident · 2 fatalField investigationFinal reportCessna 150 · Fort Scott, KSThe purpose of the flt was to observe and photograph the effects of a flood which had inundated a part of the city of Fort Scott. The acft was observed flying low and slow over the city. Witnesses said the acft was flying from west to east and made a turn…NTSB BFO86FA050Accident · 1 fatalField investigationFinal reportMooney M20F · Leesburg, VADrg arrival, the plt was clrd for a VOR rwy 35 apch. Also, he was advised that there were problems with the rwy lights &that other plts had made missed apchs that evening due to dim arpt lighting. He was then clrd to UNICOM freq & told to cancel his IFR clnc…NTSB NYC86LA243Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Seneca Falls, NYThe acft was landed gear up and was subsequently destroyed by fire. The plt admitted he forgot to lower the gear. It wasconfirmed during the post accident inspection that the gear selector was in the up position and the gear doors were closed.NTSB CHI86LA232Accident · Serious injuriesLimited investigationFinal reportMcculloch J-2 · Rush City, MNJust after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the…NTSB MKC86LA192Accident · No injuriesLimited investigationFinal reportBeech E55 · Kansas City, MOThe plt rprtd that this was a positioning flt for a 100 hr inspn & that the acft was having electrical problems thru-out the flt. According to him, he extended the flaps & put the gear handle in the down position as he made a VOR apch at night; however, the…NTSB CHI86FEC07Accident · No injuriesFinal reportPiper PA-36-285 · Imlay City, MIThe pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end…NTSB SEA86FA248Accident · 2 fatalField investigationFinal reportCessna 172 · Overton, NVThe UNICOM operator at boulder city made radio contact with '81J' at about 2300 PDT, after hearing an acft maneuvering in the area. The plt stated he did not plan to lnd at boulder city, but said he intended to fly 'up the vegas wash' area. At aprx 2300 to…NTSB ANC86LA160Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · American River, AKAfter landing on a 1200 ft gravel bar, the plt paced off the available area, estimated the load to pick up, then loaded the acft. Due to the x-wind, he used less than takeoff flaps. He began taking off, but after lift-off, the acft 'seemed to hit a…NTSB ANC86FA167Accident · 2 fatalField investigationFinal reportPiper PA-18 · Port Alsworth, AKUndetermined.NTSB LAX86LA344Accident · No injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAThe helicopter departed palomar airport (crq), Carlsbad, CA, on a local instructional flight and was the second flight for the dual student. After completing the flight lesson the student asked the CFI to demonstrate hovering. The CFI initiated an…NTSB ANC86LA149Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Umiat, AKThe airplane departed on September 7, 1986 for a local hunting trip with a client. The airplane did not return and the wreckage was found on September 9, 1986. The airplane was destroyed by post-impact fire. According to the guide, for whom the pilot was…NTSB CHI86FA218Accident · Minor injuriesField investigationFinal reportLearjet 24 · Ypsilanti, MICrew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down…NTSB SEA86FA233Accident · 1 fatalField investigationFinal reportCessna 180 · Wallace, IDPlt received wx brief, advised VFR for proposed flt. Plt filed VFR flt plan and departed. Wreckage located 2 days later at crest of mountain pass.NTSB SEA86LA228Accident · No injuriesLimited investigationFinal reportCessna 152 · Lummi Island, WAThe plt stated he remembers passing arlington, WA, at an alt of aprx 2,000 ft MSL but, remembers nothing else until the acft collided with trees. The plt believes that he fell asleep during the flt.NTSB DEN86MA241Accident · 7 fatalMajor investigationFinal reportCessna 441 · Lander, WYOn 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.…NTSB ATL86LA229Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Benson, NCThe acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site…NTSB SEA86LA214Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cusick, WAThe pilot was performing as a barnstormer close to a local fair. After completion of several low passes the pilot was attempting to make a steep 180 degree turn to a landing. The turn was completed at insufficient altitude to recover and the aircraft struck…NTSB ANC86FA130Accident · 3 fatalField investigationFinal reportCessna 177RG · Hinchinbrook Is, AKAt 1323 adt, the plt rprtd near Hinchinbrook island & requested clearance for an ndb-a apch to the cordova mile 13 arpt. About 3 min later, cordova fss provided clearance for the apch 'from over Hinchinbrook.' Radar data showed that the acft flew to the…NTSB MKC86LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Republic, MOThe pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is…