# NTSB investigations: Lycoming IO-360-A1B6D, NY

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 ERA24FA001](https://openairdocs.org/ntsb/ERA24FA001.md): Cessna 177RG · Lake Placid, NY · Accident · 2 fatal · Class 3 · Field · Final report · Oct 1, 2023 · N545PZ · Substantial damage
  > A partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.
- [NTSB NYC87LA181](https://openairdocs.org/ntsb/NYC87LA181.md): Cessna 177RG · Batavia, NY · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N8021G · Substantial damage
  > The flt made an emgy lndg in a corn field after experiencing a loss of eng pwr. During lndg roll the acft collided with a fence. Examination of the propeller revealed that the low pitch stop was broken and had separated from the piston causing the blades to…
- [NTSB NYC86LA064](https://openairdocs.org/ntsb/NYC86LA064.md): Cessna 177RG · Farmingdale, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1986 · N34069 · Destroyed
  > The acft collided with trees in the bethpage state park during a rwy 14 ILS apch at republic airport, Farmingdale, NY. The plt had instructed his passenger, a private plt, to report when he had the apch lights in sight. The plt stated the apch was continued…
- [NTSB NYC81FFJ05](https://openairdocs.org/ntsb/NYC81FFJ05.md): Cessna 177RG · Barre Center, NY · Accident · No injuries · Closed · Jan 24, 1981 · N2729V · Substantial damage
- [NTSB NYC79FFA08](https://openairdocs.org/ntsb/NYC79FFA08.md): Cessna 177RG · Hartford, NY · Accident · No injuries · Closed · Jan 10, 1979 · N50016 · Substantial damage
- [NTSB NYC77DFA42](https://openairdocs.org/ntsb/NYC77DFA42.md): Cessna 177RG · Kingston, NY · Accident · No injuries · Closed · Sep 27, 1977 · N33200 · Substantial damage
- [NTSB NYC77FFJ41](https://openairdocs.org/ntsb/NYC77FFJ41.md): Cessna 177RG · Stafford, NY · Accident · No injuries · Closed · Jul 9, 1977 · N2517V · 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" = 'NY' 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 ('41593'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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