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

## Cases, newest first

- [NTSB OAK73AP022](https://openairdocs.org/ntsb/OAK73AP022.md): Beech F35 · San Fran, CA · Accident · 1 fatal · Closed · Jan 13, 1973 · N5000B · Destroyed
- [NTSB NYC73AN101](https://openairdocs.org/ntsb/NYC73AN101.md): Piper PA-22 · Edgewater, MD · Accident · Serious injuries · Closed · Jan 13, 1973 · N5483Z · 2 aircraft · Destroyed
- [NTSB MKC73DER34](https://openairdocs.org/ntsb/MKC73DER34.md): Cessna 150G · Lake Elmo, MN · Accident · No injuries · Closed · Jan 13, 1973 · N2270J · Substantial damage
- [NTSB FTW73FRG41](https://openairdocs.org/ntsb/FTW73FRG41.md): Taylorcraft BC12-D · San Antonio, TX · Accident · Minor injuries · Closed · Jan 13, 1973 · N95340 · Substantial damage
- [NTSB NYC73FHD22](https://openairdocs.org/ntsb/NYC73FHD22.md): Piper PA-30 · Moorestown, NJ · Accident · No injuries · Closed · Jan 12, 1973 · N8452Y · Substantial damage
- [NTSB NYC73ANC46](https://openairdocs.org/ntsb/NYC73ANC46.md): Piper PA-28 · Nashua, NH · Accident · No injuries · Closed · Jan 11, 1973 · N15320 · Substantial damage
- [NTSB MKC73FCJ27](https://openairdocs.org/ntsb/MKC73FCJ27.md): Cessna 150F · Lincoln, NE · Accident · Serious injuries · Closed · Jan 11, 1973 · N6756F · Substantial damage
- [NTSB ANC73DAG74](https://openairdocs.org/ntsb/ANC73DAG74.md): Piper PA-18 · Sterling, AK · Accident · No injuries · Closed · Jan 11, 1973 · N4757Y · Substantial damage
- [NTSB CHI73AC062](https://openairdocs.org/ntsb/CHI73AC062.md): Piper PA-32 · Holland, OH · Accident · 2 fatal · Closed · Jan 10, 1973 · N1288T · Destroyed
- [NTSB ANC73FAG73](https://openairdocs.org/ntsb/ANC73FAG73.md): Stinson 108-3 · Soldotna, AK · Accident · Minor injuries · Closed · Jan 10, 1973 · N4205C · Substantial damage
- [NTSB NYC73FNE16](https://openairdocs.org/ntsb/NYC73FNE16.md): Piper PA-28 · Ellington, CT · Accident · No injuries · Closed · Jan 9, 1973 · N6497J · Substantial damage
- [NTSB LAX73FUG27](https://openairdocs.org/ntsb/LAX73FUG27.md): Cessna 150 · Corona, CA · Accident · No injuries · Closed · Jan 8, 1973 · N8780G · Substantial damage
- [NTSB OAK73AP019](https://openairdocs.org/ntsb/OAK73AP019.md): Piper PA-28 · Hayward, CA · Accident · 1 fatal · Closed · Jan 7, 1973 · N4160J · 2 aircraft · Substantial damage
- [NTSB NYC73FFJ16](https://openairdocs.org/ntsb/NYC73FFJ16.md): Piper PA-22 · Leroy, NY · Accident · Serious injuries · Closed · Jan 7, 1973 · N893C · Destroyed
- [NTSB NYC73AN098](https://openairdocs.org/ntsb/NYC73AN098.md): Cessna 320E · Avoca, PA · Accident · 4 fatal · Closed · Jan 7, 1973 · N4883B · Destroyed
- [NTSB NYC73DHD21](https://openairdocs.org/ntsb/NYC73DHD21.md): Schweizer SG233A · West Chester, PA · Accident · No injuries · Closed · Jan 6, 1973 · N7609 · Substantial damage
- [NTSB LAX73DUJ48](https://openairdocs.org/ntsb/LAX73DUJ48.md): Cessna 210 · L Havasu Cy, AZ · Accident · No injuries · Closed · Jan 6, 1973 · N9633T · Substantial damage
- [NTSB MKC73DCG25](https://openairdocs.org/ntsb/MKC73DCG25.md): Piper PA-28 · Olathe, KS · Accident · No injuries · Closed · Jan 5, 1973 · N9878W · Substantial damage
- [NTSB LAX73FUJ43](https://openairdocs.org/ntsb/LAX73FUJ43.md): Cessna 150L · Peoria, AZ · Accident · Minor injuries · Closed · Jan 5, 1973 · N6777G · Substantial damage
- [NTSB LAX73DUG29](https://openairdocs.org/ntsb/LAX73DUG29.md): Cessna 175A · Yucca Vally, CA · Accident · No injuries · Closed · Jan 5, 1973 · N8026T · Substantial damage
- [NTSB NYC73FKM21](https://openairdocs.org/ntsb/NYC73FKM21.md): Piper PA-32 · Shelby, NC · Accident · No injuries · Closed · Jan 4, 1973 · N4805S · Substantial damage
- [NTSB CHI73DEE39](https://openairdocs.org/ntsb/CHI73DEE39.md): Piper PA-28 · Lansing, IL · Accident · No injuries · Closed · Jan 4, 1973 · N7261F · Substantial damage
- [NTSB NYC73FGM15](https://openairdocs.org/ntsb/NYC73FGM15.md): Piper PA-30 · Conemaugh, PA · Accident · No injuries · Closed · Jan 3, 1973 · N153MC · Substantial damage
- [NTSB FTW73AF036](https://openairdocs.org/ntsb/FTW73AF036.md): Piper PA-28 · Prattville, AL · Accident · 2 fatal · Closed · Jan 3, 1973 · N2334R · Destroyed
- [NTSB ANC73DAG70](https://openairdocs.org/ntsb/ANC73DAG70.md): Cessna 150L · Anchorage, AK · Accident · No injuries · Closed · Jan 3, 1973 · N1773Q · Substantial damage
- [NTSB MIA73AM069](https://openairdocs.org/ntsb/MIA73AM069.md): Cessna 310P · Memphis, TN · Accident · 2 fatal · Closed · Jan 1, 1973 · N5728M · Destroyed
- [NTSB LAX73FUM13](https://openairdocs.org/ntsb/LAX73FUM13.md): Beech A35 · El Cajon, CA · Accident · No injuries · Closed · Dec 31, 1972 · N506B · Substantial damage
- [NTSB CHI73FEC20](https://openairdocs.org/ntsb/CHI73FEC20.md): Luscombe 8A · Belleville, MI · Accident · Minor injuries · Closed · Dec 31, 1972 · N1468K · Substantial damage
- [NTSB MIA73FKA07](https://openairdocs.org/ntsb/MIA73FKA07.md): Amer Avco AA1 · San Juan, PR · Accident · 1 fatal · Closed · Dec 30, 1972 · N6230L · Destroyed
- [NTSB NYC73FHJ11](https://openairdocs.org/ntsb/NYC73FHJ11.md): Cessna 172L · Deer Park, NY · Accident · Minor injuries · Closed · Dec 29, 1972 · N4507Q · Substantial damage
- [NTSB MKC73DCQ24](https://openairdocs.org/ntsb/MKC73DCQ24.md): Cessna 210 · Manhattan, KS · Accident · No injuries · Closed · Dec 29, 1972 · N19BB · Substantial damage
- [NTSB MIA73FLD51](https://openairdocs.org/ntsb/MIA73FLD51.md): Cessna 150L · St.Petersburg, FL · Accident · Minor injuries · Closed · Dec 29, 1972 · N1423Q · Destroyed
- [NTSB FTW73AF033](https://openairdocs.org/ntsb/FTW73AF033.md): Beech 65-80 · Kent, TX · Accident · 4 fatal · Closed · Dec 29, 1972 · N9867 · Destroyed
- [NTSB MIA73DKG55](https://openairdocs.org/ntsb/MIA73DKG55.md): Sidewinder Smith · Milledgeville, GA · Accident · Minor injuries · Closed · Dec 28, 1972 · N2285 · Substantial damage
- [NTSB FTW73FRG40](https://openairdocs.org/ntsb/FTW73FRG40.md): Cessna 150 · Rockport, TX · Accident · No injuries · Closed · Dec 28, 1972 · N8724G · Substantial damage
- [NTSB NYC73AN090](https://openairdocs.org/ntsb/NYC73AN090.md): Lockheed L1329 · Saranac Lake, NY · Accident · 3 fatal · Closed · Dec 27, 1972 · N400M · Destroyed
- [NTSB MKC73DER31](https://openairdocs.org/ntsb/MKC73DER31.md): Piper PA-30 · Morris, MN · Accident · No injuries · Closed · Dec 27, 1972 · N8387Y · Substantial damage
- [NTSB FTW73FRA13](https://openairdocs.org/ntsb/FTW73FRA13.md): Piper PA-28 · Bellville, TX · Accident · No injuries · Closed · Dec 27, 1972 · N4119J · Substantial damage
- [NTSB SEA73FYA15](https://openairdocs.org/ntsb/SEA73FYA15.md): Cessna 182P · Gooding, ID · Accident · No injuries · Closed · Dec 26, 1972 · N20785 · Substantial damage
- [NTSB MKC73FCQ23](https://openairdocs.org/ntsb/MKC73FCQ23.md): Beard-Parkr Mini · Benton, KS · Accident · 1 fatal · Closed · Dec 26, 1972 · N6699 · Substantial damage
- [NTSB CHI73FLQ19](https://openairdocs.org/ntsb/CHI73FLQ19.md): Cessna 310J · Lexington, KY · Accident · No injuries · Closed · Dec 26, 1972 · N3021L · Substantial damage
- [NTSB CHI73FEG14](https://openairdocs.org/ntsb/CHI73FEG14.md): Cessna 195A · Tipp City, OH · Accident · Serious injuries · Closed · Dec 26, 1972 · N3466V · Substantial damage
- [NTSB CHI73FEC19](https://openairdocs.org/ntsb/CHI73FEC19.md): Lash A-65 · Lakeville, MI · Accident · Minor injuries · Closed · Dec 26, 1972 · N6389T · Substantial damage
- [NTSB SEA73DYE23](https://openairdocs.org/ntsb/SEA73DYE23.md): Ryan ST-3KR · Snohomish, WA · Accident · Minor injuries · Closed · Dec 24, 1972 · N57185 · Substantial damage
- [NTSB NYC73FLJ15](https://openairdocs.org/ntsb/NYC73FLJ15.md): Cessna 172 · Morrisville, NC · Accident · Minor injuries · Closed · Dec 24, 1972 · N3956Q · Substantial damage
- [NTSB MKC73FCG22](https://openairdocs.org/ntsb/MKC73FCG22.md): Beech M35 · Independence, MO · Accident · No injuries · Closed · Dec 23, 1972 · N2028C · Substantial damage
- [NTSB CHI73FEA21](https://openairdocs.org/ntsb/CHI73FEA21.md): Bellanca 17-30A · Marion, IN · Accident · Serious injuries · Closed · Dec 22, 1972 · N8243R · Destroyed
- [NTSB MKC73FCA13](https://openairdocs.org/ntsb/MKC73FCA13.md): Cessna 182H · Chesterfield, MO · Accident · Serious injuries · Closed · Dec 21, 1972 · N1952X · Substantial damage
- [NTSB CHI73AC059](https://openairdocs.org/ntsb/CHI73AC059.md): Beech H18S · Bloominton, IL · Accident · 2 fatal · Closed · Dec 21, 1972 · N800G · Destroyed
- [NTSB NYC73AN087](https://openairdocs.org/ntsb/NYC73AN087.md): Piper PA-23 · Allentown, PA · Accident · No injuries · Closed · Dec 20, 1972 · N5811Y · Destroyed

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

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

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