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.
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
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 SEA86LA158Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Jordan Valley, ORWitnesses observed at acft make a 2-5 foot pass over water going north, a 180 degree turn and a 2 foot AGL run to south. The acfts left main landing gear touched water bouncing the right wing on water. Acft pitched up, rolled inverted and crashed on south…NTSB NYC86LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wellsboro, PADrg arrival, the plt was advised the winds were 5 to 7 KTS, favoring rwy 28. However, when he crossed over the arpt for a downwind entry, he noted that the wind sock had changed to indicate an upwind for rwy 10, so he elected to land on that rwy. On final…NTSB LAX86LA274Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ukiah, CAThe Piper PA-18-150 encountered turbulent wind conditions and dragged the left wing during a takeoff ground run from rwy 33. The plt reported that during the takeoff ground run, the right wing lifted causing the left wing to drag on the rwy. The aircraft then…NTSB LAX86FVA10Accident · Serious injuriesFinal reportBell UH-1B · Le Grand, CAThe helicopter experienced an engine failure shortly after lift-off prior to a spray run on a nearby field. The engine decelerated to zero and the acft collided with the ground. Examination of the engine revealed the turbine rotor was destroyed and evidence…NTSB FTW86FRD17Accident · Minor injuriesFinal reportGrumman G-164 · Rayville, LAThe acft crashed during takeoff after losing pwr during a turn at 150 ft AGL. The plt said that the acft stalled and hit in a cotton field about 1/4 mile from the arpt. The plt also said oil hit the windshield about 3 seconds before pwr failure. The acft was…NTSB BFO86FID09Accident · No injuriesFinal reportPiper PA-28R-200 · Montpelier Sta., VAThe acft collided with 2 fences during an off arpt forced landing after a pwr loss. Post acc eng inspection showed internal failure of the eng. #2 connecting rod bolt failed in fatigue through 40 percent of the diameter. The remainder failed in tension. The…NTSB ATL86LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Robbinsville, NCThe acft was flown from troy, mi to knoxville, TN and landed, but it was not refueled. The plt proceeded on to the assume destination, but the acft did not arrive. According to the plt's original flt plan (from troy to andrews, NC), the estimated time en…NTSB ANC86LA094Accident · No injuriesLimited investigationFinal reportCessna 180H · Eureka, AKThe airplane approached the short and high elevation airstrip too high and fast. It bounced on the rough surface and ran off the end before nosing over.NTSB NYC86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYDuring roll out after landing, the acft encountered a strong gust of wind & subsequently went off the side of the rwy. Before stopping, the acft went over an embankment & the nose gear collapsed.NTSB NYC86LA165Accident · No injuriesLimited investigationFinal reportCessna 150E · Hammondsport, NYWhile on final apch over high terrain east of the arpt, the plt inadvertently pulled the mixture control when he intended to apply carburetor heat. The eng stopped running & the plt was unable to obtain a restart before the acft collided with trees. The acft…NTSB NYC86LA164Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Marstons Mills, MAThe eng lost power as the acft was climbing thru about 60' AGL during takeoff. The plt rprtd that he was forced to turn back toward the arpt since there was a wooded area & a residential area ahead. Subsequently, the acft was extensively damaged when it crash…NTSB NYC86LA160Accident · No injuriesLimited investigationFinal reportHiller 12C · Lehighton, PAThe pilot of the Hiller 12C reported an overheated engine followed by an engine failure. During the forced landing the main rotor flexed and cut the tail boom off the the aircraft. The aircraft was examined. 10 oz. Of a liquid was found in the fuel system. 7…NTSB MIA86LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Titusville, FLThe plt stated that the wind changed from a crosswind to a tailwind on final apch. He continued the apch, landed, & during the landing roll, realized 'the brakes were not working properly,' & that he would be unable to stop the acft on the rwy. He then…NTSB MIA86LA232Accident · No injuriesLimited investigationFinal reportMooney M20C · Ocala, FLThe plt stated that he put the gear handle down, continued his apch and landed without realizing the gear was still up. Post crash examination of the landing gear retract system revealed that the fuse for the landing gear motor had blown during the extension…NTSB MIA86LA196Accident · No injuriesLimited investigationFinal reportPiper J5C · Daytona Beach, FLThe plt stated that he overflew the arpt to observe the wind direction as indicated by the wind sock. Upon landing on rwy 23, he lost control of the acft due to a left quartering tailwind. The acft then went through a chain link fence & came to rest in a…NTSB MIA86LA195Accident · No injuriesLimited investigationFinal reportBeech C23 · Pompano Beach, FLThe plt stated that on approach he noted that he had no left rudder control and during landing roll, the aircraft veered off the left side of the runway collapsing the nose gear. Post crash examination of the nose gear revealed that the nose wheel steering…NTSB LAX86LA301Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pleasant Grove, CAThe pilot said the aircraft had new brakes installed prior to the flight. After touchdown at the conclusion of a local flight, the pilot said he 'applied too much pressure to the pedals and could not release the pressure in time to prevent the aircraft from…NTSB LAX86LA272Accident · No injuriesLimited investigationFinal reportCessna 150 · Hesperia, CAThe student pilot and passenger departed carble airport (ccb), upland, CA, on a visual flight rules personal flight to bullhead city, Arizona. The student plt reported while approaching Hesperia, CA at about 7,500 ft m.s.l. the engine began to experience an…NTSB LAX86LA271Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Upland, CAThe plt stated that he was practicing single engine procedures and he forgot to lower the landing gear. Another plt alerted him on the radio and he attempted to lower the gear but landed with the gear only partially extended. The plt stated that he chose to…NTSB DEN86FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Townsend, MTOn 6/26/86, the plt & his wife had flown from helena, MT. To powell, WY, to visit family & relatives. On the day of the acdnt, he had consumed alcoholic beverages. Despite pleas fm his wife not to return to helena that evening, he elected to fly back. While…NTSB CHI86LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Int'L Falls, MNAcft struck power lines on approach to private airstrip. The plt stated that an air pocket pulled the plane down. Weather at international Falls, six miles from the accident site, reported winds at 7 KTS with no gusts. The plts flt time was not reported.NTSB CHI86LA161Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, MNThe plt was attempting to takeoff from a field when the accident occurred. During takeoff, the acft failed to clear trees at the departure end of the field. The acft contacted the trees and descended to the terrain. The plt had diverted to this field during a…NTSB SEA86LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Durkee, ORWhile crossing a mountain ridge at low altitude, the aircraft encountered downdrafts. The pilot was forced to land as he was unable to arrest the descent rate. The landing was accomplished onto very rough terrain.NTSB NYC86LA168Accident · No injuriesLimited investigationFinal reportBell 206B III · Moultonboro, NHThe Bell jet ranger had just dropped off an external load and was returning downhill when the pilot reported hearing a growling noise in the aft portion of the aircraft. He autorotated to landing as control was lost. When the wreckage was examined after it…NTSB NYC86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, MAThe plt rprtd he encountered a gust of wind & a wind shift during the flare to land. Subsequently, he lost directional control & the acft went off the side of the rwy, collided with a man-made pyramid of stone & rotated upside down. The plt rprtd the winds…NTSB NYC86LA161Accident · Minor injuriesLimited investigationFinal reportAlon A2 · South Sutton, NHThe plt rprtd that during a landing, the flight encountered a severe downdraft and impacted the ground hard, collapsing the nose gear and incurring other damage to the aircraft.NTSB NYC86FHA03Accident · No injuriesFinal reportThomas Pitts S-1T · Avoca, PADuring a ribbon cutting ceremony at the wilkes-barre/scranton air show, the acft had a temporary engine failure while inverted 20 feet above the terrain. The acft impacted on the rwy, slid 500 feet inverted, turned over and stopped upright.NTSB MKC86FA139Accident · 4 fatalField investigationFinal reportCessna 182J · Hartford, ARWhen the acft did not arrive at its destn, a search was initiated. The wreckage was located 4 days later where the acft crashed in mountainous terrain. An investigation revealed there was severe thunderstorm activity in the area at the time of the accident.…NTSB MIA86LA194Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Opa Locka, FLThe instructor plt stated that on takeoff just as he turned his crosswind leg, the engine lost power and he turned back to the airport, landed short of the runway and the aircraft flipped over and came to rest inverted. Post crash examination of the engine…NTSB MIA86LA193Accident · Minor injuriesLimited investigationFinal reportCulver V · Deland, FLThe plt stated that on his landing apch he reduced the power too soon, the acft stalled and collided with trees and crashed 150 feet short of the runway.NTSB LAX86LA273Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Warner Springs, CAThe plt became aware of the loss of the elevator control as the glider began it's initial climb during an aerial tow. He released from the tow aircraft and made an off arpt forced landing in tall grass. The glider's right wing became entangled in the grass…NTSB DEN86LA180Accident · No injuriesLimited investigationFinal reportMathew M. Kerr Starduster TOO · Roundup, MTDuring the telephone interview, the plt stated the acft landed hard, collapsing the right main gear & broke the right wing spar.NTSB DEN86LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lupton, COThe plt took off on a local flt with approximately 1/4 tank of fuel (6 gal). He flew the acft until the engine quit from fuel exhaustion at 1.2 hours flt time. The acft impacted in an open feild, nosed over, and came to rest in an inverted position. The plt…NTSB DEN86LA178Accident · No injuriesLimited investigationFinal reportCessna 182F · Joliet, MTAccording to the plt, horses ran in front of him during landing and he was forced to make evasive maneuvers. During the evasive maneuvers, the acft ground looped and was substantially damaged.NTSB DEN86LA177Accident · No injuriesLimited investigationFinal reportCessna 182P · Sheridan, WYA loss of directional control occurred during landing roll and the acft departed the left side of the grass/dirt landing strip. The acft then traveled down a slight embankment and collided with a wire fence and fence posts.NTSB CHI86LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Terre Haute, INThe plt stated his left brake failed during landing roll on the 3,200 ft long rwy. The landing was made with a 20 deg right quartering 10 knot tailwind. To prevent running off the departure end of the rwy in to a 50 ft dropoff, the plt ground looped the acft…NTSB ANC86LA093Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Tolsona Lake, AKThe private pilot attempted to turn downwind when he encountered downdraft conditions during a floatplane takeoff. The airplane stalled and crashed into the lake he departed from.NTSB ANC86FA092Accident · No injuriesField investigationFinal reportCessna 180H · Anchorage, AKThe pilot and the owner of the airplane serviced the brakes prior to takeoff. When they returned from a local flight, the right brake was inoperative during the landing roll-out. The airplane groundlooped to the left, then went off the left edge of the…NTSB SEA86LA154Accident · 1 fatalLimited investigationFinal reportCessna A188B · Boise, IDThe purpose of the flight was to spray thirty gallons of rinse water to clear the spray tanks of chemical. While maneuvering the acft struck power lines and then struck the ground. The acft slid for about 20 feet and then nosed over inverted.NTSB NYC86LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot was cleared for closed traffic touch and go landings; however, during his acceleration for takeoff, he lost directional control and the aircraft veered left off the runway. Not being able to regain control, the takeoff was aborted. The…NTSB MKC86LA146Accident · No injuriesLimited investigationFinal reportCessna T303 · Lake Ozark, MOThe plt stated that the flt was uneventful until after landing when somebody instructed him, over the common traffic advisory frequency on his VHF radio, to park the acft at a new parking area, and he complied. This parking area was congested with extra acft…NTSB MIA86LA192Accident · No injuriesLimited investigationFinal reportCessna 172N · Pensacola, FLThe plt stated that he landed long on the wet grass rwy. As he attempted to stop, the acft slid off the side of the rnwyinto a ditch, severing the nose gear & collapsing the left main landing gear.NTSB LAX86LA267Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Mammoth, CAThe plt lost control of the acft & it collided with terrain during a landing to rwy 27. The plt indicated that the winds were from 190 deg at 15 gusting 20 KTS. Reportedly, he landed on rwy 27 with an indicated airspeed of 80 mph. During the landing roll, a…NTSB FTW86LRG28Accident · No injuriesFinal reportCessna A188B · Temple, TXDuring the initial climb after takeoff the pilot experienced a loss of power and attempted to return to the private airport from which he had departed. Unable to reach the runway the aircraft landed in rough terrain colliding with a mound of dirt. Both main…NTSB FTW86LRG27Accident · No injuriesFinal reportAyres S2R-600 · Tivoli, TXOn June 27,1987 at approximately 1700 CDT, an Ayres S2R-600 impacted the terrain approximately 5 miles east of Tivoli, TX while conducting agriculture spraying operations. The right wing of the aircraft contacted the ground causing the aircraft to cartwheel…NTSB FTW86LPJ10Accident · No injuriesFinal reportGrumman G-164 · Hooker, OKThe pilot stated that the aircraft flipped over when he landed in soft dirt on his recently extended private landing strip.NTSB DEN86LA176Accident · No injuriesLimited investigationFinal reportCessna T188 · Kimball, SDAccording to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.NTSB DEN86FA175Accident · 3 fatalField investigationFinal reportMartin 404 · Buffalo, WYN40443 was contracted by the Wyoming dept of ag to spray grasshoppers. Investigation revealed the plt held a pvt certificate with asmel ratings. His medical certificate was denied because he failed to provide information concerning high blood pressure and…NTSB CHI86LA237Accident · No injuriesLimited investigationFinal reportPitts S2A · Peru, ILPilot elected to land on runway 18 because the windsock was indicating wind to be fromthe south. Upon touchdown in the first third of the runway the aircraft skipped slightly. Pilot chose to try to stop rather than attempt a go-around and applied heavy…NTSB ATL86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Columbus, GAThe flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…