# NTSB investigations: Beech 1900D, 2003

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 NYC03MA183](https://openairdocs.org/ntsb/NYC03MA183.md): Beech 1900D · Yarmouth, MA · Accident · 2 fatal · Major investigation · Final report · Aug 26, 2003 · N240CJ · Destroyed
  > The improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…
- [NTSB CHI03LA276](https://openairdocs.org/ntsb/CHI03LA276.md): Beech 1900D · Muskegon, MI · Accident · No injuries · Limited investigation · Final report · Aug 20, 2003 · N79SK · Substantial damage
  > The airplane colliding with a deer during the landing roll.
- [NTSB CHI03IA153](https://openairdocs.org/ntsb/CHI03IA153.md): Beech 1900D · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Jun 7, 2003 · N901SK · Minor damage
  > Failure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…
- [NTSB DCA03MA022](https://openairdocs.org/ntsb/DCA03MA022.md): Beech 1900D · Charlotte, NC · Accident · 21 fatal · Class 1 · Major · Final report · Jan 8, 2003 · N233YV · Destroyed
  > the airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…

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

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

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