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 BFO88FID02Accident · No injuriesFinal reportRotorway RW-145 · Ridgeway, VAThe student pilot was attempting to land from a 2 foot hover when the accident occurred. He reported that he overcontrolled the helicopter and a dynamic rollover resulted. A witness reported the helicopter was traveling downwind when it began to turn to the…NTSB SEA88LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Palmer, WAWhile on a VFR cross country flight the pilot encountered instrument meteorological conditions along his route. The aircraft was not instrument equipped, even though the pilot is instrument rated. The pilot had to make two precautionary landings prior to the…NTSB NYC88LA113Accident · No injuriesLimited investigationFinal reportPiper J-3 · Downingtown, PAThe pilot was performing touch and go wheel landings. During an approach the pilot came in too low and the right main landing gear impacted an electric power pole. The pilot landed the aircraft on a grass strip with only the left main gear then flipped…NTSB LAX88LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Valley Center, CAWitnesses observed the acft rotate to a high pitch attitude during the initial climb after takeoff. They said the acft then entered a left turn & descended to the ground. Impact occurred on rising terrain, beyond a gully, about 200 ft east of the departure…NTSB CHI88IA088Incident · Minor injuriesIncident investigationFinal reportBoeing 727-251 · Detroit, MINTSB ANC88LA080Accident · No injuriesLimited investigationFinal reportChampion 7EC · Anchorage, AKThe private pilot lost directional control of the airplane during the landing roll. The aircraft groundlooped to the left, striking a fence. The pilot reported that he came in high and hurried his approach to fit in with the flow of air traffic at the…NTSB SEA88LA070Accident · No injuriesLimited investigationFinal reportCessna 305-A · Arlington, WAShortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…NTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…NTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…NTSB MIA88LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Key West, FLAccording to the plt he was on a fish spotting flight. The acft lost power. The plt ditched in the ocean. He was picked up by a passing boat & taken to Key West, FL. He stated that due to the past history of this acft, his opinion was that the cause of the…NTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CANTSB LAX88LA141Accident · No injuriesLimited investigationFinal reportCessna 172RG · Malibu, CAThe pilot stated that the purpose of the flight was to allow the passenger to photograph some yachts sailing off the Malibu coast. The pilot said that he initiated a turn at 300 feet AGL around one of the yachts and the aircraft 'suddenly stalled' and he was…NTSB LAX88LA139Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Lompoc, CADuring the landing roll with a crosswind of 15-20 knots, the pilot lost control of the aircraft, collided with the terrain and, approximately 200 yards off the runway, the aircraft nosed over.NTSB LAX88LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbia, CAAt the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down…NTSB LAX88FA140Accident · No injuriesField investigationFinal reportEnstrom 280C · Fremont, CAFailure of the engine to main rotor drive system due to a drive belt slippage caused by a drive pulley worn beyond its service limit. Contributing to the accident was the inadequate factory maintenance manuals which did not provide the serviceable limits for…NTSB LAX88FA135Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Torrance, CAPilot-in-command to apply carburetor heat when entering carburetor icing conditions.NTSB DCA88WA048Accident · 1 fatalForeign investigationPiper PA-38 · Oxford, United KingdomNTSB CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…NTSB ATL88FA125Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Summerville, SCNTSB MIA88LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Terra Ceia, FLWhile on a cross country flt, the plt elected to return to the departure point due to 'bad weather.' He later advised tower personnel when the flt was 10 miles south, inbound for landing. The plt was given landing information after which he reported a loss of…NTSB LAX88LA137Accident · Minor injuriesLimited investigationFinal reportAvian Magnum IX · Phoenix, AZDuring a local flight in a hot air balloon, while descending, the deflation line malfunctioned. It was found that the release pulley had no roller and the rope was knotted and jammed in the pulley. The vent could not be activated in this condition.NTSB LAX88FA134Accident · 3 fatalField investigationFinal reportBeech D95A · Santa Maria, CAFailure of the pilot to adequately compensate for the loss of power in the left engine and to maintain control of the aircraft.NTSB DEN88FA087Accident · 2 fatalField investigationFinal reportCessna 421A · Albuquerque, NMThe plt and one pax were on a business trip in the U.S. From Canada. The plt had the acft fuel tanks 'topped off' prior to departure from Kansas city. The flt plan indicated 3 hours 30 min enroute to Albuquerque with 5 hours 30 min of fuel on board. Strong…NTSB CHI88LA085Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Indianapolis, INFifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the…NTSB CHI88LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Salem, ILWhile attempting to land with a quartering tailwind, the student experienced a loss of directional control and elected to G0-around. On climbout he was unable to maintain the proper rate of climb, and once out of ground effect the aircraft started to descend.…NTSB CHI88LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIThe pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed…NTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.NTSB BFO88LA032Accident · No injuriesLimited investigationFinal reportDreyer-Starduster SA-300 · Richlands, VAAfter touchdown, during the landing roll, the acft veered sharply to the left. The plt attempted to correct this action by applying right rudder and the acft veered 45 degrees to the right. The acft traveled off the right side of the rwy and came to rest on…NTSB MKC88LA071Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Stuttgart, ARDuring a post maintenance test flt, PIC experienced a power loss shortly after lift off. The acft crashed nose low, in a left turn. The engine was thrown clear of the airframe. Post accident inspection of the propeller blades indicated a minimum amount of…NTSB MKC88LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Preston, MOThe student pilot was on the second leg of a x-country trng flt when the eng quit. Exam of the acft fuel system revealed that no fuel was present. The pilot departed the original departure arpt without a full load of fuel, and had planned to acquire fuel at…NTSB FTW88MA083Accident · No injuriesMajor investigationFinal reportBritish Aerospace BAE-3101 · Decatur, TXAirplane's encounter with rought terrain during an attempted forced landing. The forced landing was necessitated after the captain used improper procedures to shutdown the left engine in flight following an unexplained torque fluctuation.NTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…NTSB BFO88FA031Accident · 2 fatalField investigationFinal reportRyan Navion NA-4 · Fancy Gap, VAThe pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.NTSB NYC88LA105Accident · Minor injuriesLimited investigationFinal reportBell 206B · Agawam, MAThe pilot was on approach to landing from the south at about 2,000 yards from his pad. Speed was about 65 knots and was about 500 feet from the ground when the pilot said he had a flashback and doesn't remember what happened, the helicopter rolled over while…NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…NTSB FTW88LA082Accident · Serious injuriesLimited investigationFinal reportSikorsky S-76A · Offshore OilAfter landing on the platform, the copilot moved the power levers to flight idle and set the main rotor blade tip path plane to the height normally used. When an enplanning passenger came up the stairs onto the platform, he was struck on the head by the main…NTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…NTSB CHI88IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 767-200 · Cimarron, NMWhile in normal cruise flight at FL 370, the flt crew was advised by ARTCC personnel that other aircraft were experiencing occasional severe turbulence at FL 370 along their route of flight. A descent was made to FL 330 to avoid turbulence. Later, as the…NTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.NTSB BFO88LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · New Cumberland, WVThe plt said that during the landing roll the brakes did not operate despite his continued application of pressure on the pedals. As the acft neared the rwy end he tried to swerve the acft left toward a runup pad. However, at the same time the r brake…NTSB ATL88LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Muscle Shoals, ALThe airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…NTSB LAX88LA133Accident · 1 fatalLimited investigationFinal reportGulfstream American AA5A · Union City, CADuring a pleasure flight, the airplane collided with a power line tower. The airplane was consumed by fire. The weather at the time of the accident was reported to be instrument meteorological conditions with low fog. The pilot did not file an instrument…NTSB ANC88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKAfter touchdown on a frozen lake, the aircraft rolled approximately 100 feet and at that point the pilot lost directional control and the aircraft nosed over on its back.NTSB NYC88IA112Incident · No injuriesIncident investigationFinal reportBoeing 757 · Providence, RIThe Boeing 757 was climbing through 20000 ft with the first officer on the flight controls when the 55 year old captain became incapacitated. The first officer delcared an emergency and made a normal landing. When clear of the runway, the aircraft was stopped…NTSB MKC88FA067Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Excelsior Spgs, MODuring arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…NTSB MIA88LA128Accident · No injuriesLimited investigationFinal reportCessna 150H · Pensacola, FLThe 3.8 hr cross country flt was uneventful, but after the flt entered the downwind leg of the traffic pattern for landing, the eng quit due to fuel exhaustion. During the forced landing the acft collided with trees & came to rest.NTSB DEN88LA085Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Greeley, COThe CFI rated plt and his CFI rated passenger were practicing touch and go landings. The plt reported that the winds were light and variable. The plt reported that the tail wheel chattered during the last touchdown, and the aircraft swerved to the left. The…NTSB BFO88LA029Accident · No injuriesLimited investigationFinal reportCessna 150G · Ridgeway, VADuring touchdown the acft bounced and the student plt applied power to level-off and reflare. The left wing then rose and the right wing contacted the rwy. The acft bounced back and the left wing contacted the rwy. The nose gear collapsed and the acft came to…NTSB BFO88LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chatham, VAThe student plt was practicing touch and go landings when the accident occurred. He stated the acft was a little high and fast on final apch. On touchdown the acft veered left and traveled off the rwy. The left wing contacted a tree and the acft spun around…