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 NYC86LA061Accident · No injuriesLimited investigationFinal reportBell 47J2A · Atkinson, NHPilot stated he was attempting to position the Bell 47 helicopter on a small pad. This pad was too narrow to accommodate this acft and the right skid slipped off the platform. The pilot then requested his passenger to deplane. After the pilot determined that…Jan 13, 1986 · N888EN · DestroyedNTSB NYC86LA060Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJThe student and instructor (CFI) were performing touch-and-go landings. On the third touch-and-go, the student rotated the acft and initiated his climb. The CFI stated 'I realized the acft was not climbing and that the flaps were not retracted even though the…Jan 13, 1986 · N68214 · Substantial damageNTSB MKC86LA051Accident · No injuriesLimited investigationFinal reportBeech V35 · Bassett, NEWhile landing his acft at Bassett, Nebraska the plt rptd a gust of wind hit the acft fm behind and he lost directional control veering off into a snow bank. The plt stated that two witnesses who were walking near the rwy told him no wind was blowing when the…Jan 13, 1986 · N376B · Substantial damageNTSB MKC86LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Gove, KSAfter takeoff fm the private airstrip near Gove, Kansas, the aircraft was witnessed to descend towards the ground until impact. The witness to the accident, who is a plt and the owner of the airstrip, stated that after the acft clrd the airstrip environment…Jan 13, 1986 · N7381X · Substantial damageNTSB MIA86FA059Accident · 1 fatalField investigationFinal reportCessna 150M · Summerfield, FLThe private pilot departed the sod airfield and was observed to perform a steep rotation and intital climb. The winds were off the aircrafts left tail and were observed to be gusty. The aircraft was then observed to lose control and enter a spin to the left.…Jan 13, 1986 · N714AY · DestroyedNTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…Jan 13, 1986 · N53SA · Substantial damageNTSB FTW86FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Deville, LAThe student plt had previously flown this acft in flt training. However, the insurance for the acft had lapsed & the owner had secured the acft to a tie-down with a chain & pad lock to prevent it from being flown. After the chain was cut with a hack saw, the…Jan 13, 1986 · N5655U · DestroyedNTSB DEN86LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Fargo, NDThe acft contacted a snowbank following a loss of directional control during landing. This was the plt's first landing on his second solo flt. Previous to this landing, the student had been practicing landing on rwy 17 with his CFI.Jan 13, 1986 · N51238 · Substantial damageNTSB NYC86LA059Accident · No injuriesLimited investigationFinal reportCessna 152 · Bennington, VTAfter flying in the Bennington, Vermont area for awhile, the pilot decided to land for refueling. On landing the flight encountered strong gusty winds. The aircraft was pushed off to the side of the runway, before pilot could correct for the wind. The…Jan 12, 1986 · N49653 · Substantial damageNTSB MKC86LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Des Moines, IAN8036B diverted to Des Moines for fuel after encountering strong head winds enroute. After landing on rwy 30R the plt turned off the rwy onto a taxiway that runs to the north. The plt then stopped to change radio frequencies. While the acft was stopped a…Jan 12, 1986 · N8036B · Substantial damageNTSB MIA86LA058Accident · No injuriesLimited investigationFinal reportMooney M20F · Gainesville, FLThe plt stated that when he extended his landing gear all seemed normal except he did not get a green light, he recycled the gear with the same result & then flew by the tower & they stated that the gear appeared to be down, but upon touchdown after a ground…Jan 12, 1986 · N9326V · Substantial damageNTSB FTW86FQG05Accident · No injuriesFinal reportPiper PA-24-260 · Big Spring, TXThe aircraft collided with barriers marking a displaced threshold during an emergency landing immediately after departure. The pilot reported that the engine began running rough, then quit completely. The engine ran successfully following the accident. The…Jan 12, 1986 · N9183P · Substantial damageNTSB SEA86LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150-L · Gig Harbor, WAA total loss of power occurred due to fuel exhaustion while in an extended traffic pattern due to landing traffic. An inadvertent stall occurred prior to touchdown. The left wing struck a pile of dirt which spun the aircraft around. The landing was…Jan 11, 1986 · N6989G · DestroyedNTSB MKC86FPG01Accident · Serious injuriesFinal reportBeech F33A · West Memphis, ARThe acft crashed into the ground after striking trees during a forced lndg. The acft had experienced a loss of power during cruise after 4 and 1/2 hrs of flt. Post acc investigation showed that the rt main fuel tank was almost empty of fuel and the left main…Jan 11, 1986 · N20537 · Substantial damageNTSB LAX86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172N · San Jose, CAThe acft contacted trees and a building during a forced landing following a power loss while on final apch to land. Post accident inspection revealed a failure of the throttle cable housing at the swaged ball joint near the carburetor. This failure allowed…Jan 11, 1986 · N733ZF · Substantial damageNTSB LAX86LA086Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Buckeye, AZWhile on a personal flight to a privately owned airstrip, the acft collided with wires located at the west end of the airstrip while on final approach to runway 08. The pilot initially reported that he had misjudged the aircraft height and collided with the…Jan 11, 1986 · N95009 · Substantial damageNTSB FTW86FPA14Accident · No injuriesFinal reportPiper PA-32-300T · Saginaw, TXPilot long departed big spring, Texas with two passengers VFR to Saginaw airport, Saginaw, Texas. The pilot was flying to mwl, VOR 065 radial, descending to pattern altitude at Saginaw airport. The pilot said he had not been to that airport previously. Heavy…Jan 11, 1986 · N82072 · Substantial damageNTSB DEN86MA061Accident · 5 fatalMajor investigationFinal reportCessna 425 · Granby, CODrg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility…Jan 11, 1986 · N425SC · DestroyedNTSB DEN86FA060Accident · Serious injuriesField investigationFinal reportCessna 152 · Salt Lake City, UTAn instructor with his student plt were returning from a cross-country training flt. Three attempts were made to complete an ILS approach in heavy fog to the arpt. With each approach the instructor partially lost control of the acft and then recovered but on…Jan 11, 1986 · N757ZE · Substantial damageNTSB CHI86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Schaumburg, ILAccording to the pilot, the aircraft had been refueled the day before in buffalo new york. The aircraft was then flown to chicago,IL. The duration of the flight was four hours and thirty minutes. The following day, without refueling, the aircraft was flown to…Jan 11, 1986 · N8470H · Substantial damageNTSB CHI86LA062Accident · No injuriesLimited investigationFinal reportNavion A · Cincinnati, OHTen minutes after takeoff the plt heard a loud bang followed by a loss of eng pwr. The right main gear separated during the forced landing in a rough field. Examination disclosed the piston had separated from the wrist pin causing the #5 cylinder to separate…Jan 11, 1986 · N4000G · Substantial damageNTSB CHI86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mount Gilead, OHAccording to the arpt manager, the plt was taxiing down the active in gusty wind conditions at a fairly rapid rate of speed. As the plt turned into the run-up pad area the acft nosed over.Jan 11, 1986 · N3003Z · Substantial damageNTSB NYC86LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTThe purpose of instructional flight was to practice soft field landings and takeoffs, stall series and VOR naviagtion. After airwork, the pilot flew to robertson field for short and soft field landings and takeoffs. During final soft field takeoff, 10 degrees…Jan 10, 1986 · N6267Q · Substantial damageNTSB MKC86FA048Accident · 1 fatalField investigationFinal reportCessna 182A · Clinton, IAThe pilot normally made several touch and go landings before departing the local area. He was known to not fly near clouds or at night. For this flight, the ceiling was at least 1000 feet at takeoff and was at least 700 feet in the accident area. Airplane was…Jan 10, 1986 · N3948D · DestroyedNTSB MIA86MA057Accident · 2 fatalMajor investigationFinal reportPiper PA-31T · Jacksonville, FLWhile being vectored for an ILS rwy 7 apch, the plt was told to maint 3000' & advised he was flwg a Boeing 727. The min apch alt bfr intercepting the ILS glide slope (g/s) at the final apch fix/outer marker (om) was 1900'. As the acft was apchg the om, the…Jan 10, 1986 · N700CM · DestroyedNTSB LAX86LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Crown King, AZThe acft collided with a 5600 ft ridge line shortly after executing a go-around at a privately owned dirt, upward sloping airstrip. Ground witnesses reported the acft was on short final on rwy 05 when the plt applied full pwr. When the acft was at the…Jan 10, 1986 · N8535S · Substantial damageNTSB MKC86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lawrence, KSThe plt stated he mistook an ice and snow covered area for a taxiway and turned off past the actual taxiway. The acft struck a snowbank which collapsed the nosegear. The blue taxiway light was out. This light marks the edge of taxiway. The taxiway was free of…Jan 9, 1986 · N38127 · Substantial damageNTSB LAX86FA089Accident · 3 fatalField investigationFinal reportCessna 172N · Grand Canyon, AZThe acft deptd runway 03 at Grand Canyon airport, Grand Canyon, AZ on a moonless night. Shortly after departure the aircraft entered into a left turn. The aircraft collided into some trees in about a 45 deg nose down and about a 15 deg left wing down attitude…Jan 9, 1986 · N2113E · DestroyedNTSB LAX86FA085Accident · 1 fatalField investigationFinal reportBeech D-50 · Santa Rosa, CAThe plt, who was the mechanic for the acft & who possesses FAA inspection authorization, was familiar with this acft and had flown it the day before the accident. The plt failed to refuel the acft after making two additional flts. The main fuel tank gages…Jan 9, 1986 · N666GK · DestroyedNTSB FTW86LRD05Accident · Serious injuriesFinal reportBell BH206L-1 · Gulf Of Mexico, LAThe acft descended into the Gulf Of Mexico from a 100 ft AGL hover after the plt lost yaw control downwind of an offshore oil platform in 35 kt winds. As the acft came to a hover it began a turn to the right even though it was headed into the wind. Full left…Jan 9, 1986 · N2653 · Substantial damageNTSB ATL86IA054Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Memphis, TNThe aircrew rprtd that when the landing gear was retracted after takeoff, the l main gear indicated unsafe & there was an unsafe door indication. They recycled the gear, but observed the same indications. The gear handle was then put in the neutral psn & the…Jan 9, 1986 · N403DA · Minor damageNTSB LAX86LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Ukiah, CAThe acft's eng lost pwr during a normal descent during a night x-country flt and the acft crashed during the ensuing forced landing attempt. Fire department personnel reported that the right wing fuel tank was empty and the left wing fuel tank contained one…Jan 8, 1986 · N63660 · Substantial damageNTSB LAX86FA084Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Livermore, CAThe aircraft crashed shortly after takeoff about a mile from the departure airport. IFR conditions prevailed at the accident site; however, the non-instrument rated pilot had told his wife that the weather was clear when he telephoned her from the airport…Jan 8, 1986 · N8283T · DestroyedNTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…Jan 8, 1986 · N50255 · Substantial damageNTSB ATL86LA053Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Brewton, ALDuring low level controlled burning of a small timber forest the helicopter lost power. A forced landing was attempted in a field and the helicopter was substantially damaged. The aircraft owner related that the aircraft ran out of fuel.Jan 8, 1986 · N8866F · Substantial damageNTSB NYC86LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Boston, MAThe pilot was attempting to start the aircraft for a cross country flight. The weather was cold. Initially. The pilot stated the engine started but stopped. The pilot pulled key from ignition, pulled back throttle and closed the mixture before exiting the…Jan 7, 1986 · N1468X · No damageNTSB MKC86LA046Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, NEN30535 was making a night takeoff on a rwy covered by 3' deep snow. There were also drifts along the lt side of the rwy which were 8 to 10 inches deep. During the takeoff roll moisture blew onto the windshield and the acft drifted to the lt. the acft then…Jan 7, 1986 · N30535 · Substantial damageNTSB FTW86LPJ06Accident · No injuriesFinal reportAerospatiale SA319B · Tulsa, OKThe main rotor blades struck the tail boom after liftoff and vibration was violent. When the plt heard metal contact he pulled off the throttle and made an autorotation landing from about 4 ft AGL.Jan 7, 1986 · N67102 · Substantial damageNTSB FTW86FA033Accident · Minor injuriesField investigationFinal reportBell 206B · Port O'Connor, TXThe helicopter sustained a loss of tailrotor drive on lift off. A bonding in a shaft coupling failed. Extensive research and analysis discovered no discrepancies in design, production, quality assurance, maintenance or operating environment that could have…Jan 7, 1986 · N520EH · DestroyedNTSB ATL86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charlotte, NCPlt reported loss of power on the right eng at about 20 ft alt on takeoff. The acft veered right, the plt aborted the takeoff and touched down on the right side of rwy. The acft struck a mound of dirt and the ldg gear collapsed. The takeoff was initiated from…Jan 7, 1986 · N47KB · Substantial damageNTSB LAX86LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Peoria, AZThe acft landed short of the intended rwy and collided with a cement block wall surrounding a trailer park on the apch path to the rwy. The plt stated that the eng quit on the final apch to landing due to apparent fuel starvation. He reported that he checked…Jan 6, 1986 · N7049P · Substantial damageNTSB CHI86LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Anderson, INThe acft touched down hard on the nose gear during a x-wind landing. The plt reported the acft dropped to the rwy from an alt of aprx 10 ft AGL. Reported winds at the time of the accident were from 240 degs at 15 KTS gusting to 23 KTS.Jan 6, 1986 · N8521X · Substantial damageNTSB BFO86FA012Accident · No injuriesField investigationFinal reportCessna R182 · Leesburg, VAThe acft dptd dca with 4508,70GAL fuel,and 43LBS equipmt on board which computed out to be 26LBS over max gross. It was flown directly to Leesburg,VA where the winds were generally out of the west and there was the potential for windshear w/i 2000AGL. Both…Jan 6, 1986 · N6375T · Substantial damageNTSB SEA86LA036Accident · No injuriesLimited investigationFinal reportCessna 140 · Ione, ORThe pilot attempted to fly his newly purchased aircraft a distance of 3 miles from one local airstrip to another for the purpose of hangaring it. A ceiling of 500 feet overcast with 5 miles visibility fog and freezing rain were present. The windscreen iced up…Jan 5, 1986 · N1920V · Substantial damageNTSB SEA86FA035Accident · 2 fatalField investigationFinal reportPiper PA28-151 · Kelso, WAEnroute to dest. Plt diverted to nearby airfield due deteriorating weather. One hr later, telephone weather brief for continued flt to dest was VFR not recommended. Less than 2 hrs. Later, with no further brief, acft departed. A following acft revsd course…Jan 5, 1986 · N43552 · DestroyedNTSB MKC86LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Creve Ceour, MOAfter takeoff fm the arpt the plt stated the acft eng ran rough and he applied carb heat to help the engine run better after application of carb heat the engine quit. The plt made a forced landing back to the airport finally touching down on a taxiway between…Jan 5, 1986 · N4349J · Substantial damageNTSB FTW86LRA03Accident · No injuriesFinal reportCessna 172F · Saratoga, TXPilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were…Jan 5, 1986 · N8267U · DestroyedNTSB FTW86LA032Accident · 3 fatalLimited investigationFinal reportSikorsky S-76A · Grand Isle Bl73The acft rolled over in a high x-wind after landing while deplaning passengers. The acft had landed on a moving barge. A landing into the wind was blocked by a crane so the plt sideslipped from a flt path that paralleled the ships movement. The wind was…Jan 5, 1986 · N7612L · Substantial damageNTSB FTW86FA031Accident · 2 fatalField investigationFinal reportPiper PA-31P-350 · Norco, LAThe plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…Jan 5, 1986 · N9253Y · DestroyedNTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…Jan 5, 1986 · N6422Q · Substantial damage