# NTSB investigations: Cessna 172I: 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 CHI94LA261](https://openairdocs.org/ntsb/CHI94LA261.md): Cessna 172 · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Aug 2, 1994 · N35790 · Substantial damage
  > the pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.
- [NTSB MKC85LA222](https://openairdocs.org/ntsb/MKC85LA222.md): Cessna 172I · Cameron, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1985 · N46175 · Substantial damage
  > The pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to…
- [NTSB CHI83LA435](https://openairdocs.org/ntsb/CHI83LA435.md): Cessna 172 · Plymouth, MI · Accident · No injuries · Limited investigation · Final report · Sep 13, 1983 · N46188 · Substantial damage
  > The plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…

## 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 ('2072426')
    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=2072426&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.