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

## Cases, newest first

- [NTSB CEN17LA149](https://openairdocs.org/ntsb/CEN17LA149.md): Aero Adventure Aventura UL · Garden Ridge, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2017 · N580TX · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB GAA17CA215](https://openairdocs.org/ntsb/GAA17CA215.md): Cessna 182 · Blue Earth, MN · Accident · Minor injuries · Data collection · Final report · Apr 3, 2017 · N8889X · Substantial damage
  > The pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…
- [NTSB GAA17CA219](https://openairdocs.org/ntsb/GAA17CA219.md): Cessna 172 · Millbrook, NY · Accident · Minor injuries · Data collection · Final report · Apr 2, 2017 · N734SN · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing with a crosswind, which resulted in an aerodynamic stall and an off-runway landing.
- [NTSB GAA17CA208](https://openairdocs.org/ntsb/GAA17CA208.md): Dempsey Daniel M Zodiac CH601XLB · Louisa, VA · Accident · No injuries · Data collection · Final report · Mar 25, 2017 · N978ER · Substantial damage
  > The pilot’s in-flight fuel mismanagement and subsequent failure to maintain adequate airspeed while attempting to land on the runway, which resulted in an aerodynamic stall and a hard landing.
- [NTSB GAA17CA207](https://openairdocs.org/ntsb/GAA17CA207.md): Cessna 550 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Mar 24, 2017 · N551BC · Substantial damage
  > An in-flight collision with a goose during approach.
- [NTSB ENG17RA040](https://openairdocs.org/ntsb/ENG17RA040.md): ATR ATR72 · Guarulhos, Brazil · Incident · No injuries · Foreign investigation · Mar 21, 2017 · PP-PTQ · Minor damage
  > The Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) of Brazil has notified the NTSB of an incident involving an Aerospatiale and Alenia ATR-72-212A, which occurred on March 21, 2017. The NTSB has appointed a U.S. Accredited…
- [NTSB ENG17IA017](https://openairdocs.org/ntsb/ENG17IA017.md): Douglas DC 9 83 · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Mar 19, 2017 · N881GA · No damage
  > The probable cause of the No. 2 (right) engine fire was an uncontained generator failure. Deformed rotating generator components and/or metal fragments radially released by the generator severed the constant speed drive-to-oil cooler return line located…
- [NTSB GAA17CA197](https://openairdocs.org/ntsb/GAA17CA197.md): Cessna R182 · Colorado Springs, CO · Accident · No injuries · Data collection · Final report · Mar 18, 2017 · N747AB · Substantial damage
  > The pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.
- [NTSB ENG17WA016](https://openairdocs.org/ntsb/ENG17WA016.md): Saab 340 · Sydney, Australia · Incident · No injuries · Foreign investigation · Mar 17, 2017 · VH-NRX
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Saab 340B which occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…
- [NTSB CEN17WA125](https://openairdocs.org/ntsb/CEN17WA125.md): Robinson Helicopter Robinson R44 II · Carlingford, Ireland · Accident · Serious injuries · Foreign investigation · Mar 12, 2017 · G-DORM · Destroyed
  > On March 12, 2017, about 1715 coordinated universal time (UTC), a Robinson Helicopter Company Inc. R44 II helicopter, G-DORM, was destroyed when it impacted terrain during an approach to landing near Carlingford, County Louth, Ireland. The pilot and one…
- [NTSB GAA17CA191](https://openairdocs.org/ntsb/GAA17CA191.md): Cessna 208 · Kalaupapa, HI · Accident · Minor injuries · Class 4 · Data collection · Final report · Mar 11, 2017 · N865MA · Substantial damage
  > The pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.
- [NTSB ERA17LA125](https://openairdocs.org/ntsb/ERA17LA125.md): Grob G120TP-A · Abbeville, AL · Accident · Serious injuries · Class 2 · Limited · Final report · Mar 8, 2017 · N196TP · Substantial damage
  > The flame-out of the engine due to a mis-set fuel control unit at the time of manufacture. Contributing to the accident was the pilots’ delayed recognition that the engine had flamed out, partially due to the operator’s requirement to disable the crew…
- [NTSB ERA17FA123](https://openairdocs.org/ntsb/ERA17FA123.md): Jordan Bruce C Pitts S2E · Apex, NC · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2017 · N30BJ · Substantial damage
  > The pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB DCA17WA121](https://openairdocs.org/ntsb/DCA17WA121.md): Boeing 737 · Sint Maarten, NT · Incident · No injuries · Foreign investigation · Mar 7, 2017 · C-GWSV · No damage
  > The government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…
- [NTSB ERA17FA118](https://openairdocs.org/ntsb/ERA17FA118.md): Cessna 421 · Canton, GA · Accident · 1 fatal · Field investigation · Final report · Mar 4, 2017 · N421KL · Substantial damage
  > The pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.
- [NTSB GAA17CA172](https://openairdocs.org/ntsb/GAA17CA172.md): Cessna 182 · Alpine, TX · Accident · No injuries · Data collection · Final report · Mar 3, 2017 · N2892Y · Substantial damage
  > The pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.
- [NTSB ANC17LA017](https://openairdocs.org/ntsb/ANC17LA017.md): Beech G18 · Metlakatla, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 2017 · N103AF · Substantial damage
  > An engine power loss for reasons that could not be determined because the airplane was not recovered.
- [NTSB ERA17FA117](https://openairdocs.org/ntsb/ERA17FA117.md): Lavender Alan P Sonex · Methuen, MA · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2017 · N315AL · Substantial damage
  > The pilot's failure to properly secure oil and fuel line fittings during maintenance, which resulted in an inflight engine fire, and his subsequent loss of control while maneuvering for landing. Contributing to the accident was the pilot's diverted attention…
- [NTSB ERA17FA115](https://openairdocs.org/ntsb/ERA17FA115.md): Ryan Navion · Westhampton Beach, NY · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2017 · N4529K · Destroyed
  > The flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…
- [NTSB CEN17CA114](https://openairdocs.org/ntsb/CEN17CA114.md): Cessna 340A · Waukesha, WI · Accident · No injuries · Data collection · Final report · Feb 25, 2017 · N255BC · Substantial damage
  > The pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.
- [NTSB GAA17CA162](https://openairdocs.org/ntsb/GAA17CA162.md): Cessna T337 · Linden, NJ · Accident · No injuries · Data collection · Final report · Feb 24, 2017 · N685V · Substantial damage
  > The pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.
- [NTSB CEN17LA105](https://openairdocs.org/ntsb/CEN17LA105.md): American AA 1A · Gainesville, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 2017 · N6343L · Substantial damage
  > The pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing in a field. Contributing to the accident was the pilot’s delayed action in taking control of the…
- [NTSB CEN17LA118](https://openairdocs.org/ntsb/CEN17LA118.md): Thunder & Colt Airborne Amer AX10 180 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 20, 2017 · N709TC · Substantial damage
  > The pilot’s delayed reaction to the balloon’s increased rate of descent during an attempted landing, which resulted in impact with a power line.
- [NTSB GAA17CA147](https://openairdocs.org/ntsb/GAA17CA147.md): Cessna A185 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Feb 19, 2017 · N185AE · Substantial damage
  > The pilot's failure to maintain an appropriate glidepath to the runway and to use the vertical guidance system.
- [NTSB GAA17CA140](https://openairdocs.org/ntsb/GAA17CA140.md): Cessna 172 · Burlington, NC · Accident · No injuries · Data collection · Final report · Feb 16, 2017 · N381MG · Substantial damage
  > The pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.
- [NTSB ERA17FA106](https://openairdocs.org/ntsb/ERA17FA106.md): Beech C23 · Winder, GA · Accident · 2 fatal · Field investigation · Final report · Feb 16, 2017 · N24695 · Substantial damage
  > The flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.
- [NTSB GAA17CA138](https://openairdocs.org/ntsb/GAA17CA138.md): Beech T 34B · St. Petersburg, FL · Accident · No injuries · Data collection · Final report · Feb 11, 2017 · N18PS · Substantial damage
  > The pilot's failure to maintain an appropriate glidepath to the runway.
- [NTSB GAA17CA150](https://openairdocs.org/ntsb/GAA17CA150.md): Beech F90 · Poplar Bluff, MO · Accident · No injuries · Data collection · Final report · Feb 6, 2017 · N246CA · Substantial damage
  > The pilot’s descent below the minimum descent altitude during a nonprecision approach, which resulted in a tree strike.
- [NTSB GAA17CA131](https://openairdocs.org/ntsb/GAA17CA131.md): Cessna T210 · Loveland, CO · Accident · Minor injuries · Data collection · Final report · Feb 5, 2017 · N4853U · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.
- [NTSB WPR17LA059](https://openairdocs.org/ntsb/WPR17LA059.md): Beech E 55 · Bakersfield, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 2017 · N711YK · Substantial damage
  > The pilot’s failure to select the proper fuel boost pump setting for the left auxiliary fuel pump, which allowed for an excessive fuel flow to the left engine, which resulted in a total loss of engine power and airplane control during an attempted go-around.
- [NTSB ERA17LA105](https://openairdocs.org/ntsb/ERA17LA105.md): S C Aerostar S A YAK 52 · St. Elmo, AL · Accident · No injuries · Limited investigation · Final report · Feb 1, 2017 · N624PT · Substantial damage
  > The failure of the right main landing gear uplock actuator due to corrosion.
- [NTSB CEN17LA092](https://openairdocs.org/ntsb/CEN17LA092.md): Zenith CH750 Stol · Jennings, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2017 · N1972C · Substantial damage
  > A failure of the right fuel tank to supply fuel to the engine for reasons that could not be determined, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN17LA097](https://openairdocs.org/ntsb/CEN17LA097.md): Beech BE35 · Ozark, MO · Accident · Serious injuries · Limited investigation · Final report · Jan 26, 2017 · N4213B · Substantial damage
  > The pilot's failure to adequately monitor the environment and to maintain sufficient altitude to clear power lines.
- [NTSB CEN17FA084](https://openairdocs.org/ntsb/CEN17FA084.md): Cirrus Design SR22 · San Antonio, TX · Accident · 1 fatal · Field investigation · Final report · Jan 25, 2017 · N401SC · Destroyed
  > The pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.
- [NTSB DCA17RA058](https://openairdocs.org/ntsb/DCA17RA058.md): Boeing 747 · Bishkek, Kyrgyzstan · Accident · 39 fatal · Foreign investigation · Jan 16, 2017 · TC-MCL · Destroyed
  > The Government of Kyrgyzstan has notified the NTSB of an accident involving a BOEING 747 that occurred on January 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Kyrgyzstan's investigation under the provisions of…
- [NTSB ERA17CA087](https://openairdocs.org/ntsb/ERA17CA087.md): Cessna 170 · Hayden, AL · Accident · Serious injuries · Data collection · Final report · Jan 12, 2017 · N1387D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the approach.
- [NTSB ERA17WA086](https://openairdocs.org/ntsb/ERA17WA086.md): Cessna 172 · Tangara da Serra, Brazil · Accident · 2 fatal · Foreign investigation · Jan 5, 2017 · PR-GRS · Substantial damage
  > On January 5, 2017, at 1420 universal time coordinated, a Cessna 172S airplane, Brazilian registration PR-GRS, sustained substantial damage when it struck high-tension power-lines while attempting to land at the Tangara da Serra Airport (TGQ), State of Mato…
- [NTSB WPR17LA048](https://openairdocs.org/ntsb/WPR17LA048.md): Schosanski John H Cozy MK IV R · Napa, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 2017 · N4518S · Substantial damage
  > A partial loss of power due to missing apex seals.
- [NTSB CEN17LA068](https://openairdocs.org/ntsb/CEN17LA068.md): Mooney M20 · Nacogdoches, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 2017 · N1159G · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB GAA17CA108](https://openairdocs.org/ntsb/GAA17CA108.md): Larson Roger H RV-7 · Casa Grande, AZ · Accident · No injuries · Data collection · Final report · Jan 1, 2017 · N5897R · Substantial damage
  > The pilot’s inadvertent application of the autopilot during short final, which resulted in an aerodynamic stall and hard landing.
- [NTSB CEN17FA063](https://openairdocs.org/ntsb/CEN17FA063.md): Piper PA28R · McKinney, TX · Accident · 3 fatal · Field investigation · Final report · Dec 31, 2016 · N4407T · 2 aircraft · Destroyed
  > The other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.
- [NTSB DCA17WA056](https://openairdocs.org/ntsb/DCA17WA056.md): Boeing 737 · Paris, France · Incident · No injuries · Foreign investigation · Dec 30, 2016 · CN-ROJ · No damage
  > The Bureau d'Enquêtes et d'Analyses (BEA) of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…
- [NTSB WPR17LA043](https://openairdocs.org/ntsb/WPR17LA043.md): Robinson Helicopter R44 II · Mt. Baldy, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 2016 · N324RS · Substantial damage
  > The pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…
- [NTSB CEN17LA062](https://openairdocs.org/ntsb/CEN17LA062.md): Piper PA22 · Piedmont, MO · Accident · No injuries · Limited investigation · Final report · Dec 28, 2016 · N5499Z · Substantial damage
  > The pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.
- [NTSB WPR17LA042](https://openairdocs.org/ntsb/WPR17LA042.md): Air Tractor AT 602 · Willows, CA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2016 · N602L · Substantial damage
  > The decision of the maintenance facility mechanic to conduct maintenance without reference to the applicable manufacturer’s guidance, which resulted in the improper reassembly and subsequent failure of the engine compressor bleed valve, which in turn…
- [NTSB ERA17FA074](https://openairdocs.org/ntsb/ERA17FA074.md): Independent Technologies Epic LT · Port Orange, FL · Accident · 2 fatal · Field investigation · Final report · Dec 27, 2016 · N669WR · Substantial damage
  > The pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…
- [NTSB ERA17WA085](https://openairdocs.org/ntsb/ERA17WA085.md): Beech 58 · Tabatinga, Brazil · Accident · 3 fatal · Foreign investigation · Dec 23, 2016 · PT-ICU · Destroyed
  > On December 23, 2016, about 1830 universal coordinated time, a Beech 58, Brazilian registration PT-ICU, was destroyed when it impacted wooded terrain while on approach to Tabatinga International Airport (SBTT), Tabatinga, State of Amazonas, Brazil. The two…
- [NTSB GAA17CA103](https://openairdocs.org/ntsb/GAA17CA103.md): Piper PA28 · Shreveport, LA · Accident · Minor injuries · Data collection · Final report · Dec 22, 2016 · N9541W · Substantial damage
  > The pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.
- [NTSB CEN17LA060](https://openairdocs.org/ntsb/CEN17LA060.md): Cessna 175C · Millersburg, OH · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2016 · N8381T · Substantial damage
  > The pilot's improper in-flight fuel management and his failure to switch the fuel selector to the “both” position in accordance with the Before Landing checklist, which resulted in a loss of engine power due to fuel starvation.
- [NTSB CEN17LA059](https://openairdocs.org/ntsb/CEN17LA059.md): Cessna 210 · Longville, MN · Accident · No injuries · Limited investigation · Final report · Dec 20, 2016 · N80RB · Substantial damage
  > The in-flight encounter with wind shear and gusting wind conditions, which resulted in a bounced landing and runway excursion.

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

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

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