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

## Cases, newest first

- [NTSB CHI71DDJ43](https://openairdocs.org/ntsb/CHI71DDJ43.md): Cessna A150K · Appleton, WI · Accident · Minor injuries · Closed · Feb 9, 1971 · N8336M · Substantial damage
- [NTSB MIA71AM069](https://openairdocs.org/ntsb/MIA71AM069.md): Cessna 170B · Clinton, MS · Accident · 1 fatal · Closed · Feb 7, 1971 · N3438D · Destroyed
- [NTSB IAD71DID20](https://openairdocs.org/ntsb/IAD71DID20.md): Taylorcraft BC12-D · Ararat, VA · Accident · Minor injuries · Closed · Feb 6, 1971 · N95867 · Destroyed
- [NTSB FTW71DRG78](https://openairdocs.org/ntsb/FTW71DRG78.md): Piper J-3 · Lytle, TX · Accident · No injuries · Closed · Feb 6, 1971 · N1414 · Destroyed
- [NTSB LAX71FUM26](https://openairdocs.org/ntsb/LAX71FUM26.md): Cessna 150 · Chula Vista, CA · Accident · No injuries · Closed · Feb 4, 1971 · N50265 · Substantial damage
- [NTSB MKC71FCJ45](https://openairdocs.org/ntsb/MKC71FCJ45.md): Aero Cmdr 1121 · Omaha, NE · Accident · No injuries · Closed · Feb 3, 1971 · N399D · Substantial damage
- [NTSB MIA71DKG61](https://openairdocs.org/ntsb/MIA71DKG61.md): Cessna 310 · Cornelia, GA · Accident · No injuries · Closed · Feb 3, 1971 · N6846T · Substantial damage
- [NTSB MIA71AM065](https://openairdocs.org/ntsb/MIA71AM065.md): Aero Comdr 520 · Columbia, SC · Accident · 6 fatal · Closed · Feb 3, 1971 · N4190B · Destroyed
- [NTSB NYC71FHM17](https://openairdocs.org/ntsb/NYC71FHM17.md): Beech G35 · Morristown, NJ · Accident · No injuries · Closed · Jan 31, 1971 · N4667D · Substantial damage
- [NTSB NYC71FGM29](https://openairdocs.org/ntsb/NYC71FGM29.md): Luscombe 8E · Dubois, PA · Accident · Serious injuries · Closed · Jan 31, 1971 · N1808K · Substantial damage
- [NTSB CHI71FBJ54](https://openairdocs.org/ntsb/CHI71FBJ54.md): Cessna 421 · Reed City, MI · Accident · Serious injuries · Closed · Jan 29, 1971 · N4555L · Destroyed
- [NTSB NYC71FFA44](https://openairdocs.org/ntsb/NYC71FFA44.md): Beech 65 · Newport, VT · Accident · Serious injuries · Closed · Jan 28, 1971 · N5850J · Substantial damage
- [NTSB IAD71FLJ12](https://openairdocs.org/ntsb/IAD71FLJ12.md): Cessna 172G · Wilmington, NC · Accident · Minor injuries · Closed · Jan 28, 1971 · N4346W · Substantial damage
- [NTSB DEN71FXT19](https://openairdocs.org/ntsb/DEN71FXT19.md): Piper PA-24 · Monument Vly, UT · Accident · No injuries · Closed · Jan 28, 1971 · N9010P · Substantial damage
- [NTSB MIA71FKJ39](https://openairdocs.org/ntsb/MIA71FKJ39.md): Cessna 150 · Brownsboro, AL · Accident · Minor injuries · Closed · Jan 27, 1971 · N6698S · Substantial damage
- [NTSB LAX71FUQ55](https://openairdocs.org/ntsb/LAX71FUQ55.md): Cessna 150 · Pacoima, CA · Accident · Minor injuries · Closed · Jan 27, 1971 · N4076J · Destroyed
- [NTSB LAX71FUG39](https://openairdocs.org/ntsb/LAX71FUG39.md): Piper PA-24 · Rialt0, CA · Accident · No injuries · Closed · Jan 27, 1971 · N7786P · Substantial damage
- [NTSB NYC71AN084](https://openairdocs.org/ntsb/NYC71AN084.md): Cessna 310L · Mountoursville, PA · Accident · 2 fatal · Closed · Jan 26, 1971 · N2255F · Destroyed
- [NTSB FTW71FPD34](https://openairdocs.org/ntsb/FTW71FPD34.md): Cessna 310J · Saginaw, TX · Accident · No injuries · Closed · Jan 26, 1971 · N3137L · Substantial damage
- [NTSB CHI71FGA16](https://openairdocs.org/ntsb/CHI71FGA16.md): Piper PA-28 · Chillicothe, OH · Accident · Minor injuries · Closed · Jan 26, 1971 · N8423W · Substantial damage
- [NTSB MKC71AK042](https://openairdocs.org/ntsb/MKC71AK042.md): Piper PA-28 · Columbus, NE · Accident · 1 fatal · Closed · Jan 24, 1971 · N9471J · Substantial damage
- [NTSB MIA71DKT35](https://openairdocs.org/ntsb/MIA71DKT35.md): Piper PA-12 · Belle Glade, FL · Accident · Minor injuries · Closed · Jan 24, 1971 · N3694M · Substantial damage
- [NTSB IAD71AI036](https://openairdocs.org/ntsb/IAD71AI036.md): Piper PA-28 · Asheboro, NC · Accident · 2 fatal · Closed · Jan 24, 1971 · N9327J · Destroyed
- [NTSB MKC71FDM44](https://openairdocs.org/ntsb/MKC71FDM44.md): Champion 7AC · Pillager, MN · Accident · Minor injuries · Closed · Jan 23, 1971 · N3569E · Substantial damage
- [NTSB MKC71AK041](https://openairdocs.org/ntsb/MKC71AK041.md): Beech 35 · St.Charles, MO · Accident · 4 fatal · Closed · Jan 23, 1971 · N3353V · Destroyed
- [NTSB MIA71FLA30](https://openairdocs.org/ntsb/MIA71FLA30.md): Piper PA-28 · Pensacola, FL · Accident · Serious injuries · Closed · Jan 23, 1971 · N6014W · Substantial damage
- [NTSB FTW71DPM19](https://openairdocs.org/ntsb/FTW71DPM19.md): Piper PA-28 · Bernice, OK · Accident · No injuries · Closed · Jan 23, 1971 · N993PK · Substantial damage
- [NTSB CHI71DBD54](https://openairdocs.org/ntsb/CHI71DBD54.md): Piper J3C-65 · Rockford, IL · Accident · No injuries · Closed · Jan 23, 1971 · N6903H · Substantial damage
- [NTSB FTW71FPG34](https://openairdocs.org/ntsb/FTW71FPG34.md): Ercoupe 415-C · Earle, AR · Accident · No injuries · Closed · Jan 21, 1971 · N99072 · Substantial damage
- [NTSB LAX71FUG35](https://openairdocs.org/ntsb/LAX71FUG35.md): Piper PA-28 · Corona, CA · Accident · Serious injuries · Closed · Jan 20, 1971 · N7223J · Destroyed
- [NTSB OAK71DVG48](https://openairdocs.org/ntsb/OAK71DVG48.md): Mooney M20F · Sacramento, CA · Accident · No injuries · Closed · Jan 19, 1971 · N9395M · Destroyed
- [NTSB LAX71FUA43](https://openairdocs.org/ntsb/LAX71FUA43.md): Cessna 320 · Santa Ana, CA · Accident · Minor injuries · Closed · Jan 18, 1971 · N6161Q · Substantial damage
- [NTSB OAK71DVG47](https://openairdocs.org/ntsb/OAK71DVG47.md): Amer Avco AA-1 · Wilton, CA · Accident · No injuries · Closed · Jan 17, 1971 · N6131L · Destroyed
- [NTSB LAX71FUM22](https://openairdocs.org/ntsb/LAX71FUM22.md): Mooney M20A · Brawley, CA · Accident · Serious injuries · Closed · Jan 17, 1971 · N6012X · Substantial damage
- [NTSB DEN71FQA42](https://openairdocs.org/ntsb/DEN71FQA42.md): Piper PA-28 · Albuquerque, NM · Accident · No injuries · Closed · Jan 17, 1971 · N7472W · Substantial damage
- [NTSB NYC71DHD35](https://openairdocs.org/ntsb/NYC71DHD35.md): Navion A · Vincentown, NJ · Accident · Minor injuries · Closed · Jan 16, 1971 · N91520 · Destroyed
- [NTSB CHI71AC053](https://openairdocs.org/ntsb/CHI71AC053.md): Piper PA-22 · Dyckesville, WI · Accident · 1 fatal · Closed · Jan 16, 1971 · N4651Z · Destroyed
- [NTSB MIA71FKG57](https://openairdocs.org/ntsb/MIA71FKG57.md): Cessna 172 · Statesboro, GA · Accident · Serious injuries · Closed · Jan 13, 1971 · N79570 · Destroyed
- [NTSB MIA71AM060](https://openairdocs.org/ntsb/MIA71AM060.md): Aero Comdr 500B · Jackson, TN · Accident · 2 fatal · Closed · Jan 12, 1971 · N6254X · Destroyed
- [NTSB FTW71AF037](https://openairdocs.org/ntsb/FTW71AF037.md): Beech 99A · Killeen, TX · Accident · Serious injuries · Closed · Jan 12, 1971 · N12RA · Destroyed
- [NTSB NYC71DFG12](https://openairdocs.org/ntsb/NYC71DFG12.md): Piper PA-28 · Belfast, ME · Accident · No injuries · Closed · Jan 10, 1971 · N8870N · Substantial damage
- [NTSB MKC71AK037](https://openairdocs.org/ntsb/MKC71AK037.md): Beech 35 · Wheaton, MN · Accident · 2 fatal · Closed · Jan 9, 1971 · N3282V · Destroyed
- [NTSB OAK71FVW22](https://openairdocs.org/ntsb/OAK71FVW22.md): Cessna 150K · No.Las Vegas, NV · Accident · No injuries · Closed · Jan 8, 1971 · N5956G · Substantial damage
- [NTSB MIA71FKW30](https://openairdocs.org/ntsb/MIA71FKW30.md): Beech B35 · Greeneville, TN · Accident · No injuries · Closed · Jan 7, 1971 · N8823A · Substantial damage
- [NTSB MIA71AM057](https://openairdocs.org/ntsb/MIA71AM057.md): Cessna 172K · High Springs, FL · Accident · 2 fatal · Closed · Jan 6, 1971 · N79116 · Destroyed
- [NTSB DCA71AZ008](https://openairdocs.org/ntsb/DCA71AZ008.md): Douglas DC-3C · New York, NY · Accident · Serious injuries · Closed · Jan 4, 1971 · N7 · Destroyed
- [NTSB NYC71IN076](https://openairdocs.org/ntsb/NYC71IN076.md): Cessna 150 · Danbury, CT · Incident · No injuries · Closed · Jan 2, 1971 · N22785 · 2 aircraft · Minor damage
- [NTSB LAX71DUJ54](https://openairdocs.org/ntsb/LAX71DUJ54.md): Mooney A2A · Tucson, AZ · Accident · No injuries · Closed · Jan 1, 1971 · N6371V · Substantial damage
- [NTSB SEA71FWD25](https://openairdocs.org/ntsb/SEA71FWD25.md): Piper PA-24 · Auburn, WA · Accident · No injuries · Closed · Dec 31, 1970 · N5885P · Substantial damage
- [NTSB MKC71DCA23](https://openairdocs.org/ntsb/MKC71DCA23.md): Cessna 140 · Steffenville, MO · Accident · No injuries · Closed · Dec 31, 1970 · N89035 · Substantial damage

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

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

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