# NTSB investigations: Beech A100: 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 FTW02LA172](https://openairdocs.org/ntsb/FTW02LA172.md): Beech BE-100-A100 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jun 5, 2002 · N799DD · Substantial damage
  > The malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.
- [NTSB NYC89LA103](https://openairdocs.org/ntsb/NYC89LA103.md): Beech A100 · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · Mar 22, 1989 · N23605 · Substantial damage
  > Failure of the down lock plate, which allowed the landing gear to collapse.
- [NTSB MIA87LA027](https://openairdocs.org/ntsb/MIA87LA027.md): Beech A100 · Brooksville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1986 · N78L · Destroyed
  > The pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…

## 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 ('1152915')
    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=1152915&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.