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 SEA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Juan Island, WAThe pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the…Aug 25, 1986 · N7405T · DestroyedNTSB MIA86LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Pierce, FLWhile in cruise flt the acft's eng failed and the acft was ditched in a river. Post crash eng exam revealed the no. 1 and no. 2 connecting rods separated from the crankshaft when both bolts failed on the no. 1 rod and 1 bolt failed on the no. 2 rod.…Aug 25, 1986 · N6460W · Substantial damageNTSB LAX86LA343Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Riverside, CAWhile en route to hawthorne airport the aircraft experienced a total loss of power. During a circling descent the pilot attempted to restart the engine without success. The aircraft collided with the terrain 500 ft short of rwy 27 at Riverside airport. The…Aug 25, 1986 · N4083R · Substantial damageNTSB LAX86LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Salinas, CAThe acft collided with the surface of rwy 13 after the nose gear collapsed. The plt indicated the three green gear safe indicator lights were illuminated prior to touchdown. The acft was landed on the main gear first and then the nose gear. The nose gear…Aug 25, 1986 · N56710 · Substantial damageNTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…Aug 25, 1986 · N7261T · Substantial damageNTSB DEN86LA236Accident · Serious injuriesLimited investigationFinal reportMayala Dragonfly · Helena, MTThe acft was on final apch after completing a x-country from billings, MT, when the accident occurred. The plt stated the acft was low after intercepting the VASI so power was added; however, the eng did not respond. The acft struck a small hill 300 ft short…Aug 25, 1986 · N4478V · Substantial damageNTSB ATL86FA227Accident · No injuriesField investigationFinal reportCessna 421C · Nashville, TNDuring a normal takeoff the pilot experienced a dual engine failure about 10 feet above the runway. The pilot stated that he landed on the remaining runway and attempted an 80 degree left turn onto taxiway 'c'. The aircraft failed to negotiate the turn at the…Aug 25, 1986 · N5299J · Substantial damageNTSB SEA86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kent, WAThe plt lost control of the acft during landing roll and a ground loop to the right occurred despite the plts attempt to regain control of the acft. The plt stated his ability to use the heel brakes was delayed due to the type of shoes he was wearing.Aug 24, 1986 · N23TT · Substantial damageNTSB SEA86LA223Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Caldwell, IDDuring an aerial application flight, the plt entered a right turn during a 'border pass.' While in the right turn, the right wing struck the ground and the aircraft cartwheeled & crashed.Aug 24, 1986 · N4077X · Substantial damageNTSB SEA86LA222Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sandpoint, IDThe plt lost directional control of the acft for unknown reasons during the landing roll and a ground loop resulted.Aug 24, 1986 · N4151Y · Substantial damageNTSB SEA86LA220Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Weippe, IDAn undershoot occurred during landing at an unlit airstrip at dusk. Shortly after touchdown the aircraft struck a six foot mound of dirt. The aircraft then nosed over inverted and slid 60 to 70 feet before it came to rest.Aug 24, 1986 · N4694K · DestroyedNTSB SEA86LA219Accident · Minor injuriesLimited investigationFinal reportBrennan Glasair · Mount Vernon, WAThe pilot arrived at the airport about one hour before fuel was available. He assumed that he had enough fuel remaining on board for the next leg of the flight because the duration would be about 10 minutes. About 5 minutes into the flight the aircraft's…Aug 24, 1986 · N85KB · Substantial damageNTSB NYC86LA217Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lakewood, NJThe flight encountered a strong gust of crosswind while taking off. The pilot was unable to correct and lost control of the aircraft at which time the aircraft ran off the rwy and nosed over.Aug 24, 1986 · N5238X · Substantial damageNTSB NYC86FHM03Accident · 1 fatalFinal reportSchempp-Hirth Ventus A · Middletown, NYThe sailplane was being towed into the air. It was observed to come off the ground in a tail low attitude and then start porposing. The aircraft was released from the tow plane and impacted. The pilot was fatally injured and the aircraft destroyed. No…Aug 24, 1986 · N7XT · DestroyedNTSB MKC86LA174Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KSThe pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further…Aug 24, 1986 · N5924 · Substantial damageNTSB MKC86LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bertrand, NEThe pilot stated that he was on an unsupervised local solo flight when he decided to land at a private airstrip. As he had driven his automobile on this runway four days prior to the accident and had found the landing surface clear he assumed that the runway…Aug 24, 1986 · N5376F · Substantial damageNTSB MIA86LA240Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Dublin, MSWhile buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground.Aug 24, 1986 · N55290 · Substantial damageNTSB MIA86FA241Accident · 1 fatalField investigationFinal reportRussell Post Moni Motorglider · Fellsmere, FLWitnesses reported seeing the aircraft performing aerobatic maneuvers at approximately 1500 feet. The aircraft was later found with the tail surfaces separated. The tail surfaces were found 300 and 400 feet from the main wreckage. A metallurgical examination…Aug 24, 1986 · N49P · DestroyedNTSB LAX86FVA15Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28M2 · Porterville, CADuring initial climb, shortly after takeoff, the pilot heard a loud whir then a boom sound. The aircraft started vibrating so the pilot shut down the engine. Having gained 200 to 300 feet of alt the pilot initiated a left 180 deg turn to attempt a forced…Aug 24, 1986 · N9023B · Substantial damageNTSB LAX86FA328Accident · 2 fatalField investigationFinal reportCessna 172L · Grand Canyon, AZThe acft crashed in a wooded area shortly after departing rwy 21 at Grand Canyon national park arpt (gcn). The plt had made a precautionary landing at gcn during the x-country flt to page, AZ, so he call a fss having been unable to establish contact in-flt.…Aug 24, 1986 · N7382Q · DestroyedNTSB FTW86FPA26Accident · No injuriesFinal reportErickson S-1 · Garland, TXThe internal lining in the fuel tank flop tube (fuel pickup tube for inverted flight) deteriorated and blocked the full screen. The eng quit due to fuel starvation. The acft struck a short pole for an underground utility line during the forced landingAug 24, 1986 · N22JE · Substantial damageNTSB DEN86LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Santa Fe, NMWhile flying through a mountain pass at an alt of 1,000 ft AGL, the plt encountered downdraft wind currents. The acft entered an uncontrollable descent and impacted in an alpine meadow.Aug 24, 1986 · N24151 · DestroyedNTSB CHI86LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clintonville, WIFollowing at least three successful practice low approaches to a farm field, the student pilot climbed over a small wooded area and did a 180 degree turn to perform an approach to another field. He flew down to within 20 feet of the ground, then applied full…Aug 24, 1986 · N2352N · Substantial damageNTSB CHI86LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Milford, MIThe pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft…Aug 24, 1986 · N8765S · Substantial damageNTSB ATL86LA225Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Ardmore, ALDuring the landing attempt, the pilot elected to go-around after he realized that a safe landing could not be completed. During the go-around the acft settled to the rwy after the pilot retracted the flaps. The acft rolled off the departure end of the rwy at…Aug 24, 1986 · N285G · Substantial damageNTSB ATL86LA224Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Wadsworth, OHDuring the landing roll on rwy 02, the pilot lost directional control and the acft veered off the right side of the runway. The reported winds were 290 degrees at 8 knots. The wreckage examination failed to disclose any malfunction or failure. The acft brake…Aug 24, 1986 · N50HZ · Substantial damageNTSB ANC86IA137Incident · No injuriesIncident investigationFinal reportCessna 207A · Togiak, AKAfter landing the airplane was taxiing to park and the pilot noticed the steering becoming stiff. He stopped the airplane and examined the nose gear and found it to have pivoted forward with the wheel coming to rest against the nose cowling. The mechanic…Aug 24, 1986 · N1472M · Minor damageNTSB SEA86FA216Accident · 3 fatalField investigationFinal reportGlasair SH2 · Roche Harbor, WAThe acft was one of a group of glasairs that were departing the airport after a fly in breakfast at the resort. Witnesses reported the acft departed on runway 06 (uphill) in a 3 point attitude. As the acft continued down the runway, in a steep nose up climb,…Aug 23, 1986 · N394SK · DestroyedNTSB MKC86LA176Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Hope, ARThe CFI stated that the landing gear collpased during landing roll as he raised the flaps. The student, a commercial plt, was applying power for a touch and go at the time. Post accident examination of the landing gear system failed to disclose any…Aug 23, 1986 · N7625Y · Substantial damageNTSB MIA86FA239Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Vero Beach, FLFlight experienced loss of engine power while climbing through 200 feet shortly after takeoff. While attempting to return to the runway the aircraft collided with trees and the ground coming to rest adjacent to the runway. Examination of aircraft records…Aug 23, 1986 · N23266 · Substantial damageNTSB LAX86LA330Accident · No injuriesLimited investigationFinal reportCessna 182U · Tuba City, AZThe acft collided with a dirt bank after losing alt during the initial climb after takeoff from a dirt road. The plt indicated the acft became airborne after an aprx 800 ft ground run and climbed to an alt of 10 ft AGL. The acft then encountered a gust of…Aug 23, 1986 · N5299N · Substantial damageNTSB LAX86FUM02Accident · 1 fatalFinal reportStar-Lite UNK · Ramona, CADuring a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the…Aug 23, 1986 · N42TJ · DestroyedNTSB DEN86LA240Accident · No injuriesLimited investigationFinal reportCessna 170B · Greeley, COPlt was ferrying acft from glenwood springs, CO to troy, MO. Acft was out of annual (3-84) and a special airworthiness certificate was issued. Plt likewise had not flown for 2 years. Plt accomplished the mandatory biennial flight review the day before the…Aug 23, 1986 · N2790D · Substantial damageNTSB CHI86LA211Accident · No injuriesLimited investigationFinal reportCessna 175 · Muskegon, MIJust prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched…Aug 23, 1986 · N9275B · Substantial damageNTSB BFO86LA041Accident · No injuriesLimited investigationFinal reportBellanca Citabria · Pasadena, MDOne witness who watched N41464 make the approach indicated that the aircraft appeared to be too fast as it passed the 1/2 way point on the runway and that it bounced back up into the air after nosing down onto the turf runway. The nose of the aircraft came up…Aug 23, 1986 · N41464 · Substantial damageNTSB ANC86LA135Accident · No injuriesLimited investigationFinal reportCessna A-185E · Talkeetna, AKThe aircraft lost control upon landing on a gravel bar and nosed over.Aug 23, 1986 · N70021 · Substantial damageNTSB ANC86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nabesna, AKDuring the initial climbout the pilot stalled the aircraft, lost control and crashed off the departed end of the airstrip. At the time of the accident, the pilot departed with a tailwind.Aug 23, 1986 · N2994Z · Substantial damageNTSB SEA86LA218Accident · No injuriesLimited investigationFinal reportCessna A185E · Soldier Bar Air, IDThe pilot was attempting to land on a 1600 foot runway with a tailwind. The density altitude at the time was about 6300 feet. During braking a gust of wind occurred and the aircraft nosed over inverted.Aug 22, 1986 · N1RC · Substantial damageNTSB SEA86LA214Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cusick, WAThe pilot was performing as a barnstormer close to a local fair. After completion of several low passes the pilot was attempting to make a steep 180 degree turn to a landing. The turn was completed at insufficient altitude to recover and the aircraft struck…Aug 22, 1986 · N95913 · Substantial damageNTSB NYC86LA227Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Newburyport, MAThe plt experienced a total power loss of the acft eng while practicing autorotations. The helicopter landed hard, the main rotor flexed and severed the tail boom. Post accident inspection of the helicopter revealed the fuel selector was positioned on the…Aug 22, 1986 · N255PH · Substantial damageNTSB NYC86FA214Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Ft. Dix, NJThe acft was headed sw on victor sixteen inbound to coyle VOR when the plt reported the loss of gyro instruments. The acft was at 6000 ft and in 'solid IFR weather.' The plt elected not to declare emergency and land when asked if he wanted to do so by ATC.…Aug 22, 1986 · N8734P · DestroyedNTSB MKC86LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe ag acft was being used to spray nudrin on soybeans when the engine lost power. The plt made a forced landing in a rice field and the acft flipped forward to the inverted position. Investigation revealed the two-piece cam reduction gear came apart. An AD…Aug 22, 1986 · N634U · Substantial damageNTSB LAX86LA327Accident · No injuriesLimited investigationFinal reportCessna P210N · Coalinga, CAThe flight was a repositioning flight back to the aircraft's home base at the conclusion of an on demand air taxi flight. The pilot said that he departed without visually checking the fuel tank level. The pilot said the fuel gauges indicated one half tanks…Aug 22, 1986 · N4831A · Substantial damageNTSB DEN86LA234Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Dillon, MTPlt said he called UNICOM for arpt advisory and heard operator say something about six. He thought she said rwy 6 was the preferred rwy (there is no rwy 6 at Dillon arpt). Operator actually said rwy 16 was the preferred rwy. Plt landed past midway point of…Aug 22, 1986 · N6952M · Substantial damageNTSB DEN86IA235Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COTwa flt 735 landed at Denver stapleton arpt. During the taxi to the passenger terminal, a fire erupted in the tailpipe of the left engine. The flt crew executed the emergency evacuation procedures. Fire was extinguished. With no damage to the acft or engine.…Aug 22, 1986 · N31001 · No damageNTSB CHI86LA210Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lodi, WIDuring a practice emergency landing approach, the instructor told the student to go around at an altitude of about 600 feet AGL. The student failed to add power and pulled the yoke all the way back. The aircraft then stalled. The instructor took control,…Aug 22, 1986 · N2430E · Substantial damageNTSB SEA86FA217Accident · 2 fatalField investigationFinal reportAeronca 7GCB · Stanley, IDWitnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft…Aug 21, 1986 · N9940Y · DestroyedNTSB SEA86FA215Accident · 6 fatalField investigationFinal reportCessna T207A · Frenchglen, ORAlthough low altitude flight within the gorge was not in accordance with the mission profile the pilot entered the canyon and proceeded upslope towards rising terrain. 87% of the pilot's extensive flight experience was in helicopter aircraft and he had…Aug 21, 1986 · N73569 · DestroyedNTSB NYC86LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Rochester, NHPilot made a steep descent and lost directional control. The aircraft collided with the ground while still turning causing the helicopter to roll over.Aug 21, 1986 · N2276X · Substantial damageNTSB BFO86LA043Accident · No injuriesLimited investigationFinal reportPiper 601P · Indian Head, MDThe owner of the Aerostar 601P was flying his family and a friend from bedford, Massachusetts to Indian Head, Maryland. After monitoring the dca ATIS he elected to make an ILS to fort belvoir, Virginia, break off the missed approach and proceed VFR over to…Aug 21, 1986 · N9756Q · Substantial damage