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

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 NYC92LA159](https://openairdocs.org/ntsb/NYC92LA159.md): Bell 47G-3B-1 · West Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1992 · N2070P · Substantial damage
  > A yaw for unknown reason(s) which resulted in the tail rotor contacting the dirt bank and a loss of control. A factor related to the accident was the decision of the pilot to operate in close vicinity to the dirk bank.
- [NTSB NYC92LA006](https://openairdocs.org/ntsb/NYC92LA006.md): Bell 47G-3B-1 · Catawissa, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1991 · N5NH · Substantial damage
  > Pilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…

## 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" = 'PA' 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=PA

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