# 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 51 of 420 · 20,992 cases

## Cases, newest first

- [NTSB ERA12CA348](https://openairdocs.org/ntsb/ERA12CA348.md): Mooney M20C · Pembroke Pines, FL · Accident · Minor injuries · Data collection · Final report · May 19, 2012 · N2610W · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.
- [NTSB DCA12FA076](https://openairdocs.org/ntsb/DCA12FA076.md): Hawker Hawker Hunter MK.58A · Point Mugu, CA · Accident · 1 fatal · Field investigation · Final report · May 18, 2012 · N329AX · Destroyed
  > the pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…
- [NTSB WPR12LA214](https://openairdocs.org/ntsb/WPR12LA214.md): Marley Kolb Firestar II · Cedar Fort, UT · Accident · Serious injuries · Limited investigation · Final report · May 17, 2012 · N9173T · Substantial damage
  > The pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.
- [NTSB ERA12CA333](https://openairdocs.org/ntsb/ERA12CA333.md): Luttenbacher Kurt Bushby Mustang 2 · Kingstree, SC · Accident · Minor injuries · Data collection · Final report · May 12, 2012 · N58RS · Substantial damage
  > The pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.
- [NTSB CEN12CA286](https://openairdocs.org/ntsb/CEN12CA286.md): Costruzioni Aeronautiche Tecna P2006T · Cleburne, TX · Accident · No injuries · Data collection · Final report · May 10, 2012 · N727TA · Substantial damage
  > The pilot's inadvertent selection of flap 0 degrees during the go-around and the flight instructor’s inadequate supervision, which resulted in an aerodynamic stall at low altitude.
- [NTSB ERA12CA321](https://openairdocs.org/ntsb/ERA12CA321.md): Eiriavion PIK 20D · Eagleville, TN · Accident · Serious injuries · Data collection · Final report · May 6, 2012 · N39RB · Substantial damage
  > The glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.
- [NTSB CEN12CA279](https://openairdocs.org/ntsb/CEN12CA279.md): Balloon Works Firefly 7-15 · Hallsville, MO · Accident · No injuries · Data collection · Final report · May 6, 2012 · N9079S · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during landing.
- [NTSB CEN12FA271](https://openairdocs.org/ntsb/CEN12FA271.md): Beech S35 · Lake in the Hills, IL · Accident · 2 fatal · Field investigation · Final report · May 3, 2012 · N176Q · Substantial damage
  > The pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.
- [NTSB ERA12WA300](https://openairdocs.org/ntsb/ERA12WA300.md): Beech C90 · Jundiai, Brazil · Accident · 1 fatal · Foreign investigation · Apr 20, 2012 · PP-WCA · Substantial damage
  > On April 20, 2012, at 1735 UTC, a Beech C90A, Brazilian registration PP-WCA, was destroyed when it impacted the ground shortly after takeoff from Comandante Rolim Adolfo Amaro State Airport (SBJD), Jundiaí, Brazil. The pilot was fatally injured. Visual…
- [NTSB ERA12LA299](https://openairdocs.org/ntsb/ERA12LA299.md): Cessna 210 · Gatlinburg, TN · Accident · No injuries · Limited investigation · Final report · Apr 19, 2012 · N96050 · Substantial damage
  > Failure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.
- [NTSB ERA12LA282](https://openairdocs.org/ntsb/ERA12LA282.md): Robinson Helicopter R22 Beta · Farmington, CT · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 2012 · N1152W · Substantial damage
  > The pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…
- [NTSB ERA12LA279](https://openairdocs.org/ntsb/ERA12LA279.md): Stanley B E Murphy Rebel · Falmouth, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 2012 · N24V · Substantial damage
  > The pilot's delayed application of carburetor heat, which resulted in a loss of engine power.
- [NTSB WPR12CA163](https://openairdocs.org/ntsb/WPR12CA163.md): Avian Balloon Magnum IX · Sedona, AZ · Accident · No injuries · Data collection · Final report · Apr 10, 2012 · N2037U · 2 aircraft · Substantial damage
  > The pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.
- [NTSB WPR12LA160](https://openairdocs.org/ntsb/WPR12LA160.md): Cessna 150H · Kent, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 2012 · N6616S · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.
- [NTSB WPR12CA157](https://openairdocs.org/ntsb/WPR12CA157.md): Fisher HP-14 Sailplane · Nampa, ID · Accident · No injuries · Data collection · Final report · Apr 6, 2012 · N990 · Substantial damage
  > The pilot’s incorrect positioning of the wing flaps during the landing approach, which resulted in a loss of lift and hard landing.
- [NTSB CEN12LA228](https://openairdocs.org/ntsb/CEN12LA228.md): Enstrom 280FX · Corpus Christi, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 2012 · N3042D · Substantial damage
  > The failure of the bolt that retained the clutch drive rod end, which resulted in a loss of main rotor drive and a subsequent hard landing.
- [NTSB DCA12WA066](https://openairdocs.org/ntsb/DCA12WA066.md): Boeing 777 - 206 · Tokyo, Japan · Accident · No injuries · Foreign investigation · Mar 31, 2012 · JA701J · Substantial damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-246ER that occurred on March 31, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…
- [NTSB ANC12FA028](https://openairdocs.org/ntsb/ANC12FA028.md): Piper PA-18 · Sleetmute, AK · Accident · 2 fatal · Field investigation · Final report · Mar 31, 2012 · N7276D · Substantial damage
  > Operation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.
- [NTSB CEN12LA216](https://openairdocs.org/ntsb/CEN12LA216.md): Piper PA-28-161 · Arcola, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 2012 · N800KA · Substantial damage
  > A total loss of engine power during landing approach 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 CEN12FA210](https://openairdocs.org/ntsb/CEN12FA210.md): Beech E-55 · Broken Bow, NE · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2012 · N1567W · Substantial damage
  > The pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…
- [NTSB ERA12FA256](https://openairdocs.org/ntsb/ERA12FA256.md): Anderson John H Avid Flyer MK 4 · Waxhaw, NC · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2012 · N61410 · Substantial damage
  > The pilot's failure to maintain adequate airspeed during an attempted go-around, which resulted in a low-altitude aerodynamic stall.
- [NTSB ERA12CA254](https://openairdocs.org/ntsb/ERA12CA254.md): Fantasy Air Sro Allegro 2007 · Groveland, FL · Accident · No injuries · Data collection · Final report · Mar 25, 2012 · N2570C · Substantial damage
  > The pilot's failure to maintain directional control during a go-around maneuver in gusty crosswind conditions.
- [NTSB ERA12LA273](https://openairdocs.org/ntsb/ERA12LA273.md): Cessna T337B · Dothan, AL · Accident · No injuries · Limited investigation · Final report · Mar 24, 2012 · N2334S · Substantial damage
  > The failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.
- [NTSB ERA12LA252](https://openairdocs.org/ntsb/ERA12LA252.md): New Kolb Mark III Classic · Deland, FL · Accident · No injuries · Limited investigation · Final report · Mar 24, 2012 · N528DJ · Substantial damage
  > The pilot's lack of preflight planning for potential carburetor icing conditions, and the subsequent flight in those conditions in an airplane not equipped with carburetor heat.
- [NTSB CEN12CA202](https://openairdocs.org/ntsb/CEN12CA202.md): Smith Aerostar 601P · Casterville, TX · Accident · No injuries · Data collection · Final report · Mar 24, 2012 · N602BV · Substantial damage
  > The pilot did not maintain control of the airplane while circling to land.
- [NTSB ERA12LA246](https://openairdocs.org/ntsb/ERA12LA246.md): Diamond Aircraft Ind DA 20-C1 · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2012 · N166SE · Substantial damage
  > The operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.
- [NTSB ERA12WA243](https://openairdocs.org/ntsb/ERA12WA243.md): Bell 407 · Podnovye, Russia · Accident · 1 fatal · Foreign investigation · Mar 22, 2012 · RA-01931 · Substantial damage
  > On March 22, 2012, about 0615 coordinated universal time, a Bell 407, Russian registration RA-01931, was substantially damaged when it impacted electrical utility wires and the Volga River while on approach to a private landing area near Podnovye, Russia. The…
- [NTSB ERA12CA248](https://openairdocs.org/ntsb/ERA12CA248.md): JDT MiniMax · Gap, PA · Accident · No injuries · Data collection · Final report · Mar 21, 2012 · UNREG · Substantial damage
  > The student pilot's failure to maintain airspeed during a go-around, resulting in an aerodynamic stall.
- [NTSB CEN12LA197](https://openairdocs.org/ntsb/CEN12LA197.md): Piper PA-22-150 · Pinconning, MI · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 2012 · N2389P · Substantial damage
  > The pilot's failure to properly align his airplane with the runway during final approach. Contributing to the accident was the sunglare that obscured the pilot's view of the runway.
- [NTSB ERA12LA233](https://openairdocs.org/ntsb/ERA12LA233.md): Boehlke Kevin P 2/3 Scale Jenny · Hannacroix, NY · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2012 · N987KB · Substantial damage
  > The non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…
- [NTSB ERA12CA244](https://openairdocs.org/ntsb/ERA12CA244.md): Mooney M20M · Clearwater, FL · Accident · No injuries · Data collection · Final report · Mar 18, 2012 · N9140M · Substantial damage
  > The pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.
- [NTSB WPR12LA138](https://openairdocs.org/ntsb/WPR12LA138.md): Raven Industries S-66A · Avra Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 2012 · N57194 · Substantial damage
  > The pilot's improper decision to partially open the balloon's vent before clearing a power line while landing, which resulted in the balloon descending too soon and contacting the power line.
- [NTSB WPR12LA140](https://openairdocs.org/ntsb/WPR12LA140.md): Robinson Helicopter R22 Beta · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 2012 · N290SH · Substantial damage
  > The pilot's improper use of the throttle grip, which resulted in the deactivation of the rpm governor and a loss of rotor rpm.
- [NTSB DCA12FA051](https://openairdocs.org/ntsb/DCA12FA051.md): Convair 440 - NO Series · San Juan, PR · Accident · 2 fatal · Class 1 · Field · Final report · Mar 15, 2012 · N153JR · Destroyed
  > the flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.
- [NTSB WPR12CA129](https://openairdocs.org/ntsb/WPR12CA129.md): Stinson 108-3 · Santa Clarita, CA · Accident · Minor injuries · Data collection · Final report · Mar 12, 2012 · N4143C · Substantial damage
  > The pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.
- [NTSB CEN12CA183](https://openairdocs.org/ntsb/CEN12CA183.md): Piper PA-18-150 · Fort Collins, CO · Accident · Minor injuries · Data collection · Final report · Mar 8, 2012 · N2986P · Substantial damage
  > The pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.
- [NTSB DCA12PA049](https://openairdocs.org/ntsb/DCA12PA049.md): Israel Aircraft Industries F21-C2 · Fallon, NV · Accident · 1 fatal · Final report · Mar 6, 2012 · N404AX · Destroyed
  > fuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…
- [NTSB CEN12LA179](https://openairdocs.org/ntsb/CEN12LA179.md): Skeeter 1M · Oklahoma City, OK · Accident · 1 fatal · Limited investigation · Final report · Mar 3, 2012 · N1111V · Substantial damage
  > The pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.
- [NTSB ERA12CA204](https://openairdocs.org/ntsb/ERA12CA204.md): American Champion 7GCAA · Bedminster, NJ · Accident · Serious injuries · Data collection · Final report · Mar 2, 2012 · N518F · Substantial damage
  > The pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.
- [NTSB ERA12CA198](https://openairdocs.org/ntsb/ERA12CA198.md): Lester Robert E KR-2 · Boca Raton, FL · Accident · No injuries · Data collection · Final report · Mar 1, 2012 · N1701L · Substantial damage
  > The failure of the airplane’s engine air inlet system resulting in a total loss of engine power.
- [NTSB ERA12FA196](https://openairdocs.org/ntsb/ERA12FA196.md): Cirrus Design SR22 · Melbourne, FL · Accident · 3 fatal · Field investigation · Final report · Feb 29, 2012 · N544SR · Substantial damage
  > The pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…
- [NTSB DCA12FA046](https://openairdocs.org/ntsb/DCA12FA046.md): Airbus A321 · Millville, NJ · Accident · Serious injuries · Field investigation · Final report · Feb 24, 2012 · N162UW · No damage
  > an encounter with convective turbulence that resulted in injury to a passenger who was not seated when the seatbelt sign was illuminated.
- [NTSB CEN12LA169](https://openairdocs.org/ntsb/CEN12LA169.md): Beech 58 · Cypress, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 2012 · N99EZ · Substantial damage
  > The pilot's improper preflight planning/preparation and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion during the approach to the destination airport.
- [NTSB CEN12LA166](https://openairdocs.org/ntsb/CEN12LA166.md): Boeing 737-832 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2012 · N374DA · No damage
  > An in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.
- [NTSB CEN12FA161](https://openairdocs.org/ntsb/CEN12FA161.md): Cessna 414A · Hayden, CO · Accident · 2 fatal · Field investigation · Final report · Feb 19, 2012 · N4772A · Substantial damage
  > The pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.
- [NTSB ERA12CA190](https://openairdocs.org/ntsb/ERA12CA190.md): Piper PA-32R-300 · Swainsboro, GA · Accident · No injuries · Data collection · Final report · Feb 18, 2012 · N47863 · Substantial damage
  > The pilot’s failure to maintain the proper glidepath during final approach in night visual meteorological conditions, which resulted in a collision with trees.
- [NTSB WPR12CA173](https://openairdocs.org/ntsb/WPR12CA173.md): Lindstrand LBL180A · Temecula, CA · Accident · No injuries · Data collection · Final report · Feb 17, 2012 · N49CD · Substantial damage
  > The pilot failed to see and avoid a set of power lines while maneuvering to a landing site.
- [NTSB ERA12LA186](https://openairdocs.org/ntsb/ERA12LA186.md): Cessna 150J · Jasper, GA · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 2012 · N60276 · Substantial damage
  > The pilots' inadequate preflight inspection that failed to detect water-contaminated fuel, which resulted in a total loss of engine power.
- [NTSB CEN12CA165](https://openairdocs.org/ntsb/CEN12CA165.md): Beech 95-B55 · Lancaster, WI · Accident · No injuries · Data collection · Final report · Feb 17, 2012 · N4624A · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12FA175](https://openairdocs.org/ntsb/ERA12FA175.md): Cessna T182T · Lebanon, NH · Accident · 1 fatal · Field investigation · Final report · Feb 9, 2012 · N6062E · Substantial damage
  > The pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=52

## 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=51

---
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.