# NTSB investigations: 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 65 of 718 · 35,883 cases ## Cases, newest first - [NTSB CEN16LA391](https://openairdocs.org/ntsb/CEN16LA391.md): Cessna 177RG · Cloquet, MN · Accident · No injuries · Limited investigation · Final report · Sep 30, 2016 · N1528H · Substantial damage > A lack of lubrication in the engine for reasons that could not be determined based on the available information, which resulted in a failure of the No. 4 connecting rod and a subsequent total loss of engine power. - [NTSB DCA16WA229](https://openairdocs.org/ntsb/DCA16WA229.md): Pulse Vapor 55 · Ballina, Australia · Incident · No injuries · Foreign investigation · Sep 28, 2016 · LHB270916 > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Pulse Vapor 55 unmanned helicopter that occurred on September 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation… - [NTSB ERA16LA333](https://openairdocs.org/ntsb/ERA16LA333.md): Ryan Navion · Hurt, VA · Accident · No injuries · Limited investigation · Final report · Sep 27, 2016 · N5327K · Substantial damage > Incorrect installation of the oil temperature probe and an inadequate annual inspection that failed to detect leaking oil around the loose probe, which resulted in a catastrophic engine failure due to oil starvation. - [NTSB ERA16FA324](https://openairdocs.org/ntsb/ERA16FA324.md): Cessna 120 · North Collins, NY · Accident · 3 fatal · Field investigation · Final report · Sep 25, 2016 · N3580V · 2 aircraft · Destroyed > The failure of the second airplane's pilot to see and avoid the first airplane as he was overtaking the first airplane. - [NTSB ERA16LA328](https://openairdocs.org/ntsb/ERA16LA328.md): North American T28 · Greenwood, MS · Accident · No injuries · Class 3 · Limited · Final report · Sep 23, 2016 · N526D · Substantial damage > A total loss of engine power for undetermined reasons. - [NTSB DCA16WA230](https://openairdocs.org/ntsb/DCA16WA230.md): Boeing 737 · Lores, Netherlands · Accident · Serious injuries · Foreign investigation · Sep 23, 2016 · PH-HXA · No damage > The Dutch Safety Board (DSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on September 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DSB's investigation under the provisions of ICAO Annex 13 as… - [NTSB ERA16WA334](https://openairdocs.org/ntsb/ERA16WA334.md): Beech E55 · Campinapolis, Brazil · Accident · 4 fatal · Foreign investigation · Sep 22, 2016 · PR-DTA · Destroyed > On September 22, 2016, about 2210 universal time coordinated, a Beech E55, Brazilian registration PR-DTA, was destroyed when it impacted terrain near Campinapolis, Brazil. The airplane departed the Santa Genoveva Airport (SBGO), Goiana, Brazil, and was… - [NTSB ENG16WA043](https://openairdocs.org/ntsb/ENG16WA043.md): Airbus A320 · Brisbane, Australia · Incident · No injuries · Foreign investigation · Sep 22, 2016 · VH-VFY > An Australian-registered A320-232 airplane in cruise flight between Sydney and Cairns, Australia had a failure of the right engine, an International Aero Engine V2527-A5. The airplane diverted to Brisbane for landing. The Australian Transport Safety Bureau… - [NTSB CEN16LA387](https://openairdocs.org/ntsb/CEN16LA387.md): Pahnke Vernon A Vans RV 9A · Newark, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2016 · N699RV · Substantial damage > The pilot's failure to properly assemble the fuel pump, which resulted in the loss of fuel pressure and the subsequent partial loss of engine power. - [NTSB CEN16LA381](https://openairdocs.org/ntsb/CEN16LA381.md): Scottish Series 100 MDL 101 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Sep 22, 2016 · N432BD · Substantial damage > The pilot’s improper preflight inspection during which he relied on the fuel totalizer and failed to ensure that sufficient fuel was onboard for the flight, which resulted in fuel exhaustion and a total loss of engine power. - [NTSB ERA16WA341](https://openairdocs.org/ntsb/ERA16WA341.md): Air Tractor AT602 · Sao Jose do Rio Preto, Brazil · Accident · No injuries · Foreign investigation · Sep 21, 2016 · N1001R · Substantial damage > On September 21, 2016, about 1415 coordinated universal time, an Air Tractor AT-602, N1001R, was substantially damaged during a forced landing to a sugar plantation, following a total loss of engine power during descent near Sao Jose do Rio Preto, Brazil. The… - [NTSB ENG16WA040](https://openairdocs.org/ntsb/ENG16WA040.md): Airbus A319 · Chiclayo, Peru · Incident · No injuries · Foreign investigation · Sep 21, 2016 · CC-COU · No damage > The Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA… - [NTSB CEN16LA382](https://openairdocs.org/ntsb/CEN16LA382.md): Piper PA 28-140 · Wooster, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2016 · N4470X · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. - [NTSB ERA16WA337](https://openairdocs.org/ntsb/ERA16WA337.md): Embraer EMB810 · Miranda, Brazil · Accident · 1 fatal · Foreign investigation · Sep 19, 2016 · PT-VKY · Destroyed > On September 19, 2016, at 2000 coordinated universal time (1600 local), a Piper designed Embraer EMB810-D, Brazilian registration PT-VKY, was destroyed when it impacted terrain in the Miranda Municipality, State of Mato Grosso Do Sul, Brazil. The pilot was… - [NTSB WPR16FA183](https://openairdocs.org/ntsb/WPR16FA183.md): Cessna 182P · Gilbert, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 18, 2016 · N20844 · Destroyed > An inadvertent explosion of pyrotechnics, which were contained in a box that had been installed on the airplane's left main landing gear assembly spring leg which resulted in shrapnel striking the airplane's left wing and breaching the left wing fuel tank,… - [NTSB WPR16FA182](https://openairdocs.org/ntsb/WPR16FA182.md): Beech 95 B55 (T42A) · Broadus, MT · Accident · 3 fatal · Field investigation · Final report · Sep 17, 2016 · N413D · Substantial damage > The airplane's departure from cruise flight for reasons that could not be determined based on the available information. - [NTSB DCA16WA232](https://openairdocs.org/ntsb/DCA16WA232.md): Bell 430 · Cabinda, Angola · Accident · No injuries · Foreign investigation · Sep 16, 2016 · D2-EYI · Destroyed > The Angola Ministry of Transport (MoT) has notified the NTSB of an accident involving a BELL 430 helicopter that occurred on September 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MoT's investigation under the provisions of… - [NTSB DCA16WA239](https://openairdocs.org/ntsb/DCA16WA239.md): Cessna 152 · Malindi, Kenya · Incident · No injuries · Foreign investigation · Sep 15, 2016 · 5Y-GSM · Minor damage > The Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an incident involving a Cessna 152 airplane that occurred on September 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under the… - [NTSB CEN16LA369](https://openairdocs.org/ntsb/CEN16LA369.md): Stinson V77 · Jordan, MN · Accident · No injuries · Limited investigation · Final report · Sep 14, 2016 · N715FB · Substantial damage > A partial loss of engine power due to carburetor icing. - [NTSB CEN16WA376](https://openairdocs.org/ntsb/CEN16WA376.md): Schweizer 269C · Lausanne - La Blecherette, Switzerland · Accident · No injuries · Foreign investigation · Sep 13, 2016 · HB-ZLB > The Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Schweizer Aircraft Corporation 269 helicopter, HB-ZLB, that occurred on September 13, 2016. The NTSB has… - [NTSB CEN16RA399](https://openairdocs.org/ntsb/CEN16RA399.md): Cessna P210N · Guatemala City, Guatemala · Accident · No injuries · Foreign investigation · Sep 13, 2016 · N210BC · Substantial damage > On September 13, 2016, about 1600 UTC, a Cessna turbo P210N, N210BC, owned and operated by a private individual lost engine power in cruise flight and impacted on a road near Guatemala City, Guatemala. The pilot on board was not injured. The airplane… - [NTSB GAA16CA483](https://openairdocs.org/ntsb/GAA16CA483.md): Cessna 172 · Covington, GA · Accident · No injuries · Data collection · Final report · Sep 12, 2016 · N5283R · Substantial damage > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB DCA16WA241](https://openairdocs.org/ntsb/DCA16WA241.md): Cessna 152 · Nairobi, Kenya · Accident · No injuries · Foreign investigation · Sep 12, 2016 · 5Y-NNC · Substantial damage > The Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on September 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID investigation under the… - [NTSB WPR16LA179](https://openairdocs.org/ntsb/WPR16LA179.md): Mccluskey Challenger II · Bisbee, AZ · Accident · No injuries · Class 3 · Limited · Final report · Sep 10, 2016 · N6162Y · Substantial damage > A total loss of engine power for reasons that could not be determined based on the available information. - [NTSB GAA16CA489](https://openairdocs.org/ntsb/GAA16CA489.md): Burkhart Grob Flugzeugbau G109 · Emigrant Gap, CA · Accident · No injuries · Data collection · Final report · Sep 9, 2016 · N909G · Substantial damage > The pilot's inappropriate decision to continue the flight into higher elevation under high-density altitude conditions, which degraded the glider's climb performance and resulted in impact with trees short of the intended runway. - [NTSB ENG16WA036](https://openairdocs.org/ntsb/ENG16WA036.md): Boeing 777 · Tarcoola, Australia, Australia · Incident · No injuries · Foreign investigation · Sep 7, 2016 · A6-EGA · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 777-31HER which occurred on September 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions… - [NTSB CEN16FA361](https://openairdocs.org/ntsb/CEN16FA361.md): Piper PA 46-310P · Chariton, IA · Accident · 1 fatal · Field investigation · Final report · Sep 7, 2016 · N465JM · Substantial damage > The non-instrument-rated pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations and a subsequent in-flight breakup. Contributing to the… - [NTSB CEN16WA358](https://openairdocs.org/ntsb/CEN16WA358.md): Bell 206B · Flatlands, Canada · Accident · 2 fatal · Foreign investigation · Sep 4, 2016 · C-GVJT · Substantial damage > On September 4, 2016, about 1600 Atlantic Daylight Time, a Bell model 206B helicopter, Canadian registration C-GVJT, serial number 3492, collided with power lines during cruise flight before crashing into the Restigouche River near Flatlands, New Brunswick,… - [NTSB CEN16LA349](https://openairdocs.org/ntsb/CEN16LA349.md): Piper PA 28-180 · Cuba, NM · Accident · No injuries · Limited investigation · Final report · Sep 4, 2016 · N9241J · Substantial damage > A partial loss of engine power for reasons that could not be determined based on available information. - [NTSB ERA16FA309](https://openairdocs.org/ntsb/ERA16FA309.md): Cessna 172 · Hollywood, FL · Accident · 2 fatal · Field investigation · Final report · Sep 3, 2016 · N6091E · Destroyed > The pilot's inadequate preflight and in-flight weather planning, which resulted in continued flight into a thunderstorm and a subsequent loss of airplane control. - [NTSB DCA16CA220](https://openairdocs.org/ntsb/DCA16CA220.md): Boeing 767 322 · International Waters, A1 · Accident · Serious injuries · Data collection · Final report · Aug 31, 2016 · N657UA · No damage > an inadvertent encounter with severe convective turbulence. - [NTSB ANC16FA061](https://openairdocs.org/ntsb/ANC16FA061.md): Cessna 208 · Russian Mission, AK · Accident · 5 fatal · Field investigation · Final report · Aug 31, 2016 · N752RV · 2 aircraft · Destroyed > The failure of both pilots to see and avoid each other while in level cruise flight, which resulted in a midair collision. - [NTSB CEN16LA355](https://openairdocs.org/ntsb/CEN16LA355.md): Republic RC3 · Post Oak, MO · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2016 · N6490K · Substantial damage > A partial loss of engine power due to low cylinder compression. Contributing to the loss of engine power was rust formation in the cylinders due to inactivity. - [NTSB WPR16WA192](https://openairdocs.org/ntsb/WPR16WA192.md): Cessna 182 · Mpumalanga Province, South Africa · Accident · 3 fatal · Foreign investigation · Aug 27, 2016 · ZS-PHB · Destroyed > On August 27, 2016, about 1025 coordinated universal time, a Cessna 182Q, South African registration ZS-PHB, was destroyed when it impacted terrain shortly after takeoff from Komati Gorge Lodge private airstrip, Mpumalanga Province, South Africa. The pilot… - [NTSB DCA16FA217](https://openairdocs.org/ntsb/DCA16FA217.md): Boeing 737-700 · Pensacola, FL · Accident · No injuries · Field investigation · Final report · Aug 27, 2016 · N766SW · Substantial damage > A low-cycle fatigue crack in the dovetail of fan blade No. 23, which resulted in the fan blade separating in flight and impacting the fan case. This impact caused the fan blade to fracture into fragments that traveled farther than expected into the inlet,… - [NTSB ANC16LA060](https://openairdocs.org/ntsb/ANC16LA060.md): Piper PA 18-150 · Salcha, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 2016 · N8998Y · Substantial damage > The pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain. - [NTSB CEN16WA403](https://openairdocs.org/ntsb/CEN16WA403.md): Robin DR400/180R · Schaffhausen, Switzerland · Accident · No injuries · Foreign investigation · Aug 26, 2016 · HB-EQN · Substantial damage > The government of Switzerland has notified the NTSB of an accident involving a ROBIN DR400/180R airplane that occurred on August 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under… - [NTSB CEN16LA335](https://openairdocs.org/ntsb/CEN16LA335.md): Cessna U206G · Cave-In-Rock, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 2016 · N891LL · Substantial damage > A total loss of engine power due to air entering the fuel system for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s inability to restart the engine due to the check valve assembly design. - [NTSB ANC16CA058](https://openairdocs.org/ntsb/ANC16CA058.md): Piper J5A · Sterling, AK · Accident · No injuries · Data collection · Final report · Aug 25, 2016 · N35589 · Substantial damage > The pilot's improper fuel management, which led to fuel exhaustion and a subsequent forced landing on a road too narrow for the airplane. - [NTSB ERA16FA297](https://openairdocs.org/ntsb/ERA16FA297.md): Heberlein Ronald Vans RV 9A · Sebring, FL · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2016 · N379RV · Destroyed > The pilot's failure to maintain clearance from terrain. - [NTSB CEN16FA331](https://openairdocs.org/ntsb/CEN16FA331.md): Stemme S10 VT · Telluride, CO · Accident · 2 fatal · Field investigation · Final report · Aug 24, 2016 · N5021 · Substantial damage > The pilot's encounter with a downdraft that exceeded the climb performance of the powered glider and resulted in his inability to maintain clearance from the trees. Contributing to the accident was the pilot's decision to fly near building clouds and rain… - [NTSB ERA16LA300](https://openairdocs.org/ntsb/ERA16LA300.md): Cessna 150 · Littleton, MA · Accident · No injuries · Limited investigation · Final report · Aug 19, 2016 · N9230U · Substantial damage > A total loss of engine power during descent for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation. - [NTSB DCA16CA214](https://openairdocs.org/ntsb/DCA16CA214.md): Boeing 737 924 · Waco, TX · Accident · Serious injuries · Data collection · Final report · Aug 17, 2016 · N37408 · No damage > an encounter with convective turbulence. - [NTSB GAA16CA432](https://openairdocs.org/ntsb/GAA16CA432.md): Cessna 150 · North Conway, NH · Accident · No injuries · Data collection · Final report · Aug 15, 2016 · N7157X · Substantial damage > The pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over. - [NTSB ERA16FA289](https://openairdocs.org/ntsb/ERA16FA289.md): Piper PA 31 · Northport, AL · Accident · 6 fatal · Field investigation · Final report · Aug 14, 2016 · N447SA · Substantial damage > A total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of… - [NTSB ERA16LA293](https://openairdocs.org/ntsb/ERA16LA293.md): Cessna 150G · Shirley, NY · Accident · No injuries · Class 3 · Limited · Final report · Aug 13, 2016 · N3666J · Substantial damage > Maintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator. - [NTSB ERA16LA291](https://openairdocs.org/ntsb/ERA16LA291.md): Luscombe 8 · Marlboro, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2016 · N71497 · Substantial damage > The pilot's inadequate in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power. - [NTSB CEN16LA323](https://openairdocs.org/ntsb/CEN16LA323.md): Cessna TU206C · Skiatook, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2016 · N29225 · Substantial damage > A total loss of engine power after takeoff for reasons that could not be determined based on the available information. - [NTSB WPR16LA164](https://openairdocs.org/ntsb/WPR16LA164.md): Zenith CH601 · Ocean Shores, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2016 · N619LD · Substantial damage > A reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power. - [NTSB DCA16IA215](https://openairdocs.org/ntsb/DCA16IA215.md): Airbus A320 232 · Wood, SD · Incident · Minor injuries · Incident investigation · Final report · Aug 12, 2016 · N632JB · Minor damage > an inadvertent encounter with convective turbulence while in cruise flight. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=66 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=65 --- 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.