NTSB investigations, 1986, SC
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 | 46 |
|---|---|
| 1965 | 41 |
| 1966 | 58 |
| 1967 | 49 |
| 1968 | 62 |
| 1969 | 39 |
| 1970 | 51 |
| 1971 | 42 |
| 1972 | 58 |
| 1973 | 43 |
| 1974 | 49 |
| 1975 | 51 |
| 1976 | 39 |
| 1977 | 44 |
| 1978 | 56 |
| 1979 | 28 |
| 1980 | 29 |
| 1981 | 32 |
| 1982 | 52 |
| 1983 | 40 |
| 1984 | 35 |
| 1985 | 36 |
| 1986 | 25 |
| 1987 | 35 |
| 1988 | 41 |
| 1989 | 27 |
| 1990 | 23 |
| 1991 | 20 |
| 1992 | 31 |
| 1993 | 24 |
| 1994 | 30 |
| 1995 | 32 |
| 1996 | 19 |
| 1997 | 28 |
| 1998 | 28 |
| 1999 | 26 |
| 2000 | 19 |
| 2001 | 13 |
| 2002 | 21 |
| 2003 | 22 |
| 2004 | 20 |
| 2005 | 22 |
| 2006 | 17 |
| 2007 | 15 |
| 2008 | 20 |
| 2009 | 29 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 21 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 12 |
| 2016 | 15 |
| 2017 | 12 |
| 2018 | 21 |
| 2019 | 18 |
| 2020 | 13 |
| 2021 | 22 |
| 2022 | 21 |
| 2023 | 21 |
| 2024 | 10 |
| 2025 | 19 |
| 2026 | 15 |
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\" = 'SC' 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" = 'SC' 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 ATL87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCOne blade of the fixed pitch propeller separated 3' from the hub during a routine instructional flight. The imbalance resulted in a broken engine mount and a total loss of power was experienced. A forced landing was made in a soft field during which, the…NTSB ATL86LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft was about 1/2 hrs into a planned 2.0 hr banner tow flt. On the last pass along the Beach, at about 500 ft AGL, the eng popped and lost pwr. The plt turned the acft out to sea and landed in the ocean. The plt swam to shore and the acft sank.NTSB ATL86LA226Accident · No injuriesLimited investigationFinal reportCessna 150L · Campobello, SCWhile on her 2nd solo x-country flt, the student plt became lost/disoriented after the comm/nav radios developed a problem. Subsequently, she made a precautionary landing in an open field. During the landing roll, the acft hit a ditch & nosed over.NTSB ATL86FA218Accident · No injuriesField investigationFinal reportHughes 269C · Laurens, SCThe plt was flying an underground cable patrol at 500-600 ft AGL when the accident occurred. The plt reported pwr was set at 20' hg, 3,000 RPM when a 'very loud pop' was heard. The plt likened the sound to being hit by ground fire. The acft yawed and the eng…NTSB ATL86FMG09Accident · 1 fatalFinal reportGray Drifter XP · Orangeburg, SCThe homebuilt acft crashed shortly after takeoff. Witnesses reported hearing a loss of power during initial climb. The acft then entered an abrupt right turn and descended to ground impact. Post accident bench test of the engine failed to disclose any…NTSB ATL86LA216Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Ridgeland, SCThe pilot was performing a test flight to test a new spray pump which was recently installed on the aircraft. Following a low pass over the runway the pilot heard a grinding noise from the left side of the aircraft. Shortly thereafter the aircraft lost total…NTSB ATL86LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Surfside Beach, SCDuring first banner tow of the day, plt reported that the eng lost power during initial climb after the banner was hooked. The banner was released and acft descended into trees 1 mile from the pick-up point. Inspection of the eng confirmed a magneto ignition…NTSB ATL86LA198Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Lake City, SCDuring landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway…NTSB ATL86LA204Accident · No injuriesLimited investigationFinal reportCessna C-152 · Conway, SCThe acft was based at an uncontrolled airstrip without fuel facilities. Prior to take-off, the plt refueled the acft from a 5 gal can and draining the fuel sumps. During an approach to land at Conway, SC, the acft lost power and a forced landing was made on a…NTSB ATL86LA184Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Little River, SCThe plt reported that the glider was violently rolled into a 90 left bank by strong crosswinds at about 250 ft AGL, while it was being towed aloft. The plt's cockpit canopy came open, and the plt attempted to close and secure it. The canopy came open again…NTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…NTSB ATL86LA172Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Dillon, SCDuring landing roll, the plt reported, the rwy surface was wet and he was unable to stop the acft before departing the paved surface. According to published landing procedures, the plt would have needed aprx 1439 ft of paved surface for the landing roll. The…NTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…NTSB ATL86IA162Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCDuring a scheduled air carrier flight at normal cruising altitude, the captain passed out upon re-entering the cockpit after excusing himself to go to the lavatory. The flight crew diverted to an alternate destination due to the medical emergency. A review of…NTSB ATL86LA152Accident · No injuriesLimited investigationFinal reportForney F-1 · Abbeville, SCThe student plt reported that the acft's brake system was inoperative during ldg rollout. The acft ran off the end of the rwy end into a trash pile and collided with pine logs.NTSB ATL86LA121Accident · No injuriesLimited investigationFinal reportAyres S-2D-600 · Walterboro, SCThe acft was returning to arpt for fuel then was to resume fighting a forest fire by water dispersal. The acft experienced total fuel exhaustion on short final and force landed 500 ft from rwy.NTSB ATL86LMG06Accident · No injuriesFinal reportRussell Acro MR3 · Clio, SCThe plt reported that the home-built acft experienced a loss of aileron control during lndg. He continued the lndg, using the rudder and throttle to control the acft. The acft hit a tree-top adjacent to the rwy and crashed into a plowed field next to the…NTSB ATL86LA117Accident · No injuriesLimited investigationFinal reportBellanca 7-GCAA · Chester, SCAircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient…NTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…NTSB ATL86LA112Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Orangeburg, SCDuring landing the student pilot lost directional control of the aircraft in a crosswind and ran off the side of the runway and into a drainage ditch.NTSB ATL86IA093Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Charleston, SCThe acft landed on rwy 15 at 2357 EST. The rwy was wet from heavy rain & thunderstorms. Braking was ineffective and the acft failed to stop. The capt steered rt into the mud to the rt side of the overrun. Post accident review of the flt data recorder showed…NTSB ATL86LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Charleston, SCWhile on a personal cross-country flight the aircraft experienced a complete loss of power and made an emergency landing on a road 2.5 miles east of the airport. The pilot stated that the aircraft ran out of fuel.NTSB ATL86LA071Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Columbia, SCWhile on crosswind following takeoff the engine lost total power after climbing to 500 feet AGL. The pilot initiated a turn toward a field and collided with trees on the approach end of the field. Post-crash examination of the aircraft revealed that the…NTSB ATL86LA056Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Conway, SCDuring night flight instruction for takeoff and landing practice, the aircraft collided with trees off the approach end of the runway and impacted the ground 800 feet short of the runway. The runway had been recently extended and the trees off the end of the…NTSB ATL86FMG03Accident · Minor injuriesFinal reportCessna 441 · West Columbia, SCDuring final approach the plt noticed acft flying 'unusual' and elected go-around. During power-up, the acft lost power and a forced landing was made on a residential street near the arpt. The plt stated that he had inadvertenly placed the fuel selector in…