NTSB investigations, 2013, Outside the U.S.
30 cases where the phase of flight was Approach.
Cases per year
| 1962 | 3 |
|---|---|
| 1964 | 9 |
| 1965 | 11 |
| 1966 | 13 |
| 1967 | 8 |
| 1968 | 10 |
| 1969 | 8 |
| 1970 | 6 |
| 1971 | 8 |
| 1972 | 13 |
| 1973 | 10 |
| 1974 | 5 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 1 |
| 1980 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2008 | 3 |
| 2009 | 15 |
| 2010 | 7 |
| 2011 | 15 |
| 2012 | 11 |
| 2013 | 30 |
| 2014 | 18 |
| 2015 | 16 |
| 2016 | 34 |
| 2017 | 23 |
| 2018 | 32 |
| 2019 | 30 |
| 2020 | 16 |
| 2021 | 35 |
| 2022 | 32 |
| 2023 | 49 |
| 2024 | 39 |
| 2025 | 43 |
| 2026 | 21 |
Latest cases
Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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\") = 2013
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
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.
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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") = 2013
AND c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…NTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNTSB DCA14RA012Accident · 50 fatalForeign investigationBoeing 737 - 500 · Kazan, RussiaThe Russian Interstate Aviation Committee, Accident Investigation Commission (IAC) has notified the NTSB of an accident involving a Boeing 737-500 that occurred on November 17, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the IAC…NTSB ANC14WA020Incident · No injuriesForeign investigationCessna TU206 - G · Akita City, JapanOn November 16, 2013, at 0246 coordinated universal time, a Japanese registered Cessna 206 airplane, JA4000, operated by Honda Airways, experienced a total loss of engine power near Arayamachi, Akita City, Japan. The pilot made a successful emergency landing,…NTSB DCA14RA009Accident · 5 fatalForeign investigationSwearingen SA227 - AC · Red Lake, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Swearingen SA227 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions…NTSB DCA14WA007Accident · 10 fatalForeign investigationSwearingen SA227 · Riberalta, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a SWEARINGEN SA227 airplane that occurred on November 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the…NTSB CEN14WA038Accident · 3 fatalClass 5 · ForeignPiper PA-34 · Coburg, GermanyOn November 11, 2013, at 1020 coordinated universal time, a Piper PA-34, German registration D-GRCP, impacted trees while on approach to land at the Coburg/Brandensteinsebene Airport (EDQC), Coburg, Germany. The pilot and two passengers were fatally injured.…NTSB ERA14WA026Accident · 2 fatalForeign investigationLuscombe 8 - E · Buenos Aires, ArgentinaOn October 14, 2013, about 1134 coordinated universal time, a Luscombe 8E, Argentina registration LV-RTS, was substantially damaged, during descent in thick fog, when it impacted terrain in an industrial park. The flight had departed Zarate Airport (SATE),…NTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…NTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaNTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…NTSB ENG13WA044Incident · No injuriesForeign investigationBombardier CL600 2B19 · Moscow, RussiaOn September 7, 2013 a MNG Jet charter flight, a Bombardier Canadair CL-600-2B19-7763, registration TC-EJA, landed at Vnukovo International Airport, Moscow, Russian Federation, with the nose landing gear extended and both main gear retracted. The…NTSB ERA13WA401Accident · Serious injuriesForeign investigationPiper PA-32-300 · Macas, EcuadorOn August 30, 2013, about 1630 coordinated universal time (1130 local time), a Piper PA-32-300, Ecuadorian registration HC-BOD, was substantially damaged during a forced landing while approaching Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The Ecuadorian…NTSB CEN14WA225Accident · 4 fatalForeign investigationAirbus Helicopters 332L2 · Shetland Islands, United KingdomOn August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and…NTSB DCA13WA173Incident · No injuriesForeign investigationBoeing 737 · Las Palmas, SpainThe Spainish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC). has notified the NTSB of an accident involving a BOEING 737 that occurred on August 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…NTSB CEN13WA480Accident · 3 fatalForeign investigationSocata TBM-700 · Vertaizon, FranceNTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…NTSB ERA13WA376Accident · 4 fatalForeign investigationBeech 58 · Jundiai Municipality, BrazilOn August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The…NTSB DCA13WA129Accident · No injuriesForeign investigationCirrus SR20 · Randburg, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB ERA13WA332Accident · 2 fatalForeign investigationCessna 172N · Buenos Aires, ArgentinaOn July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor…NTSB ERA13WA322Accident · Serious injuriesForeign investigationCessna 208B · Mathews Ridge, GuyanaOn July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,…NTSB CEN13WA477Accident · Minor injuriesForeign investigationBeech 100 · Saint-Mathieu-de-Beloeil, CanadaOn June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),…NTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomNTSB DCA13WA103Incident · No injuriesForeign investigationBoeing 737-800 · Eindhoven, NetherlandsThe Dutch Safety Board (DSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on May 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13 as the…NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB WPR13WA197Accident · No injuriesForeign investigationCirrus SR22 · Zhuhai Sanzao Airport, ChinaOn March 27, 2013 about 1445 Beijing time, a Cirrus SR-22, Chinese registration B-9592, experienced a loss of engine power and subsequently ditched near Zhuhai Sanzao Airport, Guangdong Province, China. The airplane was operated as an instructional flight by…NTSB CEN13WA572Accident · 1 fatalForeign investigationPiper PA28 - 161 · Persan, FranceOn March 6, 2013, about 1920 universal coordinated time, a Piper PA28-161 airplane, F-GHPN, impacted terrain during final approach to land on runway 10, at the Persan-Beaumont Airport (LFPA), near Persan, France. The pilot was fatally injured. This…NTSB DCA13WA060Incident · No injuriesForeign investigationBoeing 757 · Keflavik, IcelandOn 26 February 2013, at approximately 2232 UTC time, a Boeing B757-200, during a flight operated by Icelandair between Kastrup, Denmark, and Keflavik, Iceland, the flight crew received an EICAS message indicating a right hydraulic failure when at the top of…NTSB DCA13WA050Accident · 21 fatalForeign investigationBombardier CL600 2B19 · Almaty, KazakhstanThe Accident Investigation Department of the Ministry of Transport and Communications of the Republic of Kazakhstan has notified the NTSB of an accident involving a Bombardier Challenger CRJ-200, registration UP-CJ006, which occurred on January 29, 2013. The…