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 LAX87FA134Accident · 1 fatalField investigationFinal reportMooney M20J · Weed, CABefore takeoff, the plt was adzd that strong head winds, mod to svr turbc, mtn obscurement, multiple layers of icing & deteriorating wx were forecast along his route of flt. He filed an IFR clnc & took off at 1115 PST. While en route, he reqd the medford wx &…Mar 4, 1987 · N201LF · DestroyedNTSB DCA87MA022Accident · 9 fatalMajor investigationFinal reportCASA C-212-CC · Romulus, MIThe capt made a steep, short, fast visual approach to the runway behind a departing DC-9. The evidence indicates the capt placed the power levers into beta mode to slow the aircraft rapidly and make a short field landing. An asymmetric thrust condition…Mar 4, 1987 · N160FB · DestroyedNTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…Mar 3, 1987 · N6540Z · Substantial damageNTSB MIA87LA097Accident · No injuriesLimited investigationFinal reportBeech B-65 · Key Largo, FLThe aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown.Mar 3, 1987 · N822Q · DestroyedNTSB ANC87LA049Accident · No injuriesLimited investigationFinal reportChampion &GCBC · Talkeetna, AKThe pilot stated that during the initial climb out he lost directional control of the aircraft causing the plane to stall and strike a small tree next to the runway. At the time of the accident the wind was 330 degrees at 3 knots.Mar 3, 1987 · N2586G · Substantial damageNTSB MKC87LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Malden, MOThe acft was being used on training flt when the eng failed. During the forced landing in a muddy field, the acft flipped forward to an inverted position. Post accident inspection revealed the eng failed due to a connecting rod bolt failure on the number two…Mar 2, 1987 · N20362 · Substantial damageNTSB LAX87LA130Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Prescott, AZDuring a local solo instructional flight, the pilot reported that on landing, the aircraft touched-down on the nosewheel first and bounced. The aircraft swerved to the right and the pilot added power to initiate a go-around, however, the aircraft did not…Mar 2, 1987 · N1474R · Substantial damageNTSB FTW87LA071Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Porter, TXAccording to the pilot, he was flying low over the san jacinto river, approximately 50 ft AGL. During a descending right turn the aircraft contacted a power line. The aircraft crashed into the river causing substantial damage to both wing spars and the…Mar 2, 1987 · N714KG · Substantial damageNTSB FTW87DRA01Accident · Minor injuriesFinal reportStrissel Pitts S1S · Friendswood, TXThe prop separated during flt and the plt was forced to land the acft on rough terrain. Investigation revealed that the prop had separated as a result of a previously existing crack in the eng crankshaft. The eng had been rebuilt from components salvaged from…Mar 2, 1987 · N815DB · Substantial damageNTSB BFO87LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Charlottesville, VAAfter climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft…Mar 2, 1987 · N734ZD · Substantial damageNTSB ATL87LA078Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Augusta, GAThe acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from…Mar 2, 1987 · N2355Z · Substantial damageNTSB SEA87LA061Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Haines, AKWhile at cruise a total loss of engine oil pressure occurred with the engine seizing shortly afterwards. The aircraft was force landed into trees in a remote area. The aircraft came to rest inverted. Due to the position of the aircraft, examination of the…Mar 1, 1987 · N200LK · DestroyedNTSB MKC87LA053Accident · No injuriesLimited investigationFinal reportBeech C23 · Grain Valley, MOThe plt reported that the preflight eng run-up was satisfactory. Shortly after takeoff, the eng faultered briefly and the plt attempted a landing back on the rwy. Upon establishing a point to land, the eng responded and the acft overshot the intended landing…Mar 1, 1987 · N6001M · Substantial damageNTSB LAX87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Redlands, CADuring a pleasure cross-country flt, the plt reported that he was descending from 8500 ft MSL to 4000 ft MSL with power reduced to 2000 RPM. The plt stated that he did not use the carburetor heat while descending. When pwr was added, the eng did not respond.…Mar 1, 1987 · N5466W · Substantial damageNTSB ATL87LA077Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Dothan, ALThe plt reported that the acft nosed over when he applied the brakes during ldg roll-out. He estimated his groundspeed to be about 15-20 mph at the time.Mar 1, 1987 · N9257E · Substantial damageNTSB ANC87LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter…Mar 1, 1987 · N2449J · Substantial damageNTSB MIA87LA096Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · St.Augustine, FLThe private pilot stated that while attempting a landing the conventional gear aircraft bounced. He initiated a go around and when he added power the aircraft swerved left, ground looped and flipped over. The pilot stated that when he added power he relaxed…Feb 28, 1987 · N3707F · Substantial damageNTSB LAX87LA154Accident · No injuriesLimited investigationFinal reportCessna 190 · Chino, CAPrior to takeoff the pilot observed an asymmetrical deflection of the rudder/brake pedals. Upon landing he executed a right turn to depart the runway. The pilot stated that he was unable to stop the right turn and the aircraft ground looped damaging the left…Feb 28, 1987 · N4498C · Substantial damageNTSB LAX87LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Oatman, AZAt the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew…Feb 28, 1987 · N4786B · Substantial damageNTSB LAX87FA128Accident · No injuriesField investigationFinal reportBritish Aerospace BA146-200A · Fresno, CAFailure of company maintenance personnel to adequately examine the engine lubrication system when contamination was detected.Feb 28, 1987 · N356PS · Substantial damageNTSB ANC87LA041Accident · No injuriesLimited investigationFinal reportCessna 180B · Palmer, AKThe pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on…Feb 28, 1987 · N9141T · Substantial damageNTSB NYC87LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Cross Keys, NJThe plt rprtd that drg the lndg roll, he glanced down at the airspeed indcr, & at the same time, must have relaxed control of the acft. At about that time, the acft drifted to the left side of the rwy, the left main gear struck a snowbank & the acft nosed…Feb 27, 1987 · N9821J · Substantial damageNTSB LAX87LA129Accident · No injuriesLimited investigationFinal reportCessna 182Q · Springerville, AZA Cessna 182 collided with a snow bank after veering off runway 3. The pilot indicated that after touchdown the aircraft began to drift right and he was unable to correct it by applying left pedal. The aircraft suddenly veered left and the pilot applied right…Feb 27, 1987 · N735PQ · Substantial damageNTSB LAX87LA127Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Roosevelt, AZAt the end of a pleasure cross-country flight, the pilot reported that during the landing roll, the passenger was moving around in the back seat and accidentally pressed on the right brake. Before the pilot could get the aircraft under control, the aircraft…Feb 27, 1987 · N7572F · Substantial damageNTSB LAX87FA126Accident · Serious injuriesField investigationFinal reportBoeing 747-236B · Los Angeles, CAA Boeing 747-236B crew evacuated all occupants via escape slides after returning to Los Angeles after receiving a specific bomb threat. One passenger sustained serious injury during the evacuation. According to a witness, the 370 passengers evacuated the acft…Feb 27, 1987 · GBDXK · No damageNTSB NYC87FA098Accident · No injuriesField investigationFinal reportCessna 402 · Montgomery, NYBoth acft were operating under visual flight rules in the vicinity of active airports. The Cessna 402 was in a cruise descent. The decathlon was in level flight. Neither pilot in the 402 recalls seeing the decathlon, which was struck on the rt wing. The…Feb 26, 1987 · N36139 · 2 aircraft · Minor damageNTSB MIA87LA095Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Clearwater, FLThe private pilot attempted to reduce throttle and land but the throttle control did not reduce the power. He then landed and attempted to use the brakes to stop the aircraft but it slid off the end of the runway into a ditch. Post accident examination of the…Feb 26, 1987 · N93977 · Substantial damageNTSB MIA87LA094Accident · No injuriesLimited investigationFinal reportCessna A185E · Melbourne, FLThe student plt inadvertently lowered the landing gear on the downwind leg in preparation for a water landing. The flt then turned base to final, &, upon touchdown, the acft nosed over & came to rest inverted in the lake. Investigation revealed that the…Feb 26, 1987 · N2287T · Substantial damageNTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportBoeing 727-224 · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…Feb 26, 1987 · N88704 · 2 aircraft · No damageNTSB DEN87LA060Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Englewood, COThe rwy was plowed aprx 15 minutes prior to this takeoff. One-half inch of snow still remained along the rwy centerline with up to 3 1/2 inches along the edge of the rwy. The acft veered to the left side of the rwy during the takeoff run and continued aprx 80…Feb 26, 1987 · N888DJ · Substantial damageNTSB DEN87IA059Incident · No injuriesIncident investigationFinal reportBoeing 737-2A6 · Durango, COAmerica west airlines flt 166, a Boeing 737, departed phoenix, AZ, en route to Durango, CO. During the ILS apch to Durango's rwy 02 in IMC, the captain used a 10-15 degree crab angle to maintain the localizer course. Upon touchdown aprx 1000-1300 ft from rwy…Feb 26, 1987 · N145AW · No damageNTSB CHI87LA088Accident · No injuriesLimited investigationFinal reportBeech C-35 · Lake Station, INThe aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…Feb 26, 1987 · N99QE · Substantial damageNTSB CHI87FA087Accident · No injuriesField investigationFinal reportRockwell NA265-65 · East Alton, ILAfter landing pilot lost directional control of the aircraft during rollout. Aircraft struck taxiway edge and taxiway marker sign causing substantial damage to aircraft. Post accident testing of the anti-skid system did not reveal any functional defects.Feb 26, 1987 · N465LC · Substantial damageNTSB MIA87LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLThe student plt failed to flare the aircraft, landed hard, bounced 2-3 times, then landed on the nose gear causing it to collapse.Feb 25, 1987 · N89126 · Substantial damageNTSB LAX87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-44-180T · Missing Acft (Pacific Ocean)The instructor plt (CFI) & the single-eng, pvt plt (owner) were on a flt to conduct multi-eng training for the new owner. Drg the flt, the crew contacted los angeles TRACON & requested a VOR apch to the santa monica arpt & said they would not be able to maint…Feb 25, 1987 · N8307H · DestroyedNTSB MIA87LA092Accident · No injuriesLimited investigationFinal reportPiper J5A · Brooksville, FLShortly after take off the eng began to lose power. Unable to maintain alt a forced landing was made in a field, during which, the acft sustained substantial damage. Inspection of the acft revealed that the loss of power was the result of an insufficient fuel…Feb 24, 1987 · N41141 · Substantial damageNTSB LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…Feb 24, 1987 · N8808E · Substantial damageNTSB LAX87FA142Accident · 2 fatalField investigationFinal reportCessna P206B · Green Valley, CAA Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…Feb 23, 1987 · N58RS · DestroyedNTSB LAX87FA121Accident · 4 fatalField investigationFinal reportBeech F33A · Anza, CAThe non-instrument rated plt & 3 pax planned a pleasure flt to mx. The weather was below VFR minimums however the plt elected to attempt the flt. Several minutes after departure the acft was observed to enter an area where it was snowing, the cloud base was…Feb 23, 1987 · N59AB · DestroyedNTSB FTW87LA069Accident · No injuriesLimited investigationFinal reportBell 47G · Sand Springs, OKInstructor plt was demonstrating a confined area takeoff to the pvt plt taking advance instruction. As the acft cleared the barriers, the quartering head wind shifted to a tail wind and the acft lost translational lift. Application of full power did not…Feb 23, 1987 · N6330D · Substantial damageNTSB ATL87LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hampton, GAThe plt reported that a gusting x-wind existed during the approach to land. When he reduced pwr for touchdown, the acft pitched nose down, began a rapid sink and landed hard. The plt noted that he had the yoke full back but was unable to arrest the sink rate.…Feb 23, 1987 · N7681W · Substantial damageNTSB ANC87LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot successfully landed his ski equipped tailwheel airplane on a frozen lake in gusty wind conditions but lost control of the airplane while attempting to taxi from upwind to downwind. The airplane struck its left wing and elevator on the lake ice and…Feb 23, 1987 · N4687C · Substantial damageNTSB NYC87LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Colebrook, NHThe plt rprtd that after arriving, the wind shifted to the NE, but he elected to land on rwy 21 'because of a frost heave.' Subsequently, he landed long to avoid the frost heave, but was unable to stop on the icy rwy. The acft contd off the departure end &…Feb 22, 1987 · N3967R · Substantial damageNTSB NYC87LA093Accident · No injuriesLimited investigationFinal reportMooney M20J · Plainville, CTDuring landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the…Feb 22, 1987 · N222NS · Substantial damageNTSB NYC87LA092Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Tunkhannock, PAThe plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I…Feb 22, 1987 · N3045Z · Substantial damageNTSB NYC87FA095Accident · 2 fatalField investigationFinal reportCessna 152C · Port Matilda, PAThe university student departed the university air park airport in state college, PA on a local flight in VFR weather conditions. The aircraft nosed into the ground in an approximate 70 degree dive about 10 minutes after takeoff. The pilot was engaged in low…Feb 22, 1987 · N757BQ · DestroyedNTSB MKC87FA051Accident · 1 fatalField investigationFinal reportPiper PA-18 · Venango, NEA witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…Feb 22, 1987 · N9498D · DestroyedNTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportBoeing PT-13D · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…Feb 22, 1987 · N620BD · 2 aircraft · Substantial damageNTSB LAX87LA120Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Tucson, AZDuring a pleasure flight, the pilot reported that upon take-off, the wind was calm. While in-flight the wind increased and the pilot prepared for a high wind landing. The balloon touched-down hard and hit a bush. The pilot and one passenger were ejected from…Feb 22, 1987 · N4261R · No damageNTSB FTW87LA068Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Braunfels, TXAcft had been parked in an open field and when the plt returned he noticed that the left skid had sunk into the mud. After eng start and run up, the plt attempted to takeoff with right cyclic applied to un-stick the left skid. The acft lifted off with a right…Feb 22, 1987 · N1082Z · Substantial damage