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

## Cases, newest first

- [NTSB LAX71FUQ30](https://openairdocs.org/ntsb/LAX71FUQ30.md): Cessna 170B · Pacoima, CA · Accident · Serious injuries · Closed · Oct 24, 1970 · N2875C · Substantial damage
- [NTSB IAD71AI017](https://openairdocs.org/ntsb/IAD71AI017.md): Beech A23-24 · Ocean City, MD · Accident · 4 fatal · Closed · Oct 24, 1970 · N7955L · Destroyed
- [NTSB FTW71DPD23](https://openairdocs.org/ntsb/FTW71DPD23.md): Cessna 150 · Crowley, TX · Accident · No injuries · Closed · Oct 24, 1970 · N2556J · Substantial damage
- [NTSB DEN71FXD33](https://openairdocs.org/ntsb/DEN71FXD33.md): Aeronca 0-58B · Loveland, CO · Accident · Minor injuries · Closed · Oct 24, 1970 · N46653 · Substantial damage
- [NTSB IAD71AI027](https://openairdocs.org/ntsb/IAD71AI027.md): Mooney M20C · Lynchburg, VA · Accident · No injuries · Closed · Oct 21, 1970 · N9170V · Substantial damage
- [NTSB CHI71AC025](https://openairdocs.org/ntsb/CHI71AC025-201433.md): Piper PA-31A · Fort Wayne, IN · Accident · 1 fatal · Closed · Oct 20, 1970 · N6637L · Destroyed
- [NTSB MKC71IK021](https://openairdocs.org/ntsb/MKC71IK021.md): Boeing 747 · Kansas City, MO · Incident · No injuries · Closed · Oct 19, 1970 · N93101 · Minor damage
- [NTSB CHI71DGD27](https://openairdocs.org/ntsb/CHI71DGD27.md): Piper PA-28 · Shelby, OH · Accident · No injuries · Closed · Oct 19, 1970 · N8182N · Substantial damage
- [NTSB NYC71FGM17](https://openairdocs.org/ntsb/NYC71FGM17.md): Piper PA-28 · Washington, PA · Accident · Serious injuries · Closed · Oct 18, 1970 · N8702N · Substantial damage
- [NTSB NYC71FFA21](https://openairdocs.org/ntsb/NYC71FFA21.md): Piper PA-22 · Duanesburg, NY · Accident · No injuries · Closed · Oct 18, 1970 · N2395P · Substantial damage
- [NTSB LAX71AL022](https://openairdocs.org/ntsb/LAX71AL022.md): Piper PA-28 · Gila Bend, AZ · Accident · No injuries · Closed · Oct 17, 1970 · N5071W · 2 aircraft · Substantial damage
- [NTSB MKC71AK019](https://openairdocs.org/ntsb/MKC71AK019.md): Piper PA-28R · Sidney, NE · Accident · 1 fatal · Closed · Oct 16, 1970 · N5026S · Destroyed
- [NTSB MIA71DLD25](https://openairdocs.org/ntsb/MIA71DLD25.md): Cessna 182K · Lutz, FL · Accident · No injuries · Closed · Oct 14, 1970 · N2813R · Substantial damage
- [NTSB LAX71DUJ37](https://openairdocs.org/ntsb/LAX71DUJ37.md): Beech 36 · Tucson, AZ · Accident · Minor injuries · Closed · Oct 14, 1970 · N7452N · Substantial damage
- [NTSB MKC71AK018](https://openairdocs.org/ntsb/MKC71AK018.md): Cessna 150E · Anoka, MN · Accident · No injuries · Closed · Oct 12, 1970 · N6200R · 2 aircraft · Substantial damage
- [NTSB MIA71FKQ16](https://openairdocs.org/ntsb/MIA71FKQ16.md): Bellanca 17-31 · Brandon, MS · Accident · No injuries · Closed · Oct 12, 1970 · N7351V · Substantial damage
- [NTSB IAD71FID10](https://openairdocs.org/ntsb/IAD71FID10.md): Beech A23-19 · Norfolk, VA · Accident · Serious injuries · Closed · Oct 12, 1970 · N2382W · Destroyed
- [NTSB SEA71FWA22](https://openairdocs.org/ntsb/SEA71FWA22.md): Cessna 180H · Battle Grnd, WA · Accident · No injuries · Closed · Oct 11, 1970 · N9907V · Substantial damage
- [NTSB MIA71FKJ25](https://openairdocs.org/ntsb/MIA71FKJ25.md): Cessna 182B · Elberta, AL · Accident · No injuries · Closed · Oct 11, 1970 · N7238E · Substantial damage
- [NTSB NYC71AN047](https://openairdocs.org/ntsb/NYC71AN047.md): Lockheed Ga 382B · Wrightstown, NJ · Accident · 3 fatal · Closed · Oct 10, 1970 · N9248R · Destroyed
- [NTSB OAK71FVW13](https://openairdocs.org/ntsb/OAK71FVW13.md): Piper PA-28 · Lida Junction, NV · Accident · No injuries · Closed · Oct 9, 1970 · N7286W · Substantial damage
- [NTSB MIA71FKT10](https://openairdocs.org/ntsb/MIA71FKT10.md): Piper PA-23 · Hollywood Bch, FL · Accident · No injuries · Closed · Oct 9, 1970 · N3294P · Substantial damage
- [NTSB MIA71DKG42](https://openairdocs.org/ntsb/MIA71DKG42.md): Cessna 172 · Twin City, GA · Accident · No injuries · Closed · Oct 8, 1970 · N35368 · Substantial damage
- [NTSB MIA71FLD23](https://openairdocs.org/ntsb/MIA71FLD23.md): Cessna 177 · Ft.Pierce, FL · Accident · Serious injuries · Closed · Oct 6, 1970 · N2322Y · Destroyed
- [NTSB FTW71FRA23](https://openairdocs.org/ntsb/FTW71FRA23.md): Amer Avco AA-1 · Houston, TX · Accident · Serious injuries · Closed · Oct 6, 1970 · N5996L · Destroyed
- [NTSB SEA71FXM13](https://openairdocs.org/ntsb/SEA71FXM13.md): Cessna 180 · Hailey, ID · Accident · Serious injuries · Closed · Oct 5, 1970 · N3144C · Destroyed
- [NTSB CHI71FDJ19](https://openairdocs.org/ntsb/CHI71FDJ19.md): Cessna 150J · Eau Claire, WI · Accident · Serious injuries · Closed · Oct 5, 1970 · N61357 · Destroyed
- [NTSB OAK71DVM23](https://openairdocs.org/ntsb/OAK71DVM23.md): Beech C35 · Calif Vally, CA · Accident · No injuries · Closed · Oct 4, 1970 · N1876D · Substantial damage
- [NTSB NYC71FHJ15](https://openairdocs.org/ntsb/NYC71FHJ15.md): Howard DGA15P · East Moriches, NY · Accident · No injuries · Closed · Oct 4, 1970 · N1149V · Substantial damage
- [NTSB NYC71AN043](https://openairdocs.org/ntsb/NYC71AN043.md): Aero Comdr 500-B · Mahaffey, PA · Accident · 2 fatal · Closed · Oct 4, 1970 · N701X · Destroyed
- [NTSB IAD70DLJ15](https://openairdocs.org/ntsb/IAD70DLJ15.md): Cessna 150 · Edenton, NC · Accident · Serious injuries · Closed · Oct 4, 1970 · N50572 · Substantial damage
- [NTSB OAK71DVA35](https://openairdocs.org/ntsb/OAK71DVA35.md): Cessna 182 · Selma, CA · Accident · Minor injuries · Closed · Oct 3, 1970 · N2840Y · Substantial damage
- [NTSB NYC71FHG07](https://openairdocs.org/ntsb/NYC71FHG07.md): Piper PA-28 · Marietta, PA · Accident · No injuries · Closed · Oct 3, 1970 · N7847N · Substantial damage
- [NTSB MKC71DCJ24](https://openairdocs.org/ntsb/MKC71DCJ24.md): Beech 95-C55 · Omaha, NE · Accident · No injuries · Closed · Oct 3, 1970 · N9591Q · Substantial damage
- [NTSB FTW71FPD22](https://openairdocs.org/ntsb/FTW71FPD22.md): Beech V35B · Euless, TX · Accident · Serious injuries · Closed · Oct 3, 1970 · N9029Q · Destroyed
- [NTSB SEA71DWG24](https://openairdocs.org/ntsb/SEA71DWG24.md): Piper PA-28R · Kamiah, ID · Accident · No injuries · Closed · Oct 2, 1970 · N3887T · Substantial damage
- [NTSB SEA71DVQ12](https://openairdocs.org/ntsb/SEA71DVQ12.md): Cessna 172 · Lakeview, OR · Accident · No injuries · Closed · Oct 2, 1970 · N1823Y · Substantial damage
- [NTSB MKC71FCJ23](https://openairdocs.org/ntsb/MKC71FCJ23.md): Cessna 172 · Pleasnt Dale, NE · Accident · Minor injuries · Closed · Sep 30, 1970 · N5602T · Substantial damage
- [NTSB DEN71FQA16](https://openairdocs.org/ntsb/DEN71FQA16.md): Stinson 108-2 · Espanola, NM · Accident · No injuries · Closed · Sep 30, 1970 · N9558K · Substantial damage
- [NTSB ANC71DAG31](https://openairdocs.org/ntsb/ANC71DAG31.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Closed · Sep 29, 1970 · N2581M · Substantial damage
- [NTSB SEA71FWG23](https://openairdocs.org/ntsb/SEA71FWG23.md): Taylorcraft BC12-D · Lowden, WA · Accident · 1 fatal · Closed · Sep 28, 1970 · N96265 · Destroyed
- [NTSB OAK71FJA05](https://openairdocs.org/ntsb/OAK71FJA05.md): Piper PA-28 · Waipahu, HI · Accident · No injuries · Closed · Sep 28, 1970 · N5702U · Substantial damage
- [NTSB CHI71AC023](https://openairdocs.org/ntsb/CHI71AC023.md): Cessna 150 · Mackinaw, IL · Accident · 2 fatal · Closed · Sep 28, 1970 · N5901E · Destroyed
- [NTSB SEA71FWG22](https://openairdocs.org/ntsb/SEA71FWG22.md): Piper J3C-65 · Coulee Dam, WA · Accident · No injuries · Closed · Sep 27, 1970 · N3591K · Substantial damage
- [NTSB SEA71DWD15](https://openairdocs.org/ntsb/SEA71DWD15.md): Cessna 172 · Kenmore, WA · Accident · No injuries · Closed · Sep 27, 1970 · N7234G · Substantial damage
- [NTSB SEA71DWA19](https://openairdocs.org/ntsb/SEA71DWA19.md): Erco 415-C · Wallowa, OR · Accident · No injuries · Closed · Sep 27, 1970 · N99196 · Substantial damage
- [NTSB FTW71DQG38](https://openairdocs.org/ntsb/FTW71DQG38.md): Piper PA-32 · Sonora, TX · Accident · No injuries · Closed · Sep 25, 1970 · N7736J · Substantial damage
- [NTSB CAN71AP907](https://openairdocs.org/ntsb/CAN71AP907.md): Cessna T337B · Cranbrook, Canada · Accident · 4 fatal · Closed · Sep 22, 1970 · N2346S · Destroyed
- [NTSB OAK71DVG28](https://openairdocs.org/ntsb/OAK71DVG28.md): Cessna 150G · Sacramento, CA · Accident · No injuries · Closed · Sep 20, 1970 · N5117G · Substantial damage
- [NTSB NYC71DFG07](https://openairdocs.org/ntsb/NYC71DFG07.md): Cessna 150G · Rochester, NH · Accident · No injuries · Closed · Sep 20, 1970 · N8339J · Substantial damage

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

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

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