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 SEA86LA151Accident · No injuriesLimited investigationFinal reportNavion A · Boise, IDThe pilot elected to land onto a road to pick up a passenger. The pilot failed to maintain adequate clearance from a wire fence to the right of the road and caught the right wing.Jun 13, 1986 · N5208N · Substantial damageNTSB SEA86LA146Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Moore, IDDuring an aerial application turn a rapid rate of descent developed. The pilot released the chemical load at about 100 feet AGL and the aircraft continued to descend to the ground even though the pilot leveled the wings and initially lowered the nose. The…Jun 13, 1986 · N3742E · DestroyedNTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…Jun 13, 1986 · N34889 · Substantial damageNTSB FTW86FPA24Accident · 1 fatalFinal reportRepliea 78 Ral Fokker DV III · Slidell, TXThe shutoff mechanism and handle separated from the fuel shutoff valve body and fell to the floor. This stopped the fuel flow to the engine, resulting in a total loss of engine power in the uncetificated home built aircraft. It was not determined why the…Jun 13, 1986 · N2782A · DestroyedNTSB FTW86FA116Accident · 1 fatalField investigationFinal reportMBB 105 · Houma, LAA fatigue failure in a main rotor blade pitch change link resulted in the loss of control of one blade, leading to an in flight separation of the tail boom. The helicopter was uncontrollable and pitched forward, impacting the ground inverted.Jun 13, 1986 · N2784E · DestroyedNTSB FTW86FA107Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Huffman, TXThe pilot was being vectored around thunderstorms in the area just prior to the accident. During the last radio contact the pilot was issued a vector to the destination airport. During this turn, for unknown reasons, the pilot lost control of the aircraft and…Jun 13, 1986 · N3539K · DestroyedNTSB CHI86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Breckenridge, MNAircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision.Jun 13, 1986 · N6184A · Substantial damageNTSB ANC86FA074Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Volkmar Lake, AKAfter touchdown the pilot lost directional control of the aircraft causing the right wingtip to strike the water. The aircraft then rolled over and sank. The PIC was operating the aircraft and carrying passengers with only student pilot certificate.Jun 13, 1986 · N413X · Substantial damageNTSB SEA86LA143Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAEn route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.…Jun 12, 1986 · N11VH · DestroyedNTSB SEA86FA144Accident · 2 fatalField investigationFinal reportSanders Starduster TWO · Mead, WAA witness reported seeing the aircraft perform a series of loop maneuvers. At the top of the last loop, the acft rolled upright then rolled into a near vertical right spin which continued to ground impact. The pilot had no history ofspin recovery practice in…Jun 12, 1986 · N118JB · DestroyedNTSB MIA86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Jacksonville, FLThe eng failed & a forced ldg was performed in a field. During the ldg roll-out, the acft struck a fence. An on-scene exam of the acft revealed a substantial quantity of fuel remaining in the tanks and there was no evidence of any foreign matter within the…Jun 12, 1986 · N6603C · Substantial damageNTSB LAX86LA250Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Colusa, CAThe plt was practicing takeoffs and landings when the acft's landing gear caught a berm on short final and the acft nosed over. The plt stated that there was no mechanical failure or malfunction of the acft.Jun 12, 1986 · N68467 · Substantial damageNTSB FTW86LA109Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tahoka, TXThe acft nosed over during a forced landing in a fld following a loss of pwr due to fuel exhaustion. The plt reported that after aprx 9 minutes of flt a total loss of pwr was experienced. The plt selected an open fld in which to land. The nose gear sunk in…Jun 12, 1986 · N5195U · Substantial damageNTSB FTW86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mesquite, TXThe pilot was making touch and go landings when, during the climb-out, the aircraft stalled and entered a spin. There was no recovery and the aircraft collided with the ground. The pilot stated that the engine quit; however, an engine teardown failed to…Jun 12, 1986 · N23039 · DestroyedNTSB DEN86LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDAccording to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground.Jun 12, 1986 · N751Y · Substantial damageNTSB DEN86LA159Accident · No injuriesLimited investigationFinal reportCessna 150L · Bountiful, UTThe plt said he had been airborne for about 1.25 hrs when the eng began to cut out. Emerg procedures did not remedy the situation and an off arpt forced landing was necessary. The plt said he did not look in the fuel tanks prior to takeoff but relied on the…Jun 12, 1986 · N1739Q · Substantial damageNTSB ANC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Theodore River, AKThe pilot stated that during the takeoff roll he lost directional control of the aircraft causing the aircraft to strike a row of trees.Jun 12, 1986 · N5837D · Substantial damageNTSB ANC86LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilots of each acft stated they thought that the left float and prop of the Taylorcraft had come in contact with the rt wing and rt landing gear of the Piper. The plts failed to see the other acft in time to avoid the collision. Both acft nosed over…Jun 12, 1986 · N8597D · 2 aircraft · Substantial damageNTSB SEA86LA142Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane 1 · Petersburg, AKAfter derarting the arpt and flying about 75 ft AGL, the plt added power and attempted to climb. There was a power hesitation and the acft did not clear trees in it's path. The acft struck trees and descended to ground impact. The plt stated that he thought…Jun 11, 1986 · N8W · Substantial damageNTSB SEA86FA145Accident · 2 fatalField investigationFinal reportGrumman AA-5A · Round Mountain, NVThe pilot and passenger departed on a local flight to spot potential fishing locations in mountainous terrain. High density altitude conditions existed at the time/place of the accident. Kinematics information from the accident site indicates that as the…Jun 11, 1986 · N9761U · DestroyedNTSB MIA86LA179Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · St.Augustine, FLA forced ldg was made after the eng failed while cruising at 8000 ft. an exam of the eng revealed that the top of the crankcase was cracked & a hole was in the top of the case at the no. 2 cylinder. The bottom of the cap of the no. 2 connecting rod had broken…Jun 11, 1986 · N8495P · Substantial damageNTSB MIA86LA178Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt stated that he was attempting a practice soft-field takeoff from rwy 18. Just prior to rotation the main gear contacted a bump in the airstrip and the acft drifted to the left. The acft continued left where it struck trees alongside the rwy.…Jun 11, 1986 · N2378D · Substantial damageNTSB MIA86LA176Accident · No injuriesLimited investigationFinal reportCessna 411 · Tallahassee, FLThe plt observed a fuel spill on the ground as a result of refueling overflow. He attempted to start the engines & an explosion & fire resulted.Jun 11, 1986 · N4959T · Substantial damageNTSB MIA86LA175Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Graceville, FLA witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he…Jun 11, 1986 · N5630X · DestroyedNTSB CHI86LA149Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Brodhead, WIThe plt was making a low pass over a friend's house. He was waving to the people on the ground and when he looked up he was too close to a tree to avoid hitting it. The plane then descended to the ground.Jun 11, 1986 · N98739 · Substantial damageNTSB BFO86LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Mt. Holly, VAThe nose gear was sheared off when the acft contacted a ditch during an overrun landing. Upon arriving at the pvt airstrip the plt circled the rwy and decided it was suitable for landing. Touchdown was made 400 ft down the rwy and normal deceleration was…Jun 11, 1986 · N6264Y · Substantial damageNTSB ATL86IA167Incident · No injuriesIncident investigationFinal reportBeech H35 · Birmingham, ALDuring takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway.Jun 11, 1986 · N7989D · Minor damageNTSB NYC86LA150Accident · Serious injuriesLimited investigationFinal reportAerosport Scamp · Columbia, PAThe aircraft crashed shortly after takeoff due to insufficient airspeed and altitude gain.Jun 10, 1986 · N1031M · Substantial damageNTSB FTW86IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31 · Kingston, OKAcft received minor damage as a result of an electrical fire in-flight while in cruise at 9,000' MSL. The plt stated that he observed smoke emanating from the c.b. panel mounted on the left side wall of the cockpit and that several c.b.'s popped and he lost…Jun 10, 1986 · N68ST · Minor damageNTSB FTW86FRG26Accident · 1 fatalFinal reportBenson B-8M · New Braunfels, TXThe acft crashed out of control after the eng stopped during a landing approach, the acft had almost completed the 1st pattern around the field when the eng stopped. Investigation revealed a 1/4 inch nylon rope wrapped and tied around the rotor blade about 30…Jun 10, 1986 · N632X · DestroyedNTSB CHI86LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Belleville, MIThe plt aware she was ld on a 1750' wet grass strip elected to ld over high tension lines in calm wind. Pilot made two approaches and ld on third. Pilot aware of poor braking action turned off ignition. Acft ran off end of rwy and struck a ditch.Jun 10, 1986 · N5369F · Substantial damageNTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.Jun 10, 1986 · N20052 · Substantial damageNTSB ANC86LA070Accident · No injuriesLimited investigationFinal reportCessna 175 · Port Alsworth, AKThe airplane experienced an engine failure while in cruise flight and subsequently overran the forced landing area.Jun 10, 1986 · N7460M · Substantial damageNTSB ANC86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nulato, AKA witness on the ground watched the airplane fly the landing pattern for landing and at no time did he see the landing gear extend. He watched the airplane until it passed below the tree line. Testing of the hydro-mechanical and electrical systems did not…Jun 10, 1986 · N41078 · Minor damageNTSB ANC86FA071Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Girdwood, AKThe instructor pilot gave the student pilot a forced landing while on left base to runway 19. The student continued the approach at approximately 200 feet noticed the rate of descent increasing. The student applied full power but the airplane continued to…Jun 10, 1986 · N4418Z · Substantial damageNTSB NYC86LA149Accident · No injuriesLimited investigationFinal reportCessna U206 · Presque Isle, MEAccording to the plt, the eng lost power about 10 min after he took off while flying at low altitude. He landed in a field that was surrounded by trees. Drg the landing, the rgt float, rgt wing & rgt side of the empennage were damaged. No reason was found for…Jun 9, 1986 · N8384Q · Substantial damageNTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…Jun 9, 1986 · N5695R · Substantial damageNTSB LAX86FA249Accident · 1 fatalField investigationFinal reportCarnes Osprey 2 · Julian, CAWitness statements & examination of the wreckage revealed that the aircraft struck the ground as a result of a stall-spin type accident near the end of the closed portion of a box canyon about 200 feet below the top of the ridge. The investigation revealed…Jun 9, 1986 · N627JC · DestroyedNTSB LAX86FA248Accident · 1 fatalField investigationFinal reportBeech V35B · Del Rey Oaks, CAApproaching the destination arpt the plt informed ATC that he did not feel well and desired to land 'as quickly as possible.' The plt was cleared to land. While on a right base leg the acft pitched 45 degrees nose down, and collided with terrain and a…Jun 9, 1986 · N4457W · DestroyedNTSB ATL86LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Parkton, NCWhile practicing a simulated forced landing the aircraft stalled and crashed into the trees. The pilot related that the aircraft lost power. Post crash examination of the wreckage failed to disclose any pre-existing mechanical failure or malfunction which…Jun 9, 1986 · N66468 · Substantial damageNTSB ANC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 15 AC Sedan · Neal Lake, AKAccording to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was…Jun 9, 1986 · N1450H · Substantial damageNTSB ANC86LA067Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Deshka River, AKThe pilot stated while landing at an unimproved airstrip the aircraft's left main landing gear struck a bush causing the aircraft to ground loop.Jun 9, 1986 · N31285 · Substantial damageNTSB SEA86FA139Accident · Serious injuriesField investigationFinal reportHiller UH12B · Rathdrum, IDThe plt reported noticing the fuel gage was nearing empty shortly before the eng quit. The acft crashed during an attempted forced landing on a road. The plt stated he was flying the acft to his residence where it was based. Investigation revealed little fuel…Jun 8, 1986 · N41319 · DestroyedNTSB MIA86LA174Accident · No injuriesLimited investigationFinal reportRandy Tredo Mustang II · Ocala, FLThe plt stated that just after takeoff he lost all engine power and upon landing in an open field the gear collapsed. Examination of the eng revealed that the butterfly valve in the carburetor heat box broke off and slid back into the carburetor opening and…Jun 8, 1986 · N78RT · Substantial damageNTSB LAX86LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Santa Margarita, CAThe pilot stated that he had problems with his navigation radio and overflew his destination airport. He subsequently became disoriented, ran one fuel tank dry, and then made a precautionary landing, since he was low on fuel. On landing, the nose gear…Jun 8, 1986 · N1787P · Substantial damageNTSB LAX86FA243Accident · Serious injuriesField investigationFinal reportBell 206B · Hanalei, HIThe helicopter had just departed runway 05. Ground witnesses and several occupants in the helicopter reported that when it was about 150 ft AGL it sustained a total engine power loss. The pilot immediately entered into an abrupt right turn autorotation. The…Jun 8, 1986 · N29906 · DestroyedNTSB FTW86LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Witchita Falls, TXDuring the ground run portion of the takeoff, the pilot lost directional control of his taildragger aircraft. As the aircraft was spinning around the right gear struck a small ditch and broke the landing gear off, causing the aircraft to come to rest on its…Jun 8, 1986 · N37RA · Substantial damageNTSB DEN86LA158Accident · No injuriesLimited investigationFinal reportBeaver Evans VP-1 · Glade Park, COThe plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft.Jun 8, 1986 · N23RB · Substantial damageNTSB BFO86LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Concord, VAThe acft experienced a total loss of pwr during cruise. A forced ldg was made on a hwy and the acft struck a road sign. Post-crash examination of the acft engine revealed an inoperative engine fuel pump.Jun 8, 1986 · N2349H · Substantial damageNTSB ATL86LA164Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Benton, TNThe glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he…Jun 8, 1986 · N2135R · Substantial damage