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 BFO87IA008Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Norfolk, VADuring the landing roll the r main gear collapsed. A flight attendant received minor injuries during evacuation of the acft. Examination of the acft disclosed that the shock strut cylinder fractured circumferentially; about 10 inches below the top of the…Nov 16, 1986 · N64323 · Minor damageNTSB NYC87LA035Accident · No injuriesLimited investigationFinal reportCessna 185F · Ithaca, NYThe pilot of the landing Cessna 185 swerved to avoid hitting a deer that was crossing the runway at night. The left wing tip and elevator contacted the runway as the aircraft ground looped. The aircraft received substantial damage, however, it was able to…Nov 15, 1986 · N9680H · Substantial damageNTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…Nov 15, 1986 · N6863N · Substantial damageNTSB MKC87LA018Accident · No injuriesLimited investigationFinal reportCessna 150H · Flippin, ARWhile the student pilot was practicing touch-and-go landings, the airplane ran off the side of the runway, hit a ditch and flipped forward to the inverted position. The pilot stated he thought one of the brakes had locked. There was no signs of excessive…Nov 15, 1986 · N22037 · Substantial damageNTSB LAX87LA063Accident · No injuriesLimited investigationFinal reportCessna 310K · Phoenix, AZThe acft was landed hard while on a pleasure flt. The plt indicated that while en route to his destination it was discovered that the door was not properly shut. He diverted to Phoenix to shut the door. The acft was observed descending vertically from aprx 40…Nov 15, 1986 · N6953L · Substantial damageNTSB LAX87FA040Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Corona, CAThe plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second…Nov 15, 1986 · N621SR · 2 aircraft · Substantial damageNTSB DEN87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Peyton, CONC3004N, registered to the plt, ground looped during takeoff in a right quartering tailwind, with a check plt aboard. The plt said that upon rotation he elected to abort the flt. He abruptly reduced the power, the acft settled to the ground and ground looped.…Nov 15, 1986 · N3004N · Substantial damageNTSB CHI87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Sandwich, ILThe pilot was attempting to hand prop the aircraft due to a low battery. The engine started and the plane began moving. The aircraft struck the pilot and then traveled into a hangar door.Nov 15, 1986 · N3289U · Minor damageNTSB CHI87LA032Accident · No injuriesLimited investigationFinal reportBurkhart Grob 109B · Gregory, MIWhile landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the…Nov 15, 1986 · N58287 · Substantial damageNTSB SEA87LA025Accident · No injuriesLimited investigationFinal reportHughes 369D · Winlock, WAThe plt was loading xmas trees from a farm to a truck. He had just released a load and was en route back to the pickup area when the empty long-line sling contacted treetops. The sling rebounded into the tail rotor & damaged the gear box which resulted in…Nov 14, 1986 · N1089D · Substantial damageNTSB NYC87LA033Accident · No injuriesLimited investigationFinal reportCessna 33TC · Phillipsburg, PAThe Cessna 337 experienced engine surging and plt made a precautionary landing at an airport while enroute to destination. The aircraft landed 200 ft short of the runway and received substantial damage while the two occupants were not injured. On scene…Nov 14, 1986 · N2581S · Substantial damageNTSB NYC87LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Philadelphia, PADuring hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the…Nov 14, 1986 · N82089 · DestroyedNTSB MIA87LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Cedar Key, FLThe plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt…Nov 14, 1986 · N20816 · Substantial damageNTSB LAX87FA039Accident · 2 fatalField investigationFinal reportBeech D55 · Livermore, CAWitnesses stated that the aircraft started the takeoff roll, became airborne at about 1000 feet down the runway, climbed to an altitude of about 50 feet, rolled to the left and crashed inverted onto a parallel taxiway at about mid field. There was no fire.…Nov 13, 1986 · N8386N · DestroyedNTSB DCA87MA012Accident · No injuriesMajor investigationFinal reportLockheed L1011 · Newark, NJOn November 13, 1986, the rear main spar of the right wing failed as delta flt 194 touched down on rwy 29 at Newark airport. The pilots stated that there was moderate turbulence on final approach and initial touchdown was on the right main gear first. The…Nov 13, 1986 · N714DA · Substantial damageNTSB CHI87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Minneapolis, MNThe pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.Nov 13, 1986 · N7668Y · Substantial damageNTSB SEA87LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corral, IDThe plt was scouting for elk in rugged rising terrain. The eng began losing power, so he applied carburetor heat. However, the RPM dropped further & the acft crashed on wooded terrain. No mechanical difficulties were found. County authorities stated that…Nov 12, 1986 · N12870 · Substantial damageNTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.Nov 12, 1986 · N925J · Substantial damageNTSB MIA87FA031Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Columbus, MSThe acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in…Nov 12, 1986 · N21188 · DestroyedNTSB LAX87LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · San Jose, CAThe acft went through a fence and collided with trees after a 'hand-propped' start. The student plt had exhausted the acft battery power during previous starting attempts. He then tied the acft down at both wings and the tail. He primed the eng with the…Nov 12, 1986 · N5153W · Substantial damageNTSB CHI87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Detroit, MIUpon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…Nov 12, 1986 · N8161K · Substantial damageNTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…Nov 12, 1986 · N471BN · 2 aircraft · No damageNTSB MKC87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Gretna, NEThe instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for…Nov 11, 1986 · N5175M · Substantial damageNTSB LAX87LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Buckeye, AZA Cessna T210N crashed when the pilot attempted to underfly wires during a go-around. The pilot misjudged the surface winds and made his final approach with a tail wind. When he passed the midpoint on the 2,600 ft airstrip and still was not on the ground he…Nov 11, 1986 · N1625U · Substantial damageNTSB FTW87LA016Accident · Minor injuriesLimited investigationFinal reportBell 206L · Galveston, TXThe plt was attempting to hover in a tailwind of 35 KTS which exceeded the acft manufacturers performance limitiations for operations in allowable relative wind. The plt lost control of the acft on lift-off. The acft rolled over and came to rest on its right…Nov 11, 1986 · N16772 · Substantial damageNTSB CHI87LA028Accident · No injuriesLimited investigationFinal reportBeech 23 · Laporte, INThe plt stated that at the initial full throttle position the acft developed 2450 RPM. According to the plt, at approximately 200 feet of altitude he noticed a loss of rpm's to 2050 and he immediately rechecked the throttle and mixture controls, the magneto…Nov 11, 1986 · N2335Q · Substantial damageNTSB CHI87LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Winamac, INAfter noticing a vague shape off the right side of the aircraft, during takeoff run at night, the pilot continued down the runway until the aircraft collided with a 180 pound deer.Nov 11, 1986 · N75363 · Substantial damageNTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…Nov 10, 1986 · N89543 · Substantial damageNTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…Nov 10, 1986 · N47042 · Substantial damageNTSB CHI87LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · South Bend, INDuring cruise at 7000' MSL, the plt assumed that he was having an electrical failure because he had not heard any ARTCC transmissions, fuel gauges were indicating low fuel, ammeter reading was zero, and landing gear would not cycle. He shut off all electrical…Nov 10, 1986 · N578PA · Substantial damageNTSB ANC87IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Adak, AKA canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at…Nov 10, 1986 · CGCPJ · 2 aircraft · No damageNTSB SEA87LA053Accident · No injuriesLimited investigationFinal reportPiper PA-46-310-P · Bremerton, WAThe nose gear did not turn the full 90 degrees prior to locking for landing. When the aircraft's nose was lowered during landing roll this caused the aircraft to veer to the side of the runway. The nose gear had become stiff due to the fact that the…Nov 9, 1986 · N4323N · Substantial damageNTSB SEA87LA022Accident · No injuriesLimited investigationFinal reportCessna 182G · Juneau, AKAccording to the plt, he 'greased' the acft on the rwy, but the cast alluminum yoke on the nose gear failed & the nosewheel left the airplane. The strut then failed & the acft was further damaged.Nov 9, 1986 · N2038R · Substantial damageNTSB LAX87LA053Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perris, CAA Schweizer sgs 2-33 glider collided with a drainage ditch after a forced landing two miles short of the airport. The glider lost lift and was unable to return to the airport due to power lines in the flight path. The pilot made a 180 degree turn and landed…Nov 9, 1986 · N50CS · Substantial damageNTSB LAX87LA036Accident · No injuriesLimited investigationFinal reportCessna 150L · Elk Grove, CAAs the plt was returning from a local flight, the engine lost power for about 15 seconds, then restarted. The plt checked the fuel gauges which indicated one tank was empty and the other was 1/4 full. At about 1-1/2 miles from the airport, the engine lost…Nov 9, 1986 · N5360Q · Substantial damageNTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…Nov 9, 1986 · N7558 · Substantial damageNTSB FTW87LA015Accident · Serious injuriesLimited investigationFinal reportHouk Pitts S1-S · La Porte, TXA mechanic was attempting to pull the prop through one revolution prior to starting the engine on a pitts S1-S. Due to a bad p-lead on the magneto's the engine fired, causing the prop to strike the right leg of the mechanic. The mechanics leg was amputated…Nov 9, 1986 · N35DH · No damageNTSB CHI87DEX01Accident · No injuriesFinal reportTurnbloom Kitfox · Crawfordsville, INThe plt rprtd that when he was preparing for the acft's 1st test flt, he made a hi speed run with the tail raised & acft control was good. On the next run, he planned to let the acft lift off the rwy, then let it settle back on the surface. He stated that he…Nov 9, 1986 · N371DT · Substantial damageNTSB ATL87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCOne blade of the fixed pitch propeller separated 3' from the hub during a routine instructional flight. The imbalance resulted in a broken engine mount and a total loss of power was experienced. A forced landing was made in a soft field during which, the…Nov 9, 1986 · N6537P · Substantial damageNTSB ATL87LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring a local instructional flight, the CFI was demonstrating a simulated emergency landing to a field to a 5 hour pre-solo student pilot. During recovery the aircraft was reportedly affected by a downdraft and collided with a wire. The acft began losing…Nov 9, 1986 · N6617L · DestroyedNTSB SEA87LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Bellingham, WADrg an attempted start, the eng backfired & an induction fire started. However, the plt did not continue cranking the eng. Strong surface winds inhibited the effectiveness of the acft's portable fire extinguisher. The plt then attempted to use an extinguisher…Nov 8, 1986 · N2654G · Substantial damageNTSB SEA87LA021Accident · Serious injuriesLimited investigationFinal reportBellanca BL17-30 · Beatty, NVWhile in cruise at 11,500 ft MSL, fuel pressure and engine pwr were lost. Plt tried variations of fuel tank selections and boost pump with no success. During forced landing attempt at remote airstrip, plt misjudged approach, stalled acft about 100 yds short…Nov 8, 1986 · N4797V · Substantial damageNTSB MKC87LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chillicothe, MOThe PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during…Nov 8, 1986 · N55505 · Substantial damageNTSB MKC87FA017Accident · 1 fatalField investigationFinal reportBeech E18S · Texarkana, ARThe airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…Nov 8, 1986 · N149AA · DestroyedNTSB MIA87LA028Accident · No injuriesLimited investigationFinal reportGlasair Glasair · Ft. Lauderdale, FLThe plt stated that while in the pattern, the engine started to run rough and then quit. He attempted to return to the runway, but the aircraft crashed into trees about one mile from the airport. No reason was found for the loss of power as described by the…Nov 8, 1986 · N3241W · Substantial damageNTSB MIA87LA027Accident · Minor injuriesLimited investigationFinal reportBeech A100 · Brooksville, FLThe pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…Nov 8, 1986 · N78L · DestroyedNTSB MIA87DKT01Accident · Minor injuriesFinal reportPitts S-1T · Miami, FLAircraft collided with trees while recovering from a spin which was performed at low altitude as part of an airshow performance. Pilot stated he misjudged height of trees and recovered from the spin too low.Nov 8, 1986 · N22XP · Substantial damageNTSB CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…Nov 8, 1986 · N6096C · Substantial damageNTSB CHI87DEV01Accident · No injuriesFinal reportPiper PA-34-200T · Bloomington, ILAccording to the plt, the acft bounced upon touchdown. She attempted to reflare the acft, however, it bounced again and a go-around was performed. The acft was then landed without further incident. Following the landing it was determined the acft had received…Nov 8, 1986 · N8156C · Substantial damageNTSB BFO87MA007Accident · 1 fatalMajor investigationFinal reportBeech 65-A80 · Baltimore, MDDrg clb after tkof, l eng seized. Plt said he atmtd 1 eng restart; prop would not rotate or feather. No emerg declared. Plt stated eng shut-dwn proc was used, scientific bus sws were shut off, r gen was recycled & appeared to oper normally. Plts got imt…Nov 8, 1986 · N304D · Destroyed