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 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…