# NTSB investigations: Hamburger Flugzeugbau HFB 320 HANSA

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 CHI05FA038](https://openairdocs.org/ntsb/CHI05FA038.md): Hamburger Flugzeugbau HFB 320 Hansa · Chesterfield, MO · Accident · 2 fatal · Field investigation · Final report · Dec 1, 2004 · N604GA · Destroyed
  > The maintenance facility failed to properly install and inspect the elevator trim system resulting in the reversed elevator trim condition and the pilot's failure to maintain clearance with the terrain. Contributing factors included the dark night and low…
- [NTSB DEN85FA002](https://openairdocs.org/ntsb/DEN85FA002.md): Hamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SD · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1984 · N127MW · Destroyed
  > The hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…
- [NTSB MIA79FLD98](https://openairdocs.org/ntsb/MIA79FLD98.md): Ham-Flugzeu HFB320 · Tampa, FL · Accident · Minor injuries · Closed · Sep 18, 1979 · N111DC · Substantial damage
- [NTSB LAX73AL043](https://openairdocs.org/ntsb/LAX73AL043.md): Ham-Flugzeu HFB320 · Phoenix, AZ · Accident · No injuries · Closed · Mar 9, 1973 · N320MC · Substantial damage

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

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

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