# NTSB investigations: Beech 1900C, 2000

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 MIA00IA266](https://openairdocs.org/ntsb/MIA00IA266.md): Beech 1900C · Miami, FL · Incident · No injuries · Incident investigation · Final report · Sep 16, 2000 · N194GA · Minor damage
  > The excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…
- [NTSB MIA00IA164](https://openairdocs.org/ntsb/MIA00IA164.md): Beech 1900C · Fort Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · May 19, 2000 · N154GA · Minor damage
  > The failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…

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

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

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