NTSB investigations, 1972, Canada

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 CAN73F0906Accident · 3 fatalClosedPiper PA-23 · Aklavik, CanadaDec 8, 1972 · N4919P · Destroyed NTSB NYC73IN070Incident · Minor injuriesClosedBoeing 747 · Toronto, CanadaNov 21, 1972 · N93102 · Minor damage NTSB CAN73F0905Accident · No injuriesClosedAeronca S-85CA · Wakefield, CanadaNov 12, 1972 · N33818 · Substantial damage NTSB UNK73X0101Accident · 2 fatalClosedBeech 35P · Vancouver, CanadaOct 20, 1972 · N9656Y · Destroyed NTSB UNK73X0100Accident · 1 fatalClosedCessna 172L · Lamacaza, CanadaOct 16, 1972 · N4257L · Destroyed NTSB UNK72X0115Accident · Serious injuriesClosedBeech A23-24 · Westree, CanadaSep 4, 1972 · N3694Q · Substantial damage NTSB UNK72X0111Accident · 2 fatalClosedPiper PA-28 · Kemptvlle, CanadaJul 20, 1972 · N2087T · Destroyed NTSB CHI72AC099Accident · Minor injuriesClosedDouglas DC-10 · Windsor, CanadaJun 12, 1972 · N103AA · Substantial damage NTSB UNK72X0106Accident · No injuriesClosedCessna 182 · Princeton, CanadaMar 13, 1972 · N5452B · Substantial damage