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

## Cases, newest first

- [NTSB ANC18FA071](https://openairdocs.org/ntsb/ANC18FA071.md): Piper PA-12-150 · Healy, AK · Accident · 2 fatal · Field investigation · Final report · Sep 23, 2018 · N7511H · Substantial damage
  > An impact with terrain for reasons that could not be determined based on the available information.
- [NTSB CEN18WA388](https://openairdocs.org/ntsb/CEN18WA388.md): Cessna 210 · Pico de Orizaba, Mexico · Accident · 3 fatal · Foreign investigation · Sep 21, 2018 · XB-NVG · Substantial damage
  > On September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…
- [NTSB WPR18WA258](https://openairdocs.org/ntsb/WPR18WA258.md): Yakovlev YAK-9UM · Victoria, Australia · Accident · 1 fatal · Foreign investigation · Sep 7, 2018 · VH-YIX · Substantial damage
  > On September 7, 2018, about 1933 coordinated universal time a Yakovlev Aircraft YAK-9UM airplane, VH-YIX, impacted terrain during a local flight that departed from the Latrobe Valley Airport, Victoria, Australia. The pilot in command was fatally injured, and…
- [NTSB CEN18WA367](https://openairdocs.org/ntsb/CEN18WA367.md): Cessna 310 · Villa Zaragoza, Mexico · Accident · 1 fatal · Foreign investigation · Aug 28, 2018 · XB-KQF · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a Cessna 310, XB-KQF that occurred on August 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB WPR18FA228](https://openairdocs.org/ntsb/WPR18FA228.md): Pietenpol Aircamper · Camp Verde, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Aug 18, 2018 · N88HK · Substantial damage
  > Loss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.
- [NTSB CEN18LA338](https://openairdocs.org/ntsb/CEN18LA338.md): Lazair II · Racine, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 2018 · UNREG · Destroyed
  > The impact with terrain for reasons that could not be determined based on the lack of evidence.
- [NTSB ANC18WA074](https://openairdocs.org/ntsb/ANC18WA074.md): Cessna 172 · Edson, Canada · Accident · 1 fatal · Foreign investigation · Aug 12, 2018 · C-FJCP · Substantial damage
  > On August 12, 2018, about 1645 Coordinated Universal Time, a Cessna 172 airplane, C-FJCP, impacted terrain near Edson, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries.The Transportation Safety Board (TSB) of Canada is…
- [NTSB CEN18WA325](https://openairdocs.org/ntsb/CEN18WA325.md): Beech 58 · Munster, Germany · Accident · 2 fatal · Foreign investigation · Aug 9, 2018 · PH-CJX · Substantial damage
  > On August 9, 2018, about 1000 UTC, a Beechcraft Baron 58 airplane, Hungarian registration PH-CJX, impacted terrain under unknown circumstances near Münster, Germany. The two occupants inside the airplane sustained fatal injuries. The airplane sustained…
- [NTSB CEN18WA375](https://openairdocs.org/ntsb/CEN18WA375.md): Cessna Cessna R182 · Les Rabassieres, France · Accident · No injuries · Foreign investigation · Jul 17, 2018 · G-BHYA · Destroyed
  > On July 17, 2018, at 1300 UTC, a Cessna 182, G-BHYA, S/N R182-00532, experienced an engine failure on a local flight from a private airfield in Les Rabassières, France. The pilot declared an emergency landing and the airplane experienced a runway excursion…
- [NTSB CEN18WA268](https://openairdocs.org/ntsb/CEN18WA268.md): Robinson R44 · Domecko, Poland · Accident · 2 fatal · Foreign investigation · Jul 11, 2018 · SP-MAP · Destroyed
  > On July 11, 2018, at 0736 coordinated universal time (UTC), a Robinson Helicopter R-44 II helicopter, SP-MAP, impacted terrain near Opole, Poland. 2 occupants were fatally injured, and 1 occupant was seriously injured.The investigation is under the…
- [NTSB WPR18WA169](https://openairdocs.org/ntsb/WPR18WA169.md): MD Helicopter 600 · Waiouru, New Zealand · Accident · Serious injuries · Foreign investigation · Jun 13, 2018 · ZK-ILD · Substantial damage
  > On June 13, 2018, at 2048 Universal Coordinated time, an MD 600N helicopter, ZK-ILD crashed in a remote area for unknown reasons near Waiouru, New Zealand. The pilot and four passengers were seriously injured. The helicopter was substantially damaged. The…
- [NTSB CEN18WA355](https://openairdocs.org/ntsb/CEN18WA355.md): Cessna R172 · Aude Fraisse-Cabardes, France · Accident · Minor injuries · Foreign investigation · Jun 10, 2018 · I-DROV · Substantial damage
  > The government of France has notified the NTSB of an accident involving a Cessna R172 airplane that occurred on June 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…
- [NTSB CEN18WA202](https://openairdocs.org/ntsb/CEN18WA202.md): Bell Helicopter Textron Bell 206B · North Aldborough, United Kingdom · Accident · 1 fatal · Foreign investigation · May 30, 2018 · G-OPEN · Destroyed
  > On May 30, 2018, about 1225 coordinated universal time (UTC), a Bell 206B helicopter, registration G-OPEN, s/n 4300, impacted terrain and was destroyed near North Aldborough, North Yorkshire in the United Kingdom. The pilot was the sole occupant and was…
- [NTSB CEN18WA190](https://openairdocs.org/ntsb/CEN18WA190.md): Reims F172N · Stolwijk, Netherlands · Accident · 2 fatal · Foreign investigation · May 22, 2018 · PH-SBM · Destroyed
  > On May 22, 2018, about 0930 UTC, a Reims Aviation, F172N airplane, PH-SBM, was destroyed when it impacted trees and terrain near Stolwijk, The Netherlands. The two pilots on board the airplane were fatally injured. The foreign, local personal flight departed…
- [NTSB WPR18FA143](https://openairdocs.org/ntsb/WPR18FA143.md): I.C.A.-Brasov IS 29D · Avenal, CA · Accident · 1 fatal · Field investigation · Final report · May 19, 2018 · N38ES · Destroyed
  > The pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.
- [NTSB ERA18WA147](https://openairdocs.org/ntsb/ERA18WA147.md): Maule M7 · Abayt, Saudi Arabia · Accident · 4 fatal · Foreign investigation · May 15, 2018 · HZ-NC7 · Destroyed
  > The government of Saudi Arabia has notified the NTSB of an accident involving a Maule, M-7-235C, airplane that occurred on May 15, 2018 near Abayt, Saudi Arabia. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi…
- [NTSB CEN18WA289](https://openairdocs.org/ntsb/CEN18WA289.md): Mooney M20K · Flix, Spain · Accident · 3 fatal · Foreign investigation · May 12, 2018 · D-ETFT · Destroyed
  > On May 12, 2018, at 1340 universal coordinated time, a Mooney M20K airplane, D-ETFT, impacted terrain near Flix, Tarragona, Spain. The pilot and 2 passengers were fatally injured and the airplane was destroyed.The accident investigation is under the…
- [NTSB CEN18WA166](https://openairdocs.org/ntsb/CEN18WA166.md): Ayres S2R · Morales, Guatemala · Accident · No injuries · Foreign investigation · May 9, 2018 · TG-FDM · Destroyed
  > On May 9, 2018, about 1415 coordinated universal time, an Ayres Thrush S2R-T34 airplane TG-FDM, was destroyed when it impacted terrain under unknown circumstances near the municipality of Morales in Izabal Department of Guatemala. The pilot was fatally…
- [NTSB ERA18WA143](https://openairdocs.org/ntsb/ERA18WA143.md): Cessna U206F · Trelawny, Jamaica · Accident · 3 fatal · Foreign investigation · May 4, 2018 · N8281Q · Substantial damage
  > The government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…
- [NTSB WPR18WA160](https://openairdocs.org/ntsb/WPR18WA160.md): Robinson Helicopter R44 II · Mabula, South Africa · Accident · 2 fatal · Foreign investigation · May 1, 2018 · ZS-MZS · Destroyed
  > On May 1, 2018, at 0940 Universal Coordinated Time, a Robinson R44 Raven II helicopter, ZS-MZS, impacted an open field for unknown reasons near Mabula, South Africa. The pilot and one passenger were fatally injured. The helicopter was destroyed. The…
- [NTSB ENG18WA041](https://openairdocs.org/ntsb/ENG18WA041.md): Boeing 777 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Apr 30, 2018 · HS-XBD
  > The Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-212 airplane on April 30, 2018. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO Annex 13 as the…
- [NTSB WPR18WA138](https://openairdocs.org/ntsb/WPR18WA138.md): Taylorcraft BC12 · Vryheid, South Africa · Accident · 2 fatal · Foreign investigation · Apr 29, 2018 · ZS-BLD · Substantial damage
  > On April 29, 2018, at 1110 coordinated universal time, a Taylorcraft BC 12-D airplane, registration ZS-BLD, sustained substantial damage under unknown circumstances following a departure from Vryheid Aerodrome (FAVY), Kwa-Zulu Natal, South Africa. Both…
- [NTSB CEN18WA153](https://openairdocs.org/ntsb/CEN18WA153.md): Cessna 172 · Corozalito, Nandayure, Costa Rica · Accident · 2 fatal · Foreign investigation · Apr 28, 2018 · TI-BIL
  > On April 28, 2018, about 1800 UTC, a Cessna 172S airplane, TI-BIL, impacted terrain during an instructional flight near Corozalito, Nandayure. Both crewmembers on board were fatally injured.This investigation is under the jurisdiction and control of the Costa…
- [NTSB CEN18WA145](https://openairdocs.org/ntsb/CEN18WA145.md): Cessna Cessna 152 · Crumlin, Ireland · Accident · 2 fatal · Foreign investigation · Apr 19, 2018 · G-UFCO · Substantial damage
  > On April 19, 2018, at 1230 UTC, a Cessna 152 airplane, G-UFCO, collided with the terrain in Crumlin, Northern Ireland. The pilot and passenger were fatally injured, and the airplane was substantially damage by impact and postimpact fire. The wreckage was…
- [NTSB WPR18WA134](https://openairdocs.org/ntsb/WPR18WA134.md): Garlick UH1H · Talbingo NSW, Australia · Accident · Serious injuries · Foreign investigation · Apr 17, 2018 · VH-HUE · Destroyed
  > On April 17, 2018, about 1510 local time, a Garlick, Australian registration VH-HUE, operated as a freight charter and equipped with a Textron Lycoming T-53 engine, impacted terrain near Talbingo, Australia. The pilot, sole occupant onboard, was seriously…
- [NTSB CEN18WA136](https://openairdocs.org/ntsb/CEN18WA136.md): Bell 47G · Libourne, France · Accident · 2 fatal · Foreign investigation · Apr 5, 2018 · FGGLB · Destroyed
  > The government of France has notified the NTSB of an accident involving a BELL 47G helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…
- [NTSB CEN18WA135](https://openairdocs.org/ntsb/CEN18WA135.md): Rotorway Exec · Koblenz-Winningen, Germany · Accident · No injuries · Foreign investigation · Mar 25, 2018 · D-HEDM · Substantial damage
  > The government of Germany has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on March 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation…
- [NTSB CEN18WA103](https://openairdocs.org/ntsb/CEN18WA103.md): Beech 95B55 · Saint Laurent La Roche, France · Accident · 3 fatal · Foreign investigation · Feb 17, 2018 · N155PR · Destroyed
- [NTSB CEN18WA110](https://openairdocs.org/ntsb/CEN18WA110.md): Cessna 182 · El Pozo, Mexico · Accident · 2 fatal · Foreign investigation · Feb 12, 2018 · XB-HRG · Substantial damage
  > On February 12, 2018, about 1815 coordinated universal time, a Cessna 182B airplane, Mexican registration XB-HRG, crashed in a field under unknown circumstances near El Pozo, Mexico. The pilot and passenger were fatally injured. The local flight originated…
- [NTSB ERA18WA085](https://openairdocs.org/ntsb/ERA18WA085.md): Beech F35 · Itaituba, Brazil · Accident · 3 fatal · Foreign investigation · Feb 7, 2018 · PT-AVO · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a BEECH F35 airplane that occurred on February 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB ANC18WA023](https://openairdocs.org/ntsb/ANC18WA023.md): Sikorsky UH-60M (S-70) · Lanyu, Taiwan · Accident · 6 fatal · Foreign investigation · Feb 5, 2018 · NA706 · Destroyed
  > The foreign authority was the source of this information. On February 05, 2018, about 2352 local time, a Sikorsky UH-60M helicopter, NA-706, operated by National Airborne Service Corps. of the Ministry of Interior, Taiwan R.O.C., went missing and is presumed…
- [NTSB CEN18WA091](https://openairdocs.org/ntsb/CEN18WA091.md): Piper PA25 · Mocorito, Mexico · Accident · 1 fatal · Foreign investigation · Jan 26, 2018 · XB-FBN · Substantial damage
  > On January 26, 2018, at 1930 UTC, a Piper PA25-150, XB-FBN, impacted terrain under unknown circumstances in the Community el Recoveco in Mocorito, Mexico. The aircraft was destroyed, and the pilot was fatally injured. The flight had departed airdrome "El…
- [NTSB CEN18WA120](https://openairdocs.org/ntsb/CEN18WA120.md): Piper PA-28RT-201T · Oberhausen-Rheinhausen, Germany · Accident · 4 fatal · Foreign investigation · Jan 23, 2018 · HB-PGF · 2 aircraft · Destroyed
  > On January 23, 2018, about 1207 coordinated universal time, a Piper PA-28 airplane, Swiss registration HB-PGF, collided with an Airbus-Helicopter EC135P2, German registration D-HDRV near Oberhausen-Rheinhausen, Germany. The pilots and passengers were all…
- [NTSB CEN18FA083](https://openairdocs.org/ntsb/CEN18FA083.md): Skwira Matthew J W-10 Tailwind · Sauk Centre, MN · Accident · 1 fatal · Field investigation · Final report · Jan 23, 2018 · N251WT · Substantial damage
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB WPR18WA067](https://openairdocs.org/ntsb/WPR18WA067.md): Cessna 182 · Bridport, Australia · Accident · 1 fatal · Foreign investigation · Jan 20, 2018 · VH-TSA · Substantial damage
  > On January 20, 2018, at 1800 local time, a Cessna 182P, VH-TSA, collided with terrain near Bridport, Australia. The airplane sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight was operated…
- [NTSB ERA18WA093](https://openairdocs.org/ntsb/ERA18WA093.md): Ayres S2R · Jaramillo, Ecuador · Accident · 1 fatal · Foreign investigation · Jan 9, 2018 · HC CKS · Substantial damage
  > The government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on January 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…
- [NTSB ERA18WA051](https://openairdocs.org/ntsb/ERA18WA051.md): Beech A36 · Itapua, Paraguay · Accident · 1 fatal · Foreign investigation · Dec 17, 2017 · ZP-BHU · Destroyed
- [NTSB WPR18WA078](https://openairdocs.org/ntsb/WPR18WA078.md): Beech 58 · Qaroun Lake, Egypt · Accident · 3 fatal · Foreign investigation · Dec 15, 2017 · SU-BLD · Substantial damage
  > On December 15, 2017, about 0930 Coordinated Universal time, a Textron/Beech Model 58 Baron twin engine airplane, SU-BLD, was substantially damaged when it impacted desert terrain about 18 kilometers north of Qaroun Lake, Egypt. The training pilot and the two…
- [NTSB ERA18WA042](https://openairdocs.org/ntsb/ERA18WA042.md): Robinson R44 · Dubovaya Balka, Russia · Accident · 2 fatal · Foreign investigation · Dec 5, 2017 · RA-04308 · Substantial damage
  > The government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…
- [NTSB ERA18LA039](https://openairdocs.org/ntsb/ERA18LA039.md): Kevin Leue Sparrow Hawk · Hernando, MS · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2017 · N481ZK · Destroyed
  > Impact with trees and terrain for reasons that could not be determined based on available evidence.
- [NTSB ERA18RA045](https://openairdocs.org/ntsb/ERA18RA045.md): Piper PA28 · Vereda El Mortillo, Colombia · Accident · 2 fatal · Foreign investigation · Nov 30, 2017 · HK1573G · Destroyed
  > import
- [NTSB WPR18WA019](https://openairdocs.org/ntsb/WPR18WA019.md): Cessna T310 · Kew, New South Wales, Australia · Accident · 2 fatal · Foreign investigation · Oct 28, 2017 · VH-JMW · Destroyed
  > On October 28, 2017, at 1600 local time, a Cessna T310R, VH-JMW, was destroyed when it collided with terrain near Kew, New South Wales, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The pilot and…
- [NTSB WPR18WA024](https://openairdocs.org/ntsb/WPR18WA024.md): Cessna 210L · Darwin Aerodrome, Australia · Accident · 2 fatal · Foreign investigation · Oct 23, 2017 · VH-HWY · Destroyed
  > On October 23, 2017, at 1332 local time, a Cessna 210L, VH-HWY, collided with terrain near Darwin Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The two occupants were fatally injured. The…
- [NTSB GAA18CA020](https://openairdocs.org/ntsb/GAA18CA020.md): Cessna 150 · Pottsville, PA · Accident · No injuries · Data collection · Final report · Oct 22, 2017 · N22092 · Substantial damage
  > The failure of the right rudder cable and subsequent loss of directional control during landing.
- [NTSB CEN18WA016](https://openairdocs.org/ntsb/CEN18WA016.md): Avid Mark IV · Jüterborg, Germany · Accident · 1 fatal · Foreign investigation · Oct 16, 2017 · F-JAGB
  > On October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…
- [NTSB DCA17WA196](https://openairdocs.org/ntsb/DCA17WA196.md): Boeing 737 · Leon, Mexico · Incident · No injuries · Foreign investigation · Sep 3, 2017 · XA-MAI
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ERA17WA343](https://openairdocs.org/ntsb/ERA17WA343.md): Cessna 182 · Ivano-Frankivsk, Ukraine · Accident · Serious injuries · Foreign investigation · Jul 22, 2017 · UR-ORV · Substantial damage
  > On July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…
- [NTSB CEN17WA296](https://openairdocs.org/ntsb/CEN17WA296.md): Cessna 182 · Aeródromo de la Isla de Utila, Honduras · Accident · No injuries · Foreign investigation · Jul 1, 2017 · HR-AXI · Substantial damage
- [NTSB CEN17WA269](https://openairdocs.org/ntsb/CEN17WA269.md): Cessna TU206 · Surutato, Mexico · Accident · 1 fatal · Foreign investigation · Jun 30, 2017 · XB-NWL · Substantial damage
  > On June 30, 2017, about 1907 hours universal coordinated time, a Cessna TU206G single-engine airplane, serial number U20606684, Mexican registration XB-NWL, collided with terrain near Surutato, Mexico. The pilot was fatally injured. The flight's origin and…
- [NTSB WPR17WA129](https://openairdocs.org/ntsb/WPR17WA129.md): Airparts NZ FU 24 Stallion · Bathurst, Australia · Accident · 1 fatal · Foreign investigation · Jun 16, 2017 · VH-EUO · Substantial damage

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

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

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