NTSB investigations, 1986, MS
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 per year
| 1964 | 54 |
|---|---|
| 1965 | 69 |
| 1966 | 62 |
| 1967 | 58 |
| 1968 | 50 |
| 1969 | 54 |
| 1970 | 40 |
| 1971 | 58 |
| 1972 | 52 |
| 1973 | 32 |
| 1974 | 51 |
| 1975 | 44 |
| 1976 | 36 |
| 1977 | 56 |
| 1978 | 49 |
| 1979 | 44 |
| 1980 | 43 |
| 1981 | 45 |
| 1982 | 36 |
| 1983 | 21 |
| 1984 | 29 |
| 1985 | 23 |
| 1986 | 26 |
| 1987 | 34 |
| 1988 | 26 |
| 1989 | 36 |
| 1990 | 20 |
| 1991 | 25 |
| 1992 | 20 |
| 1993 | 26 |
| 1994 | 20 |
| 1995 | 35 |
| 1996 | 22 |
| 1997 | 22 |
| 1998 | 25 |
| 1999 | 38 |
| 2000 | 24 |
| 2001 | 23 |
| 2002 | 16 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 19 |
| 2006 | 12 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 19 |
| 2010 | 8 |
| 2011 | 16 |
| 2012 | 19 |
| 2013 | 13 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 7 |
| 2017 | 11 |
| 2018 | 6 |
| 2019 | 13 |
| 2020 | 7 |
| 2021 | 11 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 7 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1986
AND 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 year(c."eventDate") = 1986 AND 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 MIA87LA053Accident · No injuriesLimited investigationFinal reportCessna 150F · Tunica, MSThe plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed.NTSB MIA87LA049Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Gulfport, MSThe acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end…NTSB MIA87LA033Accident · No injuriesLimited investigationFinal reportHickham Twinstar · Bay St. Louis, MSShortly after takeoff on the initial test flt, severe vibration was felt and the plt attempted to return the float equipped acft to the water for a forced ldg. Due to low alt, the plt had to land in trees. An exam of one of the blades of the 3 bladed…NTSB MIA87FA031Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Columbus, MSThe acft departed Columbus, MS, en route to meridian, MS, to pick up cargo for a return flt to Columbus. The acft did not arrive at its destination and was later found in an open field about 2 miles southwest of the golden triangle regional airport in…NTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…NTSB MIA87LA012Accident · No injuriesLimited investigationFinal reportAyres SR-2-600 · Glen Allan, MSShortly after takeoff the pilot stated the engine failed and he executed a forced landing. Post accident examination revealed no fuel in the aircraft fuel system.NTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…NTSB MIA87FA003Accident · 1 fatalField investigationFinal reportGriffin STAR-LITE · Raymond, MSThe plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…NTSB MIA86FLT02Accident · Serious injuriesFinal reportMccoy Robert-Michael Breezy · Meridian, MSDuring flt testing of the newly purchased acft which was conducted prior to the x-country flt home, oil consumption/leakage was determined to be about 3 qts per hr. The plt stated that he planned the flt home in short hops so as to minimize oil usage & had…NTSB MIA86LA240Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Dublin, MSWhile buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground.NTSB MIA86FA202Accident · 1 fatalField investigationFinal reportGrumman G-164B · Sidon, MSThe right wings of the ag operator's bi-plane collided with the ground support cables of a 322 ft high microwave tower while on a base leg for landing. The right wings separated & the acft crashed & burned killing the plt. The 25000 hr plt knew of the tower…NTSB MIA86LA198Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Okolona, MSWhile in cruise flt at 100 feet en route to the spraying area the engine 'spit' twice and quit completely. During a forced landing in a field the aircraft encountered mud and nosed over coming to rest inverted. The engine had 100 hours before it was to be…NTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…NTSB MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.NTSB MIA86LA222Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Cleveland, MSThe pilot stated that when he took off, the acft was overweight and he was unable to remain airborne. He attempted a running landing, the skids dug in and collapsed causing the spray boom to swing forward and break the bubble canopy.NTSB MIA86FA185Accident · 1 fatalField investigationFinal reportAyres S2R-1820 · Dundee, MSThe ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then…NTSB MIA86LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vaiden, MSThe plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest…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 MIA86LA169Accident · No injuriesLimited investigationFinal reportCessna 172RG · Jackson, MSThe plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell…NTSB MIA86LA160Accident · Minor injuriesLimited investigationFinal reportVarga 2150A · Kiln, MSThe plt stated that while on local flight he ran out of fuel & upon landing in a field, the acft struck a tree, severing the wings.NTSB MIA86LA151Accident · No injuriesLimited investigationFinal reportCessna T188C · Shaw, MSThe plt stated that shortly after takeoff he noticed the fuel cap was loose. He then turned downwind to land, at which time the aircraft stalled, resulting in the right wing colliding with trees.NTSB MIA86LA150Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Shelby, MSAfter departure while making a turn the pilot reported the engine lost power and the aircraft settled into the trees. There was no evidence of a preexisting mechanical failure/malfunction.NTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…NTSB MIA86LA088Accident · No injuriesLimited investigationFinal reportBeech D-18S · Pascagoula, MSThe plt stated that he sensed a loss of pwr on one eng after takeoff, just prior to gear retraction. He elected to remove all pwr and land straight ahead on the remaining rwy. The acft went off the end of the rwy and entered a wet grass area. The acft could…NTSB MIA86LA083Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Greenwood, MSThe plt stated that during an aerial application swath run, he struck a group of power lines & crashed into a field.NTSB ATL86LA060Accident · No injuriesLimited investigationFinal reportCessna 182Q · Carthage, MSWhile on final approach for landing the pilot advanced the throttle to adjust his final approach path and the engine lost power. The aircraft impacted the ground short of the runway and flipped inverted. The engine was later test run and performed to…