NTSB investigations, 2016, Outside the U.S.
10 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2012 | 3 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 10 |
| 2017 | 4 |
| 2018 | 10 |
| 2019 | 20 |
| 2020 | 14 |
| 2021 | 11 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 21 |
| 2025 | 23 |
| 2026 | 21 |
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\" = '340' 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" = '340' 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 ENG16WA040Incident · No injuriesForeign investigationAirbus A319 · Chiclayo, PeruThe Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ENG16WA036Incident · No injuriesForeign investigationBoeing 777 · Tarcoola, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 777-31HER which occurred on September 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions…NTSB ENG16WA032Incident · No injuriesForeign investigationBoeing 787 · Over the Pacific, A1On August 7, 2016, a Jetstar Boeing 787, powered by 2 General Electric (GE) GEnx-1B64/P2 engines experienced a right engine (No. 2) low oil quantity indication while cruising over the Pacific. The engine was shutdown and the airplane was diverted to Guam…NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…NTSB ENG16WA013Incident · No injuriesForeign investigationAirbus A320 · Rome, ItalyThe Italian Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving an Airbus 320-216, which occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under…NTSB ENG16WA014Incident · No injuriesForeign investigationFairchild SA-227-AT · Brisbane, AustraliaDuring a post-flight inspection of a Fairchild SA227-AT, Registration Number VH-UZI, powered by two TPE331-11U-611G Honeywell Turbine engines, evidence of a fuel leak was detected on the left-hand engine. Further investigation revealed a fire on the left-hand…NTSB ENG16RA011Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…NTSB ENG16WA009Incident · No injuriesForeign investigationZurich, SwitzerlandOn March 10, 2016, about 1611 UTC, a Swiss Global Air Lines AVRO 146-RJ100 airplane, Swiss registration HB-IYT, rejected its takeoff at Zurich, Switzerland at 45 knots because of sparks coming from the No. 2 engine. The investigation of this incident is under…NTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…