# NTSB investigations: Approach 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 30 of 420 · 20,992 cases ## Cases, newest first - [NTSB CEN18WA169](https://openairdocs.org/ntsb/CEN18WA169.md): Cessna 208B · Clonbullogue, Ireland · Accident · 2 fatal · Foreign investigation · May 13, 2018 · G-KNYS · Destroyed - [NTSB WPR18WA281](https://openairdocs.org/ntsb/WPR18WA281.md): Zenith CH610 HD · Germiston, South Africa · Accident · No injuries · Foreign investigation · May 12, 2018 · ZU-FFA · Substantial damage > On May 12, 2018, about 0730 Universal Coordinated time, a Zenith Zodiac CH 610 HD airplane, ZU-FFA, touched down and overturned about 100 meters short of runway 11 at Rand Airport, Germiston, South Africa, following a loss of engine power. The pilot sustained… - [NTSB CEN18LA165](https://openairdocs.org/ntsb/CEN18LA165.md): Piper PA 34-200 · Valparaiso, IN · Accident · Serious injuries · Limited investigation · Final report · May 8, 2018 · N99GN · Substantial damage > The pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control. - [NTSB ERA18LA145](https://openairdocs.org/ntsb/ERA18LA145.md): Piper PA28 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · May 7, 2018 · N80813 · Substantial damage > Water contamination of the fuel supply, which resulted in a total loss of engine power. - [NTSB GAA18CA263](https://openairdocs.org/ntsb/GAA18CA263.md): Schweizer SGS 1 26 · Springfield, VT · Accident · Minor injuries · Data collection · Final report · May 5, 2018 · N17909 · Substantial damage > The pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees. - [NTSB DCA18WA173](https://openairdocs.org/ntsb/DCA18WA173.md): Boeing 767 323 · Guayaquil, Ecuador · Incident · No injuries · Foreign investigation · May 3, 2018 · N396AN · No damage > The government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions… - [NTSB GAA18CA243](https://openairdocs.org/ntsb/GAA18CA243.md): Cessna 310 · Gainesville, FL · Accident · No injuries · Data collection · Final report · Apr 30, 2018 · N2212A · Substantial damage > The pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike. - [NTSB CEN18WA399](https://openairdocs.org/ntsb/CEN18WA399.md): Cessna 172 · Hamilton, Bermuda · Accident · Minor injuries · Foreign investigation · Apr 30, 2018 · N9085H · Substantial damage > On April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident… - [NTSB GAA18CA244](https://openairdocs.org/ntsb/GAA18CA244.md): Luscombe 8 · Eunice, LA · Accident · No injuries · Data collection · Final report · Apr 28, 2018 · N71261 · Substantial damage > The pilot’s failure to maintain clearance from a tree while on approach to land. - [NTSB GAA18CA234](https://openairdocs.org/ntsb/GAA18CA234.md): Piper PA28 · Wickenburg, AZ · Accident · No injuries · Data collection · Final report · Apr 25, 2018 · N922PA · Substantial damage > The student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land. - [NTSB GAA18CA220](https://openairdocs.org/ntsb/GAA18CA220.md): Piper PA 22 · Shelby, MT · Accident · No injuries · Data collection · Final report · Apr 19, 2018 · N1283C · Substantial damage > The pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing. - [NTSB CEN18FA144](https://openairdocs.org/ntsb/CEN18FA144.md): Cirrus Design SR22 · Williamsburg, PA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2018 · N451TD · Destroyed > The pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after… - [NTSB WPR18LA121](https://openairdocs.org/ntsb/WPR18LA121.md): Airborne Windsports PTY XT-912-L · Peoria, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 15, 2018 · N107PW · Substantial damage > An inflight loss of control due to failure of the weight-shift-control aircraft's wing assembly. - [NTSB CEN18WA141](https://openairdocs.org/ntsb/CEN18WA141.md): Cirrus SR20 · Adolf Wurth Airport, Germany · Accident · 2 fatal · Foreign investigation · Apr 15, 2018 · D-EWTG · 2 aircraft · Destroyed > On April 15, 2018, at 1300 UTC, a Cirrus SR-20, D-EWTG, and a Dallach D4b Fascination, D-MJEK, encountered a midair collision under unknown circumstances near Adolf Würth Airport (EDTY), Schwäbisch Hall, Germany. Both aircraft were destroyed; and the pilots,… - [NTSB GAA18CA215](https://openairdocs.org/ntsb/GAA18CA215.md): Page Russell L Long EZ · Wakefield, VA · Accident · No injuries · Data collection · Final report · Apr 13, 2018 · N27RP · Substantial damage > The pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist… - [NTSB CEN18LA138](https://openairdocs.org/ntsb/CEN18LA138.md): Piper PA 24 · New Braunfels, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2018 · N7386P · Substantial damage > A partial loss of engine power for reasons that could not be determined based on the available information. - [NTSB GAA18CA214](https://openairdocs.org/ntsb/GAA18CA214.md): Cessna 170 · Big Lake, AK · Accident · No injuries · Data collection · Final report · Apr 9, 2018 · N4133V · Destroyed > The pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. - [NTSB DCA18WA123](https://openairdocs.org/ntsb/DCA18WA123.md): Boeing 737 · Osaka, Japan · Accident · No injuries · Foreign investigation · Apr 9, 2018 · HL7725 · Substantial damage > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the… - [NTSB GAA18CA193](https://openairdocs.org/ntsb/GAA18CA193.md): Piper PA28 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Apr 1, 2018 · N297PA · Substantial damage > The student pilot’s improper selection of the flap setting during a go-around, and the flight instructor’s delayed remedial action, which resulted in an aerodynamic stall. - [NTSB WPR18FA116](https://openairdocs.org/ntsb/WPR18FA116.md): Ragle RV6A · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Mar 31, 2018 · N820TL · Destroyed > The pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and subsequent spin. - [NTSB ENG18WA021](https://openairdocs.org/ntsb/ENG18WA021.md): Boeing 747 · Chek Lap Kok, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Mar 29, 2018 · JA18KZ · No damage > The Hong Kong Civil Aviation Department (HKCAD) has notified the NTSB of an incident involving a Boeing 747-8F airplane which occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the HKCAD investigation under the… - [NTSB CEN18LA123](https://openairdocs.org/ntsb/CEN18LA123.md): Mills Michael S1L · Dewitt, MI · Accident · 1 fatal · Limited investigation · Final report · Mar 22, 2018 · N197X · Substantial damage > The pilot's failure to see and avoid power lines due to sun glare. - [NTSB WPR18WA110](https://openairdocs.org/ntsb/WPR18WA110.md): Eurocopter EC120 · Hardy Reef, Queensland, Australia · Accident · 2 fatal · Foreign investigation · Mar 21, 2018 · VH-WII · Substantial damage > On March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef… - [NTSB CEN18FA126](https://openairdocs.org/ntsb/CEN18FA126.md): Rans S-16 Shekari · Pierce, NE · Accident · 1 fatal · Field investigation · Final report · Mar 21, 2018 · N741WT · Substantial damage > The pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain. - [NTSB ERA18LA097](https://openairdocs.org/ntsb/ERA18LA097.md): Reilly Charles W Escapade · Palatka, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 2018 · N45DC · Substantial damage > The interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall. - [NTSB ERA18LA096](https://openairdocs.org/ntsb/ERA18LA096.md): Piper PA 28 · Edgewater, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 2018 · N6764W · Substantial damage > The flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach. - [NTSB ERA18LA095](https://openairdocs.org/ntsb/ERA18LA095.md): Robert Snyder Autogyro Calidus · Beaufort, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 5, 2018 · N221YT · Substantial damage > The gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver. - [NTSB CEN18LA115](https://openairdocs.org/ntsb/CEN18LA115.md): Messerschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Mar 5, 2018 · N1174U · Substantial damage > The restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal… - [NTSB ENG18RA018](https://openairdocs.org/ntsb/ENG18RA018.md): Cessna 441 · Broome, Australia, Australia · Incident · No injuries · Foreign investigation · Mar 2, 2018 · VH-LBY · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO… - [NTSB CEN18LA112](https://openairdocs.org/ntsb/CEN18LA112.md): Piper PA 28 · Mackinac Island, MI · Accident · No injuries · Limited investigation · Final report · Feb 26, 2018 · N1722J · Substantial damage > The improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing. - [NTSB ERA18LA089](https://openairdocs.org/ntsb/ERA18LA089.md): Airborne Windsports PTY Edge XT 912 L · Eustis, FL · Accident · 1 fatal · Class 2 · Limited · Final report · Feb 25, 2018 · N98YW · Substantial damage > The pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the… - [NTSB ERA18LA086](https://openairdocs.org/ntsb/ERA18LA086.md): Stearman B75 · Zephryhills, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 23, 2018 · N62438 · Substantial damage > The pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing. - [NTSB WPR18LA094](https://openairdocs.org/ntsb/WPR18LA094.md): Soko Galeb G 2 · Elko, NV · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 21, 2018 · N90SR · Substantial damage > An improperly installed brake cylinder, which resulted in insufficient hydraulic pressure being provided to three of the brake cylinders and the left brake being inoperable during landing. - [NTSB WPR18FA093](https://openairdocs.org/ntsb/WPR18FA093.md): Cirrus Design SR22T · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Feb 21, 2018 · N707DF · Substantial damage > The pilot's exceedance of the airplane's critical angle of attack during an attempted return to the runway following a total loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the excessive amount of… - [NTSB ERA18FA084](https://openairdocs.org/ntsb/ERA18FA084.md): Piper PA28 · Bonifay, FL · Accident · 1 fatal · Field investigation · Final report · Feb 21, 2018 · N3568K · Destroyed > A partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the… - [NTSB CEN18FA101](https://openairdocs.org/ntsb/CEN18FA101.md): Socata TBM 700 · Evanston, WY · Accident · 2 fatal · Field investigation · Final report · Feb 18, 2018 · N700VX · Destroyed > The pilot's loss of control due to spatial disorientation. - [NTSB CEN18LA117](https://openairdocs.org/ntsb/CEN18LA117.md): Black Donald Cozy III · Los Lunas, NM · Accident · No injuries · Limited investigation · Final report · Feb 17, 2018 · N904DB · Substantial damage > The seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing. - [NTSB ANC18FA024](https://openairdocs.org/ntsb/ANC18FA024.md): Mooney M20 · Chuckanut, WA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 2018 · N123JN · Destroyed > The pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain. - [NTSB WPR18MA087](https://openairdocs.org/ntsb/WPR18MA087.md): Eurocopter EC130 · Peach Springs, AZ · Accident · 5 fatal · Class 3 · Major · Final report · Feb 11, 2018 · N155GC · Destroyed > A loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence. - [NTSB GAA18CA123](https://openairdocs.org/ntsb/GAA18CA123.md): Oliver Lawrence R Kitfox IV 1200 · Carson City, NV · Accident · No injuries · Data collection · Final report · Feb 11, 2018 · N76478 · Substantial damage > The flight instructor’s failure to maintain directional control during the landing roll and lateral control during the go-around in gusting crosswind conditions. Contributing to the accident was the lack of communication between the flight instructor and the… - [NTSB CEN18LA095](https://openairdocs.org/ntsb/CEN18LA095.md): Henderson Thorp T 18 · Troy, MO · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 2018 · N600HH · Substantial damage > The pilot's failure to maintain adequate clearance from trees while landing in crosswind conditions. - [NTSB WPR18LA082](https://openairdocs.org/ntsb/WPR18LA082.md): Beech 95 · North Las Vegas, NV · Accident · No injuries · Class 3 · Limited · Final report · Feb 2, 2018 · N128W · Substantial damage > Loss of aircraft control during an unplanned go-around for reasons that could not be determined based on available information. Contributing to the accident was the delayed remedial action by the flight instructor. - [NTSB DCA18WA088](https://openairdocs.org/ntsb/DCA18WA088.md): Boeing 757 23A · Tel Aviv, Israel · Incident · No injuries · Foreign investigation · Jan 30, 2018 · N919FD · No damage > The Israel's Ministry of Transport has notified the NTSB of an incident involving a Boeing 757, which occurred on January 30, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of… - [NTSB ERA18LA071](https://openairdocs.org/ntsb/ERA18LA071.md): Piper PA28 · Meriden, CT · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 2018 · N9673W · Substantial damage > The pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB CEN18LA087](https://openairdocs.org/ntsb/CEN18LA087.md): Robinson Helicopter R44 II · Loveland, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2018 · N878BC · 2 aircraft · Substantial damage > The airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s… - [NTSB CEN18LA085](https://openairdocs.org/ntsb/CEN18LA085.md): Quartz Mountain Aerospace L-11E · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Jan 24, 2018 · N515BW · Substantial damage > The instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power. - [NTSB ERA18LA067](https://openairdocs.org/ntsb/ERA18LA067.md): Cessna 172RG · Martinsburg, WV · Accident · No injuries · Limited investigation · Final report · Jan 21, 2018 · N9415B · Substantial damage > A hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending. - [NTSB WPR18CA072](https://openairdocs.org/ntsb/WPR18CA072.md): Cessna 172P · Cloverdale, CA · Accident · Minor injuries · Data collection · Final report · Jan 20, 2018 · N64204 · Substantial damage > The pilot's failure to maintain airplane control during the approach and his delayed decision to go around. - [NTSB CEN18LA073](https://openairdocs.org/ntsb/CEN18LA073.md): S.O.C.A.T.A. MS893E · Wadsworth, OH · Accident · No injuries · Limited investigation · Final report · Jan 11, 2018 · N353RA · Substantial damage > The pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing. - [NTSB CEN18WA067](https://openairdocs.org/ntsb/CEN18WA067.md): Construcciones Aeronauticas C.A.S.A. 1.131 · Alicante, Spain · Accident · 1 fatal · Foreign investigation · Dec 30, 2017 · N1950M · 2 aircraft · Substantial damage > On December 30, 2017, at 1642 universal time coordinated, a Construcciones Aeronauticas SA C.A.S.A. 1.131 (Bucker BU-131), N1950M (NX-1950M), and a Bell 412SP, EC-MMC, experienced a mid-air collision during final approach for landing to runway 20 at Muchamiel… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=31 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=30 --- 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.