# 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 48 of 420 · 20,992 cases ## Cases, newest first - [NTSB CEN13LA201](https://openairdocs.org/ntsb/CEN13LA201.md): Piper PA23-250 · Winsted, MN · Accident · No injuries · Limited investigation · Final report · Mar 16, 2013 · N6222M · Substantial damage > The obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power. - [NTSB ERA13CA170](https://openairdocs.org/ntsb/ERA13CA170.md): Cessna 172M · Hendersonville, NC · Accident · No injuries · Data collection · Final report · Mar 15, 2013 · N61756 · Substantial damage > The student pilot’s failure to maintain control of the airplane during an attempted go-around in gusty tailwind conditions. - [NTSB CEN13LA195](https://openairdocs.org/ntsb/CEN13LA195.md): New Piper PA-46-500TP · Brenham, TX · Accident · No injuries · Limited investigation · Final report · Mar 13, 2013 · N665KC · Substantial damage > A lack of available engine power during an attempted go-around for reasons that could not be determined because the postaccident engine examinations did not reveal any anomalies consistent with an inability to produce rated power. - [NTSB ERA13LA159](https://openairdocs.org/ntsb/ERA13LA159.md): 781569 FX 210 · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 2013 · N524VT · Substantial damage > A total loss of engine power for reasons that could not be determined from the available evidence. - [NTSB ERA13CA161](https://openairdocs.org/ntsb/ERA13CA161.md): Rainbow Aircraft PTY Cobra · Camden, SC · Accident · Minor injuries · Data collection · Final report · Mar 9, 2013 · N78DK · Substantial damage > The pilot's failure to maintain airplane control during the approach to land. - [NTSB CEN13WA572](https://openairdocs.org/ntsb/CEN13WA572.md): Piper PA28 - 161 · Persan, France · Accident · 1 fatal · Foreign investigation · Mar 6, 2013 · F-GHPN · Substantial damage > On March 6, 2013, about 1920 universal coordinated time, a Piper PA28-161 airplane, F-GHPN, impacted terrain during final approach to land on runway 10, at the Persan-Beaumont Airport (LFPA), near Persan, France. The pilot was fatally injured. This… - [NTSB ERA13LA148](https://openairdocs.org/ntsb/ERA13LA148.md): Piper PA-32-300 · Sanford, NC · Accident · No injuries · Limited investigation · Final report · Feb 27, 2013 · N1953H · Substantial damage > The installation of an incorrect length of cotter pin on the throttle linkage clevis pin by maintenance personnel at an undetermined time, which resulted in the pin coming loose and the loss of throttle control. - [NTSB WPR13LA134](https://openairdocs.org/ntsb/WPR13LA134.md): Blumer Challenger II Spec · Peoria, AZ · Accident · No injuries · Limited investigation · Final report · Feb 26, 2013 · N107BW · Substantial damage > A cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach. - [NTSB DCA13WA060](https://openairdocs.org/ntsb/DCA13WA060.md): Boeing 757 · Keflavik, Iceland · Incident · No injuries · Foreign investigation · Feb 26, 2013 · TF-FIJ · No damage > On 26 February 2013, at approximately 2232 UTC time, a Boeing B757-200, during a flight operated by Icelandair between Kastrup, Denmark, and Keflavik, Iceland, the flight crew received an EICAS message indicating a right hydraulic failure when at the top of… - [NTSB ERA13MA139](https://openairdocs.org/ntsb/ERA13MA139.md): Beech 390 · Thomson, GA · Accident · 5 fatal · Major investigation · Final report · Feb 21, 2013 · N777VG · Destroyed > The pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of… - [NTSB CEN13CA169](https://openairdocs.org/ntsb/CEN13CA169.md): Cessna 152 · Murphysboro, IL · Accident · No injuries · Data collection · Final report · Feb 15, 2013 · N95670 · Substantial damage > An inadvertent encounter with birds while on the downwind leg in the traffic pattern. - [NTSB CEN13CA206](https://openairdocs.org/ntsb/CEN13CA206.md): Cessna T206H · Sabinal, TX · Accident · No injuries · Data collection · Final report · Feb 13, 2013 · N7824G · Substantial damage > The pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over. - [NTSB CEN13CA153](https://openairdocs.org/ntsb/CEN13CA153.md): Cessna 177RG · Herington, KS · Accident · No injuries · Data collection · Final report · Feb 8, 2013 · N88NG · Substantial damage > The pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. - [NTSB WPR13FA115](https://openairdocs.org/ntsb/WPR13FA115.md): Beech E90 · Casa Grande, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 6, 2013 · N555FV · Destroyed > The pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin. - [NTSB DCA13WA050](https://openairdocs.org/ntsb/DCA13WA050.md): Bombardier CL600 2B19 · Almaty, Kazakhstan · Accident · 21 fatal · Foreign investigation · Jan 29, 2013 · UP-CJ006 · Destroyed > The Accident Investigation Department of the Ministry of Transport and Communications of the Republic of Kazakhstan has notified the NTSB of an accident involving a Bombardier Challenger CRJ-200, registration UP-CJ006, which occurred on January 29, 2013. The… - [NTSB WPR13LA106](https://openairdocs.org/ntsb/WPR13LA106.md): Cessna 152 · Atwater, CA · Accident · No injuries · Limited investigation · Final report · Jan 27, 2013 · N68757 · Substantial damage > The student pilot's inadequate flight planning, which resulted in his getting lost and not being able to return to the airport before the fuel was exhausted and the engine lost power. - [NTSB CEN13FA143](https://openairdocs.org/ntsb/CEN13FA143.md): Raytheon A36 · Richwood, LA · Accident · 4 fatal · Field investigation · Final report · Jan 24, 2013 · N980SS · Destroyed > The pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions. - [NTSB ERA13LA117](https://openairdocs.org/ntsb/ERA13LA117.md): Cirrus Design SR20 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Jan 23, 2013 · N140PG · Substantial damage > The flight instructor’s inadequate preflight inspection in which he incorrectly estimated the airplane’s fuel quantity and his improper reliance on the fuel totalizer rather than the fuel quantity indicating and warning systems to determine the fuel on board,… - [NTSB WPR13LA102](https://openairdocs.org/ntsb/WPR13LA102.md): Cessna 172RG · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Jan 18, 2013 · N6290V · Substantial damage > Failure of the left main landing gear pivot assembly during the landing approach. - [NTSB WPR13LA094](https://openairdocs.org/ntsb/WPR13LA094.md): Piper PA-28-235 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Jan 18, 2013 · N49DS · Substantial damage > The pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism. - [NTSB ERA13LA113](https://openairdocs.org/ntsb/ERA13LA113.md): Piper PA-34-200T · Manteo, NC · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2013 · N6537C · Destroyed > The pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying… - [NTSB ERA13LA111](https://openairdocs.org/ntsb/ERA13LA111.md): Piper PA-28R-200 · Dover, DE · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2013 · N4975S · Substantial damage > The pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a… - [NTSB ERA13LA110](https://openairdocs.org/ntsb/ERA13LA110.md): Piper PA-28R-180 · Winder, GA · Accident · No injuries · Limited investigation · Final report · Jan 12, 2013 · N3898T · Substantial damage > A total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time… - [NTSB CEN13CA133](https://openairdocs.org/ntsb/CEN13CA133.md): American General Acft AG5B · Ankeny, IA · Accident · No injuries · Data collection · Final report · Jan 12, 2013 · N897GA · Substantial damage > The pilot’s failure to maintain a proper glide path to the runway in gusty wind conditions and his failure to maintain clearance from obstructions during the subsequent go-around. Contributing to the accident was the pilot's improper interior lighting… - [NTSB ERA13FA105](https://openairdocs.org/ntsb/ERA13FA105.md): Beech H35 · Palm Coast, FL · Accident · 3 fatal · Field investigation · Final report · Jan 4, 2013 · N375B · Destroyed > A total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the… - [NTSB ERA13WA103](https://openairdocs.org/ntsb/ERA13WA103.md): Piper PA28 · Minas City, Brazil · Accident · 2 fatal · Foreign investigation · Dec 26, 2012 · PR-NAX · Destroyed > On December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The… - [NTSB DCA13WA041](https://openairdocs.org/ntsb/DCA13WA041.md): Fokker 100 · Heho, Myanmar (Burma) · Accident · Serious injuries · Foreign investigation · Dec 25, 2012 · XY-AGC · Substantial damage > On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and… - [NTSB WPR13FA074](https://openairdocs.org/ntsb/WPR13FA074.md): Charland Vortex · Wellton, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2012 · N618TC · Substantial damage > The pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern. - [NTSB CEN13TA113](https://openairdocs.org/ntsb/CEN13TA113.md): Cessna 550 · Oklahoma City, OK · Accident · Minor injuries · Final report · Dec 21, 2012 · N753CC · Substantial damage > The flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane… - [NTSB CEN13LA109](https://openairdocs.org/ntsb/CEN13LA109.md): Beech A23 · Grand Isle, NE · Accident · No injuries · Limited investigation · Final report · Dec 18, 2012 · N3573R · Substantial damage > The student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation. - [NTSB ERA13FA088](https://openairdocs.org/ntsb/ERA13FA088.md): Piper PA-28-160 · Parkton, NC · Accident · 1 fatal · Field investigation · Final report · Dec 16, 2012 · N5714W · Substantial damage > The failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of… - [NTSB CEN13CA106](https://openairdocs.org/ntsb/CEN13CA106.md): Cessna 182Q · Bellview, TX · Accident · No injuries · Data collection · Final report · Dec 15, 2012 · N735BV · Substantial damage > The pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun. - [NTSB WPR13CA065](https://openairdocs.org/ntsb/WPR13CA065.md): Bellanca 7ECA · Tehachapi, CA · Accident · No injuries · Data collection · Final report · Dec 8, 2012 · N8595V · Substantial damage > The non-instrument-rated pilot's continued descent into instrument meteorological conditions during the landing approach and his loss of situational awareness, which resulted in a collision with terrain. - [NTSB CEN13LA097](https://openairdocs.org/ntsb/CEN13LA097.md): North American T-28C · Moody, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2012 · N280JM · Substantial damage > The total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation. - [NTSB CEN13LA099](https://openairdocs.org/ntsb/CEN13LA099.md): Enstrom F-28C · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 2012 · N574H · Substantial damage > The flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate… - [NTSB CEN13LA094](https://openairdocs.org/ntsb/CEN13LA094.md): Lsa America Allegro · Adrian, MI · Accident · No injuries · Limited investigation · Final report · Dec 6, 2012 · N448SS · Substantial damage > The student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions. - [NTSB DCA13CA066](https://openairdocs.org/ntsb/DCA13CA066.md): Bombardier CL-600-2B19 · New York, NY · Accident · No injuries · Data collection · Final report · Dec 5, 2012 · N411ZW · Substantial damage > an inadvertant birdstrike on approach. - [NTSB CEN13LA088](https://openairdocs.org/ntsb/CEN13LA088.md): Cessna 172M · Rochester, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2012 · N9853Q · Substantial damage > The pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing… - [NTSB ERA13LA076](https://openairdocs.org/ntsb/ERA13LA076.md): Cassutt Sport Racer · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N9CA · Substantial damage > Impact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot. - [NTSB ERA13CA077](https://openairdocs.org/ntsb/ERA13CA077.md): Schweizer SGS 2-33A · Middletown, NY · Accident · No injuries · Data collection · Final report · Dec 2, 2012 · N5787S · Substantial damage > The pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach. - [NTSB CEN13CA083](https://openairdocs.org/ntsb/CEN13CA083.md): Mooney M20TN · Durango, CO · Accident · No injuries · Data collection · Final report · Dec 2, 2012 · N562BG · Substantial damage > The pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver. - [NTSB ERA13CA073](https://openairdocs.org/ntsb/ERA13CA073.md): Beech B19 · Fort Lauderdale, FL · Accident · No injuries · Data collection · Final report · Dec 1, 2012 · N2196W · Substantial damage > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power. - [NTSB CEN13FA081](https://openairdocs.org/ntsb/CEN13FA081.md): Ercoupe 415-C · Blair, NE · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2012 · N720RC · Substantial damage > The pilot's loss of control due to physical incapacitation. - [NTSB ERA13LA069](https://openairdocs.org/ntsb/ERA13LA069.md): Lawson J/Bowie R/Smith M CA-8 · Merritt Island, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 2012 · N155JD · Substantial damage > The pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the… - [NTSB CEN13FA078](https://openairdocs.org/ntsb/CEN13FA078.md): Taylorcraft BC12-D · Clutier, IA · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2012 · N94973 · Substantial damage > The pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground… - [NTSB CEN13FA067](https://openairdocs.org/ntsb/CEN13FA067.md): Piper PA-28-180 · Hillsdale, MI · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2012 · N40781 · Substantial damage > The pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional… - [NTSB CEN13FA066](https://openairdocs.org/ntsb/CEN13FA066.md): Brian P North RAF SE5A Replica · Watkins, CO · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2012 · N17SE · Substantial damage > The pilot’s loss of airplane control and inadvertent stall while attempting to return for landing. - [NTSB ERA13LA065](https://openairdocs.org/ntsb/ERA13LA065.md): Beech C90A · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Nov 20, 2012 · N702DK · Substantial damage > The failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's… - [NTSB ERA13FA064](https://openairdocs.org/ntsb/ERA13FA064.md): Piper PA-28-180 · Canton, CT · Accident · 2 fatal · Field investigation · Final report · Nov 19, 2012 · N8826J · Substantial damage > The pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night. - [NTSB CEN13LA063](https://openairdocs.org/ntsb/CEN13LA063.md): Redd Tom Quicksilver GT 400 · Oak Grove, LA · Accident · 1 fatal · Limited investigation · Final report · Nov 19, 2012 · N4031Q · Substantial damage > The total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=49 ## 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=48 --- 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.