NTSB investigations, SC
22 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1988 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 1 |
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 c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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 c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) 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 ATL04CA184Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mount Pleasant, SCGround collision with an animal (deer) during an attempted takeoff.NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.NTSB ATL02LA029Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · Greenville, SCThe tug driver's failure to maintain control of the airplane during pushback resulting in the tug colliding with the airplane. A factor was ice on the ramp.NTSB MIA01LA135Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Greenville, SCThe failure of the pilot to obtain the assistance of a person to act as a safety pilot while hand propping the engine with the airplane tied down. A factor in the accident was the failure of the tie down rope.NTSB ATL00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-200 · Mt. Pleasant, SCThe airplane collision with a deer during a night landing.NTSB MIA98LA086Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Lake Murray, SCA collision with an unknown submerged.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 ATL97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bennettsville, SCfailure of the pilot to properly plan his approach, and his failure to attain a proper touchdown point for landing.NTSB MIA96LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Georgetown, SCfailure of the pilot to see-and-avoid an obstruction on the ground (inadequate visual lookout) during a precautionary landing, which resulted in a collapsed nose gear and subsequent nose over. Factors relating to the accident were: the adverse weather…NTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.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 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 ATL89LA201Accident · No injuriesLimited investigationFinal reportBeech A-36 · Charleston, SCThe pilot's failure to maintain clearance from other parked aircraft while taxiing.NTSB ATL88LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any…NTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…NTSB ATL88LA093Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Spartanburg, SCWhen the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall.NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…NTSB ATL83LA026Accident · No injuriesLimited investigationFinal reportCessna 172N · Loris, SCWhile taxiing from ramp left wingtip struck a van parked in the tie-down area.NTSB ATL83LA015Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · N. Myrtle Beach, SCThe pilot set the parking brake after starting the aircraft and diverted his attention to the checklist. When he looked up the aircraft was moving. The pilot attempted to stop the aircraft by both pushing the toe brakes and pulling the parking brake. The…NTSB ATL82DA213Accident · No injuriesFinal reportSchweizer SGS-2-33A · Little River, SCDuring the landing roll, the left wing of the glider struck the left wing of another glider of the same make and model. The other glider, N1211S was being readed for a flight and was positioned with its left wing overlapping the runway. The pilot of N1211S…NTSB ATL82FLG11Accident · No injuriesFinal reportPiper PA-34-200J · Columbia, SCAfter landing at night, the pilot was cleared to a parking area. A lineman with wands responded to assist. While attempting to follow the signals from the lineman, the pilot taxied into another aircraft.