# NTSB investigations: Piper PA-28R-180, AK

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 ANC83LA054](https://openairdocs.org/ntsb/ANC83LA054.md): Piper PA-28R-180 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Mar 9, 1983 · N17243 · Substantial damage
  > The acft taxied into a pile of ice after landing. According to an Alaska state trooper that assisted in the investigation, the pilot turned 45 degrees to the right and departed the runway 150 feet short of the taxiway. The sun was bright, and according to the…
- [NTSB ANC78DAG43](https://openairdocs.org/ntsb/ANC78DAG43.md): Piper PA-28R · Anchorage, AK · Accident · Serious injuries · Closed · May 4, 1978 · N7677J · Substantial damage
- [NTSB ANC76AA007](https://openairdocs.org/ntsb/ANC76AA007.md): Piper PA-28R · Chandalar Camp, AK · Accident · 2 fatal · Closed · Jul 16, 1975 · N4619J · Substantial damage
- [NTSB ANC70AA056](https://openairdocs.org/ntsb/ANC70AA056.md): Piper PA-28R · Juneau, AK · Accident · No injuries · Closed · Jan 18, 1970 · N3867T · 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" = 'AK' 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 ('7102809'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102809&state=AK

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