# NTSB investigations: Cessna 172C: 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 CHI04CA121](https://openairdocs.org/ntsb/CHI04CA121.md): Cessna 172C · Fort Leavenwort, KS · Accident · No injuries · Data collection · Final report · May 15, 2004 · N1806Y · Substantial damage
  > The inadequate flare by the pilot.
- [NTSB CHI99LA030](https://openairdocs.org/ntsb/CHI99LA030.md): Cessna 172C · Falls City, NE · Accident · No injuries · Limited investigation · Final report · Nov 14, 1998 · N1806Y · Substantial damage
  > the flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.
- [NTSB FTW85LA334](https://openairdocs.org/ntsb/FTW85LA334.md): Cessna 172B · Ada, OK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N8301X · Substantial damage
  > The student plt, who had been executing touch and go landings, stated that the acft bounced on touchdown and began porpoising. The student over-corrected and the acft subsequently impacted the runway in a nose low attitude damaging the prop, nose gear and the…
- [NTSB SEA83LA047](https://openairdocs.org/ntsb/SEA83LA047.md): Cessna 172 · Payette, ID · Accident · No injuries · Limited investigation · Final report · Jan 30, 1983 · N1415Y · Substantial damage
  > The acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072408')
    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?model=2072408&occurrence=200

---
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.