NTSB investigations, 1966, 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.
Cases per year
| 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
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\") = 1966
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") = 1966 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 UNK66X0172Accident · 2 fatalClosedAeronca 15AC · Z, CanadaNTSB UNK66X0171Accident · 4 fatalClosedCessna 320D · Embras, CanadaNTSB NYC67S0001Incident · No injuriesClosedBac 1-11 · Ntoronto, CanadaNTSB UNK66X0164Accident · Minor injuriesClosedGreat Lakes 2T-1A · Abbotsford, CanadaNTSB CAN F0404Accident · No injuriesClosedCessna 172 · St.Laurent, CanadaNTSB UNK66X0145Accident · 2 fatalClosedCessna 337 · Z, CanadaNTSB CAN66F0420Accident · 1 fatalClosedCessna 150F · Aishihik, CanadaNTSB UNK66X0139Accident · No injuriesClosedMaule M-4 · Vancouver, Canada