# NTSB investigations: Lycoming HI0-360 series, IN

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 CHI00LA002](https://openairdocs.org/ntsb/CHI00LA002.md): Enstrom EN-28 · Indianapolis, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1999 · N602H · Substantial damage
  > The pilot's attempted operation of the helicopter with known deficiencies, and his improper autorotation to landing. Factors were one fouled spark plug and another partially failed spark plug in the same cylinder, and the construction area.
- [NTSB CHI77FA032](https://openairdocs.org/ntsb/CHI77FA032.md): Enstrom 280C · Valparaiso, IN · Accident · Minor injuries · Closed · Feb 25, 1977 · N594H · 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" = 'IN' 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 ('41553'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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