# NTSB investigations, NY: Nose gear collapsed

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 NYC95LA150](https://openairdocs.org/ntsb/NYC95LA150.md): Cessna 172N · Stormville, NY · Accident · No injuries · Limited investigation · Final report · Jul 9, 1995 · N734CG · Substantial damage
  > The reported pothole in the runway.
- [NTSB BFO92LA078](https://openairdocs.org/ntsb/BFO92LA078.md): Cessna 150M · Middlesex, NY · Accident · Minor injuries · Limited investigation · Final report · May 27, 1992 · N8569U · Substantial damage
  > The nose over of the aircraft during landing. A factor contributing to the accident was rough terrain.
- [NTSB NYC86LA056](https://openairdocs.org/ntsb/NYC86LA056.md): Piper PA-28-140 · Frankfort, NY · Accident · No injuries · Limited investigation · Final report · Dec 29, 1985 · N9949W · Substantial damage
  > The plt diverted to Frankfort-highland en route from his original destination of utica, NY, because of IFR weather at utica. The plt stated that as the nose wheel settled to the rwy during touchdown, it dug into snow on the rwy and the acft nosed over. It was…
- [NTSB NYC83LA259](https://openairdocs.org/ntsb/NYC83LA259.md): Cessna 182N · Binghamton, NY · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N9174G · Substantial damage
  > While landing in calm wind conditions, the nose gear reportedly collapsed on touchdown.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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