NTSB investigations, 2019, Outside the U.S.
25 cases where the phase of flight was Maneuvering.
Cases per year
| 1964 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 6 |
| 1967 | 4 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 5 |
| 1971 | 3 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1997 | 1 |
| 1999 | 2 |
| 2003 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 9 |
| 2010 | 9 |
| 2011 | 18 |
| 2012 | 17 |
| 2013 | 21 |
| 2014 | 19 |
| 2015 | 42 |
| 2016 | 30 |
| 2017 | 37 |
| 2018 | 36 |
| 2019 | 25 |
| 2020 | 25 |
| 2021 | 39 |
| 2022 | 41 |
| 2023 | 41 |
| 2024 | 35 |
| 2025 | 40 |
| 2026 | 12 |
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\") = 2019
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
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") = 2019
AND c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
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 GAA20WA101Accident · 1 fatalForeign investigationPiper PA25 · Rio Branco, Cerro Largo, UruguayThe government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…NTSB WPR20WA044Accident · 2 fatalForeign investigationAngel 44 · Mareeba, AustraliaOn December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…NTSB GAA19WA598Accident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Kitzbühel, AustriaNTSB CEN20WA210Accident · 2 fatalForeign investigationPiper PA30 · Kaunas, LithuaniaThe government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…NTSB WPR20WA037Accident · 1 fatalForeign investigationRobinson R44 · Eschowe, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB WPR20WA010Accident · No injuriesForeign investigationBell 412 · Port Said City, EgyptOn October 11, 2019, about 1147 coordinated universal time, a Bell Helicopter 412EP, SU-CBX, impacted the sea about 65 miles north of Port Said City, Egypt after losing control in flight. There were no injuries to the two pilots and three passengers, and the…NTSB CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…NTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…NTSB ENG19WA040Accident · Minor injuriesForeign investigationAir Tractor AT301 · Airdrome Jorge Efrain, MexicoOn July 10, 2019, an Air Tractor AT-301, registration XB-GBA, powered by a Pratt & Whitney R1300 radial engine, operator by the owner stuck power cables and crashed during a local flight . The Mexican Direccion De Analisis de Accidentes E Incidentes De…NTSB WPR19WA277Accident · No injuriesForeign investigationRobinson R22 · Kutchera Station, AustraliaOn June 22, 2019, at 0900 local time, a Robinson R22 helicopter, VH-HHQ, collided with terrain near Kutchera Station, Australia. The pilot was fatally injured and the helicopter was substantially damaged. The flight was conducted under the pertinent civil…NTSB CEN19WA342Accident · 2 fatalForeign investigationBRM Aero Bristell NG5 · Belan, IrelandThe government of Ireland has notified the NTSB of an accident involving an amateur-built BRM Aero Bristell NG5 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…NTSB WPR19WA156Accident · 2 fatalForeign investigationCessna T210 · Mount Isa, AustraliaOn May 26, 2019, at 0547 coordinated universal time, a Cessna T210M, registration VH-SUX, collided with terrain during a surveying flight near Mount Isa, Queensland, Australia. The two crew were fatally injured, and the airplane sustained substantial…NTSB ERA19WA168Accident · Serious injuriesForeign investigationAyres S2R · Isla Bejucal, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB ERA19WA165Accident · 1 fatalForeign investigationRobinson R22 · Pegognaga, ItalyThe government of Italy has notified the NTSB of an accident involving a Robinson R22 Beta helicopter that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…NTSB GAA19WA201Accident · 1 fatalForeign investigationMoravan Z-50LA · Castel Viscardo, ItalyThe government of Italy has notified the NTSB of an accident involving a MORAVAN Z-50LA airplane that occurred on March 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB CEN19WA118Accident · Serious injuriesForeign investigationRobinson R44 · Stavnes, NorwayThe government of Norway has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on March 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB GAA19WA179Accident · 2 fatalForeign investigationEnstrom 480 · Blazkov village, Czech Republic., CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a ENSTROM 480 helicopter that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB GAA19WA175Accident · 1 fatalForeign investigationCessna 188 · Rio Pardo, State of Rio Grande do sul, Brazil, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 188 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaNTSB CEN19WA081Accident · 2 fatalForeign investigationCessna 150 · Atizapán de Zaragoza, México, México, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150H airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB ERA19WA101Accident · 2 fatalForeign investigationGlobe GC1A · Dom Pedrito County, BrazilThe government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoNTSB WPR19WA147Accident · Minor injuriesForeign investigationSikorsky S64 · Mount Eliza, AustraliaOn January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…NTSB ERA19WA090Accident · 1 fatalForeign investigationPiper PA25 · Jaguaré County, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…