# NTSB investigations: Piper PA-30, AR

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 CHI08CA036](https://openairdocs.org/ntsb/CHI08CA036.md): Piper PA-30 · Lonoke, AR · Accident · No injuries · Data collection · Final report · Oct 13, 2007 · N8635Y · Substantial damage
  > The pilot's misjudgment of the landing flare resulting in a hard landing.
- [NTSB FTW91FA033](https://openairdocs.org/ntsb/FTW91FA033.md): Piper PA-30 · Oppella, AR · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1991 · N291R · Destroyed
  > The pilot's failure to maintain a proper climb rate following loss of his visual references and allowing himself to become diverted during the takeoff. Factors in the accident were interrupted instrument lighting and the dark night conditions.
- [NTSB FTW79DPG74](https://openairdocs.org/ntsb/FTW79DPG74.md): Piper PA-30 · Keo, AR · Accident · No injuries · Closed · Aug 2, 1979 · N291R · Substantial damage
- [NTSB FTW74DPG50](https://openairdocs.org/ntsb/FTW74DPG50.md): Piper PA-30 · Hot Springs, AR · Accident · No injuries · Closed · Mar 22, 1974 · N8682Y · Substantial damage
- [NTSB FTW71FPG60](https://openairdocs.org/ntsb/FTW71FPG60.md): Piper PA-30 · Hot Springs, AR · Accident · No injuries · Closed · May 16, 1971 · N7454Y · Substantial damage
- [NTSB FTW69A0056](https://openairdocs.org/ntsb/FTW69A0056.md): Piper PA-30 · El Dorado, AR · Accident · 1 fatal · Closed · Feb 14, 1969 · N7783Y · Destroyed
- [NTSB FTW69F0076](https://openairdocs.org/ntsb/FTW69F0076.md): Piper PA-30 · Texarkana, AR · Accident · No injuries · Closed · Jul 14, 1968 · N7258Y · Substantial damage
- [NTSB FTW67F0666](https://openairdocs.org/ntsb/FTW67F0666.md): Piper PA-30 · Little Rock, AR · Accident · No injuries · Closed · May 18, 1967 · N7454Y · Substantial damage
- [NTSB FTW67D0051](https://openairdocs.org/ntsb/FTW67D0051.md): Piper PA30 · Springdale, AR · Accident · No injuries · Closed · Jul 1, 1966 · N7164Y · Substantial damage
- [NTSB FTW66A0099](https://openairdocs.org/ntsb/FTW66A0099.md): Piper PA-30 · Pine Bluff, AR · Accident · No injuries · Closed · May 9, 1966 · N7266Y · Substantial damage
- [NTSB FTW66F0469](https://openairdocs.org/ntsb/FTW66F0469.md): Piper PA-30 · Nashville, AR · Accident · No injuries · Closed · Sep 28, 1965 · N501RE · Substantial damage
- [NTSB UNK65X0501](https://openairdocs.org/ntsb/UNK65X0501.md): Piper PA30 · Little Rock, AR · Accident · No injuries · Closed · Oct 31, 1964 · N7114Y · 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" = 'AR' 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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103002&state=AR

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