# NTSB investigations: Cessna 441, 2002

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 SEA02LA095](https://openairdocs.org/ntsb/SEA02LA095.md): Cessna 441 · Medford, OR · Accident · No injuries · Limited investigation · Final report · Jun 19, 2002 · N564AC · Substantial damage
  > The overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.
- [NTSB CHI02FA074](https://openairdocs.org/ntsb/CHI02FA074.md): Cessna 441 · Winfield, KS · Accident · 2 fatal · Field investigation · Final report · Jan 30, 2002 · N441AR · Destroyed
  > The pilot's spatial disorientation resulting in a loss of control and collision with the ground. Additional factors included the pilot operating the airplane with known deficiencies and the instrument flight conditions.
- [NTSB ATL02FA031](https://openairdocs.org/ntsb/ATL02FA031.md): Cessna 441 · Rio Grande, PR · Accident · 5 fatal · Field investigation · Final report · Jan 5, 2002 · N441AW · Destroyed
  > The pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.

## 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 year(c."eventDate") = 2002
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2076020&year=2002

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