# Final NTSB investigations, 1970, 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 CAN71AP907](https://openairdocs.org/ntsb/CAN71AP907.md): Cessna T337B · Cranbrook, Canada · Accident · 4 fatal · Closed · Sep 22, 1970 · N2346S · Destroyed
- [NTSB CAN71AW907](https://openairdocs.org/ntsb/CAN71AW907.md): Cessna 336 · Valleyview, Canada · Accident · No injuries · Closed · Aug 11, 1970 · N3891U · Substantial damage
- [NTSB CAN72AQ905](https://openairdocs.org/ntsb/CAN72AQ905.md): Swearingen SA26T · Quebec, Canada · Accident · No injuries · Closed · Jul 12, 1970 · N1212S · Substantial damage
- [NTSB CAN71AQ904](https://openairdocs.org/ntsb/CAN71AQ904.md): Grumman G-44 · Chibougamau, Canada · Accident · Minor injuries · Closed · Jun 30, 1970 · N40011 · Substantial damage
- [NTSB CAN714A905](https://openairdocs.org/ntsb/CAN714A905.md): Grumman TBM · St.Martin, Canada · Accident · 1 fatal · Closed · Jun 21, 1970 · N7031C · Destroyed
- [NTSB CAN71A0902](https://openairdocs.org/ntsb/CAN71A0902.md): Piper PA-18 · Ontario, Canada · Accident · 2 fatal · Closed · May 29, 1970 · N2321A · Substantial damage
- [NTSB CAN71AA903](https://openairdocs.org/ntsb/CAN71AA903.md): Piper PA-23 · Gander, Canada · Accident · Minor injuries · Closed · May 28, 1970 · N13905 · Destroyed
- [NTSB CAN70AW901](https://openairdocs.org/ntsb/CAN70AW901.md): Taylorcraft BC12-D · Alberta, Canada · Accident · No injuries · Closed · Apr 17, 1970 · N96295 · Substantial damage
- [NTSB UNK70X0110](https://openairdocs.org/ntsb/UNK70X0110.md): Piper PA-24 · St.Jovite, Canada · Accident · No injuries · Closed · Mar 21, 1970 · N7381P · Substantial damage
- [NTSB UNK70X0108](https://openairdocs.org/ntsb/UNK70X0108.md): Piper PA-22 · Wawa, Canada · Accident · No injuries · Closed · Jan 4, 1970 · N9991D · 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") = 1970
  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=1970

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