# NTSB investigations: Cessna 182, 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 NYC87LA148](https://openairdocs.org/ntsb/NYC87LA148.md): Cessna 182 · Honeoye Falls, NY · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N6298A · Substantial damage
  > The acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…
- [NTSB NYC86LA036](https://openairdocs.org/ntsb/NYC86LA036.md): Cessna C182 · Gardiner, NY · Accident · No injuries · Limited investigation · Final report · Nov 17, 1985 · N5634B · Substantial damage
  > The acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.…
- [NTSB NYC74FFA19](https://openairdocs.org/ntsb/NYC74FFA19.md): Cessna 182 · Ellenville, NY · Accident · No injuries · Closed · Feb 5, 1974 · N6432A · Destroyed
- [NTSB NYC70D0146](https://openairdocs.org/ntsb/NYC70D0146.md): Cessna 182 · Lockport, NY · Accident · No injuries · Closed · Mar 23, 1969 · N5624B · 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.aircraft_model_code IN ('2072702'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072702&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.