NTSB investigations, MS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE c.\"eventStateOrRegion\" = 'MS' AND c.\"eventCountry\" = 'USA' 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 WHERE c."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA' 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 ATL85FA146Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dundee, MSPlt obtained three preflight wx briefings then filed IFR using an assumed name. Routine communications until 2117 CST when pilot reported in a cell and said he wanted to make a 180 degree turn. Cleared for right turn. Radar and comm contact with aircraft lost…NTSB ATL85FA143Accident · 2 fatalField investigationFinal reportChampion 7GCA · Collinsville, MSWitnesses, friends of the plt, reported seeing the acft engaged in aerobatics at altitudes between 500 ft AGL and 2000 ft AGL, aprx 1/4 mile from their outdoor social function. They continued to report, the acft entered a spin and after aprx 2 3/4 revolutions…NTSB ATL85LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · Prentiss, MSThere was no wind as the plt took off to proceed to an ag site; however, by the time he arrived, the wind had begun to blow. Reportedly, he landed downwind on a rural road in winds that were from the southwest at 10 gusting to 15 KTS. The plt stated that he…NTSB ATL85LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Pontotoc, MSThe pilot ran off the end of the 1500 ft wet & soggy sod rwy during takeoff ground run. The plt stated that he did not realize that he was not going to liftoff , until the acft was too FAR down the rwy to stop on the remaining rwy surface.NTSB ATL85LA095Accident · No injuriesLimited investigationFinal reportBeech 58 · Natchez, MSPlt descended below mda to 720 ft MSL until observing the rwy during a LOC 17 apch at night. An arpt attendant said plt did not call UNICOM for wind info. Plt acknowledged touchdown at midfield with a 30 kt tailwind on the 5000 ft rwy. The plt said braking…NTSB ATL85LA093Accident · Minor injuriesLimited investigationFinal reportBeech A36 · New Albany, MSPIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The…NTSB ATL85LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Holly Springs, MSAbout 40 to 45 min after takeoff pilot noted electrical load meters at 0. Alternator warning lights were on. Reset was attempted but unsuccessful due to low battery voltage. Plt decided to make a precautionary ldg at Holly Springs, MS,but could not lower the…NTSB ATL85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Vicksburg, MSDuring the landing attempt, the pilot failed to ensure that the landing gear was extended. He was preoccupied with trying to locate a runway sweeper reported by the airport manager. When the gear failed to extend the pilot continued the approach knowing that…NTSB ATL85LA078Accident · No injuriesLimited investigationFinal reportCessna 182C · Batesville, MSAfter discharging parachutists at 7500 ft MSL the plt closed the throttle and descended to 1200 ft without clearing the engine. No pwr was available when the throttle was advanced upon reaching 1200 ft. a forced landing was made in a bean fld and the acft…NTSB ATL85LA026Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bay St. Louis, MSPrior to departing on a flt from arlington, TX, to gulfport, MS, the plt stated that he checked and found the fuel tanks full. About 17 miles from gulfport the fuel gage showed a rapid loss of fuel at which time the plt switched tanks. Two minutes later there…NTSB ATL85FA020Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Vicksburg, MSDuring preflt, plt detected water in fuel sample. After takeoff, the engine began to run roughly and on crosswind leg lost power completely. Plt stated that on approach to forced landing, he intentionally struck a tree with the left wing to slow the acft.…NTSB ATL85LA017Accident · Minor injuriesLimited investigationFinal reportBell 222 · Pascagoula, MSThe acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched…NTSB ATL85LA018Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tunica, MSThe pilot attempted takeoff from an agricultural site which had soft spots from wet conditions. Directional control was lost when one main wheel encountered a soft spot. The aircraft veered into a plowed field and flipped inverted.NTSB ATL85LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookhaven, MSA total power loss occurred due to fuel exhaustion. During a forced landing, the plt stalled the acft while clearing over power lines, then the acft collided with trees as it descended out of control. A successful test run of the eng was performed.…NTSB ATL84LA293Accident · No injuriesLimited investigationFinal reportGrumman AA5-B · Luka, MSDuring normal cruise flight the number one cylinder exhaust valve head separated from the valve stem causing a significant power loss. The pilot set up a landing approach to a farm field. On final approach the pilot noticed that rough and rising terrain…NTSB ATL84FLT14Accident · 2 fatalFinal reportRockwell S-2R · Lake Comorant, MSThe aircraft was taken without permission by an employee of the owner. The employee did not hold an airmens certificate and no record of him ever having flight training could be found. The aircraft was found crashed in a field. No evidence of precrash failure…NTSB ATL84LA276Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leland, MSThe plt said he was attempting a roll at low alt shortly after takeoff and was unable to complete the maneuver before the acft collided with the ground.NTSB ATL84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Biloxi, MSPrior to departure the pilot determined that his destination, a grass runway, was dry. His first approach to this field resulted in a go-around because he would have landed long. The second approach resulted in a landing, but because his wheels began to slide…NTSB ATL84LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iuka, MSOn initial climb from take-off, a partial power loss occurred. Carb heat was selected but pwr remained at a level too low to sustain altitude and a forced landing was effected in rough, wooded terrain. Investigation revealed no discrepancies in the fuel or…NTSB ATL84FA241Accident · Serious injuriesField investigationFinal reportCessna 337A · Ocean Springs, MSThe acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…NTSB ATL84LA230Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Georgetown, MSThe plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…NTSB ATL84FA225Accident · 1 fatalField investigationFinal reportde Havilland DHC-1B · Greenwood, MSWitnesses observed the acft become airborne and accelerate low over the rwy. At the end of the private strip the acft entered a 30 to 40 deg nose high attitude climbing to aprx 1,000 ft. the acft then rolled right as the nose dropped and continued to roll…NTSB ATL84LA229Accident · No injuriesLimited investigationFinal reportCessna A188B · Crenshaw, MSThe pilot acknowledged that he attempted to take off on an aerial application flt with the acft loaded above its maximumcertificated gross weight. He stated that he had previously flown with chemical loads & had not encountered problems taking off. Prior to…NTSB ATL84LA220Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Lambert, MSDuring the landing roll the tailwheel reportedly oscillated braking the shock strut lugs allowing the tail of the acft to contact the sod runway. The plt applied hard braking and the acft nosed over. The plt reported nothing was wrong with the tailwheel…NTSB ATL84LA217Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Glen Allen, MSThe plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.NTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…NTSB ATL84LLT11Accident · No injuriesFinal reportCessna T188C · Shelby, MSAcft was departing on the ninth aerial application flt of the operation. Weather had been clear but thunderstorms were building in the local area. On takeoff roll, a strong gust from the left rear caused loss of directional control. Acft veered left and…NTSB ATL84LA200Accident · No injuriesLimited investigationFinal reportCessna 172G · Forkville, MSAfter aprx 3 hrs of flight time, the plt experienced a total loss of power. A forced landing was made in trees in a national forest area. Four ounces of fuel were found in the gascolator, about 2 ounces in the right wing and a few drops in the left wing. The…NTSB ATL84LA199Accident · 1 fatalLimited investigationFinal reportCessna A188B · Hollandale, MSTwo acft were spraying same field. A farm hand was used as flagger to mark last crop row sprayed. Flagger used for last two seasons and briefed previously on flagging operations by the pilot/farm owner. Flagger was not briefed where to begin counting crop…NTSB ATL84LA192Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Tunica, MSThe non-rated plt stated that during a local flt, he flew over a water well drilling operation to survey the area. He reported that he circled at 500 ft 'indicate'. After surveying the area, he initiated a climb, but the eng lost power. Shortly after that,…NTSB ATL84LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Rosedale, MSThe plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over.NTSB ATL84LA155Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Shaw, MSThe acft was landed gear up in a precautionary landing after a control difficulty in flt. On base leg a loud bang was heard and the acft started to roll right. Control forces were heavy so the other plt in the front seat tried to help on the controls. They…NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB MIA84FA126Accident · 6 fatalField investigationFinal reportCessna 402B · Missing Acft, MSThis Acft disappeared on a flt from ft lauderdale, FL to bimini, Bahamas. After departure, the Acft flt plan was activated by radio. This was the last communication with the Acft. An itap radar readout revealed an Acft flt that departed at the appropriate…NTSB ATL84LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Parchman, MSThe plt reported that during the visual approach to runway 27, he misaligned the acft with the unlighted runway and touched down left of the landing area. The acft collided with a ditch and nosed over.NTSB ATL84LLT05Accident · Minor injuriesFinal reportCessna C-172F · Pascagoula, MSThe plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.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 ATL84LA103Accident · No injuriesLimited investigationFinal reportBeech 19A · Mayersville, MSThe plt circled the airstrip prior to landing and believed the landing area in suitable condition. During the landing right main landing gear mired in a soft spot and the landing gear collapsed.NTSB ATL84FA059Accident · 3 fatalField investigationFinal reportBeech A36 · Gulfport, MSPrior to the approach the plt was advised that the wx was sky obscured & visibility 1/4 mi in fog. The plt acknowledged 'roger we'll come on in and give it a shot.' The acft collided with trees about 500 ft short of the middle marker. It was reported that the…NTSB ATL84LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Jackson, MSThe acft ditched in a reservoir at night after a power loss. The plt was descending to land, in preparation for the landing the plt switched fuel tanks on the selector valve to what he thought was both tanks position. Shortly after thisthe engine quit. The…NTSB ATL84LA025Accident · No injuriesLimited investigationFinal reportBell 206B · Nr. Mcadams, MSThe helicopter was being used on an aerial right-of-way-burning flt. The plt reported that due to the terrain & obstacles, his attention was to the outside of the helicopter during the burning operation. After completing the burning operation for that flt, he…NTSB ATL84LA018Accident · No injuriesLimited investigationFinal reportLanny Rundell Quickie Q2 · Vicksburg, MSWhile on the landing roll, the acft was rolling straight down the centerline of the rwy when the plt felt a bump & rear of the acft dropped. At the same time, all directional control was lost & the rudder pedals went forward to the firewall. The acft started…NTSB ATL84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Vicksburg, MSThe acft landed short of the rwy during a forced landing after the engine lost power during cruise flt. The plt reportedthat power was lost at 2000 ft 10 miles north of Vicksburg. He applied the fuel boost pump and successfully restarted the eng but it quit…NTSB ATL83LA374Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Sledge, MSThe plt stated that a power loss occurred during a pull-up prom a swath run. The acft reportedly touched down hard during a forced landing & was substantially damaged.NTSB ATL83FKQ03Accident · No injuriesFinal reportAir Tractor AT-301 · Redwood, MSThe acft made a forced landing in a soybean field after severe vibration developed during a spraying operation. The pilot stated that the powerplant and flt controls were functioning normally at the time of the accident. An on-scene investigation revealed…NTSB ATL83FU005Accident · 1 fatalFinal reportWeedhopper JC-24 · Wiggins, MSReportedly, the non-rated plt had no previous flt experience, but was briefed on the ultralight vehicle's operation, control response & other aspects, as well as the traffic pattern, direction, etc. During takeoff, the ultralight entereda dive after climbing…NTSB ATL83LA284Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B-450 · Hollandale, MSThe acft swerved and nosed over during landing. The pilot stated that on landing the tire blew and directional control was lost. Post accident examination showed the left tire was flat. It was also noted that the tire was worn excessively which allowed tube…NTSB ATL83LA281Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sledge, MSThe acft collided with the ground and nosed over during an aerial application maneuver. The plt stated, the acft startedto settle while in a turn and he dumped the load after leveling the wings but was unable to stop the descent prior to ground contact. The…NTSB ATL83FA262Accident · 2 fatalField investigationFinal reportBeech N35 · Mccomb, MSThe acft crashed in a nose low attitude and was destroyed. The two plts aboard had been practicing instrument approachesat Mccomb and suddenly without notifing fss the practice was discontinued to return to baton rouge. Fss found out about the change by…NTSB ATL83LA260Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Hazlehurst, MSThe acft collided with a tree and the ground shortly after takeoff with a heavy load on a hot day. The acft had 1600 lbsof dry fertilizer, 42 gallons of fuel for takeoff. The plt stated he got into 'downdrafts' in the rolling hills and he jettisoned the load…