# NTSB investigations: Cessna 172RG, PA

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 NYC95LA227](https://openairdocs.org/ntsb/NYC95LA227.md): Cessna 172RG · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1995 · N9497B · Substantial damage
  > the pilot's failure to obtain the proper touchdown point and excessive airspeed which resulted in an overrun and a subsequent collision with a trailer off the departure end of the runway.
- [NTSB NYC93LA153](https://openairdocs.org/ntsb/NYC93LA153.md): Cessna 172RG · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Aug 13, 1993 · N6419V · 2 aircraft · Substantial damage
  > Failure of the cessa pilot to remain clear of the parked Beech C90.
- [NTSB NYC88LA139](https://openairdocs.org/ntsb/NYC88LA139.md): Cessna 172RG · West Chester, PA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N9638B · Substantial damage
  > The pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…
- [NTSB NYC84LA080](https://openairdocs.org/ntsb/NYC84LA080.md): Cessna 172RG · Marietta, PA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1984 · N9508B · Substantial damage
  > The acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.
- [NTSB NYC83LA031](https://openairdocs.org/ntsb/NYC83LA031.md): Cessna 172RG · Middletown, PA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1982 · N5223V · Substantial damage
  > After landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the…
- [NTSB NYC80FGT04](https://openairdocs.org/ntsb/NYC80FGT04.md): Cessna 172RG · Camp Hill, PA · Accident · No injuries · Closed · Dec 6, 1979 · N6286R · 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" = 'PA' 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=PA

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