# NTSB investigations: Bell 47D1, TX

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 FTW89DPA03](https://openairdocs.org/ntsb/FTW89DPA03.md): Bell 47-D1 · Allen, TX · Accident · Serious injuries · Final report · Dec 2, 1988 · N74124 · Substantial damage
  > Unqualified pilot's poor judgement in leveling the helicopter during the flare and contributing to this was his lack of total experience in this type aircraft.
- [NTSB FTW85LA043](https://openairdocs.org/ntsb/FTW85LA043.md): Bell 47D1 · Terlingua, TX · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N93067 · Substantial damage
  > Shortly after the plt took off on a sight-seeing flt, the eng lost power when the helicopter was over rough terrain at about 200 ft AGL. During an autorotative landing, the helicopter rocked forward causing the main rotor blades to strike the tail boom.…
- [NTSB FTW81FA045](https://openairdocs.org/ntsb/FTW81FA045.md): Bell 47D1 · Roanoke, TX · Accident · Minor injuries · Closed · Feb 10, 1981 · N9736Z · Substantial damage
- [NTSB FTW77FRA15](https://openairdocs.org/ntsb/FTW77FRA15.md): Bell 47D1 · Houston, TX · Accident · No injuries · Closed · Mar 8, 1977 · N929B · Substantial damage
- [NTSB FTW77FRA13](https://openairdocs.org/ntsb/FTW77FRA13.md): Bell 47D1 · Houston, TX · Accident · No injuries · Closed · Feb 27, 1977 · N9736Z · Substantial damage
- [NTSB FTW76FPA15](https://openairdocs.org/ntsb/FTW76FPA15.md): Bell 47D-1 · Irving, TX · Accident · No injuries · Closed · Dec 7, 1975 · N5226 · Substantial damage
- [NTSB FTW74DRA03](https://openairdocs.org/ntsb/FTW74DRA03.md): Bell 47D1 · Sealey, TX · Accident · Minor injuries · Closed · Jul 13, 1973 · N9713C · Substantial damage
- [NTSB FTW73FPD37](https://openairdocs.org/ntsb/FTW73FPD37.md): Bell 47D1 · Decatur, TX · Accident · No injuries · Closed · May 21, 1973 · N74121 · Substantial damage
- [NTSB FTW72DPD40](https://openairdocs.org/ntsb/FTW72DPD40.md): Bell 47D1 · Glen Rose, TX · Accident · No injuries · Closed · May 8, 1972 · N74121 · Substantial damage
- [NTSB FTW71FRA65](https://openairdocs.org/ntsb/FTW71FRA65.md): Bell 47D1 · Alvin, TX · Accident · No injuries · Closed · Jun 14, 1971 · N9713C · Substantial damage
- [NTSB FTW70FPA07](https://openairdocs.org/ntsb/FTW70FPA07.md): Bell 47D1 · Howe, TX · Accident · No injuries · Closed · Mar 4, 1970 · N74121 · Substantial damage
- [NTSB FTW70FRG10](https://openairdocs.org/ntsb/FTW70FRG10.md): Bell 47D1 · Randolph Afb, TX · Accident · No injuries · Closed · Feb 14, 1970 · N4229A · Substantial damage
- [NTSB FTW69F0392](https://openairdocs.org/ntsb/FTW69F0392.md): Bell 47D1 · Denton, TX · Accident · No injuries · Closed · Feb 25, 1969 · N9115R · Substantial damage
- [NTSB FTW67A0105](https://openairdocs.org/ntsb/FTW67A0105.md): Bell 47D1 · Irving, TX · Accident · No injuries · Closed · Apr 24, 1967 · N12512 · Substantial damage
- [NTSB FTW66A0070](https://openairdocs.org/ntsb/FTW66A0070.md): Bell 47G · Wetmore, TX · Accident · Minor injuries · Closed · Feb 10, 1966 · N586T · 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."eventStateOrRegion" = 'TX' 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 ('1180802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1180802&state=TX

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