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 FTW87LA205Accident · No injuriesLimited investigationFinal reportBeech RC-45J · Houston, TXThe pilot was practicing landings, almost to a full stop, when the accident occurred. He had asked a commercial pilot to accompany him on this flight. The plt stated that on the fourth landing the left main gear went slightly off the left edge of the runway…Aug 20, 1987 · N11249 · Substantial damageNTSB FTW87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, TXThe engine quit during cruise flight at 5500 feet MSL but restarted when the pilot switched fuel tanks. He then headed for the nearest airport which was at Bridgeport, TX. While on final approach for landing the engine stopped again and would not restart. A…Aug 20, 1987 · N6895J · Substantial damageNTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.Aug 20, 1987 · N4700M · Substantial damageNTSB ANC87LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear, AKThe pilot stated that he elected to go-around and during the go-around he lost control of the aircraft causing the plane to stall.Aug 20, 1987 · N5530T · Substantial damageNTSB SEA87LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Boulder City, NVThe pilot was attempting to land the aircraft with a 15 knot tailwind gusting to 20 knots. The density altitude was over 6,000 feet and the runway was an uphill runway with rising terrain ahead. The pilot stated that he decided to go-around but that shortly…Aug 19, 1987 · N5549B · Substantial damageNTSB LAX87LA308Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Ehrenberg, AZWhile on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making…Aug 19, 1987 · N5753H · Substantial damageNTSB FTW87FA203Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F-1 · Ship Shoal 214cAcft experienced a tail rotor drive shaft failure during t/o from an offshore platform. Acft spun left and completed 6 to 7 revolutions prior to water contact as the single plt could not reach the throttles to reduce pwr to idle. Acft landed hard and the rt…Aug 19, 1987 · N359E · Substantial damageNTSB FTW87DRD13Accident · No injuriesFinal reportAir Tractor AT-400A · Monroe, LAThe ag pilot pulled up from a swath run while spraying chemicals on cotton and the pt 6A-20A engine in his aircraft exploded. A post accident teardown of the engine revealed the blades of a compressor disk had failed causing a total loss of power. Reason for…Aug 19, 1987 · N3159C · Substantial damageNTSB CHI87LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIWhile the plt was using short field techniques for takeoff, the acft lifted off into ground effect. At about that time, the plt thought there was a partial power loss. He stated, 'after perceiving a partial power loss which was accompanied with a loss in…Aug 19, 1987 · N32387 · Substantial damageNTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…Aug 19, 1987 · N7559T · DestroyedNTSB ATL87FA234Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Aurora, NCThe pilot ditched the aircraft after running out of fuel while en route to bayboro,NC. The flight had departed earlier in the day and had flown to melfa,VA. The pilot did not fuel the aircraft before starting the flight and over flew several possible…Aug 19, 1987 · N5561U · DestroyedNTSB SEA87LA169Accident · Serious injuriesLimited investigationFinal reportMooney M20-K · Las Vegas, NVThe pilot was cleared to land on runway 19R but was attempting to land on runway 19L. The tower noted the mistake and asked the aircraft to side step to runway 19R. During the pilot's attempt to land on runway 19R, the tower told the pilot to go-around.…Aug 18, 1987 · N233BG · Substantial damageNTSB SEA87LA168Accident · No injuriesLimited investigationFinal reportBeech G35 · Kent, WAShortly after rotation a propeller blade separated from the aircraft with the remaining propeller hub assembly and the other blade also falling from the aircraft. The pilot was able to land the aircraft straight ahead on the remaining runway. The hub was…Aug 18, 1987 · N4235D · Substantial damageNTSB NYC87FA272Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Martha Vineyard, MAThe plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a…Aug 18, 1987 · N5060K · DestroyedNTSB MKC87FA163Accident · Serious injuriesField investigationFinal reportBeech 35 · Excelsior Spgs, MOAccording to witnesses, the pilot declared an emergency over the radio stating that the eng was losing power and that she was attempting an emerg lndg at Excelsior springs arpt. The pilot stated that she initiated a go-around, after the rwy was assured, due…Aug 18, 1987 · N3204V · DestroyedNTSB FTW87LA204Accident · No injuriesLimited investigationFinal reportBeech F50 · Terlingua, TXThe owner, who occupied the right front seat, stated that he retracted the landing gear during the landing roll inadvertently instead of the flaps. The PIC never responded in writing concerning the actions he took during the accident.Aug 18, 1987 · N5629D · Substantial damageNTSB FTW87DRD11Accident · 1 fatalFinal reportGrumman G-164A · Bastrop, LAThree flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the…Aug 18, 1987 · N9685 · Minor damageNTSB CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…Aug 18, 1987 · N1354D · Substantial damageNTSB ATL87LA237Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksonville, ALThe plt departed Jacksonville in VFR conds without obtaining a wx briefing. While en route, she observed thunderstorm activity & elected to return to Jacksonville. By the time she returned, the wx had deteriorated & the wind had shifted to the south. The wind…Aug 18, 1987 · N733DQ · Substantial damageNTSB ANC87LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Homer, AKThe pilot stated after the landing rollout he lost directional control of the aircraft causing a groundloop on the runway. This landing was the first full stall landing of the flight.Aug 18, 1987 · N3580M · Substantial damageNTSB SEA87LA167Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Juneau, AKDue to a low battery charge, the plt elected to hand prop the acft to start the eng. He rprtd the eng became flooded, so he shut off the mags & opened the throttle, to clear the eng while hand turning the prop. He then turned on the master sw & mags, but…Aug 17, 1987 · N2507K · Substantial damageNTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…Aug 17, 1987 · N9747B · DestroyedNTSB DEN87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Steamboat Sprin, CON7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He…Aug 17, 1987 · N7494J · DestroyedNTSB DEN87FA219Accident · 3 fatalField investigationFinal reportCessna 182P · Milner, COThe plt was on a flt fm green bay, WI to steamboat spgs (sbs), CO, with stops at sioux city & cheyenne (cys). At 2245, he contacted denver fss, stated he was on final apch to sbs & said the rwy lgts had gone out. He then asked for the freqfor 'putting them…Aug 17, 1987 · N1359S · DestroyedNTSB DCA87MA046Accident · 156 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-82 · Romulus, MIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/05. 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…Aug 17, 1987 · N312RC · DestroyedNTSB BFO87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Danville, VAThe accident occurred during an instructional x-country flt from chesapeake, VA. To south boston, VA. To ashland, VA. With a return to chesapeake. Prior to departure, the student plt performed the acft preflt and informed the CFI that the acft was topped off.…Aug 17, 1987 · N11872 · Substantial damageNTSB BFO87FA056Accident · 2 fatalField investigationFinal reportCessna 190 · Hedgesville, WVThere were no eyewitnesses to the acdnt, but 3 persons heard the eng rev up to a high power setting before the plane crashed. Subsequently, it crashed in a wooded area north of the plt's 2600' pvt strip. There was a wooded hill north of the strip. The plt's…Aug 17, 1987 · N9827A · DestroyedNTSB SEA87FA165Accident · 1 fatalField investigationFinal reportFleet 16B · Bellevue, WAThe pilot executed an emergency landing on a golf course after a power loss which he attributed to carburetor ice. Subsequent to the landing the aircraft was fueled with 10 gallons of automotive gasoline. The fuel was checked for water at the strainer drain…Aug 16, 1987 · N41871 · DestroyedNTSB NYC87LA235Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Lakewood, NJWhile returning to the arpt aft flying for abt 30 mins, the eng lost pwr. The plt attempted to restart the eng by checking the fuel tank gauges, carb heat, mags, etc but with no success. During the forced lndg, the acft was stalled into trees. No fuel was…Aug 16, 1987 · N41994 · DestroyedNTSB MKC87LA162Accident · No injuriesLimited investigationFinal reportMaxfield Pitts S-1S · Meade, KSShortly after takeoff, while depg to the se, the eng seized. All of the surrounding terrain consisted of plowed fields, so the plt tried to glide back to the arpt; however, he had insufficient speed & alt to get aligned with the rwy. Drg the lndg, the acft…Aug 16, 1987 · N900K · Substantial damageNTSB LAX87LA301Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAAfter the aircraft was flown for 3 hours and 30 minutes the engine failed. The aircraft entered a forced landing approach to an open field. The aircraft landed hard and nosed over onto its back. Ground witnesses who were on scene shortly after the accident…Aug 16, 1987 · N65451 · Substantial damageNTSB LAX87FA306Accident · No injuriesField investigationFinal reportCessna 421C · Clifton, AZThe flt deptd ry 25 at greenlee cty arpt, Clifton, AZ on a VFR flt to phoenix, AZ. The plt & gnd witnesses rptd that shortly after lift-off, grayish/white smoke emanated from the left engine. The plt was unable to feather the prop, circled the arpt abt 2…Aug 16, 1987 · N26596 · DestroyedNTSB FTW87LA201Accident · No injuriesLimited investigationFinal reportCessna 185 · San Marcos, TXThe pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence.Aug 16, 1987 · N9930X · Substantial damageNTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.Aug 16, 1987 · N5437Y · Substantial damageNTSB FTW87LA199Accident · No injuriesLimited investigationFinal reportLet L-13 · Littlefield, TXThe pilot activated the flaps while on final approach instead of the spoilers. When the glider did not descend as he expected, a left 360 degree turn was initiated to lose altitude. The pilot stated that he then unintentionally stalled the aircraft while in…Aug 16, 1987 · N9997Q · Substantial damageNTSB DEN87FA220Accident · Serious injuriesField investigationFinal reportFairchild PT-23 · Englewood, COThe plt & pax were flying to cheyenne, WY to put N64038 on static display. The plt stated the eng lost pwr drg climb- out at aprx 300' AGL. He was unable to restore pwr & maneuvered for an off arpt landing. A witness stated that after takeoff, N64038 lvld off…Aug 16, 1987 · N64038 · DestroyedNTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…Aug 16, 1987 · N1418Y · DestroyedNTSB DCA87RA047Incident · No injuriesForeign investigationBoeing B 767 200ER · Frankfurt, GermanyAug 16, 1987 · N332AANTSB BFO87LA059Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Grafton, WVAccording to the plt during the water landing the acft encountered the wake of a boat that had crossed the path of the acft. As a result the acft bounced about 20 ft high. The plt applied full power to recover; however, the acft impacted the water. He started…Aug 16, 1987 · N59FC · DestroyedNTSB ANC87LA124Accident · No injuriesLimited investigationFinal reportPiper PA-14 · King Salmon, AKAfter climbing 150 feet, the airplane passed a hill and at that point the airspeed deteriorated and the pilot stalled and lost directional control of the airplane.Aug 16, 1987 · N5118H · Substantial damageNTSB ANC87LA123Accident · Minor injuriesLimited investigationFinal reportChampion 7HC · Seward, AKThe pilot lost directional control on landing and veered to the right side of the runway. The aircraft then struck a small mound and nosed over on its back. The pilot stated that he landed with a 7 to 10 knot tailwind.Aug 16, 1987 · N8976R · Substantial damageNTSB NYC87LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Vergennes, VTDuring a landing attempt at basin harbor airport, the pilot came in high and fast. He did not correct and failed to go around. He overran the runway and crashed into a ditch causing substantial damage to the aircraft. The plt did not file an acc report.Aug 15, 1987 · N8288A · Substantial damageNTSB NYC87LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-34 · Dansville, NYThe plt stated that as he was adjusting his seat belt with the canopy open, the glider began being pulled by the tow pilots acft. He maneuvered the wing tip clear of some parked acft, grabbed the canopy hatch, and held it shut during the tkof. The cockpit…Aug 15, 1987 · N7653 · Substantial damageNTSB MKC87LA164Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mediapolis, IAThe pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the…Aug 15, 1987 · N4949X · Substantial damageNTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · DestroyedNTSB LAX87LA307Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Page, AZAfter arriving at the arpt, the plt entered traffic to land on rwy 15 with a gusty x-wind from the right. He reported that just before touchdown, the aircraft entered a sudden left roll. Subsequently, the left wing contacted the runway and the plane nosed…Aug 15, 1987 · N608V · Substantial damageNTSB LAX87LA305Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Covelo, CAThe plt rprtd that when she was landing, the acft ballooned, entered a porpoise & drifted to the left of the rwy. She applied power to 'fly out of the situation,' but the acft pitched up. The right seat occupant (pax) pulled the control yoke back &…Aug 15, 1987 · N98782 · Substantial damageNTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.Aug 15, 1987 · N7058C · Substantial damageNTSB ATL87LA232Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Ravenna, OHThe plt rprtd that drg a lndg on rwy 27, the acft touched down just short of the rwy lip. He stated that the rgt main gear hit a hole in the grass about 25 ft short of the rwy, then hit the lip. Subsequently, the rgt main gear failed & the acft veered off the…Aug 15, 1987 · N6898Z · Substantial damageNTSB SEA87LA164Accident · No injuriesLimited investigationFinal reportBeech A36TC · Cascade, IDThe plt elected to divert due to hvy rain at his destn. While lndg at an alternate arpt at ngt, hydroplaning occurred & braking was not effective. Drg a go-around, the acft rolled onto the overrun & lifted off, but the acft's main gear struck a rock pile on…Aug 14, 1987 · N1834M · Substantial damage