# NTSB investigations: Lycoming TVO-435-GIA, NM

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 DEN86LA119](https://openairdocs.org/ntsb/DEN86LA119.md): Bell 47G-3B-2 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N4073G · Substantial damage
  > According to the student plt, he was attempting to hover the helicopter when he encountered turbulence. The student plt stated that the hard landing which followed resulted in spreading the skids & severing the tailboom.
- [NTSB FTW80FA090](https://openairdocs.org/ntsb/FTW80FA090.md): Bell 47G3B1 · Mescalero, NM · Accident · Serious injuries · Closed · Jul 10, 1980 · N73972 · Destroyed
- [NTSB DEN80FA005](https://openairdocs.org/ntsb/DEN80FA005-201189.md): Soloy 47G · Ruidoso, NM · Accident · 1 fatal · Closed · Oct 23, 1979 · N7828S · Destroyed
- [NTSB DEN79FA065](https://openairdocs.org/ntsb/DEN79FA065.md): Bell 47G · Deming, NM · Accident · 1 fatal · Closed · Sep 20, 1979 · N2220W · Destroyed
- [NTSB DEN75DQA29](https://openairdocs.org/ntsb/DEN75DQA29.md): Bell 47G-3B · Dexter, NM · Accident · No injuries · Closed · Jan 29, 1975 · N73248 · Substantial damage
- [NTSB DEN75FQA24](https://openairdocs.org/ntsb/DEN75FQA24.md): Bell 47G3B2 · Albuquerque, NM · Accident · Serious injuries · Closed · Dec 17, 1974 · N4730R · Substantial damage
- [NTSB DEN75FQD06](https://openairdocs.org/ntsb/DEN75FQD06.md): Bell 47G3B2 · Mesquite, NM · Accident · No injuries · Closed · Jul 29, 1974 · N4730R · Substantial damage
- [NTSB DEN74DQA42](https://openairdocs.org/ntsb/DEN74DQA42.md): Bell 47G3B2 · Farmington, NM · Accident · No injuries · Closed · Apr 30, 1974 · N58131 · Substantial damage
- [NTSB DEN74DQA06](https://openairdocs.org/ntsb/DEN74DQA06.md): Bell 47G3B2 · Luna, NM · Accident · No injuries · Closed · Jul 11, 1973 · N58131 · Substantial damage
- [NTSB DEN73AD055](https://openairdocs.org/ntsb/DEN73AD055.md): Bell 4G3B2A · Luna, NM · Accident · 1 fatal · Closed · Jun 19, 1973 · N83111 · Substantial damage
- [NTSB DEN73FQA46](https://openairdocs.org/ntsb/DEN73FQA46.md): Bell 47G-3B · Cuba, NM · Accident · No injuries · Closed · Jun 13, 1973 · N4727R · Substantial damage
- [NTSB DEN72FQA31](https://openairdocs.org/ntsb/DEN72FQA31.md): Bell 47G3B1 · Raton, NM · Accident · Serious injuries · Closed · Jan 10, 1972 · N665GD · Destroyed
- [NTSB DEN72FQD18](https://openairdocs.org/ntsb/DEN72FQD18.md): Bell 47G3B1 · Hollomn Afb, NM · Accident · No injuries · Closed · Dec 15, 1971 · N1382X · Substantial damage
- [NTSB DEN72FQD08](https://openairdocs.org/ntsb/DEN72FQD08.md): Bell 47G3B1 · Ruidoso, NM · Accident · No injuries · Closed · Aug 31, 1971 · N1333X · Substantial damage
- [NTSB DEN70D0132](https://openairdocs.org/ntsb/DEN70D0132.md): Bell 47G-3B · Alamogordo, NM · Accident · No injuries · Closed · Nov 20, 1969 · N73995 · Substantial damage
- [NTSB DEN67A0037](https://openairdocs.org/ntsb/DEN67A0037.md): Bell 47G3B1 · Holloman Ab, NM · Accident · Minor injuries · Closed · Dec 16, 1966 · N1362X · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?engine=41526&state=NM

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