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

## Cases, newest first

- [NTSB NYC71DFD26](https://openairdocs.org/ntsb/NYC71DFD26.md): Piper PA-28 · Mansfield, MA · Accident · No injuries · Closed · Dec 29, 1970 · N8080N · Substantial damage
- [NTSB MIA71AM054](https://openairdocs.org/ntsb/MIA71AM054.md): Cessna 401A · Ft Lauderdale, FL · Accident · 4 fatal · Closed · Dec 29, 1970 · N6235Q · Destroyed
- [NTSB LAX71IL042](https://openairdocs.org/ntsb/LAX71IL042.md): Boeing 747 · Los Angeles, CA · Incident · No injuries · Closed · Dec 29, 1970 · N4704U · Minor damage
- [NTSB FTW71FRA40](https://openairdocs.org/ntsb/FTW71FRA40.md): Schweizer 1-26B · Friendswood, TX · Accident · No injuries · Closed · Dec 27, 1970 · N3728Z · Substantial damage
- [NTSB MIA71FLD39](https://openairdocs.org/ntsb/MIA71FLD39.md): Erco 415-C · Plymouth, FL · Accident · Serious injuries · Closed · Dec 26, 1970 · N2931H · Substantial damage
- [NTSB MKC71FDQ22](https://openairdocs.org/ntsb/MKC71FDQ22.md): Aeronca 7AC · Edgemont, SD · Accident · Serious injuries · Closed · Dec 25, 1970 · N2968E · Substantial damage
- [NTSB LAX71FUG32](https://openairdocs.org/ntsb/LAX71FUG32.md): Cessna 172 · El Monte, CA · Accident · Serious injuries · Closed · Dec 24, 1970 · N84235 · Substantial damage
- [NTSB CHI71FBD46](https://openairdocs.org/ntsb/CHI71FBD46.md): Piper PA-28 · Hinsdale, IL · Accident · No injuries · Closed · Dec 24, 1970 · N98008 · Substantial damage
- [NTSB CHI71AC047](https://openairdocs.org/ntsb/CHI71AC047.md): Beech H18S · Lansing, MI · Accident · Serious injuries · Closed · Dec 23, 1970 · N2345Z · Destroyed
- [NTSB CHI71AC046](https://openairdocs.org/ntsb/CHI71AC046.md): Piper PA-23 · Romulus, MI · Accident · No injuries · Closed · Dec 22, 1970 · N6748Y · Substantial damage
- [NTSB IAD71AI030](https://openairdocs.org/ntsb/IAD71AI030.md): Piper PA-24 · Clarksburg, WV · Accident · 1 fatal · Closed · Dec 21, 1970 · N7689P · Destroyed
- [NTSB FTW71FPA20](https://openairdocs.org/ntsb/FTW71FPA20.md): Stinson 108-3 · Midlothian, TX · Accident · No injuries · Closed · Dec 21, 1970 · N910C · Substantial damage
- [NTSB CHI71FGD31](https://openairdocs.org/ntsb/CHI71FGD31.md): Bellanca 17-31 · Richmond Hts, OH · Accident · No injuries · Closed · Dec 21, 1970 · N6595V · Substantial damage
- [NTSB NYC71DFJ19](https://openairdocs.org/ntsb/NYC71DFJ19.md): Piper PA-28R · Skaneateles, NY · Accident · No injuries · Closed · Dec 20, 1970 · N3701T · Substantial damage
- [NTSB MKC71FDM39](https://openairdocs.org/ntsb/MKC71FDM39.md): Luscombe 8A · Pine City, MN · Accident · Serious injuries · Closed · Dec 20, 1970 · N2121B · Substantial damage
- [NTSB MIA71DKT32](https://openairdocs.org/ntsb/MIA71DKT32.md): N.American P-51 · Homestead, FL · Accident · Minor injuries · Closed · Dec 20, 1970 · N1051S · Substantial damage
- [NTSB EU170DYZ02](https://openairdocs.org/ntsb/EU170DYZ02.md): Douglas A-26 · Beirut, LE · Incident · No injuries · Closed · Dec 19, 1970 · N40XY · Minor damage
- [NTSB CHI71AC045](https://openairdocs.org/ntsb/CHI71AC045.md): Cessna 140 · Vergennes, IL · Accident · 1 fatal · Closed · Dec 19, 1970 · N2035N · Substantial damage
- [NTSB CHI71FBA21](https://openairdocs.org/ntsb/CHI71FBA21.md): Globe GC-1B · Monticello, IN · Accident · Serious injuries · Closed · Dec 18, 1970 · N78119 · Substantial damage
- [NTSB IAD71DKM22](https://openairdocs.org/ntsb/IAD71DKM22.md): Cessna 172G · Yadkinville, NC · Accident · Minor injuries · Closed · Dec 17, 1970 · N1320F · Substantial damage
- [NTSB FTW71FPA19](https://openairdocs.org/ntsb/FTW71FPA19.md): Cessna 210A · Addison, TX · Accident · No injuries · Closed · Dec 16, 1970 · N9524X · Substantial damage
- [NTSB CHI71FGA15](https://openairdocs.org/ntsb/CHI71FGA15.md): Cessna 150 · Xenia, OH · Accident · Minor injuries · Closed · Dec 15, 1970 · N22818 · Destroyed
- [NTSB MKC71FCA22](https://openairdocs.org/ntsb/MKC71FCA22.md): Cessna 172H · Poplar Bluff, MO · Accident · Serious injuries · Closed · Dec 13, 1970 · N8108L · Destroyed
- [NTSB LAX71DUJ47](https://openairdocs.org/ntsb/LAX71DUJ47.md): Piper PA-28 · Phoenix, AZ · Accident · No injuries · Closed · Dec 13, 1970 · N9078J · Substantial damage
- [NTSB FTW71FPJ23](https://openairdocs.org/ntsb/FTW71FPJ23.md): Cessna 150 · Okla.City, OK · Accident · Serious injuries · Closed · Dec 12, 1970 · N8435J · Substantial damage
- [NTSB NYC71FHJ14](https://openairdocs.org/ntsb/NYC71FHJ14.md): Aeronca 11AC · East Moriches, NY · Accident · Minor injuries · Closed · Dec 11, 1970 · N9289E · Substantial damage
- [NTSB IAD71FIG23](https://openairdocs.org/ntsb/IAD71FIG23.md): Cessna 150 · White Marsh, MD · Accident · No injuries · Closed · Dec 7, 1970 · N5114G · Substantial damage
- [NTSB FTW71FRJ25](https://openairdocs.org/ntsb/FTW71FRJ25.md): Piper PA-28 · Shreveport, LA · Accident · No injuries · Closed · Dec 6, 1970 · N95388 · Substantial damage
- [NTSB FTW71FPD33](https://openairdocs.org/ntsb/FTW71FPD33.md): Piper PA-28 · Springtown, TX · Accident · No injuries · Closed · Dec 6, 1970 · N8353R · Substantial damage
- [NTSB CHI71DBJ44](https://openairdocs.org/ntsb/CHI71DBJ44.md): Piper J3C-65 · Midland, MI · Accident · No injuries · Closed · Dec 6, 1970 · N6132H · Substantial damage
- [NTSB MIA71FKW24](https://openairdocs.org/ntsb/MIA71FKW24.md): Schweizer TG-3A · Eagleville, TN · Accident · Serious injuries · Closed · Dec 5, 1970 · N63904 · Substantial damage
- [NTSB SEA71FWG34](https://openairdocs.org/ntsb/SEA71FWG34.md): Piper PA-28 · Pasco, WA · Accident · Minor injuries · Closed · Dec 4, 1970 · N5325L · Substantial damage
- [NTSB ANC71DAA23](https://openairdocs.org/ntsb/ANC71DAA23.md): Dehavilland DHC-6 · Prudhoe Bay, AK · Accident · No injuries · Closed · Dec 1, 1970 · N512AR · Substantial damage
- [NTSB NYC71FHA23](https://openairdocs.org/ntsb/NYC71FHA23.md): Piper PA-23 · Doylestown, PA · Accident · Minor injuries · Closed · Nov 30, 1970 · N4542P · Substantial damage
- [NTSB MKC71FCA20](https://openairdocs.org/ntsb/MKC71FCA20.md): Cessna 172 · Chesterfield, MO · Accident · Serious injuries · Closed · Nov 30, 1970 · N79942 · Destroyed
- [NTSB MKC71AK030](https://openairdocs.org/ntsb/MKC71AK030.md): Piper PA-24 · Bismarck, ND · Accident · Serious injuries · Closed · Nov 30, 1970 · N8908P · Substantial damage
- [NTSB MIA71DKW25](https://openairdocs.org/ntsb/MIA71DKW25.md): Aeronca 7AC · Lafayette, TN · Accident · No injuries · Closed · Nov 30, 1970 · N84406 · Substantial damage
- [NTSB CHI71FBD39](https://openairdocs.org/ntsb/CHI71FBD39.md): Beech 95-B55 · Sugar Grove, IL · Accident · 1 fatal · Closed · Nov 30, 1970 · N8000M · Destroyed
- [NTSB NYC71AN066](https://openairdocs.org/ntsb/NYC71AN066.md): Piper PA-23 · Chester, CT · Accident · 1 fatal · Closed · Nov 29, 1970 · N6804Y · Destroyed
- [NTSB FTW71FRD28](https://openairdocs.org/ntsb/FTW71FRD28.md): Cessna 185A · Violet, LA · Accident · No injuries · Closed · Nov 29, 1970 · N3365L · Substantial damage
- [NTSB FTW71DRG57](https://openairdocs.org/ntsb/FTW71DRG57.md): Cessna 172 · San Cristobal, Mexico · Accident · Serious injuries · Closed · Nov 29, 1970 · N8701U · Substantial damage
- [NTSB SEA71FWA24](https://openairdocs.org/ntsb/SEA71FWA24.md): Piper PA-22 · Haines, OR · Accident · Serious injuries · Closed · Nov 28, 1970 · N9184D · Substantial damage
- [NTSB MIA71FLA24](https://openairdocs.org/ntsb/MIA71FLA24.md): Piper PA-24 · Tallahassee, FL · Accident · No injuries · Closed · Nov 28, 1970 · N5706P · Substantial damage
- [NTSB MIA71DKG51](https://openairdocs.org/ntsb/MIA71DKG51.md): Briegleb BG12BD · Williamson, GA · Accident · No injuries · Closed · Nov 28, 1970 · N9009 · Substantial damage
- [NTSB DEN71FQA30](https://openairdocs.org/ntsb/DEN71FQA30.md): Piper PA-28 · Albuquerque, NM · Accident · Minor injuries · Closed · Nov 25, 1970 · N9101J · Substantial damage
- [NTSB LAX71FUG27](https://openairdocs.org/ntsb/LAX71FUG27.md): Cessna 150F · Arlington, CA · Accident · No injuries · Closed · Nov 24, 1970 · N8765G · Substantial damage
- [NTSB FTW71AF022](https://openairdocs.org/ntsb/FTW71AF022.md): Cessna P206 · San Antonio, TX · Accident · 7 fatal · Closed · Nov 24, 1970 · N2654X · Destroyed
- [NTSB LAX71FUA27](https://openairdocs.org/ntsb/LAX71FUA27.md): Beech 35-33 · Avalon, CA · Accident · Serious injuries · Closed · Nov 23, 1970 · N9926R · Substantial damage
- [NTSB FTW71DPM15](https://openairdocs.org/ntsb/FTW71DPM15.md): Piper PA-22 · Bristow, OK · Accident · No injuries · Closed · Nov 23, 1970 · N9952D · Substantial damage
- [NTSB MIA71DLD37](https://openairdocs.org/ntsb/MIA71DLD37.md): Cessna 172I · N.Smyrna Bch, FL · Accident · No injuries · Closed · Nov 22, 1970 · N35562 · Substantial damage

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

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

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