NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 MIA00FA058Accident · 2 fatalField investigationFinal reportAero Commander 500 · Georgetown, SCThe noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…NTSB MIA00FA056Accident · 1 fatalField investigationFinal reportBeech E-90 · Beaufort, SCThe pilot-in-commands failure to maintain the appropriate altitude (minimum descent altitude) during an area surveillance radar (ASR) approach, resulting in an in-flight collision with swampy terrain. Contributing to the accident was the co-pilot's failure to…NTSB MIA00LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pelzer, SCThe student pilot's failure to recognize and compensate for changing wind conditions while on final approach and landing and his failure to initiate a timely go-around, resulting in collision with trees and a utility pole.NTSB MIA00LA032Accident · No injuriesLimited investigationFinal reportBeech 90 · St. George, SCthe pilot's improper preflight planning/preparation and failure to ensure adequate fuel to safely complete the flight resulting in fuel exhaustion and engine failure, and his inadequate compensation for the wind that resulted a forced landing short of the…NTSB ATL00LA014Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ridgeland, SCThe pilot's failure to obtain/maintain adequate airspeed during the takeoff/initial climb which resulted in an inadvertent stall and subsequent collision with terrain.NTSB MIA00LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberry, SCa fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.NTSB MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.NTSB MIA99LA227Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Perry, SCan in-flight collision with the ground due to inadequate liftoff airspeed, and the pilot's improper use of flaps, which resulted in too low of an altitude to sustain flight.NTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…NTSB MIA99LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greenville, SCA total loss of engine power while in descent for landing due to fuel exhaustion as a result of the pilot's failure to properly plan and load the fuel required, and the subsequent collision with the terrain during a forced landing.NTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.NTSB MIA99LA189Accident · Minor injuriesLimited investigationFinal reportBoeing HU-369-OH6A · Murrells Inlet, SCAn inflight loss of control due to loss of tail rotor effectiveness as a result of the pilot's inadequate compensation for the winds and improper weather evaluation.NTSB MIA99LA174Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Seneca, SCThe PIC's improper fuel management resulting in loss of engine power during approach to landing due to fuel starvation and the subsequent collision with trees and a residence during an emergency landing. Contributing to the accident was the PIC's failure to…NTSB MIA99LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Timmonsville, SCThe loss of engine power due to the improper installation and in-flight separation of an engine cylinder.NTSB ATL99LA100Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbia, SCThe pilot's failure to maintain directional control during a landing roll.NTSB ATL99LA099Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Chapin, SCThe loss of engine power for undetermined reasons. A factor was the collision with a utility wire.NTSB MIA99LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rock Hill, SCThe pilot's failure to maintain directional control. Related factors were the crosswind and the pilot's lack of experience.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB MIA99FA125Accident · 2 fatalField investigationFinal reportPiper PA-16 · Hardeeville, SCAn inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.NTSB ATL99LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Hilton Head, SCThe pilot's inadequate evaluation of weather information that resulted in his failure to maintain directional control during landing. Factors were gusting winds, and a tail wind.NTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…NTSB ATL99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laurens, SCThe pilot's disregard for current wind conditions and his failure to maintain directional control during landing. Factors were the tailwind and wet runway surface.NTSB MIA99LA093Accident · No injuriesLimited investigationFinal reportScott A. George Jr. Fisher Celebrity · Simpsonville, SCThe unsuitable terrain encountered during the forced landing. Contributing to the accident was the total loss of engine power due to the failure of a plastic 90-degree fitting at the inlet fitting of the carburetor.NTSB MIA99LA090Accident · No injuriesLimited investigationFinal reportCessna 172P · Pelion, SCThe pilot's loss of directional control during landing roll as a result of improper recovery from a bounced landing and the subsequent excursion from the runway, collision with the adjacent terrain, and collapse of the nose landing gear.NTSB ATL99LA047Accident · No injuriesLimited investigationFinal reportBalloon Works AX-8 · Beech Island, SCThe pilot's failure to follow the balloon checklist that resulted in a ground fire that destroyed the balloon envelope.NTSB MIA99LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Charleston, SCthe total loss of engine power caused by an oil leak at the oil filter adapter, resulting in a broken connecting rod, a subsequent forced landing and impact with rough terrain.