# Fatal NTSB investigations: Piper PA-24: 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 CHI03FA018](https://openairdocs.org/ntsb/CHI03FA018.md): Piper PA-24 · Fond du Lac, WI · Accident · 2 fatal · Field investigation · Final report · Nov 4, 2002 · N6606P · Destroyed
  > The pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.
- [NTSB ATL92FA020](https://openairdocs.org/ntsb/ATL92FA020.md): Piper PA-24 · Engelhard, NC · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1991 · N7120P · Destroyed
  > The spatial disorientation experienced by the pilot, and his inadvertent descent into the terrain. A factor was the dark, night lighting condition at the time of the accident.
- [NTSB NYC91FA097](https://openairdocs.org/ntsb/NYC91FA097.md): Piper PA-24-180 · Muncie Valley, PA · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1991 · N5007P · Destroyed
  > The pilot's attempt to maintain visual flight into known instrument meteorological conditions, resulting in a collision with trees. Factors related to the accident were: the pilot's failure to obtain a pre-flight weather briefing and his failure to maintain…

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402')
    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?fatal=1&model=7102402&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
