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 DEN86LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Monument Valley, UTThe plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There…Jul 30, 1986 · N8272Y · Substantial damageNTSB CHI86LA190Accident · No injuriesLimited investigationFinal reportBeech B-19 · Manchester, MIThe pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown.Jul 30, 1986 · N6517R · Substantial damageNTSB CHI86FEP07Accident · No injuriesFinal reportWheeler Gold Wing · Sturdevant, WIThis aircraft force landed shortly after takeoff and was substantially damaged when the wing struck the shoulder of a ditch during the landing. An examination of the engine after the accident revealed that the fuel pump was improperly installed (not in…Jul 30, 1986 · N54314 · Substantial damageNTSB ANC86LA117Accident · No injuriesLimited investigationFinal reportCessna 185E · Tetlin, AKAcft left rwy and crashed during attempted go-around with 10 to 25 knot crosswind. Pilot stated that engine did not develop full power. Examination and test run of engine did not reveal any mechanical failures/malfunctions.Jul 30, 1986 · N1613M · Substantial damageNTSB SEA86LA183Accident · Minor injuriesLimited investigationFinal reportCessna 182 · East Sound, WADuring landing roll at about 25 mph the pilot applied both brakes. A short time thereafter the right brake pedal went to the floor. Despite the pilot's application of hard left brake and rudder, the acft veered to the left into a drainage ditch. The nose gear…Jul 29, 1986 · N71131 · Substantial damageNTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…Jul 29, 1986 · N9417A · Substantial damageNTSB FTW86LA140Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Roanoke, TXThe pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down…Jul 29, 1986 · N5753L · DestroyedNTSB CHI86LA185Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Morris, ILDuring cruise flight, the engine stopped and the pilot attempted to glide to an airport, but was forced to land in a cornfield, aprx one mile short of the airfield. A post-crash inspection revealed the flange of the left intermediate exhaust pipe (pn…Jul 29, 1986 · N81753 · Substantial damageNTSB CHI86FER15Accident · No injuriesFinal reportSamuel R. Hoskins Q-200 · Eden Prairie, MNAircraft was being test flown following ground adjustment of rudder control cables. During the flight rudder control was lost when rudder bearing blocks detached from their mounting surfaces. Pilot was unable to maintain directional control during landing…Jul 29, 1986 · N202SH · Substantial damageNTSB SEA86LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Snohomish, WAThe student was attempting to depart with a quartering tailwind. The aircraft was veering to the left of the centerline and the pilot rotated prematurely. The aircraft settled back to the ground to the left of the runway onto uneven terrain. At the time of…Jul 28, 1986 · N6509L · Substantial damageNTSB NYC86LA192Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Wolfeboro, NHWhile landing, the aircraft bounced slightly & the plt lost directional control. The aircraft veered left over the runway edge onto a soft shoulder, nosed over & was damaged.Jul 28, 1986 · N396X · Substantial damageNTSB NYC86FGM06Accident · 1 fatalFinal reportKenneth Patsch FLY Baby II · Franklin Center, PAThe plt reported that the acft banked excessively during the left turn from base to final. Opposite control input was applied, however, the plt reported the 'stick seemed to have no right movement.' Full power was applied but the bank steepened so power was…Jul 28, 1986 · N14OP · DestroyedNTSB MKC86LA162Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dumas, ARThe pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine…Jul 28, 1986 · N5694X · DestroyedNTSB LAX86LA306Accident · No injuriesLimited investigationFinal reportCessna 195 · Ramona, CAThe aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a…Jul 28, 1986 · N3899V · Substantial damageNTSB FTW86LQG17Accident · No injuriesFinal reportMcculloch J-2 · Stanton, TXPilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available.Jul 28, 1986 · N4319G · DestroyedNTSB CHI86LA186Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mattoon, ILThe glider was being towed for takeoff behind a tow plane. According to the glider instructor, the initial acceleration appeared normal. As the tow plane and the glider neared the end of the runway, the glider instructor believed the tow plane was…Jul 28, 1986 · N65901 · Substantial damageNTSB CHI86FA183Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Plainfield, ILWitnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,…Jul 28, 1986 · N6135L · DestroyedNTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…Jul 28, 1986 · N96701 · DestroyedNTSB ANC86FA116Accident · 2 fatalField investigationFinal reportStinson 108-2 · Willow, AKAbout 5 to 10 min prior to the acdnt, svrl witnesses in the vicinity of the Willow arpt saw the acft headed southbound. They rprtd the eng was running rough, but they saw no smoke or fire. Aprx 3 mi further south, other witnesses saw the acft make a 180 deg…Jul 28, 1986 · N942D · DestroyedNTSB ANC86FA115Accident · Minor injuriesField investigationFinal reportStinson ST108 · Chugiak, AKThe aircraft lost power in flight and crashed into a wooded area. VMC conditions prevailed and a VFR flight plan was filed. On site examination of the fuel tanks revealed that less than a quart of fuel remained in both tanks.Jul 28, 1986 · N75092 · Substantial damageNTSB SEA86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Colville, WAWhile making a power off approach to simulate a forced landing an over shoot was assured. The plt added pwr and the engine ceased operating. In order to avoid trees at the end of the runway the pilot made a 90 degree turn to land in a plowed field. The acft…Jul 27, 1986 · N9425A · Substantial damageNTSB NYC86LA188Accident · No injuriesLimited investigationFinal reportBeech BE-20 · Farmingdale, NYAfter a short distance on the takeoff roll, the aircraft veered sharply to the left. Pilot attempted to correct, but was unsucessful and the aircraft collided with parked unoccupied aircraft.Jul 27, 1986 · N83BA · Substantial damageNTSB MKC86LA159Accident · No injuriesLimited investigationFinal reportCessna T188C · Davenport, IAThe ag pilot was spraying a field when he impacted powerlines which removed the upper one-third of the vertical stab and rudder. On landing he groundlooped and collapsed the right main gear.Jul 27, 1986 · N9975J · Substantial damageNTSB MKC86LA158Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Audubon, IAThe pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…Jul 27, 1986 · N9835U · Substantial damageNTSB MIA86LA220Accident · No injuriesLimited investigationFinal reportCessna T337H · Marathon, FLWitnesses reported the pilot arrived for the flight carrying a glass from a local bar, was uncoordinated and appeared intoxicated. After much difficulty in taxiing to the runway, he finally took off. On arrival at Marathon, FL, the pilot failed to extend the…Jul 27, 1986 · N1343L · Substantial damageNTSB LAX86LA305Accident · No injuriesLimited investigationFinal reportNavion A · Grass Valley, CAA Navion a landed hard on rwy 01 after an attempted go-around. The plt indicated that he was landing to the north with full flaps and discovered he had a gusting tailwind. He initiated a go-around and at 50 ft AGL he brought the flaps up halfway. The acft…Jul 27, 1986 · N111T · Substantial damageNTSB LAX86FA307Accident · 1 fatalField investigationFinal reportCherry HP16 · Llano, CAThe glider pilot departed on a local flight and the wreckage of his glider was spotted a little over an hour later. There were no known witnesses to the accident which occurred in VFR daylight conditions.Jul 27, 1986 · N118PC · DestroyedNTSB LAX86FA304Accident · 1 fatalField investigationFinal reportPlaymate SA-11A · Yucca Valley, CAThe PIC planned a local flight in his homebuilt 'Playmate' experimental acft. A witness reported observing the acft 1/8 mi n of the uncontrolled arpt in a spin. The plt recovered fm the spin at 200 ft AGL, & then entered a near vertical descent until…Jul 27, 1986 · N315W · DestroyedNTSB LAX86FA303Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Yosemite Nation, CAAfter flying low over Yosemite national park the Piper PA-32-260, operating as an on-demand passenger flight, climbed eastward into rising terrain. The flight path selected by the pilot was approximately one mile north and 1000 feet higher than tioga pass…Jul 27, 1986 · N3643W · DestroyedNTSB FTW86FPA25Accident · No injuriesFinal reportThorpe T18 · Mckinney, TXThe acft was landed on a closed rwy where it collided with steel posts embedded in the rwy. The plt had questioned a Cessna plt who made a go-around in front of him about the status of the rwy and wad advised it was closed. The plt saw the flag & an 'x' but…Jul 27, 1986 · N7JA · Substantial damageNTSB DEN86LA212Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe plt reports that he was making a t&g on the 5400 by 200, asphalt rwy. The wind was light. The plt said he had reconfigured the acft for takeoff and was about to advance the throttle when the acft swerved to the right and ran off the rwy. After leaving the…Jul 27, 1986 · N3056A · Substantial damageNTSB DEN86FA211Accident · Serious injuriesField investigationFinal reportSteven Soper Pitts S-1T · Shelby, MTDuring initial climb after takeoff from a private ranch airstrip, the acft engine quit. The plt had inadvertently left the fuel selector switch in the no. 2 position which allowed oil, normally used to produce smoke during aerial demonstrations, to enter the…Jul 27, 1986 · N155NK · DestroyedNTSB CHI86LA188Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Winneconne, WIWhile landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed.Jul 27, 1986 · N4865V · Substantial damageNTSB CHI86LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Traverse City, MIWhile flaring to land, the aircraft had excessive speed and ballooned. Subsequently, it bounced twice, then began to veer to the left. The pilot performed a go-around. During the initial portion of the go-around, the left wing struck a runway edge identifier…Jul 27, 1986 · N2185B · Substantial damageNTSB BFO86FID10Accident · 1 fatalFinal reportQuickie Q200 · Newport News, VAThe acft went out of control and crashed from aprx 100 AGL after takeoff. The acft was on a test flt and after the crash the plt said that the acft was pulling to the rt during takeoff so he reduced power. The acft continued to pull rt before nosing down to…Jul 27, 1986 · N45CX · DestroyedNTSB ATL86LA210Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Huntersville, NCPlt was practicing touch-and-go and emer proc. He was high on base and attempted to correct alt, struck a ditch 200 feet short of the rwy with rt ldg gear. Acft came to a stop 100 feet short of rwy in second grass filled ditch.Jul 27, 1986 · N7689S · Substantial damageNTSB ANC86LA113Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Anchorage, AKThe acft contacted a roadside embankment during a forced landing following an engine failure due to fuel exhaustion. The acft had operated 5.1 hours since it was last refueled. The acft operator reported 4.5 hours is the normal endurance for the acft.Jul 27, 1986 · N1504Q · Substantial damageNTSB ANC86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Umiat, AKPilot stated the engine quit due to fuel exhaustion during final approach, forcing him to land on a short unsuitable gravel bar. Aircraft nosed over upon landing and came to rest in 10 feet of water.Jul 27, 1986 · N3366Z · Substantial damageNTSB ANC86FA114Accident · 2 fatalField investigationFinal reportInterstate S-1B2 · Wasilla, AKWitnesses rprtd that immediately after taking off from the Wasilla lake seaplane base, the acft entered a steep climbing turn. Shortly thereafter, it entered a steep dscnt & crash into the water. There was evidence that the acft entered a stall/spin prior to…Jul 27, 1986 · N51AA · Substantial damageNTSB NYC86LA187Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boston, MAShortly after takeoff, the aircraft was unable to continue climb out. The pilot lowered the nose to level flight, however the airspeed continued to drop and the aircraft crashed. The continued drop in the airspeed was undetermined.Jul 26, 1986 · N333TE · DestroyedNTSB MIA86LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Fort Myers, FLThe plt stated that his non-rated wife was onboard the acft while he was pulling the propeller through, priming the engine. While doing so, the engine started due to the mag switch being left on. The acft then taxied uncontrolled, colliding with a parked…Jul 26, 1986 · N13351 · Substantial damageNTSB FTW86LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fort Worth, TXThe pilot touched down long but with adequate runway remaining. However, he delayed brake application and as a result was still going too fast to turn off at the end of the runway. Collision with the runway end barrier occurred.Jul 26, 1986 · N5088D · Substantial damageNTSB DEN86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fargo, NDThe plt reports that the flt was descending through 7,000 ft approaching the dest arpt when the eng began to run rough and lost pwr. The flt continued toward to the arpt but was unable to reach the rwy and landed about 1/4 mi short. After touchdown the acft…Jul 26, 1986 · N7592W · DestroyedNTSB DEN86FA210Accident · Serious injuriesField investigationFinal reportBurkhart Grob G-102 Astir CS · Black Forest, COThe glider plt, took off at 1155 and was towed to an alt of 10,200 ft MSL and released. The plt said that a rapidly developing thunderstorm cut off his route back to the glider port and he was forced to make an off airport landing at about 1300. The plt said…Jul 26, 1986 · N144SS · DestroyedNTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…Jul 26, 1986 · N4346L · 2 aircraft · DestroyedNTSB CHI86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dodgeville, WIAccording to the pilot, his brakes failed and he was unable to stop before going off the end of the runway and over a 30 foot embankment. During an inspection, the brakes and braking system were found to be free of any defects and in proper working order.…Jul 26, 1986 · N80510 · Substantial damageNTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…Jul 26, 1986 · N2444N · Substantial damageNTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…Jul 26, 1986 · N64HW · DestroyedNTSB CHI86FA179Accident · 2 fatalField investigationFinal reportStinson 108-3 · Shiocton, WIWitnesses rprtd that prior to the acdnt, the acft was flying at a very low level, near treetop level, over residences, a ball park & a lake park. Subsequently, the acft collided with a utility pole & trees, then crashed into a private residence & burst into…Jul 26, 1986 · N6567M · DestroyedNTSB ATL86LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Ringgold, GAThe pilot reported he attempted to make a 180 degree turn because he realized he was getting too close to an airport while on a cross country flight. A highway patrolman said the pilot told him he became disoriented during the turn, cut the power to land, and…Jul 26, 1986 · N71713 · Substantial damage