NTSB investigations, 1986
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 DEN87LA009Accident · No injuriesLimited investigationFinal reportCessna TU206G · Greybull, WYThe plt departed aurora, co at 1000 en route to great falls, mt at 8000 ft MSL. At 1237 the plt advised worland fss that the eng had lost power and he was going down. The plt said that on final apch he had to pull up to avoid power lines. The acft stalled and…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 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 ANC87LA010Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Unalakleet, AKThe private pilot with 14 hours experience in this airplane did not recognize that the carburetor heat control was not functioning properly. He did not recall draining the airplane's fuel sumps after refueling from exposed fuel tanks prior to takeoff.…NTSB LAX87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Madera, CADuring a dual instructional flight, the pilots were practicing a simulated engine out procedure. Engine power had been reduced to 15' of manifold pressure. When an attempt was made to add power at an altitude of about 500 ft, the engine quit. The instructor…NTSB DEN87FA008Accident · 1 fatalField investigationFinal reportMooney M20B · Buffalo, WYAt aprx 1720 MDT, tower psnl at the dep arpt received a phone call from the plt. He said he wished to depart with an inop 2-WAY radio. He was advised that IMC prevailed & that a radio would be required to depart with an IFR or special VFR clnc. At 1907 (after…NTSB CHI87FA010Accident · Serious injuriesField investigationFinal reportBeech 58 · Chicago, ILThe pilot departed home base with an undetermined amount of available fuel, after being advised by the lineman/refueler of the uncertainty of the amount of fuel onboard. The pilot assumed the aircraft had been refueled the previous evening and departed on…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 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 SEA87LA013Accident · No injuriesLimited investigationFinal reportCessna 180K · Burlington, WAPlt was taking off in fog from wet grass strip. Acft swerved left, plt unable to arrest with opposite rudder and brake, collided with fence. Abort not attempted.NTSB NYC87MA024Accident · 1 fatalMajor investigationFinal reportEnstrom F-28F · Manhattan, NYThe aircraft was contracted by nbc to make daily highway traffic observations in the new york city area. The pilot and passenger, an nbc radio traffic reporter, were flying in a northerly direction along Manhattan's west side at an altitude of about 75 feet.…NTSB MIA87LA012Accident · No injuriesLimited investigationFinal reportAyres SR-2-600 · Glen Allan, MSShortly after takeoff the pilot stated the engine failed and he executed a forced landing. Post accident examination revealed no fuel in the aircraft fuel system.NTSB LAX87LA024Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Gila Bend, AZThe acft veered off the rwy during takeoff ground run and nosed over. The plt inidcated that during the takeoff his seat slid rearward and he was unable to reach the throttle or the rudder pedals. The acft departed the rwy to the left into vegetated desert…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 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 CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…NTSB CHI87LA006Accident · No injuriesLimited investigationFinal reportCessna 120 · Decatur, ILThe pilot stated that he was practicing crosswind landings on runway 24 when the airplane bounced twice. According to the pilot, he immediately added power and then lost directional control of the airplane and ground looped to the left. Following the ground…NTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…NTSB ANC87LA008Accident · No injuriesLimited investigationFinal reportHughes 300-269B · Fairbanks, AKThe helicopter exhausted its fuel supply during climbout. During the ensuing autorotation landing, the rotor speed was allosed to decay and the helcopter spun at touchdown. It rolled over and failed the rotor blades.NTSB NYC87LA044Accident · No injuriesLimited investigationFinal reportCentrair 101A · Julian, PAThe pilot had decided to land following a 41 minute flt. The plt reported his airspeed was too fast during the landing apch and he over compensated which resulted in too slow of an airspeed. The glider touched down hard, became airborne and landed hard a…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 CHI87LA007Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lake Village, INThe plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…NTSB ATL87FKG01Accident · 1 fatalFinal reportJere L. Rosser Rand KR-2 · Kennesaw, GADuring initial climb the aircraft was observed at a high angle of attack at low altitude before descending in a stall/spin collision with the ground. Witnesses at the aprt reported that the engine sounded rough during the taxi and takeoff roll. The plt had…NTSB ANC87LA007Accident · 1 fatalLimited investigationFinal reportInterstate S-1B1 · Eureka Creek, AKThe pilot lost control of the aircraft on landing & it collided with a large metal sluice box that was located beside the runway. At the time of the accident, the wind was from the northeast & was gusty. The dirt ruway was frozen, rough &rutted.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 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 LAX87LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Big Bear City, CAThe acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of…NTSB CHI87DEM02Accident · No injuriesFinal reportLeblanc Dragonfly · Lansing, MIThe home built acft was on a test flt & was being flown by a plt with only about 2.5 hrs of flt time in this make & model. During the landing, the acft touched down hard & began to porpoise. The canard & wooden prop were damaged during the occurrence.NTSB ATL87FA009Accident · Minor injuriesField investigationFinal reportBell 206B III · Nashville, TNThe plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…NTSB ATL87FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Nashville, TNThe flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach…NTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…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 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 LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…NTSB FTW87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Jacksboro, TXThe pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts.NTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. 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 ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…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 ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.NTSB NYC87FA022Accident · 1 fatalField investigationFinal reportGulfstream American 112 · Beekman, NYThe acft departed dutchess county airport, poughkeepsie, NY, and had an engine failure due to inadequate lubrication. The oil filter was found disconnected from the engine. At duthess county airport parking area, fresh oil was found on the grass parking area…NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…NTSB MKC87LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macon, MOThe pilot stated that he encountered more severe crosswinds than planned upon landing and that he tried remedial action, including a rejected landing, but it came too late. The wind was blowing from the right on the landing roll as he shut down the engine and…NTSB MIA87IA011Incident · No injuriesIncident investigationFinal reportCessna 310R · West Palm Beach, FLWhile on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right…NTSB LAX87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Pacoima, CAThe plt refueled the acft, but was unable to restart the eng by using the battery. He hand propped the eng which started immediately. The acft began to move unattended & the plt clung to the left wing strut, but relinquished his grip after the acft moved aprx…NTSB LAX87LA019Accident · Serious injuriesLimited investigationFinal reportLake LA4-180 · Folsom, CADuring a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses…NTSB ANC87LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · King Salmon, AKThe pilot was cleared to taxi his airplane into position and to hold behind a cherokee six airplane. After the cherokee six departed, he was cleared for takeoff. Immediately after lift off at 10 to 15 feet above the runway, the pilot stated the airplane went…NTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…NTSB MKC87IA007Incident · No injuriesIncident investigationFinal reportSwearingen SA-226-TC · Springfield, MODuring the approach, the right main landing gear would not extend by normal or emergency means. Airplane was intentionally landed with all landing gear retracted. Inspection indicated gear doors pulled closed farther than normal due to right main landing gear…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…