# NTSB investigations: Lycoming VO-540 series, CO

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 CEN10CA362](https://openairdocs.org/ntsb/CEN10CA362.md): Hiller UH-12E · Grand Junction, CO · Accident · Minor injuries · Data collection · Final report · Jun 25, 2010 · N9754C · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB DEN87LA204](https://openairdocs.org/ntsb/DEN87LA204.md): Bell 47J-2 · Canon City, CO · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N73265 · Substantial damage
  > The ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…
- [NTSB DEN84LA177](https://openairdocs.org/ntsb/DEN84LA177.md): Hiller UH-12E · Granby, CO · Accident · No injuries · Limited investigation · Final report · Jun 11, 1984 · N504HA · Substantial damage
  > The helicopter plt was on a reconnaissance flt to survey a hilltop landing site in mountainous terrain. When he arrived, he made a high reconnaissance pass, then began a low reconnaissance apch. He estimated the wind was from 210 deg at 10 to 15 KTS with…
- [NTSB DEN78FA058](https://openairdocs.org/ntsb/DEN78FA058.md): Hiller UH12E · Berthoud, CO · Accident · No injuries · Closed · Aug 14, 1978 · N143HA · 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" = 'CO' 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 ('41534', '41582'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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