# NTSB investigations: Hemp Timothy LEGACY 2000

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 CEN12FA174](https://openairdocs.org/ntsb/CEN12FA174.md): Hemp Timothy Legacy 2000 · Belen, NM · Accident · 2 fatal · Field investigation · Final report · Mar 1, 2012 · N273TE · Destroyed
  > The pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…
- [NTSB CEN09CA046](https://openairdocs.org/ntsb/CEN09CA046.md): Hemp Timothy Legacy 200 · Socorro, NM · Accident · No injuries · Data collection · Final report · Nov 2, 2008 · N273TE · Substantial damage
  > Failure of the pilot to land with sufficient runway to stop the airplane on the runway. Contributing to the accident was the airplane's speed on final approach.

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

This list as a web page: https://openairdocs.org/ntsb?model=056113I

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