# NTSB investigations: Cessna 172, 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 GAA17CA018](https://openairdocs.org/ntsb/GAA17CA018.md): Cessna 172 · Argyle, NY · Accident · Minor injuries · Data collection · Final report · Oct 8, 2016 · N3943F · Substantial damage
  > The pilot’s failure to maintain a stable descent rate and his improper landing flare, which resulted in a hard landing.
- [NTSB ERA11CA331](https://openairdocs.org/ntsb/ERA11CA331.md): Cessna 172 · Ghent, NY · Accident · Serious injuries · Data collection · Final report · Jun 8, 2011 · N8895B · Substantial damage
  > The pilot's delayed decision to abort the landing and execute a go-around.
- [NTSB NYC07CA069](https://openairdocs.org/ntsb/NYC07CA069.md): Cessna 172 · Utica, NY · Accident · No injuries · Data collection · Final report · Feb 25, 2007 · N7141A · Substantial damage
  > The pilot's failure to maintain directional control of the airplane, during an aborted takeoff, which resulted in a collision with a snowbank.
- [NTSB IAD99LA067](https://openairdocs.org/ntsb/IAD99LA067.md): Cessna 172 · Honeoye Falls, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1999 · N6941A · Substantial damage
  > the pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.
- [NTSB NYC89LA120](https://openairdocs.org/ntsb/NYC89LA120.md): Cessna 172 · So. Bethlehem, NY · Accident · No injuries · Limited investigation · Final report · Apr 17, 1989 · N6105E · Substantial damage
  > The pilots misjudgement of landing distance which resulted in the failure to touchdown at a proper touchdown point. The pilot also failed to perform a go-around.
- [NTSB NYC83LA199](https://openairdocs.org/ntsb/NYC83LA199.md): Cessna 172 · Easton, NY · Accident · No injuries · Limited investigation · Final report · Aug 2, 1983 · N3943F · Substantial damage
  > The plt reported that during landing the brakes locked & the acft then hit two bumps in the rwy & ballooned. The acft then skidded off the end of the rwy, collided with a plowed furrow & flipped inverted.
- [NTSB CHI81FA013](https://openairdocs.org/ntsb/CHI81FA013.md): Cessna 172M · Ithaca, NY · Accident · 1 fatal · Closed · Dec 29, 1980 · N5161R · Destroyed
- [NTSB NYC80DFA22](https://openairdocs.org/ntsb/NYC80DFA22.md): Cessna 172 · Saranac Inn, NY · Accident · Serious injuries · Closed · Aug 1, 1980 · N6935A · Destroyed
- [NTSB NYC80FA015](https://openairdocs.org/ntsb/NYC80FA015.md): Cessna 172 · Washingtnville, NY · Accident · 1 fatal · Closed · Dec 16, 1979 · N6647A · Destroyed
- [NTSB NYC79FHM09](https://openairdocs.org/ntsb/NYC79FHM09.md): Cessna 172 · Spring Valley, NY · Accident · No injuries · Closed · Feb 6, 1979 · N6965A · Substantial damage
- [NTSB NYC78DFJ42](https://openairdocs.org/ntsb/NYC78DFJ42.md): Cessna 172 · Wellsville, NY · Accident · No injuries · Closed · Sep 26, 1978 · N5968A · Substantial damage
- [NTSB NYC78FFJ36](https://openairdocs.org/ntsb/NYC78FFJ36.md): Cessna 172 · W.Bloomfield, NY · Accident · Minor injuries · Closed · Aug 27, 1978 · N6447B · Substantial damage
- [NTSB NYC77FFJ18](https://openairdocs.org/ntsb/NYC77FFJ18.md): Cessna 172 · Barker, NY · Accident · Serious injuries · Closed · Apr 30, 1977 · N2325U · Substantial damage
- [NTSB NYC75FFA25](https://openairdocs.org/ntsb/NYC75FFA25-132478.md): Cessna 172 · Malone, NY · Accident · No injuries · Closed · Dec 28, 1974 · N35531 · Substantial damage
- [NTSB NYC75FHJ27](https://openairdocs.org/ntsb/NYC75FHJ27-201509.md): Cessna 172 · Ronkonkoma, NY · Incident · No injuries · Closed · Apr 24, 1974 · N503E · Minor damage
- [NTSB NYC74DFA20](https://openairdocs.org/ntsb/NYC74DFA20.md): Cessna 172 · Hamilton, NY · Accident · No injuries · Closed · Feb 9, 1974 · N8921B · Substantial damage
- [NTSB NYC74AN028](https://openairdocs.org/ntsb/NYC74AN028.md): Cessna 172 · Ronkonkoma, NY · Accident · No injuries · Closed · Sep 21, 1973 · N6115E · Substantial damage
- [NTSB NYC72DFA46](https://openairdocs.org/ntsb/NYC72DFA46.md): Cessna 172 · Malone, NY · Accident · Minor injuries · Closed · Jun 7, 1972 · N8420U · Substantial damage
- [NTSB NYC70FFA18](https://openairdocs.org/ntsb/NYC70FFA18.md): Cessna 172 · Schroon Lake, NY · Accident · No injuries · Closed · Apr 25, 1970 · N6234E · Substantial damage
- [NTSB NYC70FHJ01](https://openairdocs.org/ntsb/NYC70FHJ01.md): Cessna 172 · Farmingdale, NY · Accident · Minor injuries · Closed · Jan 20, 1970 · N6696A · Substantial damage
- [NTSB NYC70F0059](https://openairdocs.org/ntsb/NYC70F0059.md): Cessna 172C · White Plains, NY · Accident · Minor injuries · Closed · Jul 5, 1969 · N1859Y · Substantial damage
- [NTSB NYC69D0191](https://openairdocs.org/ntsb/NYC69D0191.md): Cessna 172 · Oriskany, NY · Accident · No injuries · Closed · Sep 30, 1968 · N7064T · Destroyed
- [NTSB NYC69F0043](https://openairdocs.org/ntsb/NYC69F0043.md): Cessna 172 · Holtsville, NY · Accident · No injuries · Closed · Jun 29, 1968 · N7928B · Substantial damage
- [NTSB NYC68D0224](https://openairdocs.org/ntsb/NYC68D0224.md): Cessna 172 · Mahopac, NY · Accident · No injuries · Closed · Sep 30, 1967 · N6114E · Substantial damage
- [NTSB NYC67D0672](https://openairdocs.org/ntsb/NYC67D0672.md): Cessna 172 · Hammondsport, NY · Accident · No injuries · Closed · Apr 29, 1967 · N6187E · Substantial damage
- [NTSB NYC66D0705](https://openairdocs.org/ntsb/NYC66D0705.md): Cessna 172 · Penn Yan, NY · Accident · No injuries · Closed · May 27, 1966 · N6197E · Substantial damage
- [NTSB NYC66D0532](https://openairdocs.org/ntsb/NYC66D0532.md): Cessna 172 · Warwick, NY · Accident · No injuries · Closed · Feb 6, 1966 · N8508B · Substantial damage
- [NTSB NYC66F0053](https://openairdocs.org/ntsb/NYC66F0053.md): Cessna 172 · Pavilion, NY · Accident · Minor injuries · Closed · Jul 5, 1965 · N6263E · Substantial damage
- [NTSB NYC65D0119](https://openairdocs.org/ntsb/NYC65D0119.md): Cessna 172 · Middletown, NY · Accident · No injuries · Closed · Mar 28, 1965 · N7402A · Substantial damage
- [NTSB NYC65D0120](https://openairdocs.org/ntsb/NYC65D0120.md): Cessna 172 · Woodstock, NY · Accident · No injuries · Closed · Mar 20, 1965 · N6141E · Substantial damage
- [NTSB UNK65X1241](https://openairdocs.org/ntsb/UNK65X1241.md): Cessna 172 · Elmira, NY · Accident · No injuries · Closed · Jan 6, 1965 · N9111B · Substantial damage
- [NTSB UNK65X0616](https://openairdocs.org/ntsb/UNK65X0616.md): Cessna 172 · Blossvale, NY · Accident · No injuries · Closed · Nov 8, 1964 · N7157A · Substantial damage
- [NTSB UNK64X2759](https://openairdocs.org/ntsb/UNK64X2759.md): Cessna 170B · Mahopac, NY · Accident · No injuries · Closed · Jul 11, 1964 · N8804B · Substantial damage
- [NTSB UNK64X1910](https://openairdocs.org/ntsb/UNK64X1910.md): Cessna 172 · Armonk, NY · Accident · No injuries · Closed · May 23, 1964 · N4250F · 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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