# NTSB investigations, PA: On ground/water encounter with weather

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 NYC92LA176](https://openairdocs.org/ntsb/NYC92LA176.md): Piper PA-34-200T · Coatesville, PA · Accident · No injuries · Limited investigation · Final report · Aug 24, 1992 · N37DD · Substantial damage
  > The pilot's decision to continue the approach and eventual touching down off the runway which resulted in a loss of control of the airplane and collapsing the landing gear. A factor in this accident was the pilot's loss of visual perception and fog.
- [NTSB NYC91LA131](https://openairdocs.org/ntsb/NYC91LA131.md): Cessna 185C · New Hanover, PA · Accident · No injuries · Limited investigation · Final report · May 12, 1991 · N26792 · Substantial damage
  > The loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.
- [NTSB NYC85LA082](https://openairdocs.org/ntsb/NYC85LA082.md): Piper PA-22-108 · Reading, PA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1985 · N66RA · Substantial damage
  > The acft overturned while awaiting takeoff from Reading,PA. Wind was reported from 310 degs at 16 KTS, gusting to 22 KTS. After engine up the tower advised N66RA tp hold for landing traffic which was a lear jet. Wind at this time was given as 310 KTS at 27…
- [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…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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