NTSB investigations, 1992, 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\") = 1992
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") = 1992 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 ATL93LA044Accident · No injuriesLimited investigationFinal reportCessna 182A · New Ellenton, SCInadequate preflight planning and preparation by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Factors were trees in the emergency landing area.NTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.NTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.NTSB ATL93FA028Accident · 1 fatalField investigationFinal reportBeech 58 · West Columbia, SCThe pilot's continued operation with known deficient equipment, his improper descent, and his failure to perform a missed approach. A factor was the operator's inadequate surveillance of the pilot's procedures and the maintenance of the airplane.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB ATL93LA020Accident · No injuriesLimited investigationFinal reportMaule M4-210C · Pickens, SCThe pilot's failure to follow normal before takeoff procedures which included placing the propeller lever in the high RPM low pitch position. The pilot also delayed in aborting the takeoff attempt and applied hard braking which resulted in a nose over.NTSB ATL92LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Darlington, SCThe improper servicing of the airplane with contaminated fuel by the owner pilot.NTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.NTSB ATL92LA164Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Surfside Beach, SCThe failure of the main landing gear as a result of inadequate manufacturing.NTSB ATL92LA157Accident · No injuriesLimited investigationFinal reportBeech 23-B24R · Walterboro, SCThe inadequate preflight planning by the pilot in command. Factors were the soft runway, and the high density altitude which existed at the time of the attempted departure.NTSB ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB ATL92LA149Accident · No injuriesLimited investigationFinal reportCessna 182A · Aiken, SCThe pilot's diverted attention which resulted in the improper use of the elevator and inadvertent porpoise.NTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.NTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.NTSB ATL92GA121Accident · 2 fatalFinal reportEnstrom 280FX · Summerville, SCThe pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.NTSB ATL92LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Socastee, SCThe failure of the pilot to maintain proper clearance from terrain during the maneuver. Factors in the accident were the failure of the pilot to release the banner, and the excessive size of the banner.NTSB ATL92LA114Accident · No injuriesLimited investigationFinal reportHopkins, R. And M. Protech PT-2 · Landrum, SCThe failure of the pilot to maintain aircraft control during the landing attempt. Factors were the inadequate climb capability of the aircraft and the pilot's lack of familiarity with the aircraft.NTSB ATL92FA109Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Winnsboro, SCThe inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.NTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB ATL92LA089Accident · No injuriesLimited investigationFinal reportBeech 23A-19 · Orangeburg, SCThe deterioration of the exhaust muffler which resulted in an inflight fire.NTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.NTSB ATL92LA084Accident · No injuriesLimited investigationFinal reportPZL-Okecie PZL-104 Wilga 80 · Mt. Pleasant, SCThe improper flare during the touchdown phase of the approach by the pilot which exceeded the design limits of the airframe and the right landing gear assembly.NTSB ATL92LA073Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, SCThe improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…NTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.NTSB ATL92LA062Accident · Minor injuriesLimited investigationFinal reportWilliam D. Weeks Glasair I · Timmonsville, SCThe improper selection of the fuel sector valve to the off position by the pilot.NTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.NTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.NTSB ATL92LA052Accident · No injuriesLimited investigationFinal reportMooney M20C · Charleston, SCThe blocked fuel vent.NTSB ATL92FA042Accident · No injuriesField investigationFinal reportCessna T210L · Georgetown, SCThe failure of overhaul personnel to properly torque the engine case rear thru bolts.NTSB ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…