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 ANC87LA145Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kahlitna Glac, AKThe pilot stated after touchdown on the lake, he lost directional control of the aircraft causing the plane to nose over on its back and the aircraft sank in 20 to 25 feet of water.Sep 2, 1987 · N42128 · Substantial damageNTSB ANC87LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kwethluk, AKThe pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust…Sep 2, 1987 · N7233K · Substantial damageNTSB NYC87DNE05Accident · Minor injuriesFinal reportHall B-80M · Waterford, CTThe gyrocopter was observed to touch down and become airborne again. After becoming airborne it was observed to pitch down, with the main rotor blades striking the ground in front of the aircraft. The pilot said his right contact lens wasbothering him and he…Sep 1, 1987 · N180RH · Substantial damageNTSB LAX87DUJ11Accident · Minor injuriesFinal reportHiller UH-12E · Scottsdale, AZDuring an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle…Sep 1, 1987 · N236HA · DestroyedNTSB ATL87FA257Accident · 2 fatalField investigationFinal reportBeech V-35B · Hilton Head, SCPIC said he had wx brief. Noted tstms ovr atlantic & fog at arpt. Stated he would hold ovr ocean until arpt clr. Acft track on radar was into area of tstms ovr ocean followed by mode c altitude deviations and loss of radar contact. Acft recovered from ocean.…Sep 1, 1987 · N6591S · DestroyedNTSB ANC87LA132Accident · No injuriesLimited investigationFinal reportCessna 175 · Yellow Jacket, AKThe pilot stated he bounced hard on the gravel runway causing him to lose directional control and the airplane nosed over on its back.Sep 1, 1987 · N7571M · Substantial damageNTSB NYC87LA242Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Marlboro, NJDuring the plt's 1st apch to land, he noted a wind shift & made a go-around. He said the wind shifted back in favor of rwy 27, so he attempted another landing with a longer, lower apch to accommodate the winds. Also, he noted there were trees near the apch…Aug 31, 1987 · N77DL · DestroyedNTSB NYC87LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bridgeton, NJThe pilot made a landing with a tailwind of 8-10 knots. During landing roll the aircraft pulled to the left and power was added for a go around. The pilot reported, however, that the aircraft would not become airborne so he then decreased the power and the…Aug 31, 1987 · N47993 · Substantial damageNTSB MIA87FA236Accident · 1 fatalField investigationFinal reportCessna 152 · Opa Locka, FLA student plt & instructor (CFI) in Cessna 152, N48864, took off & entered rgt traffic to practice lndgs on rwy 9R. Soonthereafter, a helicopter plt (h/p) in a bell 47G-2, N6728D, took off & entered rgt traffic to practice lndgs in a desig-nated helicopter…Aug 31, 1987 · N48864 · 2 aircraft · Substantial damageNTSB LAX87LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sonora, CADuring a pleasure flt the engine suddenly lost partial power. The plt made a forced landing in a parking lot where the aircraft touched down and collided with a fence that borders the lot. The engine was inspected and test run for approx 20 minutes at…Aug 31, 1987 · N737SL · Substantial damageNTSB LAX87LA315Accident · No injuriesLimited investigationFinal reportCessna 172D · Fortuna, CAThe pilot was attempting a precautionary landing because of deteriorating weather due to fog. He undershot the runway on his landing touchdown. He said he was blinded by the approach lights but elected to continue with the landing rather than attempting a…Aug 31, 1987 · N246WB · Substantial damageNTSB LAX87DUG08Accident · Serious injuriesFinal reportBoyles Starduster II · Hemet, CAThe plt rprtd that shortly after takeoff, the eng began to 'cut out.' He moved the fuel selector to the reserve tank & activated the standby fuel pump, but was unable to restart the eng. Subsequently, the acft was damaged as the plt was making an emergency…Aug 31, 1987 · N1189B · Substantial damageNTSB CHI87DEX08Accident · Minor injuriesFinal reportChampion 7KCAB · Sheridan, INOn initial climbout at approximately 400' AGL the aircraft experienced a total power failure. The pilot attempted to maneuver the aircraft to return to the airport, however, the aircraft was forced to land in a farm field 1/4 mile short of the airport. The…Aug 31, 1987 · N6343N · Substantial damageNTSB ANC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kuskalana Pass, AKThe pilot stated that during the landing roll on the tundra he applied wheel brakes too hard causing the aircraft to nose over on its back.Aug 31, 1987 · N4302M · Substantial damageNTSB ANC87LA130Accident · No injuriesLimited investigationFinal reportCessna 180F · Cordova, AKThe wind was blowing from the south at approximately 15 knots gusting 30 knots. As he was turning off the runway, the pilot lost directional control of the aircraft causing the aircraft to ground loop on the taxiway.Aug 31, 1987 · N25722 · Substantial damageNTSB SEA87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Shelton, WADuring initial climbout the pilot stated that a loss of power occurred. However, no reason for loss of power could be found. An eye witness to the accident stated that he heard power throughout the takeoff to the moment of impact. The propeller showed heavy…Aug 30, 1987 · N4789U · DestroyedNTSB LAX87LA328Accident · No injuriesLimited investigationFinal reportCessna 310D · Lancaster, CAThe pilot-in-command (PIC) rprtd that he heard a loud bang during gear retraction after takeoff. By using the convex mirrors mounted on the tip tanks, he determined that the nose gear was hanging. He cycled the landing gear switch several times, but the nose…Aug 30, 1987 · N39DD · Substantial damageNTSB LAX87FAMS4Accident · 1 fatalMissing aircraftFinal reportCessna 172P · Missing Acft, CAThe pilot told family and friends that he was going to fly along the coast and return at night. He did not return. The civil air patrol searched for the aircraft and pilot for several days without success. The flight originated at van nuys airport, van nuys,…Aug 30, 1987 · N65797 · DestroyedNTSB CHI87LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Phillips, WIDuring the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that…Aug 30, 1987 · N67795 · Substantial damageNTSB CHI87FA198Accident · 2 fatalField investigationFinal reportBeech B35 · Martinsville, INShortly after takeoff an engine failure occurred. The aircraft stalled and spun to the ground when the pilot tried to return to the airport. The fuel selector was positioned on the almost empty auxiliary tank (meant for use in level flight only).Aug 30, 1987 · N700T · Substantial damageNTSB CHI87FA197Accident · 2 fatalField investigationFinal reportAeronca 7AC · Kenosha, WIThe aircraft was on final approach for landing during a dual instructional flight. The aircraft was observed to pitch up, then enter a nose down, right wing low attitude which it maintained until it impacted the ground. Witnesses, including another CFI who…Aug 30, 1987 · N3406E · DestroyedNTSB ATL87LA246Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Greenville, KYThe flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted…Aug 30, 1987 · N92191 · Substantial damageNTSB ATL87LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCAfter about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage…Aug 30, 1987 · N6094Z · Substantial damageNTSB ANC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Lake, AKThe pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second…Aug 30, 1987 · N9775D · Substantial damageNTSB LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…Aug 29, 1987 · N8275G · Substantial damageNTSB DEN87LA229Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Manila, UTThe student plt was landing at an uncontrolled airport with an asphalt runway 5300 x 60 ft oriented 250 degrees. She said she made 3 passes over the airport to check for conditions and then executed a normal landing. Shortly after touchdown the aircraft…Aug 29, 1987 · N43424 · Substantial damageNTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…Aug 29, 1987 · N2413C · Substantial damageNTSB CHI87LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILAccording to the plt, the lndg was normal until after touchdown when the acft bgn to 'track' toward the rgt side of the rwy. The plt said he applied left rudder, but the acft contd off the rgt side, went into a drainage ditch with standing water & nosed over.Aug 29, 1987 · N54452 · Substantial damageNTSB ATL87LA247Accident · No injuriesLimited investigationFinal reportMooney M20F · Put In Bay, OHThe plt heard a loud 'snap' while taxiing to the rwy, and the ldg gear collapsed immediately thereafter. The plt observed that the gear handle was still in the down-and-locked position and that the green 'gear down' light remained illuminated. FAA exam of the…Aug 29, 1987 · N9784M · Substantial damageNTSB ATL87FA244Accident · 1 fatalField investigationFinal reportCessna 150L · Murray, KYPIC stated to friends he intended to execute a hammerhead stall after take off from a private grass strip. Airstrip owner observed acft make a low pass, pitch up vertically, and execute a hammerhead stall at about 450-500 feet AGL. There was insufficient…Aug 29, 1987 · N6795G · Substantial damageNTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…Aug 28, 1987 · N6901K · DestroyedNTSB NYC87FA241Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Selinsgrove, PAThe pilot was conducting a demonstration flight in an overweight aircraft in conditions of low ceilings and fog. After a touch and go landing the aircraft stalled during the takeoff then collided with the ground. Exam of the wreckage did not disclose any…Aug 28, 1987 · N4003P · DestroyedNTSB NYC87FA240Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Kings Point, NYN3025W departed on a ferry flight with an unsecured, temporarily installed fuselage fuel tank. A computed c.g. at takeoff showed the aircraft about .9 inches aft of the aft limit. The aircraft had climbed to 7000 feet when the controller saw the aircraft…Aug 28, 1987 · N3025W · DestroyedNTSB LAX87LA319Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Glendale, AZDuring landing roll, in crosswind conditions, the aircraft left the runway and went into a ditch. During a telephone interview the pilot stated that he lost control of the aircraft. The pilot was landing on runway 01 and winds were reported to be from 090…Aug 28, 1987 · N3164D · Substantial damageNTSB ATL87FA243Accident · 1 fatalField investigationFinal reportAero Commander 112 · Middlefield, OHOn the previous flt, the plt made two unsuccessful IFR approaches before landing on the third attempt. The pax- configured acft was loaded with cargo. The plt filed an IFR flight plan and departed the arpt. Radio contact was established with ATC and the plt…Aug 28, 1987 · N1050J · DestroyedNTSB SEA87LA184Accident · No injuriesLimited investigationFinal reportBeech C-23 · Bremerton, WAOn the pilots third touch and go an undershoot occurred during landing onto runway 1. VASI lights are available for that runway. The plt was unable to explain why the undershoot occurred.Aug 27, 1987 · N18832 · Substantial damageNTSB MKC87DPG03Accident · Serious injuriesFinal reportAir Tractor AT-301 · Tillar, ARThe pilot stated that the prop RPM became erratic. On approach, the prop ran completely out of control, causing the aircraft to nose down into a plowed field just short of the landing area. The a/c hit on the main landing gear, broke them off, then it nosed…Aug 27, 1987 · N3159X · Substantial damageNTSB LAX87LA317Accident · No injuriesLimited investigationFinal reportBeech B-60 · Bermuda Dunes, CAThe right main landing gear hit the runway lip upon touchdown on runway 11 and collapsed. At the time of the accident the runway's overrun area was under construction and there was a nine inch lip at the runway end. The pilot was aware of the construction…Aug 27, 1987 · N6751D · Substantial damageNTSB LAX87FA318Accident · No injuriesField investigationFinal reportBell 206L-1 · Covelo, CAThe pilot performed a vertical takeoff. At aprx 30 ft AGL, while transitioning to forward flight, the engine lost power and the pilot partially lowered the collective to maintain rotor RPM. The helicopter landed hard on sloping terrain and bounced laterally…Aug 27, 1987 · N22HU · Substantial damageNTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…Aug 27, 1987 · N9065T · Substantial damageNTSB ATL87DMG02Accident · No injuriesFinal reportPiper PA-25-235 · Macclesfield, NCPlt ind that he was in procedure turn-around for spraying soybeans. Acft stalled and recovery initiated. Acft entered secondary stall and collided with trees. Examination of eng and acft did not disclose any pre-impact malfunction.Aug 27, 1987 · N89201 · DestroyedNTSB SEA87LA177Accident · Serious injuriesLimited investigationFinal reportCanton Rutan Long · Port Townsend, WADuring takeoff roll the pilot noted sluggish rotation performance and retarded the throttle to abort the takeoff. When he reduced power the aircraft rotated. He reapplied full power and abrupt aft stick, to execute rapid rotation and lift off. The hand grip…Aug 26, 1987 · N252BC · Substantial damageNTSB MKC87LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Holly Grove, ARThe pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures.Aug 26, 1987 · N8365K · Substantial damageNTSB MKC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, ARThe pilot fueled the aircraft with 20 gallons of 100LL for his flight to Hot Springs, AR. Forty miles from Hot Springs the left fuel tank indicated empty and the pilot switched to the right tank. Approximately 10 miles from Hot Springs, the engine quit and…Aug 26, 1987 · N5683U · Substantial damageNTSB MKC87FA169Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Kanorado, KSThe fss stated they had personally briefed the student pilot on the wx en route for this night flight and told him VFR was not recommended. At the first stop, he called the co-owner of the airplane and told her he had been flying around storms. At the next…Aug 26, 1987 · N8975P · DestroyedNTSB MIA87LA233Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Leland, MSWhile in cruise flight en route to a field for aerial application the engine lost power when the number one cylinder cracked between the spark plug holes. While maneuvering to land at a sod airstrip altitude could not be maintained and the left spray boom…Aug 26, 1987 · N4002K · Substantial damageNTSB MIA87FA234Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt was on an aprx 380 mi solo x-country flt fm Vero Beach (vrb) to naples (apf), brooksville (bkv) & back to vrb. He thought he had plenty of fuel for the flt & elected to dep w/o taking a credit card (for fuel). When he lndd at apf & bkv, he did…Aug 26, 1987 · N2316D · DestroyedNTSB DEN87FA224Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Devils Lake, NDThe acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft…Aug 26, 1987 · N11024 · DestroyedNTSB SEA87LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Oak Harbor, WAThe plt had not slept the night of the flt. He was wearing contact lens and had closed his eyes several times during the flt to alleviate stinging. While on short final approach to land the plt closed his eyes and fell asleep. When he awoke he was left of the…Aug 25, 1987 · N19092 · DestroyedNTSB MIA87LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe student plt had completed about 3.4 hrs of a solo cross-country training flt and was about 6 miles se of the airport, when the aircraft sustained a loss of power. A forced landing was performed in a celery field. Investigation revealed no usable fuel in…Aug 25, 1987 · N4745A · Substantial damage