# NTSB investigations: Unknown NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 14 of 40 · 1,981 cases ## Cases, newest first - [NTSB WPR17WA127](https://openairdocs.org/ntsb/WPR17WA127.md): Cessna 172 · Ballina, Australia · Accident · 1 fatal · Foreign investigation · Jun 16, 2017 · VH-FYN · Destroyed - [NTSB ANC17WA029](https://openairdocs.org/ntsb/ANC17WA029.md): Bell 206 · Fengbin, Taiwan · Accident · 3 fatal · Foreign investigation · Jun 10, 2017 · B-31118 · Destroyed > On June 10, 2017, about 1255 Taipei local time (0455 UTC), a Taiwanese registered Bell 206B3 helicopter, B-31118, operated by Emerald Pacific Airlines, impacted remote mountainous terrain about 8 miles south of Fengbin, Hualien County, under unknown… - [NTSB WPR17WA115](https://openairdocs.org/ntsb/WPR17WA115.md): Cessna 441 · Renmark, Australia · Accident · 3 fatal · Foreign investigation · May 30, 2017 · VH-XMJ · Substantial damage > On May 30, 2017, about 1630 Australian central standard time, a Cessna 441, equipped with Garret TPE331 series turboprop engines, registration VH-XMJ, collided with terrain shortly after takeoff from Renmark Aerodrome, Renmark, SA, Australia. The three crew… - [NTSB CEN17WA203](https://openairdocs.org/ntsb/CEN17WA203.md): Cessna 182 · Palmar Norte de Osa, Puntarenas, Costa Rica · Accident · 1 fatal · Foreign investigation · May 28, 2017 · HP-1760FT · Destroyed > On May 28, 2017, a Panamanian-flagged Cessna 182, serial number FT34567, and reported false registration HP-1760FT, was located crashed in an African palm seeding field on a farm near Palmar Norte of Osa, Puntarenas, Costa Rica. The pilot, the sole person on… - [NTSB CEN17WA199](https://openairdocs.org/ntsb/CEN17WA199.md): Piper PA28R · Skipness/Kintyre, Scotland, United Kingdom · Accident · 2 fatal · Foreign investigation · May 25, 2017 · G-CEOF · Destroyed > On May 25, 2017, about 1300 hours universal coordinated time, a Piper PA-28R-201, United Kingdom registration G-CEOF, impacted the sea near Skipness/Kintyre, Scotland, United Kingdom. The two occupants on-board were fatally injured. The flight departed Oban… - [NTSB ERA17WA198](https://openairdocs.org/ntsb/ERA17WA198.md): Cessna 206 · Cerro Azul, Ecuador · Accident · 2 fatal · Foreign investigation · May 18, 2017 · HC-CEG · Destroyed > On May 18, 2017, at an unknown time, a Cessna 206H, Ecuadorian registration HC-CEG, was destroyed when it impacted terrain in Cerro Azul, Ecuador. The foreign certificated pilot and one passenger were fatally injured. The flight departed Jose Joaquin de… - [NTSB CEN17WA175](https://openairdocs.org/ntsb/CEN17WA175.md): Socata-Groupe Aerospatiale TB 20 · Malaga, Spain · Accident · 3 fatal · Foreign investigation · Apr 29, 2017 · D-ECJP · Substantial damage > On April 29, 2017, at 1632 UTC, a Socata TB-20, D-ECJP, impacted terrain near Canillas de Aceituno in Malaga, Spain. The aircraft was destroyed, and the pilot and two passengers were fatally injured. The flight departed Mutxamel Airfield (LEMU) in Alicante,… - [NTSB ERA17WA179](https://openairdocs.org/ntsb/ERA17WA179.md): Piper PA30 · Sao Paulo, Brazil · Accident · 2 fatal · Foreign investigation · Apr 28, 2017 · PT-CHT · Substantial damage > On April 28, 2017, about 1930 coordinated universal time, a Piper PA30, Brazilian registration PT-CHT, was substantially damaged when it impacted terrain during an instructional flight near Sao Paulo, Brazil. The pilot and copilot were fatally injured. The… - [NTSB ERA17WA159](https://openairdocs.org/ntsb/ERA17WA159.md): Cessna 172 · Cassilandia, Brazil · Accident · 2 fatal · Foreign investigation · Apr 14, 2017 · PR-LPW · Substantial damage > On April 14, 2017, about 2045 coordinated universal time, a privately owned and operated Cessna 172N, Brazilian registration PR-LPW, was substantially damaged after it struck a tree about 400 meters from the threshold of runway 13 at the Aeroporto de… - [NTSB ERA17WA147](https://openairdocs.org/ntsb/ERA17WA147.md): Piper PA-42 · Sorocaba, Brazil · Accident · 2 fatal · Foreign investigation · Mar 31, 2017 · PP-EPB · Destroyed > On March 31, 2017, about 1745 coordinated universal time (1445 local time), a Piper PA-42, Brazilian registration PP-EPB, operated by a private individual, was destroyed after it impacted the ground while on approach to Barra Do Garcas Airport (SBBW),… - [NTSB CEN17WA137](https://openairdocs.org/ntsb/CEN17WA137.md): Cessna 152 · St-Bruno, Quebec, Canada · Accident · 1 fatal · Foreign investigation · Mar 17, 2017 · C-FGOI · 2 aircraft · Destroyed - [NTSB CEN17FA132](https://openairdocs.org/ntsb/CEN17FA132.md): Cessna 210B · Opal, SD · Accident · 1 fatal · Field investigation · Final report · Mar 16, 2017 · N9581X · Destroyed > The pilot's loss of airplane control for reasons that could not be determined due to a lack of evidence. - [NTSB CEN17WA133](https://openairdocs.org/ntsb/CEN17WA133.md): Cessna 172P · Manitouwadge, Canada · Accident · No injuries · Foreign investigation · Mar 15, 2017 · N230TX · Substantial damage > On March 15, 2017, at an unknown time, a Cessna 172P airplane, N230TX, owned and operated by the University of Michigan Flyers Inc. was substantially damaged when it collided with wooded terrain near Manitouwadge, Ontario, Canada. No pilot or occupant was… - [NTSB CEN17WA130](https://openairdocs.org/ntsb/CEN17WA130.md): Bell 206 · Figeac, France · Accident · 1 fatal · Foreign investigation · Mar 15, 2017 · F-GPPH · Destroyed > On March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and… - [NTSB CEN17CA140](https://openairdocs.org/ntsb/CEN17CA140.md): Cessna 172R · Cahokia, IL · Accident · No injuries · Data collection · Final report · Feb 23, 2017 · N51827 · Substantial damage > A hard landing for reasons that could not be determined based on the available evidence. - [NTSB ERA17WA104](https://openairdocs.org/ntsb/ERA17WA104.md): Robinson R66 · Lake Teletskoye, Russia · Accident · 5 fatal · Foreign investigation · Feb 12, 2017 · RA-06375 · Substantial damage > On February 12, 2017, at 1319 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-06375, was substantially damaged when it crashed into Lake Teletskoye, Republic of Altai, Russia. The pilot and four passengers were fatally injured.… - [NTSB CEN17WA102](https://openairdocs.org/ntsb/CEN17WA102.md): MD Helicopter 600 · Guatemala City, Guatemala · Accident · 4 fatal · Foreign investigation · Feb 7, 2017 · N245SE · Substantial damage > On February 7, 2017, about 1253 local time, a United States-registered MD 600N helicopter, N245SE, impacted terrain at the La Aurora International Airport, Guatemala City, Guatemala. The pilot and three passengers were fatally injured. The investigation is… - [NTSB ERA17WA350](https://openairdocs.org/ntsb/ERA17WA350.md): Beech 58 · Puerto la Cruz, Venezuela · Accident · 6 fatal · Foreign investigation · Jan 28, 2017 · YV-1513 · Destroyed > The government of Venezuela has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on January 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the… - [NTSB CEN17WA083](https://openairdocs.org/ntsb/CEN17WA083.md): Robinson R44 · Salinas Victoria, Mexico · Accident · 2 fatal · Foreign investigation · Jan 21, 2017 · XA-CSJ · Destroyed > On January 21, 2017, about 1800 universal coordinated time, a Robinson R44 helicopter, XA-CSJ, impacted terrain near Salinas Victoria, Mexico. The pilot and one passenger were fatally injured and the helicopter was destroyed by impact and fire damage. The… - [NTSB ERA17WA094](https://openairdocs.org/ntsb/ERA17WA094.md): Cessna 172 · Araucania, Chile · Accident · 2 fatal · Foreign investigation · Jan 20, 2017 · CC-AGK · Substantial damage > On January 20, 2017, about 2120 coordinated universal time, a Cessna 172S, Chilean registration CC-AGK, was substantially damaged when it impacted terrain near Araucania, Chile. The pilot and one passenger were fatally injured, while two other passengers were… - [NTSB ERA17WA093](https://openairdocs.org/ntsb/ERA17WA093.md): Hawker Beechcraft C90GT · Parati, Brazil · Accident · 5 fatal · Foreign investigation · Jan 19, 2017 · PR-SOM · Substantial damage > On January 19, 2017, about 1530 UTC, A Beechcraft C90GT, Brazilian registration PR-SOM, was destroyed when it impacted the sea after departing from Campo de Marte Airport (SBMT), Sao Paulo, Brazil. The five occupants were fatally injured.This accident… - [NTSB CEN17WA077](https://openairdocs.org/ntsb/CEN17WA077.md): Piper Piper PA-30 · Oxfordshire, United Kingdom · Accident · 1 fatal · Foreign investigation · Jan 15, 2017 · G-ATMT · Destroyed > On January 15, 2017, a Piper PA-30 airplane, (G-ATMT, s/n 30-439), crashed into woodland near Oxfordshire, United Kingdom. There was one person on board, who was fatally injured, and the aircraft was destroyed.This investigation is under the jurisdiction and… - [NTSB ERA17WA082](https://openairdocs.org/ntsb/ERA17WA082.md): Cessna A188 · Michiragua, Colombia · Accident · 1 fatal · Foreign investigation · Jan 7, 2017 · HK714 > On January 7, 2017, about 1315 UTC, a Cessna A188A; HK714 was lost at sea after takeoff from La Guajira, Columbia. The wreckage was not recovered and the pilot was presumed fatally injured.The investigation is under the jurisdiction of the Government of… - [NTSB WPR17FAMS2](https://openairdocs.org/ntsb/WPR17FAMS2.md): Cessna 172M · Open water, HI · Accident · 3 fatal · Missing aircraft · Final report · Dec 31, 2016 · N174LL · Destroyed > Undetermined because the airplane was not located. - [NTSB WPR17LA034](https://openairdocs.org/ntsb/WPR17LA034.md): Bell OH 58A · Sacramento, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 4, 2016 · N916PD · Substantial damage > The failure of the vertical stabilizer due to fatigue. - [NTSB ERA17WA062](https://openairdocs.org/ntsb/ERA17WA062.md): Robinson R44 · Vinogradny Township, Russia · Accident · 3 fatal · Foreign investigation · Nov 28, 2016 · RA-04195 · Substantial damage > On November 28, 2016, about 0638 universal coordinated time, a Robinson R44 helicopter, Russian registration RA-04195, was substantially damaged when it impacted terrain near Vinogradny Township, Russia, while enroute from Yalta, Russia, to Crimea, Russia.… - [NTSB ERA17WA049](https://openairdocs.org/ntsb/ERA17WA049.md): Cessna 172N · Kingston, Jamaica · Accident · 3 fatal · Foreign investigation · Nov 10, 2016 · N101KA · Destroyed > On November 18, 2016, about 1335 eastern standard time, a Cessna 172N, United Stated registration N101KA, operated by the Caribbean Aviation Training Centre, was destroyed when it impacted a building in Greenwich Farm, Kingston 13, Jamaica. The pilot and two… - [NTSB WPR17WA016](https://openairdocs.org/ntsb/WPR17WA016.md): Robinson R44 · Kamo, New Zealand, New Zealand · Accident · 2 fatal · Foreign investigation · Oct 30, 2016 · ZK-HTH · Destroyed > On October 30, 2016, a Robinson R44, ZK-HTH, was destroyed by fire after it collided with terrain near Kamo, New Zealand, The helicopter was operated by Helisika Agricultural Limited under the pertinent regulations of the government of New Zealand. The pilot… - [NTSB ERA17WA009](https://openairdocs.org/ntsb/ERA17WA009.md): Cessna 207 · Santa Cruz, Cajamarca, Peru · Accident · 3 fatal · Foreign investigation · Oct 10, 2016 · OB-1936-P · Destroyed > On October 10, 2016, about 1427 universal coordinated time, a Cessna 207A, Peruvian registration OB-1936-P, was destroyed during a collision with mountainous terrain near Santa Cruz, Cajamarca, Peru. The pilot and two passengers were fatally injured. The… - [NTSB ERA16WA327](https://openairdocs.org/ntsb/ERA16WA327.md): Agusta Bell AB206-B3 · Yartsevo, Russia · Accident · 2 fatal · Foreign investigation · Sep 24, 2016 · RA-01630 · Substantial damage > On September 24, 2016, at an unknown time, an Agusta-Bell AB206-B3 helicopter, Russian registration RA-01630, was substantially damaged when it crashed under unknown circumstances near Yartsevo, Russia. The pilot and passenger were fatally injured.The… - [NTSB CEN16WA365](https://openairdocs.org/ntsb/CEN16WA365.md): Robinson R66 · Carinthia, Austria · Accident · 1 fatal · Foreign investigation · Sep 8, 2016 · OE-XHA · Destroyed > On September 8, 2016, at 1920 coordinated universal time (UTC), a Robinson R66, Austrian registration OE-XHA, was destroyed when it impacted terrain under unknown circumstances near Carinthia, Austria. Visual meteorological conditions prevailed at the time of… - [NTSB CEN16WA368](https://openairdocs.org/ntsb/CEN16WA368.md): Piper PA34 · Skopje, Macedonia, North Macedonia · Accident · 6 fatal · Foreign investigation · Sep 6, 2016 · D-GLLW · Destroyed > On September 6, 2016, about 1540 local time, a Piper PA-34-200T multi-engine airplane, serial number 34-8070170, German registry D-GLLW, was destroyed after impacting terrain while on an ILS approach to Runway 34 at Alexander the Great Airport (LWSK), Skopje,… - [NTSB CEN16WA357](https://openairdocs.org/ntsb/CEN16WA357.md): Robin DR400 · Villanueva del Condado, Spain · Accident · 2 fatal · Foreign investigation · Sep 6, 2016 · EC-KFG · Substantial damage > On September 6, 2016, about 1420 hours coordinated universal time (UTC), a French manufactured Robin DR400-180 airplane, Spanish registration EC-KFG, impacted terrain neat Villanueva del Condado, Leon, Spain. The pilot and passenger were fatally injured. The… - [NTSB CEN16FA344](https://openairdocs.org/ntsb/CEN16FA344.md): Aves Douglas James RV 6 · Viborg, SD · Accident · 2 fatal · Field investigation · Final report · Sep 2, 2016 · N676DT · Destroyed > The pilot's failure to maintain airplane control, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, and subsequent flat spin into terrain. - [NTSB CEN16WA371](https://openairdocs.org/ntsb/CEN16WA371.md): Piper PA28 · Bovec, Slovenia · Accident · 3 fatal · Foreign investigation · Sep 1, 2016 · S5-DES · Destroyed > On September 1, 2016, about 1545 coordinated universal time, a Piper PA-28-161, Slovenia-registration S5-DES, was destroyed when it crashed into mountainous terrain near Bovec, Slovenia. The pilot and two passengers were fatally injured. The flight originated… - [NTSB CEN16WA337](https://openairdocs.org/ntsb/CEN16WA337.md): Yakovlev/Chinnery YAK 11 · Speyer, Germany · Accident · 1 fatal · Foreign investigation · Aug 25, 2016 · N111YK · Substantial damage > On August 25, 2016, at 0651 universal coordinated time, a Yakolev YAK-11, US registration N111YK, crashed under unknown circumstances in Speyer, Germany. The pilot was fatally injured and the airplane was destroyed. The accident investigation is under the… - [NTSB CEN16WA395](https://openairdocs.org/ntsb/CEN16WA395.md): Bell 206 · Sayaxché, Guatemala · Accident · Serious injuries · Foreign investigation · Aug 12, 2016 · TG-CHB · Substantial damage > On August 12, 2016, about 1500 universal coordinated time (UTC), a Guatemalan-registered Bell 206-L3 helicopter, TG-CHB, crashed near Sayaxche, Guatemala. The pilot was seriously injured, one passenger received minor injuries, and two passengers were… - [NTSB CEN16WA318](https://openairdocs.org/ntsb/CEN16WA318.md): Piper PA28 · Winchelsea, East Sussex, United Kingdom · Accident · 1 fatal · Foreign investigation · Aug 6, 2016 · G-CDER > On August 6, 2016, a Piper PA-28-161 airplane, G-CDER, sank after ditching near Winchelsea, East Sussex. The pilot was fatally injured. This investigation is under the jurisdiction and control of the government of the United Kingdom. Any further information… - [NTSB WPR16WA161](https://openairdocs.org/ntsb/WPR16WA161.md): Piper PA31 · Nong Prue, Thailand, Thailand · Accident · 1 fatal · Foreign investigation · Aug 1, 2016 · HS-FGB · Destroyed > On August 1, 2016, at 1605 local time, a Piper PA31-350, HS-FGB, was destroyed after it collided with a wooden bridge during an emergency landing near Nong Prue, Thailand. The aircraft was operated under the pertinent regulations of the Government of… - [NTSB CEN16WA272](https://openairdocs.org/ntsb/CEN16WA272.md): Robinson R22 · Madrid, Spain · Accident · 2 fatal · Foreign investigation · Jul 16, 2016 · EC-IGG · Substantial damage > On July 16, 2016, about 1240 hours universal coordinated time, a Robinson R-22 Beta helicopter, Spain registration EC-IGG, was substantially damaged when it impacted the Valmayor Reservoir near Valdemorillo, Madrid, Spain. Witnesses reported that the… - [NTSB CEN16WA268](https://openairdocs.org/ntsb/CEN16WA268.md): Piper PA-32R-301 · Ajdovscina, Slovenia · Accident · 4 fatal · Foreign investigation · Jul 14, 2016 · N710CC · Destroyed > The accident investigation is under the jurisdiction and control of the Republic of Slovenia. This report is for information purposes only and contains only information released by or obtained from the Republic of Slovenia. Further information pertaining to… - [NTSB ENG16WA025](https://openairdocs.org/ntsb/ENG16WA025.md): BAE JETSTREAM3100 · Buenos Aires, Argentina, Argentina · Incident · No injuries · Foreign investigation · Jun 16, 2016 · LV-ZST > On June 16, 2016, a Jetstream BA-32, registration number LV-ZST, powered by Honeywell TPE331 turbo propeller engines experienced an engine fire during an engine test. The incident is being investigated by the Argentinian Junta de Investigacion de Accidentes… - [NTSB CEN16WA327](https://openairdocs.org/ntsb/CEN16WA327.md): Robinson R44 · Manchester, United Kingdom · Incident · No injuries · Foreign investigation · Jun 13, 2016 · G-BZGO · Minor damage > On June 13, 2016, at 1547 coordinated universal time, a Robinson R44, G-BZGO, sustained a bird strike to the lower left windscreen about eight miles north of Manchester Barton Airport (EGCB), Manchester, England. The helicopter sustained minor damage. No… - [NTSB WPR16WA162](https://openairdocs.org/ntsb/WPR16WA162.md): Hawker Beech 900 · Chennai, India, India · Accident · No injuries · Foreign investigation · Jun 7, 2016 · VT-LTA · Substantial damage > On June 7, 2016, at 2006 local time, a Hawker 900 XP, VT-LTA, was substantially damaged after a nose gear sheared off during the landing near Chennai, India. The aircraft was operated under the pertinent regulations of the Government of India. The 2… - [NTSB WPR16WA123](https://openairdocs.org/ntsb/WPR16WA123.md): Bell 206 · Siriwo, Indonesia · Accident · 1 fatal · Foreign investigation · Jun 4, 2016 · PK-UAF · Substantial damage > On June 4, 2016, about 0815 local time, a Bell 206 helicopter, registration PK-UAF, sustained substantial damage following collision with terrain near Siriwo, Indonesia. Reports indicate that there were 4 soles onboard the helicopter; 1 fatal, 3 serious. The… - [NTSB CEN16WA205](https://openairdocs.org/ntsb/CEN16WA205.md): Vans RV4 · Coex, France · Accident · 1 fatal · Foreign investigation · Jun 1, 2016 · PH-EIL · Destroyed > On June 1, 2016, at 2100 local time, a Vans RV4, Netherlands registration PH-EIL, was destroyed when it collided with the terrain in Coex, France. The pilot was fatally injured and the passenger received serious injuries. At the time of this report, it is… - [NTSB ERA16LA201](https://openairdocs.org/ntsb/ERA16LA201.md): Criquet Aviation Bogota Columb Storch FI-156 · Fordsville, KY · Accident · 1 fatal · Limited investigation · Final report · May 30, 2016 · N429BB · Destroyed > The steep descent to ground impact for reasons that could not be determined based on the available evidence. - [NTSB CEN16WA198](https://openairdocs.org/ntsb/CEN16WA198.md): Amateur Construction Rans S6-ESD (Modifie · Shropshire, United Kingdom · Accident · 2 fatal · Foreign investigation · May 30, 2016 · G-MYES · Substantial damage > The United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of a fatal accident involving a Rans S-6ESD, registration G-MYES, which occurred on May 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB… - [NTSB WPR16FAMS1](https://openairdocs.org/ntsb/WPR16FAMS1.md): Cessna 172N · Avalon, CA · Accident · 2 fatal · Missing aircraft · Final report · May 28, 2016 · N739ZE · Destroyed > Undetermined because the airplane was not located. - [NTSB ERA16FA189](https://openairdocs.org/ntsb/ERA16FA189.md): Cessna 210 · Wantage, NJ · Accident · 1 fatal · Field investigation · Final report · May 17, 2016 · N6450N · Substantial damage > A collision with terrain for reasons that could not be determined as the investigation did not reveal any postaccident anomalies with the airplane or pilot. Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=15 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 990) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?page=14 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.