# Fatal NTSB investigations: Piper PA-28R-200, 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 NYC06FA156](https://openairdocs.org/ntsb/NYC06FA156.md): Piper PA-28R-200 · Philipsburg, PA · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2006 · N56246 · Destroyed
  > The pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.
- [NTSB NYC97LA089](https://openairdocs.org/ntsb/NYC97LA089.md): Piper PA-28R-200 · Pottstown, PA · Accident · 1 fatal · Limited investigation · Final report · May 11, 1997 · N56639 · Minor damage
  > was the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.
- [NTSB BFO95FA020](https://openairdocs.org/ntsb/BFO95FA020.md): Piper PA-28R-200 · Nesquehoning, PA · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1994 · N33049 · Destroyed
  > the non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…
- [NTSB NYC78FA009](https://openairdocs.org/ntsb/NYC78FA009.md): Piper PA-28R · North Wales, PA · Accident · 1 fatal · Closed · Nov 23, 1977 · N1018L · Destroyed
- [NTSB NYC73AN120](https://openairdocs.org/ntsb/NYC73AN120.md): Piper PA-28 · Falls Creek, PA · Accident · 3 fatal · Closed · Mar 6, 1973 · N2082T · Substantial damage
- [NTSB NYC72AN051](https://openairdocs.org/ntsb/NYC72AN051.md): Piper PA-28R · Washingtnville, PA · Accident · 1 fatal · Closed · Oct 10, 1971 · N2941R · 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" = 'PA' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7102811&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
