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 LAX84LA079Accident · 1 fatalLimited investigationFinal reportCessna 180 · Las Vegas, NVWhile on a x-country flt, the acft collided with the crest of a 10,000 ft mountain. Witnesses stated that the plt had circled in the area prior to the accident. The accident reportedly occurred at dusk, but witnesses said the area to the north of the site was…NTSB FTW84LA079Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Los Lunas, NMThis was to be the student's first flt & the CFI had him follow through on the controls. As the tail came off the rwy the student began overpowering the CFI at the controls. The CFI was unable to maintain directional control & the acft went off the rwy into a…NTSB DEN84FA039Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Moose, WYThe acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake…NTSB ATL84AA053Accident · 6 fatalFinal reportBeech A36 · Armuchee, GAThe acft collided with trees and higher terrain which was adjacent to the VOR approach path. The weather was described by witnesses as stormy with heavy rains and high winds. Some of the occupants of the accident acft were airsick according to the plts radio…NTSB NYC84LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlborough, MAThe acft collided with trees during final approach to land. The acft was on a short final to rwy 32 at marborough when the left wheel and left wing struck tree tops a short way from the rwy threshold. The acft turned about 70 degrees to the left and collided…NTSB NYC84FA039Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Wellsville, PAPrior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an…NTSB NYC84FA038Accident · 4 fatalField investigationFinal reportCessna 172P · Silver Greek, NYThe two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft…NTSB LAX84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Oceanside, CAThe acft collided with a fence during landing roll. The private plt receiving instruction in conventional gear acft was making his second landing. After rolling 150 ft the acft made a skidding right turn and veered off the right side of therwy. The CFI was…NTSB LAX84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Coalinga, CAWhile departing, the acft began veering left as the tailwheel came off the ground during the takeoff roll. It rolled onto a hard dirt shoulder to the left of the asphalt rwy. The plt reported that he corrected the drift by applying right rudder & the acft…NTSB LAX84LA078Accident · No injuriesLimited investigationFinal reportHughes 369D · Caliente, CAReportly, the plt had instructed the ground crew to place the external cable\slings in the cargo area of the helicopter. However, they connected the cable to the external hook. The plt was not aware of this & took off. After takeoff, the cable hit the tail…NTSB LAX84LA077Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Riverside, CAThe plt of a Cessna TU206F, N7320Z, stated that he advised other traffic of his position & intentions on the UNICOM freq as he entered a straight-in apch to rwy 24. At about the same time, the plt of a pitts special S-1, N20JK, had returned from a local flt &…NTSB LAX84LA076Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G-103 · California City, CAAccording to the plt, he was turning to final approach when the glider's left wing struck the ground. Reportedly, he had gotten 'too low & slow.'NTSB FTW84FA077Accident · 4 fatalField investigationFinal reportCessna 172L · Simpson, LAThe acft collided with the ground in a steep nose down altitude at a high rate of speed after the plt encounterd low ceiling and rain during a x-country flt. In attempting to fly IFR and follow radar vectors the non-instrument rated plt lost countrol of his…NTSB FTW83LA078Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Albuquerque, NMAfter transporting a patient & 2 crewmembers, the plt took off from a medical center helipad to obtain fuel at a nearby arpt. Shortly after departing, a partial loss of power was encountered. The plt started to land on a road, but saw a car & turned to avoid…NTSB CHI84IA052Incident · No injuriesIncident investigationFinal reportCessna 421B · Columbus, OHDuring approach to Columbus, the B-727 was vectored to a final for rwy 28L & the C-421 cleared for a visual to rwy 31 with instructions to 'land short of two eight left...' After contacting the tower the plt of the C-421 was twice clearedto land on rwy 31…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 ATL84FA054Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lexington, TNThe acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who…NTSB ANC84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fort Yukon, AKThe plt was approaching a lake for landing. He came over the lake & started what became a 270 deg turn toward the landing direction. At the end of the turn he tightened up the turn & the acft stalled.NTSB ANC84LA019Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Anchorage, AKThe eng quit after takeoff. The plt was able to return to the arpt but landed on a Piper super cub. Water was found in the carburetor & main fuel tank.NTSB SEA84FA023Accident · Serious injuriesField investigationFinal reportCessna 304A · Ephrata, WAThe acft collided with a hilltop during a missed approach in IMC weather. The acft was on an IFR flt plan. The plt stated visual contact was EST at about 2000 ft MSL but ground features were masked in snow. When the plt did not see the airport at the proper…NTSB MKC84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Russellville, ARAfter landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over.NTSB LAX84LA093Accident · No injuriesLimited investigationFinal reportBeech C24R · Monterey, CAFire erupted in the eng compartment during the eng run-up. Investigaiton revealed that 7 of the 8 nuts securing the exhaust manifold to the cylinders were missing. The only nut present was loose but retained the #1 cyl exhaust tube. The #2 cyl exhaust tube,…NTSB LAX84LA082Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Scottsdale, AZThe acft collided with a sign during a forced landing on a street. There was some damage to the right wing. The plt stated that he thought he had ample fuel for the flt. He also stated that the fueling facility was closed at the arpt at time of his departure.…NTSB LAX84LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Ocotillo Wells, CAThe plt reported that during arrival, he checked for the wind conditions & there appeared to be a light x-wing of appx 5 to 8 KTS. However, while on the landing roll, he encounter an unexpected wind that yawed the acft to the left. Subsequently, the acft…NTSB LAX84LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Redding, CAThe plt reported that when he tried to start the acft, the starter would not 'turn the eng.' Thinking that the oil had congealed, he exited the acft & 'pulled the prop.' At that time, the eng started & the plane began to move. The plt jumped on the right wing…NTSB LAX84LA070Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Temecula, CAThe plt reported that he had received wx info from the tv, but no wx report was obtained from flt service. When he took off on a sight-seeing flt at 0745 PST, the wind was calm. After takeoff, he flew at lower altitudes, then climbed & flew between 1200 &…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 FTW84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Portales, NMThe plt had made a successful landing in an unimproved wheat field. The acft had stopped & as the plt was making a 180 deg turn back the wind caught a wing causing the acft to nose over onto its back. The plt stated that during the turn the right main gear…NTSB CHI84LA066Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · La Porte, INThe acft veered off the rwy, hit a ditch and nosed over during takeoff. The plt reported that he lost control of the acft during the takeoff roll and it ran off the side of the rwy into an open field and nosed over.NTSB CHI84FA051Accident · 1 fatalField investigationFinal reportBeech V35B · Cairo, ILThe acft dove into the ground nose first from a 90 degree bank shortly after takeoff. The acft was observed by witnessesto take off slowly 'with about 1/2 power' being used. The climb was slow and at 300-400 ft the acft turned left with thelanding gear still…NTSB ATL84LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Jackson, MSThe acft ditched in a reservoir at night after a power loss. The plt was descending to land, in preparation for the landing the plt switched fuel tanks on the selector valve to what he thought was both tanks position. Shortly after thisthe engine quit. The…NTSB ATL84LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntington, WVAcft ballooned during the landing portion of a touch-&-go. The student added power & the acft stalled in a nose high attitude. The acft dropped to the rwy from about 10 ft.NTSB ATL84FA050Accident · Minor injuriesField investigationFinal reportCessna 182Q · Baltimore, MDThe acft crashed shortly after takeoff when the engine lost power during initial climb. This acft had not been flown forabout one month. The pilot was aware of water accumulation in C-182 bladder equipped acft, so he drained the gascolator for an added length…NTSB SEA84LA024Accident · No injuriesLimited investigationFinal reportCessna A150K Aerobat · Nr. Wrangell, AKThe acft nosed over during landing on a snow covered sand bar. The weather was VMC. The plt said he underestimated the depth of the snow and upon landing the nose gear collapsed and the acft nosed over.NTSB NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…NTSB MKC84LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Hampton, IAOn his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…NTSB LAX84LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Half Moon Bay, CAThe plt was taxiing to park when the right wing tip of his acft contacted the left wing tip of a Cessna 172RG, N6221R, that was parked beside the taxiway. According to the plt, the wing tip of the parked acft extended aprx 5 ft over the taxiway.NTSB LAX84LA072Accident · No injuriesLimited investigationFinal reportBensen B8M · Rocklin, CAThe plt was operating his home built, non-registered gyrocopter as an ultralight vehicle. Reportedly, the eng lost power during flt, and subsequently, the gyrocopter was damaged during a forced landing. According to the plt, he encountered carburetor icing…NTSB LAX84LA069Accident · No injuriesLimited investigationFinal reportCessna TU206E · Red Rock, AZThe acft taxied into a ditch after landing on a road at night. After the acft came to rest it was apparently intentionally burned. Sob & injuries are presumed. The landing site was marked by the placement of white cloths along the edges of the road. The acft…NTSB LAX84FA073Accident · Minor injuriesField investigationFinal reportBeech J-35 · Ontario, CAThe acft forced landed in a vineyard where the nose gear dug in and the acft nosed over. The flt stated that climbing through 5000 ft MSL the power went to idle and then to zero. All fuel tanks were filled prior to departure & the left main tank was selected…NTSB LAX84FA071Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Oceanside, CABefore takeoff, the plt received a wx briefing & was advised to expect IFR conditions in the vicinity of Oceanside, CA & that moderate turbulence existed below 20,000 ft. after takeoff, he obtained an IFR clearance to climb & cruise at 6000 ft. at about 2005…NTSB FTW84LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cisco, TXThe plt reported that while he was taxiing, after landing, he was focusing his attention on the radio, on the right side of the instrument panel, when the acft rolled off the rwy & into a ditch. During the occurrence, the nosewheel collapsed & the right wing…NTSB FTW84FA074Accident · 4 fatalField investigationFinal reportPiper PA-23 · Comfort, TXWitnesses stated that the acft barely cleared trees at the end of the arpt & that smoke was seen trailing from the righteng. The acft entered a right turn, stalled & impacted a ridge in a steep, near vertically banked dive. Teardowns of both engs & both props…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 CHI84LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Zanesville, OHAfter departing Zanesville, OH, the acft was at 2500 ft MSL when the eng began to 'knock'. The cockpit filed with smoke & the eng began to lose oil. The plt turned back to land at the arpt. He reported that the eng continued to run until the acft was about…NTSB ATL84LA055Accident · No injuriesLimited investigationFinal reportCessna T303 · Charlotte, NCDuring taxi for takeoff the pilot became disoriented and the acft collided with a ditch where construction of a new taxiway and old asphalt connected. The plt stated he could not determine the difference in the levels of the two surfaces. The taxiway was not…NTSB NYC84LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Great Pond, METhe plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see…NTSB ATL84FA058Accident · 2 fatalField investigationFinal reportCessna 414A · Waynesville, NCAfter departure at 1417 CST, radar track showed the acft climbing to & maintaining 7,600 ft until about 1733 EST & 28-30 mi north of the knoxville VOR. The acft then descended & crossed the snowbird VOR at about 6,700 ft. there were several up & down altitude…NTSB MIA84LA034Accident · No injuriesLimited investigationFinal reportCessna 402 · Miami, FLThe plt in command related that he had no experience in the Cessna 402 acft. He reported that while on a local test flt with the second plt, who was experienced flying the acft, the right eng malfunctioned. The co-plt climbed the acft to 500 ft AGL and the…NTSB FTW84FA075Accident · Serious injuriesField investigationFinal reportGulfstream Peregrine · El Reno, OKAt about 215 KTS the plt rolled the acft in order to evaluate newly installed ailerons. It had been noted earlier that a dead-band existed in the aileron neutral range that increased with airspeed. The plt stated that upon rollout the dead-band was stronger &…