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

## Cases, newest first

- [NTSB CHI71FGA20](https://openairdocs.org/ntsb/CHI71FGA20.md): Taylorcraft BC12-D · Phillipsburg, OH · Accident · No injuries · Closed · Mar 14, 1971 · N43639 · Substantial damage
- [NTSB FTW71DPM24](https://openairdocs.org/ntsb/FTW71DPM24.md): Beech B-95A · Mexico City, Mexico · Accident · Serious injuries · Closed · Mar 13, 1971 · N1577S · Substantial damage
- [NTSB MKC71FCG48](https://openairdocs.org/ntsb/MKC71FCG48.md): Cessna 150 · Beverly, MO · Accident · Serious injuries · Closed · Mar 12, 1971 · N6702S · Destroyed
- [NTSB MIA71OKT45](https://openairdocs.org/ntsb/MIA71OKT45.md): Beech C-45H · T Cay, Burkina Faso · Accident · No injuries · Closed · Mar 12, 1971 · N9453Z · Substantial damage
- [NTSB MIA71DKJ55](https://openairdocs.org/ntsb/MIA71DKJ55.md): Piper PA-28 · Grove Hill, AL · Accident · No injuries · Closed · Mar 11, 1971 · N4326J · Substantial damage
- [NTSB FTW71DQG64](https://openairdocs.org/ntsb/FTW71DQG64.md): Piper PA-28 · Union, TX · Accident · No injuries · Closed · Mar 11, 1971 · N5722F · Substantial damage
- [NTSB CHI71IC063](https://openairdocs.org/ntsb/CHI71IC063.md): Boeing 737 · Fort Wayne, IN · Incident · No injuries · Closed · Mar 11, 1971 · N9051U · Minor damage
- [NTSB ANC71IA045](https://openairdocs.org/ntsb/ANC71IA045.md): Boeing 727 · Kotzebue, AK · Incident · No injuries · Closed · Mar 11, 1971 · N789AS · Minor damage
- [NTSB MIA71FKG67](https://openairdocs.org/ntsb/MIA71FKG67.md): Cessna A150K · Metter, GA · Accident · Serious injuries · Closed · Mar 10, 1971 · N8498M · Substantial damage
- [NTSB CHI71FBA32](https://openairdocs.org/ntsb/CHI71FBA32.md): Cessna 172 · Frankfort, IN · Accident · No injuries · Closed · Mar 10, 1971 · N8895B · Substantial damage
- [NTSB MKC71DCJ53](https://openairdocs.org/ntsb/MKC71DCJ53.md): Piper PA-28 · Beatrice, NE · Accident · Minor injuries · Closed · Mar 9, 1971 · N9592W · Substantial damage
- [NTSB MKC71DCJ52](https://openairdocs.org/ntsb/MKC71DCJ52.md): Piper PA-28 · Gothenburg, NE · Accident · No injuries · Closed · Mar 9, 1971 · N5627U · Substantial damage
- [NTSB NYC71DFJ27](https://openairdocs.org/ntsb/NYC71DFJ27.md): Piper PA-28 · Skaneateles, NY · Accident · No injuries · Closed · Mar 7, 1971 · N1815T · Substantial damage
- [NTSB IAD71DIG25](https://openairdocs.org/ntsb/IAD71DIG25.md): Piper J-3 · College Park, MD · Accident · No injuries · Closed · Mar 6, 1971 · N70294 · Substantial damage
- [NTSB FTW71AF057](https://openairdocs.org/ntsb/FTW71AF057.md): Beech 36 · Harrison, AR · Accident · 6 fatal · Closed · Mar 6, 1971 · N7708R · Destroyed
- [NTSB FTW71DRG91](https://openairdocs.org/ntsb/FTW71DRG91.md): Piper PA-28 · Ensenada, Mexico · Accident · Serious injuries · Closed · Mar 4, 1971 · N6366W · Substantial damage
- [NTSB CHI71DGD44](https://openairdocs.org/ntsb/CHI71DGD44.md): Amer Avco AA1 · Ravenna, OH · Accident · Minor injuries · Closed · Mar 2, 1971 · N6102L · Destroyed
- [NTSB SEA71DXM26](https://openairdocs.org/ntsb/SEA71DXM26.md): Piper PA-28 · Burley, ID · Accident · No injuries · Closed · Feb 28, 1971 · N7063R · Substantial damage
- [NTSB NYC71DFA53](https://openairdocs.org/ntsb/NYC71DFA53.md): Schweizer SGS123 · Cooperstown, NY · Accident · Serious injuries · Closed · Feb 28, 1971 · N5833U · Substantial damage
- [NTSB MIA71FKT42](https://openairdocs.org/ntsb/MIA71FKT42.md): Piper PA-23 · W.Palm Beach, FL · Accident · No injuries · Closed · Feb 28, 1971 · N5986Y · Substantial damage
- [NTSB FTW71FPG39](https://openairdocs.org/ntsb/FTW71FPG39.md): Luscombe 8A · Hunter, AR · Accident · Serious injuries · Closed · Feb 27, 1971 · N1229B · Substantial damage
- [NTSB DEN71FQA47](https://openairdocs.org/ntsb/DEN71FQA47.md): Cessna 172G · Albuquerque, NM · Accident · Minor injuries · Closed · Feb 27, 1971 · N4162L · Destroyed
- [NTSB MIA71AM076](https://openairdocs.org/ntsb/MIA71AM076.md): Volpar E18S · Columbia, SC · Accident · 8 fatal · Closed · Feb 26, 1971 · N47A · Destroyed
- [NTSB FTW71AF054](https://openairdocs.org/ntsb/FTW71AF054.md): Cessna 210H · Louise, TX · Accident · 1 fatal · Closed · Feb 26, 1971 · N5978F · Destroyed
- [NTSB CHI71AC060](https://openairdocs.org/ntsb/CHI71AC060.md): Cessna 411 · Germantown, WI · Accident · 1 fatal · Closed · Feb 26, 1971 · N3283R · Destroyed
- [NTSB CHI71FLQ20](https://openairdocs.org/ntsb/CHI71FLQ20.md): Piper PA-28 · Fort Knox, KY · Accident · No injuries · Closed · Feb 25, 1971 · N9452J · Substantial damage
- [NTSB SEA71DWG38](https://openairdocs.org/ntsb/SEA71DWG38.md): Bell 47G3 · Touchet, WA · Accident · No injuries · Closed · Feb 23, 1971 · N6782D · Substantial damage
- [NTSB MIA71AM074](https://openairdocs.org/ntsb/MIA71AM074.md): Beech 99A · Orlando, FL · Accident · No injuries · Closed · Feb 21, 1971 · N860SA · Substantial damage
- [NTSB LAX71AL055](https://openairdocs.org/ntsb/LAX71AL055.md): Cessna 177 · Bg Bear Cty, CA · Accident · 3 fatal · Closed · Feb 21, 1971 · N662SR · Destroyed
- [NTSB LAX71AL054](https://openairdocs.org/ntsb/LAX71AL054.md): Cessna 150J · Corona, CA · Accident · Serious injuries · Closed · Feb 21, 1971 · N51290 · 2 aircraft · Substantial damage
- [NTSB ANC71DAG69](https://openairdocs.org/ntsb/ANC71DAG69.md): Cessna 170A · Anchorage, AK · Accident · No injuries · Closed · Feb 20, 1971 · N1708D · Substantial damage
- [NTSB MKC71FDD20](https://openairdocs.org/ntsb/MKC71FDD20.md): Cessna 140 · Elbow Lake, MN · Accident · Minor injuries · Closed · Feb 18, 1971 · N76346 · Substantial damage
- [NTSB MKC71FCD58](https://openairdocs.org/ntsb/MKC71FCD58.md): Piper PA-31 · Iowa City, IA · Accident · Minor injuries · Closed · Feb 18, 1971 · N8000Y · Destroyed
- [NTSB MIA71AM071](https://openairdocs.org/ntsb/MIA71AM071.md): Douglas DC9-15 · Gulfport, MS · Accident · Minor injuries · Closed · Feb 17, 1971 · N92S · Substantial damage
- [NTSB FTW71AF048](https://openairdocs.org/ntsb/FTW71AF048.md): Cessna 150H · W.Memphis, AR · Accident · No injuries · Closed · Feb 17, 1971 · N23323 · 2 aircraft · Substantial damage
- [NTSB MKC71FCQ29](https://openairdocs.org/ntsb/MKC71FCQ29.md): Hughes 269B · Wichita, KS · Accident · No injuries · Closed · Feb 16, 1971 · N9554F · Substantial damage
- [NTSB IAD71DIA15](https://openairdocs.org/ntsb/IAD71DIA15.md): Piper PA-28 · Quantico, VA · Accident · No injuries · Closed · Feb 15, 1971 · N4249J · Substantial damage
- [NTSB NYC71FFM27](https://openairdocs.org/ntsb/NYC71FFM27.md): Cessna 150 · Hartford, CT · Incident · No injuries · Closed · Feb 14, 1971 · N5801G · Minor damage
- [NTSB LAX71DUG46](https://openairdocs.org/ntsb/LAX71DUG46.md): Slingsby T-53 · Elsinore, CA · Accident · Serious injuries · Closed · Feb 14, 1971 · N1578 · Substantial damage
- [NTSB FTW71AF046](https://openairdocs.org/ntsb/FTW71AF046.md): Douglas DC-3C · Shawnee, OK · Accident · Serious injuries · Closed · Feb 14, 1971 · N14273 · Destroyed
- [NTSB OAK72O0004](https://openairdocs.org/ntsb/OAK72O0004.md): Beech Volpar · Tam Ky, VM · Accident · No injuries · Closed · Feb 13, 1971 · N3674G · Substantial damage
- [NTSB OAK71FVG54](https://openairdocs.org/ntsb/OAK71FVG54.md): Luscombe 8E · Cordelia, CA · Accident · Minor injuries · Closed · Feb 13, 1971 · N1742K · Destroyed
- [NTSB NYC71FFA50](https://openairdocs.org/ntsb/NYC71FFA50.md): Beech A23-19 · Granville, NY · Accident · No injuries · Closed · Feb 13, 1971 · N5951S · Substantial damage
- [NTSB MKC71FCQ28](https://openairdocs.org/ntsb/MKC71FCQ28.md): Piper PA-18A · Wichita, KS · Accident · Serious injuries · Closed · Feb 13, 1971 · N2880Z · Substantial damage
- [NTSB MKC71FCJ46](https://openairdocs.org/ntsb/MKC71FCJ46.md): Cessna 180 · Scottsbluff, NE · Accident · Minor injuries · Closed · Feb 13, 1971 · N9314C · Substantial damage
- [NTSB FTW71FPD38](https://openairdocs.org/ntsb/FTW71FPD38.md): Piper PA-12 · Keller, TX · Accident · No injuries · Closed · Feb 13, 1971 · N2608M · Substantial damage
- [NTSB ANC71DAG67](https://openairdocs.org/ntsb/ANC71DAG67.md): Cessna 150 · Cordova, AK · Accident · Minor injuries · Closed · Feb 13, 1971 · N8245S · Substantial damage
- [NTSB MKC72FCA25](https://openairdocs.org/ntsb/MKC72FCA25-160767.md): Beech V35 · St.Louis, MO · Accident · No injuries · Closed · Feb 12, 1971 · N339LT · Substantial damage
- [NTSB NYC71FHJ20](https://openairdocs.org/ntsb/NYC71FHJ20.md): Piper PA-28 · Amityville, NY · Accident · Serious injuries · Closed · Feb 11, 1971 · N6689J · Substantial damage
- [NTSB LAX71AL049](https://openairdocs.org/ntsb/LAX71AL049.md): Cessna 150F · Imprial Bch, CA · Accident · 2 fatal · Closed · Feb 9, 1971 · N7144F · Destroyed

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

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

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