NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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.

NTSB FTW86LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Abbeville, LAThe pvt plt took off on a pleasure flt with 1 pax on board. Drg the initial climb, the eng lost power at about 300 ft AGL. The plt then turned downwind & subsequently made a forced landing in a sugar cane field adjacent to the arpt. Drg the landing, the acft…Sep 30, 1986 · N3050Z · Substantial damageNTSB DEN86LA262Accident · No injuriesLimited investigationFinal reportBeech 60 · Boulder, COAt touchdown, the plt applied brakes normally. He noticed softening of the left brake pedal and the acft turned right leaving the rwy and intersecting a taxiway at aprx a 30 degree angle. The taxiway had a six inch rise at the edge which caused the left main…Sep 30, 1986 · N3694D · Substantial damageNTSB NYC86LA244Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Beaver Falls, PAThe plt stated that the acft experienced engine problems during cruise flt and crashed about one mile northeast of Beaver Falls, PA. Post accident testing revealed that the engine was capable of developing power in accordance with the manufacturer's…Sep 29, 1986 · N5244K · DestroyedNTSB MKC86LA200Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lexington, MOThe student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft…Sep 29, 1986 · N6175B · Substantial damageNTSB MKC86FA197Accident · No injuriesField investigationFinal reportRockwell NA-265-80 · Liberal, KSThe right main landing gear downlock pin retracted just before or during touchdown. The airplane touched down 21 feet short of the runway. It traveled that 21 feet, traveled the full length of the 6999-foot runway, then traveled another one-fourth of a mile…Sep 29, 1986 · N64 · Substantial damageNTSB LAX86DVA17Accident · 1 fatalFinal reportHiller UH-12E · Visalia, CAWhile executing a 90 DEG/270 deg course reversal turn, the plt lost control of the helicopter which collided with the ground. Ground witnesses reported that the plt had completed spraying a cotton field and advised the ground flagger that the winds had…Sep 29, 1986 · N5385V · DestroyedNTSB CHI86LA234Accident · No injuriesLimited investigationFinal reportBeech BE-95-55 · Shelbyville, INWhile at cruise after sunset, the pilots discovered that the left panel lights and the overhead light were not operating. A white beam flashlight was used to observe the airspeed indicator, however, continued use of the flashlight blinded the pilots' vision…Sep 29, 1986 · N562T · Substantial damageNTSB CHI86FA233Accident · 1 fatalField investigationFinal reportBeech E18S · Chicago, ILThe acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…Sep 29, 1986 · N101VE · DestroyedNTSB 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…Sep 29, 1986 · N6443Q · DestroyedNTSB ATL86LA267Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Town Creek, ALThe pilot reported that the engine had developed a 'miss' and a precautionary landing was made near the cotton fields intended to be sprayed. Trouble-shooting and full power run-ups did not reveal any problems, therefore, the pilot elected to takeoff and…Sep 29, 1986 · N44245 · Substantial damageNTSB 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.Sep 28, 1986 · N525TP · Substantial damageNTSB MKC86LA196Accident · No injuriesLimited investigationFinal reportFloyd R.Harris Eagle 2 · Joplin, MOPilot was landing rwy 22 with winds from 190 at 12. Just before touchdown, a wind gust lifted acft to right, off side of the runway. Pilot started a go-around but discovered path of flight was toward tower and terminal bldg. Pilot aborted go-around and put…Sep 28, 1986 · N25FH · Substantial damageNTSB MIA86LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cedar Key, FLDuring taxi after landing the pilot taxied on a parallel roadway that had aircraft parked on it. The left wing of the aircraft struck two parked aircraft causing minor damage to them. The taxiing aircraft sustained substantial damage.Sep 28, 1986 · N40070 · Substantial damageNTSB LAX86DVM07Accident · No injuriesFinal reportWalter D. Burleson KR-2 · Hollister, CADuring a first proving flt for the experimental homebuilt, the pilot said the aircraft 'hit hard' during the landing, bounced and came down on the left wing and nose. According to the pilot, he had accrued less than an hour of flight time in the accident…Sep 28, 1986 · N50WB · Substantial damageNTSB 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…Sep 28, 1986 · N3578L · Substantial damageNTSB 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.Sep 28, 1986 · N2346H · DestroyedNTSB DEN86LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Englewood, COPlt and there pax were departing for a LCL flt. The plt stated after the accident that he leaned the mixture prior to takeoff. He also stated that he rotated the acft at 65 KTS, and during the climb the stall warning horn sounded. The plt attempted to remedy…Sep 28, 1986 · N3482M · Substantial damageNTSB BFO86FA049Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Elkwood, VAThe acft, which was stolen from the arpt, collided with the ground in a steep angle aprx one mile south of the arpt. Instrument meteorological conditions existed with local visibility less than one mile as reported by persons near the accident site. The plt…Sep 28, 1986 · N59942 · DestroyedNTSB MIA86LA256Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student pilot while on his third supervised solo flight in the traffic pattern veered left off the runway during a touch and go landing. The aircraft crossed the infield area and struck a parked aircraft. Post accident inspection of the aircraft braking…Sep 27, 1986 · N757EQ · Substantial damageNTSB MIA86FLT02Accident · Serious injuriesFinal reportMccoy Robert-Michael Breezy · Meridian, MSDuring flt testing of the newly purchased acft which was conducted prior to the x-country flt home, oil consumption/leakage was determined to be about 3 qts per hr. The plt stated that he planned the flt home in short hops so as to minimize oil usage & had…Sep 27, 1986 · N3269X · DestroyedNTSB LAX86FUG05Accident · Serious injuriesFinal reportSchweizer SGS-1-35C · Palm Springs, CADuring a pleasure flight, the acft was not getting the lift required to maintain alt. The plt decided to return to the arpt, however, enroute the plt realized that he would not make it back to the rwy. The plt decided to land in an east west direction on a…Sep 27, 1986 · N2673H · Substantial damageNTSB BFO86FHD04Accident · No injuriesFinal reportWhite Lightning WLAC-1 · Wilmington, DEDuring a vfr-on-top flt with no flt plan, the eng lost power from fuel starvation. The plt did not recognize that fuel was still remaining in a non-selected aux tank. Subsequently, the acft was damaged during a forced landing on the median of a highway.…Sep 27, 1986 · N100WL · Substantial damageNTSB ATL86LLT09Accident · No injuriesFinal reportBeech 35A · Nashville, TNThe student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his…Sep 27, 1986 · N676B · Substantial damageNTSB ANC86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot reported that he lost control of the airplane during the takeoff run on a dirt road. The accident occurred as the plane was going around a curve in the roadway.Sep 27, 1986 · N4371A · Substantial damageNTSB MKC86LA199Accident · No injuriesLimited investigationFinal reportBell 206A · Texarkana, ARThe pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1 , and the throttle at flight idle. When the helicopter achieved…Sep 26, 1986 · N206DW · Substantial damageNTSB MIA86LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, FLWhile established in curise flight the engine failed and all attempts to start it were to no avail. The pilot executed a forced landing to a soft field and the aircraft nosed over. Examination of the engine revealed that the #1 engine exhaust valve had failed…Sep 26, 1986 · N56522 · Substantial damageNTSB MIA86LA254Accident · No injuriesLimited investigationFinal reportCessna 172P · Live Oak, FLThe student plt stated that after he landed on a wet rwy, he was unable to stop & the acft continued off the end. Before stopping, the acft collided with a fence. According to the operator, the student had landed well beyond the normal touchdown area of the…Sep 26, 1986 · N54759 · Substantial damageNTSB LAX86LA357Accident · No injuriesLimited investigationFinal reportCessna 210N · Douglas, AZThe acft was found abandoned 25 miles west of Douglas, Arizona. A landing was made on a dirt road where the acft contacted a ditch and nosed over. The acft was reported stolen and the plt was not located. According to the local sheriff's office, traces of…Sep 26, 1986 · N5340U · Substantial damageNTSB DEN86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wright, WYAcft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled…Sep 26, 1986 · N7289K · Substantial damageNTSB DCA86IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Raleigh-Durham, NCDrg arrival, the flt crew made a visual apch to rwy 23L in calm wind conds. Flt crew statements indicated that when they were on final apch at about 100 ft AGL, the acft was on the proper glidepath for landing. However the resulting grnd contact was harder…Sep 26, 1986 · N402EA · Minor damageNTSB CHI86LA236Accident · No injuriesLimited investigationFinal reportHughes 269B · Baldwin, WIAfter picking up his passenger at williams pipeline, minneapolis, Minnesota, the plt flew eastward along interstate 90 enroute to a pipeline near wausau, Wisconsin. While flying at approximatelly 400 feet, the plt and passenger stated that the engine started…Sep 26, 1986 · N9427F · Substantial damageNTSB 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…Sep 26, 1986 · N90563 · DestroyedNTSB ATL86FA266Accident · 1 fatalField investigationFinal reportPiper TG8-J3C-65 · Apex, NCThe plt was practicing takeoffs and landings in his newly acquired J3 at a private airstrip when the eng sputtered and then quit. The plt lost control of the acft and hit a 't' hanger prior to hitting the ground. The acft caught fire and was destroyed,…Sep 26, 1986 · N27047 · DestroyedNTSB ANC86LAG06Accident · Serious injuriesFinal reportStar Duster SA-100 · Anchorage, AKShortly after departure of a Boeing 747 jet, this aircraft was cleared for takeoff. At an altitude of 200 feet the pilot lost directional control of aircraft causing the aircraft to crash next to the runway. Just prior to takeoff the pilot was issued wake…Sep 26, 1986 · N578A · DestroyedNTSB FTW86FA171Accident · 1 fatalField investigationFinal reportCessna 152 · Pearland, TXThe commercial plt was conducting a pipeline patrol operation when the accident occurred. According to witnesses, the acft circled the area twice at an alt estimated to be below 100 ft AGL. The acft then banked left and nosed down to ground impact.Sep 25, 1986 · N5542P · Substantial damageNTSB DEN86LA258Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Englewood, COPlt made two unsuccessful attempts to land on rwy 26 but discontinued each approach because of unfavorable winds. Winds were reported to be 220 deg at 20 KTS with gusts to 30 KTS. Plt then made two unsuccessful attempts to land on rwy 17L. On third attempt…Sep 25, 1986 · N66TY · Substantial damageNTSB DEN86FA259Accident · 5 fatalField investigationFinal reportCessna 340A · Crawford, COThe plt took off on a VFR flt with no flt plan filed or wx briefing. He encountered a wx squall line en route with low ceilings, fog, mixed rain and snow. While he was attempting to maneuver VFR through the wx at a low altitude above the ground, the acft…Sep 25, 1986 · N6663G · DestroyedNTSB CHI86IA231Incident · No injuriesIncident investigationFinal reportMitsubishi MU-300IA · Chicago, ILAfter landing the corporate jet was cleared to taxi to the general aviation ops to deplane pax. A food service truck crossing the taxiway failed to yield the right of way. The acft was unable to stop before the left wing struck the rear of the vehicle.Sep 25, 1986 · N19R · Minor damageNTSB CHI86FA235Accident · No injuriesField investigationFinal reportFairchild SA-266TC · Galesburg, ILAll landing gear on the aircraft prematurely retracted during takoff rotation. The captain aborted the takeoff and the aircraft slid to a stop on the runway. Subsequent gear retraction tests revealed no mechanical malfunctions within the landing gear system.…Sep 25, 1986 · N327BA · Substantial damageNTSB ATL86FA265Accident · 1 fatalField investigationFinal reportCessna A-37A · Yantley, ALThe plt had just purchased the acft which had an experimental airworthiness certificate. During a preflt wx briefing, he was advised of towering cumulus clouds along his route. After takeoff, he initiated a climb to FL 240 & leveled off aprx 10 min later.…Sep 25, 1986 · N3757Z · DestroyedNTSB ANC86LA165Accident · No injuriesLimited investigationFinal reportCessna A185F · Hanning Bay, AKThe pilot reported that during a landing, the airplane encountered a strong, gusty crosswind just after touchdown, then nosed over. The wind was reported to be from the northwest at 5 KTS with gusts and light turbulence.Sep 25, 1986 · N4611E · Substantial damageNTSB NYC86LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe flight was on approach for landing when engine power was lost due to fuel exhaustion. The aircraft crashed in a tidal marsh and nosed over slightly in the soft marsh and was substantially damaged.Sep 24, 1986 · N9422C · Substantial damageNTSB MKC86FA195Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Harvard, NEThe plt received a wx briefing for a night, business flt. At the time of the briefing a reporting station 22 NM nw of the acdt site had a broken ceiling at 2300 ft with good vis. The acdt occurred about 2 hrs after the briefing less than 2 mi from the…Sep 24, 1986 · N7744N · DestroyedNTSB MIA86LA253Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Deltona, FLThe pilot stated that while in cruise flight the engine failed and he executed a forced landing to a lake and ditched the aircraft. The aircraft was recovered and examination of the power plant and systems failed to reveal any malfunction/failure that would…Sep 24, 1986 · N24854 · Substantial damageNTSB DEN86LA253Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hurricane, UTUpon making a normal landing the aircraft groundlooped to the right, impacting with an embankment. Aircraft became airborne again and touched down in soft earth, nosed over and substantially damaged the aircraft. No injuries occurred on this VFR training…Sep 24, 1986 · N1634G · Substantial damageNTSB SEA86LYA02Accident · No injuriesFinal reportInav Moni · Riverside, ORPower plant seized in flight. Plt attempted forced landing on road, wings struck sagebrush on road shoulder. It was not determined why the engine seized in flight.Sep 23, 1986 · N39200 · Substantial damageNTSB SEA86LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Dry Bay, AKGusty winds were present at the airstrip when the plt elected to go-around during the apch. During the go-around, a downdraft was encountered. The plt lost control of the acft which rolled inverted and struck the ground. The plt reported the wind velocity…Sep 23, 1986 · N9138T · DestroyedNTSB SEA86FYE01Accident · 1 fatalFinal reportJerome Dodge B-8-M · Deer Park, WAThe gyrocopter was observed oscillating in flight prior to descending to ground impact. Investigation revealed inflight contact between the main rotor and vertical fin/pusher propeller had taken place. No mechanical failure was found which would have resulted…Sep 23, 1986 · N4621N · DestroyedNTSB MKC86LA193Accident · No injuriesLimited investigationFinal reportCessna T210M · Old Monroe, MOThe PIC had initiated his descent ot his destination arpt when he rptd experiencing eng pblms. The rough running eng finally quit and the PIC made a forced lndg to an open fld. The subsequent lndg encountered a ditch and the nose gear collapsed. Exam of the…Sep 23, 1986 · N6163N · Substantial damageNTSB 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…Sep 23, 1986 · N9043V · Substantial damage