# NTSB investigations: Approach NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 46 of 420 · 20,992 cases ## Cases, newest first - [NTSB ANC13FA084](https://openairdocs.org/ntsb/ANC13FA084.md): Cessna 150L · Anchorage, AK · Accident · 2 fatal · Field investigation · Final report · Aug 24, 2013 · N18699 · Substantial damage > A loss of engine power due to fuel starvation as a result of a low fuel state and a nose-high attitude during a go-around, which unported the fuel tank feed line, and the pilot's decision to make a low-altitude turn back to the airport, which resulted in an… - [NTSB CEN14WA225](https://openairdocs.org/ntsb/CEN14WA225.md): Airbus Helicopters 332L2 · Shetland Islands, United Kingdom · Accident · 4 fatal · Foreign investigation · Aug 23, 2013 · G-WNSB · Substantial damage > On August 23, 2013, about 1717 UTC, an Airbus Helicopters AS332 L2, G-WNSB (s/n 2582) ditched into the North Sea near the Shetland Islands. The helicopter was destroyed and four passengers were fatally injured. This investigation is under the jurisdiction and… - [NTSB DCA13WA173](https://openairdocs.org/ntsb/DCA13WA173.md): Boeing 737 · Las Palmas, Spain · Incident · No injuries · Foreign investigation · Aug 22, 2013 · G-FDZG · No damage > The Spainish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC). has notified the NTSB of an accident involving a BOEING 737 that occurred on August 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the… - [NTSB CEN13CA498](https://openairdocs.org/ntsb/CEN13CA498.md): Cessna 172S · Indianapolis, IN · Accident · No injuries · Data collection · Final report · Aug 21, 2013 · N45EF · Substantial damage > The pilot's inadequate monitoring on the airplane's airspeed during the go-around, resulting in a stall. - [NTSB CEN13CA494](https://openairdocs.org/ntsb/CEN13CA494.md): Globe GC-1B · Santa Teresa, NM · Accident · No injuries · Data collection · Final report · Aug 18, 2013 · N7BR · Substantial damage > The pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devil - [NTSB ANC13WA103](https://openairdocs.org/ntsb/ANC13WA103.md): Beech A36 - TC · Ami, Japan · Accident · Serious injuries · Foreign investigation · Aug 18, 2013 · JA4152 · Substantial damage > On August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor… - [NTSB WPR13CA373](https://openairdocs.org/ntsb/WPR13CA373.md): Remos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NV · Accident · Minor injuries · Data collection · Final report · Aug 15, 2013 · N110GX · Substantial damage > The pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing. - [NTSB ANC13CA080](https://openairdocs.org/ntsb/ANC13CA080.md): Cessna U206 · Sleetmute, AK · Accident · Minor injuries · Data collection · Final report · Aug 15, 2013 · N2141F · Substantial damage > The total loss of engine power due to fuel starvation and the pilot's inadequate preflight inspection. - [NTSB DCA13MA133](https://openairdocs.org/ntsb/DCA13MA133.md): Airbus A300 - F4 622R · Birmingham, AL · Accident · 2 fatal · Class 1 · Major · Final report · Aug 14, 2013 · N155UP · Destroyed > the flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the… - [NTSB WPR13FA368](https://openairdocs.org/ntsb/WPR13FA368.md): Beech E35 · West Yellowstone, MT · Accident · 1 fatal · Field investigation · Final report · Aug 12, 2013 · N3226C · Substantial damage > The pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's… - [NTSB CEN13CA510](https://openairdocs.org/ntsb/CEN13CA510.md): Ercoupe 415-C · Mackinac Island, MI · Accident · No injuries · Data collection · Final report · Aug 10, 2013 · N99094 · Substantial damage > The pilot's failure to maintain aircraft control while on final approach. - [NTSB ERA13FA358](https://openairdocs.org/ntsb/ERA13FA358.md): Rockwell International 690B · East Haven, CT · Accident · 4 fatal · Field investigation · Final report · Aug 9, 2013 · N13622 · Destroyed > The pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent. - [NTSB CEN13WA480](https://openairdocs.org/ntsb/CEN13WA480.md): Socata TBM-700 · Vertaizon, France · Accident · 3 fatal · Foreign investigation · Aug 8, 2013 · N850GC · Substantial damage - [NTSB ERA13WA387](https://openairdocs.org/ntsb/ERA13WA387.md): Embraer 711ST · Paragominas, Brazil · Accident · 1 fatal · Foreign investigation · Aug 4, 2013 · PT-RHI · Substantial damage > On August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de… - [NTSB ERA13WA376](https://openairdocs.org/ntsb/ERA13WA376.md): Beech 58 · Jundiai Municipality, Brazil · Accident · 4 fatal · Foreign investigation · Aug 3, 2013 · PT-LKG · Destroyed > On August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The… - [NTSB ERA13FA348](https://openairdocs.org/ntsb/ERA13FA348.md): Beech D55 · Conway, SC · Accident · 3 fatal · Field investigation · Final report · Aug 3, 2013 · N7641N · Destroyed > The pilot's loss of airplane control, which resulted from his failure to follow the loss of single engine power checklist procedures after a total loss of right engine power due to fuel starvation. Contributing to the accident was the pilot's improper… - [NTSB ERA13CA353](https://openairdocs.org/ntsb/ERA13CA353.md): Piper/Cub Crafters PA-18-150 · Eagle Bay, NY · Accident · Minor injuries · Data collection · Final report · Aug 2, 2013 · N555AX · Substantial damage > The pilot's failure to set the engine throttle to full power during a go-around. - [NTSB ERA13CA355](https://openairdocs.org/ntsb/ERA13CA355.md): Beech 58 · New Bedford, MA · Accident · No injuries · Data collection · Final report · Jul 31, 2013 · N58DL · Substantial damage > The pilot's improper decision to land in the displaced threshold, resulting in a collision with the approach lighting system. - [NTSB CEN13FA446](https://openairdocs.org/ntsb/CEN13FA446.md): Campbell Earl S JR RV-6A · Knox, IN · Accident · 1 fatal · Field investigation · Final report · Jul 29, 2013 · N914ES · Destroyed > The incapacitation of the pilot due to a cardiovascular event that prevented him from maintaining control of the airplane during the landing approach. - [NTSB WPR13CA342](https://openairdocs.org/ntsb/WPR13CA342.md): Mcdonnell Douglas Helicopter 369E · Hilo, HI · Accident · No injuries · Data collection · Final report · Jul 25, 2013 · N500PH · Substantial damage > A loss of engine power due to the pilot's improper planning and mismanagement of the fuel supply, which resulted in fuel exhaustion. - [NTSB CEN13LA433](https://openairdocs.org/ntsb/CEN13LA433.md): Clayton Gerald H Glastar GS-1 · Columbus, IN · Accident · 1 fatal · Limited investigation · Final report · Jul 25, 2013 · N513GC · Destroyed > Slippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust. - [NTSB CEN13LA431](https://openairdocs.org/ntsb/CEN13LA431.md): Schweizer 269C · Gary, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 2013 · N7507A · Substantial damage > The failure of the engine connecting rod due to fatigue. - [NTSB WPR13LA336](https://openairdocs.org/ntsb/WPR13LA336.md): Wester/Steiger Glastar · Independence, OR · Accident · No injuries · Limited investigation · Final report · Jul 22, 2013 · N130GS · Substantial damage > The total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. - [NTSB WPR13CA333](https://openairdocs.org/ntsb/WPR13CA333.md): Schweizer SGS 2-33A · Hood River, OR · Accident · Serious injuries · Data collection · Final report · Jul 20, 2013 · N2052T · Substantial damage > The glider encountered atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off airport landing on rough terrain. - [NTSB ERA13LA331](https://openairdocs.org/ntsb/ERA13LA331.md): Beech A36 · Tupelo, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 2013 · N117HB · Substantial damage > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB DCA13WA129](https://openairdocs.org/ntsb/DCA13WA129.md): Cirrus SR20 · Randburg, South Africa · Accident · No injuries · Foreign investigation · Jul 18, 2013 · ZS-CAP · Destroyed > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the… - [NTSB CEN13FA416](https://openairdocs.org/ntsb/CEN13FA416.md): Taylorcraft BC12-65 · Flushing, MI · Accident · 2 fatal · Field investigation · Final report · Jul 17, 2013 · N36466 · Destroyed > The student pilot’s failure to maintain airspeed during the landing approach, which led to a stall/spin, and the flight instructor’s failure to monitor the approach and provide remedial action before the stall. - [NTSB ERA13WA332](https://openairdocs.org/ntsb/ERA13WA332.md): Cessna 172N · Buenos Aires, Argentina · Accident · 2 fatal · Foreign investigation · Jul 16, 2013 · LV-BPP · Substantial damage > On July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor… - [NTSB ERA13WA322](https://openairdocs.org/ntsb/ERA13WA322.md): Cessna 208B · Mathews Ridge, Guyana · Accident · Serious injuries · Foreign investigation · Jul 15, 2013 · 8R-AMS · Substantial damage > On July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,… - [NTSB WPR13CA326](https://openairdocs.org/ntsb/WPR13CA326.md): Cessna A185F · Cascade, ID · Accident · No injuries · Data collection · Final report · Jul 14, 2013 · N185BW · Substantial damage > The pilot’s failure to maintain clearance from trees during final approach due to the sun glare that obscured the pilot's vision. - [NTSB CEN13LA409](https://openairdocs.org/ntsb/CEN13LA409.md): Flight Design Ctsw · Taos, NM · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 2013 · N424CT · Substantial damage > The airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control. - [NTSB WPR13LA314](https://openairdocs.org/ntsb/WPR13LA314.md): Luy Wayman Lockwood Aircam · Groveland, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 2013 · N94C · Substantial damage > The pilot’s inadequate compensation for a crosswind and failure to maintain airplane control during a go-around. - [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a… - [NTSB OPS13IA071](https://openairdocs.org/ntsb/OPS13IA071.md): Gulfstream GIV - Undesignat · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Jul 5, 2013 · N0 · No damage > The Federal Aviation Administration's (FAA) inadequate procedures, which did not require specific separation between aircraft operating on nonintersecting runways where flightpaths may intersect and led to an airborne conflict between two aircraft.… - [NTSB CEN13LA381](https://openairdocs.org/ntsb/CEN13LA381.md): Beech C23 · Hot Springs, AR · Accident · No injuries · Limited investigation · Final report · Jun 30, 2013 · N3KT · Substantial damage > The pilots’ failure to monitor and manage fuel consumption during cruise flight, which resulted in fuel exhaustion and a subsequent forced landing. - [NTSB WPR13FA296](https://openairdocs.org/ntsb/WPR13FA296.md): Piper PA-22-135 · Yellow Pine, ID · Accident · 1 fatal · Field investigation · Final report · Jun 28, 2013 · N1540P · 2 aircraft · Substantial damage > The pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately… - [NTSB ERA13CA307](https://openairdocs.org/ntsb/ERA13CA307.md): Piper PA-28-161 · Okeechobee, FL · Accident · Minor injuries · Data collection · Final report · Jun 28, 2013 · N614FT · Substantial damage > The student pilot’s failure to maintain directional control during a go-around. - [NTSB CEN13LA362](https://openairdocs.org/ntsb/CEN13LA362.md): Piper PA-24-260 · Eagle, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2013 · N856CC · Substantial damage > The pilots’ improper fuel management, which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was worn and corroded fuel senders, which transmitted inaccurate fuel readings to the fuel monitoring system. - [NTSB CEN13CA373](https://openairdocs.org/ntsb/CEN13CA373.md): Beech 200 · Wheeling, IL · Accident · No injuries · Data collection · Final report · Jun 26, 2013 · N92JR · Substantial damage > The pilot's improper fuel planning and management, which resulted in a loss of engine power due to fuel exhaustion. - [NTSB CEN13LA370](https://openairdocs.org/ntsb/CEN13LA370.md): Mooney M20J · El Reno, OK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2013 · N205MC · Substantial damage > A loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations. - [NTSB ERA13LA300](https://openairdocs.org/ntsb/ERA13LA300.md): Sikorsky 269C · Lumberton, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 2013 · N2091E · Substantial damage > The pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing. - [NTSB CEN13LA369](https://openairdocs.org/ntsb/CEN13LA369.md): Schleicher ASW-15 · Navasota, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 2013 · N77VT · Substantial damage > An inadvertent aerodynamic stall during the approach for landing. - [NTSB WPR13CA280](https://openairdocs.org/ntsb/WPR13CA280.md): Aviat A-1A · McCall, ID · Accident · Minor injuries · Data collection · Final report · Jun 21, 2013 · N26HV · Substantial damage > The pilot’s failure to maintain adequate airspeed while on approach for landing, which resulted in a loss of airplane control and a hard landing. - [NTSB ERA13LA291](https://openairdocs.org/ntsb/ERA13LA291.md): Cessna 172S · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N426SJ · Substantial damage > A total loss of engine power for reasons that could not be determined because neither postaccident visual examinations nor test runs of the engine revealed any anomalies that would have precluded normal operation. - [NTSB CEN13LA360](https://openairdocs.org/ntsb/CEN13LA360.md): Enstrom F-28A · Danbury, TX · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N485PM · Destroyed > The total loss of engine power due to the failure of a connecting rod for reasons that could not be determined during postaccident examination. - [NTSB CEN13LA359](https://openairdocs.org/ntsb/CEN13LA359.md): Bell 206 - L4 · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Jun 19, 2013 · N467AE · Substantial damage > A partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA13LA285](https://openairdocs.org/ntsb/ERA13LA285.md): Beech A23 · Oxford, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 2013 · N3542R · Substantial damage > The failure to comply with an airworthiness directive by maintenance personnel and incorrect reinstallation of the fuel selector handle by unknown personnel, which resulted in fuel starvation. - [NTSB CEN13LA348](https://openairdocs.org/ntsb/CEN13LA348.md): Cessna 172S · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2013 · N552ND · Substantial damage > The student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around. - [NTSB ERA13LA281](https://openairdocs.org/ntsb/ERA13LA281.md): Cessna 172K · Newton, MS · Accident · 1 fatal · Limited investigation · Final report · Jun 12, 2013 · N7045G · Substantial damage > The student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the… - [NTSB CEN13WA477](https://openairdocs.org/ntsb/CEN13WA477.md): Beech 100 · Saint-Mathieu-de-Beloeil, Canada · Accident · Minor injuries · Foreign investigation · Jun 10, 2013 · C-GJSU · Substantial damage > On June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=47 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=46 --- 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.