NTSB investigations, Outside the U.S.
31 cases where the sequence of events included Birdstrike.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 6 |
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\" = '901' 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" = '901' 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 ENG26WA033OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoNTSB DCA26WA301Incident · No injuriesClass 5 · ForeignAirbus A321 · Brasilia, BrazilNTSB DCA26WA243Occurrence · No injuriesClass 5 · ForeignBombardier CL-600-2D24 · Montreal, CanadaNTSB DCA26WA216IncidentClass 5 · ForeignBoeing 737-8 · Liberia, Costa RicaNTSB DCA26WA162Accident · No injuriesClass 5 · ForeignBoeing 737 · Misawa, JapanNTSB DCA26WA136Incident · No injuriesClass 5 · ForeignMcdonnell Douglas DC-9 · Maiquetía, VenezuelaNTSB DCA25WA294IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB DCA25WA283Incident · No injuriesClass 5 · ForeignAirbus A321 · Madrid, SpainNTSB GAA24WA165Accident · 1 fatalClass 5 · ForeignExtra EA-330SC · Alcázar de San Juan, SpainNTSB DCA23WA302IncidentClass 3 · ForeignBoeing 737-8 · Havana, CubaNTSB ENG23WA018IncidentClass 5 · ForeignAirbus A321 · Guadalajara, MexicoNTSB ENG23WA023Incident · No injuriesClass 5 · ForeignBoeing 747 · Guadalajara, MexicoNTSB ENG23WA006Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaNTSB DCA22WA147IncidentClass 5 · ForeignBoeing 737-924ER · San Salvador, El SalvadorNTSB ENG22WA006AccidentClass 5 · ForeignBAE JETSTREAM4100 · Musina, South AfricaNTSB DCA21WA071IncidentClass 5 · ForeignBoeing 787-8 · Mexico City, MexicoNTSB DCA20WA142Accident · No injuriesForeign investigationBoeing 737 · Tokyo, JapanThe JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13.All…NTSB DCA18WA278Incident · No injuriesForeign investigationAirbus A321-271N · Tapachula, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIRBUS A321-271N airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB DCA18WA308Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA154Incident · No injuriesForeign investigationEmbraer S A ERJ170-200LR · MexicoThe government of Mexico has notified the NTSB of an incident involving a EMBRAER S A ERJ170-200LR airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB DCA17WA196Incident · No injuriesForeign investigationBoeing 737 · Leon, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA17WA053Incident · No injuriesForeign investigationBoeing Boeing 737-8K5 · Bournemouth, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING COMPANY BOEING 737-8K5 airplane that occurred on January 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's…NTSB CEN16WA327Incident · No injuriesForeign investigationRobinson R44 · Manchester, United KingdomOn June 13, 2016, at 1547 coordinated universal time, a Robinson R44, G-BZGO, sustained a bird strike to the lower left windscreen about eight miles north of Manchester Barton Airport (EGCB), Manchester, England. The helicopter sustained minor damage. No…NTSB CEN16WA141Accident · 3 fatalForeign investigationCessna 172 · Madrid, SpainOn March 31, 2016, about 1200 coordinated universal time (UTC), a Cessna 172 airplane, Spanish registration EC-JSM, collided with the terrain following a bird strike near Madrid, Spain. The pilot and two passengers sustained fatal injuries, and the airplane…NTSB DCA15WA106Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Lametia, ItalyThe ANSV of Italy has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA15WA212Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Civil Aviation Authority (PCAA) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on December 30, 2014. The NTSB has appointed a U.S. Accredited Representative to assist PCAA's investigation under the provisions…NTSB DCA13WA072Incident · No injuriesForeign investigationBoeing B737 · Guatemala City, GuatemalaOn 5 April 2013, at approximately 1029 local time, a Boeing 737-4Q8, registration N279AD, ingested a turkey vulture in the right engine during takeoff from La Aurora Airport, Guatemala City, Guatemala. Inspection of the airplane revealed damage to the first…NTSB DCA12RA153Accident · 19 fatalForeign investigationKathmandu, NepalOn September 28, 2012, a Sita Air Dornier 228, registration 9N-AHA, with Garrett (Honeywell) TPE 331 engines, reported a bird strike shortly and crash shortly after takeoff from Kathmandu-Tribhuvan Airport (KTM), Kathmandu, Nepal. The three crew members and…NTSB DCA12WA018Incident · No injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…NTSB DCA10WA071Incident · No injuriesForeign investigationBoeing 737 · Amsterdam Schiphol IAP, NetherlandsOn June 6, 2010, a Royal Air Maroc Boeing 737-400 experienced a bird strike during takeoff from Amsterdam Schiphol International Airport (EHAM), Amsterdam, the Netherlands. One engine lost power. The airplane returned to Schiphol and made an uneventful…NTSB DCA08RA063Accident · No injuriesForeign investigationBoeing B747-200 · Brussels, Belgiumimport