NTSB investigations, Outside the U.S.
21 cases where the sequence of events included Ground handling event.
Cases per year
| 2011 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 2 |
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\" = '080' 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" = '080' 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 DCA26WA330Accident · Serious injuriesClass 5 · ForeignAirbus A321 · Mascot, AustraliaNTSB DCA26WA202Incident · No injuriesClass 5 · ForeignBoeing 747-428F · Ciudad de la Costa, UruguayNTSB DCA25WA296IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB DCA25WA247IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB DCA25WA014IncidentClass 5 · ForeignBoeing 787 · Doha, QatarNTSB DCA24WA317Accident · Serious injuriesClass 5 · ForeignBoeing 757 · Palma, SpainNTSB DCA24WA286AccidentClass 5 · ForeignBoeing 737 · London, United KingdomNTSB DCA24WA259AccidentClass 5 · ForeignBoeing 737 · Nuremburg, GermanyNTSB DCA24WA007Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Nairobi, KenyaNTSB DCA23WA070Accident · No injuriesClass 5 · ForeignBoeing 737 · Paris, FranceNTSB DCA23WA044Incident · No injuriesClass 5 · ForeignBoeing 757-232 · LIberia, Costa RicaNTSB DCA22WA076AccidentClass 5 · ForeignEmbraer ERJ190 · Copenhagen, DenmarkNTSB DCA22WA219AccidentClass 5 · ForeignBoeing 737 · Gwaska, NigeriaNTSB DCA21WA003AccidentClass 5 · ForeignBoeing 737-4B6 · San Jose, Costa RicaNTSB DCA20WA017Accident · Serious injuriesForeign investigationBoeing 747 · Ataturk, TürkiyeThe Transport Safety Investigation Center (TSIC) of Turkey has notified the NTSB of an accident involving a Boeing 747-400, which occurred on November 11, 2019. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB DCA18WA179Accident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-800, which occurred on April 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB DCA18WA048Incident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) of Singapore has notified the NTSB of an incident involving a Boeing 777, which occurred on November 29, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB DCA17WA226Incident · No injuriesForeign investigationAirbus A320 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of a serious incident involving a AIRBUS A320 airplane that occurred on September 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB DCA16WA152Incident · No injuriesForeign investigationAirbus A320 · Buenos Aires, ArgentinaThe JIAAC of Argentina has notified the NTSB of an incident involving a AIRBUS A320 airplane and a Boeing B737 airplane that occurred on May 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's…NTSB DCA16WA029Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe Air Accident Investigation Bureau of Singapore (AAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 06, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…NTSB DCA11WA043Accident · No injuriesForeign investigationBoeing B777 · Paris, FranceOn April 10, 2011, at 0950 UTC, a Boeing 777, registration C-FIVM, operated by Air Canada, was substantially damaged during pushback at the Charles DeGaulle International Airport, Paris, France, when the tow bar fractured and struck the airplane. The flight…