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

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 ATL02LA040](https://openairdocs.org/ntsb/ATL02LA040.md): Piper PA-28-151 · Bessemer, AL · Accident · No injuries · Limited investigation · Final report · Jan 17, 2002 · N6910F · Substantial damage
  > On ground collision with an animal during landing.
- [NTSB ATL95LA040](https://openairdocs.org/ntsb/ATL95LA040.md): Piper PA-28-151 · Orange Beach, AL · Accident · No injuries · Limited investigation · Final report · Jan 16, 1995 · N32411 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL95LA033](https://openairdocs.org/ntsb/ATL95LA033.md): Piper PA-28-151 · Foley, AL · Accident · No injuries · Limited investigation · Final report · Jan 3, 1995 · N6829F · Destroyed
  > An engine fire for undetermined reasons.
- [NTSB ATL94LA037](https://openairdocs.org/ntsb/ATL94LA037.md): Piper PA-28-151 · Jasper, AL · Accident · No injuries · Limited investigation · Final report · Jan 9, 1994 · N14CL · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB ATL92FA185](https://openairdocs.org/ntsb/ATL92FA185.md): Piper PA-28-151 · Samantha, AL · Accident · 3 fatal · Field investigation · Final report · Sep 23, 1992 · N43313 · Destroyed
  > The pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…
- [NTSB ATL90FA071](https://openairdocs.org/ntsb/ATL90FA071.md): Piper PA-28-151 · Creola, AL · Accident · Serious injuries · Field investigation · Final report · Mar 4, 1990 · N991DB · Substantial damage
  > The pilot's failure to assure that proper maintenance and inspection of the aircraft were completed before flight.
- [NTSB MIA79DKJ33](https://openairdocs.org/ntsb/MIA79DKJ33.md): Piper PA-28 · Eutaw, AL · Accident · No injuries · Closed · Apr 13, 1979 · N32816 · 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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA'
  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&state=AL

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