# NTSB investigations: Beech 200, TX

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 CEN23LA052](https://openairdocs.org/ntsb/CEN23LA052.md): Beech 200 · Del Rio, TX · Accident · No injuries · Class 4 · Limited · Final report · Nov 22, 2022 · N968T · Substantial damage
  > The pilot’s failure to maintain control of the airplane that resulted in an uncontrolled descent and overstress of the airframe during his recovery of the airplane.
- [NTSB GAA20CA054](https://openairdocs.org/ntsb/GAA20CA054.md): Beech 200 · New Braunfels, TX · Accident · Serious injuries · Data collection · Final report · Oct 31, 2019 · N850BK · Minor damage
  > The airplane’s in-flight collision with a bird.
- [NTSB DFW05LA034](https://openairdocs.org/ntsb/DFW05LA034.md): Beech BE-200 · Bay View, TX · Accident · No injuries · Limited investigation · Final report · Dec 10, 2004 · N648KA · Destroyed
  > The pilot's failure to maintain directional control as result of his improper runway selection for takeoff. A contributing factor was the prevailing right quartering tailwind.
- [NTSB FTW88IA165](https://openairdocs.org/ntsb/FTW88IA165.md): Boeing 727-200 · Dfw Airport, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 22, 1988 · N710AA · Minor damage
  > Fatigue failure of the left main landing gear door actuator pivot trunnion shaft which subsequently became lodged in the actuator clevis preventing the door unlock mechanism from actuating during gear extension.

## 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" = 'TX' 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 ('1152920'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1152920&state=TX

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