NTSB investigations, 2019, Outside the U.S.
39 cases where the phase of flight was Initial climb.
Cases per year
| 1964 | 17 |
|---|---|
| 1965 | 11 |
| 1966 | 11 |
| 1967 | 16 |
| 1968 | 6 |
| 1969 | 5 |
| 1970 | 11 |
| 1971 | 6 |
| 1972 | 8 |
| 1973 | 6 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 10 |
| 2009 | 5 |
| 2010 | 12 |
| 2011 | 8 |
| 2012 | 13 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 22 |
| 2016 | 26 |
| 2017 | 24 |
| 2018 | 21 |
| 2019 | 39 |
| 2020 | 22 |
| 2021 | 40 |
| 2022 | 42 |
| 2023 | 39 |
| 2024 | 33 |
| 2025 | 41 |
| 2026 | 19 |
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 = 350)
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 = 350)
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 ERA20WA061Accident · 3 fatalForeign investigationPiper PA-32-301T · Vereda Cuzama, ColombiaThe government of Colombia has notified the NTSB of an accident involving a PIPER PA-32-301T airplane that occurred on December 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN20WA126Accident · No injuriesForeign investigationCessna 152 · San Salvador, El SalvadorOn December 27, 2019, about 0730 local time, a Cessna 152 airplane, YS-162PE, impacted terrain near San Salvador, El Salvador, and was destroyed. The two occupants were not injured. The accident investigation is under the jurisdiction and control of the…NTSB DCA20WA011Incident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13 as…NTSB WPR20WA137Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe government of South African Civil Aviation Authority has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on October 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South…NTSB GAA20WA077Accident · 2 fatalForeign investigationCessna 310 · La Piedad, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 310 airplane that occurred on October 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ENG20WA007Incident · No injuriesForeign investigationBAE AVRO146RJ · Cape Town, South AfricaOn October 9, 2019, a South African Airlink British Aerospace Avro 146-RJ85, registered in South Africa as ZS-TCP, experienced a No. 3 engine fire warning on departure from Cape Town International Aerodrome, Cape Town, South Africa. The airplane is equipped…NTSB ENG19WA041Incident · No injuriesForeign investigationEmbraer ERJ190 · Buenos Aires, ArgentinaThe Junta de Investigación de Accidentes de Aviación Civil (JIAAC) República ARGENTINA has notified the NTSB of an incident involving an Embraer ERJ190, which occurred on September 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB GAA19WA595Accident · 2 fatalForeign investigationCozy Mark IV · Rio Verda, GO, BrazilThe government of Brazil has notified the NTSB of an accident involving a COZY Mark IV airplane that occurred on September 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA19WA215Incident · No injuriesForeign investigationBoeing 737 · Cape Town, South AfricaThe government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB GAA19WA459Accident · 2 fatalForeign investigationDe Havilland DHC2 · Hawk Junction ON-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB DCA19WA190Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA19WA181Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…NTSB ENG19WA028Incident · No injuriesForeign investigationAirbus A320 · Delhi, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on June 26, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 1 (left)…NTSB CEN19WA201Accident · Serious injuriesForeign investigationPiper PA28R · Pointe-A-Pitre, GuadeloupeNTSB GAA19WA356Accident · 1 fatalForeign investigationPitts S2 · Saint-Jean-Port-Joli, CanadaNTSB GAA19WA357Accident · 1 fatalForeign investigationS.A.N. Jodel D-11 · La Cote, Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a S.A.N. Jodel D-11 airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB ANC19WA020Accident · 2 fatalForeign investigationCessna 170 · Whitehorse, CanadaNTSB GAA19WA275Accident · 2 fatalForeign investigationBeech F33 · Campo Grande County, BrazilNTSB GAA19WA291Accident · 2 fatalForeign investigationCessna T210 · Mahahual, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN19WA254Accident · Minor injuriesForeign investigationCirrus SR22 · Abergavenny, United KingdomOn May 12, 2019, about 0930 coordinated universal time (UTC), a Cirrus Aircraft SR22T airplane, Guernsey registration 2-RORO, serial number 701, was destroyed during a forced landing and postimpact fire following a loss of engine power shortly after takeoff…NTSB DCA19WA148Accident · 41 fatalForeign investigationSukhoi RRJ95 · Moscow, RussiaThe MAK of Russia has notified the NTSB of an accident involving a Sukhoi RRJ95 airplane that occurred on May 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the MAK's investigation under the provisions of ICAO Annex 13 as State of…NTSB GAA19WA249Accident · Minor injuriesForeign investigationGrumman AA1 · Grena, Denmark, DenmarkThe government of Denmark has notified the NTSB of an accident involving a GRUMMAN AA1 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…NTSB ENG19WA024Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 767-322, which occurred on April 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ENG19WA023Incident · No injuriesForeign investigationBoeing 767 · Johannesburg, South AfricaThe Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…NTSB ENG19RA019Incident · No injuriesForeign investigationAvro 146 · Tambo International Airport, South AfricaThe South Africa Accident and Incident Investigation Division (AIID) has notified the United States, as the State of Design and Manufacture for the Engines, of an engine in-flight shut down incident involving a BAE Aero 146 RJ85A, ZS-SSJ, that occurred near…NTSB ENG19WA017Incident · No injuriesForeign investigationAirbus A320 · Pune, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB ENG19WA018Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 1, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB GAA19WA223Accident · 1 fatalForeign investigationCessna A185 · Bocona, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA A185 airplane that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB DCA19RA101Accident · 157 fatalForeign investigationBoeing 737 · Addis Ababa, EthiopiaThe government of Ethiopia has notified the NTSB of an accident involving a BOEING 737 that occurred on March 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ethiopia's investigation under the provisions of ICAO…NTSB DCA19CA075Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737 · Bluefields, NicaraguaAn inadvertent encounter with clear air turbulence.NTSB DCA19WA072Incident · No injuriesForeign investigationBoeing 787 · Casablanca, MoroccoThe BEA of Morocco has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on February 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of Morocco's investigation under the provisions of ICAO Annex…NTSB GAA19WA342Incident · No injuriesForeign investigationRaytheon B200 · Lausanne-Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a RAYTHEON B200 airplane that occurred on February 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB ENG19WA009Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…NTSB WPR19WA059Accident · No injuriesForeign investigationCessna 182 · Tooradin, AustraliaOn January 6, 2019, at 1045 local time, a Cessna 182G, VH-DGF, collided with trees following a loss of engine power during the initial climb near Tooradin, Australia. The pilot and four passengers were not injured. The airplane was substantially damaged. The…NTSB ENG21WA016Incident · No injuriesClass 5 · ForeignBoeing 737 · Lagos, NigeriaNTSB ENG19WA010Incident · No injuriesForeign investigationAirbus A320 · Chennai, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…