# 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 12 of 40 · 1,981 cases ## Cases, newest first - [NTSB CEN20WA171](https://openairdocs.org/ntsb/CEN20WA171.md): Cessna 182 · Area Municipio De Joyabaj, Guatemala · Accident · 3 fatal · Foreign investigation · May 6, 2020 · TG-MOL · Destroyed - [NTSB ANC20WA072](https://openairdocs.org/ntsb/ANC20WA072.md): Sikorsky S76 · Cheonwangbong, South Korea · Accident · 2 fatal · Foreign investigation · May 1, 2020 · HL9646 · Substantial damage > The government of Korea, Republic Of has notified the NTSB of an accident involving a SIKORSKY S76 helicopter that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea, Republic Of's investigation… - [NTSB CEN20WA200](https://openairdocs.org/ntsb/CEN20WA200.md): Piper PA 25-235 · Angostura, Mexico · Accident · 1 fatal · Foreign investigation · Apr 28, 2020 · XB-ZOZ - [NTSB CEN20WA157](https://openairdocs.org/ntsb/CEN20WA157.md): Cessna 650 · Ciudad Juarez, Mexico · Incident · No injuries · Foreign investigation · Apr 7, 2020 · XA-SDU · Minor damage > On April 7, 2020, about 1640 hours universal coordinated time, a Cessna 650 airplane, Mexican registration XA-SDU, was involved in an incident at the Abraham González International Airport (MMCS), located in Ciudad Juárez, Chihuahua, Mexico, The NTSB has… - [NTSB CEN20WA142](https://openairdocs.org/ntsb/CEN20WA142.md): Lancair LC41 · Gotha, Germany · Accident · Serious injuries · Foreign investigation · Mar 30, 2020 · N6504H · Substantial damage - [NTSB ERA20WA137](https://openairdocs.org/ntsb/ERA20WA137.md): Bell 206 · Chicureo, Chile · Accident · 1 fatal · Foreign investigation · Mar 24, 2020 · CC-ARR · Destroyed - [NTSB ERA20WA136](https://openairdocs.org/ntsb/ERA20WA136.md): Cessna 310 · Tefe, Brazil · Accident · 2 fatal · Foreign investigation · Mar 13, 2020 · PR-GSG · Substantial damage > The government of Brazil has notified the NTSB of an accident involving a Cessna 310 airplane that occurred on March 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of… - [NTSB ANC20WA031](https://openairdocs.org/ntsb/ANC20WA031.md): Robinson R44 · Astrakhan, Russia · Accident · 1 fatal · Foreign investigation · Feb 28, 2020 · RA-04246 · Substantial damage > The government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the… - [NTSB CEN20FA098](https://openairdocs.org/ntsb/CEN20FA098.md): Innovator Mosquitto · North Manchester, IN · Accident · 1 fatal · Class 3 · Field · Final report · Feb 23, 2020 · N840GS · Substantial damage > The pilot’s loss of control for reasons that could not be determined based on the available information. - [NTSB CEN20WA121](https://openairdocs.org/ntsb/CEN20WA121.md): Lavia Argentina PA-25-235 · Etchoja, Mexico · Accident · 1 fatal · Foreign investigation · Feb 18, 2020 · XB-EMO · Destroyed > The government of Mexico has notified the NTSB of an accident involving a LAVIA ARGENTINA PA-25-235 airplane that occurred on February 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under… - [NTSB WPR20FAMS2](https://openairdocs.org/ntsb/WPR20FAMS2.md): Luscombe 8 · Pacific Ocean, OR · Accident · 1 fatal · Class 3 · Missing aircraft · Final report · Feb 12, 2020 · N77875 · Destroyed > Undetermined because the airplane and pilot were not located. - [NTSB ANC20WA019](https://openairdocs.org/ntsb/ANC20WA019.md): Bell 407 · Laishevo, Russia · Accident · 1 fatal · Foreign investigation · Feb 7, 2020 · RA-01893 · Substantial damage > The government of Russia has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on February 07, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions… - [NTSB WPR20WA106](https://openairdocs.org/ntsb/WPR20WA106.md): Aerospatiale AS350 · Bankstown Aerodrome, Australia · Incident · No injuries · Foreign investigation · Feb 5, 2020 · VH-UAH · No damage > The government of Australia has notified the NTSB of an accident involving a Aerospatiale AS350 helicopter that occurred on February 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under… - [NTSB WPR20WA083](https://openairdocs.org/ntsb/WPR20WA083.md): Cessna 182 · Tangalooma, Australia · Accident · 2 fatal · Foreign investigation · Jan 22, 2020 · VH-WNR · Substantial damage > The government of Australia has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the… - [NTSB CEN20WA054](https://openairdocs.org/ntsb/CEN20WA054.md): Mooney M20 · Lifou Wanaham, New Caledonia · Accident · 4 fatal · Foreign investigation · Jan 3, 2020 · F-OIAT · Destroyed > On January 3, 2020, about 1430 universal coordinated time, a Mooney M20J, French registration F-OIAT, impacted terrain shortly after departing the Lifou Wanaham Airport (New Caledonia). The aircraft was destroyed, and the pilot and three passengers were… - [NTSB DCA20WA016](https://openairdocs.org/ntsb/DCA20WA016.md): Boeing 747 · Leipzig, Germany · Incident · No injuries · Foreign investigation · Nov 14, 2019 · G-CLAE · Minor damage > The government of Germany has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions… - [NTSB WPR20FAMS1](https://openairdocs.org/ntsb/WPR20FAMS1.md): Piper PA28R · Shelter Cove, CA · Accident · 2 fatal · Class 3 · Missing aircraft · Final report · Oct 25, 2019 · N4958J · Destroyed > Undetermined due to lack of available evidence. - [NTSB WPR20LA014](https://openairdocs.org/ntsb/WPR20LA014.md): Vans RV 6 · Spanaway, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 23, 2019 · N615RJ · Substantial damage > A total loss of engine power during the initial climb for reasons that could not be determined. - [NTSB CEN20LA021](https://openairdocs.org/ntsb/CEN20LA021.md): Piper PA23 · (Gulf of Mexico) · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 17, 2019 · N778PA · Destroyed > The airplane’s descent into the ocean for reasons that could not be determined. - [NTSB WPR20WA006](https://openairdocs.org/ntsb/WPR20WA006.md): Piper PA-28-140 · Huhudi, South Africa · Accident · 1 fatal · Foreign investigation · Oct 6, 2019 · ZS-EEZ > On October 6, 2019, about 1547 coordinated universal time, a Piper PA28-140, ZS-EEZ, crashed near, Vryburg Airport, Huhudi, South Africa. The pilot was fatally injured, and the passenger sustained serious injuries. The extent of the airplane's damage is… - [NTSB CEN19WA296](https://openairdocs.org/ntsb/CEN19WA296.md): Robinson R44 · Veracruz, Mexico · Accident · Serious injuries · Foreign investigation · Aug 26, 2019 · XB-GIL > On August 26, 2019, about 1700 hours universal coordinated time, a Robinson R-44 II helicopter, Mexican registration XB-GIL, was substantially damaged during an emergency landing in a field near Veracruz, Mexico. Two occupants were seriously injured; one… - [NTSB CEN19WA283](https://openairdocs.org/ntsb/CEN19WA283.md): Bell 206 · Inca, Mallorca, Spain · Accident · 7 fatal · Foreign investigation · Aug 25, 2019 · D-HOTT · 2 aircraft · Destroyed > On June 25, 2019, about 1335 local time, a Bell 206L-3 helicopter, D-HOTT, and an Aeroprakt A22L airplane collided in mid-air, near Inca, Mallorca, Spain. The pilot and four passengers aboard the helicopter and the two people on the airplane, received fatal… - [NTSB CEN19WA286](https://openairdocs.org/ntsb/CEN19WA286.md): Pitts S2 · Stonor Oxforshire, United Kingdom · Accident · 2 fatal · Foreign investigation · Aug 24, 2019 · G-ODDS · Substantial damage > The government of United Kingdom has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on August 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the… - [NTSB CEN19WA289](https://openairdocs.org/ntsb/CEN19WA289.md): Capella XS · San Juan del Puerto, Spain · Accident · 1 fatal · Foreign investigation · Aug 23, 2019 · EC-YTA · Substantial damage > On August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the… - [NTSB CEN19WA284](https://openairdocs.org/ntsb/CEN19WA284.md): Reims F172 · Schneizlreuth, Germany · Accident · 1 fatal · Foreign investigation · Aug 22, 2019 · D-ECSC · Destroyed > The government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions… - [NTSB CEN19WA282](https://openairdocs.org/ntsb/CEN19WA282.md): Cessna 150 · Diepholz, Germany · Accident · 1 fatal · Foreign investigation · Aug 22, 2019 · D-EHLG · Destroyed > On August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on… - [NTSB WPR19WA274](https://openairdocs.org/ntsb/WPR19WA274.md): Cessna 172 · Pretoria, South Africa · Accident · 2 fatal · Foreign investigation · Aug 16, 2019 · ZS-LMI · Substantial damage > On August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the… - [NTSB CEN19FA248](https://openairdocs.org/ntsb/CEN19FA248.md): Cessna 310 · De Queen, AR · Accident · 1 fatal · Class 3 · Field · Final report · Aug 4, 2019 · N310QA · Substantial damage > A loss of control for reasons that could not be determined based on the available information. - [NTSB CEN19WA301](https://openairdocs.org/ntsb/CEN19WA301.md): Cessna TU206 · Guachochi, Mexico · Accident · 2 fatal · Foreign investigation · Aug 2, 2019 · XB-FZN · Substantial damage > On August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the… - [NTSB WPR19WA199](https://openairdocs.org/ntsb/WPR19WA199.md): Cessna 172 · Cangkring, Indonesia · Accident · 1 fatal · Foreign investigation · Jul 22, 2019 · PK-WUG · Substantial damage > On July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was… - [NTSB ERA19WA236](https://openairdocs.org/ntsb/ERA19WA236.md): Robinson R66 · Gorgona Island, Italy · Accident · 2 fatal · Foreign investigation · Jul 22, 2019 · RA07370 · Destroyed > The government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of… - [NTSB WPR19WA211](https://openairdocs.org/ntsb/WPR19WA211.md): Cessna 172 · Anji, China · Accident · 1 fatal · Foreign investigation · Jul 10, 2019 · B-10NH > On July 10, 2019, at an unknown time, a Cessna 172S, B-10NH, was substantially damaged when it collided with the ground near Anji, Zhejiang, China. One person on board was fatally injured, one sustained serious injury, and one is being assessed. The airplane… - [NTSB CEN19WA208](https://openairdocs.org/ntsb/CEN19WA208.md): Piper PA-24-250 · Quetzaltenango, Guatemala · Accident · 1 fatal · Foreign investigation · Jul 5, 2019 · TG-DAN · Destroyed > The government of Guatemala has notified the NTSB of an accident involving a PIPER PA-24-250 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guatemala's investigation under the… - [NTSB CEN19WA200](https://openairdocs.org/ntsb/CEN19WA200.md): Piper PA28 · Mandal, Norway · Accident · 1 fatal · Foreign investigation · Jun 22, 2019 · LN-MTJ · Substantial damage > On June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident… - [NTSB GAA21WA067](https://openairdocs.org/ntsb/GAA21WA067.md): Cessna 172 · Keti Bandar, Pakistan · Accident · Class 5 · Foreign · May 31, 2019 · AP-BAJ · Substantial damage - [NTSB ERA19WA176](https://openairdocs.org/ntsb/ERA19WA176.md): Bell 206 · La Vega, Dominican Republic · Accident · 2 fatal · Foreign investigation · May 21, 2019 · N9956K · Substantial damage - [NTSB WPR19WA151](https://openairdocs.org/ntsb/WPR19WA151.md): Robinson R44 II · Tai Po, China · Accident · 1 fatal · Class 5 · Foreign · May 19, 2019 · B-KTK · Destroyed - [NTSB GAA19CA282](https://openairdocs.org/ntsb/GAA19CA282.md): Cessna 172 · Edwards Air Force Base, CA · Accident · No injuries · Data collection · Final report · Apr 28, 2019 · N106ED · Substantial damage > An undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence. - [NTSB WPR19LA120](https://openairdocs.org/ntsb/WPR19LA120.md): Piper PA 18 225 DD · McCall, ID · Accident · No injuries · Class 3 · Limited · Final report · Apr 23, 2019 · N727WW · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB ERA19WA108](https://openairdocs.org/ntsb/ERA19WA108.md): Cessna U206 · Eteringbang, Guyana · Accident · 1 fatal · Foreign investigation · Feb 21, 2019 · 8R-GHB · Substantial damage > The government of Guyana has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on February 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions… - [NTSB WPR19WA271](https://openairdocs.org/ntsb/WPR19WA271.md): Cessna U206G · Londiani, Kenya · Accident · 5 fatal · Foreign investigation · Feb 13, 2019 · 5Y-BSE · Substantial damage > On February 13, 2019, at 0729 universal coordinated time a Cessna U206G, 5Y-BSE, crashed into terrain, following a distress signal from the airplane near Londiani, Kericho County, Kenya. The pilot and four passengers were fatally injured. The airplane was… - [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… Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=13 ## 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=12 --- 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.