# 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 346 of 420 · 20,996 cases

## Cases, newest first

- [NTSB MKC70FCA17](https://openairdocs.org/ntsb/MKC70FCA17.md): Cessna 182L · Hillsboro, MO · Accident · Serious injuries · Closed · Jun 26, 1970 · N3381R · Substantial damage
- [NTSB LAX70FUM12](https://openairdocs.org/ntsb/LAX70FUM12.md): Cessna A-188 · Calipatria, CA · Accident · No injuries · Closed · Jun 26, 1970 · N8079V · Substantial damage
- [NTSB MKC70DCJ32](https://openairdocs.org/ntsb/MKC70DCJ32.md): Piper PA-28 · S.Sioux City, NE · Accident · No injuries · Closed · Jun 25, 1970 · N8259N · Substantial damage
- [NTSB FTW71FPJ05](https://openairdocs.org/ntsb/FTW71FPJ05.md): Stinson 108-1 · Edmond, OK · Accident · Serious injuries · Closed · Jun 25, 1970 · N97835 · Substantial damage
- [NTSB SEA70DWD21](https://openairdocs.org/ntsb/SEA70DWD21.md): Cessna 150 · Snohomish, WA · Accident · No injuries · Closed · Jun 23, 1970 · N6798S · Substantial damage
- [NTSB MKC70DCG33](https://openairdocs.org/ntsb/MKC70DCG33.md): Luscombe 8E · Amsterdam, MO · Accident · No injuries · Closed · Jun 23, 1970 · N2541K · Substantial damage
- [NTSB MIA70FKQ12](https://openairdocs.org/ntsb/MIA70FKQ12.md): Cessna 401 · Brookhaven, MS · Accident · No injuries · Closed · Jun 23, 1970 · N8083F · Substantial damage
- [NTSB CHI70DDJ25](https://openairdocs.org/ntsb/CHI70DDJ25.md): Cessna 182 · Milwaukee, WI · Accident · No injuries · Closed · Jun 23, 1970 · N9958B · Substantial damage
- [NTSB OAK70FXQ18](https://openairdocs.org/ntsb/OAK70FXQ18.md): Cessna 182K · Truckee, CA · Accident · Minor injuries · Closed · Jun 22, 1970 · N2563Q · Substantial damage
- [NTSB MKC70DCD41](https://openairdocs.org/ntsb/MKC70DCD41.md): Alon A-2 · Osceola, IA · Accident · Minor injuries · Closed · Jun 22, 1970 · N6591Q · Destroyed
- [NTSB IAD70DID22](https://openairdocs.org/ntsb/IAD70DID22.md): Alon A-2 · Hopewell, VA · Accident · Minor injuries · Closed · Jun 22, 1970 · N6597Q · Substantial damage
- [NTSB SEA70DWG18](https://openairdocs.org/ntsb/SEA70DWG18.md): Luscombe 8E · Okanogan, WA · Accident · Minor injuries · Closed · Jun 21, 1970 · N1243K · Substantial damage
- [NTSB SEA70DDA17](https://openairdocs.org/ntsb/SEA70DDA17.md): Piper PA-18 · Poplar, MT · Accident · No injuries · Closed · Jun 21, 1970 · N3595Z · Substantial damage
- [NTSB OAK70DVD28](https://openairdocs.org/ntsb/OAK70DVD28.md): Bensen B-8M · Tracy, CA · Accident · No injuries · Closed · Jun 21, 1970 · N8241 · Substantial damage
- [NTSB NYC70FGM23](https://openairdocs.org/ntsb/NYC70FGM23.md): Piper PA-28 · West Mifflin, PA · Accident · No injuries · Closed · Jun 21, 1970 · N7766W · Substantial damage
- [NTSB CHI70FBJ88](https://openairdocs.org/ntsb/CHI70FBJ88.md): Champion 7FC · Bath, MI · Accident · Minor injuries · Closed · Jun 21, 1970 · N9043B · Substantial damage
- [NTSB CHI70DBD47](https://openairdocs.org/ntsb/CHI70DBD47.md): Pitts Spcl · Monee, IL · Accident · No injuries · Closed · Jun 21, 1970 · N106KB · Substantial damage
- [NTSB SEA70FWA16](https://openairdocs.org/ntsb/SEA70FWA16.md): Hughes 269A · St Johns, OR · Accident · No injuries · Closed · Jun 20, 1970 · N8737F · Substantial damage
- [NTSB OAK70FXQ17](https://openairdocs.org/ntsb/OAK70FXQ17.md): Cessna 177 · Reno, NV · Accident · No injuries · Closed · Jun 20, 1970 · N3152T · Substantial damage
- [NTSB MKC70FDD18](https://openairdocs.org/ntsb/MKC70FDD18.md): Piper PA-25 · Casselton, ND · Accident · No injuries · Closed · Jun 20, 1970 · N6265Z · Substantial damage
- [NTSB LAX70FUJ44](https://openairdocs.org/ntsb/LAX70FUJ44.md): Piper PA-24 · Glendale, AZ · Accident · No injuries · Closed · Jun 20, 1970 · N6335P · Substantial damage
- [NTSB LAX70DUG54](https://openairdocs.org/ntsb/LAX70DUG54.md): Piper PA-28 · Adelanto, CA · Accident · No injuries · Closed · Jun 20, 1970 · N8875J · Substantial damage
- [NTSB FTW70DQG20](https://openairdocs.org/ntsb/FTW70DQG20.md): Piper PA-28 · Dimmitt, TX · Accident · Minor injuries · Closed · Jun 20, 1970 · N5215L · Substantial damage
- [NTSB SEA70FXM20](https://openairdocs.org/ntsb/SEA70FXM20.md): Grumman TBM · Boise, ID · Accident · 1 fatal · Closed · Jun 19, 1970 · N7026C · Destroyed
- [NTSB SEA70FWD20](https://openairdocs.org/ntsb/SEA70FWD20.md): Aero Comdr 560 · Bellevue, WA · Accident · No injuries · Closed · Jun 19, 1970 · N2661R · Substantial damage
- [NTSB CHI70FBA24](https://openairdocs.org/ntsb/CHI70FBA24.md): Cessna 170B · Greenwood, IN · Accident · Minor injuries · Closed · Jun 19, 1970 · N2903D · Substantial damage
- [NTSB MIA70FKT26](https://openairdocs.org/ntsb/MIA70FKT26.md): Piper PA-28 · W.Hollywood, FL · Accident · Minor injuries · Closed · Jun 18, 1970 · N5331W · Substantial damage
- [NTSB DEN70DVW20](https://openairdocs.org/ntsb/DEN70DVW20.md): Cessna 172 · Cedar City, UT · Accident · No injuries · Closed · Jun 18, 1970 · N3927F · Substantial damage
- [NTSB CHI70AC091](https://openairdocs.org/ntsb/CHI70AC091.md): Cessna 150G · Burlington, WI · Accident · No injuries · Closed · Jun 18, 1970 · N2213J · 2 aircraft · Minor damage
- [NTSB OAK70FVG34](https://openairdocs.org/ntsb/OAK70FVG34.md): Cessna 150C · Napa, CA · Accident · Serious injuries · Closed · Jun 17, 1970 · N7835Z · Substantial damage
- [NTSB MKC70FDQ10](https://openairdocs.org/ntsb/MKC70FDQ10.md): Aeronca 7CCM · Hayes, SD · Accident · Serious injuries · Closed · Jun 17, 1970 · N82616 · Substantial damage
- [NTSB CHI70FBQ22](https://openairdocs.org/ntsb/CHI70FBQ22.md): Piper PA-28 · Mattoon, IL · Accident · No injuries · Closed · Jun 17, 1970 · N5815U · Substantial damage
- [NTSB MKC70DCQ27](https://openairdocs.org/ntsb/MKC70DCQ27.md): Piper J3C-65 · Sterling, KS · Accident · No injuries · Closed · Jun 16, 1970 · N2785C · Substantial damage
- [NTSB SEA70AS047](https://openairdocs.org/ntsb/SEA70AS047.md): Meyers OTW · Scappoose, OR · Accident · 3 fatal · Closed · Jun 14, 1970 · N34324 · 2 aircraft · Destroyed
- [NTSB NYC70DHD42](https://openairdocs.org/ntsb/NYC70DHD42.md): Piper PA-28 · Moorestown, NJ · Accident · No injuries · Closed · Jun 14, 1970 · N7228W · Substantial damage
- [NTSB CHI70FGJ15](https://openairdocs.org/ntsb/CHI70FGJ15.md): Aeronca 65-TAC · Lebanon, KY · Accident · Serious injuries · Closed · Jun 14, 1970 · N39563 · Substantial damage
- [NTSB FTW70FRA31](https://openairdocs.org/ntsb/FTW70FRA31.md): Cessna 150J · Houston, TX · Accident · No injuries · Closed · Jun 13, 1970 · N60559 · Substantial damage
- [NTSB FTW70FPD16](https://openairdocs.org/ntsb/FTW70FPD16.md): Cessna 150 · Fort Worth, TX · Accident · No injuries · Closed · Jun 13, 1970 · N60730 · Substantial damage
- [NTSB LAX70FUG44](https://openairdocs.org/ntsb/LAX70FUG44.md): Piper PA-28 · Hesperia, CA · Accident · No injuries · Closed · Jun 12, 1970 · N8152N · Substantial damage
- [NTSB MKC70DCD38](https://openairdocs.org/ntsb/MKC70DCD38.md): Cessna 172F · Harlan, IA · Accident · No injuries · Closed · Jun 11, 1970 · N8817U · Substantial damage
- [NTSB FTW70FQG22](https://openairdocs.org/ntsb/FTW70FQG22.md): Amer Avco AA-1 · Lubbock, TX · Accident · No injuries · Closed · Jun 10, 1970 · N5904L · Substantial damage
- [NTSB DEN70FQA26](https://openairdocs.org/ntsb/DEN70FQA26.md): Cessna 150 · Albuquerque, NM · Accident · No injuries · Closed · Jun 10, 1970 · N60266 · Substantial damage
- [NTSB CHI70FBD41](https://openairdocs.org/ntsb/CHI70FBD41.md): Aeronca 11AC · Arlington, IL · Accident · Serious injuries · Closed · Jun 10, 1970 · N9491E · Substantial damage
- [NTSB CHI70DGD01](https://openairdocs.org/ntsb/CHI70DGD01.md): Beech 33 · Cleveland, OH · Accident · No injuries · Closed · Jun 10, 1970 · N8953M · Substantial damage
- [NTSB NYC70FHJ10](https://openairdocs.org/ntsb/NYC70FHJ10.md): Cessna 150 · Farmingdale, NY · Accident · Minor injuries · Closed · Jun 9, 1970 · N60520 · Substantial damage
- [NTSB MKC70FDM32](https://openairdocs.org/ntsb/MKC70FDM32.md): Beech 35-33 · Rochester, MN · Accident · No injuries · Closed · Jun 9, 1970 · N615V · Substantial damage
- [NTSB ANC70DAG36](https://openairdocs.org/ntsb/ANC70DAG36.md): Piper PA-18 · Russian Mssn, AK · Accident · No injuries · Closed · Jun 9, 1970 · N8566C · Substantial damage
- [NTSB NYC70FFJ12](https://openairdocs.org/ntsb/NYC70FFJ12.md): Cessna 150 · Geneva, NY · Accident · No injuries · Closed · Jun 7, 1970 · N5724G · Substantial damage
- [NTSB MKC70AK069](https://openairdocs.org/ntsb/MKC70AK069.md): Piper PA-28 · Lyndon, KS · Accident · 2 fatal · Closed · Jun 7, 1970 · N7808N · Destroyed
- [NTSB LAX70DUJ40](https://openairdocs.org/ntsb/LAX70DUJ40.md): Piper PA-28 · Maricopa, AZ · Accident · No injuries · Closed · Jun 7, 1970 · N9819W · Substantial damage

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.