NTSB investigations, 2018, Outside the U.S.
21 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\") = 2018
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") = 2018
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 DCA19WA049Incident · No injuriesForeign investigationBoeing 777 · Belo Horizonte, BrazilThe CENIPA of Brazil has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on December 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19RA017Accident · 191 fatalForeign investigationBoeing 737 · Jakarta, IndonesiaimportNTSB CEN19WA340Accident · No injuriesForeign investigationCessna F152 · Lingreville, FranceThe government of France has notified the NTSB of an accident involving a CESSNA F152 airplane that occurred on October 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB DCA18WA298Incident · No injuriesForeign investigationAirbus A320 · Sydney, AustraliaNTSB DCA18WA304Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of India's investigation under the provisions of ICAO Annex…NTSB ANC18WA062Accident · 2 fatalForeign investigationCessna 180 · Gold Bridge, CanadaOn August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…NTSB ERA18WA219Accident · 3 fatalForeign investigationCessna 210 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN18WA279Accident · 1 fatalForeign investigationCessna 150 · Tortola, British Virgin IslandsNTSB ERA18WA207Accident · 1 fatalForeign investigationAero Eli Servizi Yo-Yo 222 · Musile del Piave, ItalyThe government of Italy has notified the NTSB of an accident involving a Aero Eli Servizi Yo-Yo 222 helicopter that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB CEN18WA261Accident · 1 fatalForeign investigationRobinson R44 Raven I · Kanaš, SlovakiaOn July 7, 2018, at 1640 coordinated universal time, a Robinson R22 Raven 1, OM-TTM, impacted powerlines during takeoff near Kanaš, Slovak Republic. The helicopter was destroyed. The pilot sustained fatal injuries. The flight was originating at the time of…NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB ERA18WA212Accident · No injuriesForeign investigationCessna 172 · Macas, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB CEN18WA196Accident · 1 fatalForeign investigationAvid Avid Flyer · Granada, SpainOn May 26, 2018, at 1030 UTC, an Avid Flyer Stol, EC-YFP, encountered a loss of climb during initial climb out and subsequent impact with terrain near Loja Aerodrome, Granada, Spain. The experimental airplane was destroyed; the pilot suffered serious injuries…NTSB ENG18RA029Incident · No injuriesForeign investigationBoeing 767 · Kumamoto, Japan, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B767-300 that occurred May 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13…NTSB CEN18WA154Accident · 2 fatalForeign investigationAmateur Construction Vari EZE · Innsbruck, AustriaOn April 29, 2018, about 0819 hours universal coordinated time, an amateur-built Vari-Eze airplane, Swiss registration HB-YCM, impacted terrain shortly after takeoff from the Innsbruck Airport (LOWI), Innsbruck, Austria. The pilot and passenger were fatally…NTSB ENG18WA025Incident · No injuriesForeign investigationAirbus A330 · Brisbane, QLD, AustraliaThe Australian Government has notified the NTSB of an incident involving an Airbus A330-202 that occurred April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau (ATSB) investigation under the…NTSB DCA18WA308Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18RA093Incident · Minor injuriesForeign investigationAirbus A330 · Lagos, NigeriaThe AIB of Nigeria has notified the NTSB of an incident involving a Airbus A330 airplane that occurred on February 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB of Nigeria's investigation under the provisions of ICAO…NTSB DCA18WA107Accident · 71 fatalForeign investigationAntonov AN148 · Argunovo, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a ANTONOV AN-148 airplane that occurred on February 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the…NTSB ERA18WA261Accident · Serious injuriesForeign investigationSkyrunner MK 3.2 · Margham, Dubai, United Arab EmiratesThe government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab…NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…