# NTSB investigations: Beech A36TC, 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 ERA16FA043](https://openairdocs.org/ntsb/ERA16FA043.md): Beech A36TC · Orlando, FL · Accident · 2 fatal · Field investigation · Final report · Nov 20, 2015 · N7FG · Destroyed
  > The pilot's failure to maintain adequate airspeed while turning to join the final approach leg of the airport traffic pattern with full airplane-nose-up trim, which resulted in the airplane exceeding its critical angle of attack and experiencing an…
- [NTSB MIA87FA091](https://openairdocs.org/ntsb/MIA87FA091.md): Beech A36TC · Orlando, FL · Accident · Serious injuries · Field investigation · Final report · Feb 21, 1987 · N47EE · Substantial damage
  > Drg the takeoff roll, lgt colored smoke was seen trailing the the acft. The plt rprtd that at 100 to 200 ft AGL, the englost partial pwr. He said he checked all ctls & raised the lndg gear. Witnesses rprtd that at about that time, heavy smoke bgn trailing 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."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 ('1151603', '1151613'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151603&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.