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

## Cases, newest first

- [NTSB LAX90DUG01](https://openairdocs.org/ntsb/LAX90DUG01.md): Mannon-Underwood JEANIE'S Teenie · Hemet, CA · Accident · 1 fatal · Final report · Oct 21, 1989 · N63327 · Destroyed
  > Inadvertent stall experienced by the pilot and his lack of experience.
- [NTSB LAX90LA009](https://openairdocs.org/ntsb/LAX90LA009.md): Luscombe 8C · Casa Grande, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1989 · N23060 · Substantial damage
  > Pilot's inadequate compensation for adverse winds. Factors related to the accident were: the adverse wind conditions.
- [NTSB LAX90DUJ04](https://openairdocs.org/ntsb/LAX90DUJ04.md): Rand Engineering KR-II · Eloy, AZ · Accident · 1 fatal · Final report · Oct 20, 1989 · N120TM · Destroyed
  > The failure of the pilot to maintain control of the aircraft, and his failure to discontinue the approach when it became evident that the gusting cross winds were exceeding the ability of the aircraft.
- [NTSB NYC90LA014](https://openairdocs.org/ntsb/NYC90LA014.md): Cessna T337G · Pittsburgh, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1989 · N197 · Destroyed
  > The pilot's improper in-flight planning and decision, and diverting of his attention, which resulted in fuel exhaustion to both engines. Darkness and trees in the emergency landing area were related factors.
- [NTSB MKC90LA010](https://openairdocs.org/ntsb/MKC90LA010.md): Cessna 172 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N5336R · Substantial damage
  > Failure of the throttle cable assembly which resulted in a forced landing and subsequent collision with a fence.
- [NTSB ATL90LA009](https://openairdocs.org/ntsb/ATL90LA009.md): Cessna 210 · Kernersville, NC · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N1155M · Substantial damage
  > Improper fuel consumption calculations by the pilot, which resulted in fuel exhaustion from lack of fuel. Adverse weather conditions were related to the accident.
- [NTSB BFO90LA001](https://openairdocs.org/ntsb/BFO90LA001.md): Beech A65 · Friendly, MD · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1989 · N186M · Substantial damage
  > The pilot's improper use of his fuel supply, which resulted in fuel starvation and loss of power in the left engine. A factor related to the accident was the pilot's lack of familiarity with the aircraft.
- [NTSB SEA90LA006](https://openairdocs.org/ntsb/SEA90LA006.md): Piper PA28-180 · Homedale, ID · Accident · No injuries · Limited investigation · Final report · Oct 14, 1989 · N6651J · Substantial damage
  > Inaccurate preflight planning and fuel consumption calculations by the pilot, and the pilot becoming lost or disoriented which resulted in fuel exhaustion.
- [NTSB CHI90LA010](https://openairdocs.org/ntsb/CHI90LA010.md): Cessna 172M · Cedarburg, WI · Accident · No injuries · Limited investigation · Final report · Oct 14, 1989 · N1325U · Substantial damage
  > Delay of the flight instructor (CFI) in making a go-around and his failure to attain sufficient airspeed to climb after taking off again. The transmission wire (power line) and high vegetation were contributing factors.
- [NTSB CHI90LA009](https://openairdocs.org/ntsb/CHI90LA009.md): Cessna 152 · Lakeville, MI · Accident · No injuries · Limited investigation · Final report · Oct 14, 1989 · N94668 · Destroyed
  > Inadequate supervision of the flight by the flight instructor (CFI), failure of both the student and the CFI to see-and-avoid the static line, and failure of the pilots to maintain adequate clearance from the power line/static wire. The static wire was a…
- [NTSB MIA90LA011](https://openairdocs.org/ntsb/MIA90LA011.md): Beech 58P · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Oct 12, 1989 · N94JP · Substantial damage
  > The pilot's misunderstanding of the landing gear emergency extension procedure, which resulted in his inadvertent partial retraction of the gear and failure to land with the gear in the down and locked position. Loss of electrical power was a factor.
- [NTSB DEN90LA003](https://openairdocs.org/ntsb/DEN90LA003.md): Adams A55 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 8, 1989 · N1059S · Substantial damage
  > The pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.
- [NTSB NYC90LA006](https://openairdocs.org/ntsb/NYC90LA006.md): Cessna 152 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1989 · N69169 · Substantial damage
  > Inflight loss of control due to inadvertent retraction of the wing flaps during a go around.
- [NTSB CHI90FA003](https://openairdocs.org/ntsb/CHI90FA003.md): Piper PA-28-180 · Ann Arbor, MI · Accident · 3 fatal · Field investigation · Final report · Oct 7, 1989 · N9704J · Destroyed
  > Failure of the pilot to maintain sufficient airspeed, which resulted in an inadvertent stall. A factor related to the accident was the pilot's lack of experience in the aircraft.
- [NTSB LAX90FA002](https://openairdocs.org/ntsb/LAX90FA002.md): Piper PA-28RT-201T · Palm Springs, CA · Accident · 4 fatal · Field investigation · Final report · Oct 6, 1989 · N3063T · Destroyed
  > Improper in-flight planning/decision by the pilot, and his failure to follow wake turbulence avoidance procedures, which resulted in a vortex turbulence encounter. A factor related to the accident was: the pilot's failure to assure the aircraft was loaded…
- [NTSB FTW90DPJ01](https://openairdocs.org/ntsb/FTW90DPJ01.md): Zimmerman Moni Motorglider · Oklahoma City, OK · Accident · Minor injuries · Final report · Oct 4, 1989 · N15JZ · Substantial damage
  > Power loss due to the deteriorated muffler baffle which was not discovered in the recent annual inspection. A factor was the pilot's failure to properly analyze and correct for the headwind.
- [NTSB MKC90LA004](https://openairdocs.org/ntsb/MKC90LA004.md): Bellanca 17-30 · Gainesville, MO · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 1989 · N6569V · Substantial damage
  > The pilot's failure to compensate for wind conditions and to maintain runway alignment during the landing approach. Contributing to the accident was the turbulent conditions.
- [NTSB LAX90LA004](https://openairdocs.org/ntsb/LAX90LA004.md): North American SNJ-5 · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1989 · N12377 · Substantial damage
  > The pilot's misjudgement of the proper altitude and distance from the runway during a night approach.
- [NTSB FTW90FA002](https://openairdocs.org/ntsb/FTW90FA002.md): Cessna 550 · Hurdle Mills, NC · Accident · 2 fatal · Field investigation · Final report · Oct 2, 1989 · N53CC · Destroyed
  > Impairment of the pilot-in-command (PIC) due to drugs/medication, chemotherapy and fatigue; failure of the PIC to assure that the IFR (instrument) apch procedure was followed; and his failure to maintain the minimum descent altitude (mda). Inadequate…
- [NTSB SEA90LA001](https://openairdocs.org/ntsb/SEA90LA001.md): Piper PA-28R-180 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Oct 1, 1989 · N3782T · Substantial damage
  > The pilot misjudged his altitude and distance to the runway, while on final approach, and failed to attain the proper touchdown point or flare the aircraft during the landing. Darkness was a related factor.
- [NTSB SEA89LA181](https://openairdocs.org/ntsb/SEA89LA181.md): Cessna 152 · Alderwood Manor, WA · Accident · No injuries · Limited investigation · Final report · Sep 30, 1989 · N24995 · Substantial damage
  > Inadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…
- [NTSB SEA89FA182](https://openairdocs.org/ntsb/SEA89FA182.md): Piper PA-28-151 · Bridal Veil, OR · Accident · Serious injuries · Field investigation · Final report · Sep 30, 1989 · CGIWO · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: the adverse weather conditions, the pilot's lack of instrument experience,…
- [NTSB NYC89FA221](https://openairdocs.org/ntsb/NYC89FA221.md): Aeronca 65TL · Beaver Falls, PA · Accident · 1 fatal · Field investigation · Final report · Sep 30, 1989 · N33890 · Destroyed
  > The failure of the left wing, rear upper strut attachment. The failure was caused by not installing the retaining bolt and nut.
- [NTSB CHI89FA196](https://openairdocs.org/ntsb/CHI89FA196.md): Beech A36TC · Greencastle, IN · Accident · 3 fatal · Field investigation · Final report · Sep 30, 1989 · N2YS · Destroyed
  > Failure of the pilot to maintain proper altitude during a visual approach at dusk. Factors related to the accident were: light conditions at dusk, the pilot's visual perception, and the trees.
- [NTSB LAX89LA333](https://openairdocs.org/ntsb/LAX89LA333.md): Bellanca 17-30A · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1989 · N8272R · Substantial damage
  > A loss of engine power due to fuel starvation. The fuel starvation was the result of vane particles from the deteriorated electric fuel pump restricting the upstream flow of fuel.
- [NTSB ANC89LA176](https://openairdocs.org/ntsb/ANC89LA176.md): Cessna 185 · Trading Bay, AK · Accident · No injuries · Limited investigation · Final report · Sep 29, 1989 · N64399 · Substantial damage
  > Pilot in commands failure to perform an adequate visual approach resulting in collision with a tree.
- [NTSB ATL89FA220](https://openairdocs.org/ntsb/ATL89FA220.md): Aerospatiale AS 350D · Chamblee, GA · Accident · 1 fatal · Field investigation · Final report · Sep 28, 1989 · N57689 · Destroyed
  > Failure of the main rotor swashplate bearing due to lack of lubricant.
- [NTSB ANC89DAG02](https://openairdocs.org/ntsb/ANC89DAG02.md): Evanson Long EZ/52 · Palmer, AK · Accident · 1 fatal · Final report · Sep 28, 1989 · N52AK · Substantial damage
  > Pilot-in-command's failure to maintain the proper altitude.
- [NTSB LAX89LA331](https://openairdocs.org/ntsb/LAX89LA331.md): Robinson R22 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Sep 27, 1989 · N9078U · Substantial damage
  > Improper in-flight planning/decision by the instructor pilot (CFI). Factors related to the accident were: the cfi's lack of familiarity with the geographic area, and the fence.
- [NTSB SEA89LA178](https://openairdocs.org/ntsb/SEA89LA178.md): Piper PA-32-260 · Portland, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1989 · N3660W · Substantial damage
  > The pilot's poor inflight planning. Contributing to the accident was the wake turbulence and remedial action not possible.
- [NTSB LAX89LA329](https://openairdocs.org/ntsb/LAX89LA329.md): Piper PA-25-235 · Warner Springs, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1989 · N4450Y · Substantial damage
  > Loss of engine power for an unknown reason. The obstruction (tree) was a factor.
- [NTSB LAX89LA323](https://openairdocs.org/ntsb/LAX89LA323.md): Cessna 177RG · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Sep 26, 1989 · N52665 · Substantial damage
  > A loss of engine power due to the pilot's improper use of the aircraft's powerplant controls. A contributing factor was the pilot's limited experience in a Cessna 177RG.
- [NTSB ATL89IA219](https://openairdocs.org/ntsb/ATL89IA219.md): Canadair CL-44 · Greensboro, NC · Incident · No injuries · Incident investigation · Final report · Sep 26, 1989 · N104BB · No damage
  > The first officer's failure to follow approved missed approach procedures, and his attempt to take the flight controls from the captain who was flying the airplane.
- [NTSB LAX89LA322](https://openairdocs.org/ntsb/LAX89LA322.md): Bellanca Citabria · Auburn, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1989 · N1679G · Substantial damage
  > The pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.
- [NTSB LAX89LA321](https://openairdocs.org/ntsb/LAX89LA321.md): Cessna 150 · Paradise, CA · Accident · No injuries · Limited investigation · Final report · Sep 23, 1989 · N6215G · Substantial damage
  > The pilot's failure to adequately compensate for the existing wind conditions and to maintain adequate airspeed. Contributing to the accident were the adverse wind conditions.
- [NTSB FTW89DRD16](https://openairdocs.org/ntsb/FTW89DRD16.md): Sours/Midget Mustang SM-1 · Franklinton, LA · Accident · Serious injuries · Final report · Sep 23, 1989 · N2AT · Destroyed
  > A total loss of engine power for undetermined reasons. Trees in the emergency landing area were a related factor.
- [NTSB FTW89FA171](https://openairdocs.org/ntsb/FTW89FA171.md): Piper PA-22-150 · Elgin, TX · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1989 · N4329A · Destroyed
  > The pilot's inadvertent closure (deactivation) of the mixture control, which resulted in a loss of engine power, and his failure to maintain sufficient airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the gusty wind, and…
- [NTSB CHI89LA193](https://openairdocs.org/ntsb/CHI89LA193.md): American AA-1A · Medina, OH · Accident · No injuries · Limited investigation · Final report · Sep 22, 1989 · N9332L · Substantial damage
  > The pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…
- [NTSB ATL89LA216](https://openairdocs.org/ntsb/ATL89LA216.md): Piper PA-28-181 · Cleveland, TN · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1989 · N43804 · Destroyed
  > The improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.
- [NTSB LAX89LA316](https://openairdocs.org/ntsb/LAX89LA316.md): Piper PA-22 · Winkelman, AZ · Accident · No injuries · Limited investigation · Final report · Sep 20, 1989 · N3015Z · Substantial damage
  > Improper in-flight planning/decision by the pilot, after he became lost/disoriented, which resulted in fuel exhaustion, before he was able to complete a precautionary landing. Factors related to the accident were: darkness, the pilot's lack of visual cues at…
- [NTSB CHI89LA190](https://openairdocs.org/ntsb/CHI89LA190.md): Piper PA-28R-201 · Delphi, IN · Accident · No injuries · Limited investigation · Final report · Sep 17, 1989 · N9816C · Substantial damage
  > The pilot-in-command's failure to properly compensate for the high sink rate that developed on final approach to land. Factors related to the accident were: the downdraft and the student pilot's failure to maintain a proper rate of descent on final approach.
- [NTSB FTW89FA166](https://openairdocs.org/ntsb/FTW89FA166.md): Beech BE 100 · Houston, TX · Accident · Serious injuries · Field investigation · Final report · Sep 16, 1989 · N204AJ · Destroyed
  > The inadequate preflight planning preparation & the improper inflight planning/decision by the PIC when he failed to refuel the aircraft which resulted in a total loss of power in both engines.
- [NTSB FTW89DRG10](https://openairdocs.org/ntsb/FTW89DRG10.md): Zenair CH-200 · Kerrville, TX · Accident · 1 fatal · Final report · Sep 16, 1989 · N14LU · Destroyed
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.
- [NTSB ATL89FA213](https://openairdocs.org/ntsb/ATL89FA213.md): Beech 100 · Mayfield, KY · Accident · 6 fatal · Field investigation · Final report · Sep 16, 1989 · N887PE · Destroyed
  > Failure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness, the adverse weather conditions, and the tree.
- [NTSB MIA89LA250](https://openairdocs.org/ntsb/MIA89LA250.md): Piper PA-38-112 · Fernandina Bch, FL · Accident · No injuries · Limited investigation · Final report · Sep 15, 1989 · N91344 · Substantial damage
  > The private pilot's failure to maintain airspeed on final approach, which resulted in a stall/mush. The turbulence was a related factor.
- [NTSB FTW89IA168](https://openairdocs.org/ntsb/FTW89IA168.md): Cessna 152 · Bethany, OK · Incident · No injuries · Incident investigation · Final report · Sep 15, 1989 · N94808 · 2 aircraft · Minor damage
  > Failure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…
- [NTSB DEN89FA217](https://openairdocs.org/ntsb/DEN89FA217.md): Piper PA-31T2 · Louisville, CO · Accident · 3 fatal · Field investigation · Final report · Sep 15, 1989 · N63XL · Destroyed
  > Failure of the pilot to maintain adequate airspeed, while maneuvering for spacing in the traffic pattern, which resulted in an inadvertent stall at low altitude.
- [NTSB LAX89LA312](https://openairdocs.org/ntsb/LAX89LA312.md): Cessna 152 · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1989 · N49697 · Substantial damage
  > Improper in-flight planning/decision by the student pilot. Contributing factors were the parked aircraft, hangar, and the student pilot's lack of total experience.
- [NTSB DEN89LA216](https://openairdocs.org/ntsb/DEN89LA216.md): Cessna 172N · Provo, UT · Accident · No injuries · Limited investigation · Final report · Sep 14, 1989 · N75815 · Substantial damage
  > The pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.
- [NTSB MIA89IA247](https://openairdocs.org/ntsb/MIA89IA247.md): Beech G18S · Jackson, MS · Incident · No injuries · Incident investigation · Final report · Sep 13, 1989 · N9604R · Minor damage
  > Failure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.

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

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

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