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 CHI84LA123Accident · No injuriesLimited investigationFinal reportCessna 150 · Crawfordsville, INAfter returning to the arpt, the student began practicing touch-&-go landings. While climbing thru about 150 ft AGL, after the 3rd landing, the eng sputtered twice, then quit running. The acft was landed straight ahead on snow covered terrain. When the…NTSB SEA84FA064Accident · 2 fatalField investigationFinal reportCessna U206 · Stevenson, WAThe plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…NTSB FTW84LA152Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Longview, TXShortly after takeoff the left engine ceased operating. A shallow turn back to the airport was being made when the rightengine ceased operating. A field was chosen for a forced landing and at touchdown a hard landing occurred. Investigationrevealed that the…NTSB CHI84LA122Accident · No injuriesLimited investigationFinal reportCessna R172K · Marion, OHThe plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over.NTSB ATL85LA048Accident · No injuriesLimited investigationFinal reportAero Commander 1121 · Salisbury, NCIn March, 1984, N454SR reportedly sustained substantial damage during a hard landing. The accident was reported by a former FAA inspector on 11/29/84.NTSB ATL84FLT06Accident · Serious injuriesFinal reportCessna 182 · Maryville, TNThe acft crashed during a forced landing after running out of fuel. The plt said he did not visually check the fuel prior to takeoff. After the accident the acft contained 2 gallons in each tank and had about an ounce of fuel in the carburetor which normally…NTSB SEA84FA063Accident · 2 fatalField investigationFinal reportEnstrom 280C · Middleton, IDThe acft collided with the terrain during a test flt. Witnesses observed the acft rotate about 180 degrees about its vertical axis go nose low and descend vertically to the ground. A noise change described as a 'sputter' or tone change' was heard during this…NTSB MKC84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Point Lookout, MOThe plt angled in on the final approach at low alt. And the right landing gear hit a snowbank. The collision pulled the acft into the snow and it nosed over.NTSB NYC84LA094Accident · No injuriesLimited investigationFinal reportCessna 500 · Fitchburg, MAThe plt landed on a slushy rwy. He was unable to stop on the rwy and angled off the end into marshy ground. The stoppingdistance on a dry rwy was figured at 2355 ft. on a slushy rwy the stopping distance was about 4004 ft. the landing rwy was 4500 ft long.…NTSB LAX84LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Jose, CAThe plt of the Cessna 172 requested clearance to rwy 30R & was cleared as requested. While taxiing, he was cautioned about turbulence behind a DC-9. The DC-9 plts were waiting to takeoff on rwy 30L. The Cessna plt started to pass as the DC-9 was cleared onto…NTSB LAX84IA204Incident · No injuriesIncident investigationFinal reportCessna 402C · Kalaupapa, HIWhile on final to rwy 23, a 20 ft wave ricocheted off the rwy embankment, striking the acft's rt flap. The plt executed a go-around & landed on rwy 05 without incident. Investigation revealed that the rt flap cable had broken.NTSB DCA84AA018Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Jamaica, NYDuring an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew…NTSB CHI84FA121Accident · 1 fatalField investigationFinal reportBeech A36 · Wheeling, ILA go-around was initiated about midfield at what one witness estimated as 6 in above the rwy. The acft was between 20 and 50 ft above the trees when it rolled into a steep right angle of bank with the nose dropping simultaneously. Post crash fire destroyed…NTSB ANC84FA038Accident · Minor injuriesField investigationFinal reportCessna 150L · Talkeetna, AKOn downwind for a touch and go, the student pilot noticed a strange engine noise. She elected to do another touch & go, & during a turn from crosswind to downwind, a total loss of power occurred. A forced landing was attempted onto a road. Children were…NTSB SEA84LA062Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pullman, WAAccording to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over.NTSB MKC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pleasanton, KSThe plt stated that he taxied through mud and snow enroute to the rwy. He said when he applied rt rudder and brake the acft failed to respond. The left wing hit a pole.NTSB MKC84LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morrilton, ARThe acft lost power during initial climb after takeoff at about 75 ft AGL. A forced landing was made in the trees. The acft was examined after the accident and no failures or malfunctions noted. The existing temperature and dewpoint were in carburetor icing…NTSB MKC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jefferson City, MOThe acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy.NTSB LAX84LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Emigrant Gap, CAThe student & instructor plt (CFI) were on a dual x-country flt. They proceeded to fly to an unattended arpt at Emigrant Gap, CA, which was at an elevation of 5284 ft. after arriving, they circled the arpt & made a low pass over the rwy. They saw tracks on…NTSB LAX84LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Oaks, CAThe student plt was on her second supervised solo. She reported that 'on her third landing, she misjudged the distance and undershot the runway.'NTSB DEN84LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Deming, NMThe plt took off with full fuel tanks & used fuel from the main tanks until they were aprx 1/2 full. He then switched to the tip tanks & used fuel from them until they emptied. Judging from a previous flt, he knew the l tip tank would empty aprx 8 min before…NTSB NYC84LA093Accident · No injuriesLimited investigationFinal reportBell 206B · Tarentum, PADuring a practice flt the plt tried to lift off but the right skid seemed to stick. The acrt rolled to the right and although the plt stated he took corrective action the acft rolled over onto its right side.NTSB MKC84FA084Accident · 1 fatalField investigationFinal reportPiper PA-31P · El Dorado, ARThe acft crashed into trees 2 miles short of the rwy during an instrument approach in IMC weather. A plt in the right front seat said that just prior to impact, the acft was descending at 2500 fpm, & when he looked ahead, he saw trees. Hesaid he yelled at the…NTSB MIA84FA095Accident · Serious injuriesField investigationFinal reportMonnett Moni · Indiantown, FLThe acft crashed in pieces after the airframe failed while the plt was performing aerobatics. The plt used his parachutewhile still belted to the tail section of the acft which was lowered by the chute. The wreckage consisted or six main pieces of separated…NTSB LAX84LA199Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Redding, CAThe total power loss occurred due to water contamination in the fuel. Water was found in the carburetor assembly after the accident. The pilot reported that he had drained 4 to 5 gals of fuel from each tank finding no water during the month preceding the…NTSB FTW84LA150Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Amarillo, TXPlt was advised by fss that Amarillo had snow flurries, visibility 4 miles and wind from 350 degs at 28 KTS gusting to 34 KTS, tucumcari, NM was reporting 2 miles visibility with light snow and areas further west were clearing. The plt departed Amarillo under…NTSB DEN84FTM01Accident · 1 fatalFinal reportKeith A Smith KR-2 · Salt Lake City, UTThe acft collided with a mountain ridge in a flat'pancake'attitude,no evidence of foward motion was apparent and all thewreckage was confined to the immediate area. The wooden prop was intact with the exception of 2 inches missing from the end of one blade,…NTSB CHI84FA119Accident · 1 fatalField investigationFinal reportCessna 152-II · Manhattan, ILThe acft was observed entering a spin from a nose high attitude from which it failed to recover. The student pilot was seen waving to his family as the acft circled in the vicinity of his parent's home. There was no evidence of preimpact failure or…NTSB ATL84LA110Accident · No injuriesLimited investigationFinal reportCessna 337B · Athens, TNThe acft caught fire during landing when a gasoline can overturned and was ignited by a passenger trying to right it with a burning cigar in his hand.NTSB ATL84LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Alma, GAThe plt was on downwind and reduced power,he stated,before application of carburetor heat. The engine lost RPM and when the plt tried to regain RPM. The engine stopped. The plt said he tried to restart but failed and then made a forced off arpt landing. The…NTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…NTSB SEA84LA061Accident · No injuriesLimited investigationFinal reportBeech A33 · White City, ORThe acft crashed into trees after stalling into the ground during an attempted takeoff from a soggy short sod airstrip. The acft was rotated prematurely after which it stalled at about 40 ft AGL. The plt said he should have walked the fieldto determine its…NTSB NYC84FA092Accident · Minor injuriesField investigationFinal reportCessna 425 · Dryden, NYThe plt stated that he was utilizing the autopilot and flt director to execute the ILS appch to rwy 32. The autopilot was tracking the localizer while the pilot controlled the rate of descent along the glideslope with pitch command wheel on the autopilot,…NTSB MKC84LA090Accident · No injuriesLimited investigationFinal reportRobert H. Low Mustang II · Des Moines, IAOne of the purposes of the flt was for the plt to experience a takeoff at max gross wt. He put a 150 lb bag of cement in the right front seat to simulate the wt of a passenger, then initiated a takeoff from a sod rwy that was soft after a recent thaw, using…NTSB MKC84LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415C · N. Stillwell, KSAfter an eng power loss during takeoff climb, the plt landed the acft on the remaining runway. The hard landing resultedin a nose gear collapse. Post accident investigation revealed that the acft had only flown once in 7 months. The old automotive fuel had…NTSB MKC84LA085Accident · No injuriesLimited investigationFinal reportCessna 150L · Ft Riley, KSThe student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear.NTSB MKC84LA083Accident · No injuriesLimited investigationFinal reportCessna C-150K · Hot Springs, ARThe acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…NTSB MIA84LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cedar Key, FLDuring the 1st landing, the acft touched down at night, aprx half way down the rwy. The plt eleected to go around, then made a 2nd apch & landing. During the 2nd landing, the acft went off the end of the rwy & came to rest in water. The plt stated that…NTSB MIA84LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Brandon, FLThe acft had been parked for about 2 mos with a partial fuel load. Prior to departure, 40 gal of auto fuel was added & both wing tank sumps & the gascolator were drained with only a minimal amount of water found. Shortly after takeoff, the eng lost power.…NTSB FTW84LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Longview, TXThe plt landed in an rough surface overrun area marked by painted tires as unusable. The right main gear collapsed after touchdown and the acft slid to a stop. The plt said he did not see the tires marking the overrun until after the accident.NTSB FTW84LA146Accident · Serious injuriesLimited investigationFinal reportChance Vought F4U-5 · Alief, TXShortly after takeoff the aircraft experienced a power loss. The pilot attempted to land in an area of new residential construction and was forced to dive under power lines, the aircraft impacted the ground in a nose low attitude and slid to a stop in less…NTSB DEN84FA102Accident · 1 fatalField investigationFinal reportBell 206B-III · Coalville, UTThe helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…NTSB CHI84LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Lima, OHHeavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…NTSB CHI84FA118Accident · 2 fatalField investigationFinal reportCessna 310K · Monticello, INAfter taking off, the acft was observed to climb to about 400 ft AGL, then enter a steep left bank. The acft then leveled off & rolled out on a downwind that was angling toward the rwy. On downwind, the aircrew transmitted that they were 'coming back.'…NTSB ATL84FLT03Accident · Serious injuriesFinal reportCessna A-188B · Crawford, MSThe acft stalled during an aerial application turn-around. Before recovery from the stall, the acft collided with trees, a power line and the ground. No evidence of a preimpact malfunction was found or reported.NTSB ATL84FA107Accident · 2 fatalField investigationFinal reportPiper PA-23 · Bluefield, WVWhile cruising on an IFR flt at 10,000 ft, the plt informed atlanta center that he had an eng problem & was declaring an emergency. He was provided a heading to the Bluefield arpt which was nearby. When asked about the problem, he said the left eng was…NTSB SEA84FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Kent, WAAt about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local…NTSB NYC84IA091Incident · No injuriesIncident investigationFinal reportLockheed 382G · Groton, CTAfter landing on rwy 33, and during taxi to the ramp, the lt wing tip of the acft struck a parked DC-3.NTSB LAX84LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Chandler, AZThe plt had just completed a power-off spiral to about 200 ft AGL. Power was applied & the acft climbed to about 500 ft AGL when the eng quit. Subsequently, the acft was damaged during a forced landing. All fuel lines & the fuel boost pump were found dry.…NTSB LAX84LA196Accident · No injuriesLimited investigationFinal reportRockwell 112A · Yucca Valley, CAUpon arrival at the uncontrolled arpt, neither the instructor (CFI) nor the student observed the arpt's wind sock. The acft was observed to touch down midway down the rwy & bounce once during the landing. As the acft neared the end of the rwy, the CFI…