NTSB investigations, 1969, Canada

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1969, Canada per year, 1963–2026: 85 cases
1963	1
1966	8
1967	15
1968	5
1969	12
1970	10
1971	7
1972	9
1973	5
1974	2
1975	4
1976	1
1977	2
1978	4

Latest cases

Query with 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") = 1969 AND c."eventStateOrRegion" = 'CD' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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\") = 1969
    AND c.\"eventStateOrRegion\" = 'CD' AND c.\"eventCountry\" = 'USA'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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") = 1969
  AND c."eventStateOrRegion" = 'CD' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB UNK70X0105Accident · 2 fatalClosedNpiper PA-22 · Brockville, CanadaNov 30, 1969 · N3934P · Destroyed NTSB UNK69X0140Accident · 1 fatalClosedMini Mustng 01 · Abbotsford, CanadaAug 8, 1969 · N9N · Destroyed NTSB CAN70A4457Accident · 3 fatalClosedSchweizer SGS126 · Hope, CanadaJul 26, 1969 · CF-VEQ · 2 aircraft · Destroyed NTSB UNK69X0132Accident · No injuriesClosedHughes 369HS · Ladner, CanadaJul 12, 1969 · N9008F · Substantial damage NTSB UNK69X0131Accident · 2 fatalClosedCessna 150F · Radium, CanadaJul 9, 1969 · N8621S · Substantial damage NTSB CAN70AF538Accident · Minor injuriesClosedBell 47G · Badger, CanadaJul 1, 1969 · N2814B · Substantial damage NTSB UNK69X0128Accident · 3 fatalClosedBeech 35 · Westwold, CanadaJun 28, 1969 · N2800V · Destroyed NTSB CAN69AF533Accident · No injuriesClosedMooney M20G · Labariere, CanadaJun 17, 1969 · N3937N · Substantial damage NTSB CAN69AF526Accident · 2 fatalClosedPiper PA-22 · Bowmanville, CanadaMay 18, 1969 · N7050D · Substantial damage NTSB UNK69X0119Accident · No injuriesClosedCessna 310N · Montreal, CanadaMay 6, 1969 · N4194Q · Substantial damage NTSB CAN69ACAIOAccident · No injuriesClosedCessna 172D · Couts, CanadaFeb 8, 1969 · N2379U · Substantial damage NTSB MKC69O0001Accident · Serious injuriesClosedMooney M20F · Parry, CanadaJan 5, 1969 · N3590N · Destroyed