# NTSB investigations: Beech A36, 2002

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 MIA03LA028](https://openairdocs.org/ntsb/MIA03LA028.md): Beech A36 · Laurens, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 2002 · N12MB · Substantial damage
  > Improper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…
- [NTSB FTW03FA048](https://openairdocs.org/ntsb/FTW03FA048.md): Beech A36 · Salem, UT · Accident · 2 fatal · Field investigation · Final report · Nov 25, 2002 · N367T · Destroyed
  > The pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…
- [NTSB LAX03LA026](https://openairdocs.org/ntsb/LAX03LA026.md): Beech A36 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 2002 · N69DG · Substantial damage
  > the pilot's failure to understand his IFR clearance, which resulted in a diversion of his attention during the initial climb, and his failure to maintain control of the aircraft.
- [NTSB LAX02FA278](https://openairdocs.org/ntsb/LAX02FA278.md): Beech A36 · Grand Canyon, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2002 · N8261J · Destroyed
  > the pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…
- [NTSB FTW02FA087](https://openairdocs.org/ntsb/FTW02FA087.md): Beech A36 · Austin, TX · Accident · 2 fatal · Field investigation · Final report · Mar 1, 2002 · N7236L · Destroyed
  > The pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..

## 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 year(c."eventDate") = 2002
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151604&year=2002

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