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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA86FA066Accident · 2 fatalField investigationFinal reportPiper PA34-200T · Antelope, ORPlt was operating VFR on top at 11000 feet, commenced descent to destination 34 miles out. Plt rpted field in sight 16 miles out, passing 6500 ft, cancelled flight plan. Acft impacted ridge at 4100 feet MSL 7 miles from destination. Dark night conds existed,…NTSB MIA86FA085Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · St. Cloud, FLThe acft was on a VFR flt, the wx was clear with an almost full moon when the acft crashed in a fld. There was no evidence of an airframe, flt control system, eng or propeller malfunction or failure. The autopsy & toxicological studies revealed no pre impact…NTSB LAX86LA128Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe owner of the acft reported that he had just purchased the aircraft and was being checked out at the time of the accident. Shortly after departing cma and upon reaching 1200 ft MSL, the engine lost power. Unable to maintain altitude the check pilot assumed…NTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…NTSB CHI86FA092Accident · Serious injuriesField investigationFinal reportBeech G18S · Janesville, WIThe aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC.NTSB LAX86LA124Accident · No injuriesLimited investigationFinal reportCessna 150J · Los Banos, CAThe pilot stated that he overflew his destination airport while on a night cross-country flight. He turned around and was proceeding back when the engine quit 20 miles short of his intended destination. The aircraft hit a ditch during the ensuing forced…NTSB DEN86LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Estelline, SDAccording to the student plt, during the landing roll on a public road, the acft he was piloting encountered a crosswind which tipped the left wing up. The student plt indicated the acft nosed over onto its back. The plt had purchased the acft aprx 1 hr prior…NTSB DEN86IA083Incident · No injuriesIncident investigationFinal reportCessna T207A · Longmont, COAccording to the FAA examiner, the plt whom he was giving a checkride to applied full brakes during the short field landing, causing both tires to fail.NTSB ATL86LLT07Accident · Serious injuriesFinal reportCessna 152 · Dyersburg, TNThe acft collided with trees on the edge of a 5000 ft open field during a precautionary landing after the student plt on his first solo x-country became lost & confused. He landed off arpt even though he still had about 3 hrs fuel. Wx was not threatening and…NTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…NTSB MIA86LA084Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Homestead, FLThe plt stated that she had completed one spray pass with one ton of fertilizer aboard & pulled up in a turn to about 200 ft. at that time the acft 'hit a pocket of dead air.' The acft nosed down and although the plt dumped the chemical load, she could not…NTSB MIA86LA083Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Greenwood, MSThe plt stated that during an aerial application swath run, he struck a group of power lines & crashed into a field.NTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…NTSB FTW86LQA01Accident · Minor injuriesFinal reportCessna 152 · El Paso, TXThe acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt…NTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…NTSB SEA86LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mount Baldy, IDThe pilot allowed the aircraft to enter into instrument meteorological conditions. The artificial horizon was inoperative as well as the turn portion of the turn and bank. A tree was struck with the aircraft then striking the ground.NTSB MKC86LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gardner, KSThe ip and student had been practicing landings at another airport and was landing at this airport for fuel. There was a crosswind at the airport and the ip made the approach and landing. A witness stated that the touchdown was three point in the Cessna 170A…NTSB LAX86LVM02Accident · No injuriesFinal reportBellanca 7ECA · San Jose, CAThe acft ground looped to the left after landing. The student plt said he attempted with rudder and aileron to regain directional control but failed. After rolling into the grass the acft nosed over. The plt said he should have held the stick back to assure…NTSB FTW86LPA20Accident · Serious injuriesFinal reportBalloon Works Fire FLY 7 · Keller, TXThe Balloon descended into a power line during landing at a mobile home park. The plt said that he did not see the wires until they were silhouetted against the horizon. He then tried to expedite the venting of hot air from the envelope to go under the wires.…NTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…NTSB BFO86FID01Accident · Minor injuriesFinal reportCessna 172L · Gordonsville, VAOn February 23, 1986, at 1621 EST, a Cessna 172L, N7191Q collided with a tree during an attempted go-around at Gordonsville airport, Gordonsville, VA., while on a pleasure flight. Visual meteorological conditions prevailed at the time and no flight plan was…NTSB ATL86FA081Accident · 1 fatalField investigationFinal reportRobinson R22 · Greenville, TNThe flt was last seen to depart rwy 23 at the Greenville arpt & enter a low cloud layer at ngt. A witness estimated the helicopter entered the clouds at about 300 to 400 ft AGL. No flt plan was filed. The wreckage was found the next day, located about 1/4 mi…NTSB ANC86LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Houston, AKThe pilot was buzzing the area less than 200 feet above the ground when the engine started to run rough; the pilot attempted to land near the road when the aircraft struck power lines and a row of trees. Examination of the engine revealed no mechanical…NTSB FTW86LPA19Accident · No injuriesFinal reportCessna 182A · Decatur, TXThe acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…NTSB FTW86FPA17Accident · Serious injuriesFinal reportCessna 421 · Alvord, TXThe acft collided with tree tops and sheared the landing gear during a forced landing off arpt. The left eng had been feathered due to loss of oil from a ruptured oil hose between the oil pump & filter. The rt eng was not developing full power because of an…NTSB ATL86MA080Accident · 1 fatalMajor investigationFinal reportBeech G18S · Copperhill, TNThe plt was alerted at 0100 for 0200 flt fm kenosha to milwaukee, WI to pick up cargo for a flt to atlanta, GA. At 0310,the acft deptd milwaukee in VFR. En route, the plt obtained wx & an IFR clnc. Some of his rdo xmsns were not standard. At 0433, he complied…NTSB SEA86LA065Accident · No injuriesLimited investigationFinal reportCessna 206G · Icy Point, AKA precautionary landing was made due to deteriorating weather. Landing was accomplished onto a frozen slough. During touch down during high gusty crosswinds the aircraft veered right with the right gear breaking through the ice. The aircraft bounced up onto…NTSB SEA86LA063Accident · No injuriesLimited investigationFinal reportNavion A · White Salmon, WADuring IFR cruise, a loss of power occurred. The pilot complied with emergency procedures for power loss but when he reached down to switch the fuel tank selector he lost control of the aircraft and entered into a nose down unusual attitude, descending at the…NTSB SEA86LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Odessa, WADuring an external load operation to remove groundwire off crossarms, the cable splice jammed in the pulley frame. The helicopters forward motion stopped and it then struck the ground. The pilot said the cargo hook release didn't work but no failures were…NTSB MKC86LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Alliance, NEThe plt had just completed a biennial flight review in Alliance, Nebraska and was returning to land on his ranch property south of Alliance. Wind rpts fm the Alliance airport, and the FAA flight service station in scottsbluff, indicated winds generally fm the…NTSB MKC86LA062Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · St. Louis, MON111MM collided with trees during a night, circling app in IMC. The plt said he lost sight of the rwy momentarily during his turn to final. He rolled wings level and saw a tree ahead. As he rolled rt to avoid that tree his rt wing hit another tree. The acft…NTSB MIA86FA082Accident · Minor injuriesField investigationFinal reportPiper PA-44 · Panama City, FLThe air taxi flight had begun the instrument ILS approach and the pilot stated he obtained visual contact with the runway lighting system. He was starting to land when he lost all visual contact and initiated a missed approach. The aircraft then veered left…NTSB LAX86LA122Accident · Serious injuriesLimited investigationFinal reportHenley Aerodrome Fokker DR1 · Santa Ynez, CAA homebuilt aerodrome fokker DR1 crashed after takeoff. The acft had been in storage for over 5 yrs and had just completed an annual inspection. The flt was a post annual inspection test flt. The plt had extensive experience maintaining and flying homebuilt…NTSB DCA86AA018Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Erie, PADrg arrival, the crew of us air flt 499 lndd on rwy 24, which was cvrd with snw. Rprtdly, while lndg, the acft touched dwn aprx 1800 to 2000' bynd the displaced threshold. Altho armed, the spoilers did not auto-deploy, so the capt operatedthem manually. He…NTSB ATL86FA079Accident · 2 fatalField investigationFinal reportCessna 152 · Wilkesboro, NCShortly after midnight the acft was observed flying erratically over the town. IMC existed in the area at the time. The student plt did not have any instrument flight time logged and his pax was not a plt. The acft was in a descending turn when it flew into…NTSB SEA86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-15 · Mount St.Helens, WAThe pilot was attempting to fly inside a volcanic crater around the lava dome above 6000 feet m.s.l.. The aircraft has a 75 horsepower engine. High winds entering the crater from the northeast flowing across the lava dome created a downdraft that the aircraft…NTSB NYC86FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Andover, NJThe student plt had difficulty landing the acft and instructor had devoted training session to landing technique. The difficulty was reported to be a tendency to over-flare prior to touchdown. Satisfied the student had corrected his problem area, the third…NTSB LAX86LUG02Accident · 1 fatalFinal reportWhigham GW4A · Hemet, CADuring a tow operation, the plt of the tow plane stated that just after takeoff the glider assumed a very low tow position, then swung very high to the right then to the left. At aprx 250 ft AGL the glider plt released from the tow plane and executed a 180…NTSB LAX86LA121Accident · No injuriesLimited investigationFinal reportMooney MK-20 · Phoenix, AZA Mooney mk 20 collided with the runway surface after an engine failure. The engine failed on climb at about 1500 feet AGL and would not restart. The aircraft returned to the airport and landed downwind. The landing gear collapsed and the aircraft skidded off…NTSB FTW86LRG13Accident · No injuriesFinal reportRobinson R-22 · Austin, TXAcft was substantially damaged when it experienced a hard landing and severed the tailboom. Plt initially stated that the eng had 'missed' during pwr application at the bottom of a norm approach. Later he stated that he had been practicing touchdown…NTSB FTW86LRD07Accident · No injuriesFinal reportMBB BO-105-CBS · Lake Charles, LAThe helicopter was simulating a single eng landing on an area marked to the size of an offshore helideck. The acft touched down hard enough to attract the attention of several witnesses. The crew continued with the training but later on post flt exam they…NTSB FTW86LQG10Accident · No injuriesFinal reportPiper PA-22-150 · Skellytown, TXThe pilot stated that his take off roll was longer than expected. Reaching the end of the runway, he rotated & the acft left the ground, but it did not establish a good rate of climb. Subsequently, the acft collided with a pole & crashed. The takeoff was…NTSB DEN86LA082Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Meeker, CODuring the lift off the right skid toe of the helicopter caught a seismic cable which was covered by aprx 2 ft of snow. The plt stated he brought the acft to a hover after off loading 2 pax & started a right sideward hover. When the slack was out of the…NTSB DEN86FA080Accident · No injuriesField investigationFinal reportBoeing 737-300 · Denver, COF/o was on the 3rd initial operating experience flt with a check airman. Capt and f/o had discussed rapid rate of rotation on previous flts and again on accident flt. The f/o performed the takeoff from Denver and exceeded rotation rate of 3 degrees per sec.…NTSB ATL86FKG07Accident · Serious injuriesFinal reportPiper PA-28-180 · Statesboro, GAThe acft collided with the ground after encountering a downdraft over a wooded area at about 500 ft AGL. The plt reported that he flew out to overlook some land from the air. To avoid air traffic in the landing pattern he dropped down to about 550 ft and made…NTSB ATL86FA077Accident · 1 fatalField investigationFinal reportCessna 182P · Elyria, OHThe plt was cleared for and executed a rwy 17 ILS apch at night. Prior to beginning the apch he was informed that vis was 1/8 mile. Minimum for the apch was 1/2 mile. At the middle marker the plt rated pax in the right seat told the PIC that the rwy was not…NTSB ANC86LA030Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Delta Junction, AKThe aircraft struck a telephone pole guide wire while maneuvering at a low altitude. The electric company stated that the guide wire was 32 feet above the road surface. The pilot stated that he was low flying less than 50 feet above the ground to review…NTSB SEA86LA060Accident · No injuriesLimited investigationFinal reportCessna 340 · Burns, ORThe aircraft encountered airframe icing on a descent for a VOR approach. 1/8 to 1/4 inch of ice was present during landing. The pilot allowed a stall to occur prior to touch down with a hard landing resulting.NTSB MIA86FA081Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Auburndale, FLThe plt stated that just after passing lakeland, FL, his eng RPM began to fluctuate. He selected his aux fuel tanks but the RPM continued to deteriorate. He elected to make his forced landing on a small lake but not having enough alt to turn & land into the…NTSB FTW86FQG09Accident · No injuriesFinal reportAir Tractor AT-400A · Hereford, TXThe plt reptd that as he was returning to the arpt, the eng lost power from a 'low fuel and/or rough Air' condition. Subsequently, the acft was damaged when it was landed on uneven terrain near a creek. Less than 1 gal of fuel was remaining in the acft. The…