# 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 15 of 40 · 1,981 cases

## Cases, newest first

- [NTSB CEN16WA199](https://openairdocs.org/ntsb/CEN16WA199.md): Piper PA-28R-200 · Halden, Norway · Accident · 1 fatal · Foreign investigation · May 17, 2016 · LN-AAM · Destroyed
  > On May 17, 2016, about 1615 coordinated universal time (UTC), a Piper Aircraft, Inc. PA-28R-200 airplane, Norwegian registration LN-AAM, impacted trees and terrain, near Halden, Norway. The airplane was destroyed during impact and the pilot, the sole…
- [NTSB CEN16WA160](https://openairdocs.org/ntsb/CEN16WA160.md): Extra Flugzeugbau EA 300/L · Cozumel, Mexico · Accident · 1 fatal · Foreign investigation · Apr 17, 2016 · N13DK · Destroyed
  > On April 17, 2016, at 1940 UTC, an Extra EA300, N13DK, impacted terrain at Cozumel International Airport (MMCZ) in Cozumel, Mexico. The aircraft was destroyed and the pilot, the sole occupant, was fatally injured. This investigation is under the jurisdiction…
- [NTSB CEN16WA149](https://openairdocs.org/ntsb/CEN16WA149.md): Robinson Helicopter R44 II · Atemajac de Brizuela, Mexico · Accident · Serious injuries · Foreign investigation · Apr 2, 2016 · N565AC · Destroyed
  > On April 2, 2015, about 2120 universal coordinated time, a Robinson Helicopter Company R44 II helicopter, N565AC, impacted terrain near Atemajac de Brizuela, Mexico. The pilot and two passengers were uninjured and one passenger sustained a serious injury. The…
- [NTSB CEN16WA142](https://openairdocs.org/ntsb/CEN16WA142.md): York Laser Z-200 · Abbeyshrule, Ireland · Accident · 1 fatal · Foreign investigation · Mar 20, 2016 · PH-LSR · Destroyed
  > On March 20, 2016, at 1745 coordinated universal time (UTC), an experimental amateur built York Laser Z-200 airplane, Dutch registered PH-LSR, was destroyed when it impacted terrain under unknown circumstances near Abbeyshrule, County Longford, Ireland. The…
- [NTSB WPR16WA085](https://openairdocs.org/ntsb/WPR16WA085.md): Zlin Z242L · Hong Kong, Hong Kong SAR China · Accident · 1 fatal · Foreign investigation · Feb 27, 2016 · B-LUR · Substantial damage
  > On February 27, 2016, approximately 0610 coordinated universal time (UTC), a Zlin Z242L, Hong Kong registration B-LUR, was substantially damaged when it impacted the water under unknown circumstances near the Tolo Harbour, Tai Po, Hong Kong. The pilot, the…
- [NTSB CEN16WA109](https://openairdocs.org/ntsb/CEN16WA109.md): Piper PA28 · Palin, Guatemala · Accident · 1 fatal · Foreign investigation · Feb 23, 2016 · TG-PEW · Destroyed
  > On February 23, 2016, at 1805 coordinated universal time, a Piper PA28-140, Guatemalian registration TG-PEW, was destroyed when it impacted the terrain near Palin, Guatemala. The pilot was fatally injured. The flight originated from La Aurora Airport,…
- [NTSB ERA16WA096](https://openairdocs.org/ntsb/ERA16WA096.md): Mcdonnell Douglas MD-600 · Taldykorgan, Kazakhstan · Accident · 5 fatal · Foreign investigation · Jan 27, 2016 · UP-MD004 · Substantial damage
  > On January 27, 2016, about 1747 local time, a McDonnell-Douglas MD-600N helicopter, Kazakhstan registration UP-MD004, registered to LLP Svinestroy and operated by JSC Aspan, impacted terrain under unknown circumstances after requesting to air traffic control…
- [NTSB ERA16WA088](https://openairdocs.org/ntsb/ERA16WA088.md): Cessna T188 · Bom Jesus de Goiás, Brazil · Accident · 2 fatal · Foreign investigation · Jan 7, 2016 · PR-INS · Destroyed
  > On January 7, 2016, about 1900 coordinated universal time, a Cessna T188C, Brazilian registration PR-INS, operated by Blitz Comercio e Representacoes Ltda, was destroyed when it impacted terrain while spraying insecticides on a sugar cane plantation in Bom…
- [NTSB CEN16WA071](https://openairdocs.org/ntsb/CEN16WA071.md): Socata TB9 · Malaga, Spain · Accident · 2 fatal · Foreign investigation · Dec 24, 2015 · EC-LIQ · Destroyed
  > The Comisión De Investigación De Accidentes E Incidentes De Aviación Civil (CIAIAC) of Spain has notified the NTSB of a fatal accident involving a Socata TB-9 airplane, EC-LIQ, that occurred on December 24, 2015. The NTSB has appointed a U.S. Accredited…
- [NTSB CEN16WA044](https://openairdocs.org/ntsb/CEN16WA044.md): Bell 206 · San Carlos, Nicaragua · Accident · 3 fatal · Foreign investigation · Nov 17, 2015 · YN-ISA · Destroyed
  > On November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…
- [NTSB ERA16WA038](https://openairdocs.org/ntsb/ERA16WA038.md): Air Tractor AT-502B · Balsas, Brazil · Accident · 1 fatal · Foreign investigation · Nov 9, 2015 · PR-RSA · Destroyed
  > On November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…
- [NTSB ERA16WA050](https://openairdocs.org/ntsb/ERA16WA050.md): Cessna 150H · Rondonopolis Municipality, Brazil · Accident · 2 fatal · Foreign investigation · Oct 22, 2015 · PR-DMT · Destroyed
  > On October 22, 2015, about 1130 coordinated universal time, a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…
- [NTSB ERA16WA013](https://openairdocs.org/ntsb/ERA16WA013.md): Cessna 208B · Yumbillo, Colombia · Accident · 3 fatal · Foreign investigation · Oct 14, 2015 · PR-MIC · Destroyed
  > On October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…
- [NTSB CEN16WA009](https://openairdocs.org/ntsb/CEN16WA009.md): Bell 430 · Xalapa, Mexico · Accident · 2 fatal · Foreign investigation · Oct 6, 2015 · XC-VER · Destroyed
  > On October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…
- [NTSB WPR15WA271](https://openairdocs.org/ntsb/WPR15WA271.md): Bell 407 · Chong Qing, China, China · Accident · 4 fatal · Foreign investigation · Sep 13, 2015 · B-7702 · Substantial damage
  > On September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…
- [NTSB ERA15WA355](https://openairdocs.org/ntsb/ERA15WA355.md): Smith AEROSTAR600 · Santa Fé de Antioquia, Colombia · Accident · 2 fatal · Foreign investigation · Sep 11, 2015 · N164HH · Destroyed
- [NTSB CEN15WA406](https://openairdocs.org/ntsb/CEN15WA406.md): Beech Beech C 24R · Könnern, Germany · Accident · 1 fatal · Foreign investigation · Sep 10, 2015 · D-EHZK · Substantial damage
  > On September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…
- [NTSB WPR15WA259](https://openairdocs.org/ntsb/WPR15WA259.md): Cessna 172 · Ballarat, Australia, Australia · Accident · 1 fatal · Foreign investigation · Sep 8, 2015 · VH-ZEW · Destroyed
  > On September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…
- [NTSB CEN15WA380](https://openairdocs.org/ntsb/CEN15WA380.md): Dehavilland DHC-2 MK. I · Lac Long, Canada · Accident · 6 fatal · Foreign investigation · Aug 23, 2015 · C-FKRJ
  > On August 23, 2015, about 1530 coordinated universal time, a De Havilland DHC-2 MK. I airplane, collided with wooded mountainous terrain near Lac Long, Quebec, Canada. The pilot and 5 passengers were fatally injured. The accident investigation is under the…
- [NTSB CEN15WA349](https://openairdocs.org/ntsb/CEN15WA349.md): Cessna 172F · La Blanca, Guatemala · Accident · 1 fatal · Foreign investigation · Aug 4, 2015 · TG-ZAB · Destroyed
  > On August 4, 2015, at 1315 coordinated universal time, a Cessna 172F, Guatemalian registration TG-ZAB, operated by AFYCO S.A., was destroyed when it impacted the terrain near La Blanca, Guatemala, during an aerial application flight. The pilot was fatally…
- [NTSB CEN15WA283](https://openairdocs.org/ntsb/CEN15WA283.md): Lake LA4 - 200 · Split, Croatia · Accident · 2 fatal · Foreign investigation · Jun 25, 2015 · 9A-DLA · Destroyed
  > On June 25, 2015, at 1735 universal coordinated time (UTC), a Lake Aircraft LA4-200, Croatian Registration 9A-DLA, was destroyed when it contacted the sea near the Split Airport (LDSP), Resnik, Croatia. One pilot and the sole passenger were fatally injured.…
- [NTSB ANC15WA043](https://openairdocs.org/ntsb/ANC15WA043.md): Cessna 172 · Fort McMurray, Canada · Accident · 2 fatal · Foreign investigation · Jun 22, 2015 · C-GJSE · 2 aircraft · Substantial damage
- [NTSB WPR15WA188](https://openairdocs.org/ntsb/WPR15WA188.md): Robinson R44 - Undesignat · Timber Creek, Australia, Australia · Accident · 1 fatal · Foreign investigation · Jun 14, 2015 · VH-KJJ · Substantial damage
  > On June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…
- [NTSB GAA15CA161](https://openairdocs.org/ntsb/GAA15CA161.md): Cessna 172S · Galesburg, IL · Accident · No injuries · Data collection · Final report · Jun 10, 2015 · N740SP · Substantial damage
  > Firewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.
- [NTSB CEN15WA262](https://openairdocs.org/ntsb/CEN15WA262.md): Bell Helicopter 206B · Baldwin, United Kingdom · Accident · 1 fatal · Foreign investigation · Jun 6, 2015 · G-RAMY · Substantial damage
  > On June 6, 2015, about 0810 coordinated universal time, a Bell 206B helicopter, G-RAMY, impacted mountainous terrain near Baldwin, Isle of Man, United Kingdom. The pilot, the sole occupant, was fatally injured.The accident investigation is under the…
- [NTSB CEN15WA251](https://openairdocs.org/ntsb/CEN15WA251.md): M7 Aerospace SA226 - TC · Queretaro, Mexico · Accident · 5 fatal · Foreign investigation · Jun 2, 2015 · XA-UKP · Destroyed
  > On June 2, 2015, about 1425 central daylight time, an M7 Aerospace LLC SA226-TC airplane, XA-UKP, impacted terrain near Queretaro, Mexico. A postimpact ground fire occurred. The pilot, co-pilot, and three passengers were fatally injured and the airplane was…
- [NTSB ANC15FA032](https://openairdocs.org/ntsb/ANC15FA032.md): Cessna 207 · Bethel, AK · Accident · 1 fatal · Field investigation · Final report · May 30, 2015 · N1653U · Substantial damage
  > The pilot's failure to maintain altitude, which resulted in collision with the terrain. Contributing to the accident was the pilot's impairment from carbon monoxide exposure in flight. The source of the carbon monoxide could not be determined because the…
- [NTSB ANC15WA029](https://openairdocs.org/ntsb/ANC15WA029.md): Air Tractor AT802-A · Cold Lake, Canada · Accident · 1 fatal · Foreign investigation · May 22, 2015 · C-FDHV · Substantial damage
  > On May 22, 2015, at 1630 mountain daylight time, a Canadian registered Air Tractor, AT-802A airplane, C-FDHV, operated by the Conair Group Inc., was destroyed when it collided with terrain under unknown circumstances during firefighting operations near Cold…
- [NTSB CEN15WA234](https://openairdocs.org/ntsb/CEN15WA234.md): Hughes 369 · Bocognano, Corse-du-Sud, France, France · Accident · Serious injuries · Foreign investigation · May 18, 2015 · OH-HNR · Destroyed
  > On May 18, 2015, about 0810 hours universal coordinated time, a Hughes model 369 helicopter, Finland registration OH-HNR, impacted terrain near Bocognano, Corse-du-Sud, France. The two crew members were seriously injured. The flight itinerary and purpose of…
- [NTSB WPR15FAMS1](https://openairdocs.org/ntsb/WPR15FAMS1.md): Cessna 172S · Davenport, CA · Accident · 1 fatal · Missing aircraft · Final report · May 8, 2015 · N191TG
  > Undetermined because the airplane was not located.
- [NTSB CEN15LA185](https://openairdocs.org/ntsb/CEN15LA185.md): Giackino Donald W Rotorway 162F · Marquette, MI · Accident · No injuries · Limited investigation · Final report · Mar 28, 2015 · N556DG · Substantial damage
  > The loss of helicopter control for reasons that could not be determined based on the available evidence.
- [NTSB GAA15CA018](https://openairdocs.org/ntsb/GAA15CA018.md): Cessna 172S · Camarillo, CA · Accident · No injuries · Data collection · Final report · Mar 23, 2015 · N2104H · Substantial damage
  > The pilot involved and the phase of flight when the damage occurred were not determined.
- [NTSB CEN15WA143](https://openairdocs.org/ntsb/CEN15WA143.md): Judr Zdenek Prazdny Rotorway · Bohušovice nad Ohrí, Czechia · Accident · 1 fatal · Foreign investigation · Feb 12, 2015 · N111ZP · Destroyed
- [NTSB CEN15WA145](https://openairdocs.org/ntsb/CEN15WA145.md): Pioneer 400 · Blackwood Forest, Hampshire, U.K., United Kingdom · Accident · 2 fatal · Foreign investigation · Jan 3, 2015 · G-CVGO · Destroyed
  > On January 3, 2015, about 1530 UTC, a Pioneer 400 airplane, G-CVGO (s/n LAA 364-15006) impacted terrain near Blackwood Forest, Hampshire. Two persons on board were fatally injured and one was seriously injured. The airplane was destroyed. This investigation…
- [NTSB CEN15WA455](https://openairdocs.org/ntsb/CEN15WA455.md): Rans S6 · Beja, Portugal · Accident · Serious injuries · Foreign investigation · Jan 1, 2015 · CS-UJF · Destroyed
  > On January 1, 2015, about 1700 local time, a Rans S-6 Coyote II, Portuguese registration CS-UJF, impacted terrain after departure from the Beja Civil Aerodrome (LPBE), Beja, Portugal. The pilot and passenger were seriously injured and the airplane was…
- [NTSB ERA15WA078](https://openairdocs.org/ntsb/ERA15WA078.md): Cessna U206F · Campo Grande, Brazil · Accident · 2 fatal · Foreign investigation · Dec 6, 2014 · PT-JSM · Substantial damage
- [NTSB WPR15WA065](https://openairdocs.org/ntsb/WPR15WA065.md): Ayres Thrush S2R-T34 · Manado, Indonesia, Indonesia · Accident · 2 fatal · Foreign investigation · Dec 2, 2014 · PK-ELR · Destroyed
  > On December 2, 2014, about 0250 universal coordinated time, an Ayres Trush, S2R-T34, PK-ELR, ditched in the sea under unknown circumstances. A tail wheel tire, elevator, both main landing gears, and some personal equipment were located 1 mile from the…
- [NTSB WPR15WA064](https://openairdocs.org/ntsb/WPR15WA064.md): Liberty Aerospace XL2 · Sumbawa, Indonesia, Indonesia · Accident · 2 fatal · Foreign investigation · Oct 30, 2014 · PK-LLC · Substantial damage
  > On October 30, 2014, about 0330 universal coordinated time, a Liberty Aerospace XL2, PK-LLC, was reported missing after contact was lost with the airplane. A search was initiated and the wreckage was subsequently located on December 15, 2014, South of Moyo…
- [NTSB ERA15LA001](https://openairdocs.org/ntsb/ERA15LA001.md): Air Command 582 · Monongahela, PA · Accident · 1 fatal · Limited investigation · Final report · Oct 1, 2014 · UNREG · Substantial damage
  > The amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.
- [NTSB ERA14FA455](https://openairdocs.org/ntsb/ERA14FA455.md): Piper J3C-65 · Fort Gaines, GA · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2014 · N95480 · Substantial damage
  > The pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.
- [NTSB CEN14WA502](https://openairdocs.org/ntsb/CEN14WA502.md): Diamond Aircraft Ind DA 40 · Kulusuk, Greenland · Accident · 1 fatal · Foreign investigation · Sep 11, 2014 · N39SE · Substantial damage
  > On September 11, 2014, about 1600 coordinated universal time, a Diamond Aircraft Industries Inc. DA 40 airplane, N39SE, owned and operated by Milou 1 LLC, was substantially damaged when it impacted terrain near Kulusuk, Greenland. Visual meteorological…
- [NTSB CEN14FA468](https://openairdocs.org/ntsb/CEN14FA468.md): Schafer Rick W Foxtrot 4 · Abilene, TX · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2014 · N729AR · Substantial damage
  > The pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…
- [NTSB CEN14WA452](https://openairdocs.org/ntsb/CEN14WA452.md): Nasdalla Vans RV-7 · Modrava, Czechia · Accident · 1 fatal · Foreign investigation · Aug 23, 2014 · LN-DSF · Substantial damage
  > On August 23, 2014, an experimental amateur-built Nasdalla model Vans RV-7 airplane, Norwegian registration LN-DSF, serial number 71683, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near Modrava, Czech…
- [NTSB CEN15WA115](https://openairdocs.org/ntsb/CEN15WA115.md): Rans S7 · Cambaie, Reunion Island, France · Accident · No injuries · Foreign investigation · Aug 12, 2014 · N974GL · Substantial damage
- [NTSB ERA14WA356](https://openairdocs.org/ntsb/ERA14WA356.md): Robinson R44 · Ivashka Township, Russia · Accident · 2 fatal · Foreign investigation · Jul 23, 2014 · RA-1975G · Substantial damage
  > On July 23, 2014, at 0809 Coordinated Universal Time (UTC), a Robinson R44, Russian registration RA-1975G, impacted the waters of the Ivashka River, under unknown circumstances, near Ivashka Township, Russia. The pilot and one passenger were fatally injured.…
- [NTSB CEN14LA336](https://openairdocs.org/ntsb/CEN14LA336.md): Northwing Design Apache Sport · Omro, WI · Accident · 1 fatal · Limited investigation · Final report · Jul 3, 2014 · N2725T · Substantial damage
  > The pilot’s failure to maintain adequate airspeed to compensate for a newly installed wing, which resulted in the aircraft stalling and the subsequent loss of control.
- [NTSB CEN14WA304](https://openairdocs.org/ntsb/CEN14WA304.md): Reims Cessna F150L · Nottingshire, United Kingdom · Accident · No injuries · Foreign investigation · Jun 14, 2014 · G-YIII · Substantial damage
  > This is preliminary information, subject to change, and may contain errors. On June 14, 2014, about 1240 UTC, a Cessna F150L airplane, G-YIII (s/n 0827) impacted terrain near Hucknall Airfield (EGNA), Nottinghamshire, United Kingdom. The airplane was…
- [NTSB CEN14WA315](https://openairdocs.org/ntsb/CEN14WA315.md): Beech 76 · Dublin, Ireland · Incident · No injuries · Foreign investigation · May 22, 2014 · EI-BUN · Minor damage
  > On May 22, 2014, at 1233 hours universal coordinated time, a Beech model 76 Duchess, Ireland registration EI-BUN, was involved in a runway excursion after landing at the Weston Airfield (EIWT), Dublin, Ireland. The flight instructor and pilot receiving…
- [NTSB ERA14WA224](https://openairdocs.org/ntsb/ERA14WA224.md): Robinson R44 II · Inta, Russia · Accident · 1 fatal · Foreign investigation · Apr 30, 2014 · RA-06712 · Substantial damage
  > On April 30, 2014, at 0318 Coordinated Universal Time (UTC), a Robinson R44 II, Russian registration RA-06217, impacted terrain, near Inta, Russia. The pilot was fatally injured. The investigation is under the jurisdiction of the Russian Federation Interstate…
- [NTSB WPR14WA191](https://openairdocs.org/ntsb/WPR14WA191.md): Maule M-5-235C · Lismore Aerodrome, Australia, Australia · Accident · 1 fatal · Foreign investigation · Apr 12, 2014 · VH-HOG · Substantial damage
  > On April 12, 2014, at 1230 universal coordinated time, a Maule M-5-235C, VH-HOG, struck a power line and subsequently impacted terrain near Lismore Aerodrome, Australia. The airplane was operated by the pilot under the pertinent civil regulation of the…

Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=16

## 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=15

---
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.