NTSB investigations, 1998, 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\") = 1998
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") = 1998 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 ATL99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aiken, SCThe pilot's failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.NTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.NTSB ATL99LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lima, SCThe flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.NTSB ATL99LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnsboro, SCThe pilot's improper landing flare that resulted in overload damage to the nose wheel assembly.NTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.NTSB ATL99LA005Accident · No injuriesLimited investigationFinal reportCessna 188 · Patrick, SCThe failure of the number 2 piston for undetermined reasons.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB MIA98FA250Accident · 5 fatalField investigationFinal reportPiper Aerostar 600 · N. Myrtle Beach, SCThe pilot's failure to maintain airspeed (Vs) during a single engine approach resulting in an inadvertent stall. Factors contributing to the accident were a fatigue crack in the exhaust pipe in the right engine, the aircraft weight and balance was exceeded,…NTSB MIA98LA245Accident · Serious injuriesLimited investigationFinal reportWood Glasair SH2 · Holly Hill, SCThe pilot's failure to maintain airspeed, and his failure to perform a go-around. The pilot's misjudgment of speed and distance during the landing is a contributing factor.NTSB MIA98LA240Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Winnsboro, SCThe loss of engine power for undetermined reasons.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB MIA98LA227Accident · No injuriesLimited investigationFinal reportMooney M-20F · Rockhill, SCThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB MIA98LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Conway, SCThe total failure of the left wing forward and aft attachment fitting due to corrosion and fatigue during a banner tow pick-up resulting in a subsequent in-flight collision with terrain.NTSB ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.NTSB ATL98LA090Accident · Minor injuriesLimited investigationFinal reportMbb Phoebus C · Perry, SCThe pilot's loss of control during takeoff, leading to an in-flight collision with the ground. A factor was the pilot's lack of recent experience in a high performance glider.NTSB MIA98LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe pilot's delay in initiating a go-around, which resulted in an inflight collision with power lines.NTSB MIA98FA187Accident · 1 fatalField investigationFinal reportMooney M-20E · Pickens, SCA loss of engine power for undetermined reasons and the pilot not maintaining adequate clearance with objects (trees) during the emergency landing. Contributing factors were the pilot's impairment associated with the use of an antihistamine and the trees.NTSB MIA98LA167Accident · No injuriesLimited investigationFinal reportNorth American T-28B · Spartanburg, SCThe pilot's misjudgment of speed and distance, and his delay in the use of brakes. Contributing to the accident was a thunderstorm, a wet runway, the pilot's self-induced pressure, and his inadequate inflight planning/decision.NTSB MIA98LA166Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Sumter, SCThe partial failure of the oil cooler bypass valve which resulted in the over-temperature and loss of oil pressure.NTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…NTSB MIA98LA146Accident · No injuriesLimited investigationFinal reportCessna 172RG · Greenville, SCThe pilot's use of full flaps while landing in a strong crosswind resulting in loss of directional control during the landing roll.NTSB MIA98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Beaufort, SCThe partial loss of engine power for undetermined reasons.NTSB MIA98FA121Accident · 2 fatalField investigationFinal reportRockwell GA-112TC · Allendale, SCthe pilot inadvertently entered instrument meteorological conditions, failed to maintain control of the airplane, and the airplane subsequently impacted the ground. Factors in this accident were fog, low ceilings and a dark night. An additional factor was the…NTSB MIA98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCthe pilot-in-command's failure to maintain directional control after landing.NTSB MIA98LA086Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Lake Murray, SCA collision with an unknown submerged.NTSB MIA98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Graniteville, SCfailure of the number three exhaust valve, which resulted in loss of engine power and a forced landing. Related factors were: the obstructions (earthen embankment and fence) in the emergency (forced) landing area.NTSB MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB ATL98LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Laurens, SCThe pilot's inadequate weather evaluation that resulted in initiating flight in marginal visual conditions, and resulted in fuel exhaustion.