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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA89LA013Accident · 4 fatalLimited investigationFinal reportCessna 210E · Wenatchee, WAThe acft crashed while the plt was on a x-country flt at dawn. Impact occurred on rising, rocky terrain in a box canyon area at an elev of about 6000 ft. no ground scars were evident, but the acft impacted on a rocky slide area. It came to rest in one area…NTSB LAX89LA017Accident · No injuriesLimited investigationFinal reportCessna 150F · Goodyear, AZThe plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg…NTSB LAX89DUM02Accident · Serious injuriesFinal reportPiper PA-36-285 · Brawley, CAAt the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued.NTSB DEN89FA017Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Garfield, CONTSB ATL89FA015Accident · 3 fatalField investigationFinal reportCessna 177A · La Follette, TNThe plt departed knoxville in VFR conds. There was an area of IFR wx to the north & northwest of knoxville. The wx was forecast to be marginal along his route of flt. The plt rprtd he wanted to depart knoxville on a heading of 360 deg & would be at 2500'. The…NTSB NYC89LA014Accident · Serious injuriesLimited investigationFinal reportLet L13 · Warren, VTPilot's improper supervision of flight, permitted the student to not maintain the proper airspeed and stall the glider and crash into the ground.NTSB MIA89IA012Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · St. ThomasThe rt wing was dragged while ldg in a crosswind on rwy 10. The crew stated the aprch was normal & the touchdown was smooth on the rt gear with 3 degrees to 5 degrees of rt bank. The capt stated that immed after touchdown, the lt wing came up suddenly and he…NTSB FTW89DPA02Accident · Minor injuriesFinal reportPilatus B4PC11 · Bridgeport, TXThe glider was being tow-launched by an automobile from the pilot's private ranch airstrip. When the glider was approximately 250 feet AGL, the tow rope separated and the pilot attempted to return to the airstrip. A downdraft made this impossible and the…NTSB DEN89LA018Accident · No injuriesLimited investigationFinal reportCessna U206 · Brush, COFollowing landing at an unattended airport, while back-taxiing, the eng failed. During restart the plt heard a loud 'pop' from the eng compartment followed by white smoke and flame. The plt and pax exited the acft and the plt went to a nearby phone to call…NTSB DEN89LA016Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe pilot was practicing touch-and-go landings in a 15 kt crosswind condition in an acft in which he had 8 hrs experience. During takeoff roll after the sixth landing the plt lost control and the acft departed the side of the rnwy.NTSB CHI89DEC01Accident · No injuriesFinal reportExperimental Barracuda · Ypsilanti, MIPilot's failure to maintain control of the aircraft during landing and inability to appropriately correct for the porpoise action of the aircraft.NTSB NYC89LA012Accident · Serious injuriesLimited investigationFinal reportCessna P210 · Collegeville, PAThe plt rprtd that as he was arriving to land, he entered left traffic & moved the fuel selector to the fullest tank. Shortly after moving the fuel selector, the eng lost power as though it was fuel starved. He said he operated the fuel boost pump & switched…NTSB NYC89FA013Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Wallingford, CTThe acft lost power and crashed in a tractor trailer parking lot, destroying the helicopter and causing serious injuries to the pilot and one passenger. The investigation revealed an improper fuel flow switch, which had no check valve protection installed on…NTSB MKC89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Marion, NEShortly after takeoff from a farm field, the acft's left wing dropped & the acft descended striking the terrain. Witnesses said that immediately after takeoff, the plt attempted to make a steep climbing, left turn. A post acdnt inspn revealed no preimpact…NTSB LAX89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAIn both his oral and written statements, the student pilot stated that during the landing roll he lost directional control of the airplane. The student attempted to make a go-around, but before becoming airborne the airplane veered to the left of the runway…NTSB LAX89LA015Accident · No injuriesLimited investigationFinal reportHoward GFA-15P · Vacaville, CADuring the landing roll the pilot lost control of the airplane. The airplane ground looped and the main gear collapsed. There were no mechanical problems reported prior to the accident and the weather was not a factor.NTSB LAX89FA014Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Sedona, AZTotal failure of the magneto's impulse coupling which resulted in a shearing of the crankshaft's idler gear teeth and the crankshaft dowel pin.NTSB LAX89DVM01Accident · No injuriesFinal reportContinental Copters OH13H · Castroville, CADuring aerial application by helicopter, engine power was lost. Plt maneuvered to avoid power lines during autorotation, resulting in hard lndg. Investigation revealed failure of accessory drive to magnetos.NTSB FTW89FA007Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Edinburg, TXAcft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…NTSB DEN89DTE01Accident · 1 fatalFinal reportHicks/Mervin RH-3 · Erie, CONTSB CHI89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fairview Hts., ILFuel exhaustion due inaccurate fuel consumption calculations.NTSB CHI89FA009Accident · 2 fatalField investigationFinal reportMooney M20J · Ludington, MIThe pilot in command failed to maintain proper altitude utilizing basic flight instruments while experiencing a loss of gyro instruments.NTSB BFO89LA002Accident · No injuriesLimited investigationFinal reportPitts S-1S · Ridgeway, VAThe pilot landed to the south on the private airstrip. In an attempt to make a left 180 deg turn to back taxi on the runway and avoid acft parked along the left side of the runway, the pilot steered his airplane to the right. While turning to the right, the…NTSB ANC89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Soldotna, AKDuring the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway.NTSB SEA89LA012Accident · Serious injuriesLimited investigationFinal reportLaycock Baby Great Lakes · Graham, WAEng lost pwr while in cruise on local flt. Plt attempted to return to field but contacted trees during emerg descent to forced lndg. Investigation revealed presence of water in fuel system. Fuel sediment bowl was automotive type with aviation drain installed.…NTSB MKC89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Cedar Rapids, IAWhile conducting a part 135 air taxi operation, the pilot said his engine began running rough about 7 miles from his destination apt. Emergency procedures were initiated and a call to the control tower declaring an emergency was made. Unable to reach the apt,…NTSB MIA89LA011Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tampa, FLThe plt stated the acft was topped with 30 gals of auto fuel prior to departing for the open house at mcdill afb. The flt to mcdill was normal. Before departure, about 1/2 inch of water was drained from the fuel system during preflt inspection. At about 300…NTSB MIA89LA010Accident · No injuriesLimited investigationFinal reportRaven S-60A · Tampa, FLDrg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He…NTSB LAX89LA019Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tehachapi, CADuring the landing touchdown, on runway 11, a gust of wind was encountered and the airplane became airborne. The pilot attempted to go around. During the go around attempt the pilot was not able to gain control of the airplane. Winds at the time of the…NTSB LAX89DUQ01Accident · 1 fatalFinal reportLewis Moni · Lancaster, CADuring a local flight, shortly after takeoff, the pilot reported engine trouble. The pilot was cleared to land at his discretion. The glider was observed to make a steep left descending turn subsequently colliding with the terrain. This was an experimental…NTSB LAX89DUM01Accident · 1 fatalFinal reportArlington Sisu 1A · Borrego Springs, CAWhile thermal soaring, the acft entered a steep spinning descent, three turns to the right followed by two turns to the left and ground impact in a near vertical attitude. No evidence was found of aircraft structural failure or control malfunction. The…NTSB FTW89LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Friendswood, TXThe student pilot descended from 1450 feet to 1000 feet and entered the traffic pattern. Just before turning base, he applied carburetor heat and ten seconds later the engine lost power and quit. Unsuitable terrain made the forced landing a hard landing. An…NTSB DEN89LA014Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Garfield, CON31135 was being ferried to japan from wichita with an enroute stop in oakland, CA. The acft was equipped with cabin mounted ferry tanks. The plt stated that he switched from the acft fuel tanks to the ferry tank and about 20 minutes later the right eng quit.…NTSB ATL89DLT02Accident · No injuriesFinal reportSchweizer SGU-2-22E · Benton, TNAs the student pilot was attempting a dual aerial tow flight at 100 feet AGL, he experienced difficulty in staying behind the tow plane. The instructor took over the controls and while applying full right aileron noted no aileron movement. At 300 feet AGL the…NTSB MIA89WA009Accident · 1 fatalForeign investigationPiper PA-23-250 · Missing, BahamasNTSB DEN89LA015Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Edgewood, NMThe acft had just been overhauled & a new prop (hartzell model 7636D-4) had been installed in place of the old prop. The plt rprtd that after takeoff, the acft failed to climb, although he was using full power. He said he headed for lower terrain & circled…NTSB CHI89LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Alexandria, MNPoor judgement of the plt by flying while physically impaired from consumption of alcohol, his improper inflight planning/decision, and fuel exhaustion from his inadequate supply of fuel. The light conditions at night and uneven terrain (highway median) were…NTSB ATL89FA013Accident · 1 fatalField investigationFinal reportCessna 182E · Brooklet, GAWitnesses reported the plt began a low altitude, high speed pass over the rwy as he had done on several previous occasions. However, as he initiated the pass, the descent to the rwy was not arrested & the airplane 'pancaked' near the threshold. The airplane…NTSB ATL89DLT01Accident · 1 fatalFinal reportCameron AIR Command · Hixson, TNWitnesses observed the gyrocopter oscillating in the pitch axis as it passed overhead in cruise flight. A 'white or shiny' object departed the gyrocopter. The aircraft then rolled right, descended and collided with the trees and ground, inverted. One…NTSB SEA89TL006Accident · Minor injuriesClass 3Final reportBell 47G-3B2 · Cottonwood Canyon, NVOn a flight to monitor animal health of horses, the pilot was attempting to land to a suitable landing site. During final approach on the third attempt, the airspeed was about 5 mph and altitude about 15 feet AGL, when the helicopter started turning to the…NTSB MKC89DPG01Accident · 1 fatalFinal reportCulver LFA · Dumas, ARA witness stated that the airplane backfired while in a turn at low altitude. He heard it backfire twice more and noticed engine running at idle just before it crashed. When runup, the engine would attain 1900 RPM, then backfire and the RPM would drop to 600…NTSB ANC89FA009Accident · 2 fatalField investigationFinal reportPiper PA-12 · Little Heart Lk, AKThe pilot-in-command called a local pilot in the talkeetna area for weather and the conditions of the lake to determine if the lake's surface had frozen. He then departed for the lake at 1800 adt and was not heard from again. The airplane wreckage was located…NTSB SEA89FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Sun Valley, IDThe pilot flew into a box canyon at a low altitude above the ground near 9000 ft MSL. While attempting to climb over a ridgeline, the aircraft stalled, entered a spin, and descended nose down until impact with the ground.NTSB NYC89DHM03Accident · 1 fatalFinal reportVangorden KR-2 · Allaire, NJThe homebuilt aircraft was being flown on its maiden flight when the accident occurred. A witness stated that he observed the aircraft 'swirling down like a bird with a broken wing.' According to him, the aircraft was intact with no evidence of smoke before…NTSB LAX89FA013Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Santa Maria, CAThe pilot failed to follow the correct I.f.r. procedures whereas he descended below the final approach fix altitude.NTSB LAX89DVA01Accident · Serious injuriesFinal reportAyres S2R · Traver, CAWhile spraying a cotton field the engine lost power. The pilot executed a forced landing in an open area but rollout continued into crops. The acft nosed over. Investigation revealed only unuseable fuel on board.NTSB CHI89LA008Accident · Minor injuriesLimited investigationFinal reportCessna 120 · St Peter, MNThe plt had intended to make a touch-&-go landing on a grass strip, but stated that he came in 'somewhat high.' He rprtd the acft was still airborne about halfway down the rwy when he elected to go around. He attempted to add power, but the eng 'sputtered &…NTSB ATL89MA012Incident · No injuriesMajor investigationFinal reportAerospatiale ATR-42-300 · Yardley, PABfr tkof, corrected flt plan was put in ATC computer for airforce 1 (AF1) to take nonstandard rte to newark. After tkof,AF1 was vctrd nw with handoff to NY ARTCC (zny), then east via Yardley (ard) to newark; 15 mi west of ard, zny initiatedhandoff to NY…NTSB ANC89LA008Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Bonanza Hills, AKThe commercial pilot was attempting to land on a private gravel airstrip in rural Alaska. During the landing roll, the left main landing gear encountered snow along the runway edge and veered sharply to the left and off the runway.NTSB NYC89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lancaster, PAThe pilot of the Cessna 172 was returning solo from atlantic city when the aircraft ran out of fuel. He landed in a corn field and the aircraft flipped over. Examination of the wreckage revealed no fuel in the aircraft. The plt said he fueled the acft with 20…