# NTSB investigations: Cessna 172RG, 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 NYC97LA032](https://openairdocs.org/ntsb/NYC97LA032.md): Cessna 172RG · Stamford, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1996 · N4829V · Destroyed
  > inadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.
- [NTSB NYC96LA015](https://openairdocs.org/ntsb/NYC96LA015.md): Cessna 172RG · Chester, CT · Accident · No injuries · Limited investigation · Final report · Oct 21, 1995 · N9412B · Substantial damage
  > The pilot's failure to attain adequate airspeed, and his delay in aborting the takeoff, which resulted in a runway overrun and collision with trees. Factors relating to the accident were: the wet runway and hydroplaning conditions.
- [NTSB NYC95LA213](https://openairdocs.org/ntsb/NYC95LA213.md): Cessna 172RG · Meriden, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1995 · N4671V · Substantial damage
  > the pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.
- [NTSB NYC84FA293](https://openairdocs.org/ntsb/NYC84FA293.md): Cessna 150M · Meriden, CT · Accident · No injuries · Field investigation · Final report · Aug 26, 1984 · N45288 · 2 aircraft · Minor damage
  > A cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.

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

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