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

## Cases, newest first

- [NTSB OAK75DVD28](https://openairdocs.org/ntsb/OAK75DVD28.md): Cessna 182 · Santa Rosa, CA · Accident · Minor injuries · Closed · Dec 26, 1974 · N182CT · Substantial damage
- [NTSB OAK75FVG42](https://openairdocs.org/ntsb/OAK75FVG42.md): Cessna 150 · Chico, CA · Accident · No injuries · Closed · Dec 25, 1974 · N3315J · Destroyed
- [NTSB MIA75DLD44](https://openairdocs.org/ntsb/MIA75DLD44.md): Beech B50 · Tampa, FL · Accident · Minor injuries · Closed · Dec 25, 1974 · N4862T · Substantial damage
- [NTSB MKC75FCG24](https://openairdocs.org/ntsb/MKC75FCG24.md): Beech P35 · Leawood, KS · Accident · Minor injuries · Closed · Dec 23, 1974 · N1582S · Substantial damage
- [NTSB MIA75AM038](https://openairdocs.org/ntsb/MIA75AM038.md): Piper PA-24 · Mobile, AL · Accident · 1 fatal · Closed · Dec 23, 1974 · N9168P · Destroyed
- [NTSB MIA75DKT35](https://openairdocs.org/ntsb/MIA75DKT35.md): Cessna 172L · Hollywood, FL · Accident · No injuries · Closed · Dec 22, 1974 · N4393Q · Substantial damage
- [NTSB CHI75FEI36](https://openairdocs.org/ntsb/CHI75FEI36.md): Piper PA-32 · Akron, OH · Accident · Minor injuries · Closed · Dec 22, 1974 · N56754 · Substantial damage
- [NTSB IAD75FKW08](https://openairdocs.org/ntsb/IAD75FKW08-144854.md): Beech A35 · Tullahoma, TN · Accident · No injuries · Closed · Dec 21, 1974 · N756B · Substantial damage
- [NTSB MIA75FKG53](https://openairdocs.org/ntsb/MIA75FKG53.md): Cessna 310K · Atlanta, GA · Accident · Serious injuries · Closed · Dec 20, 1974 · N7056L · Destroyed
- [NTSB MIA75AM035](https://openairdocs.org/ntsb/MIA75AM035.md): Beech 95-B55 · Atlanta, GA · Accident · 2 fatal · Closed · Dec 20, 1974 · N1633A · Destroyed
- [NTSB FTW75FQD14](https://openairdocs.org/ntsb/FTW75FQD14.md): Dehavilland DHC-2 · Van Horn, TX · Accident · No injuries · Closed · Dec 20, 1974 · N94477 · Substantial damage
- [NTSB CHI75FEC28](https://openairdocs.org/ntsb/CHI75FEC28.md): Piper PA-28 · Lake Orion, MI · Accident · No injuries · Closed · Dec 18, 1974 · N56497 · Substantial damage
- [NTSB MKC75FCA19](https://openairdocs.org/ntsb/MKC75FCA19.md): Amer Avco AA1-B · Fenton, MO · Accident · 1 fatal · Closed · Dec 17, 1974 · N8867L · Destroyed
- [NTSB LAX75FUJ47](https://openairdocs.org/ntsb/LAX75FUJ47.md): Cessna 210 · Maricopa, AZ · Accident · 1 fatal · Closed · Dec 17, 1974 · N711PV · Destroyed
- [NTSB OAK75DVD25](https://openairdocs.org/ntsb/OAK75DVD25.md): Cessna 150 · Danville, CA · Accident · No injuries · Closed · Dec 16, 1974 · N50596 · Substantial damage
- [NTSB FTW75IF042](https://openairdocs.org/ntsb/FTW75IF042.md): Boeing 727 · Houston, TX · Incident · No injuries · Closed · Dec 14, 1974 · N8152G · Minor damage
- [NTSB CHI75FEK18](https://openairdocs.org/ntsb/CHI75FEK18.md): Cessna 150L · Zanesville, OH · Accident · No injuries · Closed · Dec 11, 1974 · N11503 · Substantial damage
- [NTSB FTW75FRD17](https://openairdocs.org/ntsb/FTW75FRD17.md): Amer Avco AA1-B · Houma, LA · Accident · No injuries · Closed · Dec 10, 1974 · N6515L · Substantial damage
- [NTSB FTW75AF039](https://openairdocs.org/ntsb/FTW75AF039.md): Piper PA-23 · Denton, TX · Accident · 2 fatal · Closed · Dec 10, 1974 · N5085Y · Destroyed
- [NTSB OAK75FVM15](https://openairdocs.org/ntsb/OAK75FVM15.md): Cessna 150 · Woodside, CA · Accident · No injuries · Closed · Dec 7, 1974 · N6048J · Substantial damage
- [NTSB FTW75AF038](https://openairdocs.org/ntsb/FTW75AF038.md): Cessna 414 · Pine Bluff, AR · Accident · 4 fatal · Closed · Dec 6, 1974 · N44JG · Destroyed
- [NTSB MIA75AM030](https://openairdocs.org/ntsb/MIA75AM030.md): Beech 100 · Birmingham, AL · Accident · 2 fatal · Closed · Dec 1, 1974 · N50PC · Destroyed
- [NTSB DEN75FQA21](https://openairdocs.org/ntsb/DEN75FQA21.md): Cessna 180 · San Mateo, NM · Accident · Serious injuries · Closed · Dec 1, 1974 · N3697C · Destroyed
- [NTSB DCA75AZ005](https://openairdocs.org/ntsb/DCA75AZ005.md): Boeing 727 · Berryville, VA · Accident · 92 fatal · Closed · Dec 1, 1974 · N54328 · Destroyed
- [NTSB LAX75FVM14](https://openairdocs.org/ntsb/LAX75FVM14.md): Cessna 177 · Paso Robles, CA · Accident · Minor injuries · Closed · Nov 30, 1974 · N30349 · Substantial damage
- [NTSB FTW75AF036](https://openairdocs.org/ntsb/FTW75AF036.md): Bell 47G-4A · Venice, LA · Accident · Minor injuries · Closed · Nov 30, 1974 · N7848S · Destroyed
- [NTSB DEN75DTC10](https://openairdocs.org/ntsb/DEN75DTC10.md): Piper PA-18 · Rock Springs, WY · Accident · No injuries · Closed · Nov 28, 1974 · N1379A · Substantial damage
- [NTSB CHI75DEM21](https://openairdocs.org/ntsb/CHI75DEM21.md): Beech K35 · Gaylord, MI · Accident · Minor injuries · Closed · Nov 28, 1974 · N6068E · Substantial damage
- [NTSB SEA75DYA24](https://openairdocs.org/ntsb/SEA75DYA24.md): Piper PA-24 · Arco, ID · Accident · Minor injuries · Closed · Nov 27, 1974 · N7985P · Substantial damage
- [NTSB MIA75FKQ24](https://openairdocs.org/ntsb/MIA75FKQ24.md): Amer Avco AA-5 · Jackson, MS · Accident · Minor injuries · Closed · Nov 27, 1974 · N9590L · Substantial damage
- [NTSB LAX75FNG20](https://openairdocs.org/ntsb/LAX75FNG20.md): Cessna 150F · La Verne, CA · Accident · No injuries · Closed · Nov 25, 1974 · N8099S · Substantial damage
- [NTSB NYC75FFA21](https://openairdocs.org/ntsb/NYC75FFA21.md): Piper PA-28 · Westerlo, NY · Accident · Serious injuries · Closed · Nov 24, 1974 · N7470W · Substantial damage
- [NTSB NYC75DHA22](https://openairdocs.org/ntsb/NYC75DHA22.md): Piper PA-28 · Queen City, PA · Accident · No injuries · Closed · Nov 24, 1974 · N2438R · Substantial damage
- [NTSB MKC75DCG20](https://openairdocs.org/ntsb/MKC75DCG20.md): Cessna 150 · Olathe, KS · Accident · No injuries · Closed · Nov 24, 1974 · N6420F · Substantial damage
- [NTSB SEA75FYI17](https://openairdocs.org/ntsb/SEA75FYI17.md): Cessna 150 · North Bend, OR · Accident · No injuries · Closed · Nov 23, 1974 · N6960G · Substantial damage
- [NTSB NYC75FNA26](https://openairdocs.org/ntsb/NYC75FNA26.md): Piper PA-28 · Warwick, RI · Accident · No injuries · Closed · Nov 23, 1974 · N4375T · Substantial damage
- [NTSB NYC75FGM21](https://openairdocs.org/ntsb/NYC75FGM21.md): Piper PA-34 · Edensburg, PA · Accident · Minor injuries · Closed · Nov 23, 1974 · N15260 · Destroyed
- [NTSB FTW75DRA14](https://openairdocs.org/ntsb/FTW75DRA14.md): Cessna 150L · Orange, TX · Accident · Minor injuries · Closed · Nov 23, 1974 · N11265 · Substantial damage
- [NTSB CHI75FEC25](https://openairdocs.org/ntsb/CHI75FEC25.md): Bensen B-8M · Grosse Ile, MI · Accident · No injuries · Closed · Nov 23, 1974 · N104RJ · Substantial damage
- [NTSB LAX75DUM12](https://openairdocs.org/ntsb/LAX75DUM12.md): Mooney M20A · Oceanside, CA · Accident · Minor injuries · Closed · Nov 22, 1974 · N8198D · Substantial damage
- [NTSB LAX75AL028](https://openairdocs.org/ntsb/LAX75AL028.md): Beech D18S · Tustin, CA · Accident · 3 fatal · Closed · Nov 22, 1974 · N2085D · Destroyed
- [NTSB NYC75AN064](https://openairdocs.org/ntsb/NYC75AN064.md): Cessna 182L · White Plains, NY · Accident · 4 fatal · Closed · Nov 20, 1974 · N3343R · Destroyed
- [NTSB MKC75FER30](https://openairdocs.org/ntsb/MKC75FER30.md): Cessna 150L · Green Isle, MN · Accident · No injuries · Closed · Nov 17, 1974 · N569GS · Substantial damage
- [NTSB IAD75DKM14](https://openairdocs.org/ntsb/IAD75DKM14.md): Baby Ace E · Asheville, NC · Accident · 1 fatal · Closed · Nov 16, 1974 · N3556 · Substantial damage
- [NTSB DEN75AD029](https://openairdocs.org/ntsb/DEN75AD029.md): Cessna 180 · Sedalia, CO · Accident · 2 fatal · Closed · Nov 15, 1974 · N1523C · 2 aircraft · Destroyed
- [NTSB CHI75FEI28](https://openairdocs.org/ntsb/CHI75FEI28.md): Bede BD-4 · Mansfield, OH · Accident · Minor injuries · Closed · Nov 15, 1974 · N1734 · Substantial damage
- [NTSB LAX75DUJ44](https://openairdocs.org/ntsb/LAX75DUJ44.md): Cessna 172 · Window Rock, AZ · Accident · No injuries · Closed · Nov 14, 1974 · N4469R · Destroyed
- [NTSB IAD75FID11](https://openairdocs.org/ntsb/IAD75FID11.md): Cessna 172 · Highland Spgs, VA · Accident · No injuries · Closed · Nov 14, 1974 · N2369U · Destroyed
- [NTSB NYC75AN061](https://openairdocs.org/ntsb/NYC75AN061.md): Cessna 182P · Niagara Falls, NY · Accident · 1 fatal · Closed · Nov 13, 1974 · N21168 · Destroyed
- [NTSB NYC75FNC18](https://openairdocs.org/ntsb/NYC75FNC18.md): Cessna 150L · Nashua, NH · Accident · No injuries · Closed · Nov 9, 1974 · N11392 · Substantial damage

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

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

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