# NTSB investigations: Cessna 172D, 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 BFO93LA126](https://openairdocs.org/ntsb/BFO93LA126.md): Cessna 172D · New Milford, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1993 · N2494U · Substantial damage
  > Loss of engine engine power due to water contamination of the fuel. Factors related to the accident were the mice, which partially blocked fuel and air flow to the carburetor, and the lack of suitable terrain in the emergency landing area.
- [NTSB NYC88LA122](https://openairdocs.org/ntsb/NYC88LA122.md): Cessna 172 · Myerstown, PA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1988 · N2825U · Destroyed
  > The pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.
- [NTSB NYC87LA253](https://openairdocs.org/ntsb/NYC87LA253.md): Cessna 172D · Scottdale, PA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1987 · N2467U · Substantial damage
  > During a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…
- [NTSB NYC76AN097](https://openairdocs.org/ntsb/NYC76AN097.md): Cessna 172 · Marklesburg, PA · Accident · 1 fatal · Closed · May 19, 1976 · N56F · Destroyed
- [NTSB NYC75FHA11](https://openairdocs.org/ntsb/NYC75FHA11.md): Cessna 172 · E Stroudsburg, PA · Accident · No injuries · Closed · Aug 25, 1974 · N2463Y · Substantial damage
- [NTSB NYC69F0411](https://openairdocs.org/ntsb/NYC69F0411.md): Cessna 172D · Darragh, PA · Accident · Serious injuries · Closed · May 4, 1969 · N2350U · Destroyed
- [NTSB NYC68F0023](https://openairdocs.org/ntsb/NYC68F0023.md): Cessna 172 · Central City, PA · Accident · Minor injuries · Closed · Jun 15, 1967 · N2749U · Substantial damage
- [NTSB NYC66D0424](https://openairdocs.org/ntsb/NYC66D0424.md): Cessna 172 · Pittsburg, PA · Accident · Minor injuries · Closed · Dec 15, 1965 · N2589U · 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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