# Final NTSB investigations, 1981, VI

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 MIA82DA024](https://openairdocs.org/ntsb/MIA82DA024.md): Hawker Sdly HS-748 · St Thomas, VI · Incident · No injuries · Closed · Dec 27, 1981 · VP-LIP · Minor damage
- [NTSB MIA82FA006](https://openairdocs.org/ntsb/MIA82FA006.md): Lockheed 749 · St Thomas, VI · Accident · 3 fatal · Closed · Oct 26, 1981 · HI-328 · Destroyed
- [NTSB MIA81DKA09](https://openairdocs.org/ntsb/MIA81DKA09.md): Curtis-Wrt C-46 · St.Croix, VI · Accident · No injuries · Closed · Sep 28, 1981 · HI-209 · Substantial damage
- [NTSB MIA81FA105](https://openairdocs.org/ntsb/MIA81FA105.md): Aero Comdr 680FL · St.Croix, VI · Accident · 4 fatal · Closed · Aug 16, 1981 · N6600M · Destroyed
- [NTSB MIA81FA099](https://openairdocs.org/ntsb/MIA81FA099.md): Piper PA-23 · St.Thomas, VI · Accident · 1 fatal · Closed · Jul 23, 1981 · N1349P · Destroyed
- [NTSB MIA81FKA07](https://openairdocs.org/ntsb/MIA81FKA07.md): Beech S35 · St. Thomas, VI · Accident · Minor injuries · Closed · Jun 28, 1981 · N8620Q · Destroyed
- [NTSB MIA81FA088](https://openairdocs.org/ntsb/MIA81FA088.md): Beech 65-80 · St.Croix, VI · Accident · No injuries · Closed · Jun 26, 1981 · N314Q · Substantial damage
- [NTSB MIA81IA058](https://openairdocs.org/ntsb/MIA81IA058.md): Dehavilland DH-114 · St Thomas, VI · Incident · Minor injuries · Closed · Mar 27, 1981 · N583PR · Minor 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 year(c."eventDate") = 1981
  AND c."eventStateOrRegion" = 'VI' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=VI&status=final&year=1981

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