NTSB investigations, Outside the U.S.
17 cases where the sequence of events included Abrupt maneuver.
Cases per year
| 2011 | 1 |
|---|---|
| 2013 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '270' 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" = '270' 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 DCA24WA176Incident · Minor injuriesClass 5 · ForeignBoeing 777 · London, United KingdomNTSB DCA24WA214OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB DCA24WA125Accident · Serious injuriesClass 3 · ForeignBoeing 787 · Auckland, New ZealandNTSB DCA24WA216OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB DCA24WA044OccurrenceClass 5 · ForeignDe Havilland Dash 8 · Val-d'Or, CanadaNTSB DCA23WA157Occurrence · No injuriesClass 5 · ForeignBoeing 787 · Doha, QatarNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaNTSB GAA21WA244Accident · No injuriesClass 4 · ForeignBell 206 · Pereira, ColombiaNTSB GAA21WA017AccidentClass 5 · ForeignAir Tractor AT502 · Letsatsi Game Lodge, South AfricaNTSB GAA20WA093Incident · No injuriesForeign investigationSikorsky S92 · Foxcote house, Gloucestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on October 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB GAA19WA175Accident · 1 fatalForeign investigationCessna 188 · Rio Pardo, State of Rio Grande do sul, Brazil, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 188 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN19WA077Accident · 2 fatalForeign investigationRans S12 · Bavispe, MexicoNTSB CEN17WA193Accident · 1 fatalForeign investigationQuicksilver GT500 · Barcelona, SpainOn May 20, 2017, at 1000 local time, a Quicksilver GT-500, EC-BQ3, impacted terrain after making a steep left turn during takeoff from Gurb Aerodrome in Barcelona, Spain. The aircraft was destroyed, and the pilot was fatally injured. The flight was being…NTSB DCA16WA122Incident · No injuriesForeign investigationBoeing 737 · Malaga, SpainThe government of Spain has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB WPR13WA415Accident · 2 fatalForeign investigationLancair 360 - NO Series · Shenyang, ChinaOn September 17, 2013 about 0523 Universal Time, an experimental amateur-built Lancair, Canadian registration C-FXCK, collided with terrain while maneuvering near Shenyang, Liaoning Province, China. The airplane was participating in an aerobatic exhibition…NTSB DCA13WA060Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandOn 26 February 2013, at approximately 2232 UTC time, a Boeing B757-200, during a flight operated by Icelandair between Kastrup, Denmark, and Keflavik, Iceland, the flight crew received an EICAS message indicating a right hydraulic failure when at the top of…NTSB DCA11WA026Accident · Serious injuriesForeign investigationBoeing 767 · Atlantic Ocean, Canada.