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

## Cases, newest first

- [NTSB UNK64X1490](https://openairdocs.org/ntsb/UNK64X1490.md): Beech 65 · Billings, MT · Accident · 4 fatal · Closed · Apr 27, 1964 · N451HC · Destroyed
- [NTSB UNK64X1487](https://openairdocs.org/ntsb/UNK64X1487.md): Piper PA24 · Gary, IN · Accident · No injuries · Closed · Apr 27, 1964 · N6100R · Substantial damage
- [NTSB UNK64X1484](https://openairdocs.org/ntsb/UNK64X1484.md): Piper PA22 · Texas City, TX · Accident · Minor injuries · Closed · Apr 27, 1964 · N5282Z · Destroyed
- [NTSB UNK64X1477](https://openairdocs.org/ntsb/UNK64X1477.md): Aero Comm 520 · Ft Lauderdale, FL · Accident · Serious injuries · Closed · Apr 26, 1964 · N9094R · Destroyed
- [NTSB UNK64X1474](https://openairdocs.org/ntsb/UNK64X1474.md): Piper PA28 · Lobos Is, PR · Accident · No injuries · Closed · Apr 26, 1964 · N5657W · Substantial damage
- [NTSB UNK64X1473](https://openairdocs.org/ntsb/UNK64X1473.md): Piper PA12 · Lake Village Ind, ME · Accident · Minor injuries · Closed · Apr 26, 1964 · N4356N · Substantial damage
- [NTSB UNK64X1463](https://openairdocs.org/ntsb/UNK64X1463.md): Piper PA24 · Laconia, NH · Accident · No injuries · Closed · Apr 26, 1964 · N6227P · Substantial damage
- [NTSB UNK64X1461](https://openairdocs.org/ntsb/UNK64X1461.md): Luscombe 8F · Calistoga, CA · Accident · Serious injuries · Closed · Apr 25, 1964 · N1879B · Destroyed
- [NTSB UNK64X1442](https://openairdocs.org/ntsb/UNK64X1442.md): Luscombe 8A · Buffalo, MO · Accident · No injuries · Closed · Apr 25, 1964 · N71348 · Substantial damage
- [NTSB UNK64X1435](https://openairdocs.org/ntsb/UNK64X1435.md): Piper PA23 · Lubbock, TX · Accident · No injuries · Closed · Apr 24, 1964 · N5305Y · Substantial damage
- [NTSB UNK64X1428](https://openairdocs.org/ntsb/UNK64X1428.md): Piper PA28 · Crystal City, TX · Accident · Serious injuries · Closed · Apr 23, 1964 · N7214W · Destroyed
- [NTSB UNK64X1422](https://openairdocs.org/ntsb/UNK64X1422.md): Boeing A75N1 · Gueydan, LA · Accident · Minor injuries · Closed · Apr 23, 1964 · N49717 · Substantial damage
- [NTSB UNK64X1421](https://openairdocs.org/ntsb/UNK64X1421.md): Beechcraft F35 · Deming, NM · Accident · Minor injuries · Closed · Apr 23, 1964 · N210X · Substantial damage
- [NTSB UNK64X1419](https://openairdocs.org/ntsb/UNK64X1419.md): Cessna 172E · Lancaster, OH · Accident · Minor injuries · Closed · Apr 23, 1964 · N3702S · Substantial damage
- [NTSB UNK64X1416](https://openairdocs.org/ntsb/UNK64X1416.md): Beechcraft B95 · Colby, KS · Accident · 3 fatal · Closed · Apr 22, 1964 · N9979R · Destroyed
- [NTSB UNK64X1405](https://openairdocs.org/ntsb/UNK64X1405.md): Cessna 175 · Montgomery, AL · Accident · No injuries · Closed · Apr 21, 1964 · N7220M · Substantial damage
- [NTSB UNK64X1397](https://openairdocs.org/ntsb/UNK64X1397.md): Cessna 210 · Baja, Mexico · Accident · Minor injuries · Closed · Apr 21, 1964 · N3809Y · Destroyed
- [NTSB UNK64X1393](https://openairdocs.org/ntsb/UNK64X1393.md): Piper PA28 · Reno, NV · Accident · Minor injuries · Closed · Apr 20, 1964 · N8605W · Destroyed
- [NTSB UNK64X1386](https://openairdocs.org/ntsb/UNK64X1386.md): Fairchild 24 · Pickens, SC · Accident · Serious injuries · Closed · Apr 19, 1964 · N79860 · Destroyed
- [NTSB UNK64X1372](https://openairdocs.org/ntsb/UNK64X1372.md): Cessna 120 · Pontiac, MI · Accident · No injuries · Closed · Apr 19, 1964 · N3601V · Destroyed
- [NTSB UNK64X1365](https://openairdocs.org/ntsb/UNK64X1365.md): Meyers 200 · Lubbock, TX · Accident · 3 fatal · Closed · Apr 18, 1964 · N34382 · Destroyed
- [NTSB UNK64X1359](https://openairdocs.org/ntsb/UNK64X1359.md): Cessna 120 · Macon, MS · Accident · No injuries · Closed · Apr 18, 1964 · N89901 · Substantial damage
- [NTSB UNK64X1328](https://openairdocs.org/ntsb/UNK64X1328.md): Luscombe 8A · Pleasent Hill, OH · Accident · 1 fatal · Closed · Apr 15, 1964 · N1473K · Destroyed
- [NTSB UNK64X1306](https://openairdocs.org/ntsb/UNK64X1306.md): Piper PA23 · Phoenix, AZ · Accident · No injuries · Closed · Apr 14, 1964 · N3119P · Destroyed
- [NTSB UNK64X1297](https://openairdocs.org/ntsb/UNK64X1297.md): Cessna 175 · Baytown, TX · Accident · Minor injuries · Closed · Apr 13, 1964 · N8077T · Destroyed
- [NTSB UNK64X1290](https://openairdocs.org/ntsb/UNK64X1290.md): Cessna 150 · Solon Springs, WI · Accident · 1 fatal · Closed · Apr 12, 1964 · N7829Z · Destroyed
- [NTSB UNK64X1273](https://openairdocs.org/ntsb/UNK64X1273.md): Piper PA24 · Santa Cruz, CA · Accident · No injuries · Closed · Apr 12, 1964 · N5699P · Substantial damage
- [NTSB UNK64X1258](https://openairdocs.org/ntsb/UNK64X1258.md): Cessna 140A · Marlboro, MA · Accident · No injuries · Closed · Apr 11, 1964 · N89489 · Substantial damage
- [NTSB UNK64X1245](https://openairdocs.org/ntsb/UNK64X1245.md): Cessna 150 · Bishop, CA · Accident · No injuries · Closed · Apr 10, 1964 · N6539T · Substantial damage
- [NTSB UNK64X1198](https://openairdocs.org/ntsb/UNK64X1198.md): Piper PA22 · Northampton, MA · Accident · No injuries · Closed · Apr 6, 1964 · N7734D · Substantial damage
- [NTSB UNK64X1189](https://openairdocs.org/ntsb/UNK64X1189.md): Ercoupe 415CD · Chillicothe, OH · Accident · No injuries · Closed · Apr 5, 1964 · N94706 · Substantial damage
- [NTSB UNK64X1182](https://openairdocs.org/ntsb/UNK64X1182.md): Piper PA-24 · Sacramento, CA · Accident · No injuries · Closed · Apr 5, 1964 · N5735P · Destroyed
- [NTSB UNK64X1181](https://openairdocs.org/ntsb/UNK64X1181.md): Schweizer 119A · Dodge City, KS · Accident · Minor injuries · Closed · Apr 5, 1964 · N40278 · Substantial damage
- [NTSB UNK64X1158](https://openairdocs.org/ntsb/UNK64X1158.md): Luscombe 8E · Hopewell, VA · Accident · No injuries · Closed · Apr 4, 1964 · N1879K · Substantial damage
- [NTSB UNK64X1157](https://openairdocs.org/ntsb/UNK64X1157.md): Mooney M20D · Mt Olive, NC · Accident · No injuries · Closed · Apr 4, 1964 · N6738U · Substantial damage
- [NTSB UNK64X1137](https://openairdocs.org/ntsb/UNK64X1137.md): Cessna 140 · Plymouth, MA · Accident · Serious injuries · Closed · Apr 2, 1964 · N76641 · Destroyed
- [NTSB UNK64X1133](https://openairdocs.org/ntsb/UNK64X1133.md): Piper PA22 · Spring Valley, NY · Accident · No injuries · Closed · Apr 2, 1964 · N554Z · Substantial damage
- [NTSB UNK64X1128](https://openairdocs.org/ntsb/UNK64X1128.md): Piper PA-22 · Dravosburg, PA · Accident · Minor injuries · Closed · Apr 1, 1964 · N5793Z · Substantial damage
- [NTSB UNK64X1106](https://openairdocs.org/ntsb/UNK64X1106.md): Cessna 180 · Chapel Hill, NC · Accident · No injuries · Closed · Mar 30, 1964 · N9007C · Substantial damage
- [NTSB UNK64X1095](https://openairdocs.org/ntsb/UNK64X1095.md): Cessna 140 · Bethel, AK · Accident · No injuries · Closed · Mar 29, 1964 · N72770 · Substantial damage
- [NTSB UNK64X1066](https://openairdocs.org/ntsb/UNK64X1066.md): Beechcraft D-18S · Benghazi, Libya · Accident · 2 fatal · Closed · Mar 28, 1964 · N178L · Substantial damage
- [NTSB UNK64X1055](https://openairdocs.org/ntsb/UNK64X1055.md): Piper PA18 · El Paso, TX · Accident · Minor injuries · Closed · Mar 27, 1964 · N7604C · Substantial damage
- [NTSB UNK64X1045](https://openairdocs.org/ntsb/UNK64X1045.md): Piper PA24 · Mentone, TX · Accident · 2 fatal · Closed · Mar 26, 1964 · N7909P · Destroyed
- [NTSB UNK64X1044](https://openairdocs.org/ntsb/UNK64X1044.md): Nelson NL3W · Lancaster, CA · Accident · Minor injuries · Closed · Mar 26, 1964 · N9148Z · Substantial damage
- [NTSB UNK64X1042](https://openairdocs.org/ntsb/UNK64X1042.md): Navion B · Baker, CA · Accident · No injuries · Closed · Mar 26, 1964 · N5159K · Destroyed
- [NTSB UNK64X1016](https://openairdocs.org/ntsb/UNK64X1016.md): Piper PA22 · Vernon, MI · Accident · No injuries · Closed · Mar 22, 1964 · N2767P · Substantial damage
- [NTSB UNK64X0998](https://openairdocs.org/ntsb/UNK64X0998.md): Piper PA22 · Lake Elmo, MN · Accident · No injuries · Closed · Mar 21, 1964 · N5873Z · Substantial damage
- [NTSB UNK64X0997](https://openairdocs.org/ntsb/UNK64X0997.md): Cessna 172D · El Rosario, Mexico · Accident · Minor injuries · Closed · Mar 21, 1964 · N2757U · Substantial damage
- [NTSB UNK64X0988](https://openairdocs.org/ntsb/UNK64X0988.md): Stinson 108 · Halfday, IL · Accident · Minor injuries · Closed · Mar 20, 1964 · N97579 · Destroyed
- [NTSB UNK64X0981](https://openairdocs.org/ntsb/UNK64X0981.md): Beechcraft B45 · Corpus Christi, TX · Accident · No injuries · Closed · Mar 19, 1964 · N9131R · Destroyed

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

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

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