# NTSB investigations: Piper L-21A

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 ANC95FA157](https://openairdocs.org/ntsb/ANC95FA157.md): Piper L-21A · Kaktovik, AK · Accident · 1 fatal · Field investigation · Final report · Aug 18, 1995 · N8373H · Destroyed
  > The pilot's failure to maintain adequate altitude/clearance from mountainous terrain.
- [NTSB BFO84FA003](https://openairdocs.org/ntsb/BFO84FA003.md): Piper L-21-A · Selbyville, DE · Accident · 2 fatal · Field investigation · Final report · Aug 8, 1984 · N10468 · Destroyed
  > At the conclusion of towing banners with no pax on board, the acft was landed and topped off with fuel. The plt then reentered the acft and an additional employee got in the rear seat with the intension of flying to a nearby airport for a plt exchange. During…
- [NTSB IAD75FIG07](https://openairdocs.org/ntsb/IAD75FIG07.md): Piper PA-18 · Emmitsburg, MD · Accident · Minor injuries · Closed · Oct 23, 1974 · N10468 · Substantial damage
- [NTSB CHI72DLQ14](https://openairdocs.org/ntsb/CHI72DLQ14.md): Piper PA-18 · Fort Knox, KY · Accident · No injuries · Closed · Sep 22, 1971 · N4220A · Substantial damage
- [NTSB FTW72DPJ06](https://openairdocs.org/ntsb/FTW72DPJ06.md): Piper PA-18 · Fort Sill, OK · Accident · No injuries · Closed · Jul 31, 1971 · N6482D · Substantial damage
- [NTSB CHI71DGJ10](https://openairdocs.org/ntsb/CHI71DGJ10.md): Piper PA-18 · Ft.Knox, KY · Accident · No injuries · Closed · Aug 22, 1970 · N4220A · Substantial damage
- [NTSB DIA69D0163](https://openairdocs.org/ntsb/DIA69D0163.md): Piper PA-18 · Edgewood, MD · Accident · No injuries · Closed · Mar 23, 1969 · N10468 · Substantial damage
- [NTSB NYC65F/UOK](https://openairdocs.org/ntsb/NYC65F%2FUOK.md): Piper PA-18 · Ft Eustis, VA · Accident · No injuries · Closed · Apr 5, 1965 · N4220A · Substantial damage
- [NTSB UNK65X0365](https://openairdocs.org/ntsb/UNK65X0365.md): Piper PA-18 · Dugway, UT · Accident · 2 fatal · Closed · Oct 21, 1964 · N5031K · Destroyed

## 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 ('7101814'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101814

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