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

## Cases, newest first

- [NTSB UNK64X0333](https://openairdocs.org/ntsb/UNK64X0333.md): Piper J3C · Fitchburg, MA · Accident · No injuries · Closed · Jan 23, 1964 · N7259H · Substantial damage
- [NTSB UNK64X0317](https://openairdocs.org/ntsb/UNK64X0317.md): Piper PA12 · Andover, NJ · Accident · No injuries · Closed · Jan 22, 1964 · N4164M · Substantial damage
- [NTSB UNK64X0315](https://openairdocs.org/ntsb/UNK64X0315.md): Piper PA23 · Prescott Ariz, AZ · Accident · 2 fatal · Closed · Jan 22, 1964 · N2136P · Destroyed
- [NTSB UNK64X0308](https://openairdocs.org/ntsb/UNK64X0308.md): Grumman G-44 · Karluk, AK · Accident · No injuries · Closed · Jan 21, 1964 · N68335 · Substantial damage
- [NTSB UNK64X0293](https://openairdocs.org/ntsb/UNK64X0293.md): Cessna 172 · Lafayette Tsp, WI · Accident · Minor injuries · Closed · Jan 19, 1964 · N1694Y · Destroyed
- [NTSB UNK64X0292](https://openairdocs.org/ntsb/UNK64X0292.md): Piper PA28 · Hales Corners, WI · Accident · No injuries · Closed · Jan 19, 1964 · N7132W · Substantial damage
- [NTSB UNK64X0290](https://openairdocs.org/ntsb/UNK64X0290.md): Swift GC1B · Presque Isle, ME · Accident · No injuries · Closed · Jan 19, 1964 · N2431B · Substantial damage
- [NTSB UNK64X0280](https://openairdocs.org/ntsb/UNK64X0280.md): Beech C18S · Oakdale, CA · Accident · No injuries · Closed · Jan 18, 1964 · N5046N · Destroyed
- [NTSB UNK64X0277](https://openairdocs.org/ntsb/UNK64X0277.md): Piper PA22 · Moorestown, NJ · Accident · No injuries · Closed · Jan 18, 1964 · N5445Z · Substantial damage
- [NTSB UNK64X0272](https://openairdocs.org/ntsb/UNK64X0272.md): Cessna 172 · Mitchell Bay, Canada · Accident · No injuries · Closed · Jan 18, 1964 · N2576Y · Substantial damage
- [NTSB UNK64X0264](https://openairdocs.org/ntsb/UNK64X0264.md): Cessna 180 · Rainy Lake, Canada · Accident · Minor injuries · Closed · Jan 17, 1964 · N5296D · Substantial damage
- [NTSB UNK64X0252](https://openairdocs.org/ntsb/UNK64X0252.md): Cessna 172 · Columbus, OH · Accident · 2 fatal · Closed · Jan 15, 1964 · N8390B · Destroyed
- [NTSB UNK64X0209](https://openairdocs.org/ntsb/UNK64X0209.md): Beechcraft K35 · Mohave, AZ · Accident · No injuries · Closed · Jan 10, 1964 · N9557R · Substantial damage
- [NTSB UNK64X0197](https://openairdocs.org/ntsb/UNK64X0197.md): Beechcraft C50 · Santa Fe, NM · Accident · Minor injuries · Closed · Jan 9, 1964 · N3742B · Substantial damage
- [NTSB UNK64X0191](https://openairdocs.org/ntsb/UNK64X0191.md): Mooney MK21 · Crescent City, CA · Accident · Minor injuries · Closed · Jan 8, 1964 · N6219U · Substantial damage
- [NTSB UNK64X0185](https://openairdocs.org/ntsb/UNK64X0185.md): Mooney M20C · Head Waters, VA · Accident · Serious injuries · Closed · Jan 8, 1964 · N6886U · Destroyed
- [NTSB UNK64X0182](https://openairdocs.org/ntsb/UNK64X0182.md): Beechcraft B95A55 · New Orleans, LA · Accident · No injuries · Closed · Jan 7, 1964 · N1726G · Substantial damage
- [NTSB UNK64X0167](https://openairdocs.org/ntsb/UNK64X0167.md): Piper PA11 · Armonk, NY · Accident · No injuries · Closed · Jan 5, 1964 · N4925M · Substantial damage
- [NTSB UNK64X0166](https://openairdocs.org/ntsb/UNK64X0166.md): Aeronca 11AC · Napoleon, MI · Accident · No injuries · Closed · Jan 5, 1964 · N9172E · Substantial damage
- [NTSB UNK64X0160](https://openairdocs.org/ntsb/UNK64X0160.md): Ercoupe 415C · Alexandria, VA · Accident · Serious injuries · Closed · Jan 5, 1964 · N2238H · Destroyed
- [NTSB UNK64X0143](https://openairdocs.org/ntsb/UNK64X0143.md): Luscombe 8A · Palo Alto, CA · Accident · Serious injuries · Closed · Jan 4, 1964 · N2663K · 2 aircraft · Destroyed
- [NTSB UNK64X0126](https://openairdocs.org/ntsb/UNK64X0126.md): No American SNJ5 · Basking Ridge, NJ · Accident · No injuries · Closed · Jan 3, 1964 · N9804C · Substantial damage
- [NTSB LAX64A0036](https://openairdocs.org/ntsb/LAX64A0036.md): Douglas DC-6B · Los Angeles, CA · Accident · No injuries · Closed · Dec 17, 1963 · N93131 · Substantial damage
- [NTSB NYC64A0074](https://openairdocs.org/ntsb/NYC64A0074.md): Douglas DC-3 · Morgantown, WV · Accident · 1 fatal · Closed · Nov 29, 1963 · N386T · Destroyed
- [NTSB UNK63X0104](https://openairdocs.org/ntsb/UNK63X0104.md): Fairchild F-27 · Calgary, Canada · Accident · Serious injuries · Closed · Aug 24, 1963 · N2707 · Substantial damage
- [NTSB CHI64A0027](https://openairdocs.org/ntsb/CHI64A0027.md): Douglas DC-6 · Indianapolis, IN · Accident · No injuries · Closed · Aug 13, 1963 · N1907M · Substantial damage
- [NTSB DCA63A0007](https://openairdocs.org/ntsb/DCA63A0007.md): Douglas DC-6B · Wildwood, NJ · Accident · No injuries · Closed · May 31, 1963 · N7919C · Substantial damage
- [NTSB UNK63X0103](https://openairdocs.org/ntsb/UNK63X0103.md): Lockheed 1049G · Manhattan, KS · Accident · Serious injuries · Closed · May 28, 1963 · N189S · Destroyed
- [NTSB NYC63A0189](https://openairdocs.org/ntsb/NYC63A0189.md): Convair 340 · Atlantic City, NJ · Accident · No injuries · Closed · May 28, 1963 · N8427H · Substantial damage
- [NTSB CHI63A0156](https://openairdocs.org/ntsb/CHI63A0156.md): Douglas DC-3 · Peoria, IL · Accident · No injuries · Closed · Mar 18, 1963 · N143D · Substantial damage
- [NTSB UNK63X0102](https://openairdocs.org/ntsb/UNK63X0102.md): Lockheed 1049H · San Francisco, CA · Accident · 4 fatal · Closed · Feb 3, 1963 · N9740Z · Destroyed
- [NTSB ANC63A0059](https://openairdocs.org/ntsb/ANC63A0059.md): Beech AT-11 · Barter Isld, AK · Accident · 5 fatal · Closed · Jan 14, 1963 · N65458 · Destroyed
- [NTSB MKC62A0052](https://openairdocs.org/ntsb/MKC62A0052.md): Convair 340 · Grand Island, NE · Accident · Serious injuries · Closed · Dec 21, 1962 · N73130 · Destroyed
- [NTSB LAX62A0131](https://openairdocs.org/ntsb/LAX62A0131.md): Lockheed 1049H · No.Hollywood, CA · Accident · 5 fatal · Closed · Dec 14, 1962 · N6913C · Destroyed
- [NTSB NYC62A0128](https://openairdocs.org/ntsb/NYC62A0128.md): Douglas DC-7B · Jamaica, NY · Accident · 25 fatal · Closed · Nov 30, 1962 · N815D · Destroyed
- [NTSB UNK63X0100](https://openairdocs.org/ntsb/UNK63X0100.md): Beech C18S · Pow B Dewlne, AK · Accident · No injuries · Closed · Oct 1, 1962 · N6416C · Substantial damage
- [NTSB FTW62A0072](https://openairdocs.org/ntsb/FTW62A0072.md): Boeing 720 · New Orleans, LA · Accident · No injuries · Closed · Aug 30, 1962 · N8706E · Substantial damage
- [NTSB MIA62A0062](https://openairdocs.org/ntsb/MIA62A0062.md): Martin 404 · Wilmington, NC · Accident · Minor injuries · Closed · Aug 22, 1962 · N40401 · Destroyed
- [NTSB MIA62A0055](https://openairdocs.org/ntsb/MIA62A0055.md): Martin 404 · Rocky Mount, NC · Accident · No injuries · Closed · Aug 6, 1962 · N40415 · Substantial damage
- [NTSB OAK62A0015](https://openairdocs.org/ntsb/OAK62A0015.md): Boeing 707 · Manila, RP · Accident · No injuries · Closed · Apr 27, 1962 · N720PA · Substantial damage
- [NTSB UNK62X0100](https://openairdocs.org/ntsb/UNK62X0100.md): Canadair CL-44D · Wake Island, WQ · Accident · No injuries · Closed · Apr 14, 1962 · N602SA · Substantial damage
- [NTSB MIA62A0026](https://openairdocs.org/ntsb/MIA62A0026.md): Douglas DC-8 · Mexico City, Mexico · Accident · No injuries · Closed · Apr 7, 1962 · N8275H · Substantial damage
- [NTSB ANC62A0009](https://openairdocs.org/ntsb/ANC62A0009.md): Lockheed 1049H · Adak, AK · Accident · 1 fatal · Closed · Mar 15, 1962 · N6911C · Destroyed
- [NTSB ANC62A0008](https://openairdocs.org/ntsb/ANC62A0008.md): Beech AT-11 · Moses Point, AK · Accident · Serious injuries · Closed · Mar 5, 1962 · N41E · Substantial damage
- [NTSB ANC62A0005](https://openairdocs.org/ntsb/ANC62A0005.md): Cessna 180A · Nyac, AK · Accident · No injuries · Closed · Feb 15, 1962 · N7858A · Substantial damage
- [NTSB MIA62A0007](https://openairdocs.org/ntsb/MIA62A0007.md): Boeing 720B · Ft.Lauderdale, FL · Accident · No injuries · Closed · Jan 26, 1962 · N724US · Substantial damage

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

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