# NTSB investigations, 2016: 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 · 160 cases ## Latest cases - [NTSB CEN17FA063](https://openairdocs.org/ntsb/CEN17FA063.md): Piper PA28R · McKinney, TX · Accident · 3 fatal · Field investigation · Final report · Dec 31, 2016 · N4407T · 2 aircraft · Destroyed > The other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision. - [NTSB DCA17WA056](https://openairdocs.org/ntsb/DCA17WA056.md): Boeing 737 · Paris, France · Incident · No injuries · Foreign investigation · Dec 30, 2016 · CN-ROJ · No damage > The Bureau d'Enquêtes et d'Analyses (BEA) of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's… - [NTSB WPR17LA043](https://openairdocs.org/ntsb/WPR17LA043.md): Robinson Helicopter R44 II · Mt. Baldy, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 2016 · N324RS · Substantial damage > The pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near… - [NTSB CEN17LA062](https://openairdocs.org/ntsb/CEN17LA062.md): Piper PA22 · Piedmont, MO · Accident · No injuries · Limited investigation · Final report · Dec 28, 2016 · N5499Z · Substantial damage > The pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines. - [NTSB WPR17LA042](https://openairdocs.org/ntsb/WPR17LA042.md): Air Tractor AT 602 · Willows, CA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2016 · N602L · Substantial damage > The decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn… - [NTSB ERA17FA074](https://openairdocs.org/ntsb/ERA17FA074.md): Independent Technologies Epic LT · Port Orange, FL · Accident · 2 fatal · Field investigation · Final report · Dec 27, 2016 · N669WR · Substantial damage > The pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach… - [NTSB ERA17WA085](https://openairdocs.org/ntsb/ERA17WA085.md): Beech 58 · Tabatinga, Brazil · Accident · 3 fatal · Foreign investigation · Dec 23, 2016 · PT-ICU · Destroyed > On December 23, 2016, about 1830 universal coordinated time, a Beech 58, Brazilian registration PT-ICU, was destroyed when it impacted wooded terrain while on approach to Tabatinga International Airport (SBTT), Tabatinga, State of Amazonas, Brazil. The two… - [NTSB GAA17CA103](https://openairdocs.org/ntsb/GAA17CA103.md): Piper PA28 · Shreveport, LA · Accident · Minor injuries · Data collection · Final report · Dec 22, 2016 · N9541W · Substantial damage > The pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control. - [NTSB CEN17LA060](https://openairdocs.org/ntsb/CEN17LA060.md): Cessna 175C · Millersburg, OH · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2016 · N8381T · Substantial damage > The pilot's improper in-flight fuel management and his failure to switch the fuel selector to the “both” position in accordance with the Before Landing checklist, which resulted in a loss of engine power due to fuel starvation. - [NTSB CEN17LA059](https://openairdocs.org/ntsb/CEN17LA059.md): Cessna 210 · Longville, MN · Accident · No injuries · Limited investigation · Final report · Dec 20, 2016 · N80RB · Substantial damage > The in-flight encounter with wind shear and gusting wind conditions, which resulted in a bounced landing and runway excursion. - [NTSB GAA17CA109](https://openairdocs.org/ntsb/GAA17CA109.md): Piper PA28R · Kewanee, IL · Accident · No injuries · Data collection · Final report · Dec 16, 2016 · N55484 · Substantial damage > The pilot’s failure to extend the landing gear during the approach to land. - [NTSB GAA17CA095](https://openairdocs.org/ntsb/GAA17CA095.md): Robinson Helicopter R44 · Separ, NM · Accident · No injuries · Data collection · Final report · Dec 15, 2016 · N835AK · Substantial damage > The pilot’s abrupt maneuver to avoid electrical wires during the approach, which resulted in a hard landing. - [NTSB ERA17CA068](https://openairdocs.org/ntsb/ERA17CA068.md): Beech A36 · New Smyrna Beach, FL · Accident · Minor injuries · Data collection · Final report · Dec 12, 2016 · N776WM · Substantial damage > The pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the… - [NTSB CEN17WA051](https://openairdocs.org/ntsb/CEN17WA051.md): Piper PA-34-200T · Alsace, France · Accident · 1 fatal · Foreign investigation · Dec 7, 2016 · HB-LSD · Destroyed > On December 7, 2016, at 1644 coordinated universal time, a Piper PA-34-200T airplane, Switzerland registration HB-LSD, was destroyed when it collided with the terrain near Alsace, France. The pilot was fatally injured. The airplane departed the Nurnberg… - [NTSB WPR17FA033](https://openairdocs.org/ntsb/WPR17FA033.md): Airborne Windsports PTY Edge XT-912-L · Santa Barbara, CA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2016 · N188M · Substantial damage > The pilot's failure to maintain aircraft control while maneuvering in the traffic pattern. - [NTSB WPR17LA032](https://openairdocs.org/ntsb/WPR17LA032.md): Hoskins Lonnie F Velocity XL RG · Petaluma, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 2016 · N84KJ · Substantial damage > The pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on… - [NTSB GAA17CA087](https://openairdocs.org/ntsb/GAA17CA087.md): Jack Fehling Celebrity · North Hampton, NH · Accident · No injuries · Data collection · Final report · Dec 4, 2016 · N28JF · Substantial damage > The pilot’s unstabilized approach, which resulted in the biplane being low and striking trees. - [NTSB ERA17WA081](https://openairdocs.org/ntsb/ERA17WA081.md): Robinson Helicopter R44 II · Sao Lourenco da Serra, Brazil · Accident · 4 fatal · Foreign investigation · Dec 4, 2016 · PR-TUN · Destroyed > On December 4, 2016, about 1800 universal coordinated time, a Robinson R44-II, Brazilian registration PR-TUN, was substantially damaged when it impacted terrain while maneuvering near Sao Lourenco, Sao Paulo, Brazil. The pilot and three passengers were… - [NTSB GAA17CA089](https://openairdocs.org/ntsb/GAA17CA089.md): Piper PA 28 · Thomson, GA · Accident · No injuries · Data collection · Final report · Dec 2, 2016 · N2367R · Substantial damage > The pilot’s improper preflight planning, which resulted in fuel exhaustion and the total loss of engine power. - [NTSB CEN17FA045](https://openairdocs.org/ntsb/CEN17FA045.md): Cessna 340 · Fargo, ND · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2016 · N123KK · Destroyed > The loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire. - [NTSB DCA17RA031](https://openairdocs.org/ntsb/DCA17RA031.md): BAE AVRO146RJ · Medellin, Colombia · Accident · No injuries · Foreign investigation · Nov 28, 2016 · CP-2933 · Destroyed > The El Grupo de Investigacon de Accidentes (GRIAA) of Colombia has notified the NTSB of an accident involving a BAE AVRO146RJ that occurred on November 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA investigation under… - [NTSB WPR17FA029](https://openairdocs.org/ntsb/WPR17FA029.md): Bellanca 7GCAA · Glamis, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2016 · N88373 · Substantial damage > The pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an… - [NTSB ERA17WA059](https://openairdocs.org/ntsb/ERA17WA059.md): Embraer EMB710 · Novo Progresso, Brazil · Accident · 4 fatal · Foreign investigation · Nov 24, 2016 · PT-NCJ · Substantial damage > On November 24, 2016, about 2040 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NCJ, was substantially damaged when it impacted terrain on approach to an unregistered landing strip in a quarry near Novo Progresso, State of Para,… - [NTSB ERA17WA061](https://openairdocs.org/ntsb/ERA17WA061.md): Cessna TU206 · Villavicencio, Colombia · Accident · 1 fatal · Foreign investigation · Nov 23, 2016 · HK-2659 · Substantial damage > On November 23, 2016, about 2000 coordinated universal time, a Cessna TU206G, Colombian registration HK2659, was substantially damaged during a forced landing near Vanguardia Airport (SKVV), Colombia. The Colombian certificated pilot and two of the passengers… - [NTSB CEN17LA043](https://openairdocs.org/ntsb/CEN17LA043.md): Beech 200 · Moorhead, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 2016 · N80RT · Substantial damage > The pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain. - [NTSB WPR17FA023](https://openairdocs.org/ntsb/WPR17FA023.md): Cessna 172N · Moss Beach, CA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2016 · N6610D · Substantial damage > The pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in… - [NTSB ERA17LA048](https://openairdocs.org/ntsb/ERA17LA048.md): Schweizer SGS126 · Moscow, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2016 · N65968 · Substantial damage > The pilot's failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin. - [NTSB ENG17WA025](https://openairdocs.org/ntsb/ENG17WA025.md): Bombardier BD700 1A11 · Hong Kong, Hong Kong SAR China · Incident · No injuries · Foreign investigation · Nov 15, 2016 · VP-CKM · No damage > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Bombardier Global Express BD700, which occurred on November 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB… - [NTSB GAA17CA061](https://openairdocs.org/ntsb/GAA17CA061.md): Beech 95B55 · Plattsburgh, NY · Accident · No injuries · Data collection · Final report · Nov 14, 2016 · N180GA · Substantial damage > The pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle-of-attack during a single-engine approach, which resulted in an aerodynamic stall at an altitude too low for the flight instructor to recover. - [NTSB GAA17CA072](https://openairdocs.org/ntsb/GAA17CA072.md): Piper PA 28R · Payallup, WA · Accident · No injuries · Data collection · Final report · Nov 11, 2016 · N9466K · Substantial damage > The airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing. - [NTSB ERA17CA039](https://openairdocs.org/ntsb/ERA17CA039.md): Piper PA 24-250 · Houlton, ME · Accident · No injuries · Data collection · Final report · Nov 8, 2016 · N7682P · Substantial damage > A total loss of engine power due to fuel starvation, which resulted from the pilot’s mismanagement of the available fuel. - [NTSB CEN17LA037](https://openairdocs.org/ntsb/CEN17LA037.md): Johnson Kenneth R Stol CH 801 · Royalton, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2016 · N801KJ · Destroyed > The loss of control during approach for reasons that could not be determined due to postimpact fire damage. - [NTSB GAA17LA090](https://openairdocs.org/ntsb/GAA17LA090.md): Piper PA28R · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Nov 5, 2016 · N300KR · Substantial damage > The pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination… - [NTSB ERA17LA034](https://openairdocs.org/ntsb/ERA17LA034.md): Piper PA32 · Bartow, FL · Accident · No injuries · Limited investigation · Final report · Oct 31, 2016 · N3941X · Substantial damage > A total loss of engine power during approach for reasons that could not be determined because engine examinations did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation. - [NTSB CEN17FA028](https://openairdocs.org/ntsb/CEN17FA028.md): Aviat A-1C-180 · Clarksville, TX · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2016 · N377MA · Destroyed > The pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB CEN17WA086](https://openairdocs.org/ntsb/CEN17WA086.md): Mooney M20K · Saarbrucken, Germany · Accident · 1 fatal · Foreign investigation · Oct 27, 2016 · N400MW · Substantial damage > On October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was… - [NTSB DCA17WA224](https://openairdocs.org/ntsb/DCA17WA224.md): Boeing 757 · Keflavik, Iceland · Incident · No injuries · Foreign investigation · Oct 19, 2016 · TF-ISR · No damage > The Icelandic Transportation Safety Board has notified the NTSB of a serious incident involving a BOEING 757 airplane that occurred on October 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Iceland's… - [NTSB ERA17WA090](https://openairdocs.org/ntsb/ERA17WA090.md): Aerofab Lake LA 250 · Puerto Plata, Dominican Republic · Accident · 3 fatal · Foreign investigation · Oct 17, 2016 · N724ST · Substantial damage > On October 17, 2016, about 2200 coordinated universal time, an AeroFab, Inc. Lake-250, N724ST, was substantially damaged when it impacted the ocean while on approach to Gregorio Luperón International Airport (POP), Puerto Plata, Dominican Republic. The pilot… - [NTSB WPR17IA007](https://openairdocs.org/ntsb/WPR17IA007.md): Short Bros SD3 60 Sherpa · Missoula, MT · Incident · No injuries · Incident investigation · Final report · Oct 13, 2016 · N148Z · Minor damage > The failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer… - [NTSB CEN17LA015](https://openairdocs.org/ntsb/CEN17LA015.md): Milholland Kelly D · Livingston, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 2016 · N522LM · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB GAA17CA004](https://openairdocs.org/ntsb/GAA17CA004.md): Airborne Windsports PTY Edge XT 912 L · Fort Valley, GA · Accident · Serious injuries · Data collection · Final report · Oct 2, 2016 · N53AW · Substantial damage > The failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact. - [NTSB CEN17WA008](https://openairdocs.org/ntsb/CEN17WA008.md): North American P-51D · East Anglia, United Kingdom · Accident · 1 fatal · Foreign investigation · Oct 2, 2016 · G-MSTG · Substantial damage > This is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted… - [NTSB ERA17LA005](https://openairdocs.org/ntsb/ERA17LA005.md): Piper PA28 · Laurel, MS · Accident · No injuries · Limited investigation · Final report · Oct 1, 2016 · N499TG · Substantial damage > A total loss of engine power due to a stuck carburetor float. The reason the carburetor float became stuck could not be determined because postaccident examination of the float and needle/seat revealed no anomalies. - [NTSB CEN17LA003](https://openairdocs.org/ntsb/CEN17LA003.md): Beech C23 · Taylor, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2016 · N9704L · Destroyed > A total loss of engine power due to fuel starvation as a result of debris obstructing the fuel strainer screen and corrosion of the fuel strainer bowl. - [NTSB DCA16CA226](https://openairdocs.org/ntsb/DCA16CA226.md): Bombardier DHC 8 202 · Dulles, VA · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N366PH · Substantial damage > incorrect installation of the frangible towing fuse that prevented the nose landing gear from extending. - [NTSB ERA16LA322](https://openairdocs.org/ntsb/ERA16LA322.md): Aero Vodochody L 39 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Sep 23, 2016 · N139AJ · Substantial damage > An uncommanded flap retraction for reasons that could not be determined, as a postaccident examination of the flap system did not reveal evidence of any preaccident anomalies. - [NTSB CEN16LA380](https://openairdocs.org/ntsb/CEN16LA380.md): Piper PA 30 · Mineral Wells, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2016 · N7663Y · Substantial damage > The pilot's fuel mismanagement, which resulted in fuel starvation to both engines and their subsequent loss of engine power. - [NTSB GAA16CA501](https://openairdocs.org/ntsb/GAA16CA501.md): Piper PA28R · Ottumwa, IA · Accident · No injuries · Data collection · Final report · Sep 21, 2016 · N3803T · Substantial damage > The pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the… - [NTSB CEN16FA373](https://openairdocs.org/ntsb/CEN16FA373.md): Cessna 182 · Ephraim, WI · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2016 · N2012F · Destroyed > The pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain. - [NTSB CEN16FA372](https://openairdocs.org/ntsb/CEN16FA372.md): Agusta A109 · Alexandria, MN · Accident · Serious injuries · Field investigation · Final report · Sep 17, 2016 · N91NM · Destroyed > The pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2016&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") = 2016 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=2016 --- 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.