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 DEN86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAccording to the student plt, he flared too high during landing & landed hard, collapsing the nose gear.May 1, 1986 · N94703 · Substantial damageNTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…May 1, 1986 · N313R · Substantial damageNTSB CHI86LA135Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Indianapolis, INThe acft had sat idle for four days in heavy rains prior to this flt. A loss of power was experienced during takeoff. The plt attempted a 180 deg turn back to the arpt during which the acft stalled and descended to ground impact. Aprx 2.5 ounces of water were…May 1, 1986 · N21139 · Substantial damageNTSB MKC86FA098Accident · 1 fatalField investigationFinal reportCessna 150 · Harrisburg, NEThe acft impacted in a 40 degree nose down attitude following a stall-spin. No mechanical descrepancies were noted with the acft and no pre-existing physical incapacitating history of the PIC was discovered. On two separate occasions prior to this flt, the…Apr 30, 1986 · N10768 · Substantial damageNTSB MIA86LA139Accident · Serious injuriesLimited investigationFinal reportWing D-1 · Bunnell, FLThe plt stated that his canopy had come open and he was trying to hold it closed and make an emergency landing on runway 29 at flagler co. airport, but being too low and fast the acft struck the ground about 100 ft short of the runway and slid to a stop.Apr 30, 1986 · N8601E · Substantial damageNTSB LAX86LA210Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearlake, CAThe flt instructor (CFI) said he was instructing the student in how to judge a straight-in approach and landing to a dock with minimal taxiing required. During the approach, the CFI determined that the student was overshooting the desired touchdown point, so…Apr 30, 1986 · N738JE · Substantial damageNTSB LAX86LA202Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Vacaville, CAAccording to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.Apr 30, 1986 · N2750Z · Substantial damageNTSB LAX86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fallbrook, CAA Piper PA-38-112 veered off rwy 36. The wx reporting station located 6 NM se of the arpt reported that the winds were from 180 deg at 7 KTS during the period that the accident occurred. The plt indicated that he misinterpreted the arpt wind indicator and…Apr 30, 1986 · N25954 · Substantial damageNTSB DEN86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Lamar, CODuring the initial telephone interview, the plt stated the eng quit due to fuel exhaustion while returning from an ag spraying flt. However, in the plt accident report, the plt states that he could not rule out mechanical problems.Apr 30, 1986 · N76LF · Substantial damageNTSB CHI86FER06Accident · 1 fatalFinal reportCessna 180 · Brainerd, MNA witness reported seeing the floatplane descending 'abnormally' in a nose low attitude just prior to water impact. The plt reported making the apch to the lake in a nose up attitude with partial power on. The plt remembers no further events leading up to the…Apr 30, 1986 · N6559A · DestroyedNTSB LAX86LA199Accident · No injuriesLimited investigationFinal reportCessna 177RG · Placerville, CAWhile enroute to san francisco, CA the engine began to overspeed & the prop gov control was not effective in arresting/controlling the overspeed condition. Shortly thereafter the engine oil pressure depleted to zero. The pilot elected to land in the ice house…Apr 29, 1986 · N34020 · DestroyedNTSB FTW86LQG15Accident · No injuriesFinal reportAviation ADV. Mustang Psid · Midland, TXThe experimental acft on a test flt suffered an engine failure during the final approach to land. The plt said that he did not believe he could make the arpt so he turned right to an open field to land downwind. Investigation after the accident revealed that…Apr 29, 1986 · N51JR · Substantial damageNTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…Apr 29, 1986 · N3660Y · DestroyedNTSB ATL86FA120Accident · 4 fatalField investigationFinal reportPiper PA-28-160 · Winton, NCBefore the flt, the student plt & passengers had been socializing & drinking beer. At aprx 0200 EDT, while at a friend'shome near murfreesboro, NC, they decided to go flying. At about 0300, an acft was observed to fly over the friend's home at low alt, then…Apr 29, 1986 · N5258W · DestroyedNTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…Apr 28, 1986 · N3580Q · Substantial damageNTSB SEA86LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Ellensburg, WAThe student plt was attempting to land in high gusting x-winds. The wind was from about 290 degs at 30 KTS gusting to 35 KTS, the rwy heading is about 340 degs. The plt allowed the airspeed to decay to 40 KTS just prior to the flare and a hard flat landing…Apr 28, 1986 · N7198A · Substantial damageNTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…Apr 28, 1986 · N3235V · Substantial damageNTSB NYC86FA114Accident · 1 fatalField investigationFinal reportGlaser-Dirks DIRK-DG-400 · Julian, PAThe plt of N686U reported he was established in weak thermal at an alt of aprx 2500 AGL when two other gliders were seen. One at aprx the same alt and one below his alt. He continued to state that the glider which was at his alt passed very close to but…Apr 28, 1986 · N40MS · 2 aircraft · DestroyedNTSB LAX86LA201Accident · No injuriesLimited investigationFinal reportCessna 150M · Torrey Pines, CAThe student plt was on the final leg of a x-country flt when the eng quit. A forced landing was attempted on a beach during which the acft nosed over. The plt stated that he purchased 5.9 gallons of fuel at one of his points of landing. He did not report how…Apr 28, 1986 · N704PL · Substantial damageNTSB LAX86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Benson, AZA Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see…Apr 28, 1986 · N5RM · Substantial damageNTSB CHI86LA128Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Pickney, MIThe balloonest had briefed and positioned his two pax for a anticipated hard/drag landing in a 9 kt wind. He stated the balloon touched and bounced then touched and bounced again before it entered the drag sequence of the landing. The female pax suffered a…Apr 28, 1986 · N298CB · No damageNTSB ANC86LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Chugiak, AKWhile flying in the mountains at about 5000 feet MSL (200 feet AGL), the airplane encountered a downdraft, causing it to crash on a glacier. Pilot estimated the winds to be about 10 knots.Apr 28, 1986 · N3438A · Substantial damageNTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…Apr 27, 1986 · N8165K · DestroyedNTSB SEA86LA114Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20-D · Minden, NVThe cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude.Apr 27, 1986 · N6VS · Substantial damageNTSB SEA86LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Hubbard, ORDuring practice simulated forced landing with the power reduced to idle and gusting crosswinds airspeed was lost. The aircraft entered into an approach stall striking the ground nose first and then nosing over inverted.Apr 27, 1986 · N65654 · Substantial damageNTSB NYC86LA113Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Ridgefield Park, NJA weight imbalance, then a split needle, caused the plt to abort 2 previous attempts to depart. Conditions were corrected & the helicopter departed the waterfront helipad. As it went over the water, the plt noted a loss of eng power. He tried to return to the…Apr 27, 1986 · N60PB · Substantial damageNTSB MKC86LA097Accident · No injuriesLimited investigationFinal reportCessna 172F · Van Buren, MOThe pilot states that he had been advised of utility lines on both ends of the airstrip, and that several aircraft had previously experienced landing problems there. He further states that as he initiated a go-around he was caught in a downdraft he could not…Apr 27, 1986 · N7921U · Substantial damageNTSB MIA86LA137Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Ft.Lauderdale, FLThe acft was stolen by a 17 year old non-pilot rated male. While taxiing on a taxiway the acft was reported to be fish tailing before it ran off the taxiway and became airborne. When the acft touched down it bounced aprx 10 ft into the air and performed a…Apr 27, 1986 · N3789X · Substantial damageNTSB LAX86LA212Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Lower Lake, CAWhen the acft departed lampson arpt the left ldg gear did not retract. Gnd witnesses reported the airplane landed with only the left gear extended. The plt reported he observed all three ldg gear down green lights illuminated while in the traffic pattern. The…Apr 27, 1986 · N8549R · Substantial damageNTSB LAX86LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe plt misjudged the flare during landing and the acft touched down in a nose low attitude shearing the nose gear from the acft. The density altitude was calculated to be 3,500 ft when the accident occurred.Apr 27, 1986 · N7338F · Substantial damageNTSB LAX86LA195Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearny, AZThe plt stated that he was on a sightseeing flt and was flying westbound at about 100 ft AGL along the gila river, when the acft struck powerlines. The acft then descended into the river bed. He futher stated that he observed the powerlines at the last minute…Apr 27, 1986 · N12962 · DestroyedNTSB LAX86LA194Accident · No injuriesLimited investigationFinal reportCessna 150H · Davis, CAThe acft landed on a privately own ranch dirt airstrip. The plt reported the landing was normal, but during the landing roll the acft nosewheel struck a small ditch causing it to nose over onto its back. The pilot did not report any preimpact acft…Apr 27, 1986 · N50007 · Substantial damageNTSB LAX86LA193Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Keaau, HIA hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…Apr 27, 1986 · N5067F · DestroyedNTSB LAX86FVM05Accident · Minor injuriesFinal reportHiller UH12E · Castroville, CAThe acft landed hard and rolled over after the lndg skid failed in a forced lndg. The plt said he was crusing at 500 ft AGL over an open field when he heard a loud bang. The helicopter began to vibrate severely and spiral to the right. The plt lost ground…Apr 27, 1986 · N5374V · DestroyedNTSB CHI86LA134Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt Clemens, MIAfter aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…Apr 27, 1986 · N2194U · DestroyedNTSB CHI86LA133Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe pilot stated that during landing the right wing of the glider touched the ground causing a right turn. The left wing then caught on a truck tire causing a 70 degree turn to the left. The glider was stopped when the right wing struck a barn. He was later…Apr 27, 1986 · N30LH · Substantial damageNTSB CHI86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Griffith, INAfter takeoff and while climbing through 60 ft AGL the plt could not move the aileron to recover from a 15 deg left bank. The plt reduced power and landed the acft in a left wing low attitude. The acft slid and struck a creek bank with the right wing. Post…Apr 27, 1986 · N3321A · Substantial damageNTSB CHI86LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Midlothian, ILThe acft was being operated on a student instructional flt. On initial run up the CFI stated he had an excessive mag drop that cleared up. The acft was flown to an adjacent field to make two touch and go landings. During the last takeoff the CFI suspected a…Apr 27, 1986 · N33822 · Substantial damageNTSB ATL86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · Braselton, GAThe pilot reported that the engine RPM decreased while conducting a banner tow flight and that the engine subsequently quit. The airplane was landed in a field of an auto race track where a telephone pole was struck during the landing roll. Temperature was 92…Apr 27, 1986 · N6242Z · Substantial damageNTSB SEA86LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dallas, ORA precautionary landing was made due to deteriorating weather. Directional control was lost while attempting to land on the 70 foot wide, wet, grass airstrip during gusty crosswinds. The aircraft veered to the side of the runway striking four parked…Apr 26, 1986 · N8312K · Substantial damageNTSB MIA86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Lauderdale, FLWhile towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…Apr 26, 1986 · N2411P · Substantial damageNTSB MIA86LA134Accident · No injuriesLimited investigationFinal reportCessna 310L · Opa Locka, FLThe right main landing gear collapsed on the landing rollout, after which the acft slid off the right side of the rwy & came to rest on the grass. Post crash examination of the landing gear retract system revealed that the right main gear retract push pull…Apr 26, 1986 · N216Y · Substantial damageNTSB MIA86FA135Accident · Serious injuriesField investigationFinal reportCessna 172D · St. Petersburg, FLWhile on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…Apr 26, 1986 · N2321U · Substantial damageNTSB LAX86LA198Accident · No injuriesLimited investigationFinal reportCessna 501 · Bermuda Dunes, CABased on the flt's landing weight, an approach ref speed of 99 knots was calculated by the pilot. He reported that 115 knots was used during the approach. The pilot said that during the descent to the airport, one aircraft was heard to make a go-around 'due…Apr 26, 1986 · N46MT · Substantial damageNTSB LAX86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Coolidge, AZThe plt shut down the acft eng when it surged during an encounter with turbulence. The plt initiated a precautionary downwind landing on a nearby airstrip and the acft overran the rwy and collided with a fence.Apr 26, 1986 · N7280Y · Substantial damageNTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…Apr 26, 1986 · N2285Y · Substantial damageNTSB ATL86LMG06Accident · No injuriesFinal reportRussell Acro MR3 · Clio, SCThe plt reported that the home-built acft experienced a loss of aileron control during lndg. He continued the lndg, using the rudder and throttle to control the acft. The acft hit a tree-top adjacent to the rwy and crashed into a plowed field next to the…Apr 26, 1986 · N3MR · DestroyedNTSB ANC86LA050Accident · Minor injuriesLimited investigationFinal reportInterstate 15B2 · Port Heiden, AKThe pilot stated that during the takeoff roll he lost control of the aircraft causing the plane to nose over on its back.Apr 26, 1986 · N64AT · Substantial damageNTSB ANC86LA049Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Polly Creek, AKThe pilot attempted a landing on a sandbar. During the landing roll the pilot lost directional control of the aircraft causing the airplane to ground loop and then nose over on its back.Apr 26, 1986 · N1616G · Substantial damageNTSB SEA86LA110Accident · No injuriesLimited investigationFinal reportRobinson R22-A · Portland, ORAt aprx 500 ft AGL, while on a local traffic watch, a loss of pwr occurred. A 15 kt tail wind was present. Pwr lines had to be cleared and a hard landing resulted. An examination and test run of the eng failed to disclose any failure/ malfunction which would…Apr 25, 1986 · N8536Z · Substantial damage