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 ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…Mar 26, 1987 · N757LM · Substantial damageNTSB ATL87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Bainbridge, GAThe acft collided with trees while conducting an ag training flight. The training program was part of the locust control in central and southern africa. There was an instructor on the ground who acted as a radio controller for the flight. The pilot failed to…Mar 26, 1987 · N6699Z · Substantial damageNTSB MIA87FA118Accident · 1 fatalField investigationFinal reportAero Mirage TC-2 · Williston, FLWitnesses stated that the acft made a 'fly by' at 300 ft to check and see if the gear was down. The ground personnel informed the plt that the gear appeared to be down. They stated that the acft then made a sharp left turn paralleling runway 14, they lost…Mar 25, 1987 · N2484V · DestroyedNTSB FTW87FA080Accident · No injuriesField investigationFinal reportConvair CV-580 · Dallas, TXMetro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair…Mar 25, 1987 · N73107 · Substantial damageNTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…Mar 25, 1987 · N128AA · No damageNTSB MKC87LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Houston, MOThe airplane was on an IFR flight plan and five miles from the airport, the airplane broke out of the clouds and proceeded VFR to the airport. It was a dark night and light rain was falling. The pilot stated he flew over the airport twice looking for a wind…Mar 24, 1987 · N38077 · Substantial damageNTSB MKC87IA066Incident · No injuriesIncident investigationFinal reportCessna 172 · Neosho, MOThe acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn…Mar 24, 1987 · N98763 · Minor damageNTSB LAX87FA153Accident · 2 fatalField investigationFinal reportBeech V35B · Camp Pendleton, CAAs the acft was nearing its destn at ngt, the plt contacted TRACON & reqd radar advisories & clnc into the terminal area. Radar contact was established when the acft was 6 mi nw of oceanside VOR at 1500' MSL. This placed the acft in a restricted area…Mar 24, 1987 · N8888M · DestroyedNTSB LAX87DVD02Accident · 1 fatalFinal reportCulver Cadet LFA · Antioch, CADuring a local pleasure flt, witnesses observed the acft take-off into a headwind. At aprx 1000 ft AGL, the nose of the acft came up then down. The acft entered a spin and collided with the terrain. They also stated that the propeller appeared to be slowing…Mar 24, 1987 · N37838 · DestroyedNTSB LAX87LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Anza, CADuring a local sight seeing flt the plt entered a river valley in mountainous terrain at about 1,000 ft AGL. After about 5 miles, the plt decided to exit the narrowing valley with a climbing right turn over a ridge line. About 2/3 of the way up the slope, the…Mar 23, 1987 · N2439T · Substantial damageNTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.Mar 23, 1987 · N1725F · Substantial damageNTSB CHI87IA100Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNThe aircraft landed uneventfully after the right engine failed during a descent. The shutdown occurred after failed antirotation pins allowed gas loads to drive normally stationary third stage vane clusters in the low pressure turbine area. Rotation of the…Mar 23, 1987 · N409AA · Minor damageNTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.Mar 22, 1987 · N88929 · Substantial damageNTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…Mar 22, 1987 · N3655G · Substantial damageNTSB DEN87LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over.Mar 22, 1987 · N6285Q · Substantial damageNTSB BFO87DID02Accident · Serious injuriesFinal reportEagle Balloons C-7 · Montvale, VAThe balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to…Mar 22, 1987 · N60765 · Minor damageNTSB ATL87LA093Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Waynesville, OHDuring the instructional flt to demonstrate emergency procedures, the instructor stated that he allowed the student to get too low on approach before he took corrective action. The aircraft collided with trees and subsequently the ground approx. 600 feet…Mar 22, 1987 · N2959H · Substantial damageNTSB ATL87LA091Accident · No injuriesLimited investigationFinal reportChampion 7FC · Bellefontaine, OHThe acft was landed on rwy 04 with the wind from the east at eight KTS. The flight was the first solo in a tail wheel equipped acft for the plt. He had obtained no formal instruction in a tail wheel acft but had flown with a friend. On landing the acft…Mar 22, 1987 · N90398 · Substantial damageNTSB ATL87LA090Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Cottondale, ALThe plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction.Mar 22, 1987 · N99436 · Substantial damageNTSB NYC87LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Lawrence, MAThe crew of the PA-31T cheyenne had made one missed approach and the co-pilot was calling out the altitudes to the pilot. The pilot's reply to the co-pilot was that he was just going to descend to 400 ft. the approach minimums were published for an mda of 660…Mar 21, 1987 · N200FD · DestroyedNTSB NYC87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Rutland, VTDrg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was…Mar 21, 1987 · N2083K · DestroyedNTSB NYC87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Du Bois, PAThe student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then…Mar 21, 1987 · N67911 · Substantial damageNTSB MKC87LA063Accident · No injuriesLimited investigationFinal reportGlasair SH2 · Springdale, ARImmediately after takeoff, the engine stopped and the acft collided with trees and then the terrain. Inspection revealed contamination in the fuel tank, the lines and the filter. Contamination was water, dirt, straw and gravel. The fuel being used was regular…Mar 21, 1987 · N67SH · DestroyedNTSB MKC87FA064Accident · No injuriesField investigationFinal reportCessna T337C · Garden City, KSBoth of the acft engs had just been overhauled. The plt decided to make a maint test flt & elected to leave the lndg gear in the down & locked psn. Takeoff & initial climb were normal until about 300 to 400 ft AGL. At that time the rear eng lost power. The…Mar 21, 1987 · N2600S · Substantial damageNTSB MIA87LA115Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Oxford, MSDuring final apch the eng quit. The plt then attempted to land the acft on a road, during which, it collided with trees. Inspection of the acft revealed that the adjusting screw on the eng driven fuel pump backed out aprx 8 turns. Bench test of the pump…Mar 21, 1987 · N9504Y · Substantial damageNTSB FTW87GA083Accident · No injuriesFinal reportBell 47G-3B-1 · Odessa, TXInvestigation reveals the helicopter touched down on the heel of its skids, left skid first, and at a slightly low rotor RPM. The tail boom then moved upward while the main rotor blades flexed downward. The main rotor blades contacted and severed the tail…Mar 21, 1987 · N62462 · Substantial damageNTSB DEN87FA069Accident · 1 fatalField investigationFinal reportRaven S-77A · Park City, UTWhile on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted…Mar 21, 1987 · N40968 · DestroyedNTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…Mar 21, 1987 · N25333 · Substantial damageNTSB ATL87LA094Accident · Serious injuriesLimited investigationFinal reportBarlow Quickie 2 · Stockbridge, GAThe homebuilt Q-2 was on final approach when it impacted the trees about 300 feet short of the touchdown point. There were no witnesses and the pilot has no memory of the accident. He reported that he does not recall any problem with the aircraft except the…Mar 21, 1987 · N14QP · DestroyedNTSB ATL87LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Darien, GADuring normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become…Mar 21, 1987 · N2948R · Substantial damageNTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.Mar 20, 1987 · N6798Q · Substantial damageNTSB MIA87FA114Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…Mar 20, 1987 · N726FL · DestroyedNTSB LAX87LA152Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palm Springs, CADuring a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was…Mar 20, 1987 · N759V · Substantial damageNTSB LAX87FA151Accident · Serious injuriesField investigationFinal reportCessna T210K · Prescott, AZAfter overloading the aircraft with 5 pax and baggage, the pilot departed on a personal cross country flight to phoenix, AZ. He climbed the acft to and maintained an altitude of 14,500 feet MSL until reaching salt lake city, UT. The aircraft was then…Mar 20, 1987 · N8105G · DestroyedNTSB CHI87DEC02Accident · Minor injuriesFinal reportCessna 172G · Linden, MIThe student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the…Mar 20, 1987 · N3630L · Substantial damageNTSB ATL87LA092Accident · No injuriesLimited investigationFinal reportMooney M20 · Frankfort, KYDuring the final phase of the approach procedure, the pilot failed to extend the landing gear. The aircraft touched down, skidded along the runway surface until it finally came to rest. The pilot reported that the fuel strainer failed and a fire started and…Mar 20, 1987 · N5251B · DestroyedNTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…Mar 20, 1987 · N18879 · DestroyedNTSB SEA87LA066Accident · No injuriesLimited investigationFinal reportCessna 172 · Lopez Island, WADuring cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During…Mar 19, 1987 · N64728 · Substantial damageNTSB NYC87FA114Accident · 2 fatalField investigationFinal reportBell 47G · Wassaic, NYThe Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No…Mar 19, 1987 · N13766 · DestroyedNTSB LAX87LA160Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes FF-8-24 · Phoenix, AZDuring a local sightseeing flight, the pilot reported that upon lift-off the weather conditions were clear and calm. During the flight, however, the wind conditions had increased from a westerly direction at a velocity of 12 knots, gusting to 15. The pilot…Mar 19, 1987 · N3750D · Minor damageNTSB LAX87LA157Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Phoenix, AZDuring factory flt training, prior to delivery of the new helicopter to the owner, the CFI said he asked the student to perform a series of emergency procedures which included quick stops from an initial takeoff followed by hovering autorotations. The CFI…Mar 19, 1987 · N1601Y · Substantial damageNTSB FTW87LA077Accident · No injuriesLimited investigationFinal reportBell 206B · Austin, TXAcft was damaged during a hard landing on a roof top heliport following a partial power loss as a result of an uncommanded engine deceleration. As the acft was 40' above and 40' out from the heliport pad, the power loss occurred and the plt stretched his…Mar 19, 1987 · N666TV · Substantial damageNTSB DEN87LA067Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Missoula, MTThe plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance.Mar 19, 1987 · N3529W · 2 aircraft · Minor damageNTSB CHI87FA099Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Attica, INAfter completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that…Mar 19, 1987 · N5504L · DestroyedNTSB BFO87DIG02Accident · Serious injuriesFinal reportBoeing 727-200 · Charleston, SCThe flight encountered clear air turbulence at FL 350 during cruise flight. The pilot said he was aware beforehand of existing turbulent conditions. According to the plt the seat belt sign was on, the flight attendant and passengers were asked to be seated.…Mar 19, 1987 · XAHOH · No damageNTSB ANC87LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKAs the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,…Mar 19, 1987 · N3439D · Substantial damageNTSB SEA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVDuring landing a gust of wind occurred from the right. The student pilot was not able to correct for the wind and lost control of the aircraft. The aircraft veered to the left of the runway onto rough terrain and then nosed over inverted.Mar 18, 1987 · N457AF · Substantial damageNTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.Mar 18, 1987 · N8698T · Substantial damageNTSB LAX87LA150Accident · No injuriesLimited investigationFinal reportCessna P210N · Elk Grove, CADuring a local flight to check repairs to the aircraft cabin pressurization, the aircraft had descended from 8500 ft MSL to 2000 ft MSL when the engine began cutting out. Unable to maintain altitude to return to the airport, the pilot landed the aircraft in a…Mar 18, 1987 · N6446W · Substantial damageNTSB LAX87FA149Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Jamestown, CADuring the night cross country flt, the accident acft, in company with 2 others, was trying to land at the dest airport in hilly terrain. As the 3 acft approached the airport they encountered bkn to ovrcst conditions of about 400 ft AGL and vis of 2 mi in…Mar 18, 1987 · N5393P · Destroyed