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 DEN86LA247Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Chinook, MTThe acft took off on a 3900-foot dry asphalt rwy. An uncommanded left yaw developed which the plt was unable to counter. The acft struck a fence off the left side of the rwy and nosed over.Sep 4, 1986 · N6401L · Substantial damageNTSB ATL86LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Smithfield, NCThe pilot reported that during a practice landing he flared too high off the runway surface. The pilot lowered the nose, causing the nosewheel to strike the runway. The pilot lost control and the acft skidded off the left side, down an embankment and flipped…Sep 4, 1986 · N3410J · Substantial damageNTSB ATL86FMG10Accident · Serious injuriesFinal reportQuickie Q2 · Clinton, NCThe acft was destroyed during a forced lndg after a power loss during takeoff climb. The plts son witnessed the takeoff & saw the acft descend below trees north of the arpt. He said that the eng sounded out of time. During a post acc eng inspection the…Sep 4, 1986 · N206JB · DestroyedNTSB ANC86LA143Accident · No injuriesLimited investigationFinal reportCessna TU206A · Talkeetna, AKThe pilot forgot to retract the landing gear on the amphibous floats after taking off from a gravel runway. He landed on a lake with the wheels extended and the airplane turned over.Sep 4, 1986 · N942SA · Substantial damageNTSB SEA86LA237Accident · No injuriesLimited investigationFinal reportCessna 150L · Kent, WADuring an instructional flight a partial loss of power occurred due to the mixture control cable at the carburetor end becoming loose. During forced landing on a field, two railroad ties, on a dirt pile, were struck. It was dusk at the time of the accident.Sep 3, 1986 · N18079 · Substantial damageNTSB MKC86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Onawa, IAThe student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged.Sep 3, 1986 · N45986 · Substantial damageNTSB FTW86FRD24Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Port Allen, LAThe helicopter experienced partial power loss and descended to ground. It spray booms became entangled in the soy beans. The helicopter started to nose over, then rolled onto its right side and came to rest. Reason for the partial power loss is undetermined.Sep 3, 1986 · N38092 · Substantial damageNTSB CHI86FA218Accident · Minor injuriesField investigationFinal reportLearjet 24 · Ypsilanti, MICrew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down…Sep 3, 1986 · N88JF · Substantial damageNTSB LAX86FUM04Accident · 2 fatalFinal reportSteen Skybolt UNK · Chula Vista, CADuring a local pleasure flight, the aircraft was observed to make a climbing right turn to the inverted position. When observed a few seconds later, the aircraft was right side up in a shallow spin. The aircraft remained in this position until colliding with…Sep 2, 1986 · N64596 · DestroyedNTSB FTW86LA160Accident · No injuriesLimited investigationFinal reportBoeing E75 · Sweetwater, TXWhile the acft was in cruise flt, the engine suddenly went to idle power. The plt attempted to land in a clearing, but was unable to reach the intended area. During the landing, the acft collided with low mesquite trees, damaging the landing gear & wings. An…Sep 2, 1986 · N4563N · Substantial damageNTSB DEN86FA246Accident · 4 fatalField investigationFinal reportCessna 182D · Las Vegas, NMThe acft departed the albuquerque, new Mexico, coronado arpt, at 2248 MDT, September 1, 1986, en route to Las Vegas, new Mexico. When the acft failed to arrive as scheduled, a search was initiated. The flight was lost on radar at 2353 MDT, 15 nautical miles…Sep 2, 1986 · N83F · DestroyedNTSB ATL86FA239Accident · 1 fatalField investigationFinal reportCessna P206-B · Wht Sulphur Spr, WVAfter completing the revenue producing portion of this trip the company president called his company operations and told his secretary to send everyone home since it was a holiday. He was going to return the acft to its home base himself. The plt departed…Sep 2, 1986 · N4782F · DestroyedNTSB SEA86LA238Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Kent, WAA forced landing was made due to a loss of power for undetermined reasons. The power loss occurred at about 600 feet AGL. A slight left turn was made to land onto a road. The aircraft's left wing struck a tree separating it from the aircraft. The aircraft's…Sep 1, 1986 · N66BW · DestroyedNTSB NYC86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTDuring a simulated engine out on takeoff, the student plt leveled the acft instead of lowering the nose to maintain airspeed. The CFI took over control of the acft, however, the airspeed was too slow to arrest the rate of descent. The acft contacted the…Sep 1, 1986 · N2447B · Substantial damageNTSB NYC86LA226Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · So. Berwick, METhe acft experienced a loss of eng power while leveling off at 2,500 ft MSL shortly after takeoff. Remedial action was attempted, however, power was not regained. The plt initiated a 180 deg turn back toward the arpt but altitude was insufficient to reach the…Sep 1, 1986 · N26784 · Substantial damageNTSB MKC86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Vichy, MOThe pilot stated that the aircraft's ammeter indicated the electrical system was discharging while at cruise five miles west of rolla national airport, Missouri, and that he decided to continue to his destination airport. Fifteen miles east of rolla national…Sep 1, 1986 · N738CH · Substantial damageNTSB FTW86LA159Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Laporte, TXDuring a landing, the acft encountered turbulence, so the plt initiated a go-around. However, the acft would not climb, even with full power. The flt path was toward power lines & a road, so the plt elected to land in a grass area. During the landing, the…Sep 1, 1986 · N44WR · Substantial damageNTSB DEN86LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Aztec, NMThe student plt was returning to the arpt after a local flt when the accident occurred. The plt aborted the first landing attempt on rwy 04. During the second landing attempt, the acft ran off the left side of the rwy, struck a dirt bank and nosed over. The…Sep 1, 1986 · N63302 · Substantial damageNTSB CHI86FER18Accident · No injuriesFinal reportShanks/Becker Acro Sport · New Richmond, WIAccording to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide.Sep 1, 1986 · N2263V · Substantial damageNTSB CHI86FEC06Accident · 1 fatalFinal reportLawrence Baby Great Lakes · Holly, MIThe plt/owner had recently acquired the acft & had only about 3 hrs of flt time in this make & model. After taking off, he flew to the area of a friend's house & made svrl passes over a field near the house. After the last pass, the plt turned to an easterly…Sep 1, 1986 · N1BL · Substantial damageNTSB ATL86LA238Accident · No injuriesLimited investigationFinal reportJoe Almon Falcon XP · Mt Olive, ALWhile apchg to land, the registered ultralight acft encountered a downdraft which exceeded its climb performance. The acft was headed twd power lines, so the plt elected to fly under the lines. As the ultralight was crossing under the power lines, one of its…Sep 1, 1986 · N548YA · Substantial damageNTSB ATL86LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, WVThe plt flew the aircraft twice, another plt flew it once then the plt attempted another flight. He reported to app control that he thought he was out of fuel. An off airport landing was attempted. Examination of the aircraft showed less than one gallon of…Sep 1, 1986 · N66989 · Substantial damageNTSB ATL86LA236Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Coshocton, OHThe plt initiated a maximum power takeoff from a confined parking lot with 2 passengers on board. The area was boardered by obstructions & people. The plt rprtd that during lift-off, she increased power to 2900 RPM, lifted off to a 4' hover with 33' of…Sep 1, 1986 · N549H · Substantial damageNTSB ATL86FA240Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Hampton, NHThe acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft…Sep 1, 1986 · N8285C · DestroyedNTSB ANC86LA159Accident · No injuriesLimited investigationFinal reportCessna 180B · Clear, AKThe plt & passenger were on a hunting trip & had selected a clearing on a brush covered hillside for a landing. The clearing had been previously used as an airstrip. While on final apch to land at dusk, the plt lost sight of the touchdown area due to darkness…Sep 1, 1986 · N3539E · Substantial damageNTSB SEA86LA230Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Priest River, IDThe pilot was attempting to land while a thunderstorm was within two miles of the airport. Strong turbulence was present during the approach but the pilot elected to continue the approach. A strong downdraft occurred when the aircraft was about 50 feet AGL.…Aug 31, 1986 · N4156X · Substantial damageNTSB SEA86FA233Accident · 1 fatalField investigationFinal reportCessna 180 · Wallace, IDPlt received wx brief, advised VFR for proposed flt. Plt filed VFR flt plan and departed. Wreckage located 2 days later at crest of mountain pass.Aug 31, 1986 · N4703B · DestroyedNTSB NYC86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dennis Port, MAAccording to the plt, he was flying at an alt of 800 ft along the coastline during an aerial advertising flt and was switching from the right fuel tank to the left when the eng lost power. The acft was then ditched in 14 foot deep water. Post accident…Aug 31, 1986 · N3841P · Substantial damageNTSB NYC86LA224Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Butler, PAA loss of eng power was experienced shortly after takeoff at an alt of aprx 400 ft AGL. The acft contacted wires and descended uncontrolled to terrain impact during the forced landing descent. Post accident inspection of the acft revealed aprx 4 ounces of…Aug 31, 1986 · N3649J · DestroyedNTSB NYC86LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Willimantic, CTThe plt made an approach to runway 36 too fast and long. Aircraft touched down hard, the plt lost control and the aircraft bounced a few times before nosing over.Aug 31, 1986 · N5088Q · Substantial damageNTSB NYC86FA219Accident · 1 fatalField investigationFinal reportCessna 152 · Bargaintown, NJThe student pilot on a supervised solo cross country, diverted from his planned route and was observed flying low over a residential area performing maneuvers at or below tree top level. The pilot apparently lost control of the aircraft. Aircraft impacted the…Aug 31, 1986 · N6563L · DestroyedNTSB MKC86LA183Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, MOThe plt-in-command (PIC) rprtd that a normal apch & flare were made, but as the acft touched down, the left main gear collapsed. The acft then swerved off the rwy & came to rest on upsloping dirt terrain. Investigation revealed the left main landing gear…Aug 31, 1986 · N3239U · Substantial damageNTSB MKC86FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Elkhart, KSThe student plt intended to fly from his home arpt to a nearby arpt where he was receiving flt instruction. No record of a wx briefing was found. Local authorities said there were low clouds and fog in the area at the time of the accident. No one saw the acft…Aug 31, 1986 · N4233J · DestroyedNTSB LAX86LA340Accident · Serious injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Santa Paula, CAThe biplane crashed in mountainous terrain after a loss of power. The acft had been doing aerobatic maneuvers prior to the engine failure. The plt indicated that the engine quit at 7,500 ft MSL while in a descent. She relinquished the flt controls to the…Aug 31, 1986 · N10SV · DestroyedNTSB LAX86LA339Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lompoc, CAAccording to the plt's son the plt routinely overflew his home and rocked the wings. The plt indicated that he was flying at 1100 ft MSL (aprx 650 ft AGL) over his son's ranch and decided to demonstrate slow flt. He slowed the acft to 70 mph and made one…Aug 31, 1986 · N434CW · Substantial damageNTSB LAX86FVG07Accident · Minor injuriesFinal reportPhillips Steen Skybolt · Sonora, CAAn amateur built Phillips steen skybolt experienced an inflight failure of the upper wing panel fabric which led to a rapid descent and subsequent hard landing in a parking lot. Examination of the wing panel revealed no evidence of glue or bonding material…Aug 31, 1986 · N69Z · Substantial damageNTSB FTW86LA162Accident · No injuriesLimited investigationFinal reportCessna 172M · Mineola, TXThe inboard brake pads were worn to such a degree that metal to metal contact was occurring. This greatly reduced the aircraft's braking ability. After landing the pilot was unable to stop the aircraft upon the 3225 foot runway. The aircraft ran through a…Aug 31, 1986 · N61923 · Substantial damageNTSB DEN86LA245Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Salt Lake City, UTThe plt rprtd that while he was performing aerobatics at an airshow, the acft's eng momentarily lost power during inverted flt at the top of a loop. He was unable to complete the loop. Subsequently, the acft contacted the rwy in a level attitude while it was…Aug 31, 1986 · N260PS · DestroyedNTSB DEN86LA243Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Dexter, NMPlt and pax were taking off from 1900 ft x 50 ft turf rwy 30. Plt said she lifted off at 45 mph and initiated climb of 55 mph. At 250 ft AGL acft suddenly lost 100 ft. acft then went into steep right bank. Acft cleared power lines. Right wing contacted ground…Aug 31, 1986 · N8856S · DestroyedNTSB DCA86AA041Accident · 82 fatalClass 1Final reportMcDonnell Douglas DC-9-32 · Cerritos, CAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/07. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…Aug 31, 1986 · XAJED · 2 aircraft · DestroyedNTSB BFO86FIG03Accident · No injuriesFinal reportChampion 7FC · Baltimore, MDThe acft was observed to touch down hard on the sod rwy, bounce into the air, and come back down on the left main and nose wheel. The nose wheel fork broke and the nose wheel departed the acft. The acft continued to slide for aprx 24 ft after which time it…Aug 31, 1986 · N9853Y · Substantial damageNTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…Aug 30, 1986 · N8778X · DestroyedNTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.Aug 30, 1986 · N5159T · Substantial damageNTSB SEA86FA232Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · John Day, ORThe non-instrument rated pilots departed hermiston en route to burns, Oregon. Visual meteorological conditions prevailed; however, mountain tops along the route of flight were occasionally obstructed by local cloud layers. During the course of the flight the…Aug 30, 1986 · N3618R · DestroyedNTSB SEA86FA231Accident · 1 fatalField investigationFinal reportErcoupe 415C · Prosser, WAThe plt was practicing fly-bys for the next days airshow. The left wing sustained an inflight structural failure. Investigation revealed a progressive crack in the #7 rib emanating from previous damage to the leading edge of the left wing tip. This resulted…Aug 30, 1986 · N3002H · DestroyedNTSB NYC86LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Danbury, CTThe aircraft bounced on touchdown, but then settled back to the runway with the tail swinging to the left. Hard left brake was applied but the pilot could not maintain direction control and the aircraft ran off the runway into the turf striking the left wing…Aug 30, 1986 · N2292D · Substantial damageNTSB MKC86LA182Accident · No injuriesLimited investigationFinal reportCessna 172 · Hayes Center, NEWhile en route, the plt encountered deteriorating wx conditions. He stated that he found himself above an overcast with visibilities decreasing. He saw a hole in the cloud layer and descended thru it. He stated that wx conditions were bad below the cloud…Aug 30, 1986 · N75571 · Substantial damageNTSB LAX86LA338Accident · No injuriesLimited investigationFinal reportCessna 182B · La Jolla, CAThe pilot of a Cessna 182 ditched into the ocean after experiencing a loss of engine power. The weather was instrument meteorological conditions in the area. The pilot indicated the fuel gauges indicated less than 1/4 of fuel on the right tank at the time of…Aug 30, 1986 · N2710G · DestroyedNTSB LAX86LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lower Lake, CAThe airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…Aug 30, 1986 · N3651S · Substantial damageNTSB LAX86FUM03Accident · No injuriesFinal reportEipper Quicksilver MX 2 · Pine Valley, CAJust after lift-off at an altitude of aprx 10 ft AGL, the ultralight acft began to settle back to the dirt runway. The plt turned the acft to the right to avoid colliding with trees, however, the nose gear caught in the brush and the acft nosed over. There…Aug 30, 1986 · N57999 · Substantial damage