NTSB investigations, 1991, 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\") = 1991
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") = 1991 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 ATL92FA031Accident · 5 fatalField investigationFinal reportBeech 58TC · Bluffton, SCThe pilot's failure to maintain minimum controllable airspeed after a reported engine power loss, resulting in a loss of aircraft control. A factor was the loss of power on the left engine. The reason for the left engine power loss could not be determined.NTSB MIA92LA048Accident · Serious injuriesLimited investigationFinal reportPiper J-4E · Timmonsville, SCTotal loss of engine power (nonmechanical) due to inadequate fuel consumption calculation by the pilot-in-command, resulting in an engine failure due to fuel exhaustion, a forced landing, and in-flight collision with terrain.NTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.NTSB ATL91LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberry, SCThe pilot's failure to maintain visual lookout and clearance while maneuvering at a low altitude.NTSB ATL91LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, SCThe dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.NTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.NTSB ATL91LA171Accident · No injuriesLimited investigationFinal reportCessna 150L · Pickens, SCThe panicked, intentional interference of the flight controls by the student.NTSB ATL91LA152Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Manning, SCThe pilot's failure to maintain directional control during the takeoff roll, and his failure to abort the takeoff in a timely manner once the airplane had departed the runway surface. A factor in the accident was the pilot's failure to utilize the entire…NTSB ATL91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Spartanburg, SCThe pilot's failure to follow the checklist and extend the landing gear prior to touchdown.NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.NTSB ATL91LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Little River, SCThat the pilot dragged the right wing tip on final approach when he failed to control the aircraft. Factors to this accident were: a wind shift below the treetops.NTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…NTSB ATL91LA096Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Rock Hill, SCThe pilot diverted his attention to a poisonous snake in the cockpit and failed to maintain control of the aircraft.NTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.NTSB ATL91LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Greer, SCThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).