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 NYC86LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Middletown, CTThe student pilot was on the third leg of an approved three leg cross country solo flight. He was instructed to refuel at the second stop. However, he made a decision not to refuel since the fuel tanks indicated about 1/2 full. The aircraft ran out of fuel…NTSB NYC86LA144Accident · Minor injuriesLimited investigationFinal reportBeech A-23 · Charlotte, VTPilot stated that on takeoff roll it seemed longer than usual and about 1500 to 1600 feet of the runway before the aircraft began to rotate. The aircraft had climbed about 15 to 20 feet before coming to the end of the runway and over water. At about 30 feet…NTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage.NTSB NYC86LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Oxford, CTDuring an attempted go around, the aircraft stalled. The aircraft then veered left and collided with the ground. The aircraft came to rest about 100 feet off to the side of the runway on the grassy area.NTSB NYC86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Syracuse, NYDuring descent about six miles from Syracuse hancock airport, the flight experienced engine vibration. Engine lost power and restarted. However when flight was at 3500 feet, power was lost again. Pilot set up for best glide and crashed in a grassy field. Full…NTSB MKC86LA124Accident · No injuriesLimited investigationFinal reportCessna A188 · Blaine, KSThe plt stated that a calf, weighing aprx 500 lbs, ran in fnt of the acft, just as it was apchg lift-off. Subsequently, the acft went out of control & skidded, collapsing the main landing gear. Until just prior to impact, the calf was hidden from the plt's…NTSB FTW86MA097Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Bartlett, TXAbout 6 min after takeoff, at 2138:31 CDT, the plt rprtd level at 9000 ft MSL. At 2140:17, he transmitted that he had trouble & said he could not control or disconnect the autopilot (a/p) which was causing the acft to descend. At 2141:14,he stated he was…NTSB FTW86LA102Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Winnie, TXThe pilot experienced partial loss of power during takeoff when the #3 cylinder quit firing. The aircraft then settled back down onto the grass strip and collided with a levy. At this point the pilot lost control of the aircraft, which went through some…NTSB FTW86FA098Accident · 3 fatalField investigationFinal reportCessna T210N · Sperry, OKThe airplane departed jones (riverside) airport and climbed, on course, to its assigned altitude. It was in IMC conditions and a IFR flight plan had been filed. The pilot told ATC (after being asked) that his ride was 'smooth so far'. Shortly thereafter the…NTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…NTSB ATL86LA158Accident · No injuriesLimited investigationFinal reportCessna T188 · Tyler, ALDuring a takeoff from a field strip the plt experienced a complete eng failure. The plt made a forced landing in a pecan orchard which resulted in airframe damage. Powerplant exam disclosed that the eng drive fuel pump had failed.NTSB MIA86LA171Accident · No injuriesLimited investigationFinal reportAir AT301 · Darling, MSThe plt stated that during an aerial application swath run he attempted to go around a telephone wire. The acft stalled, hit the ground and was destroyed by post crash fire.NTSB FTW86LRG23Accident · No injuriesFinal reportNorth American Rockwell S2-R · Mercedes, TXThe acft experienced a complete loss of eng power at an alt of 200 ft AGL shortly after takeoff. The plt was forced to land against the rows in a muddy cotton field. Shortly after touchdown, the acft flipped over. The exact nature of the eng failure was not…NTSB FTW86LA099Accident · No injuriesLimited investigationFinal reportCessna 150K · Eagle Pass, TXThe pilot failed to take appropriate steps to prevent water from entering the magnetos while washing the aircraft. As a result the water caused the magnetos to cut out and in turn caused the engine failure.NTSB ATL86FA156Accident · 3 fatalField investigationFinal reportMBB BO-105C · Peterson, ALThe EMS helicopter was heard and observed as it flew at low altitude down the river. A witness saw it dip down then attempt to climb just prior to the collision with power lines across the river. The helicopter broke the wires but was stopped and came apart…NTSB ATL86FA155Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Elizabethtown, KYAcft observed in level flt in IMC just below EST 500 foot ovc. EST viz about 3/4 mi. Lt wing struck 15/16 inch dia steel guy cable 534 feet AGL shearing outer 118 in. Acft impacted earth fill dam 1169 ft from 650 feet tall tv antenna. Tower. Top of tower…NTSB SEA86LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G21A · Hobart Bay, AKThe pilot neglected to raise the landing gear after departing the airport. While landing onto water with the gear still down, the aircraft's nose broke off and the aircraft nosed over inverted and then sank.NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…NTSB DEN86LA148Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Frederick, COAccording to the plt, he had descended from 8,200 ft AGL to 700 ft AGL in preparation for landing. The plt stated that when he started to add power, he noticed the engine had quit and a forced landing was made. During the investigation, the plt did not…NTSB CHI86LA148Accident · No injuriesLimited investigationFinal reportCessna 182K · Durand, WIAccording to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge…NTSB CHI86FEM08Accident · Serious injuriesFinal reportBeech B35 · Paw Paw, MIOn takeoff at approx 100' the engine began to falter. The pilot did a 180 deg turn and landed about 1/2 way down the runway. After bouncing twice and seeing that he would probably run off the end, he performed a go-around. At a point near the end of the…NTSB CHI86FEM06Accident · No injuriesFinal reportCessna 170 · Houghton Lake, MIThis student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over.NTSB ATL86LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, NCFifty two hr pvt plt flying over lake in mountainous terrain started climb out toward destination. Elevation of lake about 3000 ft. ambient temp about 90 f. plt could not climb a/c at an angle to clear rising terrain. Flew a/c into trees.NTSB ATL86LA152Accident · No injuriesLimited investigationFinal reportForney F-1 · Abbeville, SCThe student plt reported that the acft's brake system was inoperative during ldg rollout. The acft ran off the end of the rwy end into a trash pile and collided with pine logs.NTSB SEA86FA137Accident · 1 fatalField investigationFinal reportBell UH-1L · Wenatchee, WAN4964N, a Bell UH-1L, was being operated in logging ops by an experienced, military trained plt who possessed 6000 hrs of flt experience in model. While lifting a sling load gnd crew rptd smoke from the tail rotor area. Plt released sling load & acknowledged…NTSB MKC86LA121Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground…NTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…NTSB LAX86LA239Accident · No injuriesLimited investigationFinal reportCessna 150 · Gasquet, CAThe pilot stated that, as he entered the traffic pattern, the windsock for runway 24 indicated about five knots of wind straight down the runway. He further stated that, as he was about to touch down, a sudden cross wind caused the aircraft to 'nose to the…NTSB LAX86LA237Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Goodyear, AZThe student pilot was on her first supervised solo on runway 03 at Goodyear airport, Goodyear, AZ. Her instructor advised her to make three touch & go takeoff's and landings. The instructor positioned herself near the landing area and advised the student…NTSB FTW86LA095Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Orange Grove, LADuring a part 135 check ride, the check plt had the plt execute a pwr off landing from an alt of 150 ft AGL. The plt reacted to the pwr loss by attempting a left turn to land. The acft then stalled and impacted the ground after the failure maintain airspeed.NTSB FTW86FA096Accident · 1 fatalField investigationFinal reportMeyers 200B · Krum, TXThe retired airline captain was returning to a retirement party for another airline captain. He began a barrel roll from a relatively low pass over the party, but collided with the ground on pull out. Alcohol was not a factor.NTSB DEN86FA147Accident · 1 fatalField investigationFinal reportPiper PA-20-160 · Buena Vista, COWhen the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right…NTSB DEN86FA146Accident · 1 fatalField investigationFinal reportBauer'S Mitchell Wing U-2 · Cheyenne, WYThis was an experimental amateur-built acft. Witnesses reported seeing the acft in a steep right bank when the eng lost power. The acft was then seen to stall and enter a right spin. Witnesses said the plt recovered but entered a second stall and dove…NTSB CHI86FET01Accident · Serious injuriesFinal reportPiper PA-20 · Rolling Prairie, INDuring a go-around from an aborted landing the acft struck unmarked power lines at the departure end of the landing rwy. The acft collided with terrain during the resulting uncontrolled descent. The rwy being used was a 2400 ft long and 50 ft wide sod private…NTSB BFO86FID05Accident · No injuriesFinal reportMaule M-4-210C · Saluda, VAWhile on final apch, the acft struck the top side of a van which was on a road off the apch end of the rwy. Both main landing gear were sheared off and the plt landed the acft in a grass area along the side of the rwy. The plt reported that a high sink rate…NTSB ATL86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Warren, OHDuring a normal takeoff, the pilot decided to abort the takeoff after he determined that the aircraft was not accelerating as fast as he thought it should. After the aircraft touched down on the sod surface, the pilot proceeded toapply full braking. Since the…NTSB ATL86LA151Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Magnolia, KYThe plt was using the acft to drop a tool to a mechanic friend and was flying at low alt toward rising terrain to verify the location where the tool fell. Witnesses said that when the plt exited the acft after the accident he stated he was too low, too slow,…NTSB ATL86LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GADuring a normal landing, the plt lost directional control of the acft which subsequently collided with a parked C-172. The plt reported that the right tire was inflated during the preflt inspection. Following the accident the tire was found deflated. The plt…NTSB ATL86LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring a landing attempt at a private grass airstrip, the acft bounced several times and the student plt initiated a go-around before the plt instructor was prepared. The acft cleared departure threshold powerlines in a nose high attitude at low airspeed and…NTSB ATL86FEK02Accident · Serious injuriesFinal reportGreen Pietenpol · Mt. Vernon, OHThe acft stalled and entered a spin to ground impact during the initial takeoff climb. The plt reported that during the takeoff and climb the airspeed indicator did not exceed 40 mph. He also stated the acft did not appear to be traveling very fast. He then…NTSB ATL86FEI06Accident · 1 fatalFinal reportBernard Darmstadt Daphne/Sdia · Akron, OHThe acft was observed spiraling to the left from 500 ft AGL after takeoff. The spiral continued until the acft collided with a commercial bldg. Based on the autopsy report the plt died of natural causes declared to be cardiovascular collapse. The acft…NTSB MIA86LA170Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, FLThe plt stated that the landing gear indicator light showed the gear to be down & locked. When the acft touched down the landing gear collasped and the acft slid to a stop. Post crash examination of the landing gear showed it to operate normally in all modes.…NTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…NTSB CHI86LA147Accident · No injuriesLimited investigationFinal reportCessna 195 · Port Huron, MIThe flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed…NTSB CHI86FA146Accident · 3 fatalField investigationFinal reportBellanca 7GCBC · E. Grand Forks, MNWitnesses rprtd the acft had just left the restricted lndg area (rla) when it entered a climbing maneuver, then dscndd &impacted the gnd & burned. Two witnesses said it went straight up, then straight down, before it crashed. Another 2 wit-nesses noted a pwr…NTSB BFO86IA031Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Calverton, NYN1031T a DC-9-31, was in a descent for landing at jamaica, NY. The captain reported he heard a noise that he thought was a failing cabin door pressure seal and advised the copilot. The copilot indicated he thought the noise was the soundof a jet eng. Between…NTSB BFO86FA029Accident · Minor injuriesField investigationFinal reportCessna 150L · Upper Marlboro, MDThe acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air…NTSB ATL86FA148Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Stone Mountain, GAWhile on a bfr flt, the owner/plt was considered to be the plt-in-command. Drg departure, he took off on rwy 35 with a x-wind from the left. According to the instructor (CFI) & a witness, the takeoff was normal until shortly after lift-off, then the acft…NTSB ANC86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKWhile high speed taxiing on a runway in gusting wind conditions, the pilot lost control of his airplane and it veered into a parked airplane adjacent to the runway. The pilot reported the wind was from 130 degrees at 15 gusting 25 knots.NTSB SEA86LA134Accident · No injuriesLimited investigationFinal reportAyres S2R · Hamer, IDDuring aerial application the engine ceased operating and a small fire erupted. During forced landing the landing gear was torn off and the fuselage became twisted. After landing, the fire continued for a short period of time. Postaccident eng teardown…