# NTSB investigations: Cessna 337A: 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 CHI88LA030](https://openairdocs.org/ntsb/CHI88LA030.md): Cessna 337 · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1987 · N6255F · Substantial damage
  > The pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to…
- [NTSB DEN85LA080](https://openairdocs.org/ntsb/DEN85LA080.md): Cessna 337 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Feb 17, 1985 · N6381F · Substantial damage
  > The acft landed gear up during a practice of touch and go landings. The private plt changed his choice of rwys during the approach. In a post accident interview he stated that he raised the lndg gear & forgot to re-extend it after wstablishing a new approach…
- [NTSB ATL84FA241](https://openairdocs.org/ntsb/ATL84FA241.md): Cessna 337A · Ocean Springs, MS · Accident · Serious injuries · Field investigation · Final report · Aug 3, 1984 · N90244 · Destroyed
  > The acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…

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