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 FTW86FRG02Accident · Serious injuriesFinal reportBeech K35 · Austin, TXThe acft stalled & crashed during a go-around attempt. The plt/owner was flying the acft from the left seat with the mechainc, who had just completed an annual inspection on the acft, seated in the co-plts seat. The mechanic received serious injuries when the…Nov 1, 1985 · N3091C · Substantial damageNTSB FTW86FPJ02Accident · Serious injuriesFinal reportCessna 152 · Tahlequah, OKThe acft contacted static cables and descended to ground contact during an aerial search for a person. The plt had turned the acft into the sun when it contacted one of two static cables on a power transmission array aprx 159 ft AGL. The towers to which the…Nov 1, 1985 · N4969H · Substantial damageNTSB DEN86LA017Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Bismarck, NDShortly after takeoff, the plt of the Beech A36TC acft activated what he believed was the flap retraction lever, and the eng quit. The plt made a forced landing aprx 1000 ft from the rwy departure end. During the investigation, the eng was started and…Nov 1, 1985 · N3663K · Substantial damageNTSB DEN86LA016Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe plt stated he had just departed a site located on top of a mountain, which is approximately 12,200 ft MSL. The pilot said 30 seconds later, the helicopter lost partial power. Requiring him to make a force landing. The inspection of the turbocharger…Nov 1, 1985 · N400AH · Substantial damageNTSB ANC86FA007Accident · 2 fatalField investigationFinal reportCessna 208 · Bethel, AKA total loss of pwr was experienced on takeoff due to the fuel selectors being in the off position. The plt attempted to restart the eng during which time the acft entered a stall and collided with the terrain. According to passengers the plt did not use a…Nov 1, 1985 · N9241F · DestroyedNTSB MIA86LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Gulf Of MexicoAircraft disappeared from radar while operating in an area of level 3, 4, and 5 thunderstorms associated with tropical storm juan. A search by the u. s. coast guard resulted in no aircraft wreckage being found. The aircraft is missing and the pilot is…Oct 31, 1985 · N24MS · DestroyedNTSB MIA86LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Pahokee, FLThe plt stated the acft bounced four times on landing. During the fourth bounce the acft impacted the rwy hard causing the nose tire to blow out and the nose gear to bend.Oct 31, 1985 · N15BX · Substantial damageNTSB FTW86FPA04Accident · No injuriesFinal reportPiper PA-24-250 · Terrell, TXThe acft traveled through a barbed wire fence during a forced landing short of rwy 35 at Terrell arpt. When aprx 1 mile from the arpt, the eng quit. The plt was unable to move the fuel selector, however, by applying a full rich mixture and turning on the…Oct 31, 1985 · N6393P · Substantial damageNTSB FTW86FPA03Accident · Minor injuriesFinal reportPiper PA-28-235 · Yantis, TXThe acft contacted a tree and a large bale of hay during a forced landing following a loss of pwr. Post accident inspection disclosed 18 gallons of fuel remained in the left main tank and 3 gallons remained in the left wing tip tank. Both right wing fuel…Oct 31, 1985 · N9348W · DestroyedNTSB ATL86FA014Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Ocilla, GAThe pilot of the second company aircraft to arrive in the vicinity of the airport held while the first attempted an ndr approach. After the first aircraft made a missed approach the pilot of the second aircraft attempted the approach. The aircraft flew into…Oct 31, 1985 · N8401E · DestroyedNTSB SEA86FA020Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · N.Battle Moun., NVThe aircraft impacted the ground after attempting an aerobattic maneuver at about 300 feet AGL. Several witnesses observed the aircraft enter a loop or climbing roll and diveinto the ground. No evidence of failure or malfunction of the aircraft was found…Oct 30, 1985 · N5051C · DestroyedNTSB LAX86LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · San Andreas, CAThe acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country…Oct 30, 1985 · N22264 · Substantial damageNTSB CHI86LA021Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bangor, MIThe acft nosed over after landing on a grass landing strip. The pilot stated the tail came up and the aircraft flipped over on its back after left brake was applied. An examination of the landing gear and brakes revealed that the right brake was released but…Oct 30, 1985 · N8807Z · Substantial damageNTSB SEA86LA019Accident · No injuriesLimited investigationFinal reportCessna C206 · Funter Bay, AKThe left main gear did not retract and during water landing caused the aircraft to nose over. The link pin rod was found to be broken and the cylinder assembly main retract link and pin down latch were found to be bent.Oct 29, 1985 · N756FX · Substantial damageNTSB SEA86LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172 · North Bend, ORThe plt reported having difficulty finding the tie down ramp area at the unfamiliar arpt in dusk light conditions. The passenger exited the acft with a flashlight to locate a tie down spot and walked into the spinning prop. The plt stated the passenger was…Oct 29, 1985 · N8316B · No damageNTSB MKC86IA018Incident · No injuriesIncident investigationFinal reportSAAB-Fairchild SF340A · Lincoln, NEDuring landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on…Oct 29, 1985 · N342AM · No damageNTSB CHI86LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIThe plt experienced engine failure due to fuel starvation ten miles north of his destination. During the forced landing the prop and left wing were substantially damaged. The plt stated that when he ran out of fuel the right fuel guage read between 1/4 and…Oct 29, 1985 · N68741 · Substantial damageNTSB CHI86LA018Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Comstock Park, MIAccording to the pilot she received wind information from a flight service station, the noaa and ATIS approximately 1.5 hours prior to takeoff. All these sources predicted winds to be less than 7 knots. Winds were 'very light' during Balloon inflation. The…Oct 29, 1985 · N4056L · Substantial damageNTSB ANC86LAG05Accident · Minor injuriesFinal reportBeech BE77 · Hope, AKThe acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.Oct 29, 1985 · N6753X · Substantial damageNTSB MIA86LA021Accident · No injuriesLimited investigationFinal reportMooney M20C · Starke, FLThe plt stated that after takeoff while climbing through 15 ft AGL the eng sputtered and lost pwr momentarily. Full pwr was regained but the acft had lost altitude and could not climb to clear trees at the departure end of the rwy. The acft then veered left,…Oct 28, 1985 · N79386 · Substantial damageNTSB MIA86IA022Incident · No injuriesIncident investigationFinal reportCessna 402B · St. ThomasAfter landing the pilot made a 270 degree left turn to entera taxiway. After completion of the turn the left main landing gear began to wobble and then collapsed outwardinspection of the aircraft revealed that of six bolts which attach the left gear support…Oct 28, 1985 · N98685 · Minor damageNTSB LAX86LA029Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Gila Bend, AZAfter spraying a field and while enroute to the landing site, the acft engine backfired followed by a rapid loss of power. The plt negotiated an emergency landing on a private dirt road. During the landing roll-out, the aircraft left wing struck a tree…Oct 28, 1985 · N8487K · Substantial damageNTSB DEN86LA015Accident · No injuriesLimited investigationFinal reportCessna T210NII · Sterling, COThe plt indicated he had the arpt in site when the eng failed due to fuel exhaustion. The investigation revea led the eng tach showed a total lapsed time of 4.9 hrs flown on this one fuel load. The perfomance charts for this particular flt indicates a max flt…Oct 28, 1985 · N1728U · Substantial damageNTSB ATL86LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Meridian, MSThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended for a flight to chattanooga, TN. The pilot was unable to maintain VFR conditions and attempted a precision approach. While being…Oct 28, 1985 · N5959Q · Substantial damageNTSB ATL86LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Parkersburg, WVThe acft experienced a total loss of power due to fuel exhaustion while on a baseleg for landing. The pilot elected to land in a corn field approx 1.5 miles short of the runway because he did not think he could make it to the runway. The plt was returning…Oct 28, 1985 · N48987 · Substantial damageNTSB NYC86LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe plt stated a gust of wind was encountered when the acft was 5 ft from touchdown. The gust turned the acft 90 degs from the rwy heading. The plt applied pwr to avoid trees but was unsuccessful and a collision with the trees occurred. Winds were reportedly…Oct 27, 1985 · N2561P · DestroyedNTSB NYC86LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Bangor, METhe acft experienced and eng pwr loss on the return leg of a x-country solo instructional flt. Carb heat was applied and Bangor apch control was notified of the eng problem. The plts attempts to restart the eng failed and a landing was made in a fld where the…Oct 27, 1985 · N69127 · Substantial damageNTSB NYC86FA023Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NHDuring landing approach to runway 32, the aircraft started to porpoise over the runway. The aircraft continued in this manner until it neared the end of the runway. The aircraft then started a slow climbing right turn just clearing nearby trees. The…Oct 27, 1985 · N734PX · DestroyedNTSB MIA86LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Fort Walton Bch, FLThe acft collided with power lines & crashed to the ground during a forced landing necessitated by an eng failure. The x-country flt had been in the air for 4 hrs and 35 mins. The acft's fuel capacity is 40 gals & the plt stated that fuel consumption was aprx…Oct 27, 1985 · N5219F · Substantial damageNTSB LAX86LA028Accident · No injuriesLimited investigationFinal reportS. Piccolotto/Dave Morss Cassutt SH-1 · San Carlos, CAThe acft experienced a loss of power shortly after departing ry 30, San Carlos airport, San Carlos, CA. The plt reptd that after experiencing the loss of power, he pumped the throttle. This action caused the engine to regain some power but not enough to…Oct 27, 1985 · N4975M · Substantial damageNTSB LAX86LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fullerton, CADuring an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the…Oct 27, 1985 · N98954 · Substantial damageNTSB LAX86FA024Accident · 1 fatalField investigationFinal reportChampion 7ECA · Seal Beach, CABased upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…Oct 27, 1985 · N7547F · Substantial damageNTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…Oct 27, 1985 · N7840S · DestroyedNTSB ATL86MA011Accident · 2 fatalMajor investigationFinal reportBeech 58P · Forsyth, GAThe flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to…Oct 27, 1985 · N583AM · DestroyedNTSB ANC86LA006Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Anchorage, AKAircraft stalled and crashed into trees at takeoff end of private airstrip. Several witnesses reported seeing big pieces of crusted snow and ice flying off the aircraft during the takeoff run and climb. Takeoff was made up hill contrary to published…Oct 27, 1985 · N3339R · Substantial damageNTSB NYC86LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Freeport, PAThe stu plt departed with 10.5 gals of fuel for a 48 mile x-country flt. While en route the plt became lost. Aprx 10 minutes of fuel remained when the plt spotted a arpt. She attempted to land at the arpt. During the apch to the rwy she made a go around when…Oct 26, 1985 · N60563 · Substantial damageNTSB NYC86LA020Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Lee Center, NYThe acft experienced a loss of control during an apch to the plt's pvt airstrip. After a pleasure flt of one-half hour, with no reported problems the acft returned to the arpt. On about a one-half mile final, the acft entered a steep left turn at about a 60…Oct 26, 1985 · N4499H · Substantial damageNTSB MKC86FCA01Accident · 1 fatalFinal reportBede BD-5B · Cape Girardeau, MOThe owner/builder had hired the plt to test fly the acft on its initial flt. Shortly after takeoff, the plt transmitted that he had an eng problem. He was cleared for an immediate landing & entered a downwind for rwy 28. As he continued & was turning from a…Oct 26, 1985 · N548BD · DestroyedNTSB MIA86LA019Accident · No injuriesLimited investigationFinal reportBeech G35 · Destin, FLThe acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind.Oct 26, 1985 · N4275D · Substantial damageNTSB FTW86LPA01Accident · No injuriesFinal reportCessna 150M · Arlington, TXThe acft nosed over over in a fld during a forced landing. The plt reported that the cockpit began filling with smoke shortly after takeoff. Shortly thereafter the eng quit. The acft traveled aprx 700 ft during the landing roll before the nose gear dug into…Oct 26, 1985 · N704MA · Substantial damageNTSB FTW86IA020Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Dallas/Ft.Worth, TXNo. 3 eng developed an exhaust stack fire during the second attempted start following taxi out. The 1st start was aborted when crew became aware of a 15 minute delay before takeoff. During the 2nd start, excess fuel torched in the combustors and the exhaust…Oct 26, 1985 · N714DA · No damageNTSB CHI86LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Ashland, OHThe student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing…Oct 26, 1985 · N7447G · Substantial damageNTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.Oct 26, 1985 · N10769 · 2 aircraft · Substantial damageNTSB ANC86LAG04Accident · No injuriesFinal reportCessna 177 · Soldotna, AKThe plt stated that during the preflight inspection the right wing tank quick drain was frozen and the fuel strainer was not working correctly. After consulting with a mechanic, a takeoff was performed and the eng quit during initial climb. The acft contacted…Oct 26, 1985 · N300WC · Substantial damageNTSB NYC86LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Great Valley, NYAcft experienced windshear while landing at Great Valley, n.y. the plt attempted to make a go around, but was unsuccessful and landed in a corn field. The acft was substantially damaged, however, the private certificated plt was uninjured.Oct 25, 1985 · N5486D · Substantial damageNTSB NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…Oct 25, 1985 · N2565H · DestroyedNTSB MKC86LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weeping Water, NEThe pilot stated that he was going too fast when he touched down on the short runway and should have made a go around. The airplane went off the end of the runway, went down a slope and impacted a piloe of rocks.Oct 25, 1985 · N47734 · Substantial damageNTSB MKC86LA016Accident · No injuriesLimited investigationFinal reportBellanca 7AC · Ogallala, NEWhile practicing touch and go landings the plt rptd that during the landing roll the left brake locked. The plt applied opposite rudder, but the acft veered off the left side of the rwy until striking a ditch which collapsed the gear. Inspection of the gear…Oct 25, 1985 · N467AC · Substantial damageNTSB MKC86LA015Accident · Minor injuriesLimited investigationFinal reportMooney MK21 · Warren, ARAt cruise level flt the plt rptd a malfunctioning engine. The plt was cleared to descend to an airport in the vicinity. The precautionary landing was initiated due to an oil pressure decline. Approaching for the landing the plt rptd the engine completely quit…Oct 25, 1985 · N3399X · Substantial damageNTSB MKC86FA017Accident · Serious injuriesField investigationFinal reportSilvaggio Cassutt 111M · Plattsburg, MOThe acft was level, in cruise when the plt noticed high eng temperatures. He stated that he started a shallow climb and headed for the nearest arpt. En route to nearest arpt, smoke came into the cockpit and the plt heard a loud noise that was accompanied by…Oct 25, 1985 · N4AS · Substantial damage