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

## Cases, newest first

- [NTSB MKC70FCD20](https://openairdocs.org/ntsb/MKC70FCD20.md): Piper PA-28R · Crescent, IA · Accident · No injuries · Closed · Mar 1, 1970 · N7665J · Substantial damage
- [NTSB MKC70AK046](https://openairdocs.org/ntsb/MKC70AK046.md): Cessna 140A · Mexico, MO · Accident · 1 fatal · Closed · Feb 27, 1970 · N9657A · Substantial damage
- [NTSB ANC70FAA04](https://openairdocs.org/ntsb/ANC70FAA04.md): Taylorcraft BC12-D · Fairbanks, AK · Accident · Serious injuries · Closed · Feb 26, 1970 · N96367 · Substantial damage
- [NTSB LAX70FUD03](https://openairdocs.org/ntsb/LAX70FUD03.md): Piper PA-23 · Compton, CA · Accident · Minor injuries · Closed · Feb 25, 1970 · N1055P · Substantial damage
- [NTSB FTW70FRD04](https://openairdocs.org/ntsb/FTW70FRD04.md): Bell 47J · Patterson, LA · Accident · No injuries · Closed · Feb 25, 1970 · N7819B · Destroyed
- [NTSB MIA70FLA07](https://openairdocs.org/ntsb/MIA70FLA07.md): Cessna 172 · St.Augustine, FL · Accident · No injuries · Closed · Feb 24, 1970 · N7780T · Substantial damage
- [NTSB MKC70FCG10](https://openairdocs.org/ntsb/MKC70FCG10.md): Piper PA-28 · Kansas City, MO · Accident · Serious injuries · Closed · Feb 23, 1970 · N66BA · Destroyed
- [NTSB SEA70DXM05](https://openairdocs.org/ntsb/SEA70DXM05.md): Stinson 108 · Rexburg, ID · Accident · Serious injuries · Closed · Feb 22, 1970 · N9527K · Substantial damage
- [NTSB SEA70AS033](https://openairdocs.org/ntsb/SEA70AS033.md): Beech D35 · Billings, MT · Accident · 4 fatal · Closed · Feb 22, 1970 · N2027D · Destroyed
- [NTSB FTW70FRD03](https://openairdocs.org/ntsb/FTW70FRD03.md): Cessna 210 · Melville, LA · Accident · No injuries · Closed · Feb 22, 1970 · N6121R · Substantial damage
- [NTSB FTW70AF052](https://openairdocs.org/ntsb/FTW70AF052.md): Cessna 172E · New Orleans, LA · Accident · 1 fatal · Closed · Feb 22, 1970 · N3004U · 2 aircraft · Substantial damage
- [NTSB DEN70FQD05](https://openairdocs.org/ntsb/DEN70FQD05.md): Cessna 150 · Alamogordo, NM · Accident · No injuries · Closed · Feb 22, 1970 · N5870E · Substantial damage
- [NTSB MKC70FCG17](https://openairdocs.org/ntsb/MKC70FCG17.md): Cessna 150H · Clinton, MO · Accident · No injuries · Closed · Feb 21, 1970 · N6742S · Substantial damage
- [NTSB MKC70DCG09](https://openairdocs.org/ntsb/MKC70DCG09.md): Cessna 182L · Centralia, MO · Accident · No injuries · Closed · Feb 21, 1970 · N42727 · Substantial damage
- [NTSB LAX70DUG12](https://openairdocs.org/ntsb/LAX70DUG12.md): Erco 415-CD · Hemet, CA · Accident · No injuries · Closed · Feb 21, 1970 · N2355H · Substantial damage
- [NTSB MIA70DKG14](https://openairdocs.org/ntsb/MIA70DKG14.md): Cessna 182 · Eastman, GA · Accident · Minor injuries · Closed · Feb 20, 1970 · N2920F · Substantial damage
- [NTSB LAX70FUQ11](https://openairdocs.org/ntsb/LAX70FUQ11.md): Amer Avco AA-1 · Goleta, CA · Accident · Minor injuries · Closed · Feb 20, 1970 · N5761L · Substantial damage
- [NTSB NYC70FGM09](https://openairdocs.org/ntsb/NYC70FGM09.md): Cessna 310B · Monroeville, PA · Accident · No injuries · Closed · Feb 19, 1970 · N1054Q · Substantial damage
- [NTSB NYC70AN091](https://openairdocs.org/ntsb/NYC70AN091.md): Piper PA-23 · Fairview, PA · Accident · 1 fatal · Closed · Feb 19, 1970 · N5174Y · Destroyed
- [NTSB CHI70AC054](https://openairdocs.org/ntsb/CHI70AC054.md): Piper PA-28 · Fraser, MI · Accident · 3 fatal · Closed · Feb 19, 1970 · N5567F · 2 aircraft · Destroyed
- [NTSB MIA70DKJ08](https://openairdocs.org/ntsb/MIA70DKJ08.md): Cessna 120 · Meridianville, AL · Accident · No injuries · Closed · Feb 16, 1970 · N4087N · Substantial damage
- [NTSB MIA70FKJ09](https://openairdocs.org/ntsb/MIA70FKJ09.md): Hiller Acft UH-12A · Enterprise, AL · Accident · Serious injuries · Closed · Feb 15, 1970 · N214W · Destroyed
- [NTSB MKC70AK044](https://openairdocs.org/ntsb/MKC70AK044.md): Beech E18S · Kansas City, KS · Accident · 1 fatal · Closed · Feb 14, 1970 · N5659D · Destroyed
- [NTSB MIA70FLD03](https://openairdocs.org/ntsb/MIA70FLD03.md): Piper PA-28 · Tampa, FL · Accident · No injuries · Closed · Feb 14, 1970 · N6600J · Substantial damage
- [NTSB MIA70AM070](https://openairdocs.org/ntsb/MIA70AM070.md): Cessna U206D · Memphis, TN · Accident · No injuries · Closed · Feb 13, 1970 · N71967 · Substantial damage
- [NTSB MIA70AM068](https://openairdocs.org/ntsb/MIA70AM068.md): Cessna 175A · Nashville, TN · Accident · 1 fatal · Closed · Feb 12, 1970 · N6965E · Destroyed
- [NTSB IAD70FIA05](https://openairdocs.org/ntsb/IAD70FIA05.md): Piper PA-28 · Chantilly, VA · Accident · No injuries · Closed · Feb 12, 1970 · N5589U · Substantial damage
- [NTSB OAK70AP041](https://openairdocs.org/ntsb/OAK70AP041.md): Boeing 707 · Stockton, CA · Accident · Serious injuries · Closed · Feb 11, 1970 · N426PA · Substantial damage
- [NTSB MKC70FCA01](https://openairdocs.org/ntsb/MKC70FCA01.md): Bellanca 14-193 · Chesterfield, MO · Accident · Minor injuries · Closed · Feb 11, 1970 · N8864R · Substantial damage
- [NTSB NYC70AN086](https://openairdocs.org/ntsb/NYC70AN086.md): Dehavilland DHC-6 · Waterford, CT · Accident · 5 fatal · Closed · Feb 10, 1970 · N124PM · Substantial damage
- [NTSB SEA70AS032](https://openairdocs.org/ntsb/SEA70AS032.md): Aeronca 7AC · Snohomish, WA · Accident · 1 fatal · Closed · Feb 8, 1970 · N83800 · 2 aircraft · Substantial damage
- [NTSB NYC70AN084](https://openairdocs.org/ntsb/NYC70AN084.md): Lockheed Ga 1329 · Akron, OH · Accident · No injuries · Closed · Feb 8, 1970 · N7008 · Substantial damage
- [NTSB SEA70DWA03](https://openairdocs.org/ntsb/SEA70DWA03.md): Piper PA-28 · Redmond, OR · Accident · Minor injuries · Closed · Feb 7, 1970 · N4901L · Destroyed
- [NTSB CHI70AC051](https://openairdocs.org/ntsb/CHI70AC051.md): Beech A35 · Hebron, KY · Accident · 3 fatal · Closed · Feb 7, 1970 · N726B · Destroyed
- [NTSB MKC70AK042](https://openairdocs.org/ntsb/MKC70AK042.md): Mooney M20F · Kansas City N., MO · Accident · Serious injuries · Closed · Feb 5, 1970 · N9699M · Destroyed
- [NTSB IAD70AI042](https://openairdocs.org/ntsb/IAD70AI042.md): Beech E18S · Weyers Cave, VA · Accident · 2 fatal · Closed · Feb 3, 1970 · N403FW · Destroyed
- [NTSB MKC70FCJ06](https://openairdocs.org/ntsb/MKC70FCJ06.md): Stits SA-3A · Lincoln, NE · Accident · No injuries · Closed · Feb 1, 1970 · N9109 · Substantial damage
- [NTSB LAX70FUJ07](https://openairdocs.org/ntsb/LAX70FUJ07.md): Cessna 180 · Casa Grande, AZ · Accident · Serious injuries · Closed · Feb 1, 1970 · N4633B · Substantial damage
- [NTSB NYC70FGM07](https://openairdocs.org/ntsb/NYC70FGM07.md): Cessna 210 · Connellsville, PA · Accident · No injuries · Closed · Jan 31, 1970 · N345Q · Substantial damage
- [NTSB MKC70DCQ07](https://openairdocs.org/ntsb/MKC70DCQ07.md): Piper PA-28 · Manhattan, KS · Accident · No injuries · Closed · Jan 31, 1970 · N8169W · Substantial damage
- [NTSB MIA70FKW01](https://openairdocs.org/ntsb/MIA70FKW01.md): Piper PA-23 · Nashville, TN · Accident · No injuries · Closed · Jan 31, 1970 · N4471P · Substantial damage
- [NTSB FTW70FRA04](https://openairdocs.org/ntsb/FTW70FRA04.md): Piper PA-28 · Houston, TX · Accident · No injuries · Closed · Jan 31, 1970 · N1092T · Substantial damage
- [NTSB LAX70FUA08](https://openairdocs.org/ntsb/LAX70FUA08.md): Stinson 108 · Fullerton, CA · Accident · Minor injuries · Closed · Jan 30, 1970 · N946D · Substantial damage
- [NTSB CHI70AC048](https://openairdocs.org/ntsb/CHI70AC048.md): Swearingen SA26AT · Willoughby H, OH · Accident · 1 fatal · Closed · Jan 29, 1970 · N239P · Destroyed
- [NTSB NYC70DGM06](https://openairdocs.org/ntsb/NYC70DGM06.md): Cessna 150H · Dubois, PA · Accident · No injuries · Closed · Jan 28, 1970 · N22774 · Substantial damage
- [NTSB LAX70AL045](https://openairdocs.org/ntsb/LAX70AL045.md): Piper PA-28 · La Mirada, CA · Accident · 1 fatal · Closed · Jan 28, 1970 · N8163N · Destroyed
- [NTSB MIA70FKG06](https://openairdocs.org/ntsb/MIA70FKG06.md): Cessna 172 · Marietta, GA · Accident · Minor injuries · Closed · Jan 26, 1970 · N7645X · Substantial damage
- [NTSB IAD70DID03](https://openairdocs.org/ntsb/IAD70DID03.md): Piper PA-28 · Chesapeake, VA · Accident · No injuries · Closed · Jan 25, 1970 · N8177W · Substantial damage
- [NTSB NYC70FFG02](https://openairdocs.org/ntsb/NYC70FFG02.md): Erco 415-C · Winthrop, ME · Accident · No injuries · Closed · Jan 24, 1970 · N2306H · Substantial damage
- [NTSB NYC70DHM05](https://openairdocs.org/ntsb/NYC70DHM05.md): Piper PA-28 · Spring Valley, NY · Accident · No injuries · Closed · Jan 23, 1970 · N4221J · Substantial damage

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

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

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