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

## Cases, newest first

- [NTSB MIA70FKW06](https://openairdocs.org/ntsb/MIA70FKW06.md): Cessna 150 · Chattanooga, TN · Accident · Serious injuries · Closed · May 11, 1970 · N5864E · Destroyed
- [NTSB ANC70DAA09](https://openairdocs.org/ntsb/ANC70DAA09.md): Cessna 175B · Rampart, AK · Accident · No injuries · Closed · May 11, 1970 · N8217T · Substantial damage
- [NTSB MKC70FCA10](https://openairdocs.org/ntsb/MKC70FCA10.md): Cessna 120 · Williamsburg, MO · Accident · Minor injuries · Closed · May 10, 1970 · N2936N · Substantial damage
- [NTSB IAD70FIA14](https://openairdocs.org/ntsb/IAD70FIA14.md): Piper PA-28 · Baileys X-Road, VA · Accident · Serious injuries · Closed · May 10, 1970 · N1850J · Destroyed
- [NTSB FTW70FPD09](https://openairdocs.org/ntsb/FTW70FPD09.md): Piper PA-22 · Mansfield, TX · Accident · No injuries · Closed · May 10, 1970 · N8436D · Substantial damage
- [NTSB OAK70FVG13](https://openairdocs.org/ntsb/OAK70FVG13.md): Schleicher K8B · Fairfield, CA · Accident · Serious injuries · Closed · May 9, 1970 · N4601T · Destroyed
- [NTSB DCA70AZ008](https://openairdocs.org/ntsb/DCA70AZ008.md): Lear Jet 23A · Pellston, MI · Accident · 6 fatal · Closed · May 9, 1970 · N434EJ · Destroyed
- [NTSB MIA70FLG18](https://openairdocs.org/ntsb/MIA70FLG18.md): Cessna 182B · Charleston, SC · Accident · Serious injuries · Closed · May 8, 1970 · N2452G · Substantial damage
- [NTSB MIA70DKJ32](https://openairdocs.org/ntsb/MIA70DKJ32.md): Piper PA-22 · Tuskegee, AL · Accident · No injuries · Closed · May 8, 1970 · N3163Z · Substantial damage
- [NTSB MIA70DKG29](https://openairdocs.org/ntsb/MIA70DKG29.md): Piper PA-23 · St.Marys, GA · Accident · No injuries · Closed · May 8, 1970 · N2230P · Substantial damage
- [NTSB OAK71DVG04](https://openairdocs.org/ntsb/OAK71DVG04.md): Schweizer 1-26A · Old Station, CA · Accident · No injuries · Closed · May 7, 1970 · N10386 · Destroyed
- [NTSB CHI70FBQ15](https://openairdocs.org/ntsb/CHI70FBQ15.md): Boeing D75N1 · Wilsonville, IL · Accident · No injuries · Closed · May 5, 1970 · N54805 · Substantial damage
- [NTSB ANC70AA078](https://openairdocs.org/ntsb/ANC70AA078.md): Lockheed 1049H · Barrow, AK · Accident · No injuries · Closed · May 5, 1970 · N174W · Destroyed
- [NTSB LAX70FUG30](https://openairdocs.org/ntsb/LAX70FUG30.md): Morrisey 2150 · Rubidoux, CA · Accident · No injuries · Closed · May 3, 1970 · N5108V · Substantial damage
- [NTSB LAX70FUA25](https://openairdocs.org/ntsb/LAX70FUA25.md): Bellanca 17-30 · Long Beach, CA · Accident · Minor injuries · Closed · May 3, 1970 · N4908V · Destroyed
- [NTSB CHI70DBQ13](https://openairdocs.org/ntsb/CHI70DBQ13.md): Cessna 140 · El Paso, IL · Accident · No injuries · Closed · May 3, 1970 · N5650C · Substantial damage
- [NTSB NYC70DFD12](https://openairdocs.org/ntsb/NYC70DFD12.md): Piper PA-32 · Smithfield, RI · Accident · No injuries · Closed · May 2, 1970 · N3913W · Substantial damage
- [NTSB DCA70AZ007](https://openairdocs.org/ntsb/DCA70AZ007.md): Douglas DC-9 · St.Croix, VI · Accident · 23 fatal · Closed · May 2, 1970 · N935F · Destroyed
- [NTSB CHI70FBM14](https://openairdocs.org/ntsb/CHI70FBM14.md): Mooney M20A · Fort Waybe, IN · Accident · Minor injuries · Closed · May 2, 1970 · N6071X · Substantial damage
- [NTSB SEA70FWG12](https://openairdocs.org/ntsb/SEA70FWG12.md): Cessna 150G · Wenatchee, WA · Accident · No injuries · Closed · May 1, 1970 · N3694J · Substantial damage
- [NTSB NYC70FFM12](https://openairdocs.org/ntsb/NYC70FFM12.md): Cessna 310N · Westfield, MA · Accident · Minor injuries · Closed · May 1, 1970 · N4158Q · Destroyed
- [NTSB ANC70AA075](https://openairdocs.org/ntsb/ANC70AA075.md): Cessna 180 · Kobuk, AK · Accident · No injuries · Closed · May 1, 1970 · N7977V · Substantial damage
- [NTSB IAD70FIA13](https://openairdocs.org/ntsb/IAD70FIA13.md): Piper PA-23 · Clinton, MD · Accident · Serious injuries · Closed · Apr 30, 1970 · N2045P · Substantial damage
- [NTSB MKC70FCG24](https://openairdocs.org/ntsb/MKC70FCG24.md): Piper PA-28 · Olathe, KS · Accident · No injuries · Closed · Apr 27, 1970 · N6546J · Substantial damage
- [NTSB MKC70FCA09](https://openairdocs.org/ntsb/MKC70FCA09.md): Cessna 180 · Fenton, MO · Accident · No injuries · Closed · Apr 27, 1970 · N3895C · Substantial damage
- [NTSB FTW70FRJ07](https://openairdocs.org/ntsb/FTW70FRJ07.md): Piper PA-25 · St.Joseph, LA · Accident · 1 fatal · Closed · Apr 27, 1970 · N4943Y · Destroyed
- [NTSB MIA70AM087](https://openairdocs.org/ntsb/MIA70AM087.md): Cessna P206C · St.Augustine, FL · Accident · 2 fatal · Closed · Apr 26, 1970 · N8648Z · Destroyed
- [NTSB NYC71DHM15](https://openairdocs.org/ntsb/NYC71DHM15.md): Schweizer 1-23 · Wurtsboro, NY · Accident · No injuries · Closed · Apr 25, 1970 · N91886 · Substantial damage
- [NTSB LAX70IL068](https://openairdocs.org/ntsb/LAX70IL068.md): Cessna 150G · Pacoima, CA · Incident · No injuries · Closed · Apr 25, 1970 · N4076J · 2 aircraft · Minor damage
- [NTSB LAX70FUQ25](https://openairdocs.org/ntsb/LAX70FUQ25.md): Cessna 150 · Goleta, CA · Accident · No injuries · Closed · Apr 25, 1970 · N7050S · Substantial damage
- [NTSB IAD70AI059](https://openairdocs.org/ntsb/IAD70AI059.md): Piper PA-28 · Frederick, MD · Accident · 2 fatal · Closed · Apr 25, 1970 · N5113G · Destroyed
- [NTSB MKC70DDM23](https://openairdocs.org/ntsb/MKC70DDM23.md): Piper J3C · Jackson, MN · Accident · No injuries · Closed · Apr 24, 1970 · N33237 · Substantial damage
- [NTSB LAX70AL067](https://openairdocs.org/ntsb/LAX70AL067.md): Piper PA-28R · Ramona, CA · Accident · No injuries · Closed · Apr 22, 1970 · N4695J · 2 aircraft · Substantial damage
- [NTSB FTW70AF067](https://openairdocs.org/ntsb/FTW70AF067.md): Beech D50C · Austin, TX · Accident · 6 fatal · Closed · Apr 22, 1970 · N1661 · Destroyed
- [NTSB MKC70FCJ17](https://openairdocs.org/ntsb/MKC70FCJ17.md): Mooney M20C · Crawford, NE · Accident · Serious injuries · Closed · Apr 21, 1970 · N9276M · Substantial damage
- [NTSB LAX70DVA12](https://openairdocs.org/ntsb/LAX70DVA12.md): Schweizer SGS123 · Mckittrick, CA · Accident · No injuries · Closed · Apr 21, 1970 · N10364 · Substantial damage
- [NTSB NYC70FFD10](https://openairdocs.org/ntsb/NYC70FFD10.md): Mooney M20E · Marlboro, MA · Accident · Minor injuries · Closed · Apr 19, 1970 · N2612W · Substantial damage
- [NTSB FTW70DPJ12](https://openairdocs.org/ntsb/FTW70DPJ12.md): Piper PA-28 · Granite, OK · Accident · No injuries · Closed · Apr 19, 1970 · N5397W · Destroyed
- [NTSB IAD70DIA11](https://openairdocs.org/ntsb/IAD70DIA11.md): Schweizer 2-33 · Warrenton, VA · Accident · No injuries · Closed · Apr 18, 1970 · N5758S · Substantial damage
- [NTSB ANC70DAA07](https://openairdocs.org/ntsb/ANC70DAA07.md): Piper PA-22 · Bettles, AK · Accident · Minor injuries · Closed · Apr 16, 1970 · N8757D · Substantial damage
- [NTSB MIA70FLA19](https://openairdocs.org/ntsb/MIA70FLA19.md): Piper PA-31 · Tallahassee, FL · Accident · Serious injuries · Closed · Apr 14, 1970 · N411AA · Destroyed
- [NTSB OAK70FVA09](https://openairdocs.org/ntsb/OAK70FVA09.md): Piper PA-23 · Fresno, CA · Accident · No injuries · Closed · Apr 13, 1970 · N5978Y · Substantial damage
- [NTSB NYC70DHG04](https://openairdocs.org/ntsb/NYC70DHG04.md): Cessna 150 · Sayre, PA · Accident · No injuries · Closed · Apr 12, 1970 · N8152S · Substantial damage
- [NTSB NYC70DHD16](https://openairdocs.org/ntsb/NYC70DHD16.md): Piper PA-28 · Moorestown, NJ · Accident · No injuries · Closed · Apr 12, 1970 · N1849J · Substantial damage
- [NTSB NYC70DFM09](https://openairdocs.org/ntsb/NYC70DFM09.md): Piper PA-28 · East Hampton, CT · Accident · No injuries · Closed · Apr 12, 1970 · N6713J · Substantial damage
- [NTSB OAK70DVG27](https://openairdocs.org/ntsb/OAK70DVG27.md): Aeronca 7AC · Sloughhouse, CA · Accident · Minor injuries · Closed · Apr 11, 1970 · N1661E · Substantial damage
- [NTSB MKC70AK055](https://openairdocs.org/ntsb/MKC70AK055.md): Aeronca 7AC · So.St.Paul, MN · Accident · Minor injuries · Closed · Apr 11, 1970 · N1883E · 2 aircraft · Substantial damage
- [NTSB FTW70FRG33](https://openairdocs.org/ntsb/FTW70FRG33.md): Morrisey 2150 · San Antonio, TX · Accident · No injuries · Closed · Apr 11, 1970 · N5101V · Substantial damage
- [NTSB MKC70DDM19](https://openairdocs.org/ntsb/MKC70DDM19.md): Cessna 150 · Lake Elmo, MN · Accident · Minor injuries · Closed · Apr 10, 1970 · N50693 · Substantial damage
- [NTSB LAX70AL063](https://openairdocs.org/ntsb/LAX70AL063.md): Cessna 150F · Tucson, AZ · Accident · Serious injuries · Closed · Apr 9, 1970 · N6811F · 2 aircraft · Destroyed

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

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

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