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

## Cases, newest first

- [NTSB DCA19WA144](https://openairdocs.org/ntsb/DCA19WA144.md): Boeing 737 · Las Palmas, Spain · Incident · No injuries · Foreign investigation · Mar 26, 2019 · G-TAWA · No damage
  > The CIAIAC of Spain has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB CEN19LA111](https://openairdocs.org/ntsb/CEN19LA111.md): Cessna 140 · Newton, KS · Accident · No injuries · Class 3 · Limited · Final report · Mar 26, 2019 · N76268 · Substantial damage
  > The loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.
- [NTSB ERA19FA134](https://openairdocs.org/ntsb/ERA19FA134.md): Hogan Innovator · Calhoun, GA · Accident · 1 fatal · Class 2 · Field · Final report · Mar 23, 2019 · N257AR · Substantial damage
  > The pilot's failure to maintain aircraft control during the airplane's second test flight, which resulted in a collision with terrain. Contributing to the accident was the pilot allowing external pressures to guide his decision to fly the airplane when he…
- [NTSB CEN19LA107](https://openairdocs.org/ntsb/CEN19LA107.md): Cessna R172E · Loveland, CO · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2019 · N7879N · Substantial damage
  > An inflight loss of control on landing approach due to encountering a down-draft, and the pilot's failure to take timely action to abandon the approach and perform a go-around.
- [NTSB CEN19FA099](https://openairdocs.org/ntsb/CEN19FA099.md): Cessna 172 · Lakeway, TX · Accident · 1 fatal · Class 2 · Field · Final report · Mar 14, 2019 · N8620B · Substantial damage
  > A partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…
- [NTSB ERA19LA160](https://openairdocs.org/ntsb/ERA19LA160.md): Piper PA28R · Easton, MD · Accident · No injuries · Limited investigation · Final report · Mar 13, 2019 · N33305 · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB DCA19WA114](https://openairdocs.org/ntsb/DCA19WA114.md): Boeing 747 · Taiwan, Taiwan · Incident · No injuries · Foreign investigation · Mar 9, 2019 · B-18211 · No damage
  > Aviation Safety Council of Taiwan has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Taiwan's investigation under the…
- [NTSB GAA19CA162](https://openairdocs.org/ntsb/GAA19CA162.md): Cessna 172 · Scottsdale, AZ · Accident · No injuries · Data collection · Final report · Mar 2, 2019 · N9404F · Substantial damage
  > The student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.
- [NTSB CEN19FA084](https://openairdocs.org/ntsb/CEN19FA084.md): Piper PA32R · Goshen, IN · Accident · 1 fatal · Class 3 · Field · Final report · Feb 22, 2019 · N4922K · Destroyed
  > The pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.
- [NTSB WPR19LA087](https://openairdocs.org/ntsb/WPR19LA087.md): MD Helicopter 369 · Kukuihaele, HI · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 21, 2019 · N506PH · Substantial damage
  > The partial loss of engine power due to corrosion in the engine bleed valve due to wash solution intrusion. Contributing to the accident was the installation of a bushing manufactured to incorrect dimensions in the bleed valve, and the uneven terrain at the…
- [NTSB ERA19TA105](https://openairdocs.org/ntsb/ERA19TA105.md): Beech 76 · Frankfort, KY · Accident · Minor injuries · Final report · Feb 21, 2019 · N7KY · Substantial damage
  > The pilot's failure to maintain airplane control during a simulated single-engine go-around, which resulted in a collision with terrain.
- [NTSB GAA19CA142](https://openairdocs.org/ntsb/GAA19CA142.md): Cirrus SR22 · Tulsa, OK · Accident · No injuries · Data collection · Final report · Feb 20, 2019 · N381DE · Substantial damage
  > The pilot's failure to maintain a stabilized approach with a tailwind and his subsequent failure to maintain yaw control during an attempted go-around.
- [NTSB ERA19WA127](https://openairdocs.org/ntsb/ERA19WA127.md): Cessna 210 · Belém City, State of Pará, Brazil · Accident · 1 fatal · Foreign investigation · Feb 13, 2019 · PT-JIC · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB WPR19LA100](https://openairdocs.org/ntsb/WPR19LA100.md): Bellanca 7GCAA · Watsonville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 9, 2019 · N11666 · Substantial damage
  > The pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.
- [NTSB ERA19LA097](https://openairdocs.org/ntsb/ERA19LA097.md): Piper PA28 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Feb 8, 2019 · N9219J · Substantial damage
  > The pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…
- [NTSB WPR19TA085](https://openairdocs.org/ntsb/WPR19TA085.md): Piper PA46 · Aurora, OR · Accident · Serious injuries · Class 3 · Final report · Feb 6, 2019 · N997MA · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing during a simulated power-off approach and landing, which resulted in an aerodynamic stall and loss of control and the flight instructor’s failure to adequately…
- [NTSB ANC19FA012](https://openairdocs.org/ntsb/ANC19FA012.md): Beech 200 · Kake, AK · Accident · 3 fatal · Class 2 · Field · Final report · Jan 30, 2019 · N13LY · Destroyed
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB GAA19CA126](https://openairdocs.org/ntsb/GAA19CA126.md): Cessna 170 · Selah, WA · Accident · No injuries · Data collection · Final report · Jan 27, 2019 · N4087V · Substantial damage
  > The pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.
- [NTSB CEN19TA073](https://openairdocs.org/ntsb/CEN19TA073.md): Beech A36 · Fort Worth, TX · Accident · Serious injuries · Final report · Jan 27, 2019 · N36PS · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.
- [NTSB ERA19LA083](https://openairdocs.org/ntsb/ERA19LA083.md): Beech 35 · Lexington, KY · Accident · No injuries · Class 3 · Limited · Final report · Jan 26, 2019 · N6136V · Substantial damage
  > The pilot's improper slip maneuver on final approach, which resulted in a total loss of engine power.
- [NTSB GAA19CA115](https://openairdocs.org/ntsb/GAA19CA115.md): Navion Navion · Patterson, LA · Accident · No injuries · Data collection · Final report · Jan 20, 2019 · N384TL · Substantial damage
  > The pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.
- [NTSB WPR19LA065](https://openairdocs.org/ntsb/WPR19LA065.md): Piper PA28 · Salt Lake City, UT · Accident · No injuries · Class 3 · Limited · Final report · Jan 15, 2019 · N1697J · Substantial damage
  > A partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.
- [NTSB CEN19LA066](https://openairdocs.org/ntsb/CEN19LA066.md): Piper PA-32R-300 · Adrian, MI · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 2019 · N8892E · Substantial damage
  > The airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.
- [NTSB WPR19LA062](https://openairdocs.org/ntsb/WPR19LA062.md): Vans RV8 · Langley, WA · Accident · 1 fatal · Class 2 · Limited · Final report · Jan 12, 2019 · N800KE · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and a loss of control at an altitude too low for recovery.
- [NTSB CEN19LA069](https://openairdocs.org/ntsb/CEN19LA069.md): Cessna T210 · Port Lavaca, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 10, 2019 · N2391S · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN19LA059](https://openairdocs.org/ntsb/CEN19LA059.md): Cessna T210 · Flint, MI · Accident · No injuries · Limited investigation · Final report · Jan 6, 2019 · N1237M · Substantial damage
  > The failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.
- [NTSB ERA19LA085](https://openairdocs.org/ntsb/ERA19LA085.md): Piper PA24 · Wilkes-Barre, PA · Accident · No injuries · Limited investigation · Final report · Jan 3, 2019 · N6872P · Substantial damage
  > The pilot/mechanic's improper installation and securing of the mixture control cable, which led to a simultaneous loss of total engine power and failure of the nose landing gear to fully extend when the cable caught on the nose landing gear assembly.
- [NTSB ERA19LA081](https://openairdocs.org/ntsb/ERA19LA081.md): Cessna LC41 · Apopka, FL · Accident · No injuries · Limited investigation · Final report · Dec 31, 2018 · N78JE · Substantial damage
  > A partial loss of engine power during a go-around for reasons that could not be determined based on the available information, which resulted in a forced landing.
- [NTSB CEN19LA050](https://openairdocs.org/ntsb/CEN19LA050.md): Cessna R172K · Chesaning, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 2018 · N1095V · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB CEN19LA049](https://openairdocs.org/ntsb/CEN19LA049.md): Beech 58 · Sioux Falls, SD · Accident · 2 fatal · Class 2 · Limited · Final report · Dec 25, 2018 · N6745V · Destroyed
  > The pilot's failure to maintain adequate airspeed during the instrument approach which led to an aerodynamic stall.
- [NTSB ERA19FA070](https://openairdocs.org/ntsb/ERA19FA070.md): Piper PA28 · Blairsville, GA · Accident · 3 fatal · Field investigation · Final report · Dec 20, 2018 · N6143J · Substantial damage
  > The pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.
- [NTSB CEN19LA045](https://openairdocs.org/ntsb/CEN19LA045.md): Brandt Sonex · Lodi, WI · Accident · Serious injuries · Limited investigation · Final report · Dec 15, 2018 · N393SX · Substantial damage
  > The pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.
- [NTSB ERA19FA066](https://openairdocs.org/ntsb/ERA19FA066.md): Eipper Quicksilver · Fredericksburg, VA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2018 · N350FT · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.
- [NTSB ERA19LA065](https://openairdocs.org/ntsb/ERA19LA065.md): Czech Sport Piper Sport · Punta Gorda, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 13, 2018 · N145MM · Substantial damage
  > A total loss of engine power due to an interruption of fuel flow.
- [NTSB GAA19CA096](https://openairdocs.org/ntsb/GAA19CA096.md): Beech 36 · Hartford, WI · Accident · No injuries · Data collection · Final report · Dec 12, 2018 · N6650M · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.
- [NTSB DCA19WA044](https://openairdocs.org/ntsb/DCA19WA044.md): Boeing 737 · Tijuana, Mexico · Incident · No injuries · Foreign investigation · Dec 12, 2018 · XA-ADV · Minor damage
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB ENG19RA007](https://openairdocs.org/ntsb/ENG19RA007.md): Airbus A330 · Brussels, Belgium · Incident · No injuries · Foreign investigation · Dec 11, 2018 · OO-SFU · No damage
  > The Air Accident Investigation Unit of Belgium has notified the NTSB of a serious incident involving an Airbus A330-223 that occurred on December 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation Unit…
- [NTSB ENG19WA011](https://openairdocs.org/ntsb/ENG19WA011.md): Airbus A320 · Jaipur, India · Incident · No injuries · Foreign investigation · Dec 10, 2018 · VT-ITR · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on December 10, 2018. An Indigo Airbus A320 experienced an ECAM warning for 'Lavatory Smoke' while descending through FL170 to land Kolkata Airport…
- [NTSB ERA19LA061](https://openairdocs.org/ntsb/ERA19LA061.md): Cessna P210 · Myerstown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 8, 2018 · N731LT · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB CEN19WA043](https://openairdocs.org/ntsb/CEN19WA043.md): Cessna 177 · Spain, Spain · Accident · 2 fatal · Foreign investigation · Dec 7, 2018 · D-ECGS · Destroyed
  > The government of Spain has notified the NTSB of an accident involving a CESSNA 177 airplane that occurred on December 07, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB GAA19CA086](https://openairdocs.org/ntsb/GAA19CA086.md): Cessna 182 · Reno, NV · Accident · No injuries · Data collection · Final report · Dec 3, 2018 · N9003M · Substantial damage
  > The airplane’s collision with a bird during a practice instrument approach.
- [NTSB CEN19LA039](https://openairdocs.org/ntsb/CEN19LA039.md): Cessna 550 · Fargo, ND · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 2018 · N941JM · Substantial damage
  > The pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…
- [NTSB ERA19LA057](https://openairdocs.org/ntsb/ERA19LA057.md): Cirrus SR22 · Kennesaw, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 2018 · N597CP · Substantial damage
  > The total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.
- [NTSB GAA19CA099](https://openairdocs.org/ntsb/GAA19CA099.md): Cirrus SR20 · Jasper, GA · Accident · Minor injuries · Data collection · Final report · Nov 28, 2018 · N343BZ · Substantial damage
  > The student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.
- [NTSB ERA19WA058](https://openairdocs.org/ntsb/ERA19WA058.md): Cessna 525 · Jequitaí County, Brazil · Accident · 4 fatal · Foreign investigation · Nov 26, 2018 · PP-OEG · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Cessna 525 airplane that occurred on November 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB ERA19WA054](https://openairdocs.org/ntsb/ERA19WA054.md): Eurocopter EC120 · La Romana, Dominican Republic · Accident · 5 fatal · Foreign investigation · Nov 22, 2018 · N124ML · Destroyed
  > The government of Dominican Republic has notified the NTSB of an accident involving a Eurocopter EC120 helicopter that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…
- [NTSB GAA19WA419](https://openairdocs.org/ntsb/GAA19WA419.md): Socata TB20 · Dinard Pleurtuit, France · Accident · 2 fatal · Foreign investigation · Nov 17, 2018 · F-GKVZ · Destroyed
  > The government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB ERA19FA049](https://openairdocs.org/ntsb/ERA19FA049.md): Lancair Legacy RG · Gainesville, GA · Accident · 1 fatal · Class 2 · Field · Final report · Nov 17, 2018 · N8448J · Substantial damage
  > The pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…
- [NTSB WPR19FA026](https://openairdocs.org/ntsb/WPR19FA026.md): Zenith CH601 · Overgaard, AZ · Accident · 2 fatal · Class 2 · Field · Final report · Nov 16, 2018 · N322JL · Substantial damage
  > The pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.
- [NTSB ERA19LA043](https://openairdocs.org/ntsb/ERA19LA043.md): Aero Commander 690 · Myrtle Beach, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 12, 2018 · N840JC · Substantial damage
  > An encounter with low-level windshear and turbulence during the landing approach, which resulted in a loss of airplane control.

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

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

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