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

Page 1 of 2 · 85 cases

## Latest cases

- [NTSB UNK79X0103](https://openairdocs.org/ntsb/UNK79X0103.md): Piper PA-31 · Toronto, Canada · Accident · No injuries · Closed · Nov 26, 1978 · N777GM · Substantial damage
- [NTSB UNK78X0108](https://openairdocs.org/ntsb/UNK78X0108.md): Ted Smith 601P · Shearwater, Canada · Accident · No injuries · Closed · Feb 19, 1978 · N90674 · Substantial damage
- [NTSB UNK78X0107](https://openairdocs.org/ntsb/UNK78X0107.md): Aerostar 601P · Dartmouth, Canada · Accident · No injuries · Closed · Feb 19, 1978 · N90674 · Substantial damage
- [NTSB UNK78X0104](https://openairdocs.org/ntsb/UNK78X0104.md): Cessna 414 · Dorval, Canada · Accident · No injuries · Closed · Jan 21, 1978 · N508W · Substantial damage
- [NTSB MKC77OA003](https://openairdocs.org/ntsb/MKC77OA003.md): Aeronca 15AC · Tommyhow, Canada · Accident · No injuries · Closed · Aug 29, 1977 · N1457H · Substantial damage
- [NTSB MKC770A002](https://openairdocs.org/ntsb/MKC770A002.md): Piper PA-28 · Kipling, Canada · Accident · No injuries · Closed · Jul 9, 1977 · N15999 · Substantial damage
- [NTSB LAX76O0020](https://openairdocs.org/ntsb/LAX76O0020.md): Piper PA-28R · Victoria, Canada · Accident · 2 fatal · Closed · Aug 13, 1976 · N4849T · Destroyed
- [NTSB OAK76AP026](https://openairdocs.org/ntsb/OAK76AP026.md): Douglas DC-10 · Calgary, Canada · Accident · Serious injuries · Closed · Nov 3, 1975 · N101TV · No damage
- [NTSB SEA76OS002](https://openairdocs.org/ntsb/SEA76OS002.md): Cessna 172 · Clo-Oose, Canada · Accident · No injuries · Closed · Sep 20, 1975 · N7222G · Substantial damage
- [NTSB UNK75X0107](https://openairdocs.org/ntsb/UNK75X0107.md): Cessna 177 · Yarmouth, Canada · Accident · No injuries · Closed · Aug 9, 1975 · N3313F · Substantial damage
- [NTSB MKC75OK005](https://openairdocs.org/ntsb/MKC75OK005.md): Cessna 182 · Manitoba, Canada · Accident · Minor injuries · Closed · Jun 6, 1975 · N21413 · Substantial damage
- [NTSB NYC75ON005](https://openairdocs.org/ntsb/NYC75ON005.md): Beech E18S · Toronto, Canada · Accident · No injuries · Closed · Dec 3, 1974 · N3602B · Substantial damage
- [NTSB MKC75OK002](https://openairdocs.org/ntsb/MKC75OK002.md): Cessna 210 · Manitoba, Canada · Accident · Serious injuries · Closed · Sep 20, 1974 · N1912R · Destroyed
- [NTSB UNK73X0125](https://openairdocs.org/ntsb/UNK73X0125.md): Beech C-45H · Toronto, Canada · Incident · No injuries · Closed · Sep 25, 1973 · N4999E · Minor damage
- [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 UNK73X0112](https://openairdocs.org/ntsb/UNK73X0112.md): Cessna 180 · Ft.St.James, Canada · Accident · No injuries · Closed · Apr 16, 1973 · N1546C · Substantial damage
- [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 NYC73IN070](https://openairdocs.org/ntsb/NYC73IN070.md): Boeing 747 · Toronto, Canada · Incident · Minor injuries · Closed · Nov 21, 1972 · N93102 · Minor damage
- [NTSB CAN73F0905](https://openairdocs.org/ntsb/CAN73F0905.md): Aeronca S-85CA · Wakefield, Canada · Accident · No injuries · Closed · Nov 12, 1972 · N33818 · Substantial damage
- [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 UNK72X0115](https://openairdocs.org/ntsb/UNK72X0115.md): Beech A23-24 · Westree, Canada · Accident · Serious injuries · Closed · Sep 4, 1972 · N3694Q · Substantial damage
- [NTSB UNK72X0111](https://openairdocs.org/ntsb/UNK72X0111.md): Piper PA-28 · Kemptvlle, Canada · Accident · 2 fatal · Closed · Jul 20, 1972 · N2087T · Destroyed
- [NTSB CHI72AC099](https://openairdocs.org/ntsb/CHI72AC099.md): Douglas DC-10 · Windsor, Canada · Accident · Minor injuries · Closed · Jun 12, 1972 · N103AA · Substantial damage
- [NTSB UNK72X0106](https://openairdocs.org/ntsb/UNK72X0106.md): Cessna 182 · Princeton, Canada · Accident · No injuries · Closed · Mar 13, 1972 · N5452B · Substantial damage
- [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
- [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
- [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 UNK69X0132](https://openairdocs.org/ntsb/UNK69X0132.md): Hughes 369HS · Ladner, Canada · Accident · No injuries · Closed · Jul 12, 1969 · N9008F · Substantial damage
- [NTSB UNK69X0131](https://openairdocs.org/ntsb/UNK69X0131.md): Cessna 150F · Radium, Canada · Accident · 2 fatal · Closed · Jul 9, 1969 · N8621S · Substantial damage
- [NTSB CAN70AF538](https://openairdocs.org/ntsb/CAN70AF538.md): Bell 47G · Badger, Canada · Accident · Minor injuries · Closed · Jul 1, 1969 · N2814B · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=CD&page=2

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

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