# NTSB investigations: Piper PA-28-151, 1978

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 CHI79FEG08](https://openairdocs.org/ntsb/CHI79FEG08.md): Piper PA-28 · Chesapeake, OH · Accident · Serious injuries · Closed · Dec 10, 1978 · N32541 · Substantial damage
- [NTSB SEA79FTI01](https://openairdocs.org/ntsb/SEA79FTI01.md): Piper PA-28 · Belgrade, MT · Accident · Serious injuries · Closed · Oct 8, 1978 · N43481 · Substantial damage
- [NTSB DEN79FQG01](https://openairdocs.org/ntsb/DEN79FQG01.md): Piper PA-28 · Lovington, NM · Accident · Serious injuries · Closed · Oct 3, 1978 · N44797 · Destroyed
- [NTSB DEN78FQA63](https://openairdocs.org/ntsb/DEN78FQA63.md): Piper PA-28 · Aztec, NM · Accident · Serious injuries · Closed · Sep 30, 1978 · N9231K · Substantial damage
- [NTSB MKC78FCA50](https://openairdocs.org/ntsb/MKC78FCA50.md): Piper PA-28 · Thayer, MO · Accident · No injuries · Closed · Sep 4, 1978 · N32411 · Substantial damage
- [NTSB MKC78FA067](https://openairdocs.org/ntsb/MKC78FA067.md): Piper PA-28 · St George, MN · Accident · 2 fatal · Closed · Aug 26, 1978 · N43177 · Destroyed
- [NTSB OAK78FJA15](https://openairdocs.org/ntsb/OAK78FJA15.md): Piper PA-28 · Kailua-Kona, HI · Accident · Minor injuries · Closed · Aug 23, 1978 · N8898E · Substantial damage
- [NTSB NYC78FA080](https://openairdocs.org/ntsb/NYC78FA080.md): Piper PA-28 · Cassadaga, NY · Accident · No injuries · Closed · Aug 13, 1978 · N5841F · Substantial damage
- [NTSB CHI78FA058](https://openairdocs.org/ntsb/CHI78FA058.md): Piper PA-28 · Bedford, IN · Accident · 1 fatal · Closed · Aug 12, 1978 · N43167 · Destroyed
- [NTSB CHI78FEP56](https://openairdocs.org/ntsb/CHI78FEP56.md): Cessna 172M · Oshkosh, WI · Accident · No injuries · Closed · Aug 3, 1978 · N172TC · 2 aircraft · Minor damage
- [NTSB NYC78FA071](https://openairdocs.org/ntsb/NYC78FA071.md): Piper PA-28 · Campbell, NY · Accident · 3 fatal · Closed · Jul 15, 1978 · N4853F · Destroyed
- [NTSB MIA78FKG59](https://openairdocs.org/ntsb/MIA78FKG59.md): Piper PA-28 · Toccoa, GA · Accident · Serious injuries · Closed · Jul 8, 1978 · N75313 · Destroyed
- [NTSB FTW78DPG58](https://openairdocs.org/ntsb/FTW78DPG58.md): Piper PA-28 · Summers, AR · Accident · No injuries · Closed · Jul 3, 1978 · N4174F · Substantial damage
- [NTSB DEN78FQA35](https://openairdocs.org/ntsb/DEN78FQA35.md): Piper PA-18 · Taos, NM · Accident · No injuries · Closed · Jul 2, 1978 · N41372 · Substantial damage
- [NTSB SEA78DYP34](https://openairdocs.org/ntsb/SEA78DYP34.md): Piper PA-28 · Methow, WA · Accident · No injuries · Closed · Jun 25, 1978 · N5987F · Substantial damage
- [NTSB IAD78DIJ16](https://openairdocs.org/ntsb/IAD78DIJ16.md): Piper PA-28 · New Martinsvl, WV · Accident · No injuries · Closed · Jun 25, 1978 · N7706C · Substantial damage
- [NTSB NYC78FNC31](https://openairdocs.org/ntsb/NYC78FNC31.md): Piper PA-28 · Jaffrey, NH · Accident · Serious injuries · Closed · Jun 17, 1978 · N7279F · Substantial damage
- [NTSB NYC78FHD15](https://openairdocs.org/ntsb/NYC78FHD15.md): Piper PA-28 · Bristol, PA · Accident · Minor injuries · Closed · Jun 16, 1978 · N75040 · Destroyed
- [NTSB MKC78FA048](https://openairdocs.org/ntsb/MKC78FA048.md): Piper PA-28 · Albert Lea, MN · Accident · 1 fatal · Closed · Jun 13, 1978 · N40891 · Destroyed
- [NTSB IAD78DKM13](https://openairdocs.org/ntsb/IAD78DKM13.md): Piper PA-28 · Morganton, NC · Accident · No injuries · Closed · Jun 11, 1978 · N8451F · Substantial damage
- [NTSB NYC78DHA24](https://openairdocs.org/ntsb/NYC78DHA24.md): Piper PA-28 · E.Stroudsburg, PA · Accident · Minor injuries · Closed · May 21, 1978 · N9218K · Substantial damage
- [NTSB CHI78FEE34](https://openairdocs.org/ntsb/CHI78FEE34.md): Piper PA-28 · Grayslake, IL · Accident · Minor injuries · Closed · Apr 22, 1978 · N8897E · Substantial damage
- [NTSB DEN78DQA19](https://openairdocs.org/ntsb/DEN78DQA19.md): Piper PA-18 · Taos, NM · Accident · No injuries · Closed · Apr 18, 1978 · N41372 · Substantial damage
- [NTSB DEN78DQA18](https://openairdocs.org/ntsb/DEN78DQA18.md): Piper PA-28 · Los Lunas, NM · Accident · No injuries · Closed · Apr 18, 1978 · N6110J · Substantial damage
- [NTSB FTW78FQG26](https://openairdocs.org/ntsb/FTW78FQG26.md): Piper PA-28 · Ropesville, TX · Accident · No injuries · Closed · Apr 14, 1978 · N41622 · Substantial damage
- [NTSB NYC78FA042](https://openairdocs.org/ntsb/NYC78FA042.md): Piper PA-28 · Fishers Island, NY · Accident · No injuries · Closed · Apr 11, 1978 · N6910J · Substantial damage
- [NTSB LAX78DVA36](https://openairdocs.org/ntsb/LAX78DVA36.md): Piper PA-28 · Bakersfield, CA · Accident · No injuries · Closed · Apr 11, 1978 · N75164 · Substantial damage
- [NTSB SEA78FA021](https://openairdocs.org/ntsb/SEA78FA021.md): Piper PA-28 · Springdale, WA · Accident · 1 fatal · Closed · Mar 11, 1978 · N32085 · Destroyed
- [NTSB FTW78FA033](https://openairdocs.org/ntsb/FTW78FA033.md): Piper PA-28 · Hiwasse, AR · Accident · 4 fatal · Closed · Mar 11, 1978 · N4513X · Destroyed
- [NTSB NYC78FNA11](https://openairdocs.org/ntsb/NYC78FNA11.md): Piper PA-28 · Haverhill, MA · Accident · No injuries · Closed · Feb 26, 1978 · N56725 · Substantial damage
- [NTSB CHI78DEE26](https://openairdocs.org/ntsb/CHI78DEE26.md): Piper PA-28 · Rockton, IL · Accident · No injuries · Closed · Feb 26, 1978 · N4017F · Substantial damage
- [NTSB LAX78FA028](https://openairdocs.org/ntsb/LAX78FA028.md): Piper PA-28 · Wasco, CA · Accident · 1 fatal · Closed · Feb 20, 1978 · N44138 · Destroyed
- [NTSB MKC78FCA15](https://openairdocs.org/ntsb/MKC78FCA15.md): Piper PA-28 · Chesterfield, MO · Accident · No injuries · Closed · Feb 10, 1978 · N75274 · Substantial damage
- [NTSB OAK78DVW08](https://openairdocs.org/ntsb/OAK78DVW08.md): Piper PA-28 · Pahrump, NV · Accident · 1 fatal · Closed · Feb 2, 1978 · N44517 · Destroyed
- [NTSB MIA78FKG19](https://openairdocs.org/ntsb/MIA78FKG19.md): Piper PA-28 · Stockbridge, GA · Accident · No injuries · Closed · Jan 28, 1978 · N4506F · Substantial damage
- [NTSB LAX78DUJ22](https://openairdocs.org/ntsb/LAX78DUJ22.md): Piper PA-28 · Lake Havasu, AZ · Accident · No injuries · Closed · Jan 20, 1978 · N32841 · Substantial damage
- [NTSB IAD78DA029](https://openairdocs.org/ntsb/IAD78DA029.md): Piper PA-28R · Cape Charles, VA · Accident · 2 fatal · Closed · Jan 5, 1978 · N1502X · Destroyed
- [NTSB LAX78DUM12](https://openairdocs.org/ntsb/LAX78DUM12.md): Piper PA-28 · Glamis, CA · Accident · No injuries · Closed · Jan 2, 1978 · N7200F · 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 year(c."eventDate") = 1978
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102805', '7104223'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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