# 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 287 of 420 · 20,992 cases

## Cases, newest first

- [NTSB NYC76FGT12](https://openairdocs.org/ntsb/NYC76FGT12.md): Schweizer 2-33 · Julian, PA · Accident · No injuries · Closed · Nov 15, 1975 · N7703S · Substantial damage
- [NTSB NYC76FGT10](https://openairdocs.org/ntsb/NYC76FGT10.md): Schweizer 1-23D · Wingate, PA · Accident · Minor injuries · Closed · Nov 14, 1975 · N7840C · Substantial damage
- [NTSB MKC76FCG35](https://openairdocs.org/ntsb/MKC76FCG35.md): Cessna 150L · Springfield, MO · Accident · No injuries · Closed · Nov 13, 1975 · N7286G · Substantial damage
- [NTSB IAD76AI033](https://openairdocs.org/ntsb/IAD76AI033.md): Mitsubishi MU-2K · Jefferson City, TN · Accident · 5 fatal · Closed · Nov 13, 1975 · N69QJ · Destroyed
- [NTSB DEN76FTC20](https://openairdocs.org/ntsb/DEN76FTC20.md): Piper PA-18 · Casper, WY · Accident · No injuries · Closed · Nov 12, 1975 · N4498Z · Substantial damage
- [NTSB DCA76AZ011](https://openairdocs.org/ntsb/DCA76AZ011.md): Boeing 727 · Raleigh, NC · Accident · Serious injuries · Closed · Nov 12, 1975 · N8838E · Substantial damage
- [NTSB ANC76AAG71](https://openairdocs.org/ntsb/ANC76AAG71.md): Stinson 108 · Port Alsworth, AK · Accident · Minor injuries · Closed · Nov 12, 1975 · N97677 · Substantial damage
- [NTSB NYC76DHA17](https://openairdocs.org/ntsb/NYC76DHA17.md): Schweizer 1-26A · Hainesburg, NJ · Accident · No injuries · Closed · Nov 11, 1975 · N862R · Substantial damage
- [NTSB OAK76DVM13](https://openairdocs.org/ntsb/OAK76DVM13.md): Piper PA-24 · San Luis Obspo, CA · Accident · No injuries · Closed · Nov 10, 1975 · N7479P · Substantial damage
- [NTSB IAD76II031](https://openairdocs.org/ntsb/IAD76II031.md): Nihon YS-11 · Jacksonville, NC · Incident · No injuries · Closed · Nov 10, 1975 · N7218 · Minor damage
- [NTSB DEN76FQA24](https://openairdocs.org/ntsb/DEN76FQA24.md): Cessna 206 · Abiquiu, NM · Accident · No injuries · Closed · Nov 10, 1975 · N12007 · Substantial damage
- [NTSB ANC76DAG64](https://openairdocs.org/ntsb/ANC76DAG64.md): Maule M-4210 · Anchorage, AK · Accident · No injuries · Closed · Nov 10, 1975 · N9808M · Substantial damage
- [NTSB MIA76FKG31](https://openairdocs.org/ntsb/MIA76FKG31.md): Cessna 182 · Atlanta, GA · Accident · No injuries · Closed · Nov 9, 1975 · N7380N · Substantial damage
- [NTSB OAK76DVM12](https://openairdocs.org/ntsb/OAK76DVM12.md): Piper PA-28 · King City, CA · Accident · No injuries · Closed · Nov 8, 1975 · N7252W · Substantial damage
- [NTSB LAX76FUM11](https://openairdocs.org/ntsb/LAX76FUM11.md): Kraehe V · San Luis Obspo, CA · Accident · Serious injuries · Closed · Nov 8, 1975 · N620W · Destroyed
- [NTSB IAD76FKM16](https://openairdocs.org/ntsb/IAD76FKM16.md): Cessna 172 · Wadesboro, NC · Accident · Serious injuries · Closed · Nov 4, 1975 · N21850 · Destroyed
- [NTSB OAK76AP025](https://openairdocs.org/ntsb/OAK76AP025.md): Aeronca 11AC · Lincoln, CA · Accident · 2 fatal · Closed · Nov 2, 1975 · N3191E · Destroyed
- [NTSB MKC76FCG30](https://openairdocs.org/ntsb/MKC76FCG30.md): Piper J-3 · Grain Valley, MO · Accident · Minor injuries · Closed · Nov 2, 1975 · N28113 · Substantial damage
- [NTSB FTW76FPM12](https://openairdocs.org/ntsb/FTW76FPM12.md): Mooney M20C · Tulsa, OK · Accident · No injuries · Closed · Nov 2, 1975 · N7865V · Substantial damage
- [NTSB LAX76DYA24](https://openairdocs.org/ntsb/LAX76DYA24.md): Cessna 210L · Lost Hills, CA · Accident · No injuries · Closed · Nov 1, 1975 · N93111 · Substantial damage
- [NTSB IAD76FID15](https://openairdocs.org/ntsb/IAD76FID15.md): Amer Avco AA-1A · Ashland, VA · Accident · Minor injuries · Closed · Nov 1, 1975 · N9458L · Destroyed
- [NTSB FTW76DRG28](https://openairdocs.org/ntsb/FTW76DRG28.md): Alon A-2 · San Antonio, TX · Accident · No injuries · Closed · Nov 1, 1975 · N6593Q · Substantial damage
- [NTSB MKC76FER35](https://openairdocs.org/ntsb/MKC76FER35.md): Cessna 150B · South St Paul, MN · Accident · Minor injuries · Closed · Oct 31, 1975 · N7329X · Substantial damage
- [NTSB LAX76AL032](https://openairdocs.org/ntsb/LAX76AL032.md): Piper PA-23 · San Dimas, CA · Accident · 3 fatal · Closed · Oct 31, 1975 · N1356E · Destroyed
- [NTSB FTW76FRA15](https://openairdocs.org/ntsb/FTW76FRA15.md): Beech V35B · Houston, TX · Accident · Minor injuries · Closed · Oct 29, 1975 · N1655W · Substantial damage
- [NTSB MKC76FCD17](https://openairdocs.org/ntsb/MKC76FCD17.md): Cessna 210A · Council Bluffs, IA · Accident · Serious injuries · Closed · Oct 28, 1975 · N9424X · Substantial damage
- [NTSB CHI76AC034](https://openairdocs.org/ntsb/CHI76AC034.md): Piper PA-28 · Salem, MI · Accident · 2 fatal · Closed · Oct 26, 1975 · N5394L · 2 aircraft · Destroyed
- [NTSB MIA76DLG23](https://openairdocs.org/ntsb/MIA76DLG23.md): Cessna 172 · Blair, SC · Accident · No injuries · Closed · Oct 25, 1975 · N6439E · Substantial damage
- [NTSB FTW76FPD17](https://openairdocs.org/ntsb/FTW76FPD17.md): Cessna 175 · Denton, TX · Accident · Serious injuries · Closed · Oct 25, 1975 · N7122M · Substantial damage
- [NTSB OAK76DVG30](https://openairdocs.org/ntsb/OAK76DVG30.md): Cessna 182 · Davis, CA · Accident · No injuries · Closed · Oct 24, 1975 · N5403B · Substantial damage
- [NTSB NYC76DFJ11](https://openairdocs.org/ntsb/NYC76DFJ11.md): Cessna 150 · Lockport, NY · Accident · Minor injuries · Closed · Oct 23, 1975 · N5564G · Substantial damage
- [NTSB DEN76AD020](https://openairdocs.org/ntsb/DEN76AD020.md): Champion 7GC · Lordsburg, NM · Accident · 2 fatal · Closed · Oct 23, 1975 · N8547E · Destroyed
- [NTSB CHI76DEE27](https://openairdocs.org/ntsb/CHI76DEE27.md): Piper PA-32 · Lansing, IL · Accident · No injuries · Closed · Oct 22, 1975 · N4078R · Substantial damage
- [NTSB MIA76FLG21](https://openairdocs.org/ntsb/MIA76FLG21.md): Cessna 210L · Greer, SC · Accident · Serious injuries · Closed · Oct 19, 1975 · N210EM · Destroyed
- [NTSB IAD76FIA03](https://openairdocs.org/ntsb/IAD76FIA03.md): Cessna P206D · Fredericksburg, VA · Accident · Serious injuries · Closed · Oct 19, 1975 · N8728Z · Destroyed
- [NTSB MIA76DLG20](https://openairdocs.org/ntsb/MIA76DLG20.md): Piper PA-28R · Florence, SC · Accident · Minor injuries · Closed · Oct 17, 1975 · N3988X · Destroyed
- [NTSB LAX76AL025](https://openairdocs.org/ntsb/LAX76AL025.md): Cessna 182 · Richfield, UT · Accident · No injuries · Closed · Oct 17, 1975 · N14MD · 2 aircraft · Minor damage
- [NTSB LAX76AL024](https://openairdocs.org/ntsb/LAX76AL024.md): Beech 95-C55 · Santa Ana, CA · Accident · 1 fatal · Closed · Oct 17, 1975 · N100PW · Destroyed
- [NTSB NYC76FHA13](https://openairdocs.org/ntsb/NYC76FHA13-151531.md): Beech J35 · Basking Ridge, NJ · Accident · Minor injuries · Closed · Oct 16, 1975 · N8398D · Destroyed
- [NTSB NYC76DNA18](https://openairdocs.org/ntsb/NYC76DNA18.md): Beech B19 · Beverly, MA · Accident · No injuries · Closed · Oct 16, 1975 · N9749L · Substantial damage
- [NTSB FTW76AF032](https://openairdocs.org/ntsb/FTW76AF032.md): Mooney M20C · Robstown, TX · Accident · 4 fatal · Closed · Oct 16, 1975 · N79333 · Destroyed
- [NTSB CHI76FEG06](https://openairdocs.org/ntsb/CHI76FEG06.md): Pitts S2A · Harrison, OH · Accident · Serious injuries · Closed · Oct 15, 1975 · N80032 · Substantial damage
- [NTSB CHI76FEC13](https://openairdocs.org/ntsb/CHI76FEC13.md): Cessna 182N · Flint, MI · Accident · Minor injuries · Closed · Oct 14, 1975 · N9136G · Substantial damage
- [NTSB OAK76DXQ18](https://openairdocs.org/ntsb/OAK76DXQ18.md): Cessna 182 · So.Lake Tahoe, CA · Accident · No injuries · Closed · Oct 13, 1975 · N42598 · Substantial damage
- [NTSB MKC76FTK11](https://openairdocs.org/ntsb/MKC76FTK11.md): Schreder HP-16 · Lennox, SD · Accident · Serious injuries · Closed · Oct 12, 1975 · N16DH · Destroyed
- [NTSB MKC76FCD15](https://openairdocs.org/ntsb/MKC76FCD15.md): Beech J35 · Spencer, IA · Accident · Serious injuries · Closed · Oct 12, 1975 · N4531D · Destroyed
- [NTSB MKC76AK027](https://openairdocs.org/ntsb/MKC76AK027.md): Mooney M20C · St Charles, MO · Accident · 2 fatal · Closed · Oct 12, 1975 · N6050Q · Destroyed
- [NTSB LAX76DUJ37](https://openairdocs.org/ntsb/LAX76DUJ37.md): Stinson V-77 · House Rock, AZ · Accident · 1 fatal · Closed · Oct 12, 1975 · N69395 · Substantial damage
- [NTSB DEN76FTE30](https://openairdocs.org/ntsb/DEN76FTE30.md): Beech 95-B55 · Lake City, CO · Accident · No injuries · Closed · Oct 12, 1975 · N9033V · Substantial damage
- [NTSB CHI76FEP16](https://openairdocs.org/ntsb/CHI76FEP16.md): Cessna 150H · Lake Geneva, WI · Accident · No injuries · Closed · Oct 12, 1975 · N50127 · Substantial damage

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

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

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