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 ATL89LA031Accident · No injuriesLimited investigationFinal reportCessna 310J · Carrollton, OHThe pilot had landed at Carrollton, OH for refuelling and breakfast. After refuelling he taxied out for departure from runway 25 for a flight back to his home base. The runup was reportedly normal. After application of maximum power, he started his takeoff…NTSB SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.NTSB MKC89LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mena, AROn left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…NTSB MIA89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lajas, PRThe plt filled the fuel tanks, made three touch-&-go landings, then departed on a x-country flt. After aprx 1.5 hrs of flt, he elected to reverse course & land at an alternate arpt since he had inadequate fuel to reach his destn. Realizing the fuel supply was…NTSB MIA89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Clearwater, FLAs the student plt was making a simulated single eng apch, the instructor's attention was momentarily diverted inside the cockpit. When the instructor looked outside again, the acft was low & slow on a short final apch. The CFI applied power to arrest the…NTSB MIA89IA028Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that on landing rollout, the acft veered off the left side of the runway and as it was slowing down, hit a depression in the ground and the left main gear collapsed. The acft then spun around and came to rest.NTSB MIA89FA027Accident · 2 fatalField investigationFinal reportGrumman AA5A · Tampa, FLWitnesses stated the acft was flying at low alt in the area of lake thonotosassa just before it struck the top static wire of a group of power lines. Impact occurred while the acft was on a southerly heading. The acft then crashed into an orange grove. An…NTSB FTW89LA020Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Powderly, TXThe pilot was receiving his biennial flight review and was on approach to the airport when he heard a loud snap and lost elevator control. He was able to put the airplane down on the runway, but could not get the tail down. When he applied the brakes, the…NTSB FTW89LA018Accident · No injuriesLimited investigationFinal reportCessna 182B · El Paso, TXThe pilot said he thought he had enough fuel to keep the airplane airborne for 6 hours but the left tank ran dry in 4.0 hours and the right tank went dry at 4.1 hours. The landing was on a ranch airport but was not on a runway and the forced landing was a…NTSB FTW89LA017Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Gladewater, TXThe pilot was returning home from a personal night cross-country flight when the engine stopped producing power. The pilot attempted to glide to the home airport but was unable and had to accept a forced landing on a railroad track. During the final approach,…NTSB BFO89FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Towson, MDAbout 6 min after takeoff, after leveling at 3500 ft, the plt rprtd he was having a probelm that he was unable to figure out. A few minutes later, he repeated the same problem & elected to divert to a nearby arpt. Witnesses rprtd the acft reversed course svrl…NTSB ANC89LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Meshik Lake, AKThe pilot was attempting to takeoff from an unimproved landing area with two hunter-friends. He stated that the aircraft bounced three times, reached an altitude of about four feet, then hit the ten-foot high trees at the departure end of the area and nosed…NTSB NYC89LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G · Champion, NYThe pilot was unable to sustain flight due to a severe downdraft accompanied by a power loss at a low altitude.NTSB MIA89LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Tupelo, MSThe Cessna plt was taxiing his acft on a marked taxiway when he observed a Piper PA-31-350 (chieftain) entering the taxiway ahead of his acft. The Cessna plt applied the brakes & stated the acft was stopped for 3-4 seconds before the left wing of the Piper…NTSB MIA89LA024Accident · Minor injuriesLimited investigationFinal reportBell 206L · St. ThomasThe plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter…NTSB LAX89LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAThe student plt was practicing touch-&-go landings on his 3rd instructional solo flt. Drg an apch to land, the acft was slightly to the right of the rwy. The student tried to correct the situation, then decided the acft was too close to the ground. He added…NTSB LAX89DUM03Accident · No injuriesFinal reportGrumman G-164 · Blythe, CAThe pilot stated that the engine lost power on a 'spray pass.' He then executed a forced landing straight ahead and nosed over after touchdown in a cotton field. Investigation revealed an elbow fitting connecting the main fuel supply line and the carburetor…NTSB CHI89IA023Incident · No injuriesIncident investigationFinal reportBritish Aerospace JS-3101 · Milwaukee, WILoss of lubrication to the outer wheel bearing, and the subsequent disintegration of the bearing. Contributing to the incident was the failure by maintenance personnel to properly inspect and grease the bearing.NTSB MKC89LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Montezuma, IAWhile on a VFR cross country cargo flight, the commercial plt said his alternator failed and that within eight minutes he lost electrical power and was unable to operate the navigation instruments. He continued toward his destination about 2 more hours when…NTSB MIA89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe plt taxied to rwy 6 & made an eng run-up. As he called the twr for tkof, a navy P-3 was making a low apch to rwy 10.the plt was told to taxi to rwy 10. Abt 30 sec later, as he arrived at rwy 10, he was clrd for tkof & was cautioned abt wake turbc fm the…NTSB ATL89LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Deane, KYWhile en route to wise, Virginia from richmond, Kentucky on a pleasure flight, the airplane collided with trees on rockhouse mountain. The airplane was substantially damaged and the pilot and passenger were seriously injured. The fuel selector was found…NTSB NYC89LA024Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Newstead, NYLanding in unsuitable terrain following a partial power loss carburetor icing.NTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…NTSB BFO89LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAThe student & instructor (CFI) made a normal apch at 60 KIAS with 30 degs of flaps. When aprx 100 to 200 ft AGL, the acft began to descend below the desired glidepath. The student added power and increased pitch attitude. The acft continued to descend and the…NTSB ATL89LA028Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Sheperdsville, KYThe pilot had flown a Cessna 172 to tampa to pick up a Cessna T210M for a flight to louisville, KY. The 210 had been previously flown to tampa from ft. myers by the owner. After a preflight in which the pilot said he visually verified that the fuel tanks were…NTSB ANC89LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe instructor pilot was demonstrating a soft-field landing to his student pilot when he flared the airplane too high, and allowed the crosswind to carry the airplane off the left side of the runway where it hit a runway light and a snow berm, then nosed…NTSB SEA89LA017Accident · No injuriesLimited investigationFinal reportCessna 210K · Anacortes, WADuring a gusty crosswind landing, touchdown was accomplished about 500 feet past the runway threshold. The aircraft bounced at touchdown. The pilot stated that he thought he had a flat main tire. The pilot momentarily added power after touchdown to go-around…NTSB DEN89LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, MTThe commercial plt was landing after a pipeline patrol flight. There were no pax. The plt made a wheels landing on rwy 30 with wind reported from 270 at 28 KTS. During landing roll, a wind gust from the left side, estimated by the plt as 50 KTS, lifted the…NTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINTSB ATL89LA027Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Greensboro, NCPIC was attempting to land at unfamiliar airport with narrow rwy, 25 feet wide, bounded by trees. He did not determine wind other than its general direction. Crosswind was four knots. On short final, after crossing over trees that were approach obstacles,…NTSB NYC89LA023Accident · No injuriesLimited investigationFinal reportCessna 172RG · Robbinsville, NJFailure of the pilot to adequately correct for the crosswind and maintain control of the aircraft during a crosswind landing.NTSB NYC89FA021Accident · 2 fatalField investigationFinal reportCessna 152 · Smithfield, RIFailure of the pilot to maintain airspeed after beginning an ascent from a low pass, which resulted in a stall & loss of aircraft control. Inadequate altitude to recover from a stall was considered to be a contributing factor.NTSB MKC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Leon, IAWhile cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine…NTSB LAX89LA038Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Vacaville, CADuring final approach, the glider collided with a fence. A witness stated that, 'the pilot simply let the glider get too low and too slow and hit a fence.' There were no mechanical problems reported prior to the accident. The pilot did not file an acdt report.NTSB FTW89IA016Incident · No injuriesIncident investigationFinal reportBoeing 727 · Houston, TXPoor planning/decision by the unidentified Cessna pilot by maneuvering in busy airspace near the arsa with no ATC coordination or transponder signal; no traffic advisory being issued by the approach controller; and inadequate visual lookout by the flight crew…NTSB FTW89FA015Accident · 2 fatalField investigationFinal reportCessna A150K · Flint, TXThe airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…NTSB NYC89FA022Accident · 1 fatalField investigationFinal reportCessna 207 · Monoghan, PAEvidence indicates that the airplane flew straight into the side of a 1320 ft mountain at the 1280 ft level. The recommended minimum flight altitude for this designated mountainous area, at night, is 3500 ft. there was no evidence of any mechanical problems.NTSB LAX89LA039Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Yucca Valley, CAThe student plt and the CFI agreed that the acft developed a high sink rate as it passed over the departure end of the dirt rwy. The acft collided with the ground about 3/4 mile from the rwys end. The winds were variable but basically from the south at 15-20…NTSB LAX89LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Madera, CAThe pilot stated that on the last landing, the airplane touched down hard. Subsequently, the nose gear collapsed & the airplane went off the left side of the runway. There were no reported mechanical failures or malfunctions with the airplane prior to the…NTSB LAX89LA036Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Camarillo, CAPilot of N8219J used poor judgement when she elected to execute the high speed taxi operation.NTSB FTW89LA014Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winnsboro, TXThe student plt checked the wx for his solo x/c and was advised of strong winds and moderate turbulence. The supervising flight instructor was aware of the wx report and allowed the student to depart, although all later x/c flights were cancelled due to the…NTSB FTW89DRD01Accident · Minor injuriesFinal reportSandridge KR-2 · Monroe, LAAs the plt was taxiing to takeoff, the tower adzd him that wind shear advisories were in effect. At aprx 1359, he was clrd for takeoff on rwy 31. At that time, the wind was from 280 deg at 18 KTS. Drg takeoff, the acft was climbing thru about 300 to 500 ft,…NTSB ATL89FA025Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mc Donough, GAShortly after takeoff the flight experienced a complete engine failure. The pilot attempted a forced landing to an open field but crashed short. The investigation disclosed that the pilot was not certificated as an airman and he did not have the permission of…NTSB ATL89FA024Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bridgeport, WVThe plt was cleared to execute a visual approach to rwy 21 and was issued the current alt setting of 29.60' hg. The approach was made under dark night and gusty crosswind conditions to a lighted runway in rural mountainous/hilly terrain. During final approach…NTSB SEA89LA016Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKOutbd 5 feet of top skin from one main rotor blade separated in flt. Plt effected lndg with no further damage. Investigation revealed erosion of leading edge protective strip allowed airloads to intrude under skin to cause delamination and separation. Soot…NTSB NYC89LA020Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Ebensburg, PAThe acft experienced a total loss of power and crashed in trees near Ebensburg, PA. A teardown inspection revealed extensive preimpact damage to the engine. The #3 main bearing had failed, causing the interruption of oil supply to the #4 and 5 bearings and…NTSB LAX89LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · San Diego, CADuring the initial climb after takeoff, the engine lost partial power. A turn was made to land on rwy 10R, but the pilot was unable to reach the landing area. Subsequently, he made a wheels-up landing short of the runway. An inspectionof the engine revealed…NTSB LAX89LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot lost control and collided with the runway while maneuvering for landing. The pilot and passenger were testing atmospheric conditions with meteorological equipment in conjunction with noise testing of a Boeing 707 'hush' kit. The Cessna tookoff…NTSB FTW89FA013Accident · 4 fatalField investigationFinal reportAerospatiale AS-355F-1 · W. Cameron 617The loss of control of the aircraft which occurred when the tail rotor drive shaft experienced a fatigue induced material failure and tail rotor thrust was lost. Evidence indicated that the shaft was under designed for the loads that were encountered during…NTSB FTW89DQG01Accident · 1 fatalFinal reportPiper PA-25-235 · Lamesa, TXThe pilot was spraying a field of cotton, and was in a turnaround when the airplane descended to the ground. The autopsy indicated the pilot died of acute coronary thrombosis. Although tox results indicate the presence of alcohol in the pilot's blood, the…