NTSB investigations, Outside the U.S.
11 cases where the sequence of events included Inflight upset.
Cases per year
| 2013 | 2 |
|---|---|
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 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\" = '271' 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" = '271' 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 DCA26WA267Accident · No injuriesClass 3 · ForeignBoeing 737 · Arabian Sea, PakistanNTSB DCA25WA019IncidentClass 5 · ForeignAirbus A330 · International Waters, South AfricaNTSB DCA24WA186Accident · Serious injuriesClass 4 · ForeignBoeing 787 · Tbd, TürkiyeNTSB DCA24WA036OccurrenceClass 5 · ForeignBoeing 737 Max 8-200 · London, United KingdomNTSB DCA23WA455IncidentClass 5 · ForeignBoeing 737 · Ballina, AustraliaNTSB GAA22WA274AccidentClass 5 · ForeignBeech 90 · Le Bourget, FranceNTSB DCA20WA061Incident · No injuriesForeign investigationAirbus A319 · Panama City, PanamaThe government of Panama has notified the NTSB of an incident involving a Airbus A319 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Panama's investigation under the provisions…NTSB WPR18WA123Accident · 2 fatalForeign investigationCessna T210N · Oudtshoorn, South AfricaNTSB CEN17WA087Accident · No injuriesForeign investigationCessna 560 · Gardermoen, NorwayOn January 11, 2017, about 1521 UTC, a Cessna 560, Norwegian registration LN-IDB, experienced a control upset during departure from the Oslo Airport (ENGM), Gardermoan, Norway. The two pilots on board were not injured. The airplane sustained substantial…NTSB CEN14WA208Accident · No injuriesForeign investigationCessna 525A · Honiley, United KingdomNTSB WPR13LA137Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Latangai Island, Papua New GuineaThe failure of both the pilot and the fish master of the vessel to adequately monitor their environment, which resulted in a collision.