# NTSB investigations: Lycoming 0-320 series, SC: Hard landing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB MIA02LA155](https://openairdocs.org/ntsb/MIA02LA155.md): Barnes Vans RV-6 · Chesnee, SC · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 2002 · N190TB · Substantial damage
  > the pilot misjudged the landing flare, resulting in a hard landing, loss of directional control, and damage to the airplane.
- [NTSB ATL97LA032](https://openairdocs.org/ntsb/ATL97LA032.md): Cessna 172N · Anderson, SC · Accident · No injuries · Limited investigation · Final report · Jan 2, 1997 · N1445E · Substantial damage
  > The pilot's improper recovery from a bounced landing. A factor was the pilot's improper level off.
- [NTSB ATL94LA091](https://openairdocs.org/ntsb/ATL94LA091.md): Cessna 172M · Barnwell, SC · Accident · No injuries · Limited investigation · Final report · Apr 14, 1994 · N61990 · Substantial damage
  > The pilot's failure to flare properly which resulted in a hard landing.
- [NTSB ATL88LA001](https://openairdocs.org/ntsb/ATL88LA001.md): Cessna 172P · Hilton Head, SC · Accident · No injuries · Limited investigation · Final report · Oct 3, 1987 · N66090 · Destroyed
  > The 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 ATL85LMG07](https://openairdocs.org/ntsb/ATL85LMG07.md): Cessna 172N · Anderson, SC · Accident · No injuries · Final report · Sep 7, 1985 · N737LH · Substantial damage
  > The 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.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41508&occurrence=200&state=SC

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.