# NTSB investigations: Piper PA-30, 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 MIA79FA034](https://openairdocs.org/ntsb/MIA79FA034.md): Piper PA-30 · Lafayette, GA · Accident · 1 fatal · Closed · Dec 31, 1978 · N7031Y · Destroyed
- [NTSB CHI79FEE16](https://openairdocs.org/ntsb/CHI79FEE16.md): Piper PA-30 · Kankakee, IL · Accident · No injuries · Closed · Dec 16, 1978 · N8143Y · Substantial damage
- [NTSB DEN79FTE07](https://openairdocs.org/ntsb/DEN79FTE07.md): Piper PA-30 · Englewood, CO · Accident · No injuries · Closed · Dec 15, 1978 · N5EE · Substantial damage
- [NTSB MIA79FLD19](https://openairdocs.org/ntsb/MIA79FLD19.md): Piper PA-30 · Sanford, FL · Accident · No injuries · Closed · Nov 10, 1978 · N7555Y · Substantial damage
- [NTSB MIA79FLD06](https://openairdocs.org/ntsb/MIA79FLD06.md): Piper PA-30 · Ft Pierce, FL · Accident · No injuries · Closed · Oct 31, 1978 · N7708Y · Substantial damage
- [NTSB NYC79FHD03](https://openairdocs.org/ntsb/NYC79FHD03.md): Piper PA-30 · Lumberton, NJ · Accident · No injuries · Closed · Oct 14, 1978 · N7887Y · Substantial damage
- [NTSB MKC79DCG03](https://openairdocs.org/ntsb/MKC79DCG03.md): Piper PA-30 · Nevada, MO · Accident · No injuries · Closed · Oct 10, 1978 · N7900Y · Substantial damage
- [NTSB IAD78IA002](https://openairdocs.org/ntsb/IAD78IA002.md): Piper PA-30 · Selmer, TN · Incident · No injuries · Closed · Oct 4, 1978 · N7020Y · Minor damage
- [NTSB NYC78FNC45](https://openairdocs.org/ntsb/NYC78FNC45.md): Piper PA-30 · Warren, VT · Accident · No injuries · Closed · Aug 21, 1978 · N8419Y · Substantial damage
- [NTSB FTW78FQG45](https://openairdocs.org/ntsb/FTW78FQG45.md): Piper PA-30 · Snyder, TX · Accident · No injuries · Closed · Aug 6, 1978 · N1GA · Substantial damage
- [NTSB CHI78FEE58](https://openairdocs.org/ntsb/CHI78FEE58.md): Piper PA-30 · Wheeling, IL · Accident · No injuries · Closed · Jul 26, 1978 · N8788Y · Substantial damage
- [NTSB MIA78FA103](https://openairdocs.org/ntsb/MIA78FA103.md): Piper PA-30 · Albany, GA · Accident · 3 fatal · Closed · Jul 10, 1978 · N41AC · Destroyed
- [NTSB LAX78FUM24](https://openairdocs.org/ntsb/LAX78FUM24.md): Piper PA-30 · Carlsbad, CA · Accident · No injuries · Closed · May 29, 1978 · N7569Y · Substantial damage
- [NTSB SEA78DYM34](https://openairdocs.org/ntsb/SEA78DYM34.md): Piper PA-30B · Madras, OR · Accident · No injuries · Closed · May 20, 1978 · N7068Y · Substantial damage
- [NTSB NYC78FA050](https://openairdocs.org/ntsb/NYC78FA050.md): Piper PA-30 · Flushing, NY · Accident · No injuries · Closed · May 8, 1978 · N7432Y · Substantial damage
- [NTSB NYC78FNA19](https://openairdocs.org/ntsb/NYC78FNA19.md): Piper PA-30 · Marshfield, MA · Accident · No injuries · Closed · Apr 23, 1978 · N68Y · Substantial damage
- [NTSB MIA78FA064](https://openairdocs.org/ntsb/MIA78FA064.md): Piper PA-30 · Destin, FL · Accident · 2 fatal · Closed · Apr 9, 1978 · N7250Y · Destroyed
- [NTSB MIA78FLG17](https://openairdocs.org/ntsb/MIA78FLG17.md): Piper PA-30 · Landrum, SC · Accident · Minor injuries · Closed · Apr 8, 1978 · N8563Y · Destroyed
- [NTSB NYC78FA040](https://openairdocs.org/ntsb/NYC78FA040.md): Piper PA-30 · Montpelier, VT · Accident · 2 fatal · Closed · Apr 7, 1978 · N8559Y · Destroyed
- [NTSB MKC78FTK11](https://openairdocs.org/ntsb/MKC78FTK11.md): Piper PA-30 · Rapid City, SD · Accident · No injuries · Closed · Mar 20, 1978 · N8608Y · Substantial damage
- [NTSB SEA78DYP18](https://openairdocs.org/ntsb/SEA78DYP18.md): Piper PA-30 · Tekoa, WA · Accident · No injuries · Closed · Mar 10, 1978 · N7672Y · Substantial damage
- [NTSB CHI78DEE57](https://openairdocs.org/ntsb/CHI78DEE57.md): Piper PA-30 · Monee, IL · Accident · No injuries · Closed · Mar 6, 1978 · N8665Y · Substantial damage
- [NTSB MIA78FA048](https://openairdocs.org/ntsb/MIA78FA048.md): Piper PA-30 · Waco, GA · Accident · 2 fatal · Closed · Mar 2, 1978 · N7428Y · Destroyed
- [NTSB LAX78DUQ14](https://openairdocs.org/ntsb/LAX78DUQ14.md): Piper PA-30 · Frazier Park, CA · Accident · Minor injuries · Closed · Feb 15, 1978 · N7647Y · Substantial damage
- [NTSB LAX78FA027](https://openairdocs.org/ntsb/LAX78FA027.md): Piper PA-30 · Glen Ivy, CA · Accident · 2 fatal · Closed · Feb 12, 1978 · N7558Y · Destroyed
- [NTSB CHI78FEC15](https://openairdocs.org/ntsb/CHI78FEC15.md): Piper PA-30 · Pontiac, MI · Accident · No injuries · Closed · Feb 10, 1978 · N7185Y · Substantial damage
- [NTSB MIA78FKT19](https://openairdocs.org/ntsb/MIA78FKT19.md): Piper PA-30 · Miami, FL · Accident · No injuries · Closed · Jan 30, 1978 · N8540Y · 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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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