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 LAX87LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Temple Bar, AZThe stall warning horn sounded during climbout following a touch-and-go landing. Rising terrain was reported beyond the end of the runway and the pilot was unable to continue to climb while maintaining a safe airspeed. The density altitude was approximately…NTSB FTW87DQG03Accident · Serious injuriesFinal reportSchweizer G-164-A · Seminole, TXDuring the flare for landing on a county road the aircraft collided with a pickup truck traveling in same direction as the aircraft. The driver of the pickup sustained serious injuries. The pilot was not injured. The pilot stated he did not see the pickup…NTSB DEN87LA227Accident · No injuriesLimited investigationFinal reportCessna 182Q · Albuquerque, NMThe instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake…NTSB DEN87DTE04Accident · No injuriesFinal reportCessna A188B · Stonington, COThe plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings…NTSB CHI87DEM12Accident · No injuriesFinal reportPitts S-1 · Charlevoix, MIDuring landing on a short sod strip with a cross wind the pilot lost control when excessive brakes were applied. The aircraft nosed over. The plt stated that after landing he applied the brakes and the acft assumed about a 45 degree nose down attitude and the…NTSB ATL87LA241Accident · No injuriesLimited investigationFinal reportCessna 172 · Baxley, GADuring a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at…NTSB ATL87FA240Accident · No injuriesField investigationFinal reportLockheed L-1011-385-1 · Atlanta, GAThe acft was being flown manually for an ILS apch to rwy 8L at Atlanta. The apch was allowed to become unstable at about the middle marker and the vertical speed was increased to about 1290 feet per minute about five seconds before touchdown. The ioe capt in…NTSB ANC87LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Montague Island, AKThe plt was making an apch for a soft/short field landing at a strip which paralleled the ocean shoreline on Montague Island. He stated that when he came in to land, he misjudged the height & position of bushes nr the apch end of the strip. Subsequently, the…NTSB FTW87DRD12Accident · Serious injuriesFinal reportPiper PA-22-150 · Mansfield, LAThe airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and…NTSB DEN87FA226Accident · 1 fatalField investigationFinal reportCessna 172RG · Cubero, NMThe plt rcvd a wx briefing prior to departure. VFR flt was not recommended by the briefer. N5247V departed at 2005 hrs and at 2200 hrs the plt radioed abq ARTCC that he was descending from 9000 ft to 7500 ft to avoid wx. ARTCC radar track was lost shortly…NTSB ATL87LA238Accident · No injuriesLimited investigationFinal reportCessna 172M · Marietta, GAThe student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,…NTSB ANC87LA133Accident · No injuriesLimited investigationFinal reportChampion 7GC · Central, AKThe pilot stated that he was attempting to land in gusty, crosswind conditions and lost control of the airplane. He said the accident could have been avoided by choosing a different airport with less crosswind, or by initiating a go-around when he first…NTSB ANC87LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Merrill Pass, AKThe aircraft engine failed in cruise flight. During the landing roll the airplane struck a ditch and nosed over. Examination of the aircraft and the statements from the pilot, revealed the aircraft ran out of fuel during the return trip to the airport.NTSB SEA87LA175Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tukwila, WAWhile attempting to land in a field and at about 3 feet AGL, the pilot attempted to secure the right cabin door. Due to the distraction the pilot allowed the rear skids to contact the ground and a hard landing resulted.NTSB SEA87LA174Accident · 1 fatalLimited investigationFinal reportLutz Flying Dutchman · Twin Falls, IDThe purpose of the flt was to check the acft after replacing a wooden prop with an all metal prop & to prepare for entry in the reno air races. Bfr entering the air races. The plt needed to demonstrate his ability to make a 'barrel roll' & to make 3 lndgs.…NTSB NYC87LA239Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Bingham, METhe plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the…NTSB NYC87LA238Accident · Serious injuriesLimited investigationFinal reportBoeing B-17G · Beaver Falls, PADrg an apch in gusty winds, the plt noted a rgt x-wind. He stated that after touchdown, the roll-out was stabilized for a short distance, then the rgt wing began to lift. He applied full aileron & rudder to maint control, but was unable to stop on the…NTSB NYC87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-28-161 · Nantucket, MAThe Piper PA-28-161 with a pilot and passenger onboard disappeared from the radar scope while being vectored to an ILS approach to rwy 24 at Nantucket, MA. The controller observed the aircraft in a southeasterly heading and asked the tower controller to…NTSB MIA87LA230Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Vega Baja, PRThe plt stated that he had descended from 4500 ft to get out of the clouds & at 1300 ft, the eng became rough. He stated the RPM dropped from 2300 to 1000. He also stated that he did not use carb heat prior to or during the descent. The plt stated that when…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB MIA87FA231Accident · Serious injuriesField investigationFinal reportCessna 182A · Pensacola, FLThe plt stated that just after liftoff he flew into a layer of haze and became disoriented, the aircraft stalled, crashed into a dirt mound, spun around and came to rest off the left side of the runway. The aircraft then exploded and was consumed by post…NTSB LAX87LA316Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Condord, CAAfter an annual inspection the acft was prepared for a test flight. The pilot loaded 3 passengers and began the run-up checks. During run-up the left engine ran rough. After the roughness cleared the pilot initiated the takeoff. As the acft accelerated down…NTSB LAX87LA312Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Tucson, AZThe plt reported that just after takeoff, the engine lost partial power & he was unable to land back at the airport. During an emergency landing, the aircraft collided with a utility line & pole. An exam of the engine revealed that a rocker arm on the #4…NTSB LAX87LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Long Beach, CAThe plt indicated that 10 min from his destination he became concerned that the fuel gauges read 'near zero.' The plt elected to divert to another aprt, which was closed. The plt maintained his alt in case of power loss. The plt stated, 'I also became glued…NTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…NTSB LAX87FA309Accident · 2 fatalField investigationFinal reportBeech C-55 · Salton City, CAInstructor pilot's inability to recover control of the aircraft after it entered a spin.NTSB LAX87DUM05Accident · 1 fatalFinal reportSawyer DF-9 · Ramona, CADuring the third test flt, the plt was to fly the acft to 6000 ft for slow flt and flutter testing at increasing speeds to 200 mph. The plt was then to complete a shallow descent to touch-down with an on final, over-the-fence speed not to exceed 75 mph.…NTSB FTW87FA206Accident · 3 fatalField investigationFinal reportCessna U206G · Lissie, TXThe Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16…NTSB CHI87LA196Accident · No injuriesLimited investigationFinal reportBeech A23 · Longville, MNThe student plt rprtd that as he rounded out to land, the acft nosed down & impacted nosewheel first. Subsequently, the nose gear collapsed & the acft skidded to a stop. After coming to rest, a fire erupted, which spread & subsequently destroyed the acft.NTSB CHI87FA195Accident · 3 fatalField investigationFinal reportCessna 172 · Baileyville, ILWhile performing a low level (300-400' above the ground) flight search for a remote controlled aircraft that had been lost during flight, the pilot lost control of the acft. A witness reported that the aircraft entered a 'tight left turn', and then the nose…NTSB BFO87LA058Accident · Minor injuriesLimited investigationFinal reportBeech D50C · Somerville, VAThe nose gear prematurely retracted and the props contacted the gravel runway during the takeoff initial climb. The plt attempted to continue the takeoff and the acft settled into trees off the departure end of the rwy. Post-accident inspection failed to…NTSB ATL87LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Lewisburg, KYStudent PIC flew solo x-country. About 30 minutes after dpting enroute stop engine quit. He rptd checking fuel prior to departure. Flt school policy was to refuel at enroute stop which was not done. Acft was landed in a field and hit a fence during landing…NTSB ATL87LA236Accident · No injuriesLimited investigationFinal reportCessna A185F · Mt Airy, NCAfter Cessna 185, N3462Y, entered the traffic pattern for rwy 18, the UNICOM operator warned the plt of another acft in the pattern. The other acft was a Mooney mite, N4129. The Cessna plt contd his apch, but didn't see the Mooney mite until after the Cessna…NTSB ANC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Little Delta, AKThe pilot stated that he was taking off downhill with a 10 knot tailwind. At that time the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft settled into brush and nosed over.NTSB NYC87DHJ02Accident · 2 fatalFinal reportReder KR-2 · Mattituck, NYWitnesses observed the experimental homebuilt acft in a steep nose down attitude descent with its prop rotating. No witnesses were located who saw the acft prior to the descent, however, pilots in the area reported that winds were turbulent and gusty. The…NTSB MKC87FA165Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Batesville, ARThe airplane was at maximum gross weight at takeoff. The field elevation was 613 feet and the density altitude was 3300 feet. There were two runways available. Runway 25 was 6002 feet long and had a slight headwind from the southwest. Runway 35 was 3320 feet…NTSB MIA87LA228Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6D · Panama City, FLThe plt stated that he was inbound to sandy creek airport when he heard a loud bang and lost power. On landing rollout in a field the aircraft hit some sod, flipped over & came to rest inverted. Post crash examination of the engine revealed an internal blower…NTSB LAX87LA313Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Buckeye, AZA Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned…NTSB DEN87DTI01Accident · No injuriesFinal reportCessna A188B · Basin, WYThe plt was taking off on a private, 2300 ft, dirt, ag strip with a load of chemicals. The arpt elev was 4185 ft & the rprtd temp was 74 deg. The plt said the wind was calm when he began his takeoff roll, but about 3/4 of the way down the rwy, the acft…NTSB CHI87NA194Incident · Minor injuriesFinal reportBoeing 767-231ER · Belleville, ILNTSB SEA87LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Burns, ORA loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil…NTSB SEA87LA172Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Grandview, WAAfter the completion of spray operations the pilot was attempting to place the helicopter onto a trailer. The pilot misjudged his position, over-corrected, and then lost control of the helicopter, striking the ground.NTSB MKC87LA166Accident · No injuriesLimited investigationFinal reportBeech B23 · Creston, IAThe PIC had planned his flt with departure originating in Iowa city, Iowa. Scattered thunderstorms were fcst and the PIC delayed his departure for abt 3 hrs. Aft assessing wx fm several sources the PIC dptd for Creston, Iowa around 9 pm LCL time. The flt…NTSB LAX87DUG07Accident · 2 fatalFinal reportQuickie Q-200 · Redlands, CADuring a demo flt the acft was observed on final approach when it collided with the terrain and was consumed by fire. There were no mechanical failures or malfunctions reported. The plt made a radio call as he turned to the base leg. There was no report of…NTSB DEN87DTK01Accident · 1 fatalFinal reportBushby Mustang II · Aberdeen, SDWitnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near…NTSB BFO87FA057Accident · 3 fatalField investigationFinal reportBell 206B · Washington, DCThe helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,…NTSB BFO87DHD08Accident · Minor injuriesFinal reportBede BD5B · Wilmington, DEThe pilot's failure to attain sufficient altitude to clear obstacles located off the departure end of the runway. His overconfidence in the homebuilt aircraft's performance was a contributing factor.NTSB SEA87LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kelso, WAThe plt stated that during touchdown a hard bounced landing occurred. He then elected to execute a go-around and inadvertantly entered into a departure stall. The acft struck the ground in a right wing down, nose low attitude.NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB MIA87LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Highland Beach, FLThe plt stated that they were at 1000 ft aprx 2 miles off shore en route to palm Beach international when the engine lost power & they ditched the acft in the ocean about 40 ft off the Beach. The salvage personnel stated that the left wing contained aprx 10…