# NTSB investigations: Cessna 172M, 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 ERA17FA272](https://openairdocs.org/ntsb/ERA17FA272.md): Cessna 172 · New Milford, CT · Accident · 1 fatal · Field investigation · Final report · Aug 11, 2017 · N1727V · Substantial damage
  > The flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.
- [NTSB ERA14CA430](https://openairdocs.org/ntsb/ERA14CA430.md): Cessna 172M · Watertown, CT · Accident · Minor injuries · Data collection · Final report · Sep 9, 2014 · N20469 · Substantial damage
  > The pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…
- [NTSB ERA11CA138](https://openairdocs.org/ntsb/ERA11CA138.md): Cessna 172 · Meriden, CT · Accident · No injuries · Data collection · Final report · Feb 7, 2011 · N9622Q · Substantial damage
  > The student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.
- [NTSB NYC01LA219](https://openairdocs.org/ntsb/NYC01LA219.md): Cessna 172M · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Aug 26, 2001 · N9869Q · Substantial damage
  > An inoperative airspeed indicator and the pilot's improper recovery from the bounced landing.
- [NTSB IAD98FA072](https://openairdocs.org/ntsb/IAD98FA072.md): Cessna 172M · Hebron, CT · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1998 · N12912 · Destroyed
  > The pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…
- [NTSB NYC96LA075](https://openairdocs.org/ntsb/NYC96LA075.md): Cessna 172M · Warehouse Point, CT · Accident · No injuries · Limited investigation · Final report · Feb 24, 1996 · N12219 · Substantial damage
  > the pilot's inadequate compensation for the crosswind and gusts. The wind conditions were factors.
- [NTSB NYC95LA135](https://openairdocs.org/ntsb/NYC95LA135.md): Cessna 172M · Bridgewater, CT · Accident · No injuries · Limited investigation · Final report · Jun 28, 1995 · N9176H · Substantial damage
  > the loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.
- [NTSB NYC94LA093](https://openairdocs.org/ntsb/NYC94LA093.md): Cessna 172M · Groton, CT · Accident · No injuries · Limited investigation · Final report · May 24, 1994 · N6891H · Substantial damage
  > the pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.
- [NTSB NYC90LA056](https://openairdocs.org/ntsb/NYC90LA056.md): Cessna 172 · Danbury, CT · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1990 · N9093H · Destroyed
  > Improper maintenance, inadequate surveillance by the company/operator, and inadequate preflight by the pilot, which resulted in a fire during an attempted engine start. A factor related to the accident was: the unsecured fuel line.
- [NTSB NYC80FNE03|NYC80FNE04](https://openairdocs.org/ntsb/NYC80FNE03%7CNYC80FNE04.md): Cessna 172M · Stratford, CT · Accident · No injuries · Closed · Nov 19, 1979 · N13660 · 2 aircraft · Substantial damage
- [NTSB NYC79FA059](https://openairdocs.org/ntsb/NYC79FA059.md): Cessna 172M · Griswold, CT · Accident · No injuries · Closed · Jul 14, 1979 · N73297 · Substantial damage
- [NTSB NYC79FNE16](https://openairdocs.org/ntsb/NYC79FNE16.md): Cessna 172 · Ellington, CT · Accident · No injuries · Closed · Jun 6, 1979 · N13435 · Substantial damage
- [NTSB NYC78FA097](https://openairdocs.org/ntsb/NYC78FA097.md): Cessna 172M · Windsor Locks, CT · Accident · 1 fatal · Closed · Sep 20, 1978 · N20285 · Destroyed
- [NTSB NYC78FNE17](https://openairdocs.org/ntsb/NYC78FNE17.md): Cessna 172M · East Windsor, CT · Accident · No injuries · Closed · Apr 1, 1978 · N12219 · Substantial damage
- [NTSB NYC77FNE23](https://openairdocs.org/ntsb/NYC77FNE23.md): Cessna 172M · Plainville, CT · Accident · No injuries · Closed · Jun 19, 1977 · N9574H · Substantial damage
- [NTSB NYC77FNE13](https://openairdocs.org/ntsb/NYC77FNE13.md): Cessna 172 · Chester, CT · Accident · No injuries · Closed · Apr 8, 1977 · N9920Q · Substantial damage
- [NTSB NYC76AN023](https://openairdocs.org/ntsb/NYC76AN023.md): Cessna 172M · Stamford, CT · Accident · 1 fatal · Closed · Aug 17, 1975 · N22234 · Destroyed

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

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