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

## Cases, newest first

- [NTSB MIA72FLA46](https://openairdocs.org/ntsb/MIA72FLA46.md): Cessna 310P · Gainesville, FL · Accident · No injuries · Closed · May 28, 1972 · N5843M · Substantial damage
- [NTSB ANC72DAG12](https://openairdocs.org/ntsb/ANC72DAG12-107193.md): Cessna 150L · Goose Bay, AK · Accident · No injuries · Closed · May 27, 1972 · N5352Q · Substantial damage
- [NTSB OAK72AP043](https://openairdocs.org/ntsb/OAK72AP043.md): Cessna 150J · Modesto, CA · Accident · 1 fatal · Closed · May 26, 1972 · N60934 · Destroyed
- [NTSB DEN72DTE69](https://openairdocs.org/ntsb/DEN72DTE69.md): Cessna 182 · Frisco, CO · Accident · Minor injuries · Closed · May 26, 1972 · N2807Y · Substantial damage
- [NTSB NYC72FFA44](https://openairdocs.org/ntsb/NYC72FFA44.md): Aeronca 11AC · Broadalbin, NY · Accident · Minor injuries · Closed · May 25, 1972 · N9672E · Substantial damage
- [NTSB NYC72FFA43](https://openairdocs.org/ntsb/NYC72FFA43.md): Cessna 182 · Glens Falls, NY · Accident · No injuries · Closed · May 24, 1972 · N7384Q · Substantial damage
- [NTSB LAX72DUG75](https://openairdocs.org/ntsb/LAX72DUG75.md): Cessna 150 · Bg Bear Cty, CA · Accident · Minor injuries · Closed · May 24, 1972 · N23113 · Substantial damage
- [NTSB FTW72FRG88](https://openairdocs.org/ntsb/FTW72FRG88.md): Cessna 177 · Austin, TX · Accident · Minor injuries · Closed · May 24, 1972 · N30205 · Substantial damage
- [NTSB OAK72FVD47](https://openairdocs.org/ntsb/OAK72FVD47.md): Luscombe 8A · Ukiah, CA · Accident · Minor injuries · Closed · May 23, 1972 · N77898 · Destroyed
- [NTSB NYC73FNE12](https://openairdocs.org/ntsb/NYC73FNE12.md): Piper PA-18 · New Milford, CT · Accident · No injuries · Closed · May 23, 1972 · N1361A · Destroyed
- [NTSB MIA72FKW28](https://openairdocs.org/ntsb/MIA72FKW28.md): Piper J3C-65 · Elizabethton, TN · Accident · No injuries · Closed · May 23, 1972 · N98429 · Substantial damage
- [NTSB FTW72AF080](https://openairdocs.org/ntsb/FTW72AF080.md): Piper PA-32 · Hammond, LA · Accident · 2 fatal · Closed · May 23, 1972 · N7736J · Destroyed
- [NTSB CHI72FEA40](https://openairdocs.org/ntsb/CHI72FEA40.md): Piper PA-28 · Lafayette, IN · Accident · Minor injuries · Closed · May 23, 1972 · N286P · Substantial damage
- [NTSB MIA72FLD69](https://openairdocs.org/ntsb/MIA72FLD69.md): Cessna 150H · Titusville, FL · Accident · Minor injuries · Closed · May 22, 1972 · N22306 · Destroyed
- [NTSB LAX72FUA37](https://openairdocs.org/ntsb/LAX72FUA37.md): Cessna 150K · Hntngtn Bch, CA · Accident · No injuries · Closed · May 22, 1972 · N6357G · Substantial damage
- [NTSB FTW72FPM31](https://openairdocs.org/ntsb/FTW72FPM31.md): Cessna 172D · Grove, OK · Accident · Minor injuries · Closed · May 21, 1972 · N2406Y · Substantial damage
- [NTSB CHI72FEG37](https://openairdocs.org/ntsb/CHI72FEG37.md): Luscombe 8E · Bidwell, OH · Accident · Minor injuries · Closed · May 21, 1972 · N2747K · Substantial damage
- [NTSB SEA72FYC42](https://openairdocs.org/ntsb/SEA72FYC42.md): Taylorcraft BC12-D · Vancouver, WA · Accident · No injuries · Closed · May 20, 1972 · N43387 · Substantial damage
- [NTSB NYC72FLJ34](https://openairdocs.org/ntsb/NYC72FLJ34.md): Cessna 150 · Rocky Mount, NC · Accident · Minor injuries · Closed · May 20, 1972 · N60308 · Substantial damage
- [NTSB MIA72DKJ54](https://openairdocs.org/ntsb/MIA72DKJ54.md): Schweizer SGS233 · Estaboga, AL · Accident · No injuries · Closed · May 20, 1972 · N2496W · Substantial damage
- [NTSB FTW72DPA23](https://openairdocs.org/ntsb/FTW72DPA23.md): Globe GC-1B · Dallas, TX · Accident · No injuries · Closed · May 19, 1972 · N3803K · Substantial damage
- [NTSB NYC72FKM37](https://openairdocs.org/ntsb/NYC72FKM37.md): Aero Comdr 680 · Shelby, NC · Accident · Minor injuries · Closed · May 18, 1972 · N4432W · Substantial damage
- [NTSB MKC72AK062](https://openairdocs.org/ntsb/MKC72AK062.md): Piper PA-28 · Anoka, MN · Accident · Minor injuries · Closed · May 18, 1972 · N502UM · Substantial damage
- [NTSB FTW72AF078](https://openairdocs.org/ntsb/FTW72AF078.md): Cessna 177 · Many, LA · Accident · 1 fatal · Closed · May 18, 1972 · N3344T · Destroyed
- [NTSB MIA72FLG40](https://openairdocs.org/ntsb/MIA72FLG40.md): Cessna A185E · Columbia, SC · Accident · No injuries · Closed · May 16, 1972 · N4AC · Substantial damage
- [NTSB LAX72AL055](https://openairdocs.org/ntsb/LAX72AL055.md): Cessna 182J · Redlands, CA · Accident · 1 fatal · Closed · May 16, 1972 · N3467F · 2 aircraft · Minor damage
- [NTSB CHI72FEP45](https://openairdocs.org/ntsb/CHI72FEP45.md): Bensen B-8 · Wiscnsin Rpds, WI · Accident · 1 fatal · Closed · May 16, 1972 · N2362 · Destroyed
- [NTSB MIA72AM124](https://openairdocs.org/ntsb/MIA72AM124.md): Cessna 414 · Merritt Islnd, FL · Accident · 1 fatal · Closed · May 15, 1972 · N8137Q · Destroyed
- [NTSB MKC72DCG54](https://openairdocs.org/ntsb/MKC72DCG54.md): Mooney M18C · Lees Summit, MO · Accident · No injuries · Closed · May 14, 1972 · N486M · Substantial damage
- [NTSB NYC72FFA41](https://openairdocs.org/ntsb/NYC72FFA41.md): Piper PA-23 · Cobleskill, NY · Accident · No injuries · Closed · May 13, 1972 · N5958Y · Substantial damage
- [NTSB NYC72DFJ41](https://openairdocs.org/ntsb/NYC72DFJ41.md): Piper PA-28 · Manchester, NY · Accident · No injuries · Closed · May 13, 1972 · N4459J · Substantial damage
- [NTSB SEA72DYE31](https://openairdocs.org/ntsb/SEA72DYE31.md): Erco 415-C · Bellevue, WA · Accident · No injuries · Closed · May 11, 1972 · N2041H · Substantial damage
- [NTSB NYC72DGM45](https://openairdocs.org/ntsb/NYC72DGM45.md): Stinson 108-2 · Scottsdale, PA · Accident · No injuries · Closed · May 11, 1972 · N9464K · Substantial damage
- [NTSB FTW72FPM29](https://openairdocs.org/ntsb/FTW72FPM29.md): Cessna 177 · Disney, OK · Accident · No injuries · Closed · May 11, 1972 · N2903X · Substantial damage
- [NTSB FTW72DPD43](https://openairdocs.org/ntsb/FTW72DPD43.md): Cessna 150 · Keene, TX · Accident · Minor injuries · Closed · May 7, 1972 · N2458J · Substantial damage
- [NTSB NYC72FFA38](https://openairdocs.org/ntsb/NYC72FFA38.md): Piper PA-18 · Oneonta, NY · Accident · No injuries · Closed · May 6, 1972 · N1209A · Substantial damage
- [NTSB NYC72DFA40](https://openairdocs.org/ntsb/NYC72DFA40.md): Schweizer SGS222 · Ballston Spa, NY · Accident · Minor injuries · Closed · May 6, 1972 · N91843 · Substantial damage
- [NTSB MKC72DER58](https://openairdocs.org/ntsb/MKC72DER58.md): Cessna 170A · Anoka, MN · Accident · No injuries · Closed · May 6, 1972 · N1403D · Substantial damage
- [NTSB SEA72AS049](https://openairdocs.org/ntsb/SEA72AS049.md): Piper J5A · Spanaway, WA · Accident · 1 fatal · Closed · May 5, 1972 · N38289 · Destroyed
- [NTSB MKC72FCG51](https://openairdocs.org/ntsb/MKC72FCG51.md): Cessna 172H · Gardner, KS · Accident · Minor injuries · Closed · May 4, 1972 · N3864R · Destroyed
- [NTSB NYC72AN139](https://openairdocs.org/ntsb/NYC72AN139.md): Beech 95-E55 · Groton, CT · Accident · 1 fatal · Closed · May 3, 1972 · N793Q · Destroyed
- [NTSB FTW72DQG39](https://openairdocs.org/ntsb/FTW72DQG39.md): Beech J35 · San Angelo, TX · Accident · No injuries · Closed · May 2, 1972 · N264AA · Substantial damage
- [NTSB CHI73AC085](https://openairdocs.org/ntsb/CHI73AC085-165945.md): Beech 65-A90 · Racine, WI · Accident · 5 fatal · Closed · May 1, 1972 · N295X · Destroyed
- [NTSB OAK72DVG53](https://openairdocs.org/ntsb/OAK72DVG53.md): Cessna 206 · Woodland, CA · Accident · Minor injuries · Closed · Apr 30, 1972 · N72148 · Substantial damage
- [NTSB NYC72FHM46](https://openairdocs.org/ntsb/NYC72FHM46.md): Piper PA-28 · White Lake, NY · Accident · No injuries · Closed · Apr 30, 1972 · N6336R · Substantial damage
- [NTSB SEA72FYC38](https://openairdocs.org/ntsb/SEA72FYC38.md): Piper PA-28 · Vancouver, WA · Accident · Serious injuries · Closed · Apr 29, 1972 · N8814N · Substantial damage
- [NTSB CHI72FEE77](https://openairdocs.org/ntsb/CHI72FEE77.md): Piper PA-23 · Spring Grove, IL · Accident · No injuries · Closed · Apr 29, 1972 · N2173P · Substantial damage
- [NTSB NYC72FGM42](https://openairdocs.org/ntsb/NYC72FGM42.md): Piper PA-28 · New Cumbrlnd, WV · Accident · No injuries · Closed · Apr 28, 1972 · N4522R · Substantial damage
- [NTSB LAX72DUJ93](https://openairdocs.org/ntsb/LAX72DUJ93.md): Cessna 150 · Phoenix, AZ · Accident · No injuries · Closed · Apr 26, 1972 · N51050 · Substantial damage
- [NTSB SEA72DYI21](https://openairdocs.org/ntsb/SEA72DYI21.md): Cessna 172K · North Bend, OR · Accident · Minor injuries · Closed · Apr 25, 1972 · N84196 · Destroyed

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

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

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