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

## Cases, newest first

- [NTSB LAX73FUM08](https://openairdocs.org/ntsb/LAX73FUM08.md): Cessna 170B · Niland, CA · Accident · Minor injuries · Closed · Nov 8, 1972 · N1628D · Substantial damage
- [NTSB ANC73FAG57](https://openairdocs.org/ntsb/ANC73FAG57.md): Pilatus PC6BH2 · Anchorage, AK · Accident · No injuries · Closed · Nov 8, 1972 · N2854T · Substantial damage
- [NTSB NYC73AN066](https://openairdocs.org/ntsb/NYC73AN066.md): Beech G33 · Colfax, NC · Accident · 4 fatal · Closed · Nov 7, 1972 · N9496Q · Destroyed
- [NTSB MIA73FLT12](https://openairdocs.org/ntsb/MIA73FLT12.md): Piper PA-30 · Memphis, TN · Accident · Serious injuries · Closed · Nov 6, 1972 · N7684Y · Destroyed
- [NTSB CHI73DEG11](https://openairdocs.org/ntsb/CHI73DEG11.md): Cessna 150G · Oxford, OH · Accident · No injuries · Closed · Nov 6, 1972 · N2682J · Substantial damage
- [NTSB LAX73DUQ20](https://openairdocs.org/ntsb/LAX73DUQ20.md): Cessna 172 · Santa Ynez, CA · Accident · No injuries · Closed · Nov 5, 1972 · N6211E · Substantial damage
- [NTSB FTW73DPG33](https://openairdocs.org/ntsb/FTW73DPG33.md): Cessna 120 · Beebe, AR · Accident · No injuries · Closed · Nov 5, 1972 · N76602 · Substantial damage
- [NTSB CHI73FEP30](https://openairdocs.org/ntsb/CHI73FEP30.md): Cessna 120 · Hartford, WI · Accident · Minor injuries · Closed · Nov 5, 1972 · N2425N · Substantial damage
- [NTSB MKC73DCG18](https://openairdocs.org/ntsb/MKC73DCG18.md): Cessna P206A · Springfield, MO · Accident · No injuries · Closed · Nov 4, 1972 · N2690X · Substantial damage
- [NTSB MKC73AK033](https://openairdocs.org/ntsb/MKC73AK033.md): Cessna 172 · Chesterfield, MO · Accident · No injuries · Closed · Nov 4, 1972 · N20183 · 2 aircraft · Substantial damage
- [NTSB LAX73FUJ34](https://openairdocs.org/ntsb/LAX73FUJ34.md): Cessna 172 · Scottsdale, AZ · Accident · Minor injuries · Closed · Nov 3, 1972 · N3824Q · Destroyed
- [NTSB NYC73AN065](https://openairdocs.org/ntsb/NYC73AN065.md): Fairchild FH227B · Winston-Salem, NC · Accident · Serious injuries · Closed · Nov 1, 1972 · N701U · No damage
- [NTSB NYC73AN060](https://openairdocs.org/ntsb/NYC73AN060.md): Beech A36 · Morgantown, WV · Accident · 3 fatal · Closed · Nov 1, 1972 · N9160Q · Destroyed
- [NTSB MIA73FKA05](https://openairdocs.org/ntsb/MIA73FKA05.md): Cessna 172C · Culebra, PR · Accident · Serious injuries · Closed · Nov 1, 1972 · N8293X · Destroyed
- [NTSB NYC73FHA10](https://openairdocs.org/ntsb/NYC73FHA10.md): Cessna 150K · Manville, NJ · Accident · No injuries · Closed · Oct 31, 1972 · N8411M · Substantial damage
- [NTSB FTW73FQD09](https://openairdocs.org/ntsb/FTW73FQD09.md): Cessna 150 · Fabens, TX · Accident · No injuries · Closed · Oct 30, 1972 · N7212S · Substantial damage
- [NTSB MIA73DLD25](https://openairdocs.org/ntsb/MIA73DLD25.md): Cessna 172 · Daytona Beach, FL · Accident · No injuries · Closed · Oct 27, 1972 · N84465 · Substantial damage
- [NTSB SEA73DYG18](https://openairdocs.org/ntsb/SEA73DYG18.md): Robertson 182J · Connell, WA · Accident · No injuries · Closed · Oct 25, 1972 · N3392F · Substantial damage
- [NTSB MKC73AKO29](https://openairdocs.org/ntsb/MKC73AKO29.md): Cessna 150L · Ames, IA · Accident · No injuries · Closed · Oct 24, 1972 · N16107 · 2 aircraft · Substantial damage
- [NTSB DEN73FQA19](https://openairdocs.org/ntsb/DEN73FQA19.md): Smith DSA-1 · Albuquerque, NM · Accident · Serious injuries · Closed · Oct 23, 1972 · N354S · Substantial damage
- [NTSB CHI73AC043](https://openairdocs.org/ntsb/CHI73AC043.md): Aero Comdr 500-A · Pekin, IL · Accident · 6 fatal · Closed · Oct 23, 1972 · N78376 · Destroyed
- [NTSB LAX73FUA18](https://openairdocs.org/ntsb/LAX73FUA18.md): Cessna 150J · Lomita, CA · Accident · Minor injuries · Closed · Oct 21, 1972 · N61257 · Substantial damage
- [NTSB DEN73FQA18](https://openairdocs.org/ntsb/DEN73FQA18.md): Cessna 206B · Moriarty, NM · Accident · No injuries · Closed · Oct 21, 1972 · N3403L · Substantial damage
- [NTSB UNK73X0101](https://openairdocs.org/ntsb/UNK73X0101.md): Beech 35P · Vancouver, Canada · Accident · 2 fatal · Closed · Oct 20, 1972 · N9656Y · Destroyed
- [NTSB DEN73AD016](https://openairdocs.org/ntsb/DEN73AD016.md): Cessna 182 · Denver, CO · Accident · 1 fatal · Closed · Oct 20, 1972 · N2458R · Destroyed
- [NTSB ANC73AA029](https://openairdocs.org/ntsb/ANC73AA029.md): Aero Comdr 680FL · Nome, AK · Accident · No injuries · Closed · Oct 20, 1972 · N264CP · Substantial damage
- [NTSB MIA73FKG45](https://openairdocs.org/ntsb/MIA73FKG45.md): Hughes 269C · Chamblee, GA · Accident · Minor injuries · Closed · Oct 19, 1972 · N9670F · Substantial damage
- [NTSB NYC73FHD17](https://openairdocs.org/ntsb/NYC73FHD17.md): Piper PA-30 · Philadelphia, PA · Accident · No injuries · Closed · Oct 18, 1972 · N8662Y · Substantial damage
- [NTSB MIA73DLD19](https://openairdocs.org/ntsb/MIA73DLD19.md): Aeronca 7ECA · Arcadia, FL · Accident · No injuries · Closed · Oct 15, 1972 · N8354V · Substantial damage
- [NTSB CHI73FEM21](https://openairdocs.org/ntsb/CHI73FEM21.md): Champion 7ECA · Plainwell, MI · Accident · Minor injuries · Closed · Oct 14, 1972 · N2671G · Substantial damage
- [NTSB MKC73FTG08](https://openairdocs.org/ntsb/MKC73FTG08.md): Cessna 150K · Cavalier, ND · Accident · No injuries · Closed · Oct 13, 1972 · N5785G · Substantial damage
- [NTSB DEN73FTE31](https://openairdocs.org/ntsb/DEN73FTE31.md): Cessna P206A · Nucla, CO · Accident · Serious injuries · Closed · Oct 13, 1972 · N2685X · Substantial damage
- [NTSB DEN73FTC11](https://openairdocs.org/ntsb/DEN73FTC11.md): Cessna T210F · Cheyenne, WY · Accident · Minor injuries · Closed · Oct 13, 1972 · N6185R · Destroyed
- [NTSB NYC73FFJ11](https://openairdocs.org/ntsb/NYC73FFJ11-201461.md): Cessna 140 · Etna, NY · Accident · No injuries · Closed · Oct 11, 1972 · N89814 · Substantial damage
- [NTSB SEA73ASO09](https://openairdocs.org/ntsb/SEA73ASO09.md): Piper PA-23 · Dixie, WA · Accident · 1 fatal · Closed · Oct 10, 1972 · N6707Y · Destroyed
- [NTSB NYC73FNA23](https://openairdocs.org/ntsb/NYC73FNA23.md): Mooney M20E · Lexington, MA · Accident · Minor injuries · Closed · Oct 9, 1972 · N6938U · Substantial damage
- [NTSB NYC73FHD16](https://openairdocs.org/ntsb/NYC73FHD16.md): Piper PA-28 · Bridgeport, NJ · Accident · No injuries · Closed · Oct 9, 1972 · N8996W · Substantial damage
- [NTSB CHI73ACO39](https://openairdocs.org/ntsb/CHI73ACO39.md): N. American SNJ-6 · Woodstock, IL · Accident · 1 fatal · Closed · Oct 9, 1972 · N7984C · Substantial damage
- [NTSB MIA73DLG24](https://openairdocs.org/ntsb/MIA73DLG24.md): Cessna 172H · Landrum, SC · Accident · No injuries · Closed · Oct 8, 1972 · N2881L · Substantial damage
- [NTSB LAX73FUJ25](https://openairdocs.org/ntsb/LAX73FUJ25.md): Corben Baby ACE B1 · Mesa, AZ · Accident · Minor injuries · Closed · Oct 8, 1972 · N7789C · Substantial damage
- [NTSB CHI73FEI15](https://openairdocs.org/ntsb/CHI73FEI15.md): Cessna 172 · Medina, OH · Accident · No injuries · Closed · Oct 8, 1972 · N7805G · Substantial damage
- [NTSB OAK73FVW10](https://openairdocs.org/ntsb/OAK73FVW10.md): Piper PA-28 · Henderson, NV · Accident · No injuries · Closed · Oct 7, 1972 · N516FL · Substantial damage
- [NTSB OAK73FVM16](https://openairdocs.org/ntsb/OAK73FVM16.md): Midget Mstg Cupp · San Jose, CA · Accident · Serious injuries · Closed · Oct 7, 1972 · N93177 · Destroyed
- [NTSB CHI73DEM27](https://openairdocs.org/ntsb/CHI73DEM27.md): Piper PA-32 · Lake City, MI · Accident · No injuries · Closed · Oct 7, 1972 · N4727S · Substantial damage
- [NTSB ANC73DAG48](https://openairdocs.org/ntsb/ANC73DAG48.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Closed · Oct 7, 1972 · N4158M · Substantial damage
- [NTSB ANC73AA025](https://openairdocs.org/ntsb/ANC73AA025.md): Piper PA-18 · Iliamna, AK · Accident · 1 fatal · Closed · Oct 7, 1972 · N2263A · Destroyed
- [NTSB NYC73FGT04](https://openairdocs.org/ntsb/NYC73FGT04.md): Piper PA-23 · Carlisle, PA · Accident · No injuries · Closed · Oct 5, 1972 · N2236P · Substantial damage
- [NTSB CHI73FLQ14](https://openairdocs.org/ntsb/CHI73FLQ14.md): Cessna 150H · Louisville, KY · Accident · Minor injuries · Closed · Oct 5, 1972 · N7119S · Substantial damage
- [NTSB CHI73AC036](https://openairdocs.org/ntsb/CHI73AC036.md): Schleicher AS-K13 · Oxford, MI · Accident · 1 fatal · Closed · Oct 4, 1972 · N3105 · Destroyed
- [NTSB OAK73FVA22](https://openairdocs.org/ntsb/OAK73FVA22.md): Piper PA-22 · Riverdale, CA · Accident · No injuries · Closed · Oct 1, 1972 · N2540A · Substantial damage

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

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

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