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 CHI87DEP09Accident · No injuriesFinal reportAyres 600S-2D · Bancroft, WIOn landing the aircraft veered to the right. Application of left brake and rudder did not arrest the turn. The aircraft impacted a fence post rendering substantial damage to the aircraft. Subsequent investigation revealed an axle spacer on the right wheel was…Jul 20, 1987 · N4436F · Substantial damageNTSB CHI87DEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Marne, MIAt the end of a swath run while about one-third of the way through the procedure turn around, the engine suddenly lost power. The pilot extended his glide to clear powerlines and when he flared to land he did not have enough airspeed to stop the descent. The…Jul 20, 1987 · N8972Y · Substantial damageNTSB ANC87LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKAfter several passes ovr the airstrip the plt set up to lnd on the 600 ft long dirt rwy located on a mtn ridge. He stated that on final he lost sight of the strip and elected not to land. The acft was unable to outclimb the rising terrain.Jul 20, 1987 · N9131D · Substantial damageNTSB ANC87LA102Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Kenai, AKThe pilot-in-command of the amphibious airplane applied inadequate technique during the takeoff attempt and compounded the problem by delaying aborting the takeoff. He changed his mind twice before flying/skidding into trees. The pilot stated that he should…Jul 20, 1987 · N1217L · Substantial damageNTSB MKC87LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Kansas City, MOAfter lndg, the PIC was clrd to taxi to the g/a ramp. He was not aware of the new g/a ramp & proceeded toward the old ramp. He saw a large acft coming from the opposite drctn on the same twy, so he modified his route by selecting another way. Mistakenly, he…Jul 19, 1987 · N6603H · Substantial damageNTSB MKC87DCA02Accident · Serious injuriesFinal reportRotorway Exec · Highridge, MOThe plt said the helicopter enctrd hi density altitude problems as it was moving out of ground effect drg takeoff. Subsequently, the helicopter settled into trees, then crashed to the ground in an inverted attitude. The temp & dew point were 90 & 77 deg,…Jul 19, 1987 · N275FS · Substantial damageNTSB FTW87LA172Accident · No injuriesLimited investigationFinal reportCessna 172K · Brenham, TXThe student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass.Jul 19, 1987 · N84861 · Substantial damageNTSB DEN87LA189Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Red Lodge, MTThe plt said he was getting ready to take off from a 9400-FT MSL landing zone a top a mountain 7 mi ssw of Red Lodge, MT. The plat said the helicopter was positioned on a slight north-south slope and pointed towards the west. The wind was from the south…Jul 19, 1987 · N48184 · Substantial damageNTSB BFO87LA052Accident · No injuriesLimited investigationFinal reportMooney M-20C · Basye, VAWhen the pilot applied brakes during the landing roll the acft swerved left. He applied the right brake to straighten the acft and the acft swerved right. The pilot attempted to correct with left brake and the right main gear collapsed. No malfunctions were…Jul 19, 1987 · N6769U · Substantial damageNTSB ATL87LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Foley, ALThe student plt failed to maintain directional control during a crosswind ldg on rwy 36. The airplane drifted to the left of the runway and subsequently impacted trees. The student plt was on his second unsupervised solo flight. He reported that he did not…Jul 19, 1987 · N4808T · Substantial damageNTSB ANC87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Lorraine Lake, AKThe pilot stated that he was flying a few feet above the trees when he flew into the water.Jul 19, 1987 · N5199P · Substantial damageNTSB ANC87FA101Accident · 1 fatalField investigationFinal reportCessna 185 · Hinchinbrook Is, AKAccording to witnesses the aircraft was low flying just above the tree level when the aircraft stalled and spun down into the trees.Jul 19, 1987 · N1744R · DestroyedNTSB SEA87FA141Accident · 4 fatalField investigationFinal reportBeech B200 · Crystal Bay, NVWhile on an instrument flight plan in IMC, the flight was cleared for an instrument approach to the south lake tahoe airport, the intended destination. The aircraft departed the initial approach fix on the published transition to the final approach course.…Jul 18, 1987 · N1870S · DestroyedNTSB MKC87LA141Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Bear Creek, MODuring a personal xc flt, plt experienced a partial loss of power followed by a total loss of power. During emergency ldg, pilot stated that he prematurely added full flaps, which resulted in too steep of a descent, causing acft to be short of intended…Jul 18, 1987 · N8326T · Substantial damageNTSB MIA87LA209Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Swiftown, MSWhile spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An…Jul 18, 1987 · N7310N · Substantial damageNTSB LAX87LA274Accident · No injuriesLimited investigationFinal reportCessna 182Q · Upper Lake, CAJul 18, 1987 · N97061 · Substantial damageNTSB LAX87LA272Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Perris, CAThe tow plt rprtd that drg takeoff, he felt the glider release at about 200' AGL. The purpose of the release was to practice a rope break. After being released, the glider maneuvered back toward the arpt, but it hit a tree & a power line before reaching the…Jul 18, 1987 · N125FD · Substantial damageNTSB LAX87LA271Accident · No injuriesLimited investigationFinal reportCessna 175 · Jackson, CAJust after takeoff the engine began missing then quit at an altitude of aprx 200 ft AGL. The plt attempted to return and land at the airport but was unable to reach the runway. Inspection of the engine revealed that the number 5 cylinderbarrel was cracked at…Jul 18, 1987 · N7499M · Substantial damageNTSB LAX87DVA08Accident · No injuriesFinal reportHastings Thorp T18 · Patterson, CAAt the end of a pleasure flight, the aircraft was landing with a 90 degree crosswind with a velocity of approximately 20 mph. During the landing roll, the aircraft ground looped, ran off the runway and nosed over. There were no reported mechanical failures or…Jul 18, 1987 · N50RH · Substantial damageNTSB DEN87LA187Accident · No injuriesLimited investigationFinal reportBeech 58 · Pagosa Springs, COThe plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing…Jul 18, 1987 · N1879L · Substantial damageNTSB DEN87FA188Accident · 1 fatalField investigationFinal reportCessna 210 · Coaldale, COThe ATP rated pilot was an airline captain on a Boeing 727 aircraft. However, the pilot had accumulated a total of only 140 hours in single engine aircraft with 20 hours in the Cessna 210. Moderate to severe turbulence had been forecast and reported in the…Jul 18, 1987 · N7444E · Substantial damageNTSB CHI87DER10Accident · 1 fatalFinal reportAir Tractor AT-301 · Hollandale, MNAfter making a swath run the aircraft pulled up to clear power lines. Witnesses state that the engine cut out and aircraft pitched nose down and began to rotate. They state that the engine regained power just prior to impact. Subsequent investigation failed…Jul 18, 1987 · N3652N · Substantial damageNTSB BFO87FA048Accident · No injuriesField investigationFinal reportAeronca 7AC · Saluda, VAWhile climbing thru aprx 400 to 500 ft after takeoff, the plt made a slight rgt turn which was flwd by a left bank. After moving the control stick for a left bank, it jammed to the left & was restricted in fore & aft movement. The plt applied full rgt rudder…Jul 18, 1987 · N1810E · Substantial damageNTSB ATL87LA217Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAPIC dpted, intending to fly 0.5 hours on tach. Acft had 11 gals of fuel, 5 in left tank & 6 in right tank. PIC made left climbing spiral to 9000 feet and maneuvered in left turn around airport. On a long staight in, final appch eng quit at about 500 feet AGL.…Jul 18, 1987 · N169DP · Substantial damageNTSB ATL87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Eubank, KYThe plt reptd that he was planning a refuel stop at short airport near Eubank, KY. Short is a private strip and the owner stated that he did not have fuel available. The pilot reptd that when he was about five minutes away, the engine 'quit and he was unable…Jul 18, 1987 · N1324T · Substantial damageNTSB ATL87LA215Accident · No injuriesLimited investigationFinal reportCessna 150K · New Carlisle, OHDuring a takeoff attempt, the student retarded the throttle shortly after liftoff. This flt was the student plts second flight and the first flight with this instructor. The student was instructed to follow along on the flight controls. This was the first…Jul 18, 1987 · N5669G · Substantial damageNTSB ANC87LA099Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKThe pilot stated that during takeoff on the river he lost directional control of the aircraft causing the aircraft to collide with a boat dock.Jul 18, 1987 · N1977U · Substantial damageNTSB SEA87LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ashland, ORPlt was proceeding VFR, no flt plan, no record of wx brief, northbound through siskiyou pass along I-5 from calif into Oregon about 1400 PDT. Plt reported suddenly in clouds, then saw trees. Acft collided with rising terrain 1/2 mile west of point where I-5…Jul 17, 1987 · N95407 · DestroyedNTSB SEA87LA140Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Deer Park, WADuring initial climb, at about 100 feet AGL, a loss of power occurred. The pilot made a shallow turn to avoid obstacles and landed in a plowed field. During landing roll the nose gear and right main gear collapsed, dragging the right wing. No reason could be…Jul 17, 1987 · N18933 · Substantial damageNTSB NYC87DNC08Accident · 1 fatalFinal reportCessna R172K · Cantebury, NHA local CFI heard the plt transmit over the UNICOM freq that he was 'north of the airport at 1100 ft & out of gas, so I guess I'm going to crash.' Attempts to contact the plt were unsuccessful. The CFI flew north of the airport & located the plane where it…Jul 17, 1987 · N4673K · DestroyedNTSB MKC87LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Forrest City, ARWhile doing a repositioning operation, with an ag acft, the engine quit, due to fuel exhaustion. The PIC said that a visual inspection of the fuel supply would have prevented the accident. He said that in an attempt to turn back to a dirt strip, the acft…Jul 17, 1987 · N7864 · Substantial damageNTSB MIA87LA210Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLWhile taxiing from landing in reduced visibility the instructor plt stated that he was unable to establish whether or not the acft was on a taxiway. He was then attempting to reverse direction when the rt wing collided with a fence.Jul 17, 1987 · N49817 · Substantial damageNTSB MIA87LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Rolling Fork, MSDuring the swath run, the plt stated that the eng 'barked' once or twice just prior to impact with the trees. The acft hit the trees, rolled inverted & burst into flames. He stated that the seat belt & shoulder harness saved his life. The plt stated that he…Jul 17, 1987 · N2321V · DestroyedNTSB DEN87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Grandforks, NDThe commercial plt was flying cross country on a personal flight. After takeoff during gear retraction, a loud noise was heard in the cockpit. Upon reaching the first destination, the plt attempted gear down but gear did not extend. Manual extension was…Jul 17, 1987 · N7722Y · Substantial damageNTSB DEN87FA186Accident · 2 fatalField investigationFinal reportMooney M20E · Vail, COThe pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain…Jul 17, 1987 · N71SB · DestroyedNTSB CHI87LA173Accident · No injuriesLimited investigationFinal reportBeech C23 · Monticello, ILThe acft ran off end of the rwy after the eng lost power drg a practice short fld takeoff. According to the instructor (CFI), there was insufficient rwy remaining to stop the acft drg the aborted takeoff. Maintenance psnl could not duplicate the eng prblm…Jul 17, 1987 · N6011T · Substantial damageNTSB CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…Jul 17, 1987 · N4649V · Substantial damageNTSB CHI87LA171Accident · No injuriesLimited investigationFinal reportBeech 23 · Danville, ILThe plt landed long and downwind on a sod farm strip. The acft ran off the departure end of the fld and struck trees.Jul 17, 1987 · N6562T · Substantial damageNTSB CHI87LA170Accident · No injuriesLimited investigationFinal reportCessna 182C · Clio, MIThe plt stated he departed with 55 gals of fuel. After 3.5 hrs of level flt at 7500 ft MSL he declared fuel exhaustion to the FAA flint twr. He was 3-4 miles frm a suitable arpt but was too low on final to reach the rwy. He landed on a road and struck a pole…Jul 17, 1987 · N8576T · Substantial damageNTSB BFO87LA060Accident · Minor injuriesLimited investigationFinal reportFleet 16B · Spencer, WVShortly after takeoff on runway 16, the engine began misfiring. The pilot turned back toward the airport to make a landing. He circled the airport and then attemped to land on runway 34. The pilot stated he was over the approach end ofrunway 34, turning left…Jul 17, 1987 · N47058 · Substantial damageNTSB NYC87LA243Accident · No injuriesLimited investigationFinal reportBeech C24R · Danbury, CTDuring a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured.Jul 16, 1987 · N1997L · Substantial damageNTSB NYC87LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Andover, NJThe pilot lost directional control during landing roll. As the aircraft drifted left of the runway, power was added for a go-around but the aircraft was left of the rwy. The left wing strut hit the wing of a Cessna 150 in an attempt to avoid colliding with…Jul 16, 1987 · N6346 · DestroyedNTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…Jul 16, 1987 · N4202M · Substantial damageNTSB NYC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dansville, NYAbout 5 min after taking off, the eng began running rough, then lost power & would not restart. Subsequently, the acft was damaged drg an emerg lndg in a potato field. The acft was moved before aviation inspectors arrived. No fuel was fnd in the fuel pumps,…Jul 16, 1987 · N7684J · Substantial damageNTSB NYC87DNC09Accident · No injuriesFinal reportDubois Beta Bird · Biddeford, METhe pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,…Jul 16, 1987 · N3954D · Substantial damageNTSB MIA87LA207Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1121 · Jackson, MSDuring the ground run at 80 KTS the cabin door unsafe light illuminated. The takeoff was aborted with heavy braking & deployment of the thrust reversers. The door was then opened & reclosed which extinguished the light, & a second takeoff was attempted. Aprx…Jul 16, 1987 · N133ME · Substantial damageNTSB LAX87LA269Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Buckeye, AZThe acdnt occurred as the plt was maneuvering to land on a pvt airstrip located on a ranch. He rprtd that while in a right turn toward the rwy, the acft stalled & fell to the ground. No preimpact mechanical failure or malfunction was evident.Jul 16, 1987 · N42507 · Substantial damageNTSB DEN87LA184Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Devils Lake, NDThe pvt plt, an A&P mechanic, was commuting home from the local airport in his aircraft. Upon landing, the main gear sank into soft soil and the acft nosed over.Jul 16, 1987 · N11024 · Substantial damageNTSB CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…Jul 16, 1987 · N4967B · Substantial damageNTSB ATL87LA219Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-36A · Winchester, TNThe pilot stated he circled over the airport to check for traffic then made a turn to base. He was too near the runway and too high for a normal approach. The pilot used full flaps and decreased power; however, the aircraft began to descend rapidly. The…Jul 16, 1987 · N702H · Substantial damage