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 ATL87LA068Accident · 1 fatalLimited investigationFinal reportCessna 150M · Pinson, ALDuring intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…Jan 31, 1987 · N704FT · Substantial damageNTSB ATL87IA067Incident · No injuriesIncident investigationFinal reportBurkhart Grob G103 Twin Astir · Williamson, GAAs the glider plt was apchg the entry point for landing, he checked the spoilers for operation. The spoilers extended, but would not retract. There was a significant increase in the sink rate & the plt realized he would be unable to reach the arpt.…Jan 31, 1987 · N429BG · Minor damageNTSB ANC87FA033Accident · No injuriesField investigationFinal reportChampion 7EC · Kenai, AKThe pilot allowed the wing tip to descend into brush and willows while turning to avoid obscured sky conditions. The turn was downwind and the airplane stalled and struck the snow while skidding sideways.Jan 31, 1987 · N7539B · Substantial damageNTSB ANC87FA030Accident · No injuriesField investigationFinal reportCessna C-180-H · Delta Junction, AKThe pilot attempted a glacier landing in daylight conditions and was unable to maintain surface reference. He flew onto the ice and lost control in varying surface winds.Jan 31, 1987 · N7990V · Substantial damageNTSB CHI87FA069Accident · 1 fatalField investigationFinal reportCessna 210N · Bedford Park, ILJust bfr tkof fm rwy 22L on a ngt IFR flt, the plt was clrd to clb & maint 2000' & to contact chicago dep ctl (TRACON). About 1 min later, he called TRACON & rprtd he was clbg thru 900' for 2000'. This call was in a normal tone of voice & was the last…Jan 30, 1987 · N4968C · DestroyedNTSB SEA87LA050Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Alderwood Manor, WAThe pilot, after exhausting all fuel in one tank, failed to select the remaining fuel tank during his approach. His unfamiliarity with the make/model of the accident aircraft is considered a factor in his failing to locate the fuel selector and switching to…Jan 29, 1987 · N6076N · DestroyedNTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…Jan 29, 1987 · N50922 · DestroyedNTSB NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.Jan 29, 1987 · N49769 · Substantial damageNTSB FTW87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Terrel, TXThe pilot attempted a go-around due to cross winds and experienced an engine failure due to fuel starvation when the mixture control vibrated out to the shutoff position. The pilot attempted several times to restart the engine, but was unsuccessful prior to…Jan 29, 1987 · N4862Z · Substantial damageNTSB BFO87LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · West Point, VAThe plt stated that the left main gear collided with a snowbank when the acft touched down on the rwy about 100 ft from the apch end and 10 ft left of the rwy centerline. Afterwards the left main gear folded into the wheel well.Jan 29, 1987 · N244MB · Substantial damageNTSB SEA87LA049Accident · No injuriesLimited investigationFinal reportCessna 402B · Las Vegas, NVPlt filed IFR, 2+40 ete. Due delay, plt departed VFR and opened VFR flt plan. Enroute, stong hdwinds encountered. Also, clouds required altitude and course deviations to maintain VFR. Ate was 3+33. On final, left eng lost pwr, rt eng began surging. Into 20-KT…Jan 28, 1987 · N69310 · Substantial damageNTSB NYC87LA069Accident · No injuriesLimited investigationFinal reportHughes 269D · Antrim, NHDuring a practice hover, the pilot lost directional control and the helicopter pitched up at an angle of about 20-25 degrees causing the tail rotor to contact the snow. The aircraft was substantially damaged, but there were no injuries. The CFI stated that…Jan 28, 1987 · N3624J · Substantial damageNTSB MIA87IA078Incident · No injuriesIncident investigationFinal reportBritish BAC 1-11 201 · Orlando, FLAfter landing the auxiliary power unit was started and the number one engine was shutdown. The aircraft then began to pressurize and fill with smoke. An emergency evacuation was ordered by the captain through L-1 and R-1 doors. The slide at R-1 did not work…Jan 28, 1987 · N101EX · Minor damageNTSB LAX87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZDuring a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the…Jan 28, 1987 · N95529 · Substantial damageNTSB FTW87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Medford, OKThe acft experienced a double eng failure as a result of fuel exhaustion during descent to the destination aprt. The plt attempted to divert to a nearby arpt during the descent, but both engs quit before he had the rwy assured. The subsequent attempted forced…Jan 28, 1987 · N76ND · Substantial damageNTSB DEN87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182L · La Junta, COThe engine quit during cruise flt at 8,500 feet MSL. During the emergency landing to unsuitable terrain, the acft nosed over. The plt had flown 5 hours on this flt. The long range fuel tanks had been installed with the filler ports inboard, limiting the total…Jan 28, 1987 · N3439R · Substantial damageNTSB DEN87FA061Accident · 4 fatalField investigationFinal reportCessna T210L · Nucla, COThe acft was on an IFR flt to an arpt without an instrument approach procedure. ATC cleared the flt to descend to 12,000 ft, the IFR mea for the area, at 30 NM NE of the arpt. At approx 3 min prior to the mishap, the plt was issued a cruise clearance at…Jan 28, 1987 · N1721X · DestroyedNTSB ANC87FA028Accident · Serious injuriesField investigationFinal reportCessna 207 · Anchorage, AKThe aircraft crashed one mile short of the runway. The accident occurred during an ILS approach in instrument meteorological conditions. During a post accident interview with the pilot he stated that he did not recognize and react in a timely manner to the…Jan 28, 1987 · N7393U · DestroyedNTSB LAX87FA101Accident · 2 fatalField investigationFinal reportMooney M20E · Dunsmuir, CADuring a pleasure flight, the airplane was seen flying low and disappeared into instrument meteorological conditions, consisting of low clouds, gusty winds and snow which lasted throughout the day. The airplane was found on the side of a hill in a descending…Jan 27, 1987 · N79366 · DestroyedNTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…Jan 27, 1987 · N4688D · Substantial damageNTSB ANC87LA027Accident · No injuriesLimited investigationFinal reportCessna 185D · North Pole, AKThe pilot stated that during the right downwind approach to the airstrip the aircraft ran out of fuel; the engine quit and then he attempted an emergency landing. The plt attempted to land on the rwy. Inspection revealed no fuel in the acft and the fuel…Jan 27, 1987 · N75LE · Substantial damageNTSB LAX87LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Tracy, CAJust after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…Jan 26, 1987 · N1408R · Substantial damageNTSB LAX87LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendora, CADuring a local pleasure flight, the engine lost power and the pilot made a forced landing on a golf course. Visual inspection of the fuel tanks revealed that both tanks were empty and no fuel drained from the sumps. No mechanical failure or malfunction with…Jan 26, 1987 · N65560 · Substantial damageNTSB ATL87LA066Accident · Minor injuriesLimited investigationFinal reportCessna 337D · Savannah, GAThe pilot was flying a donated aircraft in support of a program to document the activities of wright whales off the coast of the carolina's and Georgia. The plt had been with the owner on a previous flt, when problems developed while switching to/and/or from…Jan 26, 1987 · N10MM · DestroyedNTSB SEA87LA048Accident · 2 fatalLimited investigationFinal reportMichael D. Mansfield KR-2 · Fallon, NVThe owner and an acquaintance, both commerically rated pilots, departed Fallon, Nevada, on a personal flight to a nearby town. Witnesses reported observing the aircraft engaged in maneuvers described as steep turns and sharp dives a short distance from the…Jan 25, 1987 · N66996 · DestroyedNTSB NYC87LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Princeton, NJThe student pilot leveled off at a higher than normal altitude during landing. He attempted to slow the descent rate by adding power. The aircraft drifted to the left and the pilot contemplated aborting the landing. Before he could initiate adding power,…Jan 25, 1987 · N4837P · Substantial damageNTSB CHI87LA071Accident · No injuriesLimited investigationFinal reportCessna 152II · West Middleton, INDuring the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.Jan 25, 1987 · N6179Q · Substantial damageNTSB CHI87LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILDuring second touch & go landing, plt encountered a crosswind. While attempting a go-around, after bouncing three times,the acft drifted to the left. The acft collided with a snowbank and nosed over.Jan 25, 1987 · N4805B · Substantial damageNTSB CHI87IA067Incident · No injuriesIncident investigationFinal reportBoeing 727-122 · Fort Wayne, INAircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft…Jan 25, 1987 · N7015U · Minor damageNTSB ATL87LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Delaware, OHThe student plt reported that he lost control of the acft while landing on rwy 28 in croswind conditions, after a solo x-c flt. The acft landed hard, veered off the rwy, and nosed over. According to the plt, the wind was from 360 at 10 KTS, gusting to 20 KTS.…Jan 25, 1987 · N7992U · Substantial damageNTSB SEA87LA052Accident · No injuriesLimited investigationFinal reportCessna 182R II · Spokane, WAPlt attempted instrument approach in conditions conducive to structural icing; I.e., fog, light snow, temp 32F. Acft not equipped for deice. Structural ice accretion during approach and climb-out following missed approach degraded acft performance so that…Jan 24, 1987 · N9322X · Substantial damageNTSB NYC87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyertown, PAStudent pilot on a solo cross-country flight experienced fuel exhaustion, landed in a field and collided with a stonewall. The aircraft was substantially damaged and the pilot received minor injuries.Jan 24, 1987 · N10VF · Substantial damageNTSB NYC87LA065Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Babylon, NYThe Beech baron had been cruising at altitude for approximately 2 hours when it started a descent with the OAT well below freezing. During the descent the pilot attempted to add power and there was no response. The pilot turned on the boost pumps to high and…Jan 24, 1987 · N9555Y · DestroyedNTSB MKC87LA046Accident · No injuriesLimited investigationFinal reportCessna 150M · Kansas City, MOThe student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one…Jan 24, 1987 · N671HA · Substantial damageNTSB FTW87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alpine, TXStudent pilot on solo flight attempted takeoff in strong gusty winds and dragged left wing tip on runway. Pilot leveled wings and attempted to land aircraft but departed left side of runway and collided with ditch.Jan 24, 1987 · N2592C · Substantial damageNTSB FTW87FA047Accident · Serious injuriesField investigationFinal reportCessna 150F · Rio Vista, TXPrivate pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…Jan 24, 1987 · N8033F · DestroyedNTSB DEN87LA045Accident · No injuriesLimited investigationFinal reportCessna 172B · Roswell, NMStudent plt obtained wx briefing from fort worth fss and filed VFR flt plan for x-country flt from plainview, tex, to Roswell, NM, via hobbs, NM,. Plt landed at Roswell, refueled, and filed return VFR flt plan. He did not obtain updated wx briefing. Cold…Jan 24, 1987 · N8224X · Substantial damageNTSB CHI87DEC01Accident · Serious injuriesFinal reportCessna 150 · Troy, MIOutside air temperature was approximately 5 degress f when the aircraft on initial climb experienced a total power loss. The pilot lowered the nose and attempted to make a turn to return to the runway. The aircraft did complete approximately 180 to 190…Jan 24, 1987 · N5634E · DestroyedNTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…Jan 24, 1987 · N5814M · DestroyedNTSB ANC87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKAfter takeoff and during the initial climbout, the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft struck a row of trees at the departure end of the runway. The plts flt time was not reported or available.Jan 24, 1987 · N46362 · Substantial damageNTSB NYC87LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Simsbury, CTThe aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface.Jan 23, 1987 · N48918 · Substantial damageNTSB MKC87IA043Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · Springfield, MOThe PIC of this air midwest flt 4408 said that, while on initial climb, power (np) on the left engine decayed to 60% and would not recover. The engine was feathered by condition lever but the torque rose to 140% while returning for a landing, according to the…Jan 23, 1987 · N120AM · Minor damageNTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…Jan 23, 1987 · N48241 · Substantial damageNTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…Jan 23, 1987 · N2536A · Substantial damageNTSB ANC87FA025Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKThe pilot stated that on the third touch and go he raised the flaps and applied power for takeoff when the aircraft started to skid to the left. He cut power, then lost directional control of the airplane causing the aircraft to strike the snow bank.Jan 23, 1987 · N25063 · Substantial damageNTSB MKC87LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Coffeyville, KSThe student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip…Jan 22, 1987 · N4924H · Substantial damageNTSB CHI87DEX05Accident · No injuriesFinal reportCessna 340A · Bloomington, INThe plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but…Jan 22, 1987 · N3961G · Substantial damageNTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…Jan 22, 1987 · N2489R · Substantial damageNTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…Jan 21, 1987 · N5171B · Substantial damageNTSB FTW87LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Worth, TXThe nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.…Jan 21, 1987 · N4901G · Substantial damage