# NTSB investigations: Beech 1900D, FL

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 MIA96IA109](https://openairdocs.org/ntsb/MIA96IA109.md): Beech 1900D · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Mar 28, 1996 · N29YV · Minor damage
  > Failure of a blade counterweight clamp retaining screw due to cadmium embrittlement which occurred during the manufacture process. This resulted in the counterweight clamp separating and striking the adjacent blade causing it to separate.
- [NTSB MIA93LA044](https://openairdocs.org/ntsb/MIA93LA044.md): Beech 1900D · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Jan 3, 1993 · N18YV · Substantial damage
  > Failure of the pilot-in-command to follow the checklist and complacency of the pilot-in-command for failure to extend the landing gear before landing.

## 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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  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&state=FL

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