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 ATL85FA020Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Vicksburg, MSDuring preflt, plt detected water in fuel sample. After takeoff, the engine began to run roughly and on crosswind leg lost power completely. Plt stated that on approach to forced landing, he intentionally struck a tree with the left wing to slow the acft.…NTSB LAX85LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Chandler, AZThe student plt started to retract the flaps during a touch-&-go landing with a CFI on board the acft. The acft veered and the CFI took control. During this time the student applied the brakes. The right main landing gear went into the dirt and the acft nosed…NTSB DEN85LTG02Accident · 1 fatalFinal reportPiper PA-38-112 · Berthold, NDThe student solo plt was on a cross-country flt and was appropriately endorsed. Impact occurred at aprx 80 degrees nose down. Wx in the vicinity of the accident was reported to be 300 ft ceilings with visibility of 1/4 mi in fog and rain.NTSB CHI85LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tecunseh, MIWhile on an aerial application flight, the plt noted a change in engine sound and a slight power loss. During turn to return to the airstrip for precautionary lndg, complete power loss occurred. A forced landing was executed in soft terrain. On lndg roll, the…NTSB CHI85LA026Accident · No injuriesLimited investigationFinal reportBeech G-18S · Belleville, MIAfter reaching 75 KTS on takeoff roll, the acft ground looped to the left, shearing the main landing gear in side overload. Plt stated left gear seemed to be dragging. Investigation revealed no evidence of pre-existing brake/wheel malfunction or failure.NTSB BFO85FA001Accident · 2 fatalField investigationFinal reportBeech 58 · Hot Springs, VAThe destn arpt was unattended at night & when the plt received his last wx briefing at 0519 CDT, no current wx info was available. During arrival, the acft was vectored for an ILS rwy 24 apch & the plt was advised that current wx info was still not available.…NTSB ATL85LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Griffin, GAThe acft ran off the side of the rwy during landing. The plt planned to do touch and go landings. On the 1st landing theacft veered to the right and rolled off the rwy. The plt added power but the acft went into a ditch. The student plts logbook was not…NTSB NYC85LA013Accident · 1 fatalLimited investigationFinal reportDe Havilland DHC-4 · Sable Island Ns, CanadaPlt ditched acft in atlantic ocean following a loss of power due to fuel exhaustion. Co-pilot stated they were aware of bad wx along the route but the plt was anxious to get to their destination. Headwinds encountered en route were stronger then expected.…NTSB MIA85LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Williston, FLThe left seat pilot stated that he was doing touch and go landings on runway 04. He continued to state that on the last landing he touched down on the runway, then added full power and retracted the flaps, but inadvertantly retracted the landing gear. The…NTSB DEN85FA019Accident · 1 fatalField investigationFinal reportCessna TR182RG · Milan, NMThe pilot departed farmington,NM in the early morning darkness en route to grants, NM. The airplane struck the rock face of a 8399-foot mesa at about the 8150-foot level. According to one local resident, weather at that time consisted of a low ceiling, poor…NTSB DEN85FA017Accident · Serious injuriesField investigationFinal reportCessna 414 · Cheyenne, WYThe acft collided with the ground during a turn to final from a circling approach (IFR) at Cheyenne airport. According to ATC, the acft was a VFR 'pop up' & was subsequently issued an IFR clearance for an approach into the airport. Examination of the acft at…NTSB CHI85LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNOn initial climb from takeoff, the plt noted the engine cowling was loose and vibratring. Plt initiated a shallow turn back for landing but preoccupation with the cowling caused him to allow the acft to enter a steep bank. During the plt's attempts to reduce…NTSB SEA85LA013Accident · No injuriesLimited investigationFinal reportPiper PA38 · Williams, ORPlt was flying 150 to 200 ft AGL at 80 to 85 mph. Upon pwr application to return to alt, plt stated, carburetor heat conrol was not returned to the 'off' position. Plt stated acft did not want to climb so pwr was removed and an attempt to fly under…NTSB NYC85LA012Accident · No injuriesLimited investigationFinal reportCessna 152II · Wappinger Falls, NYThe solo student plt stated that during the flare the acft drifted left toward the rwy lights. A go-around was initiated with power and the acft flew over the lights but collided with the unimproved grassy terrain, coming to rest aprx 30 ft left of the rwy.NTSB MIA85IA015Incident · No injuriesIncident investigationFinal reportMBB BO-105 · Orlando, FLThe purpose of the flt was to transport a 76 yr old patient, who was in critical condition. The flt was normal until it was on final apch to a 7th floor, rooftop, hospital heliport. During the apch, the plt attempted to increase the collective to slow the…NTSB MIA85FA016Accident · No injuriesField investigationFinal reportBell 47G-5A · Belle Glade, FLAcft wad parked with 3 ft clearance between main rotor and corner of hangar. Plt stated that on lift off a gust of wind blew acft toward hangar. Main rotor blades made contact. Ground crewman injured by flying debris.NTSB LAX85LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Palo Alto, CALoss of pwr occurred on final apch. Acft contacted a dike during forced landing collapsing the nose gear. Plt said direct route was flown at 10,500 ft MSL descending lower after crossing mountainous area. Plt did not lean mixture during flt or report which…NTSB ANC85LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAccording to the plt, when he arrived at the gravel bar the passengers to be picked up were not there & could not be located from the air. After making low passes over the gravel bar he determined that the snow did not look deep and touched down to check the…NTSB MIA85IA014Incident · No injuriesIncident investigationFinal reportBellanca 17-31A · Palm Coast, FLThe plt stated that while in cruise flt, the acft sustained a partial loss of power & he elected to land on a road. During the landing the lt wing hit a sign. Post crash investigation revealed that the magneto coils were heating up.NTSB LAX85FA030Accident · Serious injuriesField investigationFinal reportCessna 150M · Lee Vining, CAThe acft crashed into a mountain during a VFR x-country. The acft was approaching the mountain ridge on the lee side anddid not clear the top of the ridge. The plt said that when he saw the acft was not going to clear the ridge he lowered 10 degrees of flaps…NTSB FTW85LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bogalusa, LAThe solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy.NTSB DEN85IA016Incident · No injuriesIncident investigationFinal reportBeech 99A · Fort Morgan, COCaptain shutdown rt engine in-flight due to a surging and vibration problem. The aircraft was in moderate icing conditions at the time of the engine shutdown. The captain was unable to maintain altitude and an emergency landing was made in a corn field. Post…NTSB CHI85LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Berlin, WIThe plt stated that he attempted to takeoff from a grass strip that is priented north and south. He described the grass as being 'too long' and the wind was from the west. The plt over rotated the acft to raise the nose wheel clear of the grass and was unable…NTSB NYC85LA011Accident · No injuriesLimited investigationFinal reportCessna 206 · Menemsha, MADuring climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water.NTSB LAX85LA026Accident · No injuriesLimited investigationFinal reportHarvard MK IV/AT-6 · Apple Valley, CAPlt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in…NTSB DEN85FA015Accident · Serious injuriesField investigationFinal reportCessna 414-8 · Cheyenne, WYThe acft departed the airport in IFR conditions (snowing) & was observed staggering into the air. Shortly after takeoff the acft struck power lines & crashed into homes in a residential area. Investigation revealed that the acft had accumulated ice & in…NTSB DEN85FA014Accident · 1 fatalField investigationFinal reportMooney M20C · Cheyenne, WYThe a/c with a non-instrument rated pilot at the controls, departed the Cheyenne, WY airport at night in light snow showers. Several minutes later he crashed in an open field north of cheyene impact forces and a post acc fire dest the a/c. evidence indicated…NTSB CHI85LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Lake Village, INThe plt reported that he was on final apch to land on a wet, sod rwy when he noticed a flock of geese over the apch end. He added power to fly over the geese then proceeded to touchdown further down the rwy than what he had planned. Due to his speed & the wet…NTSB CHI85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Dodgeville, WIThe plt attempted a landing on rwy 30 which is 85 ft higher in elev at the approach end of the rwy than the departure end. This was the plt's first flt to this arpt. The acft touched down further down the rwy than intended so the plt applied pwr to abort the…NTSB CHI85FA021Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Kiel, WIWitnesses observed acft performing aerobatics during demo flight prior to prospective sale of acft to buyer/pax. A plt/witness observed the acft executing slow speed stalls and enter a spin from an altitude of about 1000 ft. recovery was accomplished at about…NTSB CHI85FA020Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bruce, WIThe acft crashed into a heavily wooded area during a x-country personal flight. Witnesses observed the acft circle the lighted football field at atlanta, WI, at an altitude low enough that they feared the acft would hit trees in the vicinity. At this time the…NTSB ATL85LA017Accident · Minor injuriesLimited investigationFinal reportBell 222 · Pascagoula, MSThe acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched…NTSB ATL85LA016Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Commerce, GAAfter climbing to 8,000 ft the plt noticed fuel siphoning out of the left fuel tank cap. For the next hour & 20 min the flt operated on the left tank in an effort to use fuel from the left tank before it was siphoned out. Aprx 6 miles north of athens, GA, the…NTSB ATL85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCDuring attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed.NTSB ANC85LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKAccording to a state police report, the plt assaulted his wife, then loaded his two children into the acft and flew to a refueling area. He refueled the acft, then tookoff & crashed aprx 1 mile north of the departure rwy. A witness reported that after the…NTSB ANC85LA009Accident · 1 fatalLimited investigationFinal reportCessna U-206C · Iliamna, AKThe acft dragged a wing tip & nosed over while landing on a small lake near Iliamna, Alaska. The passenger seated next to the PIC stated that the plt had cancelled his flt plan prior to landing, circled the lake & made a long final apch to a touchdown on the…NTSB ANC85LA007Accident · No injuriesLimited investigationFinal reportCessna A185E · Shulin Lake, AKThe acft nosed over during a water landing. This acft had wheels in the floats and one of the wheels was not retracted for the water landing. These gear are hand retracted by the plt. The plt said he checked visually to insure the left gear was up but did not…NTSB MIA85LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · West Palm Beach, FLThe plt stated that while standing on the ramp with the eng running in preparation for flt, they were having difficulty closing the acft door. A passenger got out to look for help but once out of the acft walked along the rt wing leading edge up to the eng…NTSB MIA85FA012Accident · 3 fatalField investigationFinal reportHughes 369D · St.ThomasThe acft was flying at 50 feet above the water at 15 knots airspeed photographing a sail boat. The acft then climbed to 150 feet and drifted left over the top of the boat. At this point witnesses reported hearing a loud pop and seeing a puff of black smoke…NTSB LAX85FA025Accident · Serious injuriesField investigationFinal reportCessna 172L · Westmoreland, CAAccording to the plt, he was descending to land at his intended when the acft encountered turbulence & the eng lost power. He was unable to restart the eng & subsequently landed in a freshly irregated field. During the landing, the acft touched down while…NTSB FTW85LA023Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kilgore, TXAfter taxiing north to the end of the strip a 180 deg turn was made prior to takeoff to the south. Out of the turn the acft was lined up with the left wing tip close to the fence. The plt intended to correct his line-up during the roll. According to the plt,…NTSB DEN85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Loring, MTAcft stalled while making a downwind turn during slow flight at a low alt while on a cattle survey flt. Acft descended, impacted the terrain and was destroyed by fire.NTSB ATL85LA018Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe pilot attempted takeoff from an agricultural site which had soft spots from wet conditions. Directional control was lost when one main wheel encountered a soft spot. The aircraft veered into a plowed field and flipped inverted.NTSB ATL85LA014Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-8-71 · Hamilton, ALN825E, operated as delta air lines flt 977 heavy, encountered turbulence during descent. One flt attendant suffered serious injuries, two flt attendants & two passengers had minor injuries. Even though the seat belt sign was illuminated the flt attendants…NTSB ATL85FA013Accident · 1 fatalField investigationFinal reportCessna 150L · Douglas, GAThe passenger reported that the former aerial application plt was demonstrating an aerial application maneuver when he entered a steep descent over a lake. The plt delayed the recovery and the passenger, who held a student plt certificate, attempted to level…NTSB ANC85LA008Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Theodore River, AKThe acft crashed during a go-around attempt at Theodore River located 35 miles southwest of anchorage, AK. According to the plt, after landing on a gravel oil pad he realized that the acft would not stop before going over the edge into a swamp. He applied…NTSB SEA85LA011Accident · No injuriesLimited investigationFinal reportCessna 182F · Snoqualmie Pass, WAThe plt stated that while leveling off at 5,500 ft he trimmed the acft for cruise flt (2200 RPM/21' mp) and checked the carb heat. Aprx 5 mins later, the plt switched from the rt fuel tank to both fuel tanks. Shortly thereafter the eng lost power. Plt then…NTSB LAX85FA024Accident · No injuriesField investigationFinal reportCessna T207A · Sedona, AZOn final approach about 1.5 miles from the arpt the power loss occurred as the pilot attempted to add power. After flying over a ridge and several trees the acft touched down in the rough terrain and caught fire. The fire appeared to have started in the…NTSB FTW85FA019Accident · 1 fatalField investigationFinal reportCessna 421C · Addison, TXAprx 7 min after takeoff (at 1441), the plt declared an emergency & said the l eng had lost power. He feathered the eng,diverted back twd the arpt & dscndd to VFR conds below the clds. At 1448, the plt said he had the arpt in sight & turnedonto a left…NTSB DEN85LA011Accident · No injuriesLimited investigationFinal reportHelio Courier · Livingston, MTPrior to the attempted takeoff fss advised the plt of wind from 250 deg at 20 gusting to 30 KTS and informed him that rwy 26 would be the preferred rwy. The plt elected to use rwy 22. During the takeoff roll the right wing rose in a gust but control was…