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 SEA86LA184Accident · No injuriesLimited investigationFinal reportCessna T-210 · Battle Mountain, NVAfter a loss of power and a propeller overspeed, a forced landing was made. The pilot diverted from two chosen landing sites due to power lines crossing them. A road was chosen and during landing rollout the aircraft's wing tip clipped the top of a fence. The…Jul 25, 1986 · N4137C · Substantial damageNTSB SEA86LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R · Nampa, IDGround personnel reported the acft entered procedure turnaround in an excessive attitude, appeared to stall, rolled inverted and struck the ground. No evidence found of pre-impact mechanical failure or malfunction.Jul 25, 1986 · N5511X · DestroyedNTSB MKC86LA160Accident · No injuriesLimited investigationFinal reportHuizenga SEA Hawk · Clinton, IADuring a test flt of an experimental sea plane, the plt rptd a loss of eng pwr during a turn in the traffic pattern at Clinton airport. The plt stated he had 5 gallons of fuel onboard and had flown about 2 tenths of an hour. Inspection of the fuel system…Jul 25, 1986 · N85CK · Substantial damageNTSB MKC86LA157Accident · No injuriesLimited investigationFinal reportRandolph R.Clark KR-2 · Russell, KSThe pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a…Jul 25, 1986 · N151RC · Substantial damageNTSB LAX86FVG06Accident · No injuriesFinal reportAmateur Built Barnett J3 · Yuba City, CAThe landing accident occurred after the pilot had made high speed taxi tests along the runway with three liftoffs. After the third liftoff, the pilot said that he found himself too high. He stated that he reduced power and pushed forward on the control stick.…Jul 25, 1986 · N504P · Substantial damageNTSB FTW86LRD18Accident · No injuriesFinal reportGrumman G-164A · Bastrop, LAThe acft came to rest inverted with the engine under water after a power loss and forced landing. The plt stated that he started losing power in the turn to line up for his first aerial application run. The acft settled to ground impact in a landing attitude…Jul 25, 1986 · N6718Q · DestroyedNTSB FTW86LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Sand Springs, OKThe student pilot was hovering aircraft at 3 feet and allowed the aircraft to drift to the right. High skid gear was installed on the a/c. the right skid made contact with the ground causing dynamic rollover. The student pilot had a total of 44.2 hours flight…Jul 25, 1986 · N2779R · Substantial damageNTSB FTW86LA138Accident · No injuriesLimited investigationFinal reportHughes 269C · Batesville, TXThe pilot experienced a partial power loss at 60 feet AGL. He made a hard landing in an open field causing the rotor blades to severe the tail boom on touchdown. On examination of the aircraft fuel system debris was found in the fuel strainer, causing fuel…Jul 25, 1986 · N99803 · Substantial damageNTSB DEN86FA207Accident · Serious injuriesField investigationFinal reportCessna 140 · Taos, NMN76541 took off on rwy 04 on a high density altitude day. The acft was seen climbing with the nose high near the departure end of the rwy. The acft just cleared some electrical lines near the end of the rwy and then was observed to descend down to a height…Jul 25, 1986 · N76541 · Substantial damageNTSB CHI86LA187Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Charlevoix, MIAccording to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot…Jul 25, 1986 · N2317V · Substantial damageNTSB CHI86LA180Accident · No injuriesLimited investigationFinal reportCessna 152 · Duluth, MNThe student pilot landed the aircraft on a road and it collided with a road sign after experiencing fuel exaustion on a solo cross-country flight. The flight lasted approximately 3.2 hours and covered 289 miles. The student stated that both fuel tanks looked…Jul 25, 1986 · N5499B · Substantial damageNTSB CHI86FEM12Accident · No injuriesFinal reportRobinson R-22HP · Grayling, MIThe helicopter, during cruise flight, was flying low in an attempt to remain clear of clouds when it struck a power line and was forced to make an emergency landing. The helicopter received substantial damaged when it struck the power line and reportedly…Jul 25, 1986 · N83595 · Substantial damageNTSB ATL86LA211Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sandusky, OHThe pilot reported that he diverted and landed to reassess the weather before continuing his flight. He said the wind was from the southwest at eight KTS. Just before touchdown on runway 27, the aircraft yawed left and landed while in a crab. The airplane…Jul 25, 1986 · N9011J · Substantial damageNTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.Jul 24, 1986 · N65141 · Substantial damageNTSB SEA86LA178Accident · 1 fatalLimited investigationFinal reportAyres S-2R · Kuna, IDAcft was observed in orbit pattern near object field for night aerial application. Plt overflew object field secured acft lights and shortly thereafter collided with powerline tower. Plt had made application at this field four previous times this year. Ground…Jul 24, 1986 · N5017X · DestroyedNTSB MKC86LA161Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft.Jul 24, 1986 · N6997K · Substantial damageNTSB DEN86LA206Accident · No injuriesLimited investigationFinal reportTroutman Quickie Q2 · Rawlins, WYThe plt, flying a homebuilt quickie Q2, attempted a ldg on rwy 22 with winds of 20K, gusting to 30K out of 250 degrees. After touchdown the acft weather vaned into the wind. The acft left the rwy, flipped over and was substantially damaged.Jul 24, 1986 · N21LT · Substantial damageNTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…Jul 24, 1986 · N8379 · Substantial damageNTSB CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…Jul 24, 1986 · N734XX · Substantial damageNTSB ATL86LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7E6A · Alliance, OHDuring the second landing attempt, the pilot lost directional control and ground looped. The aircraft was substantially damaged and the pilot received minor injuries. The pilot did not report any aircraft problems. The pilot had completed a student pilot solo…Jul 24, 1986 · N982G · Substantial damageNTSB ATL86FA208Accident · 2 fatalField investigationFinal reportPiper PA-60-600 · Raleigh, NCThe plt was issued rwy 5, 7,500', for IFR departure with favoring 4 kt quartering headwind. Plt requested rwy 14, 4,498', for takeoff with a 4 kt quartering tailwind. Ground witness and control tower observed acft use nearly all of the rwy on takeoff roll.…Jul 24, 1986 · N3643Q · DestroyedNTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.Jul 23, 1986 · N1197W · Minor damageNTSB NYC86LA195Accident · No injuriesLimited investigationFinal reportBeech A24R · Tunkhannock, PADuring a landing in calm wind conditions, the acft bounced, became airborne again & touched down further down the 2000' rwy. The plt applied brakes & 'dumped' the flaps for max braking, but to no avail. The acft slid off the grass rwy & subsequently went over…Jul 23, 1986 · N1RJ · Substantial damageNTSB NYC86LA194Accident · No injuriesLimited investigationFinal reportCessna 172 M · Olcott, NYThe pilot flying a Cessna 172M with three passengers on board made a landing on a 2500 ft grass runway. This was his first landing on a grass runway. He touched down fast and became airborne, recovered, and became airborne again. His airspeed was too slow to…Jul 23, 1986 · N9263H · Substantial damageNTSB MKC86LA155Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe aerial application airplane was departing from a short strip on a hot day. The pilot said the airplane would not climb and he was forced to put it down in a flooded rice field where it nosed forward to the inverted position. The pilot stated he should…Jul 23, 1986 · N8494K · Substantial damageNTSB MIA86FA218Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Steinhatchee, FLOn 7/23/86, ARTCC lost radar & radio contact with the acft while the plt was in lvl flt at 6000 ft in an area of lvl 3 & 4 thunderstorms (tstms). Two days later, the left wing panel & the tips of the horizontal stabilators were fnd in the vicinity of where…Jul 23, 1986 · N6151J · DestroyedNTSB LAX86LA302Accident · 1 fatalLimited investigationFinal reportCessna 150D · San Diego, CAA Cessna 150D collided with the pacific ocean while spotting fish approximately 5 mi from the coast. The acft owner and operator indicated that the plt was FAA licensed and current. FAA records revealed the plt was issued a student plt certificated along with…Jul 23, 1986 · N5917T · DestroyedNTSB ATL86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt received a wx briefing prior to takeoff which forecasted widely scattered thunderstorms. On arrival at destination a thunderstorm was over the arpt. The plt executed an ILS rwy 14 apch. A preceding DC-9 made a missed approach due to tower reported…Jul 23, 1986 · N2952D · Substantial damageNTSB ATL86LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Surfside Beach, SCDuring first banner tow of the day, plt reported that the eng lost power during initial climb after the banner was hooked. The banner was released and acft descended into trees 1 mile from the pick-up point. Inspection of the eng confirmed a magneto ignition…Jul 23, 1986 · N4519U · DestroyedNTSB ATL86LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Dozier, ALThe private plt and his pax were on a night cross country flt when he ran one fuel tank dry and the eng sputtered. He switched to the other tank and the eng caught for a few seconds then quit. He let down over a heavily forested area and stalled the acft into…Jul 23, 1986 · N5041W · DestroyedNTSB NYC86LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Plymouth, MAShortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the…Jul 22, 1986 · N33985 · Substantial damageNTSB NYC86DNC06Accident · Minor injuriesFinal reportHansen Hawk 304 · Wolfeboro, NHThe experimental aircraft equipped with a buick V-8 aluminum block engine experienced power loss on approach for landing. The pilot decided that the distance and terrain was too great for a glide to the airport, and an emergency water landing in a nearby lake…Jul 22, 1986 · N13CH · Substantial damageNTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…Jul 22, 1986 · N62719 · Substantial damageNTSB MIA86MA217Accident · 1 fatalMajor investigationFinal reportDouglas DC-3 · Isla Verde, PRShortly after takeoff, the acft's climb performance bgn to deteriorate & the r eng started to overheat. Subsequently, the r eng was feathered & the crew attempted to return to the arpt. The radio transmitter bcm unintelligible, so the tower psnl cleared the…Jul 22, 1986 · N27PR · DestroyedNTSB LAX86LA300Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · San Jose, CAThe plt applied the brakes heavily during the landing roll. As the aircraft slowed to approximately 5 mph it nosed over on its back.Jul 22, 1986 · N43876 · Substantial damageNTSB LAX86FVA12Accident · 1 fatalFinal reportAyres S2R · Tranquility, CADuring an aerial application operation the aircraft was observed to have made a pass over the field, began turning to make another pass when a loud pop was heard. Just after the noise, witnesses observed the aircraft spin as the turn lights mounted on the…Jul 22, 1986 · N4023S · DestroyedNTSB FTW86LRD22Accident · No injuriesFinal reportGrumman G-164A · Franklin, LADuring aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.Jul 22, 1986 · N920X · Substantial damageNTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…Jul 22, 1986 · N8629L · Substantial damageNTSB CHI86LA177Accident · No injuriesLimited investigationFinal reportCessna 150 · Indianapolis, INThe student plt had been practicing touch and go landings for aprx 1 hour. On the accident landing, the acft veered to the left. The plt overcorrected and the acft began to travel off the right side of the rwy. While attempting a go-around the acft's wing…Jul 22, 1986 · N63069 · Substantial damageNTSB SEA86LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Nahcotta, WAWhile spraying oyster beds the pilot inadvertently flew the helicopter into the ground.Jul 21, 1986 · N7092J · DestroyedNTSB NYC86LA186Accident · Minor injuriesLimited investigationFinal reportMooney M20F · West Milford, NJDrg the landing roll, the plt believed there was insufficient braking, so he initiated a go-around. He rprtd that on climb-out, the tail of the acft impacted a 'hill.' The acft then crashed nose down & was destroyed. No preimpact part failure or malfunction…Jul 21, 1986 · N7040V · DestroyedNTSB MKC86LA152Accident · No injuriesLimited investigationFinal reportCessna 188 · Jonesboro, ARThe acft was engaged in spraying a rice field when, according to the plt, a total loss of power occurred. The acft was subsequently damaged during a forced landing in an open field. Due to the lack of fuel which he observed after the accident, the acft owner…Jul 21, 1986 · N4483Q · Substantial damageNTSB LAX86FA297Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Corona, CAThe pilot stated to fire personnel that as he approached touchdown, the sun got in his eyes and a cross wind pushed him off the right side of his private airstrip. The aircraft landed hard on the right wheel, veered off the right side of the runway,…Jul 21, 1986 · N83380 · DestroyedNTSB CHI86LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Allegan, MIGrass steip measures 1800 feet by 45 feet. Seven-foot tall corn stalks surround both sides of airstrip. The aircraft veered off center, to the left, during touchdown. Left wing contacted corn stalks, causing aircraft to cartwheel.Jul 21, 1986 · N6768F · Substantial damageNTSB ATL86LA202Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Montgomery, ALDuring flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi…Jul 21, 1986 · N9332 · Minor damageNTSB ATL86LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Topsail Beach, NCThe plt was on a x-country flt from new york state to Florida with a planned refueling stop at wilmington, NC. He reported that he became disoriented when the acft's VOR needle began wavering, about 28 miles north of wilmington. Also, he stated that he no…Jul 21, 1986 · N7059R · Substantial damageNTSB ATL86FA203Accident · Minor injuriesField investigationFinal reportBell 222UT · Chapel Hill, NCDrg an emerg med svc (EMS)/med evac flt, an uncontained pwr turbine burst of the #1 eng occurred. Debris fm the #1 eng disabled the #2 eng & severed the tail rotor drive shaft. The #2 eng fire lgt illuminated & the plt discharged the #2 eng fire extinguisher.…Jul 21, 1986 · N222DU · Substantial damageNTSB SEA86LA173Accident · No injuriesLimited investigationFinal reportCessna 180 · Thomas Creek, IDThe plt reported not being lined up properly on the airstrip when power was applied for takeoff. A witness reported seeing the tail of the acft pulling to the left causing the acft to slide down the airstrip. The left landing gear dug into the terrain,…Jul 20, 1986 · N7583K · Substantial damageNTSB SEA86FA174Accident · 1 fatalField investigationFinal reportWeiss-Haynes Stits SA6B · Big Creek, IDN3HW, a stits SA6B, was being flown from an airstrip with a density altitude of about 7,800 feet. The plt lost control of the acft during initial climb and the acft descended into the trees, struck the ground, and caught fire. The plt stated that during…Jul 20, 1986 · N3HW · DestroyedNTSB NYC86LA191Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Portland, CTWhile climbing, shortly after takeoff, the eng quit for undetermined reasons. The pilot autorotated into a sand bank where the helicopter received substantial damage.Jul 20, 1986 · N59400 · Substantial damage