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 SEA87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakutat, AKWhile taxiing, after landing on a murky river, the pilot did not see a sand bar. The aircraft struck the sand bar and the aircraft then nosed over inverted. The plt did not file an acc rpt and held a canadian pilot certificate.May 18, 1987 · CFCLL · Substantial damageNTSB LAX87LA209Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Apple Valley, CAThe pilot lost control of the aircraft and entered an inadvertent spin during the initial climbout following a touch-and-go landing. The pilot reported a loss of power after climbing to 500 feet. Another pilot on the airport observed the aircraft in a very…May 18, 1987 · N9220U · DestroyedNTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.May 18, 1987 · N62629 · Substantial damageNTSB ATL87FA142Accident · 4 fatalField investigationFinal reportCessna T337G · Oxford, OHThe pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…May 18, 1987 · N436 · DestroyedNTSB ATL87DMG01Accident · No injuriesFinal reportGrumman G-164B · Beaufort, NCThe plt had just loaded the hopper with dylox chemical. As the acft became airborne, the plt stated, he experienced wind shear and the acft rolled to the right. The plt corrected by leveling the wings and immediately experienced a second more violent wind…May 18, 1987 · N3628Z · DestroyedNTSB SEA87LA096Accident · No injuriesLimited investigationFinal reportMooney M20F · Wagontire, ORDuring takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck…May 17, 1987 · N3523X · Substantial damageNTSB NYC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Reading, PAAccording to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the…May 17, 1987 · N4387X · Substantial damageNTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.May 17, 1987 · N3886E · Substantial damageNTSB NYC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Falmouth, MAAbout 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…May 17, 1987 · N30694 · Substantial damageNTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…May 17, 1987 · N785 · Substantial damageNTSB MKC87LA104Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Wamego, KSThe PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.…May 17, 1987 · N8789T · Substantial damageNTSB LAX87LA211Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tucson, AZA Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located…May 17, 1987 · N5762G · Substantial damageNTSB LAX87LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Turlock, CAApproximately 15 minutes into a pleasure flight, the engine experienced a partial loss of power. The pilot made an emergency landing at a nearby airport, where upon landing the aircraft ran off the runway and collided with a bush. Inspection of the engine…May 17, 1987 · N38458 · Substantial damageNTSB LAX87FA207Accident · Serious injuriesField investigationFinal reportCessna 182L · Santa Monica, CAThe acft lost power during initial climb and crashed on a residential street during an attempted forced landing. The throttle arm was found separated from the throttle shaft. The arm had been replaced 19 hours prior to the accident. Examination of the…May 17, 1987 · N42814 · DestroyedNTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…May 17, 1987 · N201MK · Substantial damageNTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…May 17, 1987 · N50499 · DestroyedNTSB BFO87FA037Accident · 1 fatalField investigationFinal reportCessna 150M · Elkton, MDThe acft was flying at low altitude over an area of open fields when according to witnesses the acft abruptly pitched down and descended to the ground. Some witnesses stated they heard the engine operating throughout the descent while ohter witnesses reported…May 17, 1987 · N714FZ · DestroyedNTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…May 17, 1987 · N527B · Substantial damageNTSB NYC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Toms River, NJThe flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings.May 16, 1987 · N9443W · Substantial damageNTSB NYC87LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJAccording to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a…May 16, 1987 · N734EM · Substantial damageNTSB NYC87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Honeoye Falls, NYThe acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…May 16, 1987 · N6298A · Substantial damageNTSB MIA87LA159Accident · No injuriesLimited investigationFinal reportCessna 120 · Oklawaha, FLThe plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main…May 16, 1987 · N2106V · Substantial damageNTSB LAX87LA206Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Carefree, AZAt the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…May 16, 1987 · N9545H · Substantial damageNTSB FTW87LA120Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sargent, TXThe plt decided to takeoff twd the NE on a pvt road (which he referred to as 'shell rd . . . Beach'). He used 10 deg of flaps & applied full power before releasing the brakes. He stated that after becoming airborne about 2 to 5 ft, the acft 'shifted slightly…May 16, 1987 · N48735 · Substantial damageNTSB DEN87LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Sky, MTThe private plt was flying cross country in deteriorating weather conditions. Fog was forecast and light rain was in progress. The flt encountered less than VFR conditions in a mountainous area and reversed course. Weather was below VFR on the reverse course…May 16, 1987 · N1979C · Substantial damageNTSB CHI87LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Lansing, ILDuring an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also…May 16, 1987 · N97193 · DestroyedNTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.May 16, 1987 · N8331M · DestroyedNTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…May 16, 1987 · UNREG · DestroyedNTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…May 16, 1987 · N5747G · DestroyedNTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…May 16, 1987 · N704EA · Substantial damageNTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…May 16, 1987 · N7937Y · Substantial damageNTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…May 16, 1987 · N739QF · DestroyedNTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.May 16, 1987 · N4600W · Substantial damageNTSB ANC87FA070Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKThe pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop.May 16, 1987 · N66286 · Substantial damageNTSB CHI87LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNThe plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after…May 15, 1987 · N92140 · Substantial damageNTSB SEA87LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Orvado, NVDuring landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted.May 14, 1987 · N4848D · Substantial damageNTSB NYC87LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgartown, MAThe plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was…May 14, 1987 · N24806 · Substantial damageNTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…May 14, 1987 · N640CC · DestroyedNTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…May 14, 1987 · N704QH · Substantial damageNTSB DEN87LA127Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Limon, COThe plt reports that he was using a dirt road for aerial app operations. The acft was loaded with 40 gals fuel and 140 gals chem and the density alt is EST to have been 8100 ft. the plt said the takeoff was made to the e with a quartering tailwind of about 15…May 14, 1987 · N70164 · Substantial damageNTSB DEN87LA124Accident · No injuriesLimited investigationFinal reportBrantly Helicopter 305 · Golden, COThe commercial plt was performing hover tests in his experimental helicopter at his private helipad, located 60 feet from his residence. The plt reported winds as variable gusting to 40 knots. The plt's attention was diverted and a wind gust pushed the…May 14, 1987 · N5JM · Substantial damageNTSB CHI87DER06Accident · 1 fatalFinal reportBell 47G-2A · New Prague, MNAfter about a 5 min flight, the helicopter collided with the ground during a downwind turn on an agricultural turnaround. Impact was on a heading of 210 degrees. Wind was from 326 degrees at 14 KTS, gusts to 22 KTS. No evidence was found of powerplant, flight…May 14, 1987 · N6786D · DestroyedNTSB ANC87LA069Accident · No injuriesLimited investigationFinal reportFairchild C-119L · Shageluk, AKThe airplane was destabilized by a slight vertical air movement on approach. The pilot touched the airplane down short of the runway proper, collapsing the landing gear before sliding off the strip into adjacent tundra.May 14, 1987 · N8504X · Substantial damageNTSB SEA87LA092Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315-D Lama · Siletz, ORDuring external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the…May 13, 1987 · N47256 · DestroyedNTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…May 13, 1987 · N32774 · DestroyedNTSB LAX87WA217Accident · No injuriesForeign investigationCessna 150G · Castillejos, PhilippinesMay 13, 1987 · N3180X · Substantial damageNTSB CHI87LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIAccording to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to…May 13, 1987 · N5286P · Substantial damageNTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…May 12, 1987 · N50682 · Substantial damageNTSB LAX87DUM04Accident · Minor injuriesFinal reportTexas Helicopter M74L-WASP · Holtville, CADuring an aerial application flight, the pilot reported that the electrical system failed. Shortly after, the aircraft collided with power lines. Inspection of the aircraft revealed that the generator was inoperative. There were no other reported mechanical…May 12, 1987 · N1001Z · Substantial damageNTSB FTW87LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nowatta, OKDuring takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…May 12, 1987 · N9845C · Substantial damage