NTSB investigations, 1986
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…NTSB NYC87FA020Accident · 2 fatalField investigationFinal reportCessna 182E · Fishers Island, NYA Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally…NTSB MIA87LA010Accident · No injuriesLimited investigationFinal reportBuhl LA-1 · Belleview, FLThe plt stated that he had reached an alt of about 50 ft when the eng quit. He stated that while he was attempting to determine the cause of the problem, he stopped flying the acft & permitted a high sink rate to develop which was not arrested prior to the…NTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…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 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 FTW87LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Lago Vista, TXThe instructor (CFI) & student had planned a 30 min flt to practice touch-&-go landings. During the initial climb after the 3rd touch-&-go, the eng lost power from fuel exhaustion. The CFI stated that he measured the fuel supply with a ruler drg the preflt &…NTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.NTSB NYC87IA014Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, METhe cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which…NTSB NYC87FA015Accident · 1 fatalField investigationFinal reportCessna 185 · Greenville, METh plt stated that the acft encountered crosswinds of 20 KTS gusting to 30 KTS as the acft was coming off the step during liftoff in the open lake. The acft's right wing was forced down, the right float struck the water which resulted in the right wing…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 MIA87LA007Accident · No injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe acft nosed over during landing roll. The professional plt stated that he was certain the brakes were off prior to takeoff and that he was sure he was not 'riding' the braked on landing. The plt stated that he thought the parking brake may have come on…NTSB LAX87FA016Accident · No injuriesField investigationFinal reportBeech K35 · Bakersfield, CAThe flight was in level cruise at an altitude of 3,500 feet when the engine began to run rough. A precautionary landing was made. As the aircraft was touching down, tower personnel notified the pilot that the aircraft was on fire. The pilot evacuated 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 DEN87LA005Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fort Morgan, COThe student plt had just been endorsed for his first supervised solo flt. He had successfully completed one landing and was attempting his second landing when the accident occurred. The plt said he lost directional control, touched down, and over corrected.…NTSB CHI87FA004Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Charleston, ILN8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy…NTSB ANC87IA003Incident · No injuriesIncident investigationFinal reportBoeing 727-22C · Anchorage, AKAfter departure, the flight crew retracted the landing gear and noticed a nose gear disagreement light. Upon arriving at Anchorage, the flight crew could not lower the nose gear through normal or manual means. The airplane landed with main gear extended and…NTSB SEA87LA029Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mountain Home, IDOn short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…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 NYC87LA018Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Beverly, MAThe Beech king air E-90 was observed to break out of the clouds in a steep descent, land long and run off the departure end of the 4637 ft runway. The aircraft received substantial damage and the crew of 2 and 6 passengers received minor injuries. The…NTSB NYC87FA011Accident · 1 fatalField investigationFinal reportCessna 172 · Croton On Hud., NYStudent pilot advised by millville fss that VFR flight not recommended due to current and forecast IFR conditions throughout route of flight. Acft observed flying near base of low clouds and in and out of clouds prior to crashing in a residential area.NTSB MIA87LA006Accident · No injuriesLimited investigationFinal reportCessna U206F · Caribbean SeaThe acft was destroyed upon ditching in the ocean after sustaining eng failure several minutes after takeoff. The plt stated that he checked the fuel tanks with a calibrated dip-stick and determined there was 20 gals of fuel in the left tank and 15 gals in…NTSB NYC87DNC02Accident · No injuriesFinal reportCessna 172M · Van Buren, MEWhile climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…NTSB ATL87FA042Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pell City, ALThe aircraft departed albany Georgia for fenton Missouri without a flight plan. VFR not recommended had been given to the commercial, CFI, instrument rated pilot twice during the day. The wreckage was found two months later on the side of a mountain in…NTSB SEA87LA012Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Boulder City, NVThe plt stated that a downdraft was encountered and an undershoot occurred while on base leg. A high sink rate developed and the plt did not take corrective action soon enough. The acft struck the ground, rolled a short distance through bushes, and across a…NTSB SEA87LA009Accident · No injuriesLimited investigationFinal reportCessna 165 · Emmett, IDDirectional control was lost during takeoff roll and a groundloop occurred. This was the pilots first flight in a tail wheel aircraft.NTSB LAX87LA015Accident · No injuriesLimited investigationFinal reportCessna 182A · King City, CAWhile cruising near King City, CA, the aircraft lost power and an attempt to restart the engine was unsuccessful. The aircraft was then landed in a field, but it collided with a tree during the landing roll. An examination of the aircraft revealed that the…NTSB DEN87FA003Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-20 · Denver, COAcft had been repossessed and was being ferried from grand junction, CO, to chicago, IL, with en route stop at Denver, CO. After takeoff from Denver, landing gear would not retract. Plt made several attempts without success. He elected to return to Denver.…NTSB NYC87LA042Accident · Minor injuriesLimited investigationFinal reportRaven S60A · Montville, CTWhile landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage.NTSB NYC87LA017Accident · No injuriesLimited investigationFinal reportCessna C-152 · Port Jefferson, NYThe Cessna 152 experienced a total loss of power for unknown reason while leveling off at 1800 ft. the student pilot escaped without injury from the aircraft after it was ditched in long island sound. The aircraft was not recovered.NTSB NYC87DNC01Accident · No injuriesFinal reportEnstrom F-28A · Belmont, NHThe helicopter was in cruise flt when an engine failure occurred. The plt entered an autorotation and made a hard landing which collapsed the left front strut. The nose lowered as the tail cone rose and the main rotor made contact with the tail rotor. The…NTSB LAX87FA014Accident · 2 fatalField investigationFinal reportCessna 177RG · Happy Jack, AZThe non-instrument rated private plt was informed that MVFR weather conditions existed along his planned route of flight. The plt took off & headed into the deteriorating wx. While cruising beneath clouds the acft collided with rapidly rising terrain. The plt…NTSB ATL87LA005Accident · Serious injuriesLimited investigationFinal reportCessna 305C · Catherine, ALPlt had landed in a soybean field to participate in a dove hunt. Abt 1000 he decided to fly to another field near a restaurant for breakfast. He attempted a short field t.o. and at about 100 ft AGL, he stated that the eng quit with no warning. As a result of…NTSB ATL87FA004Accident · Serious injuriesField investigationFinal reportBeech A-23-24 · Meldrim, GAThe pilot flight planned a total time enroute of 2HRS. 45 min. The aircraft fuel endurance was four hours. The pilot used about 1 hr. 15 min. Attempting to complete an instrument procedure. Sav was VFR throughout the entire flight and prior to the accident.…NTSB SEA87LA010Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Lower Loon, IDThe plt diverted from his original destination due to weather. Upon landing at the alternate airport wiht a 7 knot tail wind, while using heavy braking on wet sod, the brakes locked. The acft veered to the right of the center placing the right main gear on…NTSB SEA87LA007Accident · No injuriesLimited investigationFinal reportHughes 500-D · Seattle, WADuring a practice autorotation a loss of power occurred. The pilot attempted engine recovery but was unable to resulting in a hard landing in which the main rotor blade flexed, severing the tail boom. The throttle linkage on the pilots side was found to have…NTSB NYC87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Poughkeepsie, NYThe Piper PA-32, landing with a 5 knot quartering tailwind from the right, ran off the left side of the runway and struck the windsock receiving substantial damage. The pilot and 2 passengers were not injured. The pilot reported that upon touchdown he felt…NTSB LAX87LA013Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Oceanside, CADuring a x-country flt, the plt stated, that just south of los angeles international arpt, the acft's right engine was running rough. At the same time pwr in the left engine began decreasing, then the prop automatically feathered. The plt attempted a re-start…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…NTSB NYC87LA010Accident · Serious injuriesLimited investigationFinal reportLockheed L188A · Boston, MADuring engine start number 4 engine was started. The signal was given to the ground crewman to disconnect the air start unit. The engineer thought he heard 'start number 3'. Engine number 4 was shifted up, it stabilized, and engine number 3 was started. After…NTSB DEN87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Price, UTThe student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft…NTSB DEN87FA002Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Richey, MTAfter making a low pass so the passenger could shoot at a coyote, the plt initiated a rgt turn to position the acft for another pass. While in the turn, the acft impacted the ground. The plt stated that the passenger (rear seat occupant) was partially out the…NTSB CHI87DEE02Accident · No injuriesFinal reportPiper PA-23-250 · Crestwood, ILThe aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft.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 ATL87FA003Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Gahanna, OHThe helicopter had been conducting a series of demo flts during the day & was on the last scheduled flt of the day. To drop off the local plt who had requested the demo flts, when the loss of power occurred. They had made a take off over the taxiway & turned…NTSB SEA87LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Petersburg, AKThe plt reported that while landing on a river the acft skidded on river silt. He stated he could not stop the acft which traveled to the FAR end of the river into 8 inch deep water where it nosed over.NTSB DEN87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Grafton, NDPlt made forced landing on dirt road shortly after takeoff when the eng reportedly lost power. Plt extended landing gear but acft touched down before gear locked and left main landing gear collapsed. Left wing also struck a mailbox during rollout. Post…NTSB CHI87LA003Accident · No injuriesLimited investigationFinal reportCessna 150L · East Jordan, MIThe pilot stated that after extending 10 degrees of flaps and applying carburetor heat on final apch, he reduced throttle. Upon throttle reduction, the engine quit. Inspection of the engine revealed a broken mixture control cable housing. The engine operated…NTSB CHI87LA002Accident · No injuriesLimited investigationFinal reportLet L-13 · White Bear Lake, MNThe plt reported that he entered the traffic pattern for rwy 30 at aprx 900 ft and completed a right turn to base. The plt stated that while on base, he realized the aircraft was too high and deployed the spoilers halfway. As he turned to final, he stated…NTSB BFO87FA003Accident · Minor injuriesField investigationFinal reportBellanca 8GCBC · Keysville, VAThe pilot made a tailwheel high touchdown on the 1850 foot grass strip. Shortly after touchdown, the nose dropped and, although the pilot said he moved the control stick fully aft, the propeller struck the ground, and the aircraft flipped inverted.