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.

NTSB BFO86LA039Accident · No injuriesLimited investigationFinal reportCessna 150M · Clifton, VAAccording to the pilot, he and his wife had departed mount olive, NC on the morning of the accident enroute to romeo, MI. After refueling at danville, VA they departed but ran into weather near beckly and diverted to the east. Unable to locate greenbrier…Jul 11, 1986 · N704VE · Substantial damageNTSB ATL86LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Augusta, GADuring takeoff from an emergency landing zone, the aircraft collided with power lines and made a precautionary landing on the median between the highway. The helicopter was operating as an emergency medical services helicopter and the pilot was responding to…Jul 11, 1986 · N5733X · Substantial damageNTSB ANC86LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe plt stated that he landed in the water with the landing gear on the floats in the down and locked position. The acft nosed over in the water on touchdown. The plt stated he failed to use a before landing checklist.Jul 11, 1986 · N6455X · Substantial damageNTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.Jul 10, 1986 · N2NH · Substantial damageNTSB MIA86LA203Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Pompano Beach, FLThe student plt lost control of the acft as power was applied to takeoff. The instructor plt then took control of the acft as it left the rwy, after which the left gear became stuck in sand. The acft nosed over and came to rest inverted.Jul 10, 1986 · N31496 · Substantial damageNTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…Jul 10, 1986 · N48593 · DestroyedNTSB ATL86LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · Shelbyville, KYThe plt rented the acft without verifying the actual fuel onboard. He then flew to his pvt strip, 26 NM away, and gave 'several' pax hops. About 5 mins after takeoff for the flt to return the acft to the owner's field, the engine started running rough and…Jul 10, 1986 · N10949 · Substantial damageNTSB ANC86LA112Accident · No injuriesLimited investigationFinal reportCessna 180B · Kvichak, AKThe plt attempted to become airborne without sufficient airspeed after noticing that there was not enough rwy remaining to complete the takeoff. The acft mushed and one of the main gears contacted a dirt bank. A loss of directional control resulted and the…Jul 10, 1986 · N5159E · Substantial damageNTSB SEA86LA164Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Juneau, AKThe acft veered left and ground looped during landing roll. The right main gear strut collapsed during the landing. The plt had 5 hours total flt time in this acft and stated the toe brakes seemed 'touchy' during the landing.Jul 9, 1986 · N40646 · Substantial damageNTSB LAX86LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paso Robles, CAThe plt was informed that he was trailing smoke on climb out. The plt elected to continue the climb due to IMC at the departure arpt and divert to another arpt located 26 NM north. He continued to climb to 4,500 ft MSL to VMC. The oil warning light…Jul 9, 1986 · N39944 · Substantial damageNTSB DEN86LA186Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Salida, COAccording to the plt, upon entering the mountain pass, the acft he was piloting encountered downdrafts from which he was unable to recover. The plt stated he bled off airspeed until contact with the trees. A local flt instructor who witnessed the accident…Jul 9, 1986 · N1272K · Substantial damageNTSB CHI86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Effingham, ILAcft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of…Jul 9, 1986 · N5214H · Substantial damageNTSB CHI86LA168Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INThe aircraft landed gear up at Indianapolis international airport. Pilot and witness report that gear was down. However, FAA inspectors and mechanics who inspected the aircraft state that the left main and nose gear were found in the wheels wells and the…Jul 9, 1986 · N9069Q · Substantial damageNTSB CHI86LA167Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Middleton, WIThe student pilot stated that he was practicing soft field takeoffs on a grass strip. He aborted his first attempt to make an intersection takeoff. On his second try, he thought he could get airborne, but did not. The aircraft struck an embankment near the…Jul 9, 1986 · N761UA · Substantial damageNTSB NYC86FHM01Accident · No injuriesFinal reportPiper PA-25-235 · Goshen, NYA loss of engine power was experienced during takeoff. The plt was unable to maintain altitude and a forced landing was made in an open field. The nose gear dug into soft terrain and the acft nosed over. Post accident inspection of the acft revealed water in…Jul 8, 1986 · N6795Z · Substantial damageNTSB NYC86FHD02Accident · Minor injuriesFinal reportCessna 172K · Jobstown, NJWhile on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but…Jul 8, 1986 · N7456G · DestroyedNTSB LAX86FVA11Accident · Serious injuriesFinal reportBell 47G-5 · Porterville, CADuring an aerial application flight the plt lost control of the helicopter and collided with a building. Examination revealed that the inside diameter of the tail rotor driveshaft was not coated with aluminized lacquer as required by the Bell finish process…Jul 8, 1986 · N1316X · Substantial damageNTSB ANC86LA104Accident · No injuriesLimited investigationFinal reportCessna 170 · Fairbanks, AKThe plt reported experiencing a total loss of pwr during cruise flt. He stated he switched fuel tanks and was temporarily able to regain pwr before experiencing a second total loss. Substantial damage resulted during the forced landing. During post accident…Jul 8, 1986 · N3864V · Substantial damageNTSB SEA86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Royal City, WAThe plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged.Jul 7, 1986 · N15270 · Substantial damageNTSB SEA86LA163Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Sandy, ORPlt experienced power surges on takeoff, elected off-airport landing, allowed acft to contact ground nose-low while maneuvering to avoid trees. Inspection did not reveal mechanical failure/malfunction.Jul 7, 1986 · N6606M · Substantial damageNTSB NYC86LA174Accident · No injuriesLimited investigationFinal reportHughes 500A · Fall River, MAThe flight encountered fog and haze during return flight to new bedford, Massachusetts. The pilot failed to maintain direction control of the helicopter and crashed into the north watuppa pond.Jul 7, 1986 · N4237D · Substantial damageNTSB NYC86IA215Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Pittsburgh, PACo-plt was flying acft on short final approach/landing. Capt observed co-plt having difficulty maintaining glideslope and airspeeds. Co-plt stopped flying the acft. Capt took control at 50' AGL and landed safely. Medical help requested and received from cabin…Jul 7, 1986 · N319US · No damageNTSB MKC86LA145Accident · No injuriesLimited investigationFinal reportCessna 182A · Davis City, IAStatements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…Jul 7, 1986 · N4773D · Substantial damageNTSB LAX86LA299Accident · No injuriesLimited investigationFinal reportBoeing N25-3 · Van Nuys, CAA Boeing N2S-3 nosed over on landing while on a local VFR flight. The pilot indicated that he had logged a total of 2.4 hours in this make and model aircraft all within the previous ninety days. The pilot stated that on his last approach, the speed was too…Jul 7, 1986 · N5106N · Substantial damageNTSB LAX86FJA02Accident · 1 fatalFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The…Jul 7, 1986 · N4835A · DestroyedNTSB LAX86FA282Accident · 1 fatalField investigationFinal reportCessna 150H · Phoenix, AZThe plt performed 1 normal touch & go operation, & touched down normally on the second planed touch & go which was to terminate with a right dep out of the pattern. After touchdown, witnesses observed the acft roll straight along the rwy centerline for about…Jul 7, 1986 · N23222 · DestroyedNTSB FTW86LA124Accident · Minor injuriesLimited investigationFinal reportCessna P-210N · Zachery, LAThe plt experienced a total loss of power due to fuel exhaustion during cruise flight. Approach control vectored him to a closer airport but the aircraft was beyond gliding distance and it collided with a house which was under construction. Inspection of the…Jul 7, 1986 · N4UD · Substantial damageNTSB FTW86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Porum, OKThe student pilot became disoriented during a cross-country flight. He was unable to find an airport and had to land in a field due to fuel exhaustion. During the attempted landing he had to maneuver to avoid a herd of cows and collided with a concrete fence…Jul 7, 1986 · N47802 · Substantial damageNTSB FTW86LA122Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · San Antonio, TXThe pilot was cleared to land on runway 12L when he encountered wind gusts on touchdown causing the aircraft to veer off the runway into a grassy area.Jul 7, 1986 · N9165P · Substantial damageNTSB CHI86LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student plt initiated the takeoff, however, the CFI took over control of the acft when it became apparent that the acft was not climbing. The CFI was unable to salvage the takeoff and the acft struck and settled into trees at the departure end of the rwy.Jul 7, 1986 · N32858 · DestroyedNTSB CHI86LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Selfridge Ang, MIThe plt became lost at night over a large body of water and requested assistance. When identified by ATC, the acft did not have enough fuel remaining to reach an arpt. The acft suffered fuel exhaustion on final apch and was landed on a golf course 2000 ft…Jul 7, 1986 · N8095F · Substantial damageNTSB CHI86FEX10Accident · Minor injuriesFinal reportBell 206L-II · Kokomo, INThe helicopter experienced a loss of power during cruise, for undetermined reasons, and was forced to make an emergency landing. Prior to touchdown the helicopter experienced a loss of directional control, due to a failed hydraulic pump, and collided with the…Jul 7, 1986 · N1084L · DestroyedNTSB CHI86FER13Accident · 1 fatalFinal reportBell 47G-5 · Elrosa, MNThe helicopter was seen flying at a low altitude by witnesses and appeared to be flying straight and level and sounded normal. The helicopter impacted the ground in a northeasterly direction, 180 degrees from it's observed flight path. There were no witnesses…Jul 7, 1986 · N94458 · DestroyedNTSB ATL86LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kirkland, OHPilot had flown from wisconson to cape cod on Wednesday and was returning to Wisconsin on Sunday. He had departed provincetown on Sunday morning and stopped at hyannis due to weather. He then flew on to saratoga springs, NY with a stop at westover, arriving…Jul 7, 1986 · N7098A · Substantial damageNTSB ATL86LA188Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Welch, WVWitnesses reported that the pilot had worked on the engine carburetor for some time as well as just before the accident takeoff. At about 200 feet after takeoff from rwy 27 the engine quit and the pilot made a left turn back to the rwy and tried to align the…Jul 7, 1986 · N70824 · DestroyedNTSB ANC86LA103Accident · No injuriesLimited investigationFinal reportCessna 170B · Tekanika River, AKThe acft nosed over during the forced landing which followed a total loss of pwr. The plt reported he noted a decrease in oil pressure during cruise flt just prior to the pwr loss. Examination of the acft eng revealed that the #6 cylinder push rod had failed.Jul 7, 1986 · N3162B · Substantial damageNTSB NYC86FA176Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Seven Valleys, PAAircraft departed york airport and crashed 5 min later. The engine sump oil quick drain had disconnected and was not found. Engine oil was exhausted and the engine seized. A tree and utility pole were found damaged. The ramp and runway at york airport did not…Jul 6, 1986 · N7562W · DestroyedNTSB MIA86LA201Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Marco Island, FLDuring landing apch, the plt stated that he switched from the left fuel tank to the right tank & shortly thereafter, the eng failed. He was unable to restart the eng and a forced ldg was made. An exam of the left tank revealed it to be empty while the right…Jul 6, 1986 · N9031S · DestroyedNTSB LAX86LA283Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M · Valencia, CAThe pilot reported that he heard a loud bang and grinding noise from the engine/main transmission area while on a swath run. He stated that the main rotor RPM decayed immediately after he heard the noise. As the helicopter descended to about 50 feet above the…Jul 6, 1986 · N51856 · Substantial damageNTSB LAX86LA281Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Atwater, CAA Cessna 175 collided with a tree after a total loss of power during a VFR x-country flt. The plt indicated he experienced an eng failure at 2,000 ft MSL, while on descent, aprx 15 mi from his dest. He reported that the eng began to vibrate slightly. The…Jul 6, 1986 · N7108M · Substantial damageNTSB LAX86LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vacaville, CAThe student plt indicated that after his third approach, while flying solo, the acft veered to the right and went off the rwy during the landing roll. He attempted to correct the situation, but the acft collided with a 5 ft ditch, located aprx 38 ft from the…Jul 6, 1986 · N8075X · Substantial damageNTSB LAX86FA279Accident · 5 fatalField investigationFinal reportCessna 172M · Havasu Lake, CAAt about 2100 PDT on 7/5/86, the flt departed lake Havasu city, AZ for an unkn destn. On the next morning at aprx 0330, witnesses, who were fishing on lake Havasu, heard the acft circle twice, then crash about 2 mi west of the arpt on the California side of…Jul 6, 1986 · N80503 · DestroyedNTSB DEN86LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Cimarron, NMThe plt received a checkout in the acft prior to the accident and then flew to the philmont scout ranch located at approximately 9,000 foot MSL elevation. Ground witnesses stated that the acft was 'buzzing the area' and flew into an area of high terrain. The…Jul 6, 1986 · N2587B · Substantial damageNTSB CHI86FER12Accident · Minor injuriesFinal reportPiper PA-25-235 · New Richland, MNThe aircraft performed a forced landing which resulted in substantial damage. Water was found in the fuel system. Water was also found in the underground fuel supply used to refuel the crop duster.Jul 6, 1986 · N9824P · Substantial damageNTSB ATL86LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Pandora, OHFollowing a early morning Balloon flight, the pilot attempted a landing in a cleared area with winds at about 14 knots. The pilot realized that the first attempt he would encounter powerlines and trees. The pilot climbed out and attempted another approach to…Jul 6, 1986 · N4065K · No damageNTSB ATL86IA187Incident · No injuriesIncident investigationFinal reportCessna U206C · Bucyrus, OHThe plt was returning to the airport after transporting skydivers to altitude and while on final aprch he allowed the acft to stall & crash short of the rwy.Jul 6, 1986 · N29095 · Minor damageNTSB ATL86FEG01Accident · No injuriesFinal reportBeech C-45H · Tremont City, OHThe acft collided with a utility pole during an exhibition fly-by. The acft continued to fly to its home arpt where it made an uneventful landing. The rt wing was damaged on the outboard end to include 2 ft of the aileron. The pole struck was 30 ft high and…Jul 6, 1986 · N8640E · Substantial damageNTSB ANC86LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe student plt stated that he ran out of fuel on a solo x-country flt after becoming disoriented. A forced landing was made during which the acft nosed over.Jul 6, 1986 · N6276P · Substantial damageNTSB SEA86LA162Accident · Minor injuriesLimited investigationFinal reportLazarini LONG-EZ · Jackpot, NVDuring takeoff at about rotation speed, the pilot diverted her attention to the right wing. The acft drifted to the edge of the runway and caught a wingtip, then nosed over.Jul 5, 1986 · N8183K · Substantial damageNTSB SEA86LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenn'S Ferry, IDThe student pilot had to be vectored during a night x-country. During cruise, 35 miles from his destination, he became concerned about his low fuel state. He then diverted, with ATC assistance to an unlit airstrip for landing. The acft touched down short of…Jul 5, 1986 · N1641F · Substantial damage