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

## Cases, newest first

- [NTSB MKC74AK009](https://openairdocs.org/ntsb/MKC74AK009.md): Luscombe 8E · Harper, KS · Accident · 1 fatal · Closed · Sep 3, 1973 · N1655K · Destroyed
- [NTSB SEA74DYE09](https://openairdocs.org/ntsb/SEA74DYE09.md): Bell 205-A1 · Lester, WA · Accident · No injuries · Closed · Sep 2, 1973 · N1440W · Destroyed
- [NTSB FTW74FRJ10](https://openairdocs.org/ntsb/FTW74FRJ10.md): Piper PA-28 · Shreveport, LA · Accident · Minor injuries · Closed · Aug 31, 1973 · N5064T · Substantial damage
- [NTSB NYC74FHD15](https://openairdocs.org/ntsb/NYC74FHD15.md): Piper PA-28 · Berlin, NJ · Accident · No injuries · Closed · Aug 29, 1973 · N8260N · Substantial damage
- [NTSB OAK74FXQ09](https://openairdocs.org/ntsb/OAK74FXQ09.md): Piper PA-28 · Reno, NV · Accident · No injuries · Closed · Aug 27, 1973 · N847E · Substantial damage
- [NTSB SEA74DYG11](https://openairdocs.org/ntsb/SEA74DYG11.md): Bellanca 14-193 · Orofino, ID · Accident · No injuries · Closed · Aug 26, 1973 · N74450 · Substantial damage
- [NTSB LAX74DUJ12](https://openairdocs.org/ntsb/LAX74DUJ12.md): Let-Np-K L-13 · Tucson, AZ · Accident · No injuries · Closed · Aug 25, 1973 · N3460 · Substantial damage
- [NTSB CHI74DEI13](https://openairdocs.org/ntsb/CHI74DEI13.md): Schweizer 2-22 · Medina, OH · Accident · Serious injuries · Closed · Aug 25, 1973 · N8679R · Substantial damage
- [NTSB CHI74AC016](https://openairdocs.org/ntsb/CHI74AC016.md): Aero Comdr 520 · Michigan City, IN · Accident · Serious injuries · Closed · Aug 25, 1973 · N2634B · Destroyed
- [NTSB FTW74DRJ07](https://openairdocs.org/ntsb/FTW74DRJ07.md): Cessna 150H · Ruston, LA · Accident · No injuries · Closed · Aug 23, 1973 · N23392 · Substantial damage
- [NTSB ANC74DAG25](https://openairdocs.org/ntsb/ANC74DAG25-201628.md): Piper PA-12 · Kenai, AK · Accident · No injuries · Closed · Aug 23, 1973 · N4362M · Substantial damage
- [NTSB FTW74FRA11](https://openairdocs.org/ntsb/FTW74FRA11.md): Convair BT-13A · Galveston, TX · Accident · Serious injuries · Closed · Aug 22, 1973 · N2200S · Substantial damage
- [NTSB LAX74FUD02](https://openairdocs.org/ntsb/LAX74FUD02.md): Cessna 150L · Los Angeles, CA · Accident · Minor injuries · Closed · Aug 21, 1973 · N1501Q · Substantial damage
- [NTSB SEA74FYC06](https://openairdocs.org/ntsb/SEA74FYC06.md): Cessna 150L · Granite, OR · Accident · Serious injuries · Closed · Aug 20, 1973 · N10865 · Substantial damage
- [NTSB MKC74DCD21](https://openairdocs.org/ntsb/MKC74DCD21.md): Mooney M20C · Marion, IA · Accident · No injuries · Closed · Aug 20, 1973 · N6757N · Substantial damage
- [NTSB IAD74FLT05](https://openairdocs.org/ntsb/IAD74FLT05.md): Piper PA-23 · Memphis, TN · Accident · No injuries · Closed · Aug 20, 1973 · N1130P · Substantial damage
- [NTSB FTW74DPG14](https://openairdocs.org/ntsb/FTW74DPG14.md): Piper PA-18 · Barton, AR · Accident · Minor injuries · Closed · Aug 20, 1973 · N4694Y · Destroyed
- [NTSB UNK73X0121](https://openairdocs.org/ntsb/UNK73X0121.md): Taylor Titch · Salem, IL · Accident · 1 fatal · Closed · Aug 19, 1973 · N1SK · Destroyed
- [NTSB NYC74DHD11](https://openairdocs.org/ntsb/NYC74DHD11.md): Amer Avco AA1-B · Bristol, PA · Accident · Minor injuries · Closed · Aug 19, 1973 · N9627L · Destroyed
- [NTSB NYC74AN017](https://openairdocs.org/ntsb/NYC74AN017.md): Piper PA-12 · Haverhill, MA · Accident · 2 fatal · Closed · Aug 19, 1973 · N4192M · Destroyed
- [NTSB MKC74DER43](https://openairdocs.org/ntsb/MKC74DER43.md): Piper PA-18 · Intl Falls, MN · Accident · Minor injuries · Closed · Aug 18, 1973 · N5415H · Substantial damage
- [NTSB MIA74FKT11](https://openairdocs.org/ntsb/MIA74FKT11.md): Beech C-45H · Indiantown, FL · Accident · No injuries · Closed · Aug 18, 1973 · N3722G · Substantial damage
- [NTSB LAX74AL017](https://openairdocs.org/ntsb/LAX74AL017.md): Mooney M20-F · Shoshone, CA · Accident · 3 fatal · Closed · Aug 18, 1973 · N6311Q · Destroyed
- [NTSB NYC74DNC17](https://openairdocs.org/ntsb/NYC74DNC17.md): Cessna 150G · Wiscasset, ME · Accident · No injuries · Closed · Aug 17, 1973 · N8556J · Substantial damage
- [NTSB NYC74AN015](https://openairdocs.org/ntsb/NYC74AN015-201621.md): Beech S35 · State College, PA · Accident · Serious injuries · Closed · Aug 17, 1973 · N434V · Substantial damage
- [NTSB MIA74IM020](https://openairdocs.org/ntsb/MIA74IM020.md): Lockheed 1011 · Miami, FL · Incident · No injuries · Closed · Aug 17, 1973 · N305EA · No damage
- [NTSB CHI74AC014](https://openairdocs.org/ntsb/CHI74AC014.md): Piper PA-28 · Batavia, OH · Accident · No injuries · Closed · Aug 17, 1973 · N15897 · 2 aircraft · Substantial damage
- [NTSB NYC74DGT06](https://openairdocs.org/ntsb/NYC74DGT06.md): Piper PA-28 · Annville, PA · Accident · No injuries · Closed · Aug 16, 1973 · N655FL · Substantial damage
- [NTSB LAX74FUQ12](https://openairdocs.org/ntsb/LAX74FUQ12.md): Bellanca 17-30A · Ridgecrest, CA · Accident · Serious injuries · Closed · Aug 16, 1973 · N8832V · Destroyed
- [NTSB CHI74FEC07](https://openairdocs.org/ntsb/CHI74FEC07.md): Piper PA-22 · Petersburg, MI · Accident · No injuries · Closed · Aug 16, 1973 · N3767A · Substantial damage
- [NTSB MKC74FCQ07](https://openairdocs.org/ntsb/MKC74FCQ07.md): Beech B19 · Wichita, KS · Accident · Serious injuries · Closed · Aug 14, 1973 · N1923W · Substantial damage
- [NTSB FTW74FPM05](https://openairdocs.org/ntsb/FTW74FPM05.md): Piper PA-22 · Tulsa, OK · Accident · No injuries · Closed · Aug 14, 1973 · N8039D · Substantial damage
- [NTSB ANC74DAG16](https://openairdocs.org/ntsb/ANC74DAG16.md): Piper PA-28R · Naknek, AK · Accident · Minor injuries · Closed · Aug 14, 1973 · N2992R · Substantial damage
- [NTSB NYC74FNC14](https://openairdocs.org/ntsb/NYC74FNC14.md): Taylorcraft BC12-D · Greenville, ME · Accident · Serious injuries · Closed · Aug 12, 1973 · N39271 · Destroyed
- [NTSB LAX74AL013](https://openairdocs.org/ntsb/LAX74AL013.md): Cessna 150L · Torrance, CA · Accident · 5 fatal · Closed · Aug 12, 1973 · N1783Q · 2 aircraft · Destroyed
- [NTSB CHI74FEP11](https://openairdocs.org/ntsb/CHI74FEP11.md): Cessna 170B · Kenosha, WI · Accident · Minor injuries · Closed · Aug 12, 1973 · N4670C · Substantial damage
- [NTSB CHI74FEE12](https://openairdocs.org/ntsb/CHI74FEE12.md): Piper PA-28 · Elburn, IL · Accident · No injuries · Closed · Aug 12, 1973 · N8863N · Substantial damage
- [NTSB CHI74FEE09](https://openairdocs.org/ntsb/CHI74FEE09.md): Stinson L-5 · Rockford, IL · Accident · No injuries · Closed · Aug 12, 1973 · N65414 · Substantial damage
- [NTSB MIA74DKG17](https://openairdocs.org/ntsb/MIA74DKG17.md): Cessna 188 · Cochran, GA · Accident · No injuries · Closed · Aug 11, 1973 · N5657J · Substantial damage
- [NTSB LAX74FUQ09](https://openairdocs.org/ntsb/LAX74FUQ09.md): Cessna 170B · Lancaster, CA · Accident · No injuries · Closed · Aug 11, 1973 · N3404C · Substantial damage
- [NTSB OAK74FVM06](https://openairdocs.org/ntsb/OAK74FVM06.md): Cessna 150 · San Jose, CA · Accident · Minor injuries · Closed · Aug 10, 1973 · N5988J · Substantial damage
- [NTSB CHI74FEP10](https://openairdocs.org/ntsb/CHI74FEP10.md): Cessna 172 · Cadott, WI · Accident · Serious injuries · Closed · Aug 10, 1973 · N8595U · Destroyed
- [NTSB MIA74DKA03](https://openairdocs.org/ntsb/MIA74DKA03.md): Cessna 150 · Humacao, PR · Accident · No injuries · Closed · Aug 9, 1973 · N50141 · Destroyed
- [NTSB LAX74FVA16](https://openairdocs.org/ntsb/LAX74FVA16.md): Piper PA-28 · Bakersfield, CA · Accident · Serious injuries · Closed · Aug 9, 1973 · N5734W · Substantial damage
- [NTSB SEA74FYG08](https://openairdocs.org/ntsb/SEA74FYG08.md): Bell 47J-2A · Inchelium, WA · Accident · Serious injuries · Closed · Aug 8, 1973 · N8439E · Destroyed
- [NTSB FTW74FRA10](https://openairdocs.org/ntsb/FTW74FRA10.md): Piper PA-22 · Friendswood, TX · Accident · No injuries · Closed · Aug 8, 1973 · N3963P · Substantial damage
- [NTSB NYC74FHJ09](https://openairdocs.org/ntsb/NYC74FHJ09.md): Piper PA-28 · Mt Pleasant, NY · Accident · Minor injuries · Closed · Aug 7, 1973 · N5091S · Substantial damage
- [NTSB CHI74DEM15](https://openairdocs.org/ntsb/CHI74DEM15.md): Piper PA-17 · Charlotte, MI · Accident · No injuries · Closed · Aug 7, 1973 · N4847H · Substantial damage
- [NTSB ANC74AA018](https://openairdocs.org/ntsb/ANC74AA018.md): Bell 206A · Wasilla, AK · Accident · Serious injuries · Closed · Aug 7, 1973 · N1472W · Destroyed
- [NTSB DEN74AD006](https://openairdocs.org/ntsb/DEN74AD006.md): Piper PA-24 · Weed, NM · Accident · 1 fatal · Closed · Aug 5, 1973 · N5879P · Destroyed

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

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

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