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 ATL86FA223Accident · 2 fatalField investigationFinal reportBellanca 17-30 · West Green, GAThe plt took off at 1259 EDT, & at 1318, he reported level at 10,000'. There was no further comm with the acft. At about 1342, radar contact was lost. Subsequently, the acft wreckage was fnd scattered over a 425 yd area, along a sw azmith, aprx 1/2 mi from…NTSB SEA86LA201Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Lages, NVThe plt was unable to divert around numerous thunderstorms along in his flight path. Subsequently, he made a precautionary landing on a soft, dry lake bed were the aircraft nosed over.NTSB LAX86FA326Accident · Serious injuriesField investigationFinal reportCessna 182N · Wilmington, CADuring a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…NTSB FTW86LA152Accident · No injuriesLimited investigationFinal reportHughes 369-500D · Fort Stockton, TXThe helicopter pilot entered autorotation after experiencing fuel exhaustion. The pilot knew he was low on fuel, but was depending on his warning light to indicate low fuel. The warning light never came on. On touchdown the tail rotor struck the ground…NTSB CHI86LA203Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Keego Harbor, MIAccording to the pilot, as he was preparing to land on a lake and was at an altitude of approximately 100 feet, he noticed that he did not have full flaps down. He then reached down, and by error, lowered the landing gear instead of the flaps. During…NTSB ANC86LA133Accident · No injuriesLimited investigationFinal reportCessna U206 · Kamishak Bay, AKAfter touchdown in the bay, the pilot lost directional control of the aircraft causing the aircraft to nose over on its back in the water.NTSB ANC86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Two Lakes, AKThe pilot lost control of the aircraft on the initial climb. The pilot stated that after takeoff the wind shifted 180 degrees.NTSB SEA86FA213Accident · 2 fatalField investigationFinal reportLuscombe 8A · Pelican, AKAt about 1500 adt on 8/19/86, the plt departed on a flt to hoonak, AK. When he did not return, a search was initiated. The acft was located at 1400 adt on the following day where it had crashed on rising mountainous terrain at an elev of about 1740 ft. an…NTSB ANC86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcneil River, AKPilot applied brakes too firmly; lost control on landing and aircraft nosed over on its back.NTSB ANC86LA131Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Kotlik, AKThe pilot stated on approach he spotted what appeared to be the airport from several miles off. Instead of landing at the airport, he landed at a gravel bar. After touchdown the pilot lost control of the aircraft and the aircraft nosed over on its back.NTSB ANC86FA130Accident · 3 fatalField investigationFinal reportCessna 177RG · Hinchinbrook Is, AKAt 1323 adt, the plt rprtd near Hinchinbrook island & requested clearance for an ndb-a apch to the cordova mile 13 arpt. About 3 min later, cordova fss provided clearance for the apch 'from over Hinchinbrook.' Radar data showed that the acft flew to the…NTSB SEA86LA212Accident · Minor injuriesLimited investigationFinal reportMooney M-20-J · Aurora, ORAt about 9,000 feet MSL the pilot smelled smoke and electrical fumes. He then turned off the master switch and returned to land. He manually lowered the landing gear but it folded upon landing roll. Investigation revealed no mechanical reason for the gear to…NTSB LAX86LA334Accident · No injuriesLimited investigationFinal reportCessna 172 · Oroville, CAThe pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They…NTSB DEN86LA233Accident · No injuriesLimited investigationFinal reportCessna 177B · Broomfield, COThe plt said that he was on a high final approach for landing and just prior to touchdown, the acft was hit by a strong gust of wind. After touchdown, the plt lost control of the acft and it went off the left side of the rwy. The acft sustained substantial…NTSB CHI86FEM14Accident · No injuriesFinal reportPiper PA-25-235 · White Pigeon, MIThe pilot took off with a full load of seed on a 1300 ft runway during shifting wind conditions. He struck a fence before he had enough airspeed to establish a climb.NTSB ANC86LA128Accident · No injuriesLimited investigationFinal reportCessna 185-F · Caribou Lake, AKThe aircraft settled back on the water and the pilot lost control of the aircraft causing it to nose over on its back.NTSB ANC86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Alexander River, AKAfter touchdown on a gravel road, the pilot lost directional control of the aircraft causing the plane to exit the left side of the road and causing the plane to nose over on its back.NTSB SEA86LA208Accident · Minor injuriesLimited investigationFinal reportCurtiss JN4-D · Vancouver, WAThe plt reported a normal takeoff was made with 1300 RPM. At liftoff a small amount of black smoke emitted from both exhaust stacks and the RPM dropped to 1250. After clearing the rwy, more black smoke emitted and the RPM dropped to 1200. The plt cleared two…NTSB SEA86FA207Accident · 3 fatalField investigationFinal reportBeech 23 · Stanwood, WAAccording to witnesses, the plt made an apch to rwy 34 which sloped downhill twd the north end. Rprtdly, the acft landedabout 1000 ft down the 1750 ft rwy. One witness heard the tires squeal as the plt applied brakes in an attempt to stop. The plt then…NTSB MKC86LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Republic, MOThe pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is…NTSB MKC86FCD03Accident · Serious injuriesFinal reportRoger Warnell KR-1 · Waterloo, IAThe pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft.NTSB MIA86LA238Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Merritt Island, FLThe plt stated that while he was towing a banner the engine lost fuel pressure and the RPM began to deteriorate. He dropped his banner and tried to make it back to the airport but couldn't and landed short of runway 29 in the water. Post crash examination of…NTSB FTW86LPJ11Accident · Minor injuriesFinal reportHomebuilt SA-100 · Oklahoma City, OKThe acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated…NTSB FTW86LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Murray, OKThe pilot lost control of the aircraft prior to touchdown after the left wing dipped approximately four feet. The left gear touched down alongside the runway and the pilot made an attempt to go around but changed his mind when he saw a group of trees at the…NTSB FTW86LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Matagorda Is., TXThe pilot was making a beach landing when the nose wheel struck an object in the sand, causing the nose wheel to collapse and the aircraft to nose over into an inverted position.NTSB CHI86LA208Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIAccording to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient…NTSB CHI86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Galesburg, ILThe non-instrament rated pilot, landing in IFR conditions, flared too high resulting in a hard landing, nose gear failure and buckling of the engine mounts.NTSB CHI86LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Fraser, MITake off was aborted after aircraft failed to achieve sufficient airspeed to allow it to climb out of ground effect. During the subsequent landing and rollout the aircraft ran off the end of the runway and was destroyed. The plt did not report any…NTSB CHI86LA204Accident · No injuriesLimited investigationFinal reportCessna 182G · Chesaning, MIThe pilot was making his first landing to a sod runway. While decelerating over the runway at about 6' AGL. The aircraft began to sink rapidly. He added power, but the landing gear hit hard and the aircraft bounced several feet back into the air. He added…NTSB BFO86FA042Accident · 3 fatalField investigationFinal reportPiper PA-30 · Bowleys Qrtrs, MDDrg arr, TRACON gave the plt the arpt wx & provided vectors for an ILS rwy 32 apch. The plt inquired about a cell that he understood was over the arpt & was advised to standby while the controller (ctlr) checked on it. The ctlr contacted twr psnl who adzd the…NTSB NYC86LA211Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Moultonboro, NHThe plt rprtd that he departed the Moultonboro arpt at about 2200 EDT. During departure, the acft stalled & crashed into trees about 1/2 mi northwest of the arpt.NTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.NTSB NYC86FA213Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · West Mifflin, PAAt 2232 EDT, the acft was climbing to 15000 feet when the pilot reported a low oil pressure light. ATC advised jimmy stewart field is about eleven thirty and 15 miles. After the pilot asked, 'is that a tower field?', ATC advised he did not know, westmoreland…NTSB LAX86LA325Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Fallbrook, CAThe acft went out of control during the takeoff ground run on rwy 18 and collided with the terrain. The plt indicated he lost control while attempting a rolling takeoff after taxiing into position on the rwy without stopping. He stated he normally stopped the…NTSB FTW86LA153Accident · No injuriesLimited investigationFinal reportCessna 206 · Ardmore, OKThe pre-solo student pilot had taken the aircraft without the owner's permission. He flew around the area for approximately 30 minutes before returning to the airport. After a hard landing, the nose wheel tire blew causing the nose wheel to collapse. The…NTSB CHI86LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Linden, MIThe newly certificated pvt plt with three passengers was attempting to practice a short field takeoff on the 2500 ft long asphalt runway. The owner's manual recommends 25 degrees of flaps to perform the takeoff. The plt did not extend any flaps. After…NTSB BFO86FIA02Accident · Serious injuriesFinal reportPiper PA 28-161 · Stanley, VAThe acft collided with trees and the ground during a x-country flt over mountainous terrain. The plt had crossed the 1st ridge at aprx 800 ft AGL according to the plt. The front seat passenger said later that he complained several times during the flt that…NTSB ATL86FA222Accident · Serious injuriesField investigationFinal reportMooney M20C · Hillsville, VAThe plt, also an A&P and IA, had flown the acft on the previous day and noted RPM at 2500 on initial climb. On the accident flt, the acft was loaded to near max gross weight and takeoff was attempted at a density alt of 4810 ft MSL. The acft used about 3/4 of…NTSB ANC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna T-210 · Alexander Lodge, AKDuring the takeoff roll on a dirt airstrip the pilot lost directional control of the aircraft causing the aircraft to exit the right side of the runway and nose over on its back.NTSB ANC86FA126Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe plts of Cessna 185 (C-185), N1802R, & Cessna 180 (C-180), N9418C, received clearance fm ground control to taxi to rwy 32 via taxiway-n (twy-n). Both acft were tailwheel (conventional gear) equipped. As the C-185 was proceeding along twy-n, the C-180 plt…NTSB SEA86LA210Accident · Minor injuriesLimited investigationFinal reportWise OR-71-B · Richland, WAWhile on a qualifying lap for an air race the number one piston failed. A forced landing was then made onto a field.NTSB NYC86LA210Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Nantucket, MAThe pilot made a precautionary landing on a beach shortly after takeoff when the engine stopped running. However during engine examination, nothing was found to determine malfunction or failure.NTSB MIA86LA237Accident · No injuriesLimited investigationFinal reportCessna 182-A · Tampa, FLThe 129 hour private pilot was landing on a runway with a 70 degree left crosswind and stated that upon touchdown the aircraft veered to the left and crashed into the trees. Post accident examination of the nose gear steering system and the brakes revealed no…NTSB MIA86LA236Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jacksonville, FLThe plt stated that just after takeoff, the eng sputtered and lost power. He landed the acft in the grass on the right side of runway 31, rolled aprx 100 yards, struck a sign, and veered left into soft dirt collapsing the nose gear. Post crash examination and…NTSB LAX86LA323Accident · Serious injuriesLimited investigationFinal reportBeech 35R · Sun City West, AZA Beechcraft BE-35R lost alt during initial climb and collided with the ground after takeoff from a private airstrip. The plt described the takeoff as normal until he reached an alt of 100 to 125 ft AGL and started to turn left. The plt stated, 'the aircraft…NTSB LAX86LA322Accident · 2 fatalLimited investigationFinal reportLuscombe 8F · Marble Canyon, AZWitnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was…NTSB DEN86FA231Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Redcliff, COA husband & wife rprtd that the acft flew near their house at a very low alt, then climbed in the direction of the sun to clear over a bridge. Moments later, the acft collided with power lines that were suspended between 2 towers. The towers were located atop…NTSB ATL86FKG10Accident · Minor injuriesFinal reportGrumman American G-164A · Quitman, GAShortly after takeoff a loss of pwr was experienced. The plt attempted to land in a cotton field but the landing gear contacted a stump short of the field. The acft then contacted a ditch and nosed over. Post accident inspection revealed the supercharger…NTSB ATL86FEI10Accident · 2 fatalFinal reportSenior Aero Sport D-260 · Valley City, OHAccording to witnesses, the acft was in lvl flt at low alt when it entered a steep climbing maneuver. Subsequently, it entered a steep dscnt & crashed in aprx a 75 deg nose down attitude. There was evidence the acft was in a right bank & was spinning or…NTSB ATL86FEI09Accident · No injuriesFinal reportCessna 182 · Glen Willow, OHThe acft was damaged during collision with scrub pine trees during a forced lndg on a road after the eng quit in flt. The plt said he was cruising at 3500 ft when the eng began to sputter. The plt stated that he changed the fuel tank selector from left to…