# Fatal NTSB investigations, 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 LAX76O0020](https://openairdocs.org/ntsb/LAX76O0020.md): Piper PA-28R · Victoria, Canada · Accident · 2 fatal · Closed · Aug 13, 1976 · N4849T · Destroyed
- [NTSB UNK73X0122](https://openairdocs.org/ntsb/UNK73X0122.md): Mooney M20C · Emo, Canada · Accident · 2 fatal · Closed · Sep 3, 1973 · N9749M · Destroyed
- [NTSB LAX73OL014](https://openairdocs.org/ntsb/LAX73OL014.md): Lockheed 1049G · Casey, Canada · Accident · 3 fatal · Closed · Jun 9, 1973 · N173W · Destroyed
- [NTSB UNK73X0109](https://openairdocs.org/ntsb/UNK73X0109.md): Cessna 340 · Gander, Canada · Accident · 1 fatal · Closed · Mar 31, 1973 · N7691Q · Destroyed
- [NTSB CAN73F0906](https://openairdocs.org/ntsb/CAN73F0906.md): Piper PA-23 · Aklavik, Canada · Accident · 3 fatal · Closed · Dec 8, 1972 · N4919P · Destroyed
- [NTSB UNK73X0101](https://openairdocs.org/ntsb/UNK73X0101.md): Beech 35P · Vancouver, Canada · Accident · 2 fatal · Closed · Oct 20, 1972 · N9656Y · Destroyed
- [NTSB UNK73X0100](https://openairdocs.org/ntsb/UNK73X0100.md): Cessna 172L · Lamacaza, Canada · Accident · 1 fatal · Closed · Oct 16, 1972 · N4257L · Destroyed
- [NTSB UNK72X0111](https://openairdocs.org/ntsb/UNK72X0111.md): Piper PA-28 · Kemptvlle, Canada · Accident · 2 fatal · Closed · Jul 20, 1972 · N2087T · Destroyed
- [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
- [NTSB CAN71AP907](https://openairdocs.org/ntsb/CAN71AP907.md): Cessna T337B · Cranbrook, Canada · Accident · 4 fatal · Closed · Sep 22, 1970 · N2346S · Destroyed
- [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 UNK70X0105](https://openairdocs.org/ntsb/UNK70X0105.md): Npiper PA-22 · Brockville, Canada · Accident · 2 fatal · Closed · Nov 30, 1969 · N3934P · Destroyed
- [NTSB UNK69X0140](https://openairdocs.org/ntsb/UNK69X0140.md): Mini Mustng 01 · Abbotsford, Canada · Accident · 1 fatal · Closed · Aug 8, 1969 · N9N · Destroyed
- [NTSB CAN70A4457](https://openairdocs.org/ntsb/CAN70A4457.md): Schweizer SGS126 · Hope, Canada · Accident · 3 fatal · Closed · Jul 26, 1969 · CF-VEQ · 2 aircraft · Destroyed
- [NTSB UNK69X0131](https://openairdocs.org/ntsb/UNK69X0131.md): Cessna 150F · Radium, Canada · Accident · 2 fatal · Closed · Jul 9, 1969 · N8621S · Substantial damage
- [NTSB UNK69X0128](https://openairdocs.org/ntsb/UNK69X0128.md): Beech 35 · Westwold, Canada · Accident · 3 fatal · Closed · Jun 28, 1969 · N2800V · Destroyed
- [NTSB CAN69AF526](https://openairdocs.org/ntsb/CAN69AF526.md): Piper PA-22 · Bowmanville, Canada · Accident · 2 fatal · Closed · May 18, 1969 · N7050D · Substantial damage
- [NTSB UNK68X0148](https://openairdocs.org/ntsb/UNK68X0148.md): N.American AT-6G · Brantford, Canada · Accident · 1 fatal · Closed · Jun 8, 1968 · N400G · Destroyed
- [NTSB UNK68X0100](https://openairdocs.org/ntsb/UNK68X0100.md): Beech C-45G · Saskatchewan, Canada · Accident · 5 fatal · Closed · Oct 5, 1967 · N505N · Destroyed
- [NTSB UNK67X0151](https://openairdocs.org/ntsb/UNK67X0151.md): Mooney M20D · Oshawa, Canada · Accident · 2 fatal · Closed · Aug 27, 1967 · N6828U · Destroyed
- [NTSB UNK67X0132](https://openairdocs.org/ntsb/UNK67X0132.md): Cessna 175 · Armstrong, Canada · Accident · 2 fatal · Closed · Jun 29, 1967 · N7022M · Destroyed
- [NTSB UNK67X0126](https://openairdocs.org/ntsb/UNK67X0126.md): Bell 47J · Ontario, Canada · Accident · 3 fatal · Closed · Jun 8, 1967 · N2833B · Destroyed
- [NTSB UNK66X0172](https://openairdocs.org/ntsb/UNK66X0172.md): Aeronca 15AC · Z, Canada · Accident · 2 fatal · Closed · Sep 10, 1966 · N1467H · Destroyed
- [NTSB UNK66X0171](https://openairdocs.org/ntsb/UNK66X0171.md): Cessna 320D · Embras, Canada · Accident · 4 fatal · Closed · Sep 7, 1966 · N4146T · Destroyed
- [NTSB UNK66X0145](https://openairdocs.org/ntsb/UNK66X0145.md): Cessna 337 · Z, Canada · Accident · 2 fatal · Closed · Jun 4, 1966 · N2166X · Destroyed
- [NTSB CAN66F0420](https://openairdocs.org/ntsb/CAN66F0420.md): Cessna 150F · Aishihik, Canada · Accident · 1 fatal · Closed · Apr 28, 1966 · N6934F · 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 c."eventStateOrRegion" = 'CD' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&state=CD

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