# NTSB investigations, 2017: Enroute 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 6 · 275 cases ## Latest cases - [NTSB WPR18LA056](https://openairdocs.org/ntsb/WPR18LA056.md): Cessna 150L · Perris, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 25, 2017 · N6627G · Substantial damage > The presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor. - [NTSB ERA18FA056](https://openairdocs.org/ntsb/ERA18FA056.md): Beech G35 · Cross City, FL · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N354WD · Destroyed > The pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control. - [NTSB DCA18CA049](https://openairdocs.org/ntsb/DCA18CA049.md): Embraer S A ERJ170-200LR · Saint Louis, MO · Accident · Serious injuries · Data collection · Final report · Dec 18, 2017 · N128SY · No damage > the abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle. - [NTSB CEN18FA054](https://openairdocs.org/ntsb/CEN18FA054.md): Piper PA28 · Reeds Spring, MO · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2017 · N6433J · Destroyed > The noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain. - [NTSB CEN18FA053](https://openairdocs.org/ntsb/CEN18FA053.md): Cessna T210M · Oldenburg, IN · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2017 · N761YZ · Destroyed > A total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational… - [NTSB ERA18LA055](https://openairdocs.org/ntsb/ERA18LA055.md): Cessna 182 · Burlington, NC · Accident · No injuries · Limited investigation · Final report · Dec 16, 2017 · N199RN · 2 aircraft · Substantial damage > The pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright. - [NTSB ERA18LA050](https://openairdocs.org/ntsb/ERA18LA050.md): Cessna 152 · Everglades City, FL · Accident · No injuries · Limited investigation · Final report · Dec 16, 2017 · N95550 · Substantial damage > The loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power. - [NTSB ERA18WA047](https://openairdocs.org/ntsb/ERA18WA047.md): Cessna T210 · West End, Bahamas · Accident · 1 fatal · Class 5 · Foreign · Dec 14, 2017 · N727TJ · Substantial damage - [NTSB ERA18WA060](https://openairdocs.org/ntsb/ERA18WA060.md): Air Tractor AT502 · Rivadavia, Argentina · Accident · 1 fatal · Foreign investigation · Dec 13, 2017 · LV-ZZX · Substantial damage > The government of Argentina has notified the NTSB of an accident involving an Air Tractor AT-502B airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under… - [NTSB WPR18FA046](https://openairdocs.org/ntsb/WPR18FA046.md): Beech A36 · San Diego, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2017 · N248SB · Destroyed > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB DCA18CA055](https://openairdocs.org/ntsb/DCA18CA055.md): Airbus A321 231 · Fort Lauderdale, FL · Accident · Serious injuries · Data collection · Final report · Dec 6, 2017 · N670NK · No damage > an inadvertent encounter with convective turbulence that resulted in a flight attendant injury. - [NTSB ERA18LA041](https://openairdocs.org/ntsb/ERA18LA041.md): Piper PA28 · Brewton, AL · Accident · No injuries · Limited investigation · Final report · Dec 5, 2017 · N747KM · Substantial damage > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB WPR18LA043](https://openairdocs.org/ntsb/WPR18LA043.md): Beech A36 · Rio Oso, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 4, 2017 · N251E · Substantial damage > An in-flight fire due to electrical arc corrosion of the fuel line. - [NTSB WPR18WA061](https://openairdocs.org/ntsb/WPR18WA061.md): Enstrom 480 · Bacoor, Philippines · Accident · Minor injuries · Foreign investigation · Dec 2, 2017 · RP-C8955 · Substantial damage > On December 2, 2017, at 0900 universal time coordinated, a Enstrom Helicopter Corporation 480B, RP-C8955, was substantially damaged during a precautionary landing near Bacoor, Cavite, Philippines. The pilot was not injured, and the passenger sustained minor… - [NTSB DCA18WA027](https://openairdocs.org/ntsb/DCA18WA027.md): Boeing 757 224 · Bogota, Colombia · Accident · Serious injuries · Foreign investigation · Nov 29, 2017 · N14115 · No damage > The Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State… - [NTSB CEN18LA042](https://openairdocs.org/ntsb/CEN18LA042.md): Motley Gary W Zenith CH750 Cruzer · Louviers, CO · Accident · No injuries · Limited investigation · Final report · Nov 27, 2017 · N956GM · Substantial damage > The engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean. - [NTSB CEN18LA040](https://openairdocs.org/ntsb/CEN18LA040.md): Cessna 150F · Midland, TX · Accident · No injuries · Limited investigation · Final report · Nov 26, 2017 · N8637S · Substantial damage > The improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure. - [NTSB WPR18LA040](https://openairdocs.org/ntsb/WPR18LA040.md): Piper PA-28 · Odessa, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2017 · N57351 · Substantial damage > A loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power. - [NTSB ANC18LA011](https://openairdocs.org/ntsb/ANC18LA011.md): Cessna 172 · Oloh, MS · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2017 · N739KW · Substantial damage > A partial loss of engine power due to the failure of the No. 3 valve key (exhaust). - [NTSB CEN18FA037](https://openairdocs.org/ntsb/CEN18FA037.md): Cessna 172G · Pittsford, VT · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2017 · N4676L · Destroyed > The pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. - [NTSB DCA18WA047](https://openairdocs.org/ntsb/DCA18WA047.md): Boeing 737 · Jauja, Peru · Incident · No injuries · Foreign investigation · Nov 20, 2017 · OB-2140P · No damage > The Peruvian Board of Aviation Accidents Investigation (CIAA) has notified the NTSB of an incident involving a Boeing 737, which occurred on November 20, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex… - [NTSB CEN18FA033](https://openairdocs.org/ntsb/CEN18FA033.md): Bell Helicopter Textron Canada 407 · Stuttgart, AR · Accident · 3 fatal · Field investigation · Final report · Nov 20, 2017 · N620PA · Destroyed > An in-flight loss of control due to bird strikes. - [NTSB GAA18CA048](https://openairdocs.org/ntsb/GAA18CA048.md): Cessna 172M · Chico, CA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2017 · N9678Q · Substantial damage > An in-flight collision with a bird. - [NTSB DCA18WA023](https://openairdocs.org/ntsb/DCA18WA023.md): Boeing 737 · Guayaquil, Ecuador · Incident · No injuries · Foreign investigation · Nov 19, 2017 · YV2937 · Minor damage > The government of Ecuador has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions… - [NTSB WPR18LA033](https://openairdocs.org/ntsb/WPR18LA033.md): Piper PA 28R-201T · Nipton, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N5966V · Substantial damage > A loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown. - [NTSB ERA18WA028](https://openairdocs.org/ntsb/ERA18WA028.md): Cessna 208 · Ngorongoro, Tanzania · Accident · 11 fatal · Foreign investigation · Nov 15, 2017 · 5H-EGG · Substantial damage > On November 15, 2017, about 0805 coordinated universal time, Cessna 208B, Tanzanian registration 5H-EGG, operated by Coastal Aviation LTD., was substantially damaged when it impacted terrain near Ngorongoro, Tanzania. The pilot and 10 passengers were fatally… - [NTSB DCA18WA020](https://openairdocs.org/ntsb/DCA18WA020.md): Boeing 777 · Oceanic, United Kingdom · Incident · No injuries · Foreign investigation · Nov 13, 2017 · G-VIIJ · No damage > The AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on November 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the provisions of ICAO… - [NTSB ERA18FA022](https://openairdocs.org/ntsb/ERA18FA022.md): Piper PA32 · Fountain Run, KY · Accident · 4 fatal · Field investigation · Final report · Nov 12, 2017 · N3371W · Destroyed > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete… - [NTSB ANC18LA008](https://openairdocs.org/ntsb/ANC18LA008.md): Cloud Jeffrey Ferrell Long EZ · Eufaula, AL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2017 · N754T · Substantial damage > The in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s… - [NTSB ENG18RA004](https://openairdocs.org/ntsb/ENG18RA004.md): British Aerospace Avro 146 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Nov 8, 2017 · ZS-ASW · Minor damage > On November 8, 2017, at about 1750 UTC, South African Airlink flight 8103, a British Aerospace BAE-146 RJ85A, registered in South Africa as ZS-ASW, experienced an uncontained release of turbine material from the No. 2 engine, a Honeywell LF507-1F turbofan,… - [NTSB ENG18WA007](https://openairdocs.org/ntsb/ENG18WA007.md): Bell 407 · Krasny Pakhar village, Russia · Accident · No injuries · Foreign investigation · Nov 6, 2017 · UNREG · Destroyed > The Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a Bell 407, which occurred on November 6, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex… - [NTSB WPR18LA039](https://openairdocs.org/ntsb/WPR18LA039.md): Cessna 172R · Redding, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 2, 2017 · N2103T · Substantial damage > The fatigue separation of the crankshaft due to a fatigue fracture, which resulted in a total loss of engine power and a subsequent off-airport landing and impact with a fence. - [NTSB ENG18WA005](https://openairdocs.org/ntsb/ENG18WA005.md): Boeing 767 · Karachi, Pakistan · Incident · No injuries · Foreign investigation · Nov 1, 2017 · A9C-DHJ · No damage > The Safety Investigation Board of Pakistan has notified the NTSB of an incident involving a Boeing 767-200 airplane which occurred on November 1, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the SIB investigation under the… - [NTSB WPR18LA021](https://openairdocs.org/ntsb/WPR18LA021.md): Metcalfe Robert B Vans RV 6 · Selma, CA · Accident · No injuries · Limited investigation · Final report · Oct 30, 2017 · N88MV · Substantial damage > The pilot’s failure to properly secure an alternator ground cable swage that led to problems with the electrical system and/or electronic engine controls, which resulted in a total loss of engine power. - [NTSB ANC18LA006](https://openairdocs.org/ntsb/ANC18LA006.md): Piper PA 32R-300 · Dawsonville, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 2017 · N4213F · Substantial damage > The failure of the pilot, who was not a certified mechanic, to tighten the B-nut on a remotely mounted oil filter line, which resulted in oil exhaustion, a total loss of oil pressure, and a subsequent total loss of engine power. - [NTSB DCA18WA017](https://openairdocs.org/ntsb/DCA18WA017.md): Boeing 737 · Tokyo, Japan · Accident · Serious injuries · Foreign investigation · Oct 22, 2017 · JA03GR · No damage > The JTSB of Japan has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on October 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions of ICAO Annex 13 as the… - [NTSB WPR18FA011](https://openairdocs.org/ntsb/WPR18FA011.md): Peterson Lancair Legacy · Bowie, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 19, 2017 · N259L · Substantial damage > An in-flight loss of control due to a bird strike. - [NTSB ERA18WA052](https://openairdocs.org/ntsb/ERA18WA052.md): Beech B200 · Pucallpa, Peru · Accident · Serious injuries · Foreign investigation · Oct 19, 2017 · OB-2077-P · Substantial damage > The government of Peru has notified the NTSB of an accident involving a Beech B200C airplane that occurred on October 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of… - [NTSB ERA18LA011](https://openairdocs.org/ntsb/ERA18LA011.md): Cessna 402 · St. Petersburg, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 18, 2017 · N900CR · Substantial damage > The pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing. - [NTSB WPR18LA010](https://openairdocs.org/ntsb/WPR18LA010.md): Robinson Helicopter R44 · Molokai, HI · Accident · 2 fatal · Limited investigation · Final report · Oct 17, 2017 · N820DF · Destroyed > A descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information. - [NTSB ENG18WA038](https://openairdocs.org/ntsb/ENG18WA038.md): Embraer ERJ190 · Dublin, Ireland · Incident · No injuries · Foreign investigation · Oct 16, 2017 · G-FBEM · No damage > The Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving an Embraer 190-200 LR, which occurred on October 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the… - [NTSB ANC18FA003](https://openairdocs.org/ntsb/ANC18FA003.md): Cessna 210 · Russian Mission, AK · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2017 · N8347Z · Destroyed > The pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control. - [NTSB DCA18CA007](https://openairdocs.org/ntsb/DCA18CA007.md): Boeing 767 328 · Honolulu, HI · Accident · Serious injuries · Data collection · Final report · Oct 15, 2017 · N342AX · No damage > an inadvertent encounter of clear air turbulence. - [NTSB DCA18WA015](https://openairdocs.org/ntsb/DCA18WA015.md): Boeing 777 · Adelaide, Australia · Incident · No injuries · Foreign investigation · Oct 14, 2017 · A6-ETR · No damage > The government of Australia has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on October 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the… - [NTSB CEN18LA013](https://openairdocs.org/ntsb/CEN18LA013.md): Russell E Oberg Murphy Rebel · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Oct 12, 2017 · N734R · Substantial damage > A total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat. - [NTSB WPR18LA006](https://openairdocs.org/ntsb/WPR18LA006.md): Nanchang China CJ 6 · Buckeye, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 9, 2017 · N8NW · Substantial damage > The failure of the fuel pump’s diaphragm which resulted in fuel system contamination from air and or oil and caused the engine to lose power. - [NTSB WPR18LA018](https://openairdocs.org/ntsb/WPR18LA018.md): Cirrus Design SR22 · Blythe, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2017 · N418CP · Substantial damage > Maintenance personnel's failure to properly torque an oil supply line fitting, which resulted in oil starvation, a subsequent engine failure, and an off-airport landing. - [NTSB WPR18LA002](https://openairdocs.org/ntsb/WPR18LA002.md): Cessna 172S · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Oct 2, 2017 · N5311H · Substantial damage > The pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of… - [NTSB WPR18FA001](https://openairdocs.org/ntsb/WPR18FA001.md): Cirrus Design SR22 · Klamath Falls, OR · Accident · 2 fatal · Field investigation · Final report · Oct 1, 2017 · N6083D · Destroyed > The noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in… - [NTSB WPR17FA215](https://openairdocs.org/ntsb/WPR17FA215.md): Piper PA 28-140 · Brinnon, WA · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2017 · N9549W · Destroyed > The flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into… Next page: https://openairdocs.org/ntsb-phases/400/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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/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.