# NTSB investigations: Cessna 172P, CT

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 GAA17CA530](https://openairdocs.org/ntsb/GAA17CA530.md): Cessna 172 · Plainville, CT · Accident · Minor injuries · Data collection · Final report · Sep 11, 2017 · N54463 · Substantial damage
  > The pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.
- [NTSB ERA12FA483](https://openairdocs.org/ntsb/ERA12FA483.md): Cessna 172P · Plainville, CT · Accident · 1 fatal · Field investigation · Final report · Jul 26, 2012 · N64182 · Substantial damage
  > The pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.
- [NTSB NYC03CA167](https://openairdocs.org/ntsb/NYC03CA167.md): Cessna 172P · Plainfield, CT · Accident · No injuries · Data collection · Final report · Jul 25, 2003 · N62152 · Substantial damage
  > The pilot's failure to maintain directional control, which resulted in a collision with a ditch. A factor in this accident was the crosswind condition.
- [NTSB NYC98LA082](https://openairdocs.org/ntsb/NYC98LA082.md): Cessna 172P · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Mar 29, 1998 · N9821L · Substantial damage
  > The pilot's inadequate crosswind compensation.
- [NTSB NYC91LA106](https://openairdocs.org/ntsb/NYC91LA106.md): Cessna 172P · Burlington, CT · Accident · No injuries · Limited investigation · Final report · Apr 6, 1991 · N64182 · Substantial damage
  > The failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.
- [NTSB NYC88LA031](https://openairdocs.org/ntsb/NYC88LA031.md): Cessna 172 · Stamford, CT · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N9538L · Substantial damage
  > The instructor (CFI) reported that the aircraft had just reached the top of a climb at 2500 ft when the engine lost power. An off airport landing was made on a golf course. During the landing, the wings struck trees and the aircraft was damaged. The golf…
- [NTSB NYC87LA213](https://openairdocs.org/ntsb/NYC87LA213.md): Cessna 172P · Plainfield, CT · Accident · No injuries · Limited investigation · Final report · Aug 4, 1987 · N99171 · Substantial damage
  > While landing in crosswind conditions, the pilot failed to compensate for the conditions and lost directional control of the aircraft. The aircraft went down an embankment, collided with a fence and then flipped inverted.
- [NTSB NYC87LA228](https://openairdocs.org/ntsb/NYC87LA228.md): Cessna 172 · Groton, CT · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N53461 · Substantial damage
  > The aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…
- [NTSB NYC87LA154](https://openairdocs.org/ntsb/NYC87LA154.md): Cessna 172 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · May 24, 1987 · N65482 · Substantial damage
  > Drg a night flt from new bedford to bridgeport, the plt enctrd visibility problems & believed that fuel consumption was higher than normal. He obtained radar vectors to New Haven. After seeing the arpt, he flew over to establish the runway pattern. However,…
- [NTSB NYC85LA178](https://openairdocs.org/ntsb/NYC85LA178.md): Cessna C172 · Ellington, CT · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1985 · N98651 · Substantial damage
  > The acft collided with the ground during takeoff from rwy 01 at Ellington, Connecticut, and was substantially damaged but there was no fire. The pilot received minor injuries. The aircraft crashed for undetermined reasons.
- [NTSB NYC85LA034](https://openairdocs.org/ntsb/NYC85LA034.md): Cessna 172P · Madison, CT · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N89929 · Substantial damage
  > Plt stated that as he lowered nose gear to runway following initial touchdown on mains, acft nose continued to drop. Control inputs were not effective. Investigation revealed the nose gear ass'y failed in overload. Based on fuel remaining on board and…
- [NTSB NYC83LA161](https://openairdocs.org/ntsb/NYC83LA161.md): Cessna 172P · Redding, CT · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N62511 · Substantial damage
  > The flight originated at ramapo, NY. During a preflight check, the plt noted that the fuel gauges indicated full. When he visually checked the fuel tanks, he estimated that the fuel level in each tank was about 1 inch from being full. The fuel capacity of…
- [NTSB NYC83LA058](https://openairdocs.org/ntsb/NYC83LA058.md): Cessna 172P · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Jan 30, 1983 · N62264 · Substantial damage
  > After practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane…

## 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" = 'CT' 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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072436&state=CT

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