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

## Cases, newest first

- [NTSB LAX71FUQ11](https://openairdocs.org/ntsb/LAX71FUQ11.md): Cessna 177 · Van Nuys, CA · Accident · No injuries · Closed · Aug 21, 1970 · N30151 · Substantial damage
- [NTSB IAD71FIG09](https://openairdocs.org/ntsb/IAD71FIG09.md): Cessna 170B · Taneytown, MD · Accident · No injuries · Closed · Aug 21, 1970 · N1648D · Destroyed
- [NTSB MIA71FKG22](https://openairdocs.org/ntsb/MIA71FKG22.md): Piper PA-28R · East Point, GA · Accident · Minor injuries · Closed · Aug 20, 1970 · N3207R · Substantial damage
- [NTSB LAX71DUJ17](https://openairdocs.org/ntsb/LAX71DUJ17.md): Aero Comdr 100 · Flagstaff, AZ · Accident · Minor injuries · Closed · Aug 19, 1970 · N3736X · Substantial damage
- [NTSB CHI71FDJ13](https://openairdocs.org/ntsb/CHI71FDJ13.md): Luscombe 8E · Cottage Grove, WI · Accident · No injuries · Closed · Aug 19, 1970 · N39028 · Substantial damage
- [NTSB DEN71AD005](https://openairdocs.org/ntsb/DEN71AD005.md): Mooney M20E · Cody, WY · Accident · 2 fatal · Closed · Aug 17, 1970 · N6937U · Destroyed
- [NTSB OAK71FVD05](https://openairdocs.org/ntsb/OAK71FVD05.md): N.American P-51D · Concord, CA · Accident · Serious injuries · Closed · Aug 16, 1970 · N5410V · Destroyed
- [NTSB MIA71DLG06](https://openairdocs.org/ntsb/MIA71DLG06.md): Schleicher ASW-15 · Chester, SC · Accident · Minor injuries · Closed · Aug 16, 1970 · N291W · Substantial damage
- [NTSB IAD71DIJ07](https://openairdocs.org/ntsb/IAD71DIJ07.md): Mooney M20C · Huntington, WV · Accident · Serious injuries · Closed · Aug 16, 1970 · N9710M · Substantial damage
- [NTSB CHI71FDW10](https://openairdocs.org/ntsb/CHI71FDW10.md): Cessna 172E · Pontiac, MI · Accident · Serious injuries · Closed · Aug 16, 1970 · N5581T · Destroyed
- [NTSB MIA71AM016](https://openairdocs.org/ntsb/MIA71AM016.md): Hughes 269B · Memphis, TN · Accident · 2 fatal · Closed · Aug 15, 1970 · N9304F · Destroyed
- [NTSB OAK71FVM08](https://openairdocs.org/ntsb/OAK71FVM08.md): Globe GC-1B · Morgan Hill, CA · Accident · 1 fatal · Closed · Aug 14, 1970 · N3371K · Destroyed
- [NTSB CHI71FGD12](https://openairdocs.org/ntsb/CHI71FGD12.md): Cessna 150 · Tiffin, OH · Accident · No injuries · Closed · Aug 14, 1970 · N23301 · 2 aircraft · Minor damage
- [NTSB SEA71FDA04](https://openairdocs.org/ntsb/SEA71FDA04.md): Piper PA-18A · Garryowen, MT · Accident · No injuries · Closed · Aug 13, 1970 · N1190C · Substantial damage
- [NTSB LAX71DUG09](https://openairdocs.org/ntsb/LAX71DUG09.md): Piper PA-28 · El Monte, CA · Accident · No injuries · Closed · Aug 13, 1970 · N98092 · Substantial damage
- [NTSB FTW71DPG18](https://openairdocs.org/ntsb/FTW71DPG18.md): Cessna 210A · Monterrey, Mexico · Accident · Minor injuries · Closed · Aug 13, 1970 · N100AM · Substantial damage
- [NTSB MIA71FKD04](https://openairdocs.org/ntsb/MIA71FKD04.md): Piper PA-28 · Birmingham, AL · Accident · No injuries · Closed · Aug 11, 1970 · N1692J · Substantial damage
- [NTSB NYC71DHG03](https://openairdocs.org/ntsb/NYC71DHG03.md): Cessna 150H · Herricksville, PA · Accident · Minor injuries · Closed · Aug 9, 1970 · N7129S · Substantial damage
- [NTSB NYC71AN018](https://openairdocs.org/ntsb/NYC71AN018.md): N.American B-25J · Orange, MA · Accident · 1 fatal · Closed · Aug 9, 1970 · N3443G · Destroyed
- [NTSB LAX71FUA14](https://openairdocs.org/ntsb/LAX71FUA14.md): Beech P35 · Huntngton B, CA · Accident · No injuries · Closed · Aug 9, 1970 · N985Q · Substantial damage
- [NTSB ANC71AA010](https://openairdocs.org/ntsb/ANC71AA010.md): Piper J3C-65 · Gulkana, AK · Accident · 2 fatal · Closed · Aug 9, 1970 · N3598N · Destroyed
- [NTSB DCA71R0002](https://openairdocs.org/ntsb/DCA71R0002.md): Convair 990 · Acapulco, Mexico · Accident · Serious injuries · Closed · Aug 8, 1970 · N5603 · Destroyed
- [NTSB CHI71AC012](https://openairdocs.org/ntsb/CHI71AC012.md): Cessna 402 · Watertown, WI · Accident · Serious injuries · Closed · Aug 8, 1970 · N8139F · Destroyed
- [NTSB SEA71DWD09](https://openairdocs.org/ntsb/SEA71DWD09.md): Bell 47G3B1 · Diablo, WA · Accident · Minor injuries · Closed · Aug 7, 1970 · N1182W · Substantial damage
- [NTSB MKC71DDQ05](https://openairdocs.org/ntsb/MKC71DDQ05.md): Piper PA-18 · Opal, SD · Accident · No injuries · Closed · Aug 7, 1970 · N7113K · Substantial damage
- [NTSB MKC71FCJ14](https://openairdocs.org/ntsb/MKC71FCJ14.md): Piper PA-25 · Minden, NE · Accident · 1 fatal · Closed · Aug 4, 1970 · N8580L · Destroyed
- [NTSB NYC71FGM07](https://openairdocs.org/ntsb/NYC71FGM07.md): Piper PA-24 · Butler, PA · Accident · No injuries · Closed · Aug 3, 1970 · N5788P · Substantial damage
- [NTSB DEN71AD004](https://openairdocs.org/ntsb/DEN71AD004.md): Cessna 177 · Montrose, CO · Accident · No injuries · Closed · Aug 3, 1970 · N2901X · Substantial damage
- [NTSB SEA71DWD08](https://openairdocs.org/ntsb/SEA71DWD08-201676.md): Schweizer SGS233 · North Plains, OR · Accident · No injuries · Closed · Aug 2, 1970 · N7761S · Substantial damage
- [NTSB MKC71DCD17](https://openairdocs.org/ntsb/MKC71DCD17.md): Cessna 150K · Iowa Falls, IA · Accident · No injuries · Closed · Aug 2, 1970 · N5684G · Substantial damage
- [NTSB MIA71DKJ08](https://openairdocs.org/ntsb/MIA71DKJ08.md): Piper PA-32 · Marion Junctn, AL · Accident · No injuries · Closed · Aug 2, 1970 · N5598J · Substantial damage
- [NTSB IAD71FIG06](https://openairdocs.org/ntsb/IAD71FIG06.md): Erco 415-C · Cumberland, MD · Accident · Serious injuries · Closed · Aug 2, 1970 · N2154H · Substantial damage
- [NTSB FTW71DRA09](https://openairdocs.org/ntsb/FTW71DRA09.md): Piper PA-32 · Beeville, TX · Accident · No injuries · Closed · Aug 1, 1970 · N3707W · Substantial damage
- [NTSB FTW71DPJ10](https://openairdocs.org/ntsb/FTW71DPJ10.md): Cessna 172K · Eakly, OK · Accident · Minor injuries · Closed · Aug 1, 1970 · N79252 · Substantial damage
- [NTSB NYC71AN013](https://openairdocs.org/ntsb/NYC71AN013.md): Piper PA-23 · Muncy, PA · Accident · 1 fatal · Closed · Jul 31, 1970 · N6753Y · Destroyed
- [NTSB CAN71AC905](https://openairdocs.org/ntsb/CAN71AC905.md): Cessna 170B · Nestor Falls, Canada · Accident · 3 fatal · Closed · Jul 31, 1970 · N3426C · Substantial damage
- [NTSB NYC71FFM05](https://openairdocs.org/ntsb/NYC71FFM05.md): Cessna 172K · Harwinton, CT · Accident · Minor injuries · Closed · Jul 30, 1970 · N79319 · Destroyed
- [NTSB NYC71FFJ02](https://openairdocs.org/ntsb/NYC71FFJ02.md): Stinson 108-3 · Jamestown, NY · Accident · Serious injuries · Closed · Jul 29, 1970 · N739C · Destroyed
- [NTSB MKC71DCQ07](https://openairdocs.org/ntsb/MKC71DCQ07.md): Navion A · Meade, KS · Accident · No injuries · Closed · Jul 29, 1970 · N4182K · Substantial damage
- [NTSB NYC71FHD12](https://openairdocs.org/ntsb/NYC71FHD12.md): Piper PA-28R · Marlton, NJ · Accident · Serious injuries · Closed · Jul 28, 1970 · N2997R · Destroyed
- [NTSB IAD71FIJ05](https://openairdocs.org/ntsb/IAD71FIJ05-201089.md): Cessna 175A · Clarksburg, WV · Accident · Serious injuries · Closed · Jul 28, 1970 · N7920T · Destroyed
- [NTSB FTW71DRG10](https://openairdocs.org/ntsb/FTW71DRG10.md): Cessna 150J · Temple, TX · Accident · Minor injuries · Closed · Jul 27, 1970 · N60054 · Substantial damage
- [NTSB DCA71AZ002](https://openairdocs.org/ntsb/DCA71AZ002-79683.md): Douglas DC-8 · Naha Ab, JA · Accident · 4 fatal · Closed · Jul 27, 1970 · N785FT · Destroyed
- [NTSB FTW71FRD05](https://openairdocs.org/ntsb/FTW71FRD05.md): Cessna 182A · Covington, LA · Accident · Serious injuries · Closed · Jul 26, 1970 · N9981B · Substantial damage
- [NTSB FTW71DRG09](https://openairdocs.org/ntsb/FTW71DRG09.md): Aeronca 7BCM · Lampasas, TX · Accident · Serious injuries · Closed · Jul 26, 1970 · N73633 · Substantial damage
- [NTSB DEN71DQD01](https://openairdocs.org/ntsb/DEN71DQD01.md): Piper PA-24 · Rodeo, NM · Accident · No injuries · Closed · Jul 25, 1970 · N5134P · Substantial damage
- [NTSB OAK71DVW02](https://openairdocs.org/ntsb/OAK71DVW02.md): Mooney M20B · Lone Pine, CA · Accident · No injuries · Closed · Jul 24, 1970 · N74587 · Substantial damage
- [NTSB SEA71FWD06](https://openairdocs.org/ntsb/SEA71FWD06.md): Cessna 170 · Lester, WA · Accident · Serious injuries · Closed · Jul 22, 1970 · N2927D · Substantial damage
- [NTSB CHI71FDJ05](https://openairdocs.org/ntsb/CHI71FDJ05.md): Piper PA-28 · Green Bay, WI · Accident · Minor injuries · Closed · Jul 21, 1970 · N6667J · Substantial damage
- [NTSB CHI71FBQ04](https://openairdocs.org/ntsb/CHI71FBQ04.md): Stinson 108-1 · Ludlow, IL · Accident · No injuries · Closed · Jul 21, 1970 · N9215K · Substantial damage

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

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

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