# NTSB investigations: Nord 3202

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 CEN10CA421](https://openairdocs.org/ntsb/CEN10CA421.md): Nord 3202 · Oshkosh, WI · Accident · No injuries · Data collection · Final report · Jul 19, 2010 · N2256Y · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll.
- [NTSB LAX06LA016](https://openairdocs.org/ntsb/LAX06LA016.md): Nord 3202 · Casa Grande, AZ · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 2005 · N22532 · Substantial damage
  > the pilot's failure to maintain airspeed during a low-altitude evasive maneuver away from another airplane, which resulted in a stall and uncontrolled descent.
- [NTSB LAX87LA244](https://openairdocs.org/ntsb/LAX87LA244.md): Nord 3202 · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1987 · N32RM · Substantial damage
  > During a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail…

## 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 ('6383202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=6383202

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