# NTSB investigations, 2017: 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 1 of 4 · 191 cases ## Latest cases - [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… - [NTSB OPS18IA003](https://openairdocs.org/ntsb/OPS18IA003.md): Bombardier CL600 2D24 · Medford, OR · Incident · Class 3 · Incident · Final report · Dec 25, 2017 · N162PQ · No damage > The incident was caused by the air traffic controller assigning an altitude below the published procedure altitude for the approach segment to be flown prior to the aircraft being established on a published portion of the approach. Contributing to the… - [NTSB ERA18TA059](https://openairdocs.org/ntsb/ERA18TA059.md): Cessna 172 · Union Mills, NC · Accident · Minor injuries · Final report · Dec 24, 2017 · N91SP · Substantial damage > The pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing. - [NTSB WPR18LA055](https://openairdocs.org/ntsb/WPR18LA055.md): Kelley Derrick/Leza Aircam · Newport, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 23, 2017 · N959M · Substantial damage > The pilot’s failure to maintain airplane control while on final approach for landing in crosswind conditions, which resulted in a collision with trees. - [NTSB ANC18LA016](https://openairdocs.org/ntsb/ANC18LA016.md): Piper PA 23-250 · Knoxville, TN · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 2017 · N40285 · Substantial damage > The flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel… - [NTSB ANC18WA015](https://openairdocs.org/ntsb/ANC18WA015.md): Piper PA23 · Baldur, Canada · Accident · 1 fatal · Foreign investigation · Dec 16, 2017 · CFIPK · Substantial damage > On December 16, 2017, about 0037 Coordinated Universal Time, a Piper PA-23 airplane, CFIPK, impacted terrain near Baldur, Manitoba, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries.The Transportation Safety Board (TSB) of… - [NTSB WPR18LA051](https://openairdocs.org/ntsb/WPR18LA051.md): Piper PA 32-300 · Hinesville, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 14, 2017 · N4326X · Substantial damage > A total loss of engine power due to the failure of a connecting rod. - [NTSB CEN18WA055](https://openairdocs.org/ntsb/CEN18WA055.md): Cessna 510 · Waldburg, Germany · Accident · 3 fatal · Foreign investigation · Dec 14, 2017 · OE-FWD · Destroyed > On December 14, 2017, about 1620 coordinated universal time, a Cessna 510 airplane, OE-FWD, impacted terrain near Waldburg, Germany. The pilots and passenger were all fatally injured and the airplane was destroyed.The accident investigation is under the… - [NTSB GAA18CA084](https://openairdocs.org/ntsb/GAA18CA084.md): Corbeil Shawn Corbeil Shawn SER VI · Rogersburg, OR · Accident · No injuries · Data collection · Final report · Dec 12, 2017 · N552EZ · Substantial damage > The pilot’s improper landing flare and his subsequent failure to see and avoid a tree during a go-around. - [NTSB CEN18FA050](https://openairdocs.org/ntsb/CEN18FA050.md): Smith Aerostar 601 · Miami, FL · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2017 · N7529S · Destroyed > The pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information. - [NTSB ANC18FA012](https://openairdocs.org/ntsb/ANC18FA012.md): Cessna U206 · Maunaloa, HI · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2017 · N732DF · Destroyed > The pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain. - [NTSB WPR18FA045](https://openairdocs.org/ntsb/WPR18FA045.md): Beech C90 · Geneva, FL · Accident · 3 fatal · Field investigation · Final report · Dec 8, 2017 · N19LW · Destroyed > The pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment… - [NTSB GAA18CA075](https://openairdocs.org/ntsb/GAA18CA075.md): Jones Kent C Vans RV-10 · Limon, CO · Accident · Minor injuries · Data collection · Final report · Dec 8, 2017 · N9738J · Substantial damage > The pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing. - [NTSB ERA18FA046](https://openairdocs.org/ntsb/ERA18FA046.md): Beech 58 · St. Croix · Accident · 5 fatal · Field investigation · Final report · Dec 8, 2017 · N4494A · Destroyed > The non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the… - [NTSB WPR18LA047](https://openairdocs.org/ntsb/WPR18LA047.md): Cessna 172D · Auburn, WA · Accident · No injuries · Class 3 · Limited · Final report · Dec 7, 2017 · N2351U · Substantial damage > The pilot's loss of airplane control for reasons that could not be determined based on the available information. - [NTSB CEN18FA049](https://openairdocs.org/ntsb/CEN18FA049.md): Raytheon B36TC · Chesterfield, MO · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2017 · N679EA · Destroyed > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN18LA047](https://openairdocs.org/ntsb/CEN18LA047.md): Beech C90 · Rockford, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 2017 · N500KR · Substantial damage > The pilot's inadequate preflight planning and his decision to depart without the required fuel reserve, which resulted in fuel exhaustion during a night approach and subsequent loss of engine power. - [NTSB WPR18LA042](https://openairdocs.org/ntsb/WPR18LA042.md): Cessna 152 · Everett, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 3, 2017 · N714TD · Substantial damage > The flight instructor’s inadequate preflight inspection, during which he failed to ensure that water was sufficiently drained from the fuel system, which resulted in total loss of engine power and a subsequent forced landing and impact with objects. - [NTSB CEN18FA045](https://openairdocs.org/ntsb/CEN18FA045.md): Piper Titan Tornado II D · Ravenna, OH · Accident · 1 fatal · Field investigation · Final report · Dec 3, 2017 · N2200T · Destroyed > The pilot's failure to maintain adequate airspeed following a loss of engine power during final approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB GAA18CA069](https://openairdocs.org/ntsb/GAA18CA069.md): Weaver David A Pulsar 912XP · Plato Center, IL · Accident · No injuries · Data collection · Final report · Dec 2, 2017 · N912GR · Substantial damage > The pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration. - [NTSB GAA18CA074](https://openairdocs.org/ntsb/GAA18CA074.md): Cessna 172 · Bowie, MD · Accident · No injuries · Data collection · Final report · Nov 30, 2017 · N474SP · Substantial damage > The pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach. - [NTSB DCA18IA026](https://openairdocs.org/ntsb/DCA18IA026.md): Boeing 737-932ER · Atlanta, GA · Incident · No injuries · Class 3 · Incident · Final report · Nov 29, 2017 · N852DN · No damage > The flight crewmembers’ failure to properly monitor the airplane’s flightpath, which caused the approach to become unstabilized and resulted in the airplane’s descent below the decision altitude while misaligned with the localizer course. Contributing to the… - [NTSB GAA18CA058](https://openairdocs.org/ntsb/GAA18CA058.md): Cessna 182 · Black River Falls, WI · Accident · No injuries · Data collection · Final report · Nov 27, 2017 · N8128M · Substantial damage > The student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions. - [NTSB CEN18LA038](https://openairdocs.org/ntsb/CEN18LA038.md): Piper / Laudeman J3C 65 · Palmyra, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2017 · N11188 · Substantial damage > The pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had… - [NTSB ERA18LA032](https://openairdocs.org/ntsb/ERA18LA032.md): Piper PA 34-220T · Ebensburg, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 2017 · N263DM · Substantial damage > The pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and… - [NTSB GAA18CA061](https://openairdocs.org/ntsb/GAA18CA061.md): Luscombe 8 · Caldwell, TX · Accident · Minor injuries · Data collection · Final report · Nov 23, 2017 · N1780K · Substantial damage > The pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin. - [NTSB GAA18CA063](https://openairdocs.org/ntsb/GAA18CA063.md): Cessna 172N · San Diego, CA · Accident · No injuries · Data collection · Final report · Nov 20, 2017 · N172SX · Substantial damage > An in-flight collision with a bird. - [NTSB ANC18LA010](https://openairdocs.org/ntsb/ANC18LA010.md): Rockwell International 112A · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Nov 19, 2017 · N1401J · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB ERA18LA026](https://openairdocs.org/ntsb/ERA18LA026.md): Piper PA28 · Bladenboro, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 2017 · N8758N · Substantial damage > A loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power. - [NTSB ANC18LA009](https://openairdocs.org/ntsb/ANC18LA009.md): Cessna 172RG · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 2017 · N6102R · Substantial damage > A failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal… - [NTSB CEN18LA031](https://openairdocs.org/ntsb/CEN18LA031.md): Cessna T210N · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Nov 12, 2017 · N5300A · Substantial damage > The failure of the No. 4 connecting rod due to inadequate oil lubrication for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have caused a lack of lubrication. - [NTSB ERA18FA016](https://openairdocs.org/ntsb/ERA18FA016.md): Piper PA 32 · Morrison, TN · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2017 · N47831 · Destroyed > The pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation. - [NTSB CEN18LA036](https://openairdocs.org/ntsb/CEN18LA036.md): Piper PA 28-180 · Carroll, OH · Accident · No injuries · Limited investigation · Final report · Nov 8, 2017 · N10GJ · Substantial damage > The total loss of engine power due to carburetor icing. - [NTSB ENG18IA003](https://openairdocs.org/ntsb/ENG18IA003.md): Airbus A330-243 · Seattle, WA · Incident · No injuries · Class 3 · Incident · Final report · Nov 7, 2017 · N375HA · Minor damage > The loss of control of the left-hand engine and the subsequent thermal damage to the left wing on landing during engine reverse operation was due to a blockage of the variable stator vane torque motor filter that resulted in the engine’s electronic engine… - [NTSB GAA18CA038](https://openairdocs.org/ntsb/GAA18CA038.md): Piper PA28 · Batavia, OH · Accident · Minor injuries · Data collection · Final report · Nov 5, 2017 · N98299 · Substantial damage > The pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing. - [NTSB CEN18FA023](https://openairdocs.org/ntsb/CEN18FA023.md): Beech V35B · Alva, OK · Accident · 2 fatal · Field investigation · Final report · Nov 4, 2017 · N777PH · Destroyed > The flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation… - [NTSB WPR18LA023](https://openairdocs.org/ntsb/WPR18LA023.md): Beech B95 · Las Vegas, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 3, 2017 · N9628R · Substantial damage > The flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing. - [NTSB ERA18FA012](https://openairdocs.org/ntsb/ERA18FA012.md): Beech 35C33 · Whiteville, NC · Accident · 1 fatal · Field investigation · Final report · Oct 31, 2017 · N293GC · Substantial damage > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.… - [NTSB CEN18WA028](https://openairdocs.org/ntsb/CEN18WA028.md): Cessna 152 · Namur, Belgium · Incident · No injuries · Foreign investigation · Oct 31, 2017 · OO-TMC · No damage > On October 31, 2017, at 1305 coordinated universal time, a Cessna 152, Belgium registration OO-TMC, registered to Aero Motion, was involved in an off airport landing following a loss of engine power while preparing to land at the Namur-Suarlee Airport (EBNM),… - [NTSB WPR18CA028](https://openairdocs.org/ntsb/WPR18CA028.md): Still Michael J Titan T-51 · Chandler, AZ · Accident · No injuries · Data collection · Final report · Oct 28, 2017 · N651P · Substantial damage > The pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down. - [NTSB CEN18LA020](https://openairdocs.org/ntsb/CEN18LA020.md): Bell 206B · Groom, TX · Accident · No injuries · Limited investigation · Final report · Oct 24, 2017 · N60EA · Substantial damage > The total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to operate the helicopter with minimum fuel on board. - [NTSB CEN18CA021](https://openairdocs.org/ntsb/CEN18CA021.md): Cessna T210N · Eagle, CO · Accident · No injuries · Data collection · Final report · Oct 23, 2017 · N5129C · Substantial damage > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB WPR18LA014](https://openairdocs.org/ntsb/WPR18LA014.md): American AA 1A · Maricopa, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 21, 2017 · N9239L · Substantial damage > The pilot’s failure to see and avoid unmarked power lines during the approach to land. - [NTSB GAA18CA015](https://openairdocs.org/ntsb/GAA18CA015.md): Thomas G Parkhurst Kitfox IV · Sidney, NY · Accident · Minor injuries · Data collection · Final report · Oct 18, 2017 · N37TP · Substantial damage > The pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin. - [NTSB CEN18LA014](https://openairdocs.org/ntsb/CEN18LA014.md): Diamond Aircraft Ind DA 40 · Gustavus, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2017 · N105MK · Substantial damage > The pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's… - [NTSB DCA18WA016](https://openairdocs.org/ntsb/DCA18WA016.md): Boeing 737 · Moscow, Russia · Incident · No injuries · Foreign investigation · Oct 13, 2017 · VQ-BJP · No damage > The Federal Air Transport Agency (FATA) of Russia has notified the NTSB of an incident involving a Boeing 737, which occurred on October 13, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the… - [NTSB ANC18LA002](https://openairdocs.org/ntsb/ANC18LA002.md): Fleetwood Jack Team Airbike · Ocean Springs, MS · Accident · No injuries · Limited investigation · Final report · Oct 11, 2017 · N7566D · Substantial damage > An intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power. - [NTSB ERA18WA014](https://openairdocs.org/ntsb/ERA18WA014.md): Beech E33A · São José do Rio Preto, Brazil · Accident · 3 fatal · Foreign investigation · Oct 9, 2017 · PT-DDB · Substantial damage > On September 10, 2017, about 1525 coordinated universal time, a Beechcraft E33-A, Brazilian registration PT-DDB, struck a residence while conducting a go around near São José do Rio Preto State Airport (SBSR), Brazil. The airplane was substantially damaged,… - [NTSB WPR18LA003](https://openairdocs.org/ntsb/WPR18LA003.md): Borom Marcus P Long EZ · Tucson, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 7, 2017 · N966EZ · 2 aircraft · Substantial damage > The failure of both pilots to see and avoid the other airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the controller's failure to provide adequate traffic information, issue necessary… - [NTSB GAA18CA007](https://openairdocs.org/ntsb/GAA18CA007.md): Cessna T210 · Waterford, MI · Accident · No injuries · Data collection · Final report · Oct 7, 2017 · N5EC · Substantial damage > The pilot's unstabilized approach at night, which resulted in collision with trees. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2017&page=2 ## 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") = 2017 AND 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?year=2017 --- 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.