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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&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.