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

## Cases, newest first

- [NTSB IAD71FLJ25](https://openairdocs.org/ntsb/IAD71FLJ25.md): Cessna 150L · Durham, NC · Accident · Minor injuries · Closed · May 20, 1971 · N6553G · Substantial damage
- [NTSB DEN71FTE01](https://openairdocs.org/ntsb/DEN71FTE01.md): Cessna 150 · Broomfield, CO · Accident · No injuries · Closed · May 18, 1971 · N8294S · Substantial damage
- [NTSB DEN71DQA54](https://openairdocs.org/ntsb/DEN71DQA54.md): Piper PA-18 · Roswell, NM · Accident · No injuries · Closed · May 18, 1971 · N7399D · Substantial damage
- [NTSB MKC71FER63](https://openairdocs.org/ntsb/MKC71FER63.md): Cessna 180E · Lutsen, MN · Accident · Minor injuries · Closed · May 17, 1971 · N2666Y · Substantial damage
- [NTSB LAX71FUG86](https://openairdocs.org/ntsb/LAX71FUG86.md): Cessna 150 · Corona, CA · Accident · Serious injuries · Closed · May 17, 1971 · N8204F · Substantial damage
- [NTSB NYC71FGM46](https://openairdocs.org/ntsb/NYC71FGM46.md): Cessna 150F · Monroeville, PA · Accident · Minor injuries · Closed · May 16, 1971 · N8562G · Substantial damage
- [NTSB MKC71DTK29](https://openairdocs.org/ntsb/MKC71DTK29.md): Alouette 2 · Lake Norden, SD · Accident · No injuries · Closed · May 16, 1971 · N8398 · Substantial damage
- [NTSB MKC71DCG69](https://openairdocs.org/ntsb/MKC71DCG69.md): Cessna 150 · Kirksville, MO · Accident · Minor injuries · Closed · May 16, 1971 · N6839F · Destroyed
- [NTSB FTW71FRH27](https://openairdocs.org/ntsb/FTW71FRH27.md): Piper PA-32 · Llano, TX · Accident · Minor injuries · Closed · May 16, 1971 · N3466W · Destroyed
- [NTSB FTW71FRH26](https://openairdocs.org/ntsb/FTW71FRH26.md): Schweizer SGS2-8 · Georgetown, TX · Accident · Serious injuries · Closed · May 16, 1971 · N54094 · Substantial damage
- [NTSB FTW71FRA57](https://openairdocs.org/ntsb/FTW71FRA57.md): Cessna 172 · Port Bolivar, TX · Accident · Serious injuries · Closed · May 16, 1971 · N4095F · Substantial damage
- [NTSB OAK71FVA72](https://openairdocs.org/ntsb/OAK71FVA72.md): Bellanca 14-19 · Fresno, CA · Accident · Minor injuries · Closed · May 15, 1971 · N7661B · Substantial damage
- [NTSB MIA71AM096](https://openairdocs.org/ntsb/MIA71AM096.md): Beech 95-B55 · Ellabelle, GA · Accident · 3 fatal · Closed · May 15, 1971 · N100DC · Destroyed
- [NTSB FTW71FPD55](https://openairdocs.org/ntsb/FTW71FPD55.md): Cessna 310 · Albany, TX · Accident · No injuries · Closed · May 15, 1971 · N765MS · Substantial damage
- [NTSB CHI71DEE82](https://openairdocs.org/ntsb/CHI71DEE82.md): Beech B23 · Joliet, IL · Accident · No injuries · Closed · May 15, 1971 · N6069N · Substantial damage
- [NTSB NYC71FFJ35](https://openairdocs.org/ntsb/NYC71FFJ35.md): Beech 35 · Fulton, NY · Accident · No injuries · Closed · May 14, 1971 · N80462 · Destroyed
- [NTSB MIA71FKQ34](https://openairdocs.org/ntsb/MIA71FKQ34.md): Piper J3C · Minter City, MS · Accident · Minor injuries · Closed · May 14, 1971 · N33598 · Substantial damage
- [NTSB SEA71FYG52](https://openairdocs.org/ntsb/SEA71FYG52.md): Cessna 172 · Electric Cty, WA · Accident · No injuries · Closed · May 10, 1971 · N5741A · Substantial damage
- [NTSB CHI71FEV40](https://openairdocs.org/ntsb/CHI71FEV40.md): Cessna 150 · Manito, IL · Accident · No injuries · Closed · May 10, 1971 · N3821J · Substantial damage
- [NTSB NYC71FHD47](https://openairdocs.org/ntsb/NYC71FHD47.md): Champion 7AC · Bargaintown, NJ · Accident · Minor injuries · Closed · May 9, 1971 · N3032E · Destroyed
- [NTSB LAX71FUQ79](https://openairdocs.org/ntsb/LAX71FUQ79.md): Piper PA-22 · Quartz Hill, CA · Accident · No injuries · Closed · May 9, 1971 · N3616A · Substantial damage
- [NTSB MKC71FER59](https://openairdocs.org/ntsb/MKC71FER59.md): Navion A · Minneapolis, MN · Accident · Serious injuries · Closed · May 8, 1971 · N91426 · Substantial damage
- [NTSB CHI71FEA36](https://openairdocs.org/ntsb/CHI71FEA36.md): Cessna 182 · Muncie, IN · Accident · No injuries · Closed · May 8, 1971 · N4090D · Substantial damage
- [NTSB NYC71FHJ26](https://openairdocs.org/ntsb/NYC71FHJ26.md): Cessna 310D · Mattituck, NY · Accident · No injuries · Closed · May 7, 1971 · N100CA · Substantial damage
- [NTSB NYC71FGT17](https://openairdocs.org/ntsb/NYC71FGT17.md): Piper PA-22 · Bloomsburg, PA · Accident · Minor injuries · Closed · May 7, 1971 · N3241Z · Substantial damage
- [NTSB CHI71DEP50](https://openairdocs.org/ntsb/CHI71DEP50.md): Cessna 337 · Land O Lakes, WI · Accident · Minor injuries · Closed · May 7, 1971 · N2201X · Substantial damage
- [NTSB CHI71AC082](https://openairdocs.org/ntsb/CHI71AC082.md): Beech C35 · Cloverland, IN · Accident · 2 fatal · Closed · May 7, 1971 · N606D · Destroyed
- [NTSB MKC71DTG26](https://openairdocs.org/ntsb/MKC71DTG26.md): Cessna 172L · Bucyrus, ND · Accident · No injuries · Closed · May 6, 1971 · N7571G · Substantial damage
- [NTSB MIA71FLT14](https://openairdocs.org/ntsb/MIA71FLT14.md): Cessna 150 · Memphis, TN · Accident · Serious injuries · Closed · May 4, 1971 · N6943F · Substantial damage
- [NTSB LAX71AL065](https://openairdocs.org/ntsb/LAX71AL065.md): Cessna 140 · Phoenix, AZ · Accident · 2 fatal · Closed · May 4, 1971 · N89482 · Destroyed
- [NTSB FTW71FPM25](https://openairdocs.org/ntsb/FTW71FPM25.md): Cessna 180 · Honobia, OK · Accident · No injuries · Closed · May 4, 1971 · N1705C · Substantial damage
- [NTSB NYC71AN107](https://openairdocs.org/ntsb/NYC71AN107.md): Beech E35 · Indiana, PA · Accident · 3 fatal · Closed · May 3, 1971 · N7366B · Destroyed
- [NTSB LAX71DUJ87](https://openairdocs.org/ntsb/LAX71DUJ87.md): Schweizer 1-26 · Maricopa, AZ · Accident · No injuries · Closed · May 2, 1971 · N2795Z · Substantial damage
- [NTSB OAK71FVG71](https://openairdocs.org/ntsb/OAK71FVG71.md): Cessna A188 · Willows, CA · Accident · 1 fatal · Closed · May 1, 1971 · N8118V · Destroyed
- [NTSB FTW71AF072](https://openairdocs.org/ntsb/FTW71AF072.md): Laister LK-10A · Bracketville, TX · Accident · 1 fatal · Closed · May 1, 1971 · N50894 · Destroyed
- [NTSB LAX71AL064](https://openairdocs.org/ntsb/LAX71AL064.md): Piper PA-28 · Phoenix, AZ · Accident · 1 fatal · Closed · Apr 30, 1971 · N7342W · Destroyed
- [NTSB MIA71FLD60](https://openairdocs.org/ntsb/MIA71FLD60.md): Republic P-47N · Vero Beach, FL · Accident · No injuries · Closed · Apr 29, 1971 · N47TB · Substantial damage
- [NTSB LAX71FUA58](https://openairdocs.org/ntsb/LAX71FUA58.md): Cessna T210K · Lakewood, CA · Accident · No injuries · Closed · Apr 26, 1971 · N8091M · Substantial damage
- [NTSB SEA71FYC36](https://openairdocs.org/ntsb/SEA71FYC36.md): Taylorcraft BC12-D · Sandy, OR · Accident · No injuries · Closed · Apr 25, 1971 · N96324 · Substantial damage
- [NTSB SEA71DYE30](https://openairdocs.org/ntsb/SEA71DYE30.md): Cessna 172 · Darrington, WA · Accident · Minor injuries · Closed · Apr 25, 1971 · N4262F · Substantial damage
- [NTSB IAD71DLJ21](https://openairdocs.org/ntsb/IAD71DLJ21.md): Piper PA-24 · Hatteras, NC · Accident · No injuries · Closed · Apr 25, 1971 · N7460P · Substantial damage
- [NTSB CHI71FEK34](https://openairdocs.org/ntsb/CHI71FEK34.md): Cessna 177 · Ada, OH · Accident · Minor injuries · Closed · Apr 25, 1971 · N3379T · Substantial damage
- [NTSB NYC71FGT19](https://openairdocs.org/ntsb/NYC71FGT19.md): Maule M-4 · Fairfield, PA · Accident · No injuries · Closed · Apr 24, 1971 · N12024 · Destroyed
- [NTSB MKC71FCD77](https://openairdocs.org/ntsb/MKC71FCD77.md): Piper PA-28 · Iowa City, IA · Accident · No injuries · Closed · Apr 24, 1971 · N5682U · Substantial damage
- [NTSB MIA71FKJ50](https://openairdocs.org/ntsb/MIA71FKJ50.md): Piper PA-22 · Pell City, AL · Accident · No injuries · Closed · Apr 24, 1971 · N5303Z · Substantial damage
- [NTSB FTW71DRD39](https://openairdocs.org/ntsb/FTW71DRD39.md): Cessna 150 · Port Sulphur, TX · Accident · No injuries · Closed · Apr 22, 1971 · N23340 · Destroyed
- [NTSB DEN71AD039](https://openairdocs.org/ntsb/DEN71AD039.md): Cessna 175A · Rangely, CO · Accident · 1 fatal · Closed · Apr 22, 1971 · N6807E · Destroyed
- [NTSB CHI71FEC43](https://openairdocs.org/ntsb/CHI71FEC43.md): Piper PA-28 · Lambertville, MI · Accident · Minor injuries · Closed · Apr 21, 1971 · N98003 · Substantial damage
- [NTSB OAK71DVA69](https://openairdocs.org/ntsb/OAK71DVA69.md): Piper PA-25 · Tulare, CA · Accident · No injuries · Closed · Apr 20, 1971 · N7092Z · Substantial damage
- [NTSB LAX71FUJ83](https://openairdocs.org/ntsb/LAX71FUJ83.md): Piper PA-28 · Phoenix, AZ · Accident · Serious injuries · Closed · Apr 20, 1971 · N6468W · Destroyed

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

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

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