Major NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch') 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 WHERE (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 DCA86AA041Accident · 82 fatalClass 1Final reportMcDonnell Douglas DC-9-32 · Cerritos, CAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/07. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB DEN86MA241Accident · 7 fatalMajor investigationFinal reportCessna 441 · Lander, WYOn 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.…NTSB CHI86MA212Accident · 1 fatalMajor investigationFinal reportPiper PA-31-T1 · Montgomery, NYAfter canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he…NTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…NTSB MIA86MA217Accident · 1 fatalMajor investigationFinal reportDouglas DC-3 · Isla Verde, PRShortly after takeoff, the acft's climb performance bgn to deteriorate & the r eng started to overheat. Subsequently, the r eng was feathered & the crew attempted to return to the arpt. The radio transmitter bcm unintelligible, so the tower psnl cleared the…NTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…NTSB LAX86MA275Incident · No injuriesMajor investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)While ual flt 1 was cruising at FL 310, aprx 1.8 hr after takeoff, a flt attendant (f/a) rprtd a headache & lightheaded-ness. The flt climbed to FL 350, then another f/a & svrl pax rprtd similar symptoms. At that time, the tropopause was AT40,000'. As the flt…NTSB LAX86MA268Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Galveston, TXThe plt rprtd that while apchg an oil drilling platform for a lndg, he observed the main rotor blades go out of track about 8 to 10 inches. He also rprtd the helicopter developed a 1:1 vertical vibration. Drg the lndg, the helicopter entered into ground…NTSB DCA86AA028Accident · 25 fatalFinal reportde Havilland DHC-6-300 · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…NTSB MIA86MA182Accident · 2 fatalMajor investigationFinal reportHughes 369HE · Jacksonville, FLA LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft…NTSB NYC86MA148Accident · 4 fatalMajor investigationFinal reportSikorsky S-76B · Sutton, MAAbout 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the…NTSB FTW86MA097Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Bartlett, TXAbout 6 min after takeoff, at 2138:31 CDT, the plt rprtd level at 9000 ft MSL. At 2140:17, he transmitted that he had trouble & said he could not control or disconnect the autopilot (a/p) which was causing the acft to descend. At 2141:14,he stated he was…NTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…NTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…NTSB DEN86MA129Accident · 6 fatalMajor investigationFinal reportGulfstream 690D · Price, UTAt 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…NTSB FTW86MA074Accident · Serious injuriesMajor investigationFinal reportCessna 310Q · Houston, TXDrg ngt visual apch, plt enctrd dtrtg wx, got vectors for ILS rwy 8 apch, was clrd for apch at 0511 CDT. On final apch, he noted his #1 & #2 ils's giving erratic LOC & g/s info (but functioning) & that his LOC course deviation info didn't agree with adf, but…NTSB LAX86MA186Accident · No injuriesMajor investigationFinal reportLTV Aerospace Industries A7E · Warner Springs, CAA rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating…NTSB ATL86MA114Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Holliston, MAThe Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a…NTSB FTW86MA058Accident · 7 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Redwater, TXAirplane crashed during a uncontrolled descent, following a turbulence upset at FL370. The upset occurred as a result of clr air turb associated with a vip lvl 6 thunderstorm located within 7 miles of the last pos of the airplane. After the upset, the…NTSB LAX86MA161Incident · No injuriesMajor investigationFinal reportBoeing 767-222 · San Fransisco, CAWhile climbing through 3000 feet AGL, during the initial climb phase of the flight, both engines flamed out. The crew was able to restart both engines and return to the airport of departure for an uneventful landing.NTSB LAX86MA151Incident · No injuriesMajor investigationFinal reportBoeing 727-231 · Cincinnati, OHIndianapolis ctr (ctlr-a) clrd sluff 11 (S-11), a flt of 4 ANG A-7'S, to clb to FL210. Later, ctlr-a told S-11 to chg freq (to york low sector, ctlr-b). S-11 chgd freq, but neither S-11 nor ctlr-b established rdo contact with each other until S-11 had contd…NTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…NTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…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 ANC86MA027Accident · 3 fatalMajor investigationFinal reportCessna 207 · Nome, AKThe acft departed during a break in the wx after having waited for a special VFR departure. His departure radio call was the last communication from the flt. The wx remained marginal with icing in the clouds and freezing drizzle. The acft was on a flt to…NTSB CHI86MA071Accident · 3 fatalMajor investigationFinal reportBell 206B · Ellendale, MNThe purpose of the flt was to take a news crew to a location to cover a story. The news crew had attempted to hire another helicopter, but that operator refused due to forcast low visibility. This plt, however, agreed to fly. Altho he was certified for…NTSB DEN86MA061Accident · 5 fatalMajor investigationFinal reportCessna 425 · Granby, CODrg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility…NTSB MIA86MA057Accident · 2 fatalMajor investigationFinal reportPiper PA-31T · Jacksonville, FLWhile being vectored for an ILS rwy 7 apch, the plt was told to maint 3000' & advised he was flwg a Boeing 727. The min apch alt bfr intercepting the ILS glide slope (g/s) at the final apch fix/outer marker (om) was 1900'. As the acft was apchg the om, the…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 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 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 LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…NTSB CHI86MA052Accident · 6 fatalMajor investigationFinal reportCessna 177B · Brooklyn, MIThe pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…NTSB CHI86MA047Accident · 5 fatalMajor investigationFinal reportBeech B-60 · Carp Lake, MIDrg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At…NTSB LAX86MA050Accident · 1 fatalMajor investigationFinal reportBell 206L-1 · San Pedro, CATwo Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,…NTSB MKC86MA031Accident · 7 fatalMajor investigationFinal reportRockwell 500-S · Des Moines, IAN81589 was flwg a Boeing 727 on ILS apch in IFR conds. Aprx 2.5 mi fm rwy, N81589 suddenly deviated left nrly 90 deg. 39 sec later, plt rprtd he enctrd svr turbc, then said he was trying to clb. N81589 subsequently flew thru tree tops on rising trrn for aprx…NTSB MIA86MA032Accident · 6 fatalMajor investigationFinal reportBeech 58 · Boca Raton, FLAccording to witnesses, the plt took off on rwy 4, then turned left toward the southwest & flew parallel with the rwy at a distance of about 1/4 to 1/2 mi. He leveled the acft at aprx 200' AGL, just below the clouds, until aprx abeam of midfield, then he…NTSB CHI86MA025Accident · 5 fatalMajor investigationFinal reportCessna 441 · Derry, PADrg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…NTSB DCA86AA004Accident · 6 fatalFinal reportDassault Falcon 50 · Fairview, NJDassalt falcon 50 (D50), N784B, was on vor/dme-a apch at dusk to circle/lnd at teterboro (teb), as Piper PA-28, N1977H, was transiting arpt traffic area (ata) fm west to east at 1500' in VFR (no flt pln). PA-28 plt was clrd thru ata by teb twr (staying blo…NTSB ATL86MA011Accident · 2 fatalMajor investigationFinal reportBeech 58P · Forsyth, GAThe flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to…NTSB FTW86MA018Accident · 2 fatalMajor investigationFinal reportBell 222UT · East CameronThree pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a…NTSB SEA86MA018Accident · 4 fatalMajor investigationFinal reportGates Learjet 24D · Juneau, AKDrg arrival to pick up a med-evac patient, the flt was clrd for an LDA-1 rwy 8 apch via the asort transition. Thus, the plt should have contd se on J-541 twd the ssr VORTAC & intercepted the localizer (LOC) at asort; then track inbnd on theloc (062 deg),…NTSB MIA86MA013Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-51 · Tampa, FLShortly after lift-off, the flt crew heard a loud noise (similar, but louder than a tire blow-out) as the #1 eng failed. They secured the #1 eng, remained in the traffic pattern & landed on the same rwy. After landing, an exam revealed the combustion chamber…NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…NTSB FTW86MA001Accident · 5 fatalMajor investigationFinal reportCessna 441 · Dallas, TXA student plt in a Cessna 152, N5522L, had deptd redbird arpt at Dallas. He was practicing solo maneuvers in a privatelydesignated practice area that overlapped the extended inbnd course to rwys 31L & r at love field. At the same time, a Cessna 441, N400BG,…NTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…NTSB ANC85MA183Accident · Minor injuriesMajor investigationFinal reportBoeing 737-2X6C · Unalaska, AKAcft was dispatched to rstrctd arpt with a 3900' rwy & notamed: 3' stndg wtr on north end of rwy. SIGMET was in effect for mod to svr turbc blo 10,000' due to strong low lvl wnd & assoc wndshear. Capt made a shallow ovrwtr apch to rwy 12, which had a nr vert…NTSB DCA85AA037Accident · 14 fatalFinal reportBeech B99 · Grottoes, VAAcft arr fm the NE, crossed ovr the arpt in IMC conds & contd twd the sw to the initial apch fix (iaf) for an ILS rwy 4 apch. The iaf was ovr the outer marker (om), 4.2 mi sw of the arpt. As the acft deptd the iaf, it contd outbnd twd the sw on an imprecise…NTSB ATL85MA282Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Auburn, ALDrg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion…