NTSB investigations, Outside the U.S.
6 cases where the sequence of events included Loss of visual reference.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2019 | 3 |
| 2021 | 1 |
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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '402' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '402' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA22WA029Accident · 1 fatalClass 5 · ForeignCessna P210N · Dornbirn, AustriaNTSB CEN20WA024Accident · 7 fatalForeign investigationPiper PA32 · Kingston, CanadaNTSB GAA19WA574Accident · 2 fatalForeign investigationCirrus SR22 · Pedreguer, SpainThe government of Spain has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…NTSB GAA19WA417Accident · 3 fatalForeign investigationDe Havilland DHC2 · Chibogamau, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ERA13WA068Accident · 4 fatalForeign investigationEmbraer 810D · Chapada dos Guimaraes, BrazilOn November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…NTSB ERA12WA113Accident · 1 fatalForeign investigationRobinson R44 · Sao Bento do Sul, BrazilOn December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…