Major NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 ATL85MA275Accident · 6 fatalMajor investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Eva, ALDrg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd . . .' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…NTSB DCA85AA036Accident · 31 fatalFinal reportDouglas DC-9-14 · Milwaukee, WIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. 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 Drg…NTSB DCA85AA035Accident · 8 fatalFinal reportBeech 99 · Auburn, MEDrg arr, aprx 12 mi south of the final apch fix (faf), flt 1808 was clrd for an ILS rwy 4 apch. Aprx 3 min later, ATC controller (ctlr) noted acft was tracking east of the localizer (LOC) course. He asked if the flt was rcvg the ILS LOC. Capt replied 'not yet…NTSB ANC85MA157Accident · 3 fatalMajor investigationFinal reportGates Learjet 24D · Gulkana, AKDuring a night arrival, the flt was on an instrument apch to the Gulkana arpt when radio contact with the acft was lost. A search was initiated & the wreckage was found 7.4 mi north of the terminal VOR on the 330 deg radial. The inbound course for the VOR rwy…NTSB FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…NTSB DCA85AA031Accident · 135 fatalFinal reportLockheed L-1011-385-1 · Dallas/Ft Worth, TXThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. 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 Psbl…NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB ATL85MA177Accident · 2 fatalMajor investigationFinal reportGulfstream G-159 · Nashville, TNThe acft was being operated as general aviation flt 115 & was deptg on a routine night flt. Drg takeoff/initial climb, the left eng lost pwr. The flt crew attempted to cont the climb-out, but following the application of water-methanol, the plt lost drctnl…NTSB CHI85MA169Accident · 7 fatalMajor investigationFinal reportCessna 310R · St James, MIDuring a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…NTSB DCA85AA015Accident · Serious injuriesFinal reportBoeing 747 SP-09 · San Francisco, CAWhile abv a cloud layer (top at FL 370) nr the jet stream, autoplt was engaged & was in the performance mngmnt sys (pms)mode. The pms provided pitch guidance to hold FL 410, roll guidance to ailerons & spoilers for roll ctl & autothrottle to maint .85 mach…NTSB CHI85MA100Accident · Serious injuriesMajor investigationFinal reportSwearingen SA-227 · London, KYDrg arrival, at 0540:31, the capt was clrd for an RNAV rwy 5 apch & was told to contact London fss on 121.6 mhz, 'now.' However, he did not make the radio call until aprx 3 min later. The acft broke out of the wx at about 1000' & 1 mi fm the arpt (before the…NTSB ATL85MA083Accident · No injuriesMajor investigationFinal reportLockheed 188C · Dobbins Afb, GADuring gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…NTSB MIA85MA064Accident · 6 fatalMajor investigationFinal reportPiper PA-32R-301 · Bradley, FLThe plt completed a 30 min insurance check flt, then loaded the acft with baggage/pax & departed decauter, IL on a flt to naples, FL. A refueling stop was made at columbus, GA. At 1750 the acft departed columbus & cruised uneventfully until sometime after…NTSB DCA85AA004Accident · 13 fatalFinal reportEmbraer EMB-110P1 · Jacksonville, FLProvincetown-boston airlines flt 1039, an Embraer EMB-110P1, was cleared to takeoff on rwy 31 at 1812 EST. Drg the initial climb nr the departure end of the rwy, the capt routinely acknowledged an instrn to contact dep control (ctl). Shortly thereafter, the…NTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…NTSB LAX85MA012Accident · 3 fatalMajor investigationFinal reportBell 206B · Riverside, CAThe acft departed fullerton, CA (elev 96') at O958 PDT on a flt to big bear, CA (elev 6750'). There was no record of the plt obtaining a wx briefing. At aprx 1015, a witness heard the helicopter circling above the bottom of 'an early morning fog hanging over…NTSB LAX85MA008Accident · 3 fatalMajor investigationFinal reportGates Learjet 24B · San Francisco, CAThe acft, a Gates lear jet 24B, modified by a howard/raisebach mark ii conversion, was cleared for takeoff on rwy 28L. Tower psnl estimated that the acft rotated for takeoff at 3200' down the rwy & was at aprx 200' AGL when the plt was instructed to contact…NTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…NTSB DEN84MA266Accident · 4 fatalMajor investigationFinal reportAero Commander 690 · Little America, WYAbout 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…NTSB DCA84AA034Accident · 17 fatalClass 1Final reportBeech C-99 · San Luis Obispo, CAAt about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…NTSB NYC84MA270Accident · 1 fatalMajor investigationFinal reportSikorsky S-76A · Fort Dix, NJThe aircrew of the helicopter contacted mcguire rapcon & obtained clearance to proceed thru the mcguire afb control zone at 1500 ft. a short time later, the crew declared an emergency. Witnesses on the ground heard a loud 'bang' & observed the helicopter…NTSB DCA84AA033Accident · 9 fatalFinal reportBritten-Norman BN-2A Islander · Vieques, PRA witness reported he heard an apparent eng problem after the acft took off & began a left turn for a x-wind departure. Reportedly, the acft oscillated, then after regaining some lost alt, it banked abruptly to the left, nosed down, & subsequently, crashed in…NTSB DEN84MA247Accident · 3 fatalMajor investigationFinal reportCessna 421C · Fort Lupton, CODuring a preflt wx briefing, the plt was advised of thunderstorms & intense rain showers on the route of flt. However, he filed an IFR flt plan & took off. During flt, the ATC controller advised the plt of a level 6 cell ahead & noted that he had no report on…NTSB LAX84MA392Accident · 6 fatalMajor investigationFinal reportPiper PA-31T · Concord, CAThe Piper PA-31T was a foreign registered acft (federal republic of germany). The owner/plt in the left front seat held a german commercial certificate with airplane instrument, single eng land & multi-eng land ratings. The plt in the right front seat held an…NTSB ATL84MA208Accident · 5 fatalMajor investigationFinal reportPiper PA-32-300 · Canton, GAThe acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…NTSB CHI84MA249Accident · 4 fatalMajor investigationFinal reportCessna 340A · Cincinnati, OHPlt requested fuel from FBO but failed to make it clear what type he wanted. The FBO personnel misunderstood the plt's request and refueled the acft with 'jet a' instead of aviation grade gasoline. The plt did not monitor the refueling process and failed to…NTSB DCA84AA027Accident · 3 fatalFinal reportLearjet 23A · Windsor Locks, CTAccording to witnesses, the acft made a normal apch to rwy 33 with no apparent abnormalities. However, when it was about 200 ft over the apch lights, they heard an increase in the eng thrust & the acft's descent stopped. Two plt witnesses thought the aircrew…NTSB DCA84AA025Accident · No injuriesFinal reportBoeing 727-222 · Denver, COBefore takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…NTSB NYC84MA151Accident · 2 fatalMajor investigationFinal reportPiper PA-60-601P · Cockeysville, MDOn the day of departure the plt had received a 30 min familiarization flt upon completion of the superstar conversion. Emphasis was directed to eng gages, fuel flow & counter, & power settings. The flt was flown at 5,500 ft. the plt then obtained a wx…NTSB ATL84MA148Accident · 6 fatalMajor investigationFinal reportPiper PA-34-220T · Mt Airy, GADrg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…NTSB ATL84MA114Accident · 6 fatalMajor investigationFinal reportCessna 421B · Cullman, ALPlt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west…NTSB NYC84MA102Accident · 3 fatalMajor investigationFinal reportPiper PA-31 · Cumberland, MDApprox 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy…NTSB DCA84AA018Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Jamaica, NYDuring an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…NTSB ANC84MA037Accident · No injuriesMajor investigationFinal reportEmbraer EM-110P1 · Cordova, AKDuring a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…NTSB ATL84MA101Accident · 4 fatalMajor investigationFinal reportBeech V35B · Charlottesville, VAWhile proceeding on an IFR flt plan, the plt requested he be assigned an alt below 8000 ft due to 'a passenger with an ear problem.' Otherwise, the en route portion of the flt proceeded without incident. During arrival, the plt was cleared for an ILS apch to…NTSB DCA84AA014Accident · Serious injuriesFinal reportFokker F27-100 · Jamaica, NYDuring the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…NTSB MKC84MA060Accident · 1 fatalMajor investigationFinal reportDouglas DC-3C · St. Louis, MOAfter landing, the plt-in-command (PIC) placed a refueling order to fill the acft's two 210 gal main tanks for a return flt to toronto, ontario, Canada. After the cargo was unloaded & the acft was refueled, the aircrew aborted the 1st 2 attempts to takeoff…NTSB DCA84AA013Accident · Serious injuriesFinal reportMcDonnell Douglas DC-10-30CF · Anchorage, AKA Piper PA-31, N35206, (south central air flt 59) was cleared to taxi to rwy 6L. The wx at that time was foggy with about 1/8 mi vsiibility, but the RVR was improving & the arpt was expected soon to be acceptable for takeoffs. The PA-31 crew taxied & waited…NTSB ATL84MA063Accident · 4 fatalMajor investigationFinal reportPiper PA-34-200T · Lawrenceburg, TNDuring the descent at Lawrenceburg the acft went into clouds at 3500 ft. at 1709 the acft was cleared for an NDB approach. Minimum alt for the approach is 1560 ft. field elevation is 936 ft. the acft was being tracked on radar and the last contact was about…NTSB ATL84MA052Accident · 4 fatalMajor investigationFinal reportBeech 58TC · Knoxville, TNDuring arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported…NTSB FTW84MA076Accident · 8 fatalMajor investigationFinal reportBeech B100 · Midland, TXThe acft crashed while completing a charter flt that began at 1220 CST on 11/25/83 to transport a tv sports film crew. The flt began at Midland, TX & proceeded to fort worth & wichita falls, TX, then began a return flt to Midland. During arrival, the plt…NTSB DCA84AA008Accident · Serious injuriesFinal reportLockheed L-1011 · Charleston, SCDuring flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of…NTSB FTW84MA069Accident · 4 fatalMajor investigationFinal reportCessna 210N · El Paso, TXN4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The…NTSB SEA84MA016Accident · 4 fatalMajor investigationFinal reportde Havilland DHC-2 · Challis, IDThe plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the…NTSB DCA84AA005Accident · No injuriesFinal reportDouglas DC-8-63F · Norfolk, VADuring arrival at nas Norfolk, the aircrew were vectored for a gca apch to rwy 10. They were advised that the wx was 200 ft scattered, 600 ft overcast, visibility 1 mi with rain, wind was from 360 deg at 20 KTS. Also, they were given a PIREP of 'heavy…NTSB DCA83AA036Accident · 11 fatalFinal reportLockheed Learstar, L-18-56 · Silvana, WAThe acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…NTSB DCA83AA034Accident · 10 fatalFinal reportPiper PA-31-350 · Peach Springs, AZThe acft departed las vegas, NV as the 2nd of 5 acft on a scheduled grand canyon sight-seeing flt. The 1st portion of the flt was over the las vegas strip area & lake mead & was uneventful. However, wx conditions precluded the plt from continuing over the…NTSB DCA83AA028Accident · 23 fatalFinal reportDouglas DC-9-32 · Covington, KYThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/02. 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 MIA83AA136Incident · No injuriesFinal reportLockheed L-1011 · Miami, FLThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-84/04. 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…NTSB DCA83AA023Accident · 2 fatalFinal reportGates Learjet 25 · Newark, NJThe acft was on a ngt check courier flt. During arrival, the indicated airspeed was well above the legal limit of 250 ktfor flt below 10,000 ft. rwy 4R was selected for landing after the crew were advised that their original choice (rwy 11)was noise…