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 NYC87LA116Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Warwick, NYThe flight was on approach for landing on runway 3 at Warwick airport when the engine started to sputter. The pilot continued to pump the throttle but overshot the runway and landed in a swamp. It was not determined what caused the loss of power to the engine.Apr 5, 1987 · N2833H · Substantial damageNTSB MKC87LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Muscatine, IAThe grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a…Apr 5, 1987 · N79179 · DestroyedNTSB MKC87FA067Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 6 · Kansas City, MOThe pilot stated that lift-off and climbout were normal but, shortly thereafter, the fuel pilot light began to fail continuously until the burner flamed out. The passengers were briefed and the chase vehicle was contacted by cb radio before the plt climbed up…Apr 5, 1987 · N3695B · Substantial damageNTSB MIA87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ft.Lauderdale, FLThe plt reported that while towing a banner aprx 200-300 yards offshore at an alt of aprx 500 ft the eng sputtered, then quit. Attempts to restart it were unsuccessful. The banner was then released & the acft was ditched in the ocean. Post crash examination…Apr 5, 1987 · N9663H · Substantial damageNTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…Apr 5, 1987 · N8678V · Substantial damageNTSB LAX87LA194Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Healdsburg, CADuring what was supposed to be a taxi test, the plt decided to takeoff when he lost control of the acft. The acft veered to the right off the rwy and collided with the terrain. The plt had flown the acft for the first time with the owner the day before the…Apr 5, 1987 · N9216K · Substantial damageNTSB LAX87LA169Accident · 2 fatalLimited investigationFinal reportCessna 182Q · Needles, CAA Cessna 182Q collided with an unmarked 50 ft high cable over the Colorado river. The acft was observed flying below the level of the cable rocking its wings to boaters and sunbathers. One witness stated that the acft 'buzzed us, so low, I actually ducked,…Apr 5, 1987 · N4828N · DestroyedNTSB LAX87LA168Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZDuring a pleasure Balloon ride, the Balloon lifted off in a southerly direction then shifted to a south easterly direction. The plt felt that the balloons response time for adequate lift took too long. The Balloon began drifting toward 50 to 60 ft power…Apr 5, 1987 · N3750D · No damageNTSB FTW87LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Horizon City, TXThe pilot delayed in initiating recovery from a simulated forced landing. Then when the throttle was advanced from idle to full open the engine hesitated briefly and full power was restored too late to recover. A hard left bank was initiated to align the…Apr 5, 1987 · N85397 · DestroyedNTSB DEN87LA086Accident · No injuriesLimited investigationFinal reportBoeing A75L3 · Belgrade, MTThe plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about…Apr 5, 1987 · N5084N · Substantial damageNTSB DEN87LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTAn ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original…Apr 5, 1987 · N23069 · Substantial damageNTSB ATL87LA105Accident · Serious injuriesLimited investigationFinal reportAir & Space 18A · Paducah, KYThe plt reported that he spun the rotor up to 350 RPM in preparation for a maximum performance takeoff. During takeoff roll, the gyroplane experienced ground resonance. The plt reduced the throttle to idle, but the oscillations continued and the rt main ldg…Apr 5, 1987 · N6141S · Substantial damageNTSB ANC87LA058Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe pilot reported that he could not keep the ski equipped aircraft from banking to the left after take off and elected to reduce power and land. The aircraft sustained substantial damage when the left wing tip struck the ground and cartwheeled during the…Apr 5, 1987 · N9073D · Substantial damageNTSB SEA87LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Alkali Lake, ORDuring a windy crosswind approach the pilot lost control of the aircraft. The aircraft struck the ground short of the runway breaking off the nose gear and then nosing over inverted.Apr 4, 1987 · N1770J · Substantial damageNTSB SEA87LA073Accident · Minor injuriesLimited investigationFinal reportCessna TU206-F · Reno, NVWhile on base leg a loss of power occurred. The student pilot selected right fuel tank and applied the fuel boost pump. A restart was not successful. The instructor pilot then took the controls of the aircraft. He selected a road to land on because there was…Apr 4, 1987 · N71068 · Substantial damageNTSB MKC87LA075Accident · No injuriesLimited investigationFinal reportBeech 35A · Liberal, KSThe PIC rptd experiencing turbulence on takeoff from Liberal airport. Winds were prevailing from the southeat at 15 knots as he departed the airstrip using runway 19. At rotation, the PIC reported that the left wing got too high and he lost control. The PIC…Apr 4, 1987 · N1953V · Substantial damageNTSB LAX87LA171Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAWhile holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna.Apr 4, 1987 · N5690N · 2 aircraft · Minor damageNTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…Apr 4, 1987 · N402BC · Substantial damageNTSB DEN87LA083Accident · No injuriesLimited investigationFinal reportCessna 180B · Boulder, COThe plt reports that he was landing with a lt x-wind at 10 to 15 KTS. He said that at or just after touchdown a gust of wind lifted the lt wing and the acft swerved to the lt off the rwy and nosed over.Apr 4, 1987 · N5207E · Substantial damageNTSB ATL87LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lebanon, TNThe plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard…Apr 4, 1987 · N4974J · Substantial damageNTSB SEA87LA128Accident · No injuriesLimited investigationFinal reportMooney M20F · Grants Pass, ORShortly after takeoff the pilot realized that he had no airspeed indication due to his forgetting to remove the pitot cover during preflight. The pilot returned to land at the airport and landed gear up.Apr 3, 1987 · N6901V · Substantial damageNTSB SEA87LA074Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Forks, WADuring external load operation the aircraft's engine ceased operating. The helicopter was too close to the ground for recovery. The helicopter descended, struck the ground hard and then rolled over onto its right side. Water in the fuel was discovered after…Apr 3, 1987 · N8356F · DestroyedNTSB MIA87LA127Accident · No injuriesLimited investigationFinal reportCessna 180H · Frostproof, FLUpon touchdown the rt landing gear tire blew due to the side load placed upon it after the acft was blown sideways by the direct crosswind. The landing gear was then sheared off, after which, the acft slid off the rwy into the grass & came to rest.Apr 3, 1987 · N9731G · Substantial damageNTSB MIA87LA126Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Miami, FLDuring climb to cruise the pilot lost one blade of the three bladed right propeller, due to the failure of the hub. Examination of the propeller and engine revealed that the crankshaft counterweight bushings were not installed allowing a high frequency…Apr 3, 1987 · N506ES · Substantial damageNTSB LAX87DVW01Accident · Minor injuriesFinal reportNorth American P51D · Ashfork, AZThe North American P-51D experienced a total loss of engine power after cruising at 10,000 feet MSL for 45 minutes. Attempts to restart the engine were unsuccessful. The aircraft collided with some trees prior to coming to rest in an open field. The landing…Apr 3, 1987 · N1451D · Substantial damageNTSB DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…Apr 3, 1987 · N1653G · DestroyedNTSB DEN87LA080Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COAn 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to…Apr 3, 1987 · N2323D · Substantial damageNTSB DEN87LA079Accident · No injuriesLimited investigationFinal reportNorth American Navion · Los Alamos, NMThe instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…Apr 3, 1987 · N91735 · Substantial damageNTSB DEN87FA081Accident · Serious injuriesField investigationFinal reportPiper PA-22-150 · Morgan, UTThe plt departed Morgan arpt with an acft near gross weight, in a relatively strong cross wind. After a successful takeoff at about 100 AGL, he said he encountered moderate turbulence and a downdraft. Altitude and airspeed could not be maintained. The acft…Apr 3, 1987 · N3809P · DestroyedNTSB CHI87DER03Accident · No injuriesFinal reportHiller UH-12ET · Big Lake, MNAircraft was being maneuvered for landing on a ground support trailer when it experienced a power failure. Due to high trees autorotation was made to adjacent field. Aircraft landed on rough/uneven terrain and rolled over. Investigation revealed contaminated…Apr 3, 1987 · N135HA · Substantial damageNTSB ATL87FA104Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Rhine, GAThe non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.Apr 3, 1987 · N47887 · DestroyedNTSB SEA87LA072Accident · No injuriesLimited investigationFinal reportPiper PA 16 · Jean, NVThe plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks.Apr 2, 1987 · N5916H · Substantial damageNTSB NYC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bridgeport, NJThe pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees.Apr 2, 1987 · N75336 · Substantial damageNTSB MKC87LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Topeka, KSThe tower stated the aircraft made a hard bounce and when it touched down again, the right gear collapsed. The airplane landed on runway 3 with winds from 350 degrees at 17 knots, gusts to 32 knots. Runway 3 was the best runway to use at the time.Apr 2, 1987 · N1467F · Substantial damageNTSB MIA87LA130Accident · No injuriesLimited investigationFinal reportCessna 310D · Miami, FLThe plt stalled the acft prior to touchdown resulting in a hard landing. According to FAA personnel at Oklahoma city, the plt holds a private plt certificate with a single eng land rating and was not rated in the Cessna 310D aircraft.Apr 2, 1987 · N6880T · Substantial damageNTSB MIA87LA125Accident · No injuriesLimited investigationFinal reportNorth American B-25-J · Titusville, FLThe plt stated that he was in the vicinity of melbourne FL when the right engine failed. He secured the right engine and turned back towards new smyrna beach, but as he was nearing tico airport the left engine also failed. The pilot, realizing he was not…Apr 2, 1987 · N25NA · Substantial damageNTSB MIA87FA124Accident · Serious injuriesField investigationFinal reportEagle C-7 · Ft. Lauderdale, FLThe balloon struck powerlines while attempting to locate a suitable ldg site. The plt stated that a gust of wind blew the balloon into the wires & he was unable to climb to avoid the wires prior to impact. The surface winds were from the north at about 8 KTS…Apr 2, 1987 · N7321R · Substantial damageNTSB LAX87FA167Accident · 2 fatalField investigationFinal reportChampion 7ECA · Upland, CAThe pilot took off from his home airport for a sight-seeing, local flight over nearby mountains. Although the rear seat passenger weighed 270 lbs and the aircraft's fuel tanks were assumed to be full, there is no evidence that the pilot calculated the…Apr 2, 1987 · N9655S · DestroyedNTSB FTW87FA090Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Uvalde, TXOn 04-02-87, a Piper PA-38-112, N5540E, owned and operated by southwest Texas junior college, impacted the terrain near Uvalde, TX. The flight was conducted for training purposes. Visual meteorological conditions prevailed at the time of the accident. The…Apr 2, 1987 · N4450E · Substantial damageNTSB ANC87MA057Accident · 2 fatalMajor investigationFinal reportCessna 402 · Anchorage, AKThe acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground…Apr 2, 1987 · N967JW · Substantial damageNTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…Apr 1, 1987 · N733PX · Substantial damageNTSB MKC87LA072Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge City, KSThe pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field…Apr 1, 1987 · N48564 · Substantial damageNTSB MKC87LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Coeur, MOThe PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a…Apr 1, 1987 · N89316 · Substantial damageNTSB MIA87LA123Accident · No injuriesLimited investigationFinal reportCessna A150M · Jackson, MSThe plt stated that he failed to remove the control column gust lock prior to take off. Immediately after rotation, the acft began to porpoise, descended uncontrolled, & landed hard collapsing the landing gear. He further stated that this accident could have…Apr 1, 1987 · N7344A · Substantial damageNTSB MIA87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe nose gear collapsed following a hard landing due to the student plts failure to adequately flare the acft.Apr 1, 1987 · N95904 · Substantial damageNTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.Apr 1, 1987 · N31681 · Substantial damageNTSB DEN87LA078Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Englewood, COThe student plt said the acft ballooned during the flare and he applied forward stick. The acft touched down nose wheel first and the nose gear collapsed. The acft then settled hard on main gear resulting in additional damage.Apr 1, 1987 · N114PA · Substantial damageNTSB ATL87LA103Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Oliver Springs, TNThe plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…Apr 1, 1987 · N2510Y · Substantial damageNTSB ATL87LA102Accident · Serious injuriesLimited investigationFinal reportBoeing 727-295 · Miami, FLAn 84 year-old male pax got up from his seat shortly after takeoff and headed toward the aft lavatories. The seat belt and no smoking signs were still illuminated. The acft was at about 1000 ft AGL and in a steep climb attitude. The pax fell face forward…Apr 1, 1987 · N1643 · No damageNTSB MKC87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tribune, KSThe pilot stated that he was spotting stray cattle after a snow blizzard moved through the region. Two hours into the flight, the pilot further stated, he reduced engine power for approximately 10 seconds--without carburetor heat. The engine then sputtered…Mar 31, 1987 · N89547 · Substantial damage