# NTSB investigations, 2018: 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.

## Latest cases

- [NTSB ANC19WA013](https://openairdocs.org/ntsb/ANC19WA013.md): Agusta A119 · Ulan-Ude, Russia · Accident · 4 fatal · Foreign investigation · Dec 30, 2018 · RA-01908 · Destroyed
  > On December 30, 2018, about 0230 universal time, an Agusta A119 helicopter, RA-01908, impacted terrain under unknown circumstances about 12 miles from Ulan-Ude, Buryatia, Russia. The pilot and three passenger sustained fatal injuries. The Interstate Aviation…
- [NTSB WPR19LA039](https://openairdocs.org/ntsb/WPR19LA039.md): Beech 36 · Los Banos, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 6, 2018 · N361TC · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA19WA089](https://openairdocs.org/ntsb/ERA19WA089.md): Embraer EMB720 · Almeirim, Brazil · Accident · No injuries · Foreign investigation · Dec 2, 2018 · PT-RDZ
  > The government of Brazil has notified the NTSB of an accident involving a Embraer EMB720 airplane that occurred on December 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB ERA19WA087](https://openairdocs.org/ntsb/ERA19WA087.md): Cessna 210 · São Paulo, Brazil · Accident · 2 fatal · Foreign investigation · Nov 30, 2018 · PR-JEE · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on November 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN19FA032](https://openairdocs.org/ntsb/CEN19FA032.md): Mooney M20C · Santa Fe, NM · Accident · 1 fatal · Field investigation · Final report · Nov 27, 2018 · N113TA · Destroyed
  > Collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.
- [NTSB WPR19WA032](https://openairdocs.org/ntsb/WPR19WA032.md): Robinson R22 · Alice Springs, Australia · Accident · 1 fatal · Foreign investigation · Nov 24, 2018 · VH-KZV · Substantial damage
  > On November 24, 2018, at 1200 local time, a Robinson R22 BETA, VH-KZV, collided with terrain near Alice Springs, NT, Australia. The helicopter sustained substantial damage. The pilot sustained serious injuries and the passenger was fatally injured. The flight…
- [NTSB CEN19WA027](https://openairdocs.org/ntsb/CEN19WA027.md): Vans (EX) RV-6 · Meraaker, Norway · Accident · 2 fatal · Foreign investigation · Nov 7, 2018 · LN-AAL · Substantial damage
  > On November 7, 2018, about 1410 hours central European standard time, a Vans RV-6 airplane, Norwegian registration LN-AAL, impacted terrain under unknown circumstances near Meråker, Norway. The pilot and passenger were fatally injured. The flight departed…
- [NTSB CEN19WA011](https://openairdocs.org/ntsb/CEN19WA011.md): Cessna F172 · East Yorkshire, United Kingdom · Accident · 2 fatal · Foreign investigation · Oct 11, 2018 · G-BGSV · Destroyed
  > On November 10, 2018, about 1930 hours universal coordinated time, a Reims Cessna F172N, United Kingdom registration G-BGSV, impacted a field near East Yorkshire, United Kingdom. The two occupants on-board were fatally injured. The flight origin and…
- [NTSB ANC19WA001](https://openairdocs.org/ntsb/ANC19WA001.md): Robinson R44 · Bodaybo, Russia · Accident · 2 fatal · Foreign investigation · Oct 1, 2018 · RA-05758 · Substantial damage
  > On October 1, 2018, at an undetermined time, a Robinson R-44-II helicopter, RA-05758, impacted water and sank prior to colliding with a power transmission line near Bodaybo, Russia. The pilot and passenger sustained fatal injuries. The Interstate Aviation…
- [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…

## 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 year(c."eventDate") = 2018
  AND 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?year=2018

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