NTSB investigations, 2016, Outside the U.S.
10 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 10 |
| 2017 | 8 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 7 |
| 2021 | 14 |
| 2022 | 13 |
| 2023 | 20 |
| 2024 | 10 |
| 2025 | 18 |
| 2026 | 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 year(c.\"eventDate\") = 2016
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' 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 year(c."eventDate") = 2016 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' 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 ERA17WA303Accident · 1 fatalForeign investigationSchempp Hirth VENTUS2C · San Carlos de Bolivar, ArgentinaOn December 3, 2016, about 1750 coordinated universal time, a Schempp Hirth Ventus-2C motorized glider, Argentine registration LV-EDB, operated by a private individual, was substantially damaged when it impacted terrain after the left wing detached from the…NTSB DCA17WA023Incident · No injuriesForeign investigationBoeing 737-476 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CCAA) has notified the NTSB of an incident involving a BOEING 737-476 airplane that occurred on November 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…NTSB ENG16RA030Incident · No injuriesForeign investigationAirbus A320 · Narita, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving an Airbus A320, which occurred on July 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Japan Transport Safety Board investigation under the…NTSB ERA16WA249Incident · No injuriesForeign investigationBeech B200 · Lima, PeruOn June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…NTSB DCA16WA185Accident · Serious injuriesForeign investigationEmbraer ERJ190 · Madrid, SpainThe Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) Spain has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on June 15, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB ENG16RA028Incident · No injuriesForeign investigationBombardier CL600 2C10 · Fukuoka, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving a Bombardier CL-600-2C10, JA06RJ, which took off from Fukuoka Airport at 07:48 local time to Komatsu Airport and during return back to Fukuoka Airport due to weather condition of…NTSB DCA16WA135Incident · No injuriesForeign investigationBoeing 737-76N · Porto de Moz Municipality, BrazilThe Brazil Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an accident involving a Boeing 737-76N that occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's…NTSB DCA16WA084Incident · No injuriesForeign investigationBoeing 747 · London, United KingdomThe Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on January 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN16WA099Accident · No injuriesForeign investigationEnstrom 280 · Buttwil, SwitzerlandOn January 22, 2016, about 0845 hours universal coordinated time, an Enstrom model 280C helicopter, Swiss registration HB-XLS, sustained damage to the tail rotor control system before liftoff from the Buttwil Airfield (LSZU), Buttwil, Switzerland. The pilot…