# NTSB investigations: Piper PA-32R-301: In flight collision with object

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 FTW04FA054](https://openairdocs.org/ntsb/FTW04FA054.md): Piper PA-32R-301 · Beaumont, TX · Accident · 2 fatal · Field investigation · Final report · Jan 3, 2004 · N396HP · Destroyed
  > The flight instructor's failure to maintain clearance with a static line. Contributing factors were the low cloud ceiling weather conditions and night light conditions.
- [NTSB IAD01FA070](https://openairdocs.org/ntsb/IAD01FA070.md): Piper PA-32R-301 · Greenwich, CT · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2001 · N13VH · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation. Factors in the accident were the fog, and the pilot's use of a sedating medication.
- [NTSB FTW00LA123](https://openairdocs.org/ntsb/FTW00LA123.md): Piper PA-32R-301 · Rocksprings, TX · Accident · No injuries · Limited investigation · Final report · Apr 12, 2000 · N789CA · Destroyed
  > The pilot's failure to maintain proper glidepath. A factor was the dark night light conditions.
- [NTSB MIA99FA034](https://openairdocs.org/ntsb/MIA99FA034.md): Piper PA-32R-301 · Olive Branch, MS · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1998 · N83396 · Destroyed
  > The pilot's failure to follow IFR procedures when he descended below the published minimum descent altitude.
- [NTSB ATL85LA145](https://openairdocs.org/ntsb/ATL85LA145.md): Piper PA-32R-301 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N8047P · Substantial damage
  > The plt stated that during takeoff the right main gear struck a large dog which ran onto the rwy. The takeoff was continued & the plt circled the arpt for 2 hrs to burn off excess fuel before performing a ldg with the nose gear & the left main ldg gear…
- [NTSB BFO85FA002](https://openairdocs.org/ntsb/BFO85FA002.md): Piper PA-32R-301 · Salisbury, MD · Accident · 4 fatal · Field investigation · Final report · Oct 25, 1984 · N81752 · Destroyed
  > After contacting millville fss 4 times for wx info the acft departed lincoln park, NY, at 1858 EDT with destination listed on the IFR flt plan as easton, MD. En route the plt diverted to Salisbury, MD, due to wx. After being cleared forthe rwy 32 ILS the acft…
- [NTSB MIA83LA056](https://openairdocs.org/ntsb/MIA83LA056.md): Piper PA-32-301R · Near Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 3, 1983 · N35590 · Substantial damage
  > The acft collided with tree tops during a night flight but the pilot was able to maintain control and land at a nearby airport. According to the pilot he was on approach to fort pierce airport when the accident occurred. However according to some witnesses…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103218')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103218&occurrence=220

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