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 FTW87IA108Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Denton, TXThe aircraft's right engine, while in flight, lost a blade from its fourth stage turbine wheel due to metal fatigue. This resulted in varying degrees of damage throughout the entire engine and caused the engine to shut itself down while climbing through…Apr 28, 1987 · N600KC · Minor damageNTSB DEN87LA114Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Valley City, NDThe commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road…Apr 28, 1987 · N6749Z · Substantial damageNTSB DEN87LA113Accident · No injuriesLimited investigationFinal reportBeech A24R · Beulah, WYThe acft lost power during a normal climb on a personal trip. The private plt noticed a drop in fuel flow pressure and smelled fuel. The plt then selected boost pump on but the pressure stayed low. The plt elected to make a forced landing and selected a…Apr 28, 1987 · N9784L · Substantial damageNTSB BFO87LA033Accident · No injuriesLimited investigationFinal reportCessna 150G · Roanoke, VAWhile enroute from gaithersburg, MD, to blacksburg, VA, the plt decided to divert to Roanoke, VA, due to thunderstorms in the area. On x-wind leg to rwy 33 at Roanoke the eng started to run rough. Aft carb heat was applied it smoothed out but quit completely…Apr 28, 1987 · N3043S · Substantial damageNTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…Apr 28, 1987 · N5670C · Substantial damageNTSB ANC87LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 28, 1987 · N2223T · Substantial damageNTSB SEA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blakely Island, WAThe plt landed with excess airspeed past the first third of the downhill runway. The aircraft bounced and the pilot added a little power. The aircraft then struck the runway with the nose gear. Since the plt feared going off the end of the runway into the…Apr 27, 1987 · N5185L · Substantial damageNTSB SEA87LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Renton, WADuring touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear.Apr 27, 1987 · N6312P · Substantial damageNTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…Apr 27, 1987 · N2595B · Substantial damageNTSB LAX87LA191Accident · Serious injuriesLimited investigationFinal reportBeech 95-55 · Monterey, CAJust after take-off, the cabin door opened in flight. The plt attempted to reland but was unsuccessful due to weather conditions. The plt was vectored to another arpt, however, the plt never climbed to the assigned alt and was never in radar contact. The plt…Apr 27, 1987 · N9711R · Substantial damageNTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…Apr 27, 1987 · N5644X · Substantial damageNTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.Apr 27, 1987 · N34S · Substantial damageNTSB DEN87LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Harvey, NDAn ag plt was working a field on an aerial application flt. At the end of a spray pass, the acft struck a shelterbelt and went out of control. The acft climbed to 300 ft and rolled inverted. The acft impacted the ground in a nose low, wing down attitude. The…Apr 27, 1987 · N9736P · Substantial damageNTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…Apr 27, 1987 · N5824S · Substantial damageNTSB ATL87LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Union Grove, NCThe plt reported that he was attempting to make a soft-field ldg in a plowed field at a friend's farm. He had not landed there previously. After initial touchdown was made on the main ldg gear, the nosewheel dug into a rise in the terrain and the airplane…Apr 27, 1987 · N4678G · Substantial damageNTSB ATL87LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Pinehurst, NCThe pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He…Apr 27, 1987 · N7136P · DestroyedNTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…Apr 26, 1987 · N1145Q · DestroyedNTSB MIA87LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · St.Petersburg, FLWhile landing, the acft floated down the rwy as the result of excessive airspeed during the apch. The plt continued to flare the acft, & as the airspeed bled off, the wings stalled, resulting in a hard landing. The acft then began to propoise, & on the third…Apr 26, 1987 · N217JA · Substantial damageNTSB LAX87LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Fullerton, CAThe pilot reported that a gust of wind turned the aircraft left just prior to touchdown on runway 24. He was unable to maintain directional control during the landing roll and the aircraft ran off the left side of the runway. The reported surface winds were…Apr 26, 1987 · N2936C · Substantial damageNTSB LAX87LA190Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Rubidoux, CAA Hughes 269B went out of control and collided with the ground during a t/o to a hover. The pilot had purchased the aircraft recently and was learning to fly it. He was scheduled for his first flight lesson on the day of the accident. The CFI reported that he…Apr 26, 1987 · N101DN · DestroyedNTSB FTW87LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXA student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted.Apr 26, 1987 · N5100Q · Substantial damageNTSB FTW87LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Pond Creek, OKPilot failed to lower flaps for a short field takeoff. After rotation the pilot realized that the aircraft would not clear a power line off the end of the runway and aborted the takeoff. The aircraft ran off the end of the runway and contacted a fence and…Apr 26, 1987 · N2114E · Substantial damageNTSB CHI87LA118Accident · No injuriesLimited investigationFinal reportPiper J3C · Midland, MIWhile taxiing to runway 24 run up area the aircraft flipped over onto its nose. The pilot stated a gust of wind caught the plane from behind. Winds at the tri-city airport, 12 miles southeast of Midland, were reported from 130 degrees at 6 knots.Apr 26, 1987 · N6AJ · Substantial damageNTSB BFO87LA032Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Manassas, VAThe student, under the supervision of the instructor, was practicing hovering; about 5 ft AGL. The stu had been overcontrolling the acft and each time the instr would take corrective action to stabilize the acft. The accident occurred when the stu…Apr 26, 1987 · N2486N · Substantial damageNTSB SEA87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ritter Butte, ORDuring a cross country flt the plt noticed that he was gradually losing his communications radio and navigational instruments. Shortly afterwards the plt noticed that the fuel gauges were quickly approaching empty. Since hostile terrain was ahead the plt…Apr 25, 1987 · N1935F · DestroyedNTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.Apr 25, 1987 · N7726W · Substantial damageNTSB NYC87LA130Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Rumford Point, MEWhile circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts…Apr 25, 1987 · N9119K · Substantial damageNTSB MKC87LA091Accident · Minor injuriesLimited investigationFinal reportBeech V35B · N Little Rock, ARThe acft was on a short ferry flt when the fuel pressure decreased and could not be restored. During the final apch of the forced landing on a city street, the acft struck a ground wire and fell to the street. Due to the intense fire that followed, the reason…Apr 25, 1987 · N1718W · DestroyedNTSB MKC87LA090Accident · No injuriesLimited investigationFinal reportCessna A188B · Orleans, NEThe pilot stated that he was spraying a wheat field with a load of chemicals, and was completing his fourth swath run, when he noticed powerlines in his flight path. He performed an evasive maneuver; however, the aircraft struckthe powerlines. The aicraft…Apr 25, 1987 · N6048G · Substantial damageNTSB MIA87LA147Accident · No injuriesLimited investigationFinal reportPiper J-3 · Miami, FLThe owners rprtd the acft was stolen on 4/25/87. The non-certificated plt rprtd that he had taken the acft without permission. Drg flt, the eng lost power, & subsequently, the plt made a forced lndg in the everglades about 9 mi west of the tamiami arpt. He…Apr 25, 1987 · N25863 · Substantial damageNTSB MIA87LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Daytona Beach, FLThe plt stated that during the landing roll, after depressing both brakes evenly, the rt brake locked up causing the acft to leave the rwy. The arpt was Beach regional airport, Daytona Beach, Florida, the acft collided with a taxiway marker sign & came to…Apr 25, 1987 · N129ER · Substantial damageNTSB MIA87LA145Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Rolling Fork, MSWhile landing downwind, at an alt of aprx 20 feet, the helicopter began to settle with power. The pilot then attempted to stop the descent, however, because of insufficient alt & airspeed, was unable. The helicopter then landed hard, rolled over, after which,…Apr 25, 1987 · N202CH · Substantial damageNTSB LAX87DVA06Accident · 1 fatalFinal reportNorth American F-86F · Shafter, CAFollowing an airshow, the pilot transmitted while on final approach to the runway, that the engine had seized. The aircraft was landed with the landing gear retracted. During the flare the aircraft became uncontrollable, bounced several times on the runway,…Apr 25, 1987 · N86Z · DestroyedNTSB LAX87DUG03Accident · Serious injuriesFinal reportFrimelt Werner Moni 164 · Lake Riverside, CAJust after take off of a homebuilt, experimental acft, a witness observed the acft at aprx 150 ft AGL initiate a 15 deg turn to the right. Immediately thereafter the acft pitched down slightly and began to lose altitude, then abruptly entered a spin and…Apr 25, 1987 · N189L · Substantial damageNTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…Apr 25, 1987 · N3575 · Substantial damageNTSB FTW87FA105Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Eagle Lake, TXOn April 25,1987 a Grumman American AA5B, N28846, impacted the terrain near Eagle Lake, Texas. The private pilot and her husband received fatal injuries. The aircraft was destroyed. Visual meteorological conditions prevailed at the time of the accident. The…Apr 25, 1987 · N28846 · DestroyedNTSB DEN87FA111Accident · Serious injuriesField investigationFinal reportTaylorcraft F21 TC · Boulder, COThe flt instructor and student plt were practicing night touch and go landings. Flt instructor reduced engine power to idle after takeoff to simulate an engine failure. He banked the acft 'steeply' to the left at a low altitude. The acft struck the ground in…Apr 25, 1987 · N2005C · Substantial damageNTSB CHI87LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Terre Haute, INAircraft stalled on takeoff during an instructional flight. No malfunctions or mechanical problems were reported by either pilot. Witnesses reported that the engine sounded smooth but did not seem to be developing full power. Inspection of aircraft after the…Apr 25, 1987 · N51881 · Substantial damageNTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damageNTSB ATL87FA124Accident · No injuriesField investigationFinal reportCessna 500 · Willoughby, OHAcft had been flown over 4 hrs on pers. Business for owner. Plts had stopped at lnn to drop off pax. Start & taxi were norm for positioning flt back to home base. Started t.o. roll and when eng RPM reached 80-85% toward tgt of 95.7%, plts reptd loud 'bang'…Apr 25, 1987 · N82AT · Substantial damageNTSB MKC87LA093Accident · No injuriesLimited investigationFinal reportForney Ercoupe · Omaha, NEThe annual inspection on this acft was completed the day prior to this accident. During this flt, the wire holding the fuel filter bowl in place came loose and the bowl came off. The eng quit from fuel starvation and the plt made a forced landing in a plowed…Apr 24, 1987 · N7515C · Substantial damageNTSB LAX87LA189Accident · 4 fatalLimited investigationFinal reportCessna 172N · Lihue, HIThe pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…Apr 24, 1987 · N739RV · DestroyedNTSB LAX87DUM02Accident · No injuriesFinal reportRockwell S2R · Imperial, CADuring an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…Apr 24, 1987 · N4194X · Substantial damageNTSB FTW87FA102Accident · Serious injuriesField investigationFinal reportCessna T210L · Lufkin, TXThe pilot reduced power and was descending for a VFR straight-in approach when the engine quit. The pilot had the selector on the left tank with 4 to 5 gallons of fuel remaining in this tank. During the descent the fuel tank outlet line became unported…Apr 24, 1987 · N4637Q · DestroyedNTSB DEN87LA100Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9B · Wood, SDA commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…Apr 24, 1987 · N2755V · DestroyedNTSB CHI87LA116Accident · No injuriesLimited investigationFinal reportCessna 172XP · Superior, WIUpon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were…Apr 24, 1987 · N5093V · Substantial damageNTSB ANC87LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Theodore River, AKThe pilot stated that during the landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 24, 1987 · N9597S · Substantial damageNTSB MKC87LA089Accident · No injuriesLimited investigationFinal reportCessna 172E · Moorhead, IAAccording to FAA statements, the pilot was attempting a takeoff from a taxiway when a wing dipped. The pilot then lost control as the wing dragged, causing the aircraft to ground loop/swerve onto the terrain. The nose gear tire blew during the swerve and the…Apr 23, 1987 · N3777S · Substantial damageNTSB MKC87LA088Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Lincoln, KSThe plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched…Apr 23, 1987 · N8802B · Substantial damageNTSB MIA87LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadoa, FLDuring the landing roll the plt diverted his attention from taxiing the acft to raising the flaps and turning off the carb heat. The rt wing was then lifted by the cross wind, after which, the plt applied excessive rt rudder. The acft left the rwy, fell into…Apr 23, 1987 · N49832 · Substantial damage