# NTSB investigations: Aircraft Mfg & Development CH 2000, 2004

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 LAX05LA083](https://openairdocs.org/ntsb/LAX05LA083.md): Aircraft Mfg & Dev. CH-2000 · Jean, NV · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2004 · N285AM · Minor damage
  > an in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…
- [NTSB DEN05CA018](https://openairdocs.org/ntsb/DEN05CA018.md): Aircraft Mfg & Dev. CH 2000 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Nov 2, 2004 · N8504G · Substantial damage
  > the dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.
- [NTSB DEN04LA090](https://openairdocs.org/ntsb/DEN04LA090.md): Aircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Jun 14, 2004 · N8502F · Substantial damage
  > the pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.
- [NTSB ATL04LA087](https://openairdocs.org/ntsb/ATL04LA087.md): Aircraft Mfg & Development Alarus CH2T · Bay Minette, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2004 · N605AM · Substantial damage
  > The pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.

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

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

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