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 LAX88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Corona, CAThe acft lost engine pwr during cruise and during the ensuing forced landing the acft collided with an object and was damaged. The post acc inspection revealed that the acft fuel tanks were empty and the fuel lines lacked fuel. No other malfunctions were…Nov 9, 1987 · N92783 · Substantial damageNTSB DEN88LA022Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe plt reported that she was making a touch and go. She said as she applied full power to takeoff the acft veered to the right. She was unable to realign the acft with the rwy and elected to continue the takeoff and 'pulled the acft off at a speed below…Nov 9, 1987 · N9209G · Substantial damageNTSB ATL88FA032Accident · No injuriesField investigationFinal reportBeech 95C-55 · Atlanta, GAAcft was being positioned to begin cargo revenue flt. As acft turned final and ldg gear handle was put in down position PIC noted dimming of all lights & communications were lost. PIC unaware gear were still retracted until prop tips contacted rwy. During…Nov 9, 1987 · N616G · Substantial damageNTSB NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.Nov 8, 1987 · N8128A · Substantial damageNTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…Nov 8, 1987 · N7277Y · Substantial damageNTSB MIA88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLWhile practicing short field landings, the student plt flared the acft prematurely resulting in a hard landing & substantial damage. The acft was then taxied to the ramp.Nov 8, 1987 · N269ER · Substantial damageNTSB LAX88LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · San Luis Obispo, CAA Robinson R22 landed hard while on a VFR business flight. The pilot reported that he landed hard during a downwind approach to a landing site. He examined the helicopter and noticed the aft landing gear cross tube was bent. He felt the helicopter was…Nov 8, 1987 · N123PL · Substantial damageNTSB FTW88IA025Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · El Paso, TXThe pilot stated that the nose baggage door was properly closed and locked before takeoff but it came open during the aircraft's initial climb at about 200 feet AGL. He made an immediate descent and landed on the remaining runway. He delayed the leveloff…Nov 8, 1987 · N83931 · Minor damageNTSB FTW88FA024Accident · Serious injuriesField investigationFinal reportCessna 140 · Bryan, TXThe student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch…Nov 8, 1987 · N72137 · DestroyedNTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…Nov 8, 1987 · N6501S · DestroyedNTSB ATL88LA050Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Union City, TNThe plt rprtd the acft started to veer off the rwy after a 'rough' lndg. He atmtd to steer the plane with the steering control, but it would not respond. Subsequently, the acft veered off the rwy. About 50' to the side of the rwy, the nose gear hit a hole &…Nov 8, 1987 · N3849H · Substantial damageNTSB NYC88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Groucester Twsp, NJThe student pilot was on a cross country training flight. He stated that the VOR was inoperative but he recognized the VOR by a road that passed near it. The pilot became disoriented and was not able to locate a checkpoint. He descended to 1500 feet, spotted…Nov 7, 1987 · N6385M · DestroyedNTSB DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…Nov 7, 1987 · N9447B · DestroyedNTSB DCA88RA002Incident · No injuriesForeign investigationMcdonnell Douglas DC-10-15 · Tijuana, MexicoNov 7, 1987 · N1003NNTSB CHI88LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Detroit, MIThe plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51…Nov 7, 1987 · N8253E · 2 aircraft · Substantial damageNTSB CHI88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Hudson, MIThe student pilot was on his first solo flight. Before turning onto final approach to land, he noticed another aircraft ahead, already on final approach. The student decided to s-turn for spacing, but while maneuvering, altitude was lost. Subsequently, he saw…Nov 7, 1987 · N46065 · Substantial damageNTSB ATL88LA030Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Newnan, GAThe tail rotor 90 degree gearbox mounting flange fractured during apch to land, while the helicopter was at about 75 ft AGL. The gearbox subsequently separated from the helicopter. The plt initiated an autorotation. The helicopter rolled over on ldg.…Nov 7, 1987 · N922TE · Substantial damageNTSB ATL88LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sebring, OHThe airplane landed hard short of the rwy, and sustained structural damage to the ldg gear and both wings. The plt reported that he had been distracted by another airplane that entered the traffic pattern ahead of him, and had inadvertently allowed the…Nov 7, 1987 · N667FL · Substantial damageNTSB NYC88LA035Accident · No injuriesLimited investigationFinal reportCessna U206F · New Bedford, MAThe Cessna U206F was taking off from a harbor. After becoming airborne it experienced a 40 knot airspeed loss. The plt stated that he was unable to maintain altitude and was forced to land on a beach. The acft flipped ovr after a pontoon caught a rock. A…Nov 6, 1987 · N8384Q · Substantial damageNTSB MIA88IA028Incident · No injuriesIncident investigationFinal reportBeech 99 · Gulfport, MSWhile on a part 135 scheduled domestic passenger flt during final apch, the nose landing gear failed to fully extend. The plt recycled the gear, but the gear failed to fully extend. He then attempted to lower the gear using the emergency method, again, with…Nov 6, 1987 · N6724D · Minor damageNTSB FTW88DRG03Accident · Minor injuriesFinal reportHerman Dragonfly · New Braunfels, TXThe experimental, home built, aircraft was on its maiden fliht. The pilot stated he intended to fly the pattern for a check-out of the aircraft. The pilot indicated that he hoped to gain altitude early to permit returning to the field in case of an engine…Nov 6, 1987 · N5303H · DestroyedNTSB CHI88LA018Accident · No injuriesLimited investigationFinal reportCessna 172P · Danville, ILDuring an emergency off airport landing, subsequent to a power failure, the aircraft experienced a nose over and suffered substantial damage. The pilot reported no injuries. Investigation after the accident revealed a valve sticking problem in the engine.…Nov 6, 1987 · N52263 · Substantial damageNTSB ATL88LA033Accident · No injuriesLimited investigationFinal reportCessna 172K · Cumming, GAThe student plt rptd that the airplane contacted the rwy and bounced twice during the ldg flare. Once he got the airplane on the rwy, he realized that the airspeed was 'too high' for the rwy remaining and attempted to ground loop the airplane to stop it. The…Nov 6, 1987 · N7140G · Substantial damageNTSB ATL88LA031Accident · No injuriesLimited investigationFinal reportCessna 401A · Mobile, ALThe plt related that he was climbing through 4,300 ft when he lost the left turbocharger. He then noted sparks and then fire from the engine. He shut off the fuel, waited for the fire to go out and feathered the propeller. The flt was continued to montgomery,…Nov 6, 1987 · N6250Q · Substantial damageNTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…Nov 5, 1987 · N4178Q · DestroyedNTSB NYC88LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Stamford, CTThe instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…Nov 5, 1987 · N9538L · Substantial damageNTSB MKC88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bonne Terre, MOThe plt rprtd the eng lost pwr fm fuel exhaustion as he was cruising at ngt on a x-country flt at 6500' MSL. He declaredan emerg with st louis apch & reqd vectors to the nearest arpt. The controller (ctlr) provided vectors to the Bonne Terre arpt which was…Nov 5, 1987 · N8303Y · Substantial damageNTSB MIA88LA036Accident · No injuriesLimited investigationFinal reportRaven S-66A · Naples, FLAfter liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then…Nov 5, 1987 · N4094G · Substantial damageNTSB CHI88LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · Sugar Grove, ILWhile descending for landing the aircraft experienced total power failure due to fuel exhaustion. An emergency landing was made on a road and on short final, the aircraft collided with power lines which ran along the south side of the road. According to the…Nov 5, 1987 · N5360U · Substantial damageNTSB ATL88LA028Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Beaufort, SCThe airplane engine lost pwr at cruise and the plt made a forced lng in a salt-water marsh. Investigation revealed that the plt was ferrying the acft to another arpt to have maintenance performed on the fuel selector valve, which was stuck in the aux tank…Nov 5, 1987 · N78169 · Substantial damageNTSB NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…Nov 4, 1987 · N53461 · Substantial damageNTSB NYC88DNE01Accident · 1 fatalFinal reportLamb Commander Elite · Meriden, CTThe pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers.Nov 4, 1987 · N501JL · Substantial damageNTSB MIA88LA027Accident · No injuriesLimited investigationFinal reportLearjet 35A · Clearwater, FLDuring taxi up to hangar under direction of lineman after arrival the flt experienced loss of hydraulic pressure and brakes. The plt could not activate the emergency brakes prior to rolling into the hangar and colliding with two acft prior to coming to rest.…Nov 4, 1987 · N900JE · Substantial damageNTSB MIA88LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Orlando, FLThe acft made a hard ldg during heavy rain & after being advised of wind shear. The crew stated that at one point, the acft was thrown into a 60 deg bank with airspeed fluctuations plus or minus 20 KTS about 400 to 600 ft AGL. The plt stated that at 100 to…Nov 4, 1987 · N888DJ · Substantial damageNTSB LAX88LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Willcox, AZThe plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.…Nov 4, 1987 · N8411S · Substantial damageNTSB FTW88FA023Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Fulton, TXAcft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…Nov 4, 1987 · N3666W · DestroyedNTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…Nov 4, 1987 · N49209 · Substantial damageNTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…Nov 4, 1987 · N8266U · DestroyedNTSB MIA88FA025Accident · Serious injuriesField investigationFinal reportTaylorcraft DC-65 · Davie, FLShortly after takeoff during the crosswind to downwind turn at an alt of aprx 50 ft, the acft stalled, spun to the left, & due to the low altitude the plt was unable to recover prior to impact in a left wing low nose down attitude. Postcrash examination of…Nov 3, 1987 · N53736 · Substantial damageNTSB LAX88FA032Accident · 2 fatalField investigationFinal reportRobinson R22A · Moraga, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area.Nov 3, 1987 · N8475A · DestroyedNTSB DEN88LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Monte Vista, COThe plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over.Nov 3, 1987 · N5483H · Substantial damageNTSB MKC88LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Sweet Springs, MODuring a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…Nov 2, 1987 · N46094 · Substantial damageNTSB CHI88LA013Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Leavenworth, INAccording to the pilot, the aircraft was taking off from a 'bumpy' grass private strip. The pilot stated he discussed aborted takeoff procedures with the pilot rated passenger who was sitting in the right seat and stated if the aircraft did not reach takeoff…Nov 2, 1987 · N28483 · Substantial damageNTSB NYC88LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Marlboro, MAThe pilot was attempting a landing at Marlboro airport. Upon touchdown brakes were applied. According to the pilot, the aircraft was not stopping but instead was sliding down the runway. The pilot turned the nosewheel to the left to slow the aircraft but…Nov 1, 1987 · N6439D · Substantial damageNTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…Nov 1, 1987 · N757PY · Substantial damageNTSB NYC88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Argyle, NYThe flight was returning to cheney farm field for landing when the pilot came in too high and fast. He added power, banked left and started a go around. At this time the engine backfired and started missing. During the emergency landing in a pasture the…Nov 1, 1987 · N5502Z · Substantial damageNTSB NYC88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erwinna, PAThe pilot was landing the aircraft on runway 25 at vansant airport. At about 100 feet down the runway, the aircraft veered to the left, off of the runway and slid down an embankment and came to rest after colliding with a tree.Nov 1, 1987 · N4302T · Substantial damageNTSB NYC88FA032Accident · 2 fatalField investigationFinal reportBeech F-33A · Forked River, NJThe pilot and passenger departed white plains, new york on a VFR flight to kill devil hills, north carolina. Search efforts were initiated when the aircraft failed to arrive at its destination. A witness in a hunting camp near the crashsite saw the aircraft…Nov 1, 1987 · N333JL · DestroyedNTSB NYC88DHA01Accident · 2 fatalFinal reportCouden Skybolt · Mansfield, NJWitnesses observed acft performing multiple aerobatic maneuvers. They said airplane was performing vertical maneuver or nearing top of loop when it entered an inverted flat spin. Rotation was stopped, but recovery incomplete when airplane crashed in a hay…Nov 1, 1987 · N341SB · DestroyedNTSB MIA88IA055Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Newark, NJAt 1710:53 EST, the LCL twr ctlr (lc) at the Newark intl arpt clrd Continental flt 321 (DC-9-82, N806NY) for takeoff on rwy 22L; 11 sec later, Continental flt 688 (Boeing 727, N577PE) rprtd 'left downwind for rwy 29.' Lc told flt 688 to 'maintain 1500 as you…Nov 1, 1987 · N806NY · 2 aircraft · No damage