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 ATL87LA180Accident · No injuriesLimited investigationFinal reportLockheed L-382-30 · Dayton, OHThe flight experienced separation of the nose landing gear during the landing roll. Investigation showed that the failure was related to the progression of a preexisting crack on the nose landing gear strut assembly. The probelms with the nose landing gear…Jun 22, 1987 · N20ST · Substantial damageNTSB SEA87LA120Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Yakima, WAWhile on landing roll in gusty crosswind conditions, the aircraft swerved off the runway and ground looped.Jun 21, 1987 · N27039 · Substantial damageNTSB MKC87LA126Accident · No injuriesLimited investigationFinal reportCessna 150L · Antioch, NEThe rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them…Jun 21, 1987 · N1363Q · Substantial damageNTSB LAX87FA239Accident · 2 fatalField investigationFinal reportRockwell 690 · Bridgeport, CAThe flt conditions for the air ambulance trip consisted of a clear, moonless, dark night and the dest arpt was in a mtn valley with the only ground reference lights the town adjacent to the arpt. Witnesses saw the acft overfly the town and arpt at pattern alt…Jun 21, 1987 · N662DM · DestroyedNTSB FTW87LA150Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Chelsea, OKThe non-rated plt attempted a downwind takeoff from a 1450' pvt grass strip. The strip was soft from recent rain & contained grass & weeds which were 6 to 7 inches hi. After taking off, the acft would not climb fast enough to clear obstacles. Subsequently, it…Jun 21, 1987 · N51267 · Substantial damageNTSB FTW87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Alice, TXThe pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical…Jun 21, 1987 · N5496E · Substantial damageNTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…Jun 21, 1987 · N7121A · Substantial damageNTSB CHI87LA155Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Big Sandy Lake, MNThe engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident.Jun 21, 1987 · N40161 · Substantial damageNTSB CHI87DET07Accident · 1 fatalFinal reportMcentee Stitsplaymate SA-11A · Rolling Prairie, INAircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.…Jun 21, 1987 · N2813 · DestroyedNTSB ATL87LA184Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cottonwood, ALThe plt stated that everything was normal for the acft during the preflt and runup. He had just about completed his first swath run when he reptd that the engine shook a little and started backfiring. He pulled up and started across a swamp toward a paved…Jun 21, 1987 · N7687 · Substantial damageNTSB ATL87LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Goldsboro, NCStudent plt had dep apt for purpose of practicing ldgs. At about 400 ft he noted a pwr loss and rough running eng. He reduced the throttle setting and the roughness contd. Further reductions were made to the point where flight could not be maintained. The…Jun 21, 1987 · N704MW · Substantial damageNTSB NYC87LA182Accident · No injuriesLimited investigationFinal reportMaule M-4 · Wellsville, NYThe flight experienced a violent shimmy upon t/d and the acft veered to the right. The pilot made a go-around and experienced the same condition on the second t/d. on the third t/d, the pilot landed but was only able to maintain control of the acft until it…Jun 20, 1987 · N40354 · Substantial damageNTSB NYC87LA181Accident · No injuriesLimited investigationFinal reportCessna 177RG · Batavia, NYThe flt made an emgy lndg in a corn field after experiencing a loss of eng pwr. During lndg roll the acft collided with a fence. Examination of the propeller revealed that the low pitch stop was broken and had separated from the piston causing the blades to…Jun 20, 1987 · N8021G · Substantial damageNTSB MKC87LA117Accident · No injuriesLimited investigationFinal reportCessna 150L · East Lynne, MOThe PIC had been practicing t&g lndgs for the previous hour or so and decided to stop briefly to wait out rain showers in the area. After waiting the PIC fueled the acft with 10 gal of avn fuel and taxied to the active rwy to return to his originating arpt.…Jun 20, 1987 · N17297 · Substantial damageNTSB MIA87LA190Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe instructor plt stated that the helicopter began to vibrate while the student plt was maneuvering it during an instructional flt. The instructor plt then executed a forced landing and upon touchdown the main rotor blades contacted the ground. Inspection of…Jun 20, 1987 · N6772D · Substantial damageNTSB MIA87FA189Accident · 2 fatalField investigationFinal reportBeech 23 · Miramar, FLAfter the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…Jun 20, 1987 · N2387J · DestroyedNTSB MIA87FA188Accident · 1 fatalField investigationFinal reportCessna 172I · Ellisville, MSBfr the flt, the arpt owner adzd the plt not to fly, since he (the plt) appeared to be intoxicated. The plt 'said ok & left,' but returned aprx 1 hr later. A witness rprtd the plt atmtd to takeoff with full flaps. Drg the takeoff roll, theacft drifted off the…Jun 20, 1987 · N8446L · Substantial damageNTSB LAX87LA241Accident · Serious injuriesLimited investigationFinal reportCessna TU206C · S. Lake Tahoe, CAJust after lift-off during a downwind departure the pilot decided that the acft was not climbing normally and aborted the take-off at mid-field. The pilot reduced power and extended 40 degrees of flaps. The pilot then decided that he would not be able to…Jun 20, 1987 · N1177T · Substantial damageNTSB DEN87LA157Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Ray, NDThe plt reports that he was departing from an aerial app operating area. He said there was a tree line along a road with an opening and the takeoff was made toward the opening. There were wires across the opening and the poles were obscured by the trees on…Jun 20, 1987 · N68012 · Substantial damageNTSB DEN87LA156Accident · No injuriesLimited investigationFinal reportTalbott Avid Flyer · Palisade, COThe plt reported that he had just finished several short flights on the recently certified homebuilt acft to fly off the hr restriction. He had completed the shutdown checklist and had the fuel valve shut off. He restarted the eng without the checklist to…Jun 20, 1987 · N186TF · Substantial damageNTSB CHI87LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILWhile on final approach just past the threshold of runway 32 at about 10 feet AGL, a helicopter crossed in front of the Cessna 152. The student pilot added power and pulled back on the yoke. The instructor pilot then took the controls and attempted to get the…Jun 20, 1987 · N94739 · Substantial damageNTSB CHI87FA151Accident · 2 fatalField investigationFinal reportCessna 182D · Marine City, MIA witness rprtd that drg takeoff, the acft rotated to a steep (nose up) attitude, & immediately after lift-off, the plt made a steep left turn & entered a downwind for lndg on the same rwy. He described the downwind as being a little tighter than normal & a…Jun 20, 1987 · N275T · DestroyedNTSB CHI87FA149Accident · 2 fatalField investigationFinal reportCessna 172A · Tomah, WIThe pilot had flown a closed pattern and was making touch and go landing. A witness saw the acft bounce and then initiate a go around. The surviving pax said the stall warning horn was sounding 'a long time.' At midpoint of downwind leg the acft stalled out.…Jun 20, 1987 · N7189T · DestroyedNTSB BFO87DIG06Accident · 1 fatalFinal reportStriplin SKY Ranger · Easton, MDAfter taking off on a test flt, the plt remained in the traffic pattern & was on downwind when the eng surged or sputtered, then lost power. Soon thereafter, the acft entered a steep dscnt & crashed. The experimental, home built acft had only 11 hrs of flt…Jun 20, 1987 · N4925S · DestroyedNTSB ATL87LA178Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Augusta, GAThe aircraft was on its first flight from the factory. The pilot was checked out in the aircraft on the day prior to theaccident flight. Witnesses reported the aircraft touched down and lifted off several times. The pilot stated the aircraft got away from him…Jun 20, 1987 · N5667F · Substantial damageNTSB SEA87IA119Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101 · Seattle, WAThe crew of the scheduled airline passenger flight experienced an explosion and fire in the right engine at approx 800 ft AGL during initial climb after takeoff. The pilot shut the engine down, activated two fire bottles, which extinguished the fire and…Jun 19, 1987 · N813PH · Minor damageNTSB MKC87LA171Accident · No injuriesLimited investigationFinal reportCessna TU206G · West Plains, MODuring ldg phase of operation, PIC was unable to stop the acft before striking a fence on the overrun. Plt stated a rain shower had just passed through which left the dirt surface slick and muddy. He stated that he was unable to obtain effective braking due…Jun 19, 1987 · N4881U · Substantial damageNTSB MKC87LA125Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Hazen, ARThe PIC was returning to base of operations after completing an aerial application operation. Enroute, PIC experienced an engine failure and made a forced ldg in a farm field. After touchdown, acft nosed over and was substantially damaged. Subsequent…Jun 19, 1987 · N8027K · Substantial damageNTSB LAX87LA237Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Rimrock, AZThe aircraft overran the runway while on a personal VFR cross-country flight. The pilot indicated that he attempted a go-around after a poor approach and that the terrain off the end of the runway rose faster than the aircraft could climb. A witness observed…Jun 19, 1987 · N5438L · Substantial damageNTSB FTW87LA147Accident · No injuriesLimited investigationFinal reportBeech B36TC · Barnhart, TXUpon landing the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted bushes and rough terrain causing the aircraft to nose over.Jun 19, 1987 · N69309 · Substantial damageNTSB CHI87DEX07Accident · Serious injuriesFinal reportBoeing E75 · Mccordsville, INDuring initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the…Jun 19, 1987 · N550LR · DestroyedNTSB CHI87DEM08Accident · No injuriesFinal reportCessna 152 · Plainwell, MIThe aircraft experienced a total power failure and the pilot chose a wheat field on rising terrain for a forced landing. The field turned out to be rough and uneven. When the aircraft touched down, the nose gear failed and the aircraft nosed over. Subsequent…Jun 19, 1987 · N47412 · Substantial damageNTSB ATL87LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Marion, NCThe acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the…Jun 19, 1987 · N52575 · Substantial damageNTSB ATL87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft encountered a strong downdraft in a thunderstorm and impacted the water during a beachside banner towing operation. The plt reported that he had observed thunderstorms developing inland about 1/2 hr prior to the accident and that his acft was…Jun 19, 1987 · N6078Z · Substantial damageNTSB ATL87LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Middlefield, OHThe acft struck a fence during a forced ldg, following a loss of engine pwr in flight. The plt reported that he had topped off both main fuel tanks prior to departure. About 10 minutes after departure at about 4000 ft MSL, he smelled fuel fumes in the…Jun 19, 1987 · N8391E · Substantial damageNTSB ATL87IA179Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Nashville, TNAt aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming…Jun 19, 1987 · N482DA · 2 aircraft · No damageNTSB ATL87FA174Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Asheville, NCDuring a personal night x-country VFR flight over mountainous terrain the plt was informed by ATC that vip level 3 and 4 thunderstorms were positioned across the intended flt path. The 128 hour non-instrument rated private plt acknowledged and continued the…Jun 19, 1987 · N900AJ · DestroyedNTSB ANC87LA083Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander River, AKThe pilot stated that during the takeoff run the left float contacted a hidden sand bar. The aircraft then nosed over on its back.Jun 19, 1987 · N5349G · Substantial damageNTSB ANC87LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Iliamna, AKThe student pilot stated that during a landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Jun 19, 1987 · N95695 · Substantial damageNTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.Jun 18, 1987 · N3913F · Substantial damageNTSB NYC87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tewksbury, MAThe pilot switched the fuel selector from what he thought was the left tank to both while on final approach. He then decided to make a go-around during the flare because he felt his a/s was to fast. The engine quit at 40 ft AGL during the go-around. He was…Jun 18, 1987 · N53060 · DestroyedNTSB MKC87LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Neelyville, MOThe ag pilot was making a low pass to wave his flagman out of the field. The engine response was slow and he was forced to land. To keep from hitting trees, pilot overbraked and flipped airplane forward to inverted position.Jun 18, 1987 · N5214 · Substantial damageNTSB MIA87FA187Accident · 1 fatalField investigationFinal reportMooney M20J · Merritt Island, FLAccording to witnesses, the plt performed a hasty preflt & an abbreviated run-up bfr taking off. After lift-off, the acft bgn a rgt turn, then rolled rapidly to the left & crossed over the extended rwy centerline twd a left downwind. Subsequently, it rolled…Jun 18, 1987 · N5630K · DestroyedNTSB MIA87FA186Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Panama City, FLThe purpose of the flt was to check out a new plt in banner towing operations. The first flt had been completed, the banner dropped & the second banner was engaged. Witnesses saw the acft make the steep climb after pick-up normally associated with banner…Jun 18, 1987 · N7620S · DestroyedNTSB LAX87LA238Accident · No injuriesLimited investigationFinal reportCessna 172N · Malibu, CADuring a local instructional flight, the pilot stated that they were flying along the coast aprx 1 mile offshore and 500 ft AGL. The student started a climbing right turn towards land. The student continued to apply back pressure to the point that the acft…Jun 18, 1987 · N738JV · Substantial damageNTSB CHI87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Muncie, INAfter landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller…Jun 18, 1987 · N9174M · Substantial damageNTSB CHI87IA163Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Detroit, MIA northwest airlines Boeing 757, operating as flight 336, scraped the tail cone area of the fuselage on the runway when the pilot failed to maintain sufficient ground clearance during rotation and takeoff from Detroit, Michigan. The Boeing 757 flight…Jun 18, 1987 · N515US · Minor damageNTSB ATL87LA171Accident · No injuriesLimited investigationFinal reportLuscombe 8A · London, OHThe pilot was making a planned refueling stop at madison county airport. He stated he made a normal pattern entry, approach and landing. During the roll out the aircraft groundlooped to the right and departed the runway. Investigation revealed no preimpact…Jun 18, 1987 · N1029K · Substantial damageNTSB ATL87FA173Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B · Coral Springs, FLThe pilot reported to ground personnel at fort lauderdale that he was experiencing an avionics problem and the passengerentry door was sprung the day before when it was slammed; however, the pilot elected to depart. The aircraft wreckage was located on June…Jun 18, 1987 · N184MA · DestroyedNTSB ANC87LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Theodore River, AKThe plt stated that during the takeoff roll the acft's left main gear struck a culvert in the road. The acft became airborne prior to reaching rotation speed. The plt reduced power to abort the takeoff. The nose wheel struck a stump on the road and the acft…Jun 18, 1987 · N71724 · Substantial damage