# NTSB investigations: Beech 95-A55: Airframe/component/system failure/malfunction

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 LAX85FA006](https://openairdocs.org/ntsb/LAX85FA006.md): Beech 95-A55 · Newport Beach, CA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1984 · N9572Y · Destroyed
  > Shortly after takeoff, the propeller separated from the aircraft's left engine. The aircraft continued to climb straight ahead and was then observed in s steep left turn during which it descended and crashed into the roof of a building approximately one…
- [NTSB MIA84IA074](https://openairdocs.org/ntsb/MIA84IA074.md): Beech 95-A55 · Opa Locka, FL · Incident · No injuries · Incident investigation · Final report · Feb 11, 1984 · N9707Y · Minor damage
  > The acft was intentionally landed with the landing gear retracted when the lt main gear could not be extended. Inspection of the acft revealed that the spring which pulls the lt main gear uplock out of the way when released had become disconnected from the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152704')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1152704&occurrence=130

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