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

## Cases, newest first

- [NTSB OAK71DVG02](https://openairdocs.org/ntsb/OAK71DVG02.md): Champion 7KCAB · Platina, CA · Accident · Minor injuries · Closed · Jul 19, 1970 · N5231X · Substantial damage
- [NTSB OAK71AP003](https://openairdocs.org/ntsb/OAK71AP003.md): Beech 35-C33 · Minden, NV · Accident · 4 fatal · Closed · Jul 19, 1970 · N462SR · Destroyed
- [NTSB MKC71FCG05](https://openairdocs.org/ntsb/MKC71FCG05.md): Cessna 177 · Elkton, MO · Accident · No injuries · Closed · Jul 19, 1970 · N29658 · Destroyed
- [NTSB LAX71DUM06](https://openairdocs.org/ntsb/LAX71DUM06.md): Bell 47G5 · Imperial, CA · Accident · No injuries · Closed · Jul 19, 1970 · N7840S · Substantial damage
- [NTSB IAD71FIJ05](https://openairdocs.org/ntsb/IAD71FIJ05-109460.md): Cessna 182A · Morgantown, WV · Accident · No injuries · Closed · Jul 19, 1970 · N3864D · Substantial damage
- [NTSB OAK71FVA08](https://openairdocs.org/ntsb/OAK71FVA08.md): Convair PBY-6A · Columbia, CA · Accident · 2 fatal · Closed · Jul 18, 1970 · N6459C · Destroyed
- [NTSB NYC71DFM11](https://openairdocs.org/ntsb/NYC71DFM11.md): Schweizer 2-22 · Barre, MA · Accident · Serious injuries · Closed · Jul 18, 1970 · N1323V · No damage
- [NTSB MIA71FKW02](https://openairdocs.org/ntsb/MIA71FKW02.md): Cessna 140 · Powell, TN · Accident · Minor injuries · Closed · Jul 18, 1970 · N3560V · Destroyed
- [NTSB MIA71DLA03](https://openairdocs.org/ntsb/MIA71DLA03.md): Beech A23 · Carabelle, FL · Accident · No injuries · Closed · Jul 18, 1970 · N1428L · Substantial damage
- [NTSB FTW71FRA06](https://openairdocs.org/ntsb/FTW71FRA06.md): Beech B50 · Friendswood, TX · Accident · Minor injuries · Closed · Jul 18, 1970 · N41U · Substantial damage
- [NTSB NYC71FHM01](https://openairdocs.org/ntsb/NYC71FHM01.md): Piper PA-28 · Flanders, NJ · Accident · No injuries · Closed · Jul 17, 1970 · N5982U · Substantial damage
- [NTSB CHI71DGD21](https://openairdocs.org/ntsb/CHI71DGD21.md): Piper PA-28 · N.Bass Islnd, OH · Accident · No injuries · Closed · Jul 17, 1970 · N2316R · Substantial damage
- [NTSB NYC71FHG01](https://openairdocs.org/ntsb/NYC71FHG01.md): Amer Avco AA-1 · Carlisle, PA · Accident · No injuries · Closed · Jul 16, 1970 · N5783L · 2 aircraft · Substantial damage
- [NTSB MKC71DCA03](https://openairdocs.org/ntsb/MKC71DCA03.md): Luscombe 8E · House Springs, MO · Accident · No injuries · Closed · Jul 16, 1970 · N1916K · Substantial damage
- [NTSB NYC71FHA02](https://openairdocs.org/ntsb/NYC71FHA02.md): Cessna 310H · Princeton, NJ · Accident · No injuries · Closed · Jul 15, 1970 · N1004Q · Substantial damage
- [NTSB LAX71FUA01](https://openairdocs.org/ntsb/LAX71FUA01.md): Piper PA-28 · Long Beach, CA · Accident · No injuries · Closed · Jul 15, 1970 · N95174 · Substantial damage
- [NTSB MIA71DKD02](https://openairdocs.org/ntsb/MIA71DKD02.md): Cessna 150 · Millington, TN · Accident · No injuries · Closed · Jul 14, 1970 · N6494G · Substantial damage
- [NTSB FTW71FQG13](https://openairdocs.org/ntsb/FTW71FQG13.md): Taylorcraft BC12-D · Gruver, TX · Accident · Minor injuries · Closed · Jul 13, 1970 · N5280M · Substantial damage
- [NTSB SEA71FWD03](https://openairdocs.org/ntsb/SEA71FWD03.md): Vancraft GC-1 · Olympia, WA · Accident · 1 fatal · Closed · Jul 12, 1970 · N3631 · Destroyed
- [NTSB MIA71AM005](https://openairdocs.org/ntsb/MIA71AM005.md): Beech 95-C55 · Pompano Beach, FL · Accident · 1 fatal · Closed · Jul 12, 1970 · N655H · Destroyed
- [NTSB LAX71FUD01](https://openairdocs.org/ntsb/LAX71FUD01.md): Beech 56TC · Hawthorne, CA · Accident · Minor injuries · Closed · Jul 12, 1970 · N461NC · Substantial damage
- [NTSB SEA71DWA05](https://openairdocs.org/ntsb/SEA71DWA05.md): Hiller Acft UH-12A · Maupin, OR · Accident · No injuries · Closed · Jul 11, 1970 · N8180H · Substantial damage
- [NTSB SEA70DWG03](https://openairdocs.org/ntsb/SEA70DWG03-115039.md): Bell 47G · Conconully, WA · Accident · No injuries · Closed · Jul 11, 1970 · N979B · Substantial damage
- [NTSB CHI71DDJ04](https://openairdocs.org/ntsb/CHI71DDJ04.md): Cessna 150 · Platteville, WI · Accident · No injuries · Closed · Jul 10, 1970 · N3679J · Substantial damage
- [NTSB MIA71DKG04](https://openairdocs.org/ntsb/MIA71DKG04.md): Piper PA-24 · Marietta, GA · Accident · No injuries · Closed · Jul 9, 1970 · N6793P · Substantial damage
- [NTSB IAD71DIJ01](https://openairdocs.org/ntsb/IAD71DIJ01.md): Champion 7-FC-3 · Ripley, WV · Accident · No injuries · Closed · Jul 9, 1970 · N7495B · Substantial damage
- [NTSB NYC71DHD05](https://openairdocs.org/ntsb/NYC71DHD05.md): Cessna 150 · Moorestown, NJ · Accident · No injuries · Closed · Jul 8, 1970 · N7024F · Substantial damage
- [NTSB CHI71FBA01](https://openairdocs.org/ntsb/CHI71FBA01.md): Cessna 172 · Orleans, IN · Accident · No injuries · Closed · Jul 8, 1970 · N5440R · Destroyed
- [NTSB MIA71DKC01](https://openairdocs.org/ntsb/MIA71DKC01.md): Mustang II · St Simons Isl, GA · Accident · No injuries · Closed · Jul 6, 1970 · N1388 · Substantial damage
- [NTSB DEN71DXA01](https://openairdocs.org/ntsb/DEN71DXA01.md): Cessna 182 · Aladdin, WY · Accident · Minor injuries · Closed · Jul 6, 1970 · N8301S · Substantial damage
- [NTSB FTW71DRD02](https://openairdocs.org/ntsb/FTW71DRD02.md): Cessna 180H · Houma, LA · Accident · Minor injuries · Closed · Jul 5, 1970 · N2486F · Substantial damage
- [NTSB FTW71DPJ06](https://openairdocs.org/ntsb/FTW71DPJ06.md): Cessna 150 · Duncan, OK · Accident · Minor injuries · Closed · Jul 5, 1970 · N8435J · Substantial damage
- [NTSB CHI71DDW01](https://openairdocs.org/ntsb/CHI71DDW01.md): Piper PA-28 · Dundee, MI · Accident · No injuries · Closed · Jul 5, 1970 · N8900J · Substantial damage
- [NTSB FTW71DQG01](https://openairdocs.org/ntsb/FTW71DQG01.md): Cessna 172K · Sterling City, TX · Accident · No injuries · Closed · Jul 4, 1970 · N79139 · Substantial damage
- [NTSB CHI71FGD17](https://openairdocs.org/ntsb/CHI71FGD17.md): Beech E35 · Cleveland, OH · Accident · No injuries · Closed · Jul 4, 1970 · N5559D · Substantial damage
- [NTSB MIA71DLD02](https://openairdocs.org/ntsb/MIA71DLD02.md): Schleicher KA-6CR · Apopka, FL · Accident · No injuries · Closed · Jul 3, 1970 · N6098V · Substantial damage
- [NTSB FTW71FRG02](https://openairdocs.org/ntsb/FTW71FRG02.md): Piper PA-22 · Sabinal, TX · Accident · Serious injuries · Closed · Jul 3, 1970 · N9768D · Substantial damage
- [NTSB DEN71DXD02](https://openairdocs.org/ntsb/DEN71DXD02.md): Schweizer SGS126 · Walsenburg, CO · Accident · No injuries · Closed · Jul 3, 1970 · N2422W · Substantial damage
- [NTSB CHI71DDJ02](https://openairdocs.org/ntsb/CHI71DDJ02.md): Cessna 180F · Friendship, WI · Accident · Minor injuries · Closed · Jul 3, 1970 · N2157Z · Substantial damage
- [NTSB OAK71AVG01](https://openairdocs.org/ntsb/OAK71AVG01.md): Luscombe 8A · Williams, CA · Accident · Minor injuries · Closed · Jul 2, 1970 · N2798 · Substantial damage
- [NTSB IAD71AI002](https://openairdocs.org/ntsb/IAD71AI002.md): Short Bros SC7-3 · Washington, DC · Accident · 2 fatal · Closed · Jul 2, 1970 · N21CK · Destroyed
- [NTSB LAX70DUJ46](https://openairdocs.org/ntsb/LAX70DUJ46.md): Beech 35S · Tucson, AZ · Accident · No injuries · Closed · Jun 30, 1970 · N7907K · Substantial damage
- [NTSB MKC70DCG36](https://openairdocs.org/ntsb/MKC70DCG36.md): Piper PA-28 · Missouri City, MO · Accident · Minor injuries · Closed · Jun 29, 1970 · N66BA · Substantial damage
- [NTSB ANC70FAG32](https://openairdocs.org/ntsb/ANC70FAG32.md): Piper PA-22 · Cooper Lndg, AK · Accident · Minor injuries · Closed · Jun 29, 1970 · N3837P · Substantial damage
- [NTSB NYC70DFD22](https://openairdocs.org/ntsb/NYC70DFD22.md): Schweizer 2-33 · Shirley, MA · Accident · No injuries · Closed · Jun 28, 1970 · N2489W · Substantial damage
- [NTSB DEN70FXD44](https://openairdocs.org/ntsb/DEN70FXD44.md): Cessna 172K · Littleton, CO · Accident · Serious injuries · Closed · Jun 28, 1970 · N78677 · Destroyed
- [NTSB CHI70DDJ26](https://openairdocs.org/ntsb/CHI70DDJ26.md): Cessna 180 · Lone Rock, WI · Accident · No injuries · Closed · Jun 28, 1970 · N4930A · Substantial damage
- [NTSB SEA70DDG14](https://openairdocs.org/ntsb/SEA70DDG14.md): Cessna 172 · Kremlin, MT · Accident · No injuries · Closed · Jun 27, 1970 · N8251X · Substantial damage
- [NTSB SEA70AS048](https://openairdocs.org/ntsb/SEA70AS048.md): Cessna 182 · Shoshone, ID · Accident · 1 fatal · Closed · Jun 27, 1970 · N6446A · Destroyed
- [NTSB NYC70DHA14](https://openairdocs.org/ntsb/NYC70DHA14.md): Piper PA-23 · Manville, NJ · Accident · No injuries · Closed · Jun 26, 1970 · N4570P · Substantial damage

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

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

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