# NTSB investigations: Piper PA-28-181, 1979

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 CHI80FEC07](https://openairdocs.org/ntsb/CHI80FEC07.md): Piper PA-28 · Owosso, MI · Accident · No injuries · Closed · Dec 21, 1979 · N36700 · Substantial damage
- [NTSB CHI80FA015](https://openairdocs.org/ntsb/CHI80FA015.md): Piper PA-28 · Mansfield, OH · Accident · 1 fatal · Closed · Dec 16, 1979 · N5515F · Destroyed
- [NTSB IAD80FIG03](https://openairdocs.org/ntsb/IAD80FIG03.md): Piper PA-28 · Edgewater, MD · Accident · No injuries · Closed · Dec 12, 1979 · N8132R · Substantial damage
- [NTSB FTW80DPG05](https://openairdocs.org/ntsb/FTW80DPG05.md): Piper PA-28 · Cherokee Vlg, AR · Accident · No injuries · Closed · Nov 26, 1979 · N9681K · Substantial damage
- [NTSB LAX80FA016](https://openairdocs.org/ntsb/LAX80FA016.md): Piper PA-28 · Santa Barbara, CA · Accident · 1 fatal · Closed · Nov 20, 1979 · N9042K · Destroyed
- [NTSB UNK80X0102](https://openairdocs.org/ntsb/UNK80X0102.md): Piper PA-28 · Melvin, IA · Accident · 1 fatal · Closed · Nov 11, 1979 · N2181D · Destroyed
- [NTSB LAX80DUJ14](https://openairdocs.org/ntsb/LAX80DUJ14.md): Piper PA-28 · Show Low, AZ · Accident · No injuries · Closed · Sep 24, 1979 · N47921 · Substantial damage
- [NTSB CHI79DER08](https://openairdocs.org/ntsb/CHI79DER08.md): Piper PA-28 · Superior, WI · Accident · Minor injuries · Closed · Sep 17, 1979 · N2109N · Substantial damage
- [NTSB FTW79DRD54](https://openairdocs.org/ntsb/FTW79DRD54.md): Piper PA-28 · Baton Rouge, LA · Accident · No injuries · Closed · Sep 12, 1979 · N3030S · Substantial damage
- [NTSB NYC79FA087](https://openairdocs.org/ntsb/NYC79FA087.md): Piper PA-28 · Fishers Island, NY · Accident · Serious injuries · Closed · Sep 2, 1979 · N6945C · Substantial damage
- [NTSB SEA79FA053](https://openairdocs.org/ntsb/SEA79FA053.md): Piper PA-28 · Paisley, OR · Accident · 4 fatal · Closed · Sep 1, 1979 · N2818N · Destroyed
- [NTSB MKC79DCD32](https://openairdocs.org/ntsb/MKC79DCD32.md): Piper PA-28 · Davenport, IA · Accident · Minor injuries · Closed · Aug 17, 1979 · N4360F · Substantial damage
- [NTSB CHI79DEI36](https://openairdocs.org/ntsb/CHI79DEI36.md): Piper PA-28 · Painesville, OH · Accident · No injuries · Closed · Aug 4, 1979 · N2925Q · Substantial damage
- [NTSB ANC79FAD03](https://openairdocs.org/ntsb/ANC79FAD03.md): Piper PA-28 · Pt.Sherman, AK · Accident · No injuries · Closed · Jul 23, 1979 · N6396C · Substantial damage
- [NTSB NYC79FA058](https://openairdocs.org/ntsb/NYC79FA058.md): Piper PA-28 · Blng Springs, PA · Accident · 4 fatal · Closed · Jul 15, 1979 · N2216G · Destroyed
- [NTSB CHI79FA056](https://openairdocs.org/ntsb/CHI79FA056.md): Piper PA-28 · Taylor, WI · Accident · 1 fatal · Closed · Jul 3, 1979 · N8341C · Destroyed
- [NTSB DEN79DTM16](https://openairdocs.org/ntsb/DEN79DTM16.md): Piper PA-28 · Green River, UT · Accident · No injuries · Closed · May 21, 1979 · N6553F · Substantial damage
- [NTSB OAK79DVG38](https://openairdocs.org/ntsb/OAK79DVG38.md): Piper PA-28 · Napa, CA · Accident · No injuries · Closed · May 14, 1979 · N6505C · Substantial damage
- [NTSB DEN79FQA23](https://openairdocs.org/ntsb/DEN79FQA23.md): Piper PA-28 · Gallup, NM · Accident · Serious injuries · Closed · Apr 6, 1979 · N5428F · Substantial damage
- [NTSB SEA79FA028](https://openairdocs.org/ntsb/SEA79FA028.md): Piper PA-28 · Brothers, OR · Accident · 2 fatal · Closed · Mar 26, 1979 · N1649H · Destroyed
- [NTSB OAK79FA021](https://openairdocs.org/ntsb/OAK79FA021.md): Piper PA-28 · Sacramento, CA · Accident · 2 fatal · Closed · Mar 24, 1979 · N7931C · Destroyed
- [NTSB MIA79DLA23](https://openairdocs.org/ntsb/MIA79DLA23.md): Piper PA-28 · Tallahassee, FL · Accident · No injuries · Closed · Mar 16, 1979 · N8470F · Substantial damage
- [NTSB DEN79FA022](https://openairdocs.org/ntsb/DEN79FA022.md): Piper PA-28 · Logan, UT · Accident · 1 fatal · Closed · Feb 17, 1979 · N3893M · 2 aircraft · Minor 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 year(c."eventDate") = 1979
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102807&year=1979

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