# 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 57 of 718 · 35,883 cases ## Cases, newest first - [NTSB WPR18WA123](https://openairdocs.org/ntsb/WPR18WA123.md): Cessna T210N · Oudtshoorn, South Africa · Accident · 2 fatal · Foreign investigation · Feb 25, 2018 · ZS-KOM · Destroyed - [NTSB GAA18CA140](https://openairdocs.org/ntsb/GAA18CA140.md): Robinson Helicopter R44 · Woodland, CA · Accident · Minor injuries · Data collection · Final report · Feb 24, 2018 · N630ML · Substantial damage > The pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application. - [NTSB DCA18CA102](https://openairdocs.org/ntsb/DCA18CA102.md): Airbus A330 323 · Minneapolis, MN · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 24, 2018 · N817NW · No damage > an inadvertent encounter with clear air turbulence. - [NTSB CEN18FA108](https://openairdocs.org/ntsb/CEN18FA108.md): Beech 58 · Ulysses, KS · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2018 · N678DD · Destroyed > An inflight loss of control and collision with terrain for reasons that could not be determined. - [NTSB CEN18FA107](https://openairdocs.org/ntsb/CEN18FA107.md): Cessna 441 · Rossville, IN · Accident · 3 fatal · Field investigation · Final report · Feb 23, 2018 · N771XW · Destroyed > An in-flight loss of control for reasons that could not be determined based on the available evidence. - [NTSB WPR18FA095](https://openairdocs.org/ntsb/WPR18FA095.md): Piper PA32R · Monticello, UT · Accident · 4 fatal · Field investigation · Final report · Feb 22, 2018 · C-GYGY · Destroyed > The noninstrument-rated pilot's continued flight into a region of deteriorating ceiling and visibility conditions, which resulted in controlled flight into terrain event. - [NTSB WPR18LA092](https://openairdocs.org/ntsb/WPR18LA092.md): Cessna 172 · Obyan, Sark · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 19, 2018 · N7328F · Substantial damage > The pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch. - [NTSB WPR18FA091](https://openairdocs.org/ntsb/WPR18FA091.md): Piper PA34 · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2018 · N14GQ · Destroyed > The pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine. - [NTSB DCA18WA136](https://openairdocs.org/ntsb/DCA18WA136.md): Boeing 737 · Ballina/Byron Gateway Aerodome, Australia · Incident · No injuries · Foreign investigation · Feb 18, 2018 · unknown · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's… - [NTSB DCA18WA135](https://openairdocs.org/ntsb/DCA18WA135.md): Airbus A320 · abeam Cooma Aerodome, Australia · Incident · No injuries · Foreign investigation · Feb 18, 2018 · unknown · No damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on February 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's… - [NTSB DCA18IA092](https://openairdocs.org/ntsb/DCA18IA092.md): Boeing 777 222 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Feb 13, 2018 · N773UA · Minor damage > the fracture of a fan blade due to P&W's continued classification of the TAI inspection process as a new and emerging technology that permitted them to continue accomplishing the inspection without having to develop a formal, defined initial and recurrent… - [NTSB CEN18WA104](https://openairdocs.org/ntsb/CEN18WA104.md): Beech F33 · Bolderberg, Belgium · Accident · 2 fatal · Foreign investigation · Feb 12, 2018 · OO-JKM · Destroyed - [NTSB WPR18FA088](https://openairdocs.org/ntsb/WPR18FA088.md): Hastings Thomas G Cirrus VK 30 · Agua Dulce, CA · Accident · 4 fatal · Field investigation · Final report · Feb 11, 2018 · N52TH · Substantial damage > The driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of… - [NTSB CEN18LA099](https://openairdocs.org/ntsb/CEN18LA099.md): Beech 35 · Batesville, AR · Accident · No injuries · Limited investigation · Final report · Feb 8, 2018 · N4654D · Substantial damage > An in-flight control system flutter encounter during a turbulence encounter; the reason for the flutter could not be determined. - [NTSB CEN18LA097](https://openairdocs.org/ntsb/CEN18LA097.md): Piper PA 24-260 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Feb 8, 2018 · N9360P · Substantial damage > The pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the… - [NTSB CEN18LA093](https://openairdocs.org/ntsb/CEN18LA093.md): Piper PA 34-220T · Patterson, LA · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2018 · N9148B · Substantial damage > The pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion. - [NTSB ENG18RA015](https://openairdocs.org/ntsb/ENG18RA015.md): Boeing 757 · Auckland, New Zealand · Incident · No injuries · Foreign investigation · Feb 5, 2018 · VH-TCA · No damage > The Australian Transport Safety Bureau has notified the NTSB of an incident involving a Boeing 757-236, which occurred on February 5,2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau investigation… - [NTSB DCA18WA122](https://openairdocs.org/ntsb/DCA18WA122.md): Boeing 737 · Indonesia · Incident · No injuries · Foreign investigation · Feb 5, 2018 · unknown · No damage > The government of Indonesia has notified the NTSB of an incidentt involving a BOEING 737-800 that occurred on February 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions… - [NTSB GAA18CA124](https://openairdocs.org/ntsb/GAA18CA124.md): Cessna 150 · El Dorado, KS · Accident · No injuries · Data collection · Final report · Feb 4, 2018 · N61024 · Substantial damage > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport landing and nose-over. - [NTSB CEN18WA134](https://openairdocs.org/ntsb/CEN18WA134.md): Bell 206 · Uetersen, Germany · Accident · Minor injuries · Foreign investigation · Feb 4, 2018 · D-HHNC · Substantial damage > On April 2, 2018, at 0919 coordinated universal time, a Bell Helicopter 206, D-HHNC, experienced a loss of engine power while airborne.The accident investigation is under the jurisdiction and control of the German government. This report is for information… - [NTSB CEN18WA098](https://openairdocs.org/ntsb/CEN18WA098.md): Robinson R44 · St Joachim de Courval, Canada · Accident · 3 fatal · Foreign investigation · Feb 2, 2018 · C-GYMG · Destroyed > On February 2, 2018, about 0145 UTC, a Robinson R-44 helicopter, Canadian registry C-GYMG, owned and operated by a private operator, impacted in a field at St-Joachim-de-Courval, Quebec, Canada. A post impact fire ensued. The pilot and two passengers on board… - [NTSB WPR18FA077](https://openairdocs.org/ntsb/WPR18FA077.md): Robinson Helicopter R44 · Newport Beach, CA · Accident · 3 fatal · Field investigation · Final report · Jan 30, 2018 · N7530R · Destroyed > The pilot's failure to perform weight and balance calculations before departing on the flight, which resulted in his operation of the helicopter outside of its published weight and balance limitations and a subsequent loss of control shortly after takeoff. - [NTSB ANC18FA022](https://openairdocs.org/ntsb/ANC18FA022.md): Beech 35 A33 · Helenwood, TN · Accident · 1 fatal · Field investigation · Final report · Jan 30, 2018 · N9378Y · Substantial damage > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow the air start checklist. - [NTSB WPR18FA075](https://openairdocs.org/ntsb/WPR18FA075.md): Cessna 152 · Concord, CA · Accident · 1 fatal · Field investigation · Final report · Jan 29, 2018 · N93316 · Substantial damage > A loss of control for reasons that could not be determined based on the available information. - [NTSB ERA18LA074](https://openairdocs.org/ntsb/ERA18LA074.md): Cessna 172 · Babylon, NY · Accident · No injuries · Limited investigation · Final report · Jan 29, 2018 · N294ME · Substantial damage > The partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA18LA072](https://openairdocs.org/ntsb/ERA18LA072.md): Cessna P210N · Farmington, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 29, 2018 · N34VF · Substantial damage > A total loss of engine power due to fatigue failure of the crankshaft drive gear teeth. - [NTSB ERA18TA076](https://openairdocs.org/ntsb/ERA18TA076.md): Vertical Aviation Technologies 260L Hummingbird · Harrisville, NY · Accident · No injuries · Final report · Jan 28, 2018 · N4045 · Substantial damage > The failure of an electric fuel pump, which resulted in fuel starvation and a total loss of engine power during cruise flight. - [NTSB ENG18WA010](https://openairdocs.org/ntsb/ENG18WA010.md): Boeing 737 · Lima, Peru · Incident · No injuries · Foreign investigation · Jan 25, 2018 · OB-2140P · No damage > On January 25, 2018, a Peruvian Air Lines Boeing 737-530, registered in Peru as OB-2140P, had an uncommanded shutdown of the No. 2 engine, a CFMI CFM56-3B1, after leveling off at FL370. The flight crew declared an emergency and diverted back to Lima, Peru.… - [NTSB CEN18LA084](https://openairdocs.org/ntsb/CEN18LA084.md): Beech A36 · Abilene, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 22, 2018 · N3600A · Substantial damage > Maintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight. - [NTSB WPR18LA071](https://openairdocs.org/ntsb/WPR18LA071.md): Six Chuter Spirit · Marana, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 19, 2018 · UNREG · 2 aircraft · Substantial damage > The noncertificated pilots’ failure to maintain an adequate visual lookout, which resulted in a midair collision. - [NTSB CEN18WA081](https://openairdocs.org/ntsb/CEN18WA081.md): Zodiac 601XL · Castellon, Spain · Accident · 1 fatal · Foreign investigation · Jan 19, 2018 · EC-XKM · Destroyed > On January 19, 2018, about 0930 UTC, a Zodiac 601XL, Spanish registry EC-XKM, owned and operated by a private individual, impacted mountainous terrain in the municipality of La Pobla de Benifassa, Castellon, Spain. A postimpact fire ensued. The pilot was… - [NTSB CEN18LA086](https://openairdocs.org/ntsb/CEN18LA086.md): Swearingen SA227 TT · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jan 19, 2018 · N6UP · Substantial damage > The failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines. - [NTSB ENG18WA011](https://openairdocs.org/ntsb/ENG18WA011.md): Airbus A330 · Alice Springs, Australia · Incident · No injuries · Foreign investigation · Jan 18, 2018 · 9M-MTM · No damage > On January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was… - [NTSB CEN18FA078](https://openairdocs.org/ntsb/CEN18FA078.md): Bell UH-1H · Raton, NM · Accident · 5 fatal · Field investigation · Final report · Jan 18, 2018 · N658H · Destroyed > The pilot's failure to maintain adequate altitude above mountainous terrain during cruise flight in dark night conditions, which resulted in controlled flight into terrain. - [NTSB WPR18LA069](https://openairdocs.org/ntsb/WPR18LA069.md): Mooney M20E · Skyforest, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 2018 · N5562Q · Substantial damage > The pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an… - [NTSB ERA18WA063](https://openairdocs.org/ntsb/ERA18WA063.md): Piper PA-23-250 · Nicholls Town, Bahamas · Accident · 6 fatal · Foreign investigation · Jan 17, 2018 · N62769 · Destroyed > The government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the… - [NTSB CEN18LA077](https://openairdocs.org/ntsb/CEN18LA077.md): Bryk Steven L Velocity XL RG · Santa Fe, NM · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 16, 2018 · N787SB · Substantial damage > The airplane’s inadvertent encounter with unforecasted icing conditions during cruise flight, which resulted in the accumulation of airframe icing, the airplane’s inability to maintain altitude, and a subsequent forced landing on rough terrain. - [NTSB CEN18LA075](https://openairdocs.org/ntsb/CEN18LA075.md): Piper PA 28-236 · Tishomingo, OK · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 2018 · N4345K · Substantial damage > The pilot’s inadequate preflight fuel planning and in-flight fuel monitoring and his decision to take off with an unverified amount of fuel, which resulted in fuel exhaustion and a subsequent impact with trees during an attempted forced landing. - [NTSB WPR18FA073](https://openairdocs.org/ntsb/WPR18FA073.md): Piper PA 23-250 · Elko, NV · Accident · 1 fatal · Field investigation · Final report · Jan 12, 2018 · N54857 · Destroyed > The pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain. - [NTSB CEN18CA072](https://openairdocs.org/ntsb/CEN18CA072.md): Bell Helicopter Textron Canada 407 · Norfolk, NE · Accident · No injuries · Data collection · Final report · Jan 5, 2018 · N214AM · Substantial damage > Maintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight. - [NTSB CEN18LA068](https://openairdocs.org/ntsb/CEN18LA068.md): Barnes Steven D Steve Barnes RV 4 · Montrose, CO · Accident · No injuries · Limited investigation · Final report · Jan 4, 2018 · N83SB · Substantial damage > The total loss of engine power for reasons that could not be determined because a postaccident examination of the engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation. - [NTSB CEN18FA400](https://openairdocs.org/ntsb/CEN18FA400.md): Cirrus Design SR22T · Gulf of Mexico (Gulf of Mexico) · Accident · 1 fatal · Class 3 · Field · Final report · Jan 3, 2018 · N325JK · Destroyed > The pilot's incapacitation resulted in impact with the Gulf of Mexico. The reason the hypoxia recognition system did not descend the airplane as designed could not be determined as the airplane was not located. - [NTSB GAA18CA095](https://openairdocs.org/ntsb/GAA18CA095.md): Cessna 150 · Nampa, ID · Accident · No injuries · Data collection · Final report · Jan 2, 2018 · N3229V · Substantial damage > The pilot’s geographic disoriention during a night flight, which resulted in an off-airport landing. - [NTSB WPR18LA056](https://openairdocs.org/ntsb/WPR18LA056.md): Cessna 150L · Perris, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 25, 2017 · N6627G · Substantial damage > The presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor. - [NTSB ERA18FA056](https://openairdocs.org/ntsb/ERA18FA056.md): Beech G35 · Cross City, FL · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N354WD · Destroyed > The pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control. - [NTSB DCA18CA049](https://openairdocs.org/ntsb/DCA18CA049.md): Embraer S A ERJ170-200LR · Saint Louis, MO · Accident · Serious injuries · Data collection · Final report · Dec 18, 2017 · N128SY · No damage > the abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle. - [NTSB CEN18FA054](https://openairdocs.org/ntsb/CEN18FA054.md): Piper PA28 · Reeds Spring, MO · Accident · 2 fatal · Field investigation · Final report · Dec 18, 2017 · N6433J · Destroyed > The noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain. - [NTSB CEN18FA053](https://openairdocs.org/ntsb/CEN18FA053.md): Cessna T210M · Oldenburg, IN · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2017 · N761YZ · Destroyed > A total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational… - [NTSB ERA18LA055](https://openairdocs.org/ntsb/ERA18LA055.md): Cessna 182 · Burlington, NC · Accident · No injuries · Limited investigation · Final report · Dec 16, 2017 · N199RN · 2 aircraft · Substantial damage > The pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright. - [NTSB ERA18LA050](https://openairdocs.org/ntsb/ERA18LA050.md): Cessna 152 · Everglades City, FL · Accident · No injuries · Limited investigation · Final report · Dec 16, 2017 · N95550 · Substantial damage > The loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=58 ## 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=57 --- 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.