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

## Cases, newest first

- [NTSB LAX71DUJ01](https://openairdocs.org/ntsb/LAX71DUJ01.md): Navion A · Willcox, AZ · Accident · Serious injuries · Closed · Jun 19, 1971 · N3180G · Destroyed
- [NTSB FTW71FPJ44](https://openairdocs.org/ntsb/FTW71FPJ44.md): Cessna 172G · Oklahoma Cty, OK · Accident · No injuries · Closed · Jun 19, 1971 · N4160L · Substantial damage
- [NTSB LAX71FUQ93](https://openairdocs.org/ntsb/LAX71FUQ93.md): Cessna 182 · Sta Barbara, CA · Accident · Serious injuries · Closed · Jun 18, 1971 · N92847 · Destroyed
- [NTSB OAK71FXQ45](https://openairdocs.org/ntsb/OAK71FXQ45.md): Cessna 182 · Reno, NV · Accident · Minor injuries · Closed · Jun 16, 1971 · N3236Y · Substantial damage
- [NTSB NYC71FNA56](https://openairdocs.org/ntsb/NYC71FNA56.md): Piper PA-28 · Norwood, MA · Accident · No injuries · Closed · Jun 16, 1971 · N1760J · Substantial damage
- [NTSB DEN71FQD25](https://openairdocs.org/ntsb/DEN71FQD25.md): Piper PA-32 · Chamberino, NM · Accident · Serious injuries · Closed · Jun 15, 1971 · N5264S · Substantial damage
- [NTSB CHI71IC089](https://openairdocs.org/ntsb/CHI71IC089.md): Luscombe 8E · Ann Arbor, MI · Incident · No injuries · Closed · Jun 15, 1971 · N1470B · 2 aircraft · Minor damage
- [NTSB LAX71FUA67](https://openairdocs.org/ntsb/LAX71FUA67.md): Lark 95 · Sj Capstrno, CA · Accident · Minor injuries · Closed · Jun 14, 1971 · N86654 · Substantial damage
- [NTSB OAK71FJA18](https://openairdocs.org/ntsb/OAK71FJA18.md): Schweizer TG-3A · Haleiwa, HI · Accident · Minor injuries · Closed · Jun 13, 1971 · N67532 · Substantial damage
- [NTSB MKC71DER76](https://openairdocs.org/ntsb/MKC71DER76.md): Schweizer 1-26 · Hayfield, MN · Accident · No injuries · Closed · Jun 13, 1971 · N8603R · Substantial damage
- [NTSB IAD71FLJ27](https://openairdocs.org/ntsb/IAD71FLJ27.md): Cessna 172K · Southport, NC · Accident · Minor injuries · Closed · Jun 13, 1971 · N78490 · Substantial damage
- [NTSB IAD71DIA22](https://openairdocs.org/ntsb/IAD71DIA22.md): Cessna 170B · Cobb Island, MD · Accident · No injuries · Closed · Jun 13, 1971 · N3483D · Substantial damage
- [NTSB FTW71DRJ37](https://openairdocs.org/ntsb/FTW71DRJ37.md): Cessna 180 · Ringgold, LA · Accident · Minor injuries · Closed · Jun 13, 1971 · N180A · Substantial damage
- [NTSB DEN71FQA58](https://openairdocs.org/ntsb/DEN71FQA58.md): Mooney M20E · Albuquerque, NM · Accident · Serious injuries · Closed · Jun 13, 1971 · N6965U · Substantial damage
- [NTSB OAK71FVA83](https://openairdocs.org/ntsb/OAK71FVA83.md): Cessna 150L · Fresno, CA · Accident · No injuries · Closed · Jun 12, 1971 · N6684G · Substantial damage
- [NTSB NYC71FNC30](https://openairdocs.org/ntsb/NYC71FNC30.md): Schweizer 2-33 · Warren, VT · Accident · No injuries · Closed · Jun 12, 1971 · N2448W · Substantial damage
- [NTSB LAX71FUG91](https://openairdocs.org/ntsb/LAX71FUG91.md): Cessna 172K · Bg Bear Cty, CA · Accident · Minor injuries · Closed · Jun 12, 1971 · N84112 · Substantial damage
- [NTSB FTW71AF083](https://openairdocs.org/ntsb/FTW71AF083.md): Piper PA-28 · Beckville, TX · Accident · 2 fatal · Closed · Jun 12, 1971 · N98279 · Destroyed
- [NTSB OAK71DVG82](https://openairdocs.org/ntsb/OAK71DVG82.md): Beech 19A · Pope Valley, CA · Accident · Minor injuries · Closed · Jun 10, 1971 · N416J · Substantial damage
- [NTSB MIA71DKJ60](https://openairdocs.org/ntsb/MIA71DKJ60.md): Cessna 150 · Guin, AL · Accident · No injuries · Closed · Jun 10, 1971 · N3914J · Substantial damage
- [NTSB SEA71FYC44](https://openairdocs.org/ntsb/SEA71FYC44.md): Beech V35B · Vancouver, WA · Accident · No injuries · Closed · Jun 9, 1971 · N3586A · Substantial damage
- [NTSB NYC71FHA52](https://openairdocs.org/ntsb/NYC71FHA52.md): Cessna 172 · Fleetville, PA · Accident · Minor injuries · Closed · Jun 8, 1971 · N7392G · Substantial damage
- [NTSB MIA71AM111](https://openairdocs.org/ntsb/MIA71AM111.md): Cessna A150L · Tallahassee, FL · Accident · 2 fatal · Closed · Jun 8, 1971 · N5940J · Destroyed
- [NTSB FTW71FPA34](https://openairdocs.org/ntsb/FTW71FPA34.md): Cessna 150B · Addison, TX · Accident · Minor injuries · Closed · Jun 8, 1971 · N1201Y · Substantial damage
- [NTSB SEA71FTI36](https://openairdocs.org/ntsb/SEA71FTI36.md): Callair A-5 · Havre, MT · Accident · Minor injuries · Closed · Jun 7, 1971 · N2957G · Substantial damage
- [NTSB DCA71AZ009](https://openairdocs.org/ntsb/DCA71AZ009-79622.md): Convair 580 · New Haven, CT · Accident · 28 fatal · Closed · Jun 7, 1971 · N5832 · Destroyed
- [NTSB NYC71FNA51](https://openairdocs.org/ntsb/NYC71FNA51.md): Piper PA-28 · Oak Bluffs, MA · Accident · No injuries · Closed · Jun 6, 1971 · N5695W · Substantial damage
- [NTSB MKC71FCG73](https://openairdocs.org/ntsb/MKC71FCG73.md): Cessna 180 · Smithville, MO · Accident · No injuries · Closed · Jun 6, 1971 · N6502A · Substantial damage
- [NTSB CHI71DEI57](https://openairdocs.org/ntsb/CHI71DEI57.md): Piper PA-16 · Dorset, OH · Accident · No injuries · Closed · Jun 6, 1971 · N5359H · Substantial damage
- [NTSB CHI71AC086](https://openairdocs.org/ntsb/CHI71AC086.md): Cessna 182 · Lafayette, IN · Accident · 2 fatal · Closed · Jun 6, 1971 · N2127G · Destroyed
- [NTSB MKC71DER70](https://openairdocs.org/ntsb/MKC71DER70.md): Cessna 170B · Lakeville, MN · Accident · No injuries · Closed · Jun 5, 1971 · N2568C · Substantial damage
- [NTSB MIA71FKG89](https://openairdocs.org/ntsb/MIA71FKG89.md): Cessna 150J · Lithonia, GA · Accident · No injuries · Closed · Jun 5, 1971 · N61254 · Substantial damage
- [NTSB MKC71FCJ67](https://openairdocs.org/ntsb/MKC71FCJ67.md): Cessna 182A · Grand Island, NE · Accident · Minor injuries · Closed · Jun 4, 1971 · N2040G · Substantial damage
- [NTSB MIA71DLA49](https://openairdocs.org/ntsb/MIA71DLA49.md): Piper PA-28 · Fernandna Bch, FL · Accident · No injuries · Closed · Jun 4, 1971 · N7216F · Substantial damage
- [NTSB FTW71FPA33](https://openairdocs.org/ntsb/FTW71FPA33.md): Bellanca 14-19 · Addison, TX · Accident · No injuries · Closed · Jun 4, 1971 · N8826R · Substantial damage
- [NTSB DEN71DTE13](https://openairdocs.org/ntsb/DEN71DTE13.md): Piper PA-12 · Louviers, CO · Accident · Minor injuries · Closed · Jun 4, 1971 · N3364M · Substantial damage
- [NTSB CHI71DEE83](https://openairdocs.org/ntsb/CHI71DEE83.md): Piper PA-28 · Roselle, IL · Accident · No injuries · Closed · Jun 3, 1971 · N9782W · Substantial damage
- [NTSB NYC71FGM50](https://openairdocs.org/ntsb/NYC71FGM50.md): Cessna 150F · Valencia, PA · Accident · Serious injuries · Closed · May 31, 1971 · N7142F · Substantial damage
- [NTSB CHI71FEM87](https://openairdocs.org/ntsb/CHI71FEM87.md): Piper PA-28 · Riverdale, MI · Accident · No injuries · Closed · May 31, 1971 · N5221L · Substantial damage
- [NTSB MIA71DLG29](https://openairdocs.org/ntsb/MIA71DLG29.md): Piper PA-16 · Isle Of Palms, SC · Accident · No injuries · Closed · May 30, 1971 · N5906H · Substantial damage
- [NTSB NYC71DHA50](https://openairdocs.org/ntsb/NYC71DHA50.md): Wolf Hirth L0-150 · Matamoras, PA · Accident · No injuries · Closed · May 29, 1971 · N3500G · Substantial damage
- [NTSB NYC71DHD51](https://openairdocs.org/ntsb/NYC71DHD51.md): Cessna 150 · Atlantic City, NJ · Accident · No injuries · Closed · May 28, 1971 · N60767 · Substantial damage
- [NTSB MIA71RM105](https://openairdocs.org/ntsb/MIA71RM105.md): Piper PA-23 · Cat Islnd, Burkina Faso · Accident · 6 fatal · Closed · May 28, 1971 · N4755P · Destroyed
- [NTSB CHI71FCA06](https://openairdocs.org/ntsb/CHI71FCA06.md): Cessna 172I · Bethalto, IL · Accident · Minor injuries · Closed · May 28, 1971 · N8452L · Substantial damage
- [NTSB OAK71DVG79](https://openairdocs.org/ntsb/OAK71DVG79.md): Schweizer 2-22E · Auburn, CA · Accident · No injuries · Closed · May 26, 1971 · N2748R · Substantial damage
- [NTSB NYC71AN114](https://openairdocs.org/ntsb/NYC71AN114.md): Piper PA-28 · Reading, PA · Accident · 1 fatal · Closed · May 26, 1971 · N1697T · Substantial damage
- [NTSB FTW71FPD57](https://openairdocs.org/ntsb/FTW71FPD57.md): Cessna 182 · Stephenville, TX · Accident · No injuries · Closed · May 26, 1971 · N9020G · Destroyed
- [NTSB CHI47DEI59](https://openairdocs.org/ntsb/CHI47DEI59.md): Cessna 150J · New Phil, OH · Accident · No injuries · Closed · May 26, 1971 · N50688 · Substantial damage
- [NTSB MIA71AM100](https://openairdocs.org/ntsb/MIA71AM100.md): Grumman G-21A · Charlotte Amal, VI · Accident · Minor injuries · Closed · May 23, 1971 · N8777A · Substantial damage
- [NTSB MIA71FLD65](https://openairdocs.org/ntsb/MIA71FLD65.md): Beech 35 · Windermere, FL · Accident · Serious injuries · Closed · May 22, 1971 · N3023V · Substantial damage

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

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

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