Fatal NTSB investigations, Outside the U.S.
9 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2018 | 1 |
|---|---|
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' 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 GAA24WA274Accident · 1 fatalClass 5 · ForeignPiper 38 · Córdoba, SpainNTSB GAA24WA141Accident · 1 fatalClass 5 · ForeignCessna T210M · Leeds, United KingdomNTSB GAA23WA148Accident · 2 fatalClass 5 · ForeignCessna 185 · Sao Paulo, BrazilNTSB GAA23WA095Accident · 1 fatalClass 4 · ForeignCessna 182 · Belo Horizonte, BrazilNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyNTSB GAA21WA230Accident · 1 fatalClass 5 · ForeignBell 206 · Hope Bay, Canada, CanadaNTSB GAA21WA176Accident · 1 fatalClass 5 · ForeignBeech C90 · Durango, MexicoNTSB GAA19WA561Accident · 1 fatalForeign investigationMooney M20K · Orio al Serio, ItalyThe government of Italy has notified the NTSB of an accident involving a MOONEY M20K airplane that occurred on September 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…NTSB ANC18WA075Accident · 1 fatalForeign investigationPiper PA28 · Black Diamond, CanadaOn July 30, 2018, about 0133 Coordinated Universal Time, a Piper PA-28-161 airplane, C-GVZJ, was departing a cut hay field and collided with hay bales near Black Diamond, Alberta, Canada, under unknown circumstances. Of the two occupants onboard, 1 sustained…