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 NYC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Madison, CTThe acft experienced an engine failure during takeoff and the plt made a forced landing in a river. Post accident inspection did not determine cause of the power loss. It should be noted that the acft was under water for several hours prior to examination.NTSB LAX86LA211Accident · 1 fatalLimited investigationFinal reportBell 47G-5A · AganaThe helicopter crashed into the ocean when the plt attempted to lift off from a tuna boat. Reportedly, only three of the four tiedown ropes, which had secured the helicopter to the boat, had been released. The plt's medical certificate was dated 1/18/84.NTSB FTW86LA081Accident · No injuriesLimited investigationFinal reportMooney M-10 · Abilene, TXWhile on final approach for runway 17 at elmdale airpark, Abilene, TX, the student pilot lost control of the aircraft when he flared the aircraft and it began to descend. The student attempted to pull back on the wheel, causing the aircraft to enter a stall…NTSB ATL86FA125Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Winchester, TNThe plt made a VFR pattern at an uncontrolled arpt and noted a truck alongside the north end of the rwy. The plt did notsee any persons on the rwy. During the landing flare the plt noticed a man on the rwy near the right wingtip. A jolt was felt as the acft…NTSB SEA86LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Juneau, AKAcft had history of water in fuel and the system was purged. During winter, the plt did not fly acft but ran the eng periodically. On the day of the accident, the plt refueled the acft, completed a normal pwr run-up and took off. Shortlyafter takeoff, a pwr…NTSB NYC86LA120Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Plymouth, MAThe acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…NTSB MIA86FA148Accident · Serious injuriesField investigationFinal reportCessna 150H · Vero Beach, FLThe CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The…NTSB DEN86FA125Accident · Serious injuriesField investigationFinal reportBoeing 737-200 · Almosa, COA southwest airline company Boeing 737, flt no. 558 en route from denver, Colorado, to albuquerque, new Mexico, at FL 350, encountered severe clear air turbulence. The unexpected wx phenomena caused the acft to 'drop' suddenly resulting in two flt attendants…NTSB ANC86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Atmautluak, AKThe air taxi pilot planned six hours of night flying with a five minute fuel reserve at his destination. When he saw that he would be unable to reach the destination, he diverted toward atmautlauk. However, the acft ran out of fuel as the plt was maneuvering…NTSB NYC86LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Mt. Graylock, MAThe pilot was practicing simulated cross country passes on a ridge at an altitude of 150 ft AGL on the windward side of a ridge in a Schweizer sgs 1-26 sailplane. The pilot encountered a roll condition from which he lost control, was unable to recover and…NTSB NYC86LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Marshfield, MAThe student pilot was making touch and go's on runway 24 in a Piper tomahawk. The wind was from the north west at 12 knots. The pilots reported the wing rose and the aircraft drifted left with a gust. He stated he applied power for a go-around, however the…NTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…NTSB MIA86LA147Accident · No injuriesLimited investigationFinal reportHughes 269C · Jacksonville, FLThe plt stated that as he was landing on a dolly, the helicopter experienced ground resonance & began to shake violently. It then rolled over on its side, causing the main rotor blades to strike the tail boom & the ground.NTSB MIA86FA146Accident · 1 fatalField investigationFinal reportCessna 150F · Pembroke Pines, FLA witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…NTSB LAX86LA209Accident · No injuriesLimited investigationFinal reportMooney M20C · La Verne, CAA total loss of eng power was experienced while on base leg for landing at brakett field. The acft was landed short of the rwy and a fence was contacted. Post accident inspection revealed the acft's fuel supply had been exhausted.NTSB LAX86DVA07Accident · 1 fatalFinal reportWright BD5B · Merced, CAGround witnesses and the pilot reported the canopy opened shortly after departing runway 30 at Merced airport, Merced, CA. The pilot executed a steep left banking turn. When the airplane turned abt 140 deg it pitched up, rolled inverted and nosed down into…NTSB FTW86LA077Accident · No injuriesLimited investigationFinal reportCessna A185F · Georgetown, TXThe pilot failed to correct for a wing which was lifted in a gust of wind. The wingtip touched the ground and the aircraft nosed over onto it's back and stopped.NTSB FTW86FA076Accident · 1 fatalField investigationFinal reportNorth American SNJ-5 · Anadarko, OKThe pilot radioed that he had smoke in the cockpit. He immediately made an emergency landng, down wind, in a farmer's field. Witnesses saw the aircraft's right wing drop before the plane touched down. The resulting impact tore the wings and engine off,…NTSB DEN86LA127Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Longmont, COThis experimental glider has a stowable 2 cycle eng mounted behind the cockpit. When the eng is stowed the glide ratio is about 40:1. When the eng is deployed but not running, the glide ratio is about 10:1. While returning after a 4 hr and 50 min flt the plt…NTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…NTSB CHI86FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Warren, MIThe acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…NTSB ATL86LA123Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Roanoke, ALThe plt lost control of the acft during an attempted go-around. While on final apch, full flaps were lowered and power was added to maintain 80 KTS. The acft continued descending, the airspeed decreased to 65-70 KTS and the stall warning activated. The plt…NTSB ATL86FEK01Accident · No injuriesFinal reportCessna 182D · Mt. Gilead, OHThe acft collided with the ground in a plowed field during a forced landing after a power loss. Post acc inspection of the eng revealed 3 pieces of felt like seal material lodged in the carburetor venturi. This felt was identical to the missing seal from the…NTSB ATL86FEI05Accident · No injuriesFinal reportPiper J3 · Wauseon, OHThe plt reported that he was landing on rwy 27 with the wind from about 190 degrees at 15 mph, gusting to 23 mph; he executed a normal ldg and was rolling out when a gust of wind lifted up the left wing and the acft ground-looped. The acft subsequently…NTSB SEA86LA117Accident · No injuriesLimited investigationFinal reportHanson Jungmann 131E · Las Vegas, NVDuring rollout after a left x-wind landing and while decelerating through aprx 20-25 mph, the plt encountered a wind gust. Directional control was lost and the acft nosed over as it departed the rwy. The plt reported having only 2 hrs total flt time in this…NTSB MIA86LA145Accident · No injuriesLimited investigationFinal reportPiper 601P · Miami, FLNearing completion of an international flt of nearly 5 hrs duration, the flt advised ATC they were low on fuel & would like vectors to the nearest arpt. The flt was unable to make the arpt & a forced ldg was made in the everglades aprx 6 mi from the arpt. An…NTSB MIA86LA143Accident · No injuriesLimited investigationFinal reportMooney M20C · Starke, FLThe plt stated that during landing, he lost directional control of the acft due to crosswinds. He attempted to abort the landing, however, the landing gear contacted a cattle fence which resulted in a loss of control and impact with the terrain. The acft was…NTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…NTSB LAX86LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Banning, CAThe glider plt lost lift as he flew farther into the mountains with lack of thermal and ridge effect. A landing was attempted which resulted in an overrun into a ravine.NTSB LAX86LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Oakland, CABefore takeoff, the plt tuned in the hayward ATIS & received information alpha, which rprtd the wx was: 2200' scattered,3000' overcast & visibility 8 mi. After taking off from rwy 28R, the plt climbed to about 650' & made a rgt turn. At about that time, the…NTSB LAX86FA207Accident · Serious injuriesField investigationFinal reportCessna P210N · Long Beach, CAWhile enroute from cincinnati, oh (luk), to torrance, CA, the airplane experienced a total engine power loss about 10 miles south of Long Beach airport (lgb), Long Beach, CA. The pilot attempted to land at lgb but the acft alt was insufficient. The acft…NTSB LAX86FA206Accident · 3 fatalField investigationFinal reportMooney M20F · Morgan Hill, CAThe pilot requested and received preflight weather briefings, twice, and was advised that VFR flight was not recommended. The flight departed and crashed into mountainous terrain that was obscured by adverse weather conditions. Witnesses reported that the…NTSB FTW86LA080Accident · No injuriesLimited investigationFinal reportCessna 172M · Dallas, TXThe pilot collided with a fence while taxiing on an airport access road, which he had mistaken for the taxiway. Although the pilot should have exercised better judgement, it has been determined that this same type of mishap has occurred before. After a…NTSB ATL86LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Clyde, OHThe acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…NTSB ATL86LA121Accident · No injuriesLimited investigationFinal reportAyres S-2D-600 · Walterboro, SCThe acft was returning to arpt for fuel then was to resume fighting a forest fire by water dispersal. The acft experienced total fuel exhaustion on short final and force landed 500 ft from rwy.NTSB SEA86LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Twin Falls, IDDuring final apch the ATCT advised the plt of a 17 kt x-wind with gusts to 22 KTS. The plt landed but was unable to maintain directional control and the acft departed the rwy into a grass area. The plt attempted to takeoff again, the wind lifted up the wing…NTSB NYC86LA116Accident · No injuriesLimited investigationFinal reportCessna 152 II · Pittstown, NJOn flare for landing, student pilot encountered wind shear and landed hard, collapsing the nose gear, bouncing off to the left of the runway, nose digging into soft turf, causing aircraft to come to rest inverted. Aircraft was substantially damaged.…NTSB MIA86LA141Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLDuring a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.NTSB LAX86LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Wickenberg, AZA Cessna 152 veered off the rwy and nosed over while on a VFR solo cross country training flt. The plt indicated that during roll the acft began oscillating up and down for aprx 100 feet of travel down the runway. The acft then veered left off the runway. The…NTSB LAX86LA203Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Palmdale, CAThe helicopter landed hard in the desert while on a VFR personal flt. The plt indicated that he just departed a mountian area for refueling. He also indicated he was disoriented and the compass was inoperable. He decided to land and check the fuel quantity.…NTSB FTW86MA074Accident · Serious injuriesMajor investigationFinal reportCessna 310Q · Houston, TXDrg ngt visual apch, plt enctrd dtrtg wx, got vectors for ILS rwy 8 apch, was clrd for apch at 0511 CDT. On final apch, he noted his #1 & #2 ils's giving erratic LOC & g/s info (but functioning) & that his LOC course deviation info didn't agree with adf, but…NTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…NTSB CHI86FEX08Accident · Minor injuriesFinal reportConner KR-2 · Hagerstown, INDrg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for…NTSB ATL86LA124Accident · No injuriesLimited investigationFinal reportCessna 182A · Kenansville, NCDuring a landing attempt, the pilot failed to maintain directional control with a 15 knot right crosswind. The pilot stated that he applied rudder and braking, the aircraft drifted of the left side of the runway and collided with a ditch. The pilot did not…NTSB ANC86LA053Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe pilot stated that he was taxiing for takeoff on the frozen river when the left main gear broke through the ice. The aircraft's left wing and left gear were damaged.NTSB ANC86LA052Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee L-13 · Fairbanks, AKDuring the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At…NTSB MKC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fulton, MOThe pilot and his passenger were on a short flight to check the operation of a VOR receiver. While they were on the landing roll, a gust of wind turned the nose of the airplane to the left and the airplane ran off the runway and the right gear hit a runway…NTSB MIA86LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Hastings, FLThe plt stated she landed long and over ran the runway. She continued to state a go-around should have been performed.NTSB FTW86FA075Accident · Serious injuriesField investigationFinal reportRockwell 112A · El Paso, TXThe plt rprtd that the eng quit immediately after takeoff. During an emerg landing on arpt property, the acft collided with a sand dune & nosed over. An exam of the eng revealed no discrepancies. The extent of damage prevented a thorough exam of the fuel sys.…NTSB FTW86FA073Accident · 1 fatalField investigationFinal reportPartenavia P68C · Goudeau, LAThe pilot received a weather briefing indicating IMC conditions existed at the point of departure and at reporting stations near the point of the first intended landing. (There was no reporting stations at the airport of intended landing). Weather conditions…