NTSB investigations, 1986
213 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 302 |
|---|---|
| 1983 | 260 |
| 1984 | 261 |
| 1985 | 230 |
| 1986 | 213 |
| 1987 | 198 |
| 1988 | 191 |
| 1989 | 203 |
| 1990 | 181 |
| 1991 | 155 |
| 1992 | 189 |
| 1993 | 170 |
| 1994 | 163 |
| 1995 | 163 |
| 1996 | 146 |
| 1997 | 154 |
| 1998 | 161 |
| 1999 | 164 |
| 2000 | 164 |
| 2001 | 150 |
| 2002 | 143 |
| 2003 | 155 |
| 2004 | 137 |
| 2005 | 112 |
| 2006 | 114 |
| 2007 | 126 |
Where
Latest 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\" = 220)
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" = 220) 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 SEA87LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Gates, ORThe plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose…NTSB NYC87DNE01Accident · Serious injuriesFinal reportKosch Whitehead #21 · Stratford, CTThe experimental aircraft was making taxi tests on an abandoned taxiway when it became airborne. A photographer rushed out from a marked safety area directly in the flight path of the aircraft and was struck by the aircraft receiving a broken arm. The…NTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…NTSB ATL87FA051Accident · 2 fatalField investigationFinal reportBeech 35-33 · Blountville, TNDrg vectors for a ILS rwy 23 apch, the plt allowed the acft to get 400' below the assigned alt of 3700'. The controller (ctlr) queried the plt about his alt & the plt replied he had gotten a little low, but was returning to the assigned alt. After…NTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…NTSB MKC87FA035Accident · Serious injuriesField investigationFinal reportCessna 414A · Olathe, KSThe plt stated that this was not a charter flt and, as such, he decided to attempt the LOC 17 apch to Olathe even though the area was forecasting zero-zero conditions. According to the plt, the last thing he remembers during the flt is bracketing the LOC and…NTSB FTW87LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Marble Falls, TXA pilot on a cross country flight in the local area at randolf afb, TX. Was flying low over the llano river about 50 ft. AGL and contacted a power line, substantially damaging the right wing. The pilot continued on to randolf afb and landed without incident.NTSB MIA87LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sarasota, FLTwo ldg attempts were made at the physician plt's private arpt but were abandoned due to strong shifting violent winds. The plt later stated the last thing he remembered was seeing 500 ft on the altimeter & telling himself 'to get up & out of there' the acft…NTSB CHI87DEX04Accident · Serious injuriesFinal reportAero Commander 500B · Hagerstown, INThe pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and…NTSB MIA87FA047Accident · 1 fatalField investigationFinal reportBeech C-55 · Ivel, KYThe plt who was originally scheduled to make the charter flt to pick up the pax was reluctant to do so due to low ceilings in the mountainous area at the destination. The owner of the company took the flt & the flt was observed by witnesses near the…NTSB CHI87MA053Accident · 2 fatalMajor investigationFinal reportHughes 269B · Cross Plaines, INThe plt & observer were on a power line patrol flt. While proceeding southbound, they apchd an area were the lines were about 23 ft AGL & were crossed by another set of power lines, oriented in an east-west direction. The other power lines were about 45 ft…NTSB ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…NTSB LAX87DUJ02Accident · No injuriesFinal reportGrumman G-164 · Chandler, AZThe acft collided with power lines during an aerial application flight. The pilot had made several passes prior to the accident and noticed the wires each time. Visibility was good, it was daylight conditions, and there were no mechanical problems.NTSB FTW87FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Baytown, TXThe plt took off from a decommissioned, unlighted arpt at night after telling friends in a bar that he was going to new orleans. Later, witnesses observed the acft as the plt made several low passes over an interstate highway near the departure arpt. While…NTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…NTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…NTSB ATL87FA029Accident · 4 fatalField investigationFinal reportBeech 35-B33 · Winston-Salem, NCThe flt departed rochester, NY, and received and IFR clearance. The flt and ATC handling were normal. The plt was cleared for the ILS rwy 33 apch to Winston-Salem, NC. The flt was established on the final apch but collided with trees about 2 miles southeast…NTSB LAX87DVA02Accident · No injuriesFinal reportSchweizer G-164A · Fresno, CAThe airplane collided with telephone lines while conducting an aerial application operation. The pilot reported that he was familiar with the area. He surveyed the field, in flight, before he commenced the spraying activities. The pilot did not report, nor…NTSB MKC87LA024Accident · No injuriesLimited investigationFinal reportCessna 177XP · Camden, ARThe pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA.NTSB LAX87LA352Accident · 2 fatalLimited investigationFinal reportCessna 180K · Lakeport, CAThe plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was…NTSB FTW87LA020Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Holden, LAA commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student…NTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…NTSB CHI87LA032Accident · No injuriesLimited investigationFinal reportBurkhart Grob 109B · Gregory, MIWhile landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the…NTSB SEA87LA025Accident · No injuriesLimited investigationFinal reportHughes 369D · Winlock, WAThe plt was loading xmas trees from a farm to a truck. He had just released a load and was en route back to the pickup area when the empty long-line sling contacted treetops. The sling rebounded into the tail rotor & damaged the gear box which resulted in…NTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…NTSB MIA87DKT01Accident · Minor injuriesFinal reportPitts S-1T · Miami, FLAircraft collided with trees while recovering from a spin which was performed at low altitude as part of an airshow performance. Pilot stated he misjudged height of trees and recovered from the spin too low.NTSB CHI87FA021Accident · 1 fatalField investigationFinal reportCessna 182P · Goreville, ILThe acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and…NTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.NTSB CHI87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INDuring an instructional flight a bird strike was encountered while practicing steep turns at about 2500' MSL. The horizontal stabilator was damaged to the point that it was barely operative. Landing was accomplished by using extreme forward pressure to the…NTSB MIA87FA020Accident · 1 fatalField investigationFinal reportBushby MM-1 · New Smyrna Bch, FLWitnesses, including the victim's son riding as a pax in another acft flying at 800 ft, observed the midget mustang coming up from the right, behind and below them. While still below their alt, the mustang was observed to roll to the right, away from them,…NTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.NTSB BFO87FA006Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Bloomington, MDWitnesses observed 2 aircraft flying near treetop level and reported that one appeared to be about 10 feet behind the other. The lead aircraft collided with trees when the pilot delayed his pullup to a point where he was unable to climb over a ridge on his…NTSB MIA87FA015Accident · 1 fatalField investigationFinal reportde Havilland DHC-3 · San Juan, PRWitnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The…NTSB DEN87LA010Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Richardton, NDThe plt attempted a landing on an unlighted dirt strip at dusk. He stated he intentionally flew low because it was getting dark. On final apch acft struck trees and then impacted the terrain, nosing over.NTSB CHI87LA014Accident · No injuriesLimited investigationFinal reportBeech V35A · La Pointe, WIThe acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure.NTSB DEN87FA007Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Crosby, NDCrosby municipal arpt was notam'd closed due to rwy construction and resurfacing. The plt and paxs were employees of the engineering company participating in the arpt construction. The plt of N8271P had landed on the closed rwy earlier in the day. The rwy was…NTSB MKC87DCA01Accident · 2 fatalFinal reportCessna C-152 · Fredericktown, MOThe aircraft was being used to give relatives local area flights. The witnesses reported that the airplane had been doing low altitude maneuvers, stalls, and engine power cuts for over an hour. The witnesses observed the acft in a low altitude pass when it…NTSB NYC87FA023Accident · 1 fatalField investigationFinal reportCessna R172K · Rockwood, TNThe aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104…NTSB ATL87DEG01Accident · No injuriesFinal reportCessna T210N · Cleves, OHThe plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus…NTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…NTSB LAX87DVA01Accident · Minor injuriesFinal reportRockwell S-2R · Dos Palos, CAAfter departing the field on his last spray application, the aircraft's left wing collided with an antenna guy wire located about 100 feet above the ground. The pilot attempted to return to the airstrip aprx five miles away. However, as he entered into a…NTSB ATL87LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172P · East Liverpool, OHRwy repair was in progress. The rwy was closed & battery powered lights were left to mark a 5 inch deep ditch that crossed the runway. Arpt & rwy lights were left off. The FBO continued to rent acft for operations from the arpt. The plt departed on a 28 mi…NTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…NTSB DEN86LA263Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Durango, COWhile flying low level inside a river gorge at 200-300 feet above the water, the balloon impacted a power line and fell into the river.NTSB MIA86LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLWhile on approach to runway the pilots vision was restricted by the glare from the rising sun. The pilot failed to see the operating approach light system which is located in the closed first 2000 feet of runway, and collided with the approach light system.…NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB ATL86LA258Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Chardon, OHDuring final landing approach to runway 14, the sutdent pilot deployed spoilers and attempted to maintain altitude. The glider collided with trees and descended out of control to the ground 200 feet short of the runway. The student pilot had a total flight…NTSB BFO86LA046Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Roanoke, VAThe hot air Balloon was involved in an air show flight event. While enroute to the airport the plt stated that he encountered winds that forced him to land short of the arpt. During the lndg apch he became distracted by spectators on the ground who were in…