NTSB investigations, 2009, Outside the U.S.
30 cases where the phase of flight was Enroute.
Cases per year
| 1962 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 23 |
| 1965 | 21 |
| 1966 | 18 |
| 1967 | 26 |
| 1968 | 9 |
| 1969 | 22 |
| 1970 | 15 |
| 1971 | 11 |
| 1972 | 19 |
| 1973 | 16 |
| 1974 | 14 |
| 1975 | 19 |
| 1976 | 3 |
| 1977 | 8 |
| 1978 | 8 |
| 1979 | 4 |
| 1981 | 2 |
| 1982 | 3 |
| 1984 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 6 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 10 |
| 2009 | 30 |
| 2010 | 31 |
| 2011 | 39 |
| 2012 | 53 |
| 2013 | 57 |
| 2014 | 51 |
| 2015 | 71 |
| 2016 | 89 |
| 2017 | 77 |
| 2018 | 100 |
| 2019 | 124 |
| 2020 | 71 |
| 2021 | 119 |
| 2022 | 106 |
| 2023 | 112 |
| 2024 | 152 |
| 2025 | 138 |
| 2026 | 72 |
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\") = 2009
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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") = 2009
AND c."eventCountry" <> 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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 WPR10RA093Accident · 6 fatalClass 5 · ForeignCessna 185 · Baindoang, PNG, Papua New GuineaOn December 30, 2009, about 0618 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 185E, P2-MJL, made a forced emergency landing on mountainous terrain following a loss of oil pressure, about 1 nautical mile southwest of a remote…NTSB WPR10WA070Accident · 4 fatalForeign investigationRobinson R44 · Netanya, Israel, IsraelThe accident is under the jurisdiction of, and is being investigated, by the State of Israel, Ministry of Transport, Aviation Incidents and Accidents Investigation (AIAI).NTSB ERA10WA416Accident · No injuriesForeign investigationEmbraer EMB-720 · Fazenida Liberdade, Brazil, BrazilOn November 23 18, 2009, about 1440 Universal Coordinated Time (UTC), an Embraer EMB-720D, Brazilian registration PT-VIF, operated by W.P.Comercio De Cereais LTDA, collided with a fence as a result of a force landing from a loss of engine power during cruise…NTSB ERA10WA060Accident · 2 fatalForeign investigationRobinson R22B · Verona, ItalyOn October 26, 2009, at 1300 coordinated universal time, a Robinson R22B helicopter, Italian registration I-ANSO, was substantially damaged when it impacted water in Lake Garda, near Verona, Italy. The pilot and a passenger were fatally injured. Visual…NTSB ERA10WA044Accident · 1 fatalForeign investigationBritten Norman BN2A · Kralendijk, Bonaire, NTOn October 22, 2009, about 1417 universal coordinated time, a Britten Norman BN-2A/26, PJ-SUN, experienced a right engine failure during cruise flight, and subsequently ditched in the Caribbean Sea, near Kralendijk, Bonaire, Netherlands Antilles. The airplane…NTSB ERA10CA022Accident · Serious injuriesData collectionFinal reportBoeing 767-3P6 · ArgentinaAn inadvertent encounter with turbulence, which resulted in an injury to a flight cabin attendant.NTSB ERA10WA012Accident · 3 fatalForeign investigationAerospatiale AS350 · Cusco, PeruOn October 1, 2009, about 2205 UTC, a Eurocopter AS350-B3, Peruvian registration OB-1911-P, operated by Coyotair S.A.C., was destroyed following an impact with terrain near Cusco, Peru. The helicopter impacted against a hill side at approximately 11,700 feet…NTSB DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB ENG09IA016Incident · No injuriesIncident investigationFinal reportBoeing 767 432ER · St. Johns, CanadaIncorrect installation of a wire bundle, which contained wires for oxygen system, passenger address system and lavatory power, led to chafing of the wires on structure. The chafing eventually exposed the wire conductors and resulted in electrical arcing,…NTSB CEN09WA582Accident · 2 fatalForeign investigationReims F172 · Commune de Brethencourt, FranceUnder the jurisdiction and control of the French government.NTSB CEN09WA607Accident · No injuriesForeign investigationEurocopter AS350 B2 · Némisko, CanadaOn August 28, 2009, at 1200 eastern daylight time, a Eurocopter model AS350 B2 (AStar), s/n 3292, Canadian registration C-FHAP, experienced a loss of engine power during cruise flight near Némisko, Québec, Canada. The helicopter was substantially damaged…NTSB ERA09WA486Accident · Minor injuriesForeign investigationCessna 208 · La Tortuga, VenezuelaOn August 26, 2009, about 1152 UTC, a Cessna 208B, Venezuelan registration YV1182, registered to and operated by Linea Turista Aerotuy (LTA), as a scheduled domestic passenger flight, had a total loss of engine power. The airline transport (ATP) rated pilot…NTSB CEN09WA529Accident · 2 fatalForeign investigationBell 412 · Manzanillo, MexicoOn August 7, 2009 a Bell Helicopter model 212 was destroyed when it impacted the ground in low visibility mountainous terrain. The pilot and on board mechanic were killed. The helicopter is located near a mountain top and is not accessible. When to helicopter…NTSB DCA09IA071Incident · Minor injuriesIncident investigationFinal reportBoeing 767-224 · Bavaro, Dominican RepublicThe flight crew's inadvertent flight through the top of a convective updraft that resulted in an encounter with convective induced turbulence. Contributing to the severity of the incident was the unrestrained status of several passengers, contrary to the…NTSB DCA09WA066Incident · No injuriesForeign investigationBoeing 767 · Keflavik, IcelandOn July 20, 2009, UAL flight 949, a B767 enroute from London Heathrow to Chicago O'Hare experienced smoke in the cockpit and the crew elected to divert to Keflavik, Iceland. The flight landed without further incident and no injuries among the 11 crew and 178…NTSB ERA09WA408Accident · 2 fatalForeign investigationBeech A36 · Masizo del Roraima, Venezuela, VenezuelaOn July 16, 2009, about 1640 Atlantic standard time, the wreckage of a Beechcraft A36 A, N354RA, was located on the “Ilu – Tepuy” mountain, within the sector of Masizo del Roraima, Bolivar, Venezuela. The pilot had filed a flight plan from the Maurice Bishop…NTSB WPR09WA296Accident · 1 fatalForeign investigationRobinson R22 · Paraburdoo, AustraliaOn June 25, 2009 at 2230 local time, a Robinson R22 helicopter, Australia registry VH-HXO, collided with the ground near Paraburdoo, Western Australia. The helicopter was owned and operated by a private individual and was on a non-commercial cross country…NTSB DCA09IA064Incident · No injuriesIncident investigationFinal reportAirbus A330-323 · Kagoshima, JapanBrief and temporary blockage of the pitot probes in cruise flight, most likely due to ice crystals aloft, leading to erroneous airspeed indications and airplane automation degradation as designed. Contributing to the incidents were design features of the…NTSB DCA09WA062Incident · No injuriesForeign investigationBoeing 767 · North Bay, CanadaOn June 19, 2009, a Boeing 767-300, registration SP-LPA, operated by LOT Polish Airlines (flight number LOT 2) departed O'Hare International Airport, Chicago, Illinois (ORD) destined for Warsaw, Poland. In the vicinity of North Bay, Ontario, Canada, while…NTSB DCA09IA055Incident · No injuriesIncident investigationFinal reportAirbus A330 · Los Cayes, HaitiThe final report for this incident was combined with and can be found under NTSB Investigation number, DCA09IA064.NTSB ERA09LA418Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Cuba, CubaAn unanticipated inflight encounter with turbulence.NTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…NTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.NTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneNTSB CEN09WA174Accident · 4 fatalClass 5 · ForeignCirrus Design SR 22 · Itzehoe, GermanyOn February 24, 2009, at 1600 coordinated universal time, a Cirrus Design Corporation SR22 , German registered D-EPDK, was destroyed when it impacted terrain under unknown circumstances near Itzehoe Germany. Visual meteorological conditions prevailed at the…NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanNTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…NTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.NTSB ERA09RA161Accident · 2 fatalForeign investigationCessna 650 · Rome, ItalyNone.NTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.