# Final NTSB investigations, 1971, Canada

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 UNK72X0103](https://openairdocs.org/ntsb/UNK72X0103.md): Cessna 310H · Malton, Canada · Accident · No injuries · Closed · Dec 18, 1971 · N1078Q · Substantial damage
- [NTSB CAN72AW908](https://openairdocs.org/ntsb/CAN72AW908.md): Hiller Acft FH1100 · Alberta, Canada · Accident · Minor injuries · Closed · Aug 30, 1971 · N514FH · Substantial damage
- [NTSB LAX72DUG14](https://openairdocs.org/ntsb/LAX72DUG14.md): Piper PA-28R · Ft.St.John, Canada · Accident · No injuries · Closed · Aug 15, 1971 · N3241R · Substantial damage
- [NTSB UNK71X0110](https://openairdocs.org/ntsb/UNK71X0110.md): Fairchild PT-26 · Carp, Canada · Accident · Serious injuries · Closed · Aug 14, 1971 · N5514N · Substantial damage
- [NTSB UNK71X0108](https://openairdocs.org/ntsb/UNK71X0108.md): Piper PA-24 · Calgary, Canada · Accident · 5 fatal · Closed · Jun 5, 1971 · N5462P · Destroyed
- [NTSB UNK71X0106](https://openairdocs.org/ntsb/UNK71X0106.md): Beech M35 · Oshawa, Canada · Accident · 2 fatal · Closed · Feb 17, 1971 · N9812R · Destroyed
- [NTSB SEA71OS003](https://openairdocs.org/ntsb/SEA71OS003.md): Cessna 172C · Mission, Canada · Accident · 4 fatal · Closed · Jan 21, 1971 · N8482X · 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 year(c."eventDate") = 1971
  AND c."eventStateOrRegion" = 'CD' 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=CD&status=final&year=1971

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