NTSB investigations, Outside the U.S.
6 cases where the sequence of events included AC/prop/rotor contact w person.
Cases per year
| 2012 | 1 |
|---|---|
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2025 | 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\" = '081' 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" = '081' 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 GAA25WA171Accident · 1 fatalClass 5 · ForeignCessna 188 · Trinidad Casanare, ColombiaNTSB GAA20WA098Accident · 1 fatalForeign investigationCessna 172 · Los Andes/San Raphael, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB GAA22WA262Accident · 1 fatalClass 5 · ForeignThrush S2R · Bataan, Costa RicaNTSB WPR16WA180Accident · 1 fatalForeign investigationCessna 172RG · Parafield Aerodrome, Australia, AustraliaOn September 11, 2016, at 1606 local time, Cessna 172RG, VH-MKG, while hand-starting the engine at Parafield Aerodrome, Australia, the pilot was fatally injured and the damage to the airplane is unknown. The flight was under the pertinent civil regulations of…NTSB DCA16WA198Accident · Serious injuriesForeign investigationBoeing Boeing 737-8AS · Charleroi, BelgiumThe Air Accident Investigation Unit of Belgium has notified the NTSB of an accident involving a Boeing 737 that occurred on July 01, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under the provisions of ICAO…NTSB ERA12WA447Accident · 1 fatalClass 5 · ForeignCessna 208 · Sao Paulo, BrazilOn July 9, 2012, at 1700 UTC, a Cessna 208, Brazilian registration PT-OQR, was substantially damaged when it collided with a parachutist during a local skydiving flight from Boituva Airport (SDOI), Boituva Municipality, Sao Paulo, Brazil. The parachutist…