# 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 62 of 718 · 35,889 cases ## Cases, newest first - [NTSB ANC17FA021](https://openairdocs.org/ntsb/ANC17FA021.md): Cessna 208B · Chignik Lake, AK · Accident · 1 fatal · Field investigation · Final report · May 1, 2017 · N803TH · Substantial damage > The pilot's continued visual flight rules flight into an area of mountainous terrain and instrument meteorological conditions, which resulted in controlled flight into terrain (CFIT). Contributing to the accident was the company's failure to provide the pilot… - [NTSB ERA17LA169](https://openairdocs.org/ntsb/ERA17LA169.md): Piper PA32RT · Coral Springs, FL · Accident · No injuries · Limited investigation · Final report · Apr 30, 2017 · N31678 · Substantial damage > The in-flight disconnection of the fuel injection servo throttle linkage, which resulted in a loss of engine power. - [NTSB WPR17LA094](https://openairdocs.org/ntsb/WPR17LA094.md): Yakovlev YAK 52 · Porterville, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2017 · N132MD · Substantial damage > A partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined. - [NTSB ENG17WA021](https://openairdocs.org/ntsb/ENG17WA021.md): Boeing Boeing 787-9 · London, United Kingdom · Incident · No injuries · Foreign investigation · Apr 29, 2017 · G-ZBKF · No damage > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 787-9, which occurred on April 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the… - [NTSB WPR17LA093](https://openairdocs.org/ntsb/WPR17LA093.md): Schweizer 269C · Coolidge, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2017 · N521AR · Substantial damage > A partial loss of engine power due to separation of the throttle cable. - [NTSB WPR17FA091](https://openairdocs.org/ntsb/WPR17FA091.md): Nanchang CJ6A · Keene, CA · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2017 · N192NG · Destroyed > The pilot's failure to maintain airplane control following a descent into clouds. - [NTSB CEN17FA167](https://openairdocs.org/ntsb/CEN17FA167.md): Cessna 421C · Huntsville, TX · Accident · 1 fatal · Field investigation · Final report · Apr 25, 2017 · N421TK · Destroyed > The pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined… - [NTSB WPR17LA090](https://openairdocs.org/ntsb/WPR17LA090.md): Cessna T210N · Banning, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2017 · N6218Y · Substantial damage > The pilot's improper energy management during an emergency landing approach that was prompted by an engine power loss. The specific reason(s) for the power loss and the improper energy management could not be determined based on available evidence. - [NTSB GAA17CA244](https://openairdocs.org/ntsb/GAA17CA244.md): Beech 99 · Waukesha, WI · Accident · No injuries · Data collection · Final report · Apr 24, 2017 · N899CZ · Substantial damage > An in-flight collision with a bird during the approach. - [NTSB CEN17LA178](https://openairdocs.org/ntsb/CEN17LA178.md): Cessna 182G · Manistee, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 2017 · N2056R · Substantial damage > The failure of the airplane owner and maintenance personnel to follow the propeller manufacturer's recommend overhaul schedule, which resulted in a fatigue fracture of the propeller blade actuating pin and a loss of thrust in flight. - [NTSB CEN17LA166](https://openairdocs.org/ntsb/CEN17LA166.md): Piper PA 31-350 · Covington, LA · Accident · No injuries · Limited investigation · Final report · Apr 23, 2017 · N3548J · Substantial damage > The pilot's improper fuel planning, which resulted in a total loss of power to both engines due to fuel exhaustion. - [NTSB ERA17LA163](https://openairdocs.org/ntsb/ERA17LA163.md): Robinson R44 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 2017 · N899GB · Substantial damage > A partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight… - [NTSB ERA17LA160](https://openairdocs.org/ntsb/ERA17LA160.md): Cessna 172 · Yankeetown, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 2017 · N6013E · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation. - [NTSB DCA17WA113](https://openairdocs.org/ntsb/DCA17WA113.md): Boeing 737 · Palma de Mallorca, Spain · Incident · No injuries · Foreign investigation · Apr 20, 2017 · EC-JBK · 2 aircraft · No damage > The Comision de Investigacion de Accidenties E Incidentes de Aviacion Civil of Spain has notified the NTSB of an incident involving a CESSNA 510 airplane that occurred on April 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the… - [NTSB WPR17FA105](https://openairdocs.org/ntsb/WPR17FA105.md): Socata TB 20 Trinidad · Sierraville, CA · Accident · 2 fatal · Field investigation · Final report · Apr 17, 2017 · N28070 · Destroyed > The pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. - [NTSB DCA17WA107](https://openairdocs.org/ntsb/DCA17WA107.md): Airbus A320 · New Delhi, India · Incident · No injuries · Foreign investigation · Apr 17, 2017 · VT-IDB · No damage > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's… - [NTSB ANC17LA020](https://openairdocs.org/ntsb/ANC17LA020.md): Cessna 182 · Willow, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2017 · N9362X · Substantial damage > The partial loss of engine power for reasons that could not be determined based on the available information, which resulted in the forced landing attempt and impact with power lines. - [NTSB ENG17WA020](https://openairdocs.org/ntsb/ENG17WA020.md): BAE JETSTREAM3100 · Monteria, Colombia · Incident · No injuries · Foreign investigation · Apr 15, 2017 · HK4820 · No damage > On April 15, 2017, a Colombian-registered BAE Jetstream J32, HK4820, operated by Aerolinea de Antioquia ADA experienced a loss of power from the No. 2 engine, a Honeywell TPE331 turbopropeller. The engine was shutdown in flight and the airplane diverted to… - [NTSB DCA17CA101](https://openairdocs.org/ntsb/DCA17CA101.md): Embraer ERJ 190 100 IGW · Orlando, FL · Accident · Serious injuries · Data collection · Final report · Apr 14, 2017 · N373JB · No damage > an inadvertent encounter with convective turbulence, which resulted in a serious injury to a flight attendant. - [NTSB GAA17CA233](https://openairdocs.org/ntsb/GAA17CA233.md): Piper PA 34 · Llano, TX · Accident · No injuries · Data collection · Final report · Apr 12, 2017 · N461RL · Substantial damage > The pilot’s complacency during the en route phase of flight, which resulted in fuel mismanagement and a subsequent gear-up landing. - [NTSB GAA17CA230](https://openairdocs.org/ntsb/GAA17CA230.md): Cessna 180 · Manchester, CA · Accident · No injuries · Data collection · Final report · Apr 12, 2017 · N7945V · Substantial damage > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power. - [NTSB DCA17WA098](https://openairdocs.org/ntsb/DCA17WA098.md): Boeing 737 · Dublin, Ireland · Incident · No injuries · Foreign investigation · Apr 11, 2017 · EI-DAS · Minor damage > The Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's… - [NTSB CEN17WA160](https://openairdocs.org/ntsb/CEN17WA160.md): Cessna U206 · Seine-Maritime, France · Accident · Minor injuries · Foreign investigation · Apr 9, 2017 · F-HNCM · Substantial damage > On April 9, 2017, about 1430 universal coordinated time (UTC), a Cessna U206-F airplane, F-HNCM, flipped on it back during a forced landing near Seine-Maritime, France, following a loss of engine power. The pilot and four passengers received minor injuries… - [NTSB DCA17WA095](https://openairdocs.org/ntsb/DCA17WA095.md): Boeing 747 · Kong Kong, China · Incident · No injuries · Foreign investigation · Apr 7, 2017 · VH-OJU · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 747, which occurred on April 7, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of… - [NTSB ERA17FA145](https://openairdocs.org/ntsb/ERA17FA145.md): Pipistrel Virus SW · Micanopy, FL · Accident · 1 fatal · Field investigation · Final report · Apr 4, 2017 · N155CL · Destroyed > The pilot's intentional flight into an area of known convective thunderstorm activity, which resulted in an in-flight breakup. - [NTSB WPR17LA082](https://openairdocs.org/ntsb/WPR17LA082.md): OTT 601XL-B · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 2017 · N610TT · Substantial damage > A partial loss of engine power due to the reverse bending fatigue failure of the propeller hub bolts, which resulted from the bolts not fitting tightly into the propeller hub holes. Also causal was the pilot's decision to use improper bolts for this type of… - [NTSB CEN17WA143](https://openairdocs.org/ntsb/CEN17WA143.md): Aerospatiale AS355 · Snowdonia, United Kingdom · Accident · 5 fatal · Foreign investigation · Mar 29, 2017 · G-OHCP · Destroyed > On March 29, 2017, about 1500 coordinated universal time, an Aerospatiale AS355 F1 helicopter, G-OHCP, collided with Rhinog Fawr mountain in Snowdonia, Wales, United Kingdom. The pilot and four passengers were fatally injured.The accident investigation is… - [NTSB ERA17FA140](https://openairdocs.org/ntsb/ERA17FA140.md): Beech A36 · Dadeville, AL · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2017 · N8169Y · Destroyed > A loss of engine power for reasons that could not be determined due to postcrash thermal damage to the engine accessories and the airframe. Contributing to the accident was the pilot's failure to navigate to any of the available forced landing sites within… - [NTSB CEN17WA142](https://openairdocs.org/ntsb/CEN17WA142.md): Rutan Longez · Cloncoskoran, Ireland · Accident · 1 fatal · Foreign investigation · Mar 27, 2017 · EI-CPI · Destroyed > On March 27, 2017, at 1514 coordinated universal time, a Rutan Long-Ez, Irish registration EI-CPI, collided with terrain in Cloncoskoran, Waterford, Ireland, following a loss of engine power. The pilot was fatally injured and the airplane was destroyed. The… - [NTSB CEN17FA138](https://openairdocs.org/ntsb/CEN17FA138.md): Beech V35 · Union City, OK · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N2053Y · Destroyed > The pilot's improper recovery from a spin. - [NTSB ENG17WA019](https://openairdocs.org/ntsb/ENG17WA019.md): Saab 340 · Dubbo, Australia · Incident · No injuries · Foreign investigation · Mar 23, 2017 · VH-RXS · No damage > On March 23, 2017, a Saab 340B, registered in Australia as VH-RXS, had an in-flight shutdown of the right engine, a General Electric CT7-9B. During the climb, the crew detected abnormal turbine temperatures and vibrations from the right engine. The crew shut… - [NTSB DCA17WA137](https://openairdocs.org/ntsb/DCA17WA137.md): Boeing 767 · Amsterdam, Netherlands · Incident · No injuries · Foreign investigation · Mar 19, 2017 · G-POWD · No damage > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 767, which occurred on March 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under… - [NTSB CEN17RA131](https://openairdocs.org/ntsb/CEN17RA131.md): Sikorsky S92 · Blacksod Bay, Ireland · Accident · 4 fatal · Foreign investigation · Mar 14, 2017 · EI-ICR · Destroyed > On March 14, 2017, about 1719 universal coordinated time (UTC), a Sikorsky S-92 helicopter, Irish registration EI-ICR, crashed offshore near Blackrock Island West of Blacksod Bay, Ireland. There were 4 occupants. The pilot was fatally injured and 3… - [NTSB GAA17CA196](https://openairdocs.org/ntsb/GAA17CA196.md): Schweizer SGS126 · Bangor, PA · Accident · No injuries · Data collection · Final report · Mar 11, 2017 · N17933 · Substantial damage > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing. - [NTSB DCA17CA079](https://openairdocs.org/ntsb/DCA17CA079.md): Mcdonnell Douglas DC 9 83(MD-83) · Dallas-Fort Worth (DFW), TX · Accident · Serious injuries · Data collection · Final report · Mar 10, 2017 · N9615W · Minor damage > an inadvertent encounter with convective turbulence. - [NTSB GAA17CA179](https://openairdocs.org/ntsb/GAA17CA179.md): Burkhart Grob G 109B · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Mar 8, 2017 · N109FH · Substantial damage > The failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection. - [NTSB ANC17FA018](https://openairdocs.org/ntsb/ANC17FA018.md): Cessna R172K · Nome, AK · Accident · 1 fatal · Field investigation · Final report · Mar 6, 2017 · N736AS · Substantial damage > The pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel… - [NTSB ANC17RA019](https://openairdocs.org/ntsb/ANC17RA019.md): Bell 412 · Matsumoto, Japan · Accident · 9 fatal · Foreign investigation · Mar 5, 2017 · JA97NA · Substantial damage > import - [NTSB WPR17FA066](https://openairdocs.org/ntsb/WPR17FA066.md): Cessna T310Q · Riverside, CA · Accident · 4 fatal · Field investigation · Final report · Feb 28, 2017 · N1246G · Destroyed > The pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure… - [NTSB CEN17FA112](https://openairdocs.org/ntsb/CEN17FA112.md): Bell 407 · Chauvin, LA · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2017 · N1371 · Destroyed > The pilot's failure to maintain proper altitude resulting in a collision with water for reasons that could not be determined based on the available information. - [NTSB WPR17FA065](https://openairdocs.org/ntsb/WPR17FA065.md): Cessna 172 · Panguitch, UT · Accident · 3 fatal · Field investigation · Final report · Feb 26, 2017 · N3712F · Substantial damage > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making. - [NTSB WPR17LA067](https://openairdocs.org/ntsb/WPR17LA067.md): Guarino Vans · Marysville, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 2017 · N470LM · Substantial damage > A partial loss of engine power for reasons that could not be determined due to the fragmentation of the electrical system. - [NTSB ERA17LA116](https://openairdocs.org/ntsb/ERA17LA116.md): Robinson Helicopter R44 · Chatham, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 2017 · N44EK · Substantial damage > Maintenance personnel's improper installation and inspection of the crankshaft gear bolt during major overhaul, which resulted in the crankshaft gear disengaging from the accessory gears of the engine and a subsequent loss of power. - [NTSB GAA17CA178](https://openairdocs.org/ntsb/GAA17CA178.md): Schweizer 269C · Ormond beach, FL · Accident · No injuries · Data collection · Final report · Feb 21, 2017 · N614TA · Substantial damage > The separation of the throttle cable’s outer housing from the inner housing at the throttle linkage while at a high-power setting, which prevented the pilot from being able to control the throttle and execute a proper landing flare and resulted in a hard… - [NTSB GAA17CA161](https://openairdocs.org/ntsb/GAA17CA161.md): Piper PA 28R · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Feb 20, 2017 · N962WW · Substantial damage > An in-flight collision with a bird. - [NTSB CEN17WA213](https://openairdocs.org/ntsb/CEN17WA213.md): Piper PA28 · Petit Bourg, Guadeloupe · Accident · 1 fatal · Foreign investigation · Feb 20, 2017 · F-OGPJ · Destroyed > On February 20, 2017, about 1225 UTC, a Piper PA-28-161, French registration F-OGPJ, owned and operated by Aeroclub Les Ailes Guadeloupeenes, collided with a house while conducting low altitude cruise flight near Petit Bourg, Guadeloupe, French Antilles. The… - [NTSB CEN17LA110](https://openairdocs.org/ntsb/CEN17LA110.md): Aerostar Acft Corp Of Texas M20E · Clever, MO · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2017 · N6807V · Substantial damage > The failure of the engine No. 2 connecting rod bearing for reasons that could not be determined due to the extensive secondary engine damage. - [NTSB WPR17LA070](https://openairdocs.org/ntsb/WPR17LA070.md): Beech F33A · Pomona, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 16, 2017 · N222EN · Substantial damage > The 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 CEN17FA103](https://openairdocs.org/ntsb/CEN17FA103.md): Bell Helicopter Textron Canada 429 · Shreveport, LA · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2017 · N598PB · Substantial damage > The pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain. - [NTSB CEN17LA121](https://openairdocs.org/ntsb/CEN17LA121.md): Beech C90A · Rattan, OK · Accident · No injuries · Limited investigation · Final report · Feb 14, 2017 · N1551C · Substantial damage > The loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=63 ## 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=62 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.