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 NYC85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Spring Valley, NYThe plt decided to divert to the rampa valley arpt due to wx. He over flew the arpt 2 times, then made an apch to land, but the acft was high & fast, so he made a go-around. He stated that he made a normal landing on the next apch. However, he was unable to…Jul 16, 1985 · CFEYV · Substantial damageNTSB LAX85LA319Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down.Jul 16, 1985 · N6322B · Substantial damageNTSB FTW85LA288Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Crane, TXThe helicopter was being operated from a flat bed trailer. The plt stated he had lifted to a 3 foot hover when the eng stopped. The helicopter suddenly rotated about 45 degs before he could stop it. The plt attempted to make an autorotation touchdown but was…Jul 16, 1985 · N8197J · DestroyedNTSB CHI85LA293Accident · Serious injuriesLimited investigationFinal reportJohn H. MC Clain, JR. Rand KR2 · Mechanicstown, OHThe acft landed short of the rwy after a power loss. The plt said he was approaching to ladn at 1800 RPM when he added power to clear some power lines. The eng did not respond and the acft was flown under the wires where it collided with a tree during landing…Jul 16, 1985 · N717J · Substantial damageNTSB CHI85LA291Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 6B · Battle Creek, MIThe envelope of Balloon N1533S was penetrated and torn by the basket of Balloon i-frog. The envelope was damaged to the degree that altitude could not be sustained. The aeronqut of N1533S was seriously injured upon ground impact. I-frog was landed without…Jul 16, 1985 · N1533S · 2 aircraft · Substantial damageNTSB CHI85LA290Accident · No injuriesLimited investigationFinal reportHughes 269A · Oconomowoc, WIThe helicpoter contacted a corn crop and came to rest inverted during an aerial application flt. The plt stated, 3 passes were made over the fld being sprayed and after a turn to begin the 4th pass, the helicopter settled with pwr contacting the crop.Jul 16, 1985 · N8877F · Substantial damageNTSB CHI85FA292Accident · 1 fatalField investigationFinal reportCessna 170A · Olney, ILThe aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…Jul 16, 1985 · N1223D · Substantial damageNTSB ATL85LA214Accident · Minor injuriesLimited investigationFinal reportWag-Aero Cubbie (J-3) · Stockbridge, GADuring a departure, the eng had a partial loss of power. The plt reported that after climbing to about 75 ft, neither the acft's speed nor alt would increase. He lowered the nose to increase the eng RPM & speed, but the eng did not respond. Subsequently, the…Jul 16, 1985 · N909GH · Substantial damageNTSB ATL85FMG05Accident · 1 fatalFinal reportFain Evans VP-1 · Statesville, NCThe unregistered expired certificated newly purchased experimental acft was being flown by the student plt owner on his 1st flt in the acft. The acft was seen to takeoff and make a right turn after which it descended into tall trees. Witness reported hearing…Jul 16, 1985 · N74VP · DestroyedNTSB ATL85FA213Accident · No injuriesField investigationFinal reportBeech 99 · Louisville, KYWhile enroute to 8000 ft, both eng lost all power. The plts attempted return to the departure a/p was unsuccessful. He made an emerg ldg on the interstate highway. All landing gear was damaged. The fuel tanks were empty. There were conflicting fuel quantity…Jul 16, 1985 · N95WA · Substantial damageNTSB SEA85LA189Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Scappoose, ORDuring taxi from landing while in a turn, th epilot inadvert ently selected gear up. He owns a similar airplane and had borrowed this aircraft. His aircraft gear and flap contr ols are in the opposite position of this aircraft's. he intended to raise the…Jul 15, 1985 · N5891J · Substantial damageNTSB SEA85LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Pacatello, IDAfter landing the plt was instructed by the tower to expedite off the rwy and taxiway due to a jet following close behind. During taxi from the taxiway to the ramp, the plt was paying particular attention to his right wing tip to avoid parked acft. The acft…Jul 15, 1985 · N2396E · Substantial damageNTSB MKC85LA225Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Griffithville, ARThe plt reports that the acft fishtailed during the takeoff roll and ran off the side of the rwy. The acft was heading toward a canal and the plt elected to try to fly over the canal. The acft became airborne and flew about 1/4 mi. The plt saw trees ahead and…Jul 15, 1985 · N8561H · Substantial damageNTSB MKC85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Springfield, MODuring a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where…Jul 15, 1985 · N5424W · Substantial damageNTSB MKC85LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrison, ARAfter an en route stop, on a x-country flt, the student plt was taxiing to takeoff again. While proceeding northbound with a left x-wind, the plt applied braking action to slow the acft for a turn. At about that time, the acft veered to the right, went down…Jul 15, 1985 · N68777 · Substantial damageNTSB MIA85IA211Incident · No injuriesIncident investigationFinal reportCessna R182 · Jacksonville, FLThe plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing…Jul 15, 1985 · N6289T · Minor damageNTSB LAX85LA316Accident · No injuriesLimited investigationFinal reportMooney M-20-E · Los Banos, CAThe acft collided with a cement embankment during the landing roll after completing an emergency landing in an open field about 5 miles so. Of Los Banos arpt, Los Banos, CA. The plt reported that shortly after departing harris-argo west arpt (5CA7), the acft…Jul 15, 1985 · N6891U · Substantial damageNTSB FTW85FA287Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Saginaw, TXThe helicopter had landed in the road to pick up an injured auto accident patient. The plt made an aerial check prior to landing to the west in a calm wind condition. The patient was loaded in a secure stretcher and all was ready for liftoff. The plt stated…Jul 15, 1985 · N32GT · DestroyedNTSB DEN85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Thistle, UTThe plt had just completed an aerial spray mission and was flying through a canyon when the acft collided with pwr lines. Control of the acft was lost and it contacted the terrain.Jul 15, 1985 · N7614Z · Substantial damageNTSB DEN85FA189Accident · 1 fatalField investigationFinal reportCessna 320F · Rapid City, SDThe acft crashed during an attempted VFR go-around. The plt said he didn't recall touching down and he thought he was 'floating.' When the acft began drifting left of rwy centerline, the plt initiated a go-aroung. He said he applied full power and rotated. He…Jul 15, 1985 · N90HC · DestroyedNTSB ATL85FA216Accident · No injuriesField investigationFinal reportBell 206B · Anneville, KYThe pilot stated that the aircraft experienced hydraulic system failure followed by a loss of engine power. An emergency autorotation landing was attempted in a pasture and during the landing the aircraft was substantially damaged. Post crash examination…Jul 15, 1985 · N16646 · Substantial damageNTSB SEA85LA164Accident · No injuriesLimited investigationFinal reportCessna 172 · Idaho City, IDShortly after takeoff the pilot was unable to outclimb rising terrain. A tree was struck with the left wing tip. And shortly afterwards the aircraft mushed into trees. Density altitude at the time of takeoff computed to be about 6000 feet. The aircraft was…Jul 14, 1985 · N8655U · Substantial damageNTSB NYC85LA177Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Hartford, CTThe apch to the pvt helipad was uneventful up to the last 100 ft where the plts noticed a high sink rate. The plt increased collective to correct for the situation. At about 20 ft from touchdown point the plt noticed a decrease in RPM and realized that they…Jul 14, 1985 · N3124L · Substantial damageNTSB NYC85LA172Accident · No injuriesLimited investigationFinal reportBeech 36 · Calverton, NYThe pilot of N9031S was advised that nantucket memorial airport was in IFR conditions and decided to turn back towards long island. During the flight to long island, N9031S lost radio communications and soon electrical power to the navigational equipment. The…Jul 14, 1985 · N9031S · Substantial damageNTSB NYC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Provincetown, MADuring arrival, the acft was vectored for an ILS rwy 7 apch which was made with a tail wind. On his 1st attempt, the plt made a missed apch & was vectored for another ILS. After making a 2nd apch, he landed. The plt stated that while he was landing, he…Jul 14, 1985 · N8210H · Substantial damageNTSB NYC85FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Tioga, PAThe plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested…Jul 14, 1985 · N7934P · DestroyedNTSB MKC85LA165Accident · Minor injuriesLimited investigationFinal reportde Havilland DH 82A · Ames, IAThe owner had given the plt permission to fly the acft & the plt elected to take a passenger in the front seat. After the accident, the plt stated that he was making a hi speed taxi run on the grass on the right side of the rwy. He reported that the lower…Jul 14, 1985 · N657DH · Substantial damageNTSB MKC85LA155Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Salina, KSThe plt stated that he was receiving a multi-engine flight check from a designated flt examiner. They were still rolling after a landing when the examiner requested a go-around. The plt said that after advancing the throttles, he reached for the flap switch &…Jul 14, 1985 · N1522Z · Substantial damageNTSB MKC85LA154Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Camdenton, MON5593C took off on rwy 25 which has a hill off the west end. The wind was from the west at 10 to 13 knots and the temperature was 95 deg f. the plt said the acft encountered a downdraft as it approached the hill during the initial climb. The plt became…Jul 14, 1985 · N5593C · Substantial damageNTSB MIA85LA210Accident · No injuriesLimited investigationFinal reportCessna 177B · Cedar Key, FLThe plt reported that shortly after taking off, while flying at 1400 ft, there was a strong odor of fuel in the cabin, then the eng lost power. He was unable to restart the eng & subsequently ditched the acft in the gulf of Mexico about 1/4 mi south of Cedar…Jul 14, 1985 · N13714 · Substantial damageNTSB LAX85LVM04Accident · Serious injuriesFinal reportLarry Robbins Bakeng Duce · Gilroy, CAThe acft crashed after circling a ground fire at about 500 ft AGL. The plt said that she was watching the grnd fire when suddenly the acft dropped to the left. She added power and applied opposite rudder but the acft did not recover. She does not remember…Jul 14, 1985 · N3957D · Substantial damageNTSB LAX85LA317Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Piru, CAThe flight instructor instructed the 25-hour student plt to perform an autorotation with a pwr recovery at 20 ft AGL. The instructor became aware too late that the student was 'dead locked' on the controls and he was unable to recover prior to touchdown. A…Jul 14, 1985 · N85594 · Substantial damageNTSB FTW85LA285Accident · No injuriesLimited investigationFinal reportRyan ST3KR (PT-22) · Hondo, TXThe plt was on a x-country flt. Near the destination the eng experienced sudden seizure and all eng pwr was lost. The plt attempted an emergency landing but collided with a pwr line which resulted in substantial damage to the acft. The cause of the loss of…Jul 14, 1985 · N46170 · Substantial damageNTSB DEN85LA188Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Glen Canyon, UTThe plt said that during the takeoff roll at night from an unlit runway, he was distracted when the engine overboost light illuminated. The investigation revealed, however, that the plt was actually trying to avoid colliding with an airplane at the other end…Jul 14, 1985 · N8409V · Substantial damageNTSB CHI85LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Appleton, WIAs the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and…Jul 14, 1985 · N4137F · Substantial damageNTSB CHI85FA284Accident · 1 fatalField investigationFinal reportEipper MX Super · Almont, MIWitnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had…Jul 14, 1985 · N23MX · DestroyedNTSB ATL85LA212Accident · No injuriesLimited investigationFinal reportCessna 182C · Lugoff, SCThe plt transported a load of skydivers to alt & was returning to the airstrip. During arrival, he decided to practice a simulated eng out landing. While on an apch with full flaps, the plt elected to slip the acft. As he was transitioning from a side slip to…Jul 14, 1985 · N8472T · Substantial damageNTSB ATL85LA211Accident · No injuriesLimited investigationFinal reportCessna 172 M · Statesville, NCWhile en route, the plt encountered reduced visibility & had difficulty finding the airstrip. His 1st apch to land was high & he made a go-around. The plt landed on his 2nd attempt, but was unable to stop on the wet grass rwy. He delayed attempting a…Jul 14, 1985 · N12334 · Substantial damageNTSB SEA85LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · American Falls, IDThe student solo x-country flt departed ogden, UT, at aprx 1130 MDT and made a touch & go at black foot, ID, at aprx 135 MDT. The plt stated the landing was a little rough and due to the distraction, he forgot to switch fuel tanks. Fuel exhaustion occurred at…Jul 13, 1985 · N25678 · Substantial damageNTSB NYC85LA171Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Pittstown, NJThe approach to runway 08 was normal, however it was long. Although the approach was not too long to land, the student applied full power and decided to go around. The ins tructor took control of the aircraft after realizing that clearing the trees would be…Jul 13, 1985 · N44GF · DestroyedNTSB NYC85LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Chatham, MADuring the final approach to runway 24, the aircraft was too high and fast. The pilot decided to land on the runway instead of going around. According to the pilot, the aircraft landed too FAR down the runway and went over the end.Jul 13, 1985 · N5405F · Substantial damageNTSB MKC85LA157Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Earle, ARThe plt reports that the propeller ran away when the acft was at 75 ft AGL on final apch for landing at a pvt airstrip. The plt said he was to low to correct the propeller malfunction and was forced to land in a bean field adjacent to the strip. An FAA…Jul 13, 1985 · N1391M · Substantial damageNTSB LAX85LA318Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Paso Robles, CAThe Paso Robles (prb) flight service station air traffic control specialist reptd that the pilot radioed that the aircraft ran out of fuel abt 5 miles so of prb. Examination of the wreckage disclsed both wing fuel tanks contained less that 1 gallon of fuel in…Jul 13, 1985 · N8964L · DestroyedNTSB DEN85LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Kiowa, COThe acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at…Jul 13, 1985 · N3030Z · Substantial damageNTSB CHI85LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Iola, WIUpon takeoff at approximately 100 ft AGL the pilot experienced a partial power loss which necessitated a forced landing in a soft, wet potato field. The pilot had time to switch fuel tanks and magnetos prior to touchdown, but the power loss remained constant.…Jul 13, 1985 · N1487A · Substantial damageNTSB CHI85LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stoughton, WIUpon landing following a normal 70 knot final approach the aircraft initially touched down one-third of the way down the 2500 ft grass runway. A bounce carried the aircraft to a point halfway down the runway where the aircraft landed in a full stall. The…Jul 13, 1985 · N47677 · Substantial damageNTSB CHI85LA285Accident · Serious injuriesLimited investigationFinal reportCessna 182 · North Canton, OHThe preflight, engine runup and initial takeoff were uneventful. At approx 600 ft AGL the engine sputtered for two or three seconds then stopped. The pilot turned back toward the runway but was too low. He crash landed in a gravel quarry after clipping power…Jul 13, 1985 · N3920D · Substantial damageNTSB BFO85LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Middletown, DEFollowing takeoff, at about 350 feet AGL, the engine quit abruptly. The plt attempted to land in a field which was located about 15 degrees east of the acft's heading. While attempting to avoid pwr lines near the field, the right wing collided with the wires.…Jul 13, 1985 · N8577P · Substantial damageNTSB ATL85LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Franklin, NCWhile in cruise flt eng RPM decreased. Plt actions to recover RPM were unsuccessful and eng eventually quit. A forced landing was made to an empty fld. On roll out the acft hit a concealed ditch resulting in substantial damage. Later, exmination of the eng…Jul 13, 1985 · N779VM · Substantial damageNTSB ATL85LA215Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Owensboro, KYThe plt had a single eng land rating & was preparing for a multi-eng check ride. While practicing a touch-&-go landing, the acft bounced. The plt applied power, made a go-around & landed without further incident. However, during a post-flt exam, substantial…Jul 13, 1985 · N3001S · Substantial damage