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 ATL86FA049Accident · 1 fatalField investigationFinal reportCessna 177RG · Hazard, KYThe plt called the arpt on UNICOM and asked how to find the arpt, stated that he needed fuel and asked if fuel was available. He was given directions and asked if he had landed there before. He replied no, and inquired about the traffic pattern. It was…NTSB MIA86FA055Accident · 2 fatalField investigationFinal reportCessna 210L · Lake City, FLPrior to departure on a VFR flight from Florida to Michigan the non-instrument rated plt did not obtain a weather briefing. 53 minutes after departure the pilot contacted jacksonville ARTCC and reported he had flown VFR into the clouds and was having trouble…NTSB FTW86FRD04Accident · No injuriesFinal reportCessna 150J · Belle Chasse, LAThe acft nosed over during a forced landing following a loss of power. The flt was begun an hour before the acc with the intention of staying in local area. The wx was minimal VMC at the time of takeoff and suddenly became IMC when fog rolled in. The plt was…NTSB DEN86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · West Fargo, NDAccording to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt.NTSB ATL86FA055Accident · 2 fatalField investigationFinal reportCessna T337B · Talladega, ALThe acft collided with trees during the final approach to landing. The light conditions were dark, skies were clear and winds were calm. Prior to the accident, the plt had landed and visited the FBO from where the acft was recently purchased to correct some…NTSB NYC86FA057Accident · 2 fatalField investigationFinal reportCessna 182L · So.Glastonbury, CTThe acft was on a VOR instrument apch when it collided with 250 ft high terrain approx 6 miles south of the arpt and approx 2 miles north of the vor/faf. Shortly before the accident the pilot notified ATC that he was in turbulence; then reported he was clear…NTSB MIA86WA056Accident · No injuriesForeign investigationCessna T210N · St. Maarten, NTNTSB LAX86FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CADrg arrival at an arpt near his home, the plt contacted apch control (ctl) & asked the ctlr for assistance in landing & said that the wx looked a little foggy. The ctlr informed the plt of the acft's position in relation to the arpt. As the acft was dscndg…NTSB FTW86MA030Incident · No injuriesMajor investigationFinal reportBoeing 737-2H4 · Dallas, TXThis incident occurred when the no. 2 engine experienced an aft engine mount cone bolt failure and the subsequent failure of the secondary support link (stainless steel cable). The failure of both aft engine support assemblies during the takeoff roll allowed…NTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…NTSB CHI86MA056Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIN101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step…NTSB CHI86LA057Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Indianapolis, INOn the second approach to rwy 22R the private pilot (in the left seat) attempted to land. The right main gear hit hard and the acft bounced coming down on the left wing tip. The acft then hit on its right main gear, then the left main gear. The right main…NTSB ATL86LA052Accident · No injuriesLimited investigationFinal reportCessna 150M · Whiteville, NCThe student plt had moved the aircraft closer to the terminal about 15 minutes prior to this attempted start. He tried several times but it would not start. The plt then primed the eng several times. His wife shouted to him that the aircraft was on fire. His…NTSB MKC86LA043Accident · No injuriesLimited investigationFinal reportCessna 172N · Kansas City, MOThe pilot had been at this airport 31 times since 1979. During his taxi to takeoff for a night flight, he mistook a service road for a taxiway. He taxied past one sign without seeing it but struck the second one. This is the third documented accident at this…NTSB MIA86LA054Accident · No injuriesLimited investigationFinal reportCessna 150L · Boca Raton, FLThe plt stated that while enroute to ft. lauderdale executive arpt his eng began to run rough. He made a forced landing in a field & on landing rollout, the nose gear collapsed. Post crash examination of the eng revealed that the #1 intake valve was stuck in…NTSB MIA86FA053Accident · 1 fatalField investigationFinal reportCessna 172M · St. Marys, GADrg a ngt x-country flt, the non-instrument rated plt contacted apch control & rprtd he was 'sort of lost in the fog.' He obtained wx info & elected to divert to waycross, GA. Shortly thereafter, the acft collided with trees on uneven terrain & crashed.…NTSB LAX86LA103Accident · No injuriesLimited investigationFinal reportCessna T210N · Tucson, AZThe plt planned to fly nonstop fm houston, TX, to phoenix, AZ. He reported that during the trip he encountered 'fluctuating head winds' & he miscalculated the acft's endurance. Fuel exhaustion occurred 8 miles fm Tucson, AZ., & the plt made a successful…NTSB FTW86FPA13Accident · No injuriesFinal reportBeech E18S · Terrell, TXThe plt reported the acft yawed left on takeoff and despite attempted remedial action the acft would not clear odstaclesalong the flt path. Pwr was reduced and a straight in landing was made in a fld aprx 1/4 mile north of the rwy. A witness reported the acft…NTSB MKC86LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Olathe, KSThe pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He…NTSB MIA86IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe plt stated that while making touch & go landing, after his third takeoff, the rt eng lost power & the acft began to drift right, he pulled the power off & landed gear up in the grass on the right side of rwy 08. Post crash examination of the right eng…NTSB LAX86LA078Accident · 1 fatalLimited investigationFinal reportCessna R172K · Kamuela, HIThe acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…NTSB FTW86LQG07Accident · Serious injuriesFinal reportRaven Rally RX-7 · Lockney, TXThe student pilot stated that he did not checked the wind forecast when he called for a weather briefing about four hours before the accident. The surface winds increased to 30 gusting 40 KTS while he was airborne. He reported that when he landed, he was not…NTSB DEN86LA059Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Alamogordo, NMUpon returning to the arpt, the plt decided to make a fly-by. The plt reported that while on a modified downwind at an alt of aprx 50 ft AGL, the glider which he was piloting encountered adverse winds and downdrafts. Control of the acft was lost and it…NTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…NTSB DEN86LA058Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Columbus, NMAccording to the plt, after performing the preflight engine runup, he leaned the mixture control and switched the fuel selector to both tanks. Shortly after takeoff at approximately 50 ft AGL, the eng lost partial pwr. The plt made a forced landing following…NTSB DCA86AA012Accident · 7 fatalFinal reportDouglas DC-3 · Dekalb, TXAt 1708:48, while cruising at 6000', a pilot of N711Y advised ATC, 'I think I'd like to turn around, head for texarkana here, I've got a little problem.' He was provided a vector & advised of closest airports. Shortly after, he stated he would be unable to…NTSB CHI86LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · Grygla, MNThe aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…NTSB SEA86FA034Accident · 2 fatalField investigationFinal reportStinson 108 · Hoquiam, WAThe acft contacted terrain 680 ft north of rwy 06 at bowerman airfield. The acft departed elma arpt, ocean shores, WA, sometime around 2330 PST, on 12-29-85. Prior to the departure the passenger stated to persons they were waiting for the fog to clear for…NTSB SEA86FA033Accident · 4 fatalField investigationFinal reportMooney M20K · Des Moines, WAThe weather briefer informed the pilot that VFR was not recommended due to current/forecast condtions. The non instrument rated pilot then filed a VFR flight plan responding that he was IFR rated and would file inflight if necessary. Witnesses reported…NTSB MKC86LA040Accident · No injuriesLimited investigationFinal reportBeech C23 · Dubuque, IAThe aircraft landed on runway 13 because the n-s runway was covered with ice. The wind was from 220 degrees at 16, gusts to 24 knots. The aircraft bounced twice during the landing and drifted left. The aircraft encountered snow along the left side of the…NTSB MKC86LA039Accident · No injuriesLimited investigationFinal reportCessna 182RG · Wentzville, MOThe pilot stated that he winds were calm when he made the tou long, on the runway, attempted a go around and ran off the end of the runway into a field when the airplanefailed to get airborne.NTSB MIA86LA051Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, FLThe pilot stated that he had started the flight at about 1000 EST from miami, FL and had planned on landing at Madison county airport. As he flew overhead he noted an airstrip with county vehicles parked nearby. He landed and was informed that it was local…NTSB FTW86FA028Accident · 2 fatalField investigationFinal reportBeech B33 · Arlington, TXInspite of an adverse weather forecast, the non-instrument rated pilot took off into pre-dawn fog and low ceilings. The acft impacted the ground in a steep descending turn after being observed maneuvering at a low altitude. No eng, airframe, or instrument…NTSB DEN86FA232Accident · 2 fatalField investigationFinal reportCessna T210L · Salina, UTThe non-instrument rated plt did not obtain a wx briefing nor file a flight plan. He and his wife took off from bullfrog basin airport, glen canyon, UT, en route to heber city, UT, on 12-30-85. Acft did not arrive. Civil air patrol search was conducted from…NTSB CHI86LA059Accident · No injuriesLimited investigationFinal reportCessna 180J · Hibbing, MNThe plt landing in a direct 90 deg x-wind, lost directional control, struck a snowbank and nosed over inverted.NTSB CHI86FEI01Accident · Minor injuriesFinal reportMonnet Moni · Perry, OHAfter initiating a 180 deg turn, the plt heard a 'thump' and noted a low vibration. The acft then pitched down abruptly and entered an inverted spin to ground contact. The plt stated an in flight structural failure of the tail section had occurred which…NTSB ATL86IA051Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300 B4-203 · Atlanta, GADuring takeoff initial climb the aircraft experienced an uncontained failure of the no 1 engine. The pilot returned to the airport and landed without further incident. Post incident examination disclosed four broken turbine mid frame strut studs. The fracture…NTSB NYC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Frankfort, NYThe plt diverted to Frankfort-highland en route from his original destination of utica, NY, because of IFR weather at utica. The plt stated that as the nose wheel settled to the rwy during touchdown, it dug into snow on the rwy and the acft nosed over. It was…NTSB MIA86LA049Accident · Minor injuriesLimited investigationFinal reportBeech B-35-P · Lake Wales, FLThe private pilot stated that during takeoff from a wet sod field he rotated prematurely and the aircraft stalled. The aircraft then mushed and crashed causing minor injuries to one passenger.NTSB LAX86FA077Accident · 2 fatalField investigationFinal reportCessna T210N · Hyder, AZWitnesses observed the acft depart the ranch airstrip, level off at about 200 ft AGL & make a turn back over the ranch house. The acft occupants were seen to wave to the people on the ground as the acft began an abrupt climbing turn. The witnesses then saw…NTSB FTW86LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-325 · Junction, TXDuring initial climb after takeoff the pilot noticed oil streaming out from the oil filler access door on the right engine cowling. He elected to continue climbing and make a tear drop turn back to the airport and land in the opposite direction from which he…NTSB DEN86LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Broomfield, COThe acft drifted off the runway during the flare/touchdown phase of ldg due to plt failure to correct for a 20 kt xwind condition. The plt attempted to make a go-around at a low a/s and with ldg flaps (25 degrees) extended, resulting in loss of control and…NTSB DEN86FA056Accident · 6 fatalField investigationFinal reportCessna T210L · West Valley, UTDuring apch to rwy 34L, the rt horizontal stab, elevators and wings separated in-flt. Investigation revealed the plt was not instr current. Ntap data revealed N2082S at an alt of 7,400 ft and 203 KTS grnd speed at outer marker. The mca at the marker is 6,100…NTSB CHI86LA054Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNThe aircraft collided with a snowbank while goundlooping after landing at the completion of a cargo flight from chicago ill. The winds were calm. The pilot stated that he needed to take timely and sufficient action.NTSB BFO86FA011Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Westminster, MDThe student pilot was flying in a flight of three returning from having lunch at a nearby airport. The first pilot made a go-around after bouncing during touchdown on the downhill 1830 foot long by 30 foot wide airstrip. He then came aroundand made a…NTSB NYC86LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Ellington, CTWhile on apch for landing, about 50 ft from the rwy, the landing gear contacted a bridge and the acft bounced into the air. Pwr was added at this time and again the acft bounced. The acft was then landed on the rwy and it skidded to a stop. The plt stated she…NTSB NYC86LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Marlboro, NJThe acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,…NTSB MIA86MA048Incident · No injuriesMajor investigationFinal reportBoeing 727-232 · Fort Lauderdale, FLAfter gear retraction drg takeoff, at aprx 150' AGL, the aircrew heard a loud noise & noted the #2 eng had failed. They secured the eng, dumped fuel & landed without further incident. An exam of the #2 eng revealed the combustion chamber outer case, pn…NTSB MIA86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, FLThe plt stated that while attempting to takeoff from a private airstrip his left main wheel hit a barbed wire fence causing the left wing to strike the ground & separate from the acft.NTSB LAX86LA076Accident · No injuriesLimited investigationFinal reportMooney M20F · San Manuel, AZDuring cruise at 10,500 ft MSL on a night x-country flt, the plt said the eng ran rough with moderate vibration levels. Plt declared an emergency with abq ARTCC, who vectored the acft to an unlighted airstrip. The plt said he had difficultyin seeing the rwy…