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 SEA87LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Cashmere, WADuring aerial applications maneuver a loud whine accompanied by a loss of power occurred. During forced landing a hard landing was made collapsing the skids with the main rotor blades striking the ground. No reason for the power loss was found.Jul 6, 1987 · N73932 · Substantial damageNTSB SEA87LA133Accident · No injuriesLimited investigationFinal reportMooney M-20 · Spokane, WAAt touchdown a prop strike occurred. The pilot immediatley added full power to go around. Since the prop strike was severe full power was not available. The pilot made a shallow 180 degree turn back to the rwy and landed on the grass. During the landing…Jul 6, 1987 · N5265B · Substantial damageNTSB NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…Jul 6, 1987 · N1403W · Substantial damageNTSB FTW87LA162Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Big Spring, TXDuring flt, the plt noted that the left fuel tank was almost empty and the right tank had gained fuel. He immediately switched from the both position to the right tank and started to work the wobble pump. The fuel continued to drop in the left tank and the…Jul 6, 1987 · N322 · Substantial damageNTSB DEN87LA173Accident · No injuriesLimited investigationFinal reportBeech B-60 · Kanab, UTThe commercial corporate plt had deplaned his passengers and was beginning the second leg of a corp/exec flight. During ground run the plt detected a manifold pressure loss on the left engine. The plt aborted the takeoff and applied heavy braking. The…Jul 6, 1987 · N18444 · Substantial damageNTSB BFO87LA045Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Cambridge, MDWhen the aircraft failed to start the pilot set the throttle, insured the aircraft was tied down and attempted to start the aircraft by hand propping. The aircraft started immediately, broke both tie-down ropes, traveled across the field into a ditch and…Jul 6, 1987 · N5775V · Substantial damageNTSB BFO87FA046Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Abingdon, VAFss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the…Jul 6, 1987 · N19SM · DestroyedNTSB ATL87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Goldsboro, NCStudent PIC rpted he followed wrong railroad track to return from the practice area to the airport. Viz was about 6 miles in hazy conditions. Prior to exhausting fuel or daylight he elected to land in a field. Field was soft terrain and acft nosed over.Jul 6, 1987 · N69087 · Substantial damageNTSB ANC87LA091Accident · No injuriesLimited investigationFinal reportDornier DO-27 · White Mountain, AKThe pilot stated that while cruising at 2000 feet MSL the engine started to run rough. He made an emergency landing on the tundra. Examination of the engine revealed the number one and number two cylinders broke and separated in flight.Jul 6, 1987 · N777AX · Substantial damageNTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.Jul 5, 1987 · N3438M · Substantial damageNTSB NYC87LA197Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Scoodic Lake, METhe plt of the float equipped acft was taking off from Scoodic Lake. Drg the initial climb phase after takeoff, he noted the acft began to lose altitude & would not clear trees on a ridge ahead. He initiated a turn back toward the lake; however, the acft…Jul 5, 1987 · N8955R · Substantial damageNTSB NYC87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Roseville, PAWitnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found.Jul 5, 1987 · N7933F · Substantial damageNTSB NYC87DNE03Accident · No injuriesFinal reportNoble Falcon X-P · Wallingford, CTThe undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing.Jul 5, 1987 · N62JC · Substantial damageNTSB NYC87DNC07Accident · 1 fatalFinal reportMcculloch Monerai "S" · Springfield, VTThe monerai 's' (N54MS, a pwrd glider) experienced an inflt failure of the left wing spar & crashed. An investigation revealed the acft was being operated in excess of its max gross wt limit of 450 lbs. The plt of an unpowered monerai said he & 3 others…Jul 5, 1987 · N54MS · DestroyedNTSB LAX87DUJ07Accident · Minor injuriesFinal reportKiesel Midget Mustang · Window Rock, AZThe aircraft lost power shortly after takeoff and collided with a dirt bank during the subsequent forced landing. Engineexamination revealed an open intake valve on the number 4 cylinder and the pilot stated a 'bent and cracked crankshaft from a prior…Jul 5, 1987 · N68WK · Substantial damageNTSB FTW87LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Roanoke, TXDuring final approach the aircraft developed an excessive sink rate and the pilot elected to go-around. When the pilot applied power the nose and right wing pitched up, causing the aircraft to turn 90 degrees, and stall. The aircraft contacted some power…Jul 5, 1987 · N15491 · Substantial damageNTSB FTW87LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Dallas, TXDuring flare/touchdown on runway 15, the aircraft's right wing came up sharply, due to a gusting cross wind, causing the left wing to strike the runway. The aircraft then cartwheeled, left wing, nose, right wing, causing substantial damage. Reported winds at…Jul 5, 1987 · N56420 · Substantial damageNTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…Jul 5, 1987 · N132E · DestroyedNTSB DEN87LA171Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Cripple Creek, COThis acdt occurred when the plt attempted to takeoff on a 2600 ft long rwy when the density altitude was about 13,500 ft. the acft overran the rwy and collided with a highway. The plt said that the field was too high and too short and it was too hot.Jul 5, 1987 · N112U · Substantial damageNTSB DEN87LA170Accident · 2 fatalLimited investigationFinal reportChristian Eagle II · Snowmass, COThe ATP plt and his passenger departed aspen, CO on a local acrobatic flight. Witnesses stated the plt had been performing acrobatic manuevers and was attempting a 'loop' when the acft was observed to 'stall' at the top of the manuever, approximately 2000…Jul 5, 1987 · N81DG · DestroyedNTSB DEN87LA169Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Red Lodge, MTThe plt stated that shortly after takeoff he intended to switch fuel to fullest tank but inadvertently put the fuel selector on off position. The engine failed. He did not have enough altitude or time to correct the situation and had to make a forced landing…Jul 5, 1987 · N5858D · Substantial damageNTSB CHI87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Duluth, MNRprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft…Jul 5, 1987 · N56808 · Substantial damageNTSB ATL87LA199Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Mt. Airy, NCThe instructor stated this was the second flight of the day with the student. They had released from an air tow at 1,500 feet AGL. The instructor was demonstrating glide slope control for best final glide. When the sailplane was about 1,000 feet AGL and one…Jul 5, 1987 · N930BG · Substantial damageNTSB ATL87LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · St Marys, GAAfter returning fm a local ngt flt, the acft was lndd gear up when the lndg gear did not extend. The acft bgn burning after it came to rest. It was extensively damaged by fire & the cause of the gear malfunction was not determined. Local police, who responded…Jul 5, 1987 · N6165P · Substantial damageNTSB SEA87LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Glenns Ferry, IDDuring takeoff with a quartering tailwind about 3/4 way down the runway the aircraft settled back onto the runway. There was not enough room to stop the aircraft. The aircrafts main gear caught on a fence and tall wheat with the aircraft coming to rest…Jul 4, 1987 · N5580X · DestroyedNTSB SEA87FA129Accident · 2 fatalField investigationFinal reportCessna 150G · Vashon, WAAircraft departed on a routine instructional flight. Radar track indicated aircraft engaging in maneuvers typical of instructional high work (stalls/turn/slow flight) followed by left orbit about grass airstrip used only for practice emergency landing…Jul 4, 1987 · N3736J · DestroyedNTSB MIA87LA197Accident · Minor injuriesLimited investigationFinal reportCessna TU-206F · Ft. Lauderdale, FLThe pilot refueled for the flight by topping off the fuel tanks. He then utilized the left tank until it was empty and switched to the right for the remainder of the flight. About 2 miles short of the destination the engine failed. The right fuel cap was…Jul 4, 1987 · N744AP · Substantial damageNTSB LAX87LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Huron, CAAt the end of a cross country flight,the plt applied the brakes on touch down. The acft veered to the left and the plt applied the right brake, however, the left main landing gear went off the edge of the rwy. The acft went out of control, exited the rwy and…Jul 4, 1987 · N8273P · Substantial damageNTSB FTW87LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Galveston, TXThe plt had lndd on an abandoned airstrip & was attempting to takeoff again. He stated that due to birds on the rwy, he deviated to the left to avoid a bird strike. Subsequently, the landing gear collided with a chunk of raised concrete which was hidden by…Jul 4, 1987 · N8274U · Substantial damageNTSB FTW87FA161Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · El Paso, TXEscaping hot exhaust gas from the broken exhaust manifold melted the sealant from several areas of the firewall where hoses, wires, etc., pass through to the cocipit area. Heavy black smoke produced by smoldering wire insulation, fire shield material, etc.,…Jul 4, 1987 · N5777M · DestroyedNTSB FTW87FA156Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F1 · Venice, LAOne of the mechanics who performed maintenance on the aircraft main rotor head stated that he was not sure that he installed the retaining bolts which secured the vibration absorber assembly to the aircraft. Metallurgical analysis of the assembly indicated…Jul 4, 1987 · N5796M · DestroyedNTSB DEN87LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Las Vegas, NMThe plt reported that he experienced a departure stall after take off. A witness reported that the plt attempted a steep turn immediately after takeoff and that the acft appeared to stall. The left wing went down and the acft began an uncontrolled descent…Jul 4, 1987 · N9406P · Substantial damageNTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.Jul 4, 1987 · N6933V · DestroyedNTSB CHI87DEC04Accident · 2 fatalFinal reportBeech S35 · Pontiac, MIAcft was making a low pass about 200 ft AGL over rwy 27L to allow ATCT personnel to inspect landing gear position after reporting landing gear difficulties. After twr personnel informed the plt that the gear appeared to be down, the plt requested to land on…Jul 4, 1987 · N9011S · DestroyedNTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…Jul 4, 1987 · N1162F · DestroyedNTSB ANC87LA089Accident · No injuriesLimited investigationFinal reportCessna 180 · Matanuska Glaci, AKThe pilot stated that upon touchdown on the glacier the surface was cluster snow. The aircraft rolled about 150 feet and nosed over on its back.Jul 4, 1987 · N2995T · Substantial damageNTSB SEA87LA198Accident · No injuriesLimited investigationFinal reportCessna 150A · Tacoma, WAWhile lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about…Jul 3, 1987 · N9815J · Substantial damageNTSB SEA87LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Sprague River, ORA hard, flat, bounced landing occurred collapsing the nose gear and damaging the firewall.Jul 3, 1987 · N2625Q · Substantial damageNTSB SEA87LA130Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Olympia, WADuring landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the…Jul 3, 1987 · N55FS · Substantial damageNTSB NYC87LA195Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Jamestown, NYThe student plt rented the acft & flew to a field aprx 40 mi from the dep arpt. After landing, a passenger boarded the acft. The student started to takeoff again. Drg takeoff, the acft lifted off, but would not climb sufficiently to clear trees at the dep end…Jul 3, 1987 · N2460E · Substantial damageNTSB NYC87DNC06Accident · 1 fatalFinal reportEnstrom F-28A · Mason, NHThe loss of aircraft control after the tail rotor struck the trees and departed the aircraft. The pilot's poor judgement in flying in weather conditions beyond his capabilities was a factor.Jul 3, 1987 · N9271 · DestroyedNTSB MKC87FA130Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-60 · Kansas City, MODuring a takeoff, PIC lost directional control of acft, causing it to swerve off the active runway, spin around, shearing the nose gear assembly and left main wheel. The nose wheel strut assembly careened into the right powerplant propeller causing the torque…Jul 3, 1987 · N271MA · Substantial damageNTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…Jul 3, 1987 · N7SD · DestroyedNTSB FTW87LA157Accident · No injuriesLimited investigationFinal reportCessna 172L · Houston, TXWhile lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged.Jul 3, 1987 · N3980Q · Substantial damageNTSB DEN87LA174Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Silverthorne, COThe commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose…Jul 3, 1987 · N41986 · No damageNTSB DEN87LA172Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pagosa Springs, COThe commercial plt and a friend departed aztec, new Mexico, with the intention of flying over wolf creek pass en route to Colorado Springs, Colorado. He said the acft would not climb over the pass and the acft collided with trees in mountainous terrain. The…Jul 3, 1987 · N25655 · Substantial damageNTSB DEN87LA165Accident · No injuriesLimited investigationFinal reportCessna 150-J · Ogden, UTThe plt and his son were returning home to Ogden. The plt reported to Ogden tower, 'I'm out of fuel.' The plt later stated, 'I landed in a field of two foot tall grass about five miles north of Ogden arpt. Prior to coming to a stop the acft struck a ditch…Jul 3, 1987 · N60154 · Substantial damageNTSB DEN87LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lordsburg, NMWhile en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered…Jul 3, 1987 · N5032S · Substantial damageNTSB CHI87DET08Accident · Serious injuriesFinal reportPiper PA-28R-180 · Benton Harbor, MIWhile the aircraft was climbing to altitude the pilot tried to decrease power to cruise climb but had to reduce power more to control the propeller RPM. The pilot decreased the power once again and shortly after the engine stopped. The pilot then attempted to…Jul 3, 1987 · N7681J · DestroyedNTSB CHI87DEP08Accident · No injuriesFinal reportUnknown Avid Flyer · Cottage Grove, WIOn return from the second test flight in the experimental aircraft, the pilot failed to maintain the proper descent rate on short final. An attempt to add power to correct the situation was unsuccessful, and the aircraft touched down on a highway short of the…Jul 3, 1987 · N169AF · Substantial damage