NTSB investigations, Outside the U.S.
8 cases where the sequence of events included Prop/jet/rotor blast/suction.
Cases per year
| 2015 | 2 |
|---|---|
| 2016 | 1 |
| 2019 | 1 |
| 2023 | 2 |
| 2025 | 1 |
| 2026 | 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\" = '082' 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" = '082' 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 DCA26WA367Incident · No injuriesClass 5 · ForeignAirbus A321-271NX · Guayaquil, EcuadorNTSB GAA26WA032Accident · No injuriesClass 5 · ForeignPilatus PC24 · Lago Sul, BrazilNTSB DCA23WA460Incident · Serious injuriesClass 5 · ForeignBoeing 787 · Melbourne, AustraliaNTSB DCA23WA387Incident · No injuriesClass 5 · ForeignBoeing 737 · Corrientes, ArgentinaNTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…NTSB CEN16WA397Incident · No injuriesForeign investigationBombardier BD 700 1A10 · George Town, Cayman IslandsOn March 25, 2016, about 0345 coordinated universal time, an unoccupied Saab 340B airplane, VP-CKI, encountered jet blast from a taxiing Bombardier Global Express BD-700-1A10 airplane, N683GA, at the Owen Roberts International Airport, George Town, Cayman…NTSB DCA16WA103Accident · No injuriesForeign investigationBoeing 737 · Dublin, IrelandThe Ireland Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a Boeing 737-800 that occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…NTSB DCA15WA180Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 747 airplane, which occurred on August 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of…