# 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 70 of 718 · 35,883 cases ## Cases, newest first - [NTSB WPR16FA041](https://openairdocs.org/ntsb/WPR16FA041.md): Piper PA 32RT-300T · Bakersfield, CA · Accident · 5 fatal · Field investigation · Final report · Dec 19, 2015 · N36402 · Destroyed > The noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the… - [NTSB ERA16LA076](https://openairdocs.org/ntsb/ERA16LA076.md): Porrata Luis G Rans S 12XL · Guanica, PR · Accident · No injuries · Limited investigation · Final report · Dec 19, 2015 · N124LP · Substantial damage > The pilot/owner's failure to maintain the engine in accordance with manufacturer guidance, which resulted in the undetected corrosion of the power takeoff bearing, subsequent bearing failure, and a total loss of engine power. - [NTSB ERA16FA074](https://openairdocs.org/ntsb/ERA16FA074.md): Hinton Paul M RV 4 · Greenville, FL · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2015 · N77BP · Destroyed > The pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation… - [NTSB DCA16WA236](https://openairdocs.org/ntsb/DCA16WA236.md): Cessna 182 · Plettenberg, Western Cape Province, South Africa · Accident · No injuries · Foreign investigation · Dec 16, 2015 · ZS-SLS · Destroyed > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the… - [NTSB ERA16LA071](https://openairdocs.org/ntsb/ERA16LA071.md): Piper PA-32 · Brunswick, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 2015 · N8675N · Substantial damage > Maintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder. - [NTSB ERA16WA069](https://openairdocs.org/ntsb/ERA16WA069.md): Hawker Beech A36TC · Suvorovskaya, Russia · Accident · 4 fatal · Foreign investigation · Dec 13, 2015 · RA-2587G · Destroyed > On December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,… - [NTSB ERA16LA066](https://openairdocs.org/ntsb/ERA16LA066.md): Raytheon A36 · Fayetteville, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2015 · N3241N · Substantial damage > Maintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the… - [NTSB DCA16CA050](https://openairdocs.org/ntsb/DCA16CA050.md): Boeing 777 223 · Buenos Aires, Argentina · Accident · Serious injuries · Data collection · Final report · Dec 12, 2015 · N784AN · No damage > an inadvertant encounter with convective turbulence. - [NTSB WPR16FA037](https://openairdocs.org/ntsb/WPR16FA037.md): Bell 407 · McFarland, CA · Accident · 4 fatal · Field investigation · Final report · Dec 11, 2015 · N408FC · Destroyed > The pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time… - [NTSB ENG16WA006](https://openairdocs.org/ntsb/ENG16WA006.md): Airbus A319 · Bogota, Colombia · Incident · No injuries · Foreign investigation · Dec 11, 2015 · N593FL · No damage > On December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the… - [NTSB DCA16CA030](https://openairdocs.org/ntsb/DCA16CA030.md): Airbus A319 115 · Great Falls, MT · Accident · Serious injuries · Data collection · Final report · Dec 10, 2015 · N3014R · No damage > an encounter with turbulence during initial descent. - [NTSB CEN16WA065](https://openairdocs.org/ntsb/CEN16WA065.md): Enstrom 280 · Salinas Victoria, Mexico · Accident · No injuries · Foreign investigation · Dec 10, 2015 · XB-GRG · Substantial damage > On December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.… - [NTSB WPR16IA044](https://openairdocs.org/ntsb/WPR16IA044.md): Cessna LC41-550FG · Seal Beach, CA · Incident · No injuries · Incident investigation · Final report · Dec 8, 2015 · N932AC · Minor damage > Improper maintenance performed on the left magneto which led to a loss of engine power. Contributing to the incident was the pilot's failure to check the magnetos in flight in compliance with manufacturers guidance regarding rough running engine. The pilot's… - [NTSB DCA16WA031](https://openairdocs.org/ntsb/DCA16WA031.md): Eclipse 500 · Swellendam, South Africa · Accident · 1 fatal · Foreign investigation · Dec 7, 2015 · ZS-DKS · Destroyed > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation… - [NTSB DCA16CA026](https://openairdocs.org/ntsb/DCA16CA026.md): Boeing 737 7H4 · St Louis, MO · Accident · Serious injuries · Data collection · Final report · Nov 29, 2015 · N467WN · No damage > an inadvertent encounter with clear air turbulence. - [NTSB GAA16CA072](https://openairdocs.org/ntsb/GAA16CA072.md): Skaggs Ronnie Lynn Rans S6S · Oldtown, MD · Accident · No injuries · Data collection · Final report · Nov 27, 2015 · N531VS · Substantial damage > The pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain. - [NTSB WPR16LA032](https://openairdocs.org/ntsb/WPR16LA032.md): Hughes 369D · Carlisle, WA · Accident · No injuries · Limited investigation · Final report · Nov 24, 2015 · N50713 · Substantial damage > A total loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge. - [NTSB DCA16CA023](https://openairdocs.org/ntsb/DCA16CA023.md): Airbus Industrie A319 112 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · Nov 23, 2015 · N725UW · No damage > an inadvertent encounter with clear air turbulence. - [NTSB CEN16WA048](https://openairdocs.org/ntsb/CEN16WA048.md): Bell 407 · Justo Romero, Nicaragua · Accident · No injuries · Foreign investigation · Nov 21, 2015 · HR-AWI · Substantial damage > On November 21, 2015, at 1000 central standard time (cst), a Bell model 407 helicopter, Honduran registration HR-AWI, serial number 53978, sustained substantial damage during a forced landing following a total loss of engine power near Justo Romero,… - [NTSB CEN16LA047](https://openairdocs.org/ntsb/CEN16LA047.md): Eurocopter EC120B · Goshen, IN · Accident · No injuries · Limited investigation · Final report · Nov 16, 2015 · N88HA · Substantial damage > The failure of the Thomas coupling at the interface with the main gear box tail rotor output shaft, which resulted in the helicopter's loss of tail rotor control. - [NTSB CEN16FA042](https://openairdocs.org/ntsb/CEN16FA042.md): Cessna 182G · Sandia Park, NM · Accident · 3 fatal · Field investigation · Final report · Nov 16, 2015 · N2440R · Destroyed > The pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control. - [NTSB CEN16WA046](https://openairdocs.org/ntsb/CEN16WA046.md): Cessna 172N · Gorliz, Spain · Accident · Serious injuries · Foreign investigation · Nov 14, 2015 · EC-HKH · Substantial damage > On November 14, 2015, at 1157 UTC, a Cessna 172, Spanish registration EC-HKH, collided with the water in the Astondo Bay off the coast of Gorliz, Spain, following a loss of engine power. The pilot and one passenger received minor injuries and a second… - [NTSB ERA16LA040](https://openairdocs.org/ntsb/ERA16LA040.md): Cirrus Design SR22 · Jefferson, NC · Accident · No injuries · Limited investigation · Final report · Nov 13, 2015 · N334CM · Substantial damage > A total loss of engine power for reasons that could not be determined during a postaccident test run of the engine. - [NTSB CEN16FA037](https://openairdocs.org/ntsb/CEN16FA037.md): Cessna 182Q · Richmond, MO · Accident · 1 fatal · Field investigation · Final report · Nov 11, 2015 · N96381 · Substantial damage > The airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did… - [NTSB ERA16WA037](https://openairdocs.org/ntsb/ERA16WA037.md): Cessna 650 · Guarda-Mor, Brazil · Accident · 4 fatal · Foreign investigation · Nov 10, 2015 · PT-WQH · Destroyed > On November 10, 2015, at 2030 Universal Coordinated Time (UTC), a Cessna 650 Citation VII, Brazilian registration PT-WQH, operated by a private owner, was destroyed following an in-flight loss of control and collision with terrain near Guarda-mor… - [NTSB DCA16CA021](https://openairdocs.org/ntsb/DCA16CA021.md): Boeing 787 · Beaumont, TX · Accident · Serious injuries · Data collection · Final report · Nov 7, 2015 · N27958 · No damage > An inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant. - [NTSB GAA16CA078](https://openairdocs.org/ntsb/GAA16CA078.md): Cessna 525 · Monroeville, AL · Accident · No injuries · Data collection · Final report · Nov 6, 2015 · N525DY · Substantial damage > An inadvertent collision with a bird during takeoff enroute climb, which resulted in substantial damage to the right wing. - [NTSB ERA16FA033](https://openairdocs.org/ntsb/ERA16FA033.md): Zenith CH701 · Okeechobee, FL · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2015 · N56553 · Destroyed > An in-flight structural failure due to a severely corroded wing strut, which resulted in a loss of airplane control. - [NTSB ERA16FA032](https://openairdocs.org/ntsb/ERA16FA032.md): Piper PA 28-180 · Cornelia, GA · Accident · 3 fatal · Field investigation · Final report · Nov 5, 2015 · N57WV · Destroyed > The pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control. - [NTSB ANC16LA005](https://openairdocs.org/ntsb/ANC16LA005.md): Cessna 180 · Haines, AK · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 2015 · N4611U · Substantial damage > A loss of engine power due to fuel exhaustion for reasons that could not be determined based on available evidence and the pilot’s decision to continue the flight after realizing the remaining fuel quantity was near 0. - [NTSB CEN16LA026](https://openairdocs.org/ntsb/CEN16LA026.md): Cirrus Design SR22T · Fayetteville, AR · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2015 · N857SW · Substantial damage > The fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power. - [NTSB DCA16WA015](https://openairdocs.org/ntsb/DCA16WA015.md): Airbus A321 · Sinai Peninsula, Egypt · Accident · 224 fatal · Foreign investigation · Oct 31, 2015 · EI-ETJ · Destroyed > The Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's… - [NTSB ERA16LA030](https://openairdocs.org/ntsb/ERA16LA030.md): Hughes 369D · Marion, SC · Accident · No injuries · Limited investigation · Final report · Oct 30, 2015 · N920JP · Substantial damage > A momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control. - [NTSB ANC16WA002](https://openairdocs.org/ntsb/ANC16WA002.md): Bell 206B · Asquinth, Canada · Accident · 1 fatal · Foreign investigation · Oct 28, 2015 · C-GIFY > On October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is… - [NTSB ERA16LA028](https://openairdocs.org/ntsb/ERA16LA028.md): Schumacher Lancair Super ES · Pascagoula, MS · Accident · 3 fatal · Limited investigation · Final report · Oct 26, 2015 · N817PR · Destroyed > The pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather. - [NTSB ERA16LA027](https://openairdocs.org/ntsb/ERA16LA027.md): Cessna 150M · Key Biscayne, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 2015 · N171RD · Substantial damage > The fatigue failure of the No. 1 cylinder intake valve, which resulted in the partial loss of engine power. - [NTSB DCA16CA010](https://openairdocs.org/ntsb/DCA16CA010.md): Boeing 737-924ER · Plevna, KS · Accident · Serious injuries · Data collection · Final report · Oct 24, 2015 · N69838 · No damage > An inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant. - [NTSB ERA16LA022](https://openairdocs.org/ntsb/ERA16LA022.md): Piper PA-32-260 · Bluemont, VA · Accident · No injuries · Limited investigation · Final report · Oct 23, 2015 · N43249 · Substantial damage > A total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information. - [NTSB CEN16WA020](https://openairdocs.org/ntsb/CEN16WA020.md): Learjet 31 · La Tinaja, Mexico · Accident · 4 fatal · Foreign investigation · Oct 22, 2015 · XB-GYB · Destroyed > The Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the… - [NTSB ERA16LA018](https://openairdocs.org/ntsb/ERA16LA018.md): Cessna 172 · Campobello, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2015 · N6636A · Substantial damage > The pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination. - [NTSB WPR16FA014](https://openairdocs.org/ntsb/WPR16FA014.md): Piper PA 28R-180 · Morongo Valley, CA · Accident · 2 fatal · Field investigation · Final report · Oct 17, 2015 · N4972J · Destroyed > The non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and… - [NTSB WPR16FA013](https://openairdocs.org/ntsb/WPR16FA013.md): Aviat A-1C-200 · Swan Valley, ID · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2015 · N280TB · Substantial damage > The pilot's failure to maintain airspeed while maneuvering in high density altitude conditions over mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. - [NTSB ERA16LA016](https://openairdocs.org/ntsb/ERA16LA016.md): Titan Tornado · Mitchells, VA · Accident · No injuries · Class 3 · Limited · Final report · Oct 15, 2015 · N4070F · Substantial damage > A total loss of engine power due to fatigue cracking and separation of the No. 3 cylinder exhaust valve stem. - [NTSB GAA16CA016](https://openairdocs.org/ntsb/GAA16CA016.md): Central Missouri State Univ HP 14 · Jackson, NH · Accident · No injuries · Data collection · Final report · Oct 14, 2015 · N102MW · Substantial damage > The glider pilot's decision to descend into a broken to overcast cloud layer, which resulted in encountering instrument meteorological conditions and the pilot parachuting from the glider. Contributing to the accident was the pilot's lack of planning for an… - [NTSB WPR16LA008](https://openairdocs.org/ntsb/WPR16LA008.md): Cessna T210K · Boise, ID · Accident · No injuries · Limited investigation · Final report · Oct 13, 2015 · N8273M · Substantial damage > The pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which… - [NTSB CEN16LA018](https://openairdocs.org/ntsb/CEN16LA018.md): Diamond DA20-C1 · Waskom, TX · Accident · No injuries · Limited investigation · Final report · Oct 12, 2015 · N165DC · Substantial damage > The pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion. - [NTSB WPR16FA007](https://openairdocs.org/ntsb/WPR16FA007.md): Beech G35 · South Lake Tahoe, CA · Accident · 2 fatal · Field investigation · Final report · Oct 11, 2015 · N4485D · Destroyed > The pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without… - [NTSB ERA16LA009](https://openairdocs.org/ntsb/ERA16LA009.md): Cessna 172N · Miami Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 11, 2015 · N733VB · Substantial damage > A total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean after the ditching. - [NTSB ERA16FA006](https://openairdocs.org/ntsb/ERA16FA006.md): Columbia Aircraft Mfg LC41 550FG · Erwin, TN · Accident · 2 fatal · Field investigation · Final report · Oct 9, 2015 · N1058S · Destroyed > The pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control. - [NTSB DCA16CA008](https://openairdocs.org/ntsb/DCA16CA008.md): Boeing 737 3H4 · Pound Ridge, NY · Accident · Serious injuries · Data collection · Final report · Oct 9, 2015 · N383SW · No damage > hot water spilled from a cup onto the flight attendant's arm resulting in a 2nd degree burn. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=71 ## 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=70 --- 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.