NTSB investigations, SC
37 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2007 | 2 |
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\" = 200)
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" = 200) 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 NYC07CA220Accident · No injuriesData collectionFinal reportEurocopter AS-350B2 · Greenville, SCThe pilot's failure to maintain a proper descent rate during a precautionary landing, which resulted in a settling with power condition and a subsequent hard landing.NTSB ATL07LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Columbia, SCThe pilot's improper landing flare, resulting in a hard landing.NTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.NTSB ATL04LA037Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Greenville, SCThe pilot's improper landing flare, resulting in a hard landing and a main rotor/tailboom strike.NTSB ATL03LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe pilot's improper flare and recovery from a bounced landing.NTSB MIA02LA155Accident · Serious injuriesLimited investigationFinal reportBarnes Vans RV-6 · Chesnee, SCthe pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.NTSB MIA01LA014Accident · Minor injuriesLimited investigationFinal reportCraig R. Merrill Luton Beta · Ridgeland, SCThe pilot's failure to maintain airspeed on final approach resulting in the aircraft settling fast, touching down hard, and colliding with an embankment on the side of the runway, where it came to rest inverted.NTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.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 ATL97LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Anderson, SCThe pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB ATL95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Luray, SCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL94LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · W. Columbia, SCThe student pilot's failure to properly flare the aircraft, resulting in a hard landing.NTSB ATL94LA146Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Greenville, SCThe pilot's failure to properly flare the aircraft during landing, resulting in a hard landing.NTSB ATL94LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Barnwell, SCThe pilot's failure to flare properly which resulted in a hard landing.NTSB ATL93LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Myrtle Beach, SCThe pilot's improper compensation for wind conditions during the approach and landing. Factors were the gusts, turbulence, and tailwind conditions at the landing site.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 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 ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.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 ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.NTSB ATL90LA101Accident · No injuriesLimited investigationFinal reportCessna 177B · Spartanburg, SCThe pilot's improper flare and improper recovery from a bounced landing.NTSB ATL89LA176Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Holly Hill, SCPilot misjudged his landing approach path and crossed the runway threshold too high to safely complete the landing. He also flared the airplane at too high an altitude resulting in a stall to a hard touchdown on the nose wheel exceeding the structural…NTSB ATL89LA109Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pickens, SCImproper flare by the pilot and inadequate supervision of the flight by the other crew member.NTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…NTSB ATL88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mccormick, SCThe student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to…NTSB ATL88LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, SCThe student plt rptd that the airplane was low on final appch, and that he applied pwr to maintain altitude. After crossing the rwy threshold, he reduced the pwr to idle & lowered the nose to maintain airspeed. He initiated a flare prior to touchdown, but the…NTSB ATL88LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Hilton Head, SCThe student plt was performing a crosswind landing which resulted in a hard landing. The acft drifted to the side of the rwy and one wheel was off the paved surface upon the next touchdown. The student plt attempted to hold the acft straight in the direction…NTSB ATL87LA192Accident · No injuriesLimited investigationFinal reportNavion H · New Ellenton, SCPreviously, the acft had been involved in a gear-up lndg & was out of svc while it was being repaired. Drg that time the annual inspn expired. A special airworthiness certificate was obtained to ferry the acft to the sizemore arpt for the annual inspn. Drg…NTSB ATL87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Belton, SCThe pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface…NTSB ATL85LMG07Accident · No injuriesFinal reportCessna 172N · Anderson, SCThe plt reported that the acft encountered a gust of wind as he was landing & the nose went up. Subsequently, the acft landed hard & was damaged.NTSB ATL85LA212Accident · No injuriesLimited investigationFinal reportCessna 182C · Lugoff, SCThe plt transported a load of skydivers to alt & was returning to the airstrip. During arrival, he decided to practice a simulated eng out landing. While on an apch with full flaps, the plt elected to slip the acft. As he was transitioning from a side slip to…NTSB ATL85LA006Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Abbeville, SCRight main tire blew during a hard landing. Plt applied left brake and rudder but acft continued off right side of rwy. Acft skidded across a pile of debris which initiated a flash fire in the underbrush. The right main gear assembly was broken from the acft…NTSB ATL83LA154Accident · No injuriesLimited investigationFinal reportCessna 152B · Conway, SCThe acft bounced during a hard landing and stalled about 10 feet AGL. The second contact with the runway occurred with the nose gear first. The nose gear then collapsed. This was a training flight with a solo student pilot as pilot in command. The weather was…NTSB ATL83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hampton, SCThe left main landing gear of the aircraft collapsed during a hard landing. The pilot stated that he cleared tall pine trees north of the runway at about 90 mhp (78 KTS). Shortly thereafter the aircraft started to sink 'real fast'. The pilot stated that he…NTSB ATL83LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot stated he attempted to land beyond the mid-point of the runway from a high threshold position with full flaps deployed. The aircraft was forced onto the runway, bounced 3 times, and the nose gear collapsed.NTSB ATL82DLG12Accident · No injuriesFinal reportBell-Cont 42G EL TOMCAT-MK5A · Oswego, SCThe purpose of the flight was to study cotton fields that the pilot had been assigned to spray in the near future. He stated that during a landing approach on a farm field road, a wasp landed on his left arm and started stinging. The pilot allowed the rotor…