NTSB investigations, 2012, Outside the U.S.
11 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 5 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 18 |
| 2023 | 20 |
| 2024 | 19 |
| 2025 | 32 |
| 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\") = 2012
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\" = '900' 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") = 2012 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" = '900' 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 DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB DCA12WA105Incident · No injuriesForeign investigationAirbus A319 · Okinawa, JapanOn July 5, 2012, about 1324 Japan Standard Time (0424 UTC), an Airbus A319-112, (B2332), operated by China Eastern Airlines Co., Ltd., was instruction to hold short of the runway at the Naha Airport (OKA), Okinawa, Japan; however, the flight crew taxied onto…NTSB DCA12WA102Incident · No injuriesForeign investigationBoeing 767-323 · Sao Paulo, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 767 that occurred on July 3, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB DCA12WA089Accident · 14 fatalForeign investigationSikorsky S58 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación of Peru (CIAA) has notified the NTSB of an accident involving a Sikorsky S58 helicopter that occurred on June 06, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…NTSB DCA12WA070Accident · No injuriesForeign investigationBoeing 737 · Gothenburg, SwedenThe Swedish Accident Investigation Authority (SHK) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the SHK investigation under the provisions of ICAO…NTSB ERA12WA183Incident · No injuriesForeign investigationEmbraer EMB-500 · Campo Grande, BrazilOn February 3, 2012, about 2333 universal coordinated time, an Embraer EMB-500 airplane, Brazilian registration PR-PHE, experienced an anti-skid brake failure during landing roll at the Campo Grande International Airport (SBCG), Campo Grande, Brazil, which…NTSB DCA12WA028Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving an MD-80 that occurred on January 24, 2012. The ACAA delegated the investigation to the Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación…NTSB DCA12WA027Incident · No injuriesForeign investigationBoeing 777 · Rio de Janeiro, BrazilThe Brazilian Centro de Investigação e Prevenção deAcidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 777 that occurred on January, 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…