NTSB investigations, Outside the U.S.
20 cases where the defining event was Altitude deviation.
Cases per year
| 2019 | 3 |
|---|---|
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 3 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '282')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '282') 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 DCA26WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Malaga, SpainNTSB DCA25WA327IncidentClass 5 · ForeignBoeing 767 · Sydney, AustraliaNTSB DCA25WA318IncidentClass 5 · ForeignBoeing 787 · Frankfurt, GermanyNTSB DCA24WA334IncidentClass 5 · ForeignBoeing 757-224 · Brussels, BelgiumNTSB DCA24WA184IncidentClass 5 · ForeignEmbraer ERJ190 · Brisbane Airport, AustraliaNTSB ENG24WA038Incident · No injuriesClass 3 · ForeignDornier 328 · Zurich, SwitzerlandNTSB DCA24WA292IncidentClass 5 · ForeignDornier 328 · Zurich, SwitzerlandNTSB GAA25WA085Incident · No injuriesClass 5 · ForeignSikorsky S92A · Offshore Vessel, AustraliaNTSB DCA24WA072IncidentClass 5 · ForeignBoeing 777 · Muscat, OmanNTSB DCA24WA066IncidentClass 5 · ForeignAirbus A320 · Geneva, SwitzerlandNTSB GAA24WA027Incident · No injuriesClass 5 · ForeignFokker F28 · Adelaide Aerodrome, AustraliaNTSB DCA23WA437IncidentClass 5 · ForeignEmbraer 190 · Alice Springs, AustraliaNTSB ENG24WA001IncidentClass 5 · ForeignDe Havilland DHC8 · Timaru, New ZealandNTSB DCA23WA045IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB DCA23WA033IncidentClass 5 · ForeignSaab 340 · Sydney, AustraliaNTSB DCA23WA032IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaNTSB DCA22WA039IncidentClass 5 · ForeignBoeing 737 · Kuusamo, FinlandNTSB DCA20WA152IncidentClass 5 · ForeignBoeing 737 · Paris, FranceNTSB OPS19WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB DCA19WA144Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe CIAIAC of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…