NTSB investigations, 2021, SC
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2021
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") = 2021 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 ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB ERA22FA047Accident · 1 fatalClass 3 · FieldFinal reportPiper PA30 · Rock Hill, SCThe pilot’s exceedance of the airplane's critical angle of attack while troubleshooting a landing gear indication, which resulted in an aerodynamic stall at low altitude.NTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.NTSB ERA22FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Walterboro, SCThe pilot’s inadequate fuel planning and fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA22LA025Accident · Serious injuriesClass 4 · LimitedFinal reportPipistrel Apis-Bee · Columbia, SCThe pilot’s failure to maintain control of the glider during the landing approach, which resulted in an aerodynamic stall and subsequent impact with the runway.NTSB ERA22LA019Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Mount Pleasant, SCThe pilot’s failure to maintain clearance with the parked fuel truck while taxiing for takeoff. Contributing to the outcome was the pilot’s decision to park the airplane in the congested ramp area and his excessive taxi speed.NTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB ERA22LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Columbia, SCA failure of the landing gear hydraulic power pack for reasons that could not be determined.NTSB ERA21LA379Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft 400A · Charleston, SCThe in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.NTSB ERA21LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Spartanburg, SCThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA21LA316Accident · No injuriesClass 3 · LimitedFinal reportSocata TBM-700 C2 · Mount Pleasant, SCThe pilot’s decision to continue an unstable approach, which resulted in a runway excursion.NTSB ERA21LA280Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Bishopville, SCThe flight instructor’s inadequate supervision of the student during a go-around, which resulted in a loss of lift and a subsequent collision with the VASI lights.NTSB ERA21FA224Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-31P · Myrtle Beach, SCThe mechanic’s inadvertent installation of the elevator trim tabs in reverse, which resulted in the pitch trim system operating opposite of the pilot’s input and the pilot’s subsequent loss of control.NTSB ERA21LA208Accident · No injuriesClass 3 · LimitedFinal reportIsrael Aerospace Industries Gulfstream G150 · Ridgeland, SCThe flight crew’s continuation of an unstable approach and the failure of the ground air brakes to deploy upon touchdown, both of which resulted in the runway overrun. Contributing was the crew’s motivation and response to external pressures to complete the…NTSB ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.NTSB ERA21LA192Accident · Serious injuriesClass 3 · LimitedFinal reportMeyeres F L/Meyeres M M Skystar Ktfox Clsc 4 · Mountain Rest, SCA partial loss of engine power due to carburetor icing. Contributing to the accident was the engine’s lack of carburetor heat.NTSB ERA21LA395Accident · Serious injuriesClass 4 · LimitedFinal reportSchempp Hirth Ventus C · Wagener, SCImpact with trees during a forced landing in atmospheric lift conditions that were insufficient to maintain flight. Contributing was the pilot’s delayed decision to return to the airport.NTSB ERA21LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Orangeburg, SCThe student pilot’s improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA21LA172Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics Phantom II · McBee, SCThe pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.NTSB ERA21LA125Accident · Minor injuriesClass 3 · LimitedFinal reportTaylorcraft BC-65 · Columbia, SCA total loss of engine power due to carburetor icing, which resulted from the student pilot’s failure to use carburetor heat.NTSB ERA21LA115Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 300 · Myrtle Beach, SCAn encounter with severe turbulence, which resulted in serious injury to an unseated passenger.NTSB ERA21LA101Accident · 1 fatalClass 3 · LimitedFinal reportBeech F33 · Columbia, SCThe pilot's in-flight loss of airplane control due to spatial disorientation during a missed approach in instrument meteorological conditions.