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 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB SEA86LA209Accident · No injuriesLimited investigationFinal reportLet L-13 · Issaquah, WAPlt undershot approach after encountering downdraft, collided with perimeter fence.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB SEA86LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Nahcotta, WAWhile spraying oyster beds the pilot inadvertently flew the helicopter into the ground.NTSB 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…NTSB 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…NTSB 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,…NTSB 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.NTSB 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…NTSB 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…NTSB 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.…NTSB 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,…NTSB 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…NTSB 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.