NTSB investigations, 1988, MS
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1988
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") = 1988 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 MIA89LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Holly Springs, MSThe plt stated that after he began a descent from 12,000 ft to 4000 ft, the acft lost all electrical power due to failure of the alternator. While apchg to land at Holly Springs arpt, the acft enctrd unfavorable winds & turbulence. Subsequently, it lost…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 MIA89LA017Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, MSDuring normal cruise flt a portion of one propeller blade separated. The plt landed the acft in a field & during the landing roll, the acft collided with a haystack. Examination of the propeller blade revealed it separated at blade station 28.5. Metallurgical…NTSB MIA89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tupelo, MSThe operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running…NTSB MIA89LA007Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Flora, MSAfter dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began…NTSB MIA88LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Waynesboro, MSWhile cruising at 5500 ft, the plt smelled burning oil. Moments later, oil press was lost, the prop went into high RPM & the tach zoomed over redline. A loud report was heard & all power was lost. A forced ldg was attempted in the rolling country but the acft…NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…NTSB MIA88FA254Accident · 1 fatalField investigationFinal reportCessna 172E · Floweree, MSThe student pilot departed early in the morning and was not found until the next afternoon. There were no witnesses to the accident. The aircraft impacted the ground in a 50 degree nose down angle at a high rate of speed with evidence of aircraft rotation…NTSB MIA88LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Tupelo, MSThe private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…NTSB MIA88LA250Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK-5A · Valley Park, MSThe pilot stated that he thought he had 8 gallons of fuel prior to takeoff. The engine failed about 100 ft AGL and he attempted to stretch the glide of the helicopter by using collective pitch. The aircraft hit hard and rolled over. Only 1 quart of fuel was…NTSB MIA88LA246Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Glen Allen, MSAccording to FAA personnel while returning to land during an aerial application flt, the eng quit due to fuel exhaustion. The acft was damaged drg the forced landing.NTSB MIA88LA242Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Greenville, MSThe pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.NTSB MIA88LA228Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Lambert, MSThe plt stated there were tstrms in the area when he attempted to takeoff on an aerial application flt. He began his takeoff roll from the duster strip & a strong wind gust from the approaching tstrm blew the tail around. The acft came to rest on its belly in…NTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.NTSB MIA88LA217Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Stringer, MSAccording to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree.NTSB MIA88LA212Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ruleville, MSDuring an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…NTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…NTSB MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…NTSB MIA88FA192Accident · Serious injuriesField investigationFinal reportBell 47G3B-1 · Benoit, MSThe plt said the engine misfired three times during takeoff and lost partial power. The helicopter settled into a rice field and the damaged spray booms became entangled. The helicopter nosed over in the high vegetation. The plt stated the engine accelerated…NTSB MIA88LA190Accident · No injuriesLimited investigationFinal reportCessna 150J · Carthage, MSWhile on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a…NTSB MIA88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ocean Springs, MSThe instructor stated that they were on their third touch and go and had made a wheel landing, and just as she started to retract the flaps, the aircraft made an aprx 30 degree turn off the right side of the runway. She then stated that no matter how much…NTSB MIA88LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Centerville, MSThe pilot stated that he thought the aircraft had been refueled the previous evening. During preflight he did not observe any fuel in the aircraft fuel tanks. He further stated that the aircraft fuel quantity guages had been unreliable. In cruise flight both…NTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.NTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…NTSB MIA88LA118Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe plt stated that he was simulating a loss of power & then attempting to turn back to the arpt & land on the runway that they departed from. As he was turning back from an approximate altitude of 600 feet, the acft stalled & crashed.NTSB MIA88LA111Accident · No injuriesLimited investigationFinal reportCessna A188B · Macon, MSThe plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…