NTSB investigations, 2019, Outside the U.S.
32 cases where the phase of flight was Takeoff.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 9 |
| 1965 | 8 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 6 |
| 1970 | 5 |
| 1971 | 4 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 7 |
| 1975 | 5 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2007 | 1 |
| 2008 | 9 |
| 2009 | 7 |
| 2010 | 8 |
| 2011 | 15 |
| 2012 | 11 |
| 2013 | 9 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 29 |
| 2017 | 42 |
| 2018 | 29 |
| 2019 | 32 |
| 2020 | 30 |
| 2021 | 39 |
| 2022 | 41 |
| 2023 | 61 |
| 2024 | 71 |
| 2025 | 55 |
| 2026 | 26 |
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 = 300)
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 = 300)
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 WPR20WA251Incident · No injuriesForeign investigationDe Havilland DHC8 · Eaton, AustraliaThe government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB DCA20WA019Accident · 29 fatalForeign investigationDornier 228 · Gomo, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a DORNIER 228 airplane that occurred on November 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…NTSB DCA20WA022Incident · No injuriesForeign investigationBoeing 737 · Lyon, FranceThe government of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ENG20RA002Incident · No injuriesForeign investigationBoeing 777 · Bangkok, ThailandOn October 20, 2019, a Thai Airways International Boeing 777-300ER, powered by two General Electric GE90-115B turbofan engines, aborted takeoff after experiencing a No. 1 engine high pressure turbine uncontainment failure during takeoff roll. The incident is…NTSB WPR20WA011Incident · No injuriesClass 5 · ForeignDiamond DA42 · Singapore, SingaporeNTSB ERA19WA271Accident · 7 fatalForeign investigationPiper PA31 · Popayan, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA31 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB DCA19WA220Incident · No injuriesForeign investigationBoeing 737 · Malaga, SpainThe government of Spain has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB DCA19WA218Incident · No injuriesForeign investigationBoeing 767 · Jeddah, Saudi ArabiaThe AIB of Saudi Arabia has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on September 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIB's investigation under the provisions of ICAO Annex 13…NTSB ENG19WA044Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 19, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…NTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…NTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…NTSB ENG19RA038Incident · No injuriesForeign investigationRaytheon 390 · Hamburg, GermanyOn August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,…NTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…NTSB GAA19WA420Accident · 9 fatalForeign investigationAIRvan GA8 · Umea, SwedenThe government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB ANC19WA041Accident · 2 fatalForeign investigationRobinson R22 · Moscow, RussiaOn July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…NTSB DCA19WA184Incident · No injuriesForeign investigationBoeing 737 · San Jose, Costa RicaThe CETAC of Costa Rica has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CETAC's investigation under the provisions of ICAO Annex 13 as…NTSB GAA19WA386Accident · 2 fatalForeign investigationCessna 182 · Chimaltenango, GuatemalaNTSB DCA19WA173Incident · No injuriesForeign investigationBoeing 737 · Bandung, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…NTSB DCA19WA174Incident · No injuriesForeign investigationBoeing 737 · Birmingham, United KingdomThe government of United Kingdom has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB ENG19WA039Accident · Minor injuriesForeign investigationAtr ATR42 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a ATR 42-300 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB DCA19WA163Accident · No injuriesForeign investigationCasa C212 · Kuinga, KenyaThe Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…NTSB GAA19WA290Accident · 1 fatalForeign investigationCessna T210 · Belem County, State of Para, BrazilNTSB CEN19RA145Accident · 5 fatalForeign investigationPiper PA32 · Roatán, HondurasimportNTSB GAA19WA254Accident · No injuriesForeign investigationRobinson R44 · Guatape-Antioquia, ColombiaNTSB GAA19WA210Accident · 6 fatalForeign investigationBritten Norman BN2A · Marcel Marchant (SCPF), ChileThe government of Chile has notified the NTSB of an accident involving a BRITTEN NORMAN BN2A airplane that occurred on April 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the…NTSB DCA19WA129Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz de la Sierra, BoliviaThe AIG of Bolivia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AIG's investigation under the provisions of ICAO Annex 13 as State…NTSB GAA19WA222Accident · 2 fatalForeign investigationCessna U206 · Bolivar, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB CEN19WA105Accident · No injuriesForeign investigationPiper PA34 · Lagunilla, Costa RicaNTSB ENG19WA045Incident · No injuriesForeign investigationEmbraer ERJ190 · Devon, United Kingdom, United KingdomOn February 28, 2019, an Embraer ERJ 190-200 LR powered by two General Electric CF34 10E7 turbofan engines, experienced smoke filling the cabin during the takeoff roll from Exeter International Airport, Devon, United Kingdom. The takeoff was aborted and an…NTSB DCA19WA054Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Dubai, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of The United Arab Emirates has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD11 that occurred on January 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's…NTSB ERA19WA092Accident · 1 fatalForeign investigationPiper PA25 · Campinas do Sul County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA25-235 airplane that occurred on January 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…