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 LAX85FVD02Accident · No injuriesFinal reportCessna 188B · Lodi, CAOn June 24, 1985, at 0520 hours PDT, a Cessna ag truck 188B, N9966J, registered to james l. thomas and operated by ag- flight, inc. collided with the brim of an irrigation canal during take-off from the thomas ranch strip and impacted the ground in a field…NTSB LAX85FA293Accident · 1 fatalField investigationFinal reportRolladen-Schneider LS3-A · Callahan, CAThe plt was participating in a x-country soaring competition. He released from the tow at 5,000 ft above sea level. About one hour later he imformed his crew by radio that he had covered 80 percent of the first leg and that he was 'doing fine.' The flt did…NTSB DEN85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Glen Canyon, UTThe plt became lost/disoriented near the end of a x-country flt from west jordan to blanding, Utah. When fuel quantity became low, the plt decided to make a precautionary landing on a dirt road. During the landing falre, a x-wind gust drifted the acft to the…NTSB DEN85LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Gallup, NMOn June 23, 1985, a student plt flying a C-172 departed the side of the rwy whole landing at Gallup, NM. He said that the landing was made at too high an airspeed. Upon departing the rwy the acft proceeded into a ditch causing substantial damage.NTSB DEN85LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Yuma, COOn June 23, 1985, a Piper PA24 crashed immediately after takeoff from Yuma arpt while avoiding another acft. The plt made a right turn immediately after takeoff. He then saw the traffic and pushed the control wheel forward. The acft impacted the ground. The…NTSB CHI85FA251Accident · 1 fatalField investigationFinal reportNeumann-Everett N2 · Cambridge, MNThe newly rated prt plt was on his 12th flt in the recently certificated homebuilt that he had designed and built himself. While performing an unknown maneuver both horizontal stabilizers and both wings separated from the acft. The acft was restricted from…NTSB SEA85LA144Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Orofino, IDDuring strong gusting winds the private plt was attempting to give dual instruction. During short final for rwy 27 and the wind from 270 at 8 to 12 knots gusting to 18 knots an approach stall was entered into a about 50 feet AGL. Although an attempted…NTSB NYC85LA154Accident · Minor injuriesLimited investigationFinal reportMcCulloch J-2 · Cortland, NYAccording to the pilot, the rotor blade contacted the tail rudders because of insufficient rotor speed. The rotor bladeswere thrown out of track and the gyroplane lost control. The insufficient rotor RPM was due to a rotor or pulley belt stripping.NTSB MKC85LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOThe student plt was on her 1st solo flt. She said that during a landing, she flared too hi & the acft bounced. A porpoise developed & the nose gear failed. About 11 mi southeast at the lambert-st louis arpt, the 1048 CDT wind was from 240 deg at 12 KTS.NTSB MKC85LA139Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sheldon, IAThe student plt was on a solo x-country flight. After the nose wheel touched down on landing, the acft veered left, went into a corn field & nosed over. The plt stated that he may have let the nose wheel contact the rwy before he neutralized the rudder…NTSB MKC85LA138Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Manhattan, KSThe plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the…NTSB MKC85FA137Accident · Serious injuriesField investigationFinal reportCessna 152 · Independence, MOStudent pilot and instructor were practicing pre-solo landings. When airplane was 30 feet AGL and on very short final approach, airplane dropped to ground, went through top of two dikes and two ditches, impacted bank of second ditch and flipped forward to…NTSB LAX85LA288Accident · Serious injuriesLimited investigationFinal reportStarduster II · Glendale, AZThe plt crossed the arpt at midfield and made a left turn for a close in downwind. Witnesses estimated that he made a 180 deg descending turn to final. While on final the plt observed another acft which was already on final slightly aheadand slightly below…NTSB FTW85FA261Accident · 1 fatalField investigationFinal reportCessna 150 · Temple, TXA midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by…NTSB DEN85FTM03Accident · 1 fatalFinal reportKillian Briegleb BG-12B · Heber City, UTThe acft was a george Killian/briegleb BG-12B, experimental, home built glider. An owner reported that the plt had come from new Mexico to buy the glider. After spending about 3 hrs in familiarization training, the plt went on his 1st flt which was…NTSB CHI85LA252Accident · No injuriesLimited investigationFinal reportBeech BE-19A · Appleton, WIThe left main landing gear collapsed following a loss of directional control during landing. The landing was made on rwy 21 with winds from 240 degs at 18 KTS gusting to 30 KTS. The plt reported the acft drifted left during the landing and side loads on the…NTSB CHI85LA250Accident · No injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft collided with a fence during landing the wind was from 230 degrees at 14 KTS and the landg was on rwy 28 the plt said that may be she would have had better control with less than full flaps.NTSB CHI85LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · East Alton, ILThe acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the…NTSB CHI85LA247Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe glider landed in trees after the spoiler 'popped' open in flt during a towed takeoff. The tow plane released the glider at 300 ft AGL after the spoilers opened. The plt landed without retracting the spoilers. Two FAA inspectors stated that they checked…NTSB CHI85FER01Accident · Serious injuriesFinal reportPZL PZL-104 Wilga 35A · St. Paul, MNThe acft contacted the rwy following a loss of control during takeoff. At an alt of 50 to 100 ft AGL after a maximum performance takeoff, the plt rapidly raised the flaps from 44 to 0 degs and the acft suddenly pitched nose down. The plt attempted remedial…NTSB CHI85FA249Accident · Serious injuriesField investigationFinal reportBoeing 727 · South Haven, MIWhile en route on an IFR flt plan (1st officer at ctls), American flt 803 (a Boeing 727, N1965) bgn a dscnt fm FL 190 TO9000'. The seat belt sign was turned on at 18,000'. While dscndg btn cld layers, at aprx 13,000 to 12,000', the capt sawa Cessna 421C,…NTSB ANC85FA107Accident · 1 fatalField investigationFinal reportPiper PA-18 · Lake Beverley, AKThe plt stated that he & his student plt was flying around the lake well below the tree line, & after a steep right bank the acft struck the trees & crashed in the lake, the acft sank into 10 to 12 ft of water.NTSB SEA85LA146Accident · No injuriesLimited investigationFinal reportGrumman 164B · Twin Falls, IDA partial loss of power occurred during aerial application due to a crack around one of the cylinders. While the plt was attempting to dump chemicals, the acft settled onto the ground tearing off the rt main gear. The plt then flew on to Twin Falls to land.…NTSB SEA85LA143Accident · No injuriesLimited investigationFinal reportCessna 172B · Imbler, ORDuring takeoff from a field (off arpt), the acft failed to clear a fence. The pilot then attempted to abort the takeoff, but the acft hit a bale of hay & nosed over. The plt's last medical certificate was dated 9/2/82.NTSB SEA85FA147Accident · 4 fatalField investigationFinal reportCessna C-177RG · Yakima, WAThe pilot, while in slow-flight configuartion, at low altitude, in light chop, failed to see and avoid trees. Resulting tree impact caused acft into stall conditions. Acft contacted other trees, crashed and burned.NTSB LAX85LA295Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Angwin, CADuring a VFR cross country flt, wx conditions along the route induced the plt to divert to the Angwin arpt. After an overflt to obtain wind information from the wind sock, the plt said he entered the pattern and completed a normal approach and touchdown.…NTSB LAX85LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Glendale, AZWhen the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,…NTSB FTW85LA264Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Ville Platte, LAThe plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,…NTSB FTW85LA262Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ship Shoal BlkThe pilot had landed on the offshore platform and was in the process of repositioning the helicopter to one side of the landing pad to provide additional space for another aircraft when the main rotor blades struck a 3' steel sign post. Theblade separated…NTSB DEN85LA173Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Deming, NMThe plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n…NTSB DEN85LA170Accident · No injuriesLimited investigationFinal reportRockwell Aerocommander 112 · Landers, WYOn June 22, 1985, a Rockwell aerocommander 112 impacted the ground immediately after takeoff. The density alt was 7700 ft. after takeoff the plt realized the acft would not clear a ridgetop. The acft began to descend & was maneuvered to land on level terrain.…NTSB DEN85FTI04Accident · 1 fatalFinal reportFailing/Rand-Robinson KR-2 · Laurel, MTDrg a test flt, the plt made a fast taxi run, then took off on rwy 21. After takeoff, he made a gradual climb & shallow left turns to a downwind, circled the arpt & reentered a downwind for rwy 21. Witnesses reported that the plt made a power reduction &…NTSB CHI85LA246Accident · Minor injuriesLimited investigationFinal reportAnderson Skybolt · Escanaba, MIPrior to the acdnt, the acft was observed making repeated low passes over the area where it subsequently crashed. Witnesses reported that during a turning maneuver over water, the acft collided with the surface & crashed. A police officer, who responded,…NTSB CHI85LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INOn the student's third approach, he was observed to flare the acft too high. The acft drifted off to the side of the rwy and nosed down until it collided with the ground.NTSB BFO85FA052Accident · Minor injuriesField investigationFinal reportPiper PA-28-140B · Perry Hall, MDOn June 22, 1985 the plt and three passengers boarded N98079. After taxing to rwy 27 (which has a one degree upgrade), the acft began an extended ground roll with a left-quartering tailwind of approximately eight knots. At this time, the acft was loaded about…NTSB BFO85FA051Accident · Minor injuriesField investigationFinal reportBellanca 17-30A · College Park, MDBfr flt, the plt obtained fuel samples thru the remotely operated gascolator, but detected no water. No samples could bedrawn directly fm the wing or fuselage tanks since they had no quick drains installed. A pwr loss occurred drg takeoff at 50 to 100 ft AGL.…NTSB ANC85LA105Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Lewis River, AKThe pilot stated there was a gust of wind about 10 knots, the pilot was not able to reach flying speed, and the aircraft ran off the departure end of the runway.NTSB ANC85LA104Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Ungalikthluk Rv, AKThe plt reported that when he was landing the float plane on a river, an extreme gust of wind cocked the acft causing loss of control. Subsequently, the acft struck a river bank & was damaged. The plt noticed that after the landing, the winds had changed,…NTSB NYC85LA153Accident · Minor injuriesLimited investigationFinal reportCessna R-182RG · Spring Valley, NYDuring the final approach to runway 25, the aircraft encountered a downdraft and began to descend, the pilot added power but but unable to recover prior to the aircraft contacting the trees.NTSB MKC85LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Belgrade, NEFlight instructor giving private pilot a bfr. Bfr was nearly completed when ip gave pilot a simulated forced landing over his own farm strip. Pilot was making an excellent approach until the landing gear hit the barbed wire hidden in the high grass.NTSB LAX85LA287Accident · No injuriesLimited investigationFinal reportCessna 152 · Filmore, CAThe plt flew into a canyon with the intention of turning around to back out. He then decided the canyon was too narrow for a 180 degree turn. He continued flying up the canyon while attempting to gain alt, however, the rising terrain exceeded the acft's climb…NTSB DCA85AA026Accident · 1 fatalFinal reportBeech E18S · Birmingham, ALAt 2045 the military flt, dixie 06, contacted Birmingham apch & obtained clearance for a low apch followed by a full-stop lndg on rwy 05. At 2053, dixie 06 reported a 4 mile final for a low apch to the local controller. At 2054:19, the local controller…NTSB ATL85LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring landing on a private turf airstrip, the nose wheel struck a 'pot' hole. The nose wheel separated from the acft and the acft skidded to a stop resulting in substantial damage.NTSB ATL85FA193Accident · No injuriesField investigationFinal reportBell 206L-1 · Ghent, WVThe plt took off at 1805 with 150 lbs of fuel remaining, intending to fly to beckley, WV to refuel. He stated that afterhe was in lvl flt at about 3000 ft MSL for 3 to 4 min, he noted an unusual jerk or vibration in the rear. Suspecting a psbl tail rotor…NTSB ANC85LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe plt stated that he was making an apch to the arpt when the acft ran out of fuel. Subsequently, the acft crash landed about 1-1/2 mi nw of the arpt.NTSB ANC85LA103Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe aircraft swervd on the runway and ground looped, the pilot stated he lost control of the acft due to the wind condition.NTSB NYC85LA066Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Norfolk, MAThe acft was unintentionally landed with the gear retracted. A CFI and a pvt plt were on board at the time of the accident. The pvt plt in the left seat was flying the acft and on the third landing failed to extend the gear. The CFI in the right seat was…NTSB MKC85LA135Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · York, NEThe plt reported that he had completed a landing & had come to a near stop, then he applied power & was on the brakes for control. He stated that the left brake locked & the acft went off the rwy into hi weeds & rough terrain. There was no damage due to…NTSB LAX85FA286Accident · 2 fatalField investigationFinal reportBell 214B-1 · Squaw Valley, CAThe helicopter was engaged in lowering a large pole to the ground when the eng failed catastrophically due to a total first turbine rotor disc failure. The plt turned the acft down the mountain but was unable to gain enough speed to autorotate. The acft…NTSB CHI85LA260Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roseau, MNThe plt intentionally ground looped the acft during a forced landing to avoid obstacles following a loss of power en route. Aprx 1 1/2 hrs into the flt the plt noticed an engine roughness followed by an increase in oil temp which returned to normal shortly…