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

## Cases, newest first

- [NTSB MKC67F0138](https://openairdocs.org/ntsb/MKC67F0138.md): Cessna 172D · Bemidji, MN · Accident · Serious injuries · Closed · Jul 24, 1966 · N2330U · Substantial damage
- [NTSB DEN67D0040](https://openairdocs.org/ntsb/DEN67D0040.md): Cessna 182 · Colorado Sprg, CO · Accident · No injuries · Closed · Jul 24, 1966 · N2450R · Substantial damage
- [NTSB CHI67F0248](https://openairdocs.org/ntsb/CHI67F0248.md): Luscombe 8A · Northfield, OH · Accident · Minor injuries · Closed · Jul 24, 1966 · N45615 · Destroyed
- [NTSB CHI67A0012](https://openairdocs.org/ntsb/CHI67A0012.md): Beech H50 · Munster, IN · Accident · 4 fatal · Closed · Jul 24, 1966 · N538B · Destroyed
- [NTSB MKC67A0006](https://openairdocs.org/ntsb/MKC67A0006.md): Beech H35 · Sioux City, IA · Accident · 2 fatal · Closed · Jul 23, 1966 · N354B · Destroyed
- [NTSB MIA67F0189](https://openairdocs.org/ntsb/MIA67F0189.md): Piper PA-28 · Jacksonville, FL · Accident · No injuries · Closed · Jul 23, 1966 · N8431W · 2 aircraft · Minor damage
- [NTSB LAX67F0115](https://openairdocs.org/ntsb/LAX67F0115.md): Beech 35 · Goleta, CA · Accident · No injuries · Closed · Jul 22, 1966 · N767D · Substantial damage
- [NTSB LAX67F0061](https://openairdocs.org/ntsb/LAX67F0061.md): Cessna 120 · Esa, AZ · Accident · Minor injuries · Closed · Jul 22, 1966 · N2010V · Destroyed
- [NTSB CHI67F0093](https://openairdocs.org/ntsb/CHI67F0093-107174.md): Cessna 140 · Freaser, MI · Accident · 1 fatal · Closed · Jul 22, 1966 · N2378N · Destroyed
- [NTSB LAX67F0073](https://openairdocs.org/ntsb/LAX67F0073.md): Cessna 182 · Lompoc, CA · Accident · No injuries · Closed · Jul 21, 1966 · N8587T · Destroyed
- [NTSB FTW67D0105](https://openairdocs.org/ntsb/FTW67D0105.md): Piper PA-24 · Keo, AR · Accident · No injuries · Closed · Jul 21, 1966 · N6048P · Substantial damage
- [NTSB MKC67D0111](https://openairdocs.org/ntsb/MKC67D0111.md): Mooney M20 · Gravois Mills, MO · Accident · No injuries · Closed · Jul 19, 1966 · N5917Q · Substantial damage
- [NTSB NYC67D0105](https://openairdocs.org/ntsb/NYC67D0105.md): Cessna 172 · Madison, CT · Accident · No injuries · Closed · Jul 17, 1966 · N3597S · Substantial damage
- [NTSB MKC67F0083](https://openairdocs.org/ntsb/MKC67F0083.md): Ercoupe 415-C · Tribune, KS · Accident · No injuries · Closed · Jul 17, 1966 · N99504 · Destroyed
- [NTSB MIA67A0008](https://openairdocs.org/ntsb/MIA67A0008.md): Piper J3C-65 · Burlington, NC · Accident · 1 fatal · Closed · Jul 17, 1966 · N2147M · Destroyed
- [NTSB ANC67D0048](https://openairdocs.org/ntsb/ANC67D0048.md): Piper J-3 · Dillingham, AK · Accident · No injuries · Closed · Jul 17, 1966 · N35525 · Substantial damage
- [NTSB CHI67F0118](https://openairdocs.org/ntsb/CHI67F0118.md): Cessna 172 · Dekalb, IL · Accident · Serious injuries · Closed · Jul 16, 1966 · N6917A · Substantial damage
- [NTSB UNK66X0158](https://openairdocs.org/ntsb/UNK66X0158.md): Piper PA-28 · Spring Valley, NY · Accident · Minor injuries · Closed · Jul 15, 1966 · N7322W · Substantial damage
- [NTSB NYC67D0076](https://openairdocs.org/ntsb/NYC67D0076.md): Piper PA-28 · Hopedale, MA · Accident · No injuries · Closed · Jul 15, 1966 · N5716W · Substantial damage
- [NTSB MKC67D0053](https://openairdocs.org/ntsb/MKC67D0053.md): Prue 215A · Wilbur, NE · Accident · No injuries · Closed · Jul 14, 1966 · N454Y · Substantial damage
- [NTSB MIA67S0002](https://openairdocs.org/ntsb/MIA67S0002.md): Mooney M20 · Vera Cruz, Mexico · Accident · 2 fatal · Closed · Jul 14, 1966 · N5291B · Destroyed
- [NTSB MIA67F0073](https://openairdocs.org/ntsb/MIA67F0073.md): Aeronca 7AC · Warrington, FL · Accident · No injuries · Closed · Jul 13, 1966 · N81532 · Substantial damage
- [NTSB LAX67F0045](https://openairdocs.org/ntsb/LAX67F0045.md): Morrisey 2150 · Perris, CA · Accident · Serious injuries · Closed · Jul 13, 1966 · N5105V · Substantial damage
- [NTSB DEN67D0042](https://openairdocs.org/ntsb/DEN67D0042.md): Bellanca 14-13 · Panguitch, UT · Accident · No injuries · Closed · Jul 13, 1966 · N74209 · Substantial damage
- [NTSB MKC67D0068](https://openairdocs.org/ntsb/MKC67D0068.md): Aeronca 7AC · Junction City, KS · Accident · No injuries · Closed · Jul 12, 1966 · N3521E · Substantial damage
- [NTSB FTW67A0009](https://openairdocs.org/ntsb/FTW67A0009.md): Convair CV-600 · Harlingen, TX · Accident · No injuries · Closed · Jul 11, 1966 · N94215 · Substantial damage
- [NTSB ANC67A0004](https://openairdocs.org/ntsb/ANC67A0004.md): Piper PA-22 · Fairbanks, AK · Accident · 2 fatal · Closed · Jul 11, 1966 · N2913Z · Destroyed
- [NTSB MIA67D0127](https://openairdocs.org/ntsb/MIA67D0127.md): Piper PA-28 · Enterprise, AL · Accident · No injuries · Closed · Jul 10, 1966 · N7042R · Substantial damage
- [NTSB MIA67D0109](https://openairdocs.org/ntsb/MIA67D0109.md): Luscombe 8E · Gadsen, AL · Accident · No injuries · Closed · Jul 10, 1966 · N2634K · Substantial damage
- [NTSB LAX67F0040](https://openairdocs.org/ntsb/LAX67F0040.md): Cessna 172B · El Monte, CA · Accident · No injuries · Closed · Jul 10, 1966 · N8099X · Substantial damage
- [NTSB FTW67A0008](https://openairdocs.org/ntsb/FTW67A0008.md): Brantly 305 · Wichita Falls, TX · Accident · Serious injuries · Closed · Jul 10, 1966 · N2203U · Destroyed
- [NTSB FTW67A0007](https://openairdocs.org/ntsb/FTW67A0007.md): Beech 35 · Andrews, TX · Accident · 5 fatal · Closed · Jul 10, 1966 · N4508V · Destroyed
- [NTSB NYC67A0009](https://openairdocs.org/ntsb/NYC67A0009.md): Waco 10 · Caldwel, NJ · Accident · 2 fatal · Closed · Jul 9, 1966 · N904H · Destroyed
- [NTSB CHI67F0161](https://openairdocs.org/ntsb/CHI67F0161.md): Cessna 150 · Kankakee, IL · Accident · No injuries · Closed · Jul 9, 1966 · N1146Y · 2 aircraft · Substantial damage
- [NTSB NYC67F0078](https://openairdocs.org/ntsb/NYC67F0078.md): Cessna 182J · Roanoke, VA · Accident · Minor injuries · Closed · Jul 8, 1966 · N2826F · Substantial damage
- [NTSB MIA67F0061](https://openairdocs.org/ntsb/MIA67F0061.md): Aero Comdr 500 · Ft Lauderdale, FL · Accident · No injuries · Closed · Jul 8, 1966 · N3828C · Substantial damage
- [NTSB CHI67D0225](https://openairdocs.org/ntsb/CHI67D0225.md): Cessna 150 · Cleveland, OH · Accident · No injuries · Closed · Jul 8, 1966 · N3981U · Substantial damage
- [NTSB MKC67F0052](https://openairdocs.org/ntsb/MKC67F0052.md): Cessna 150D · Bonner Sprgs, KS · Accident · Minor injuries · Closed · Jul 6, 1966 · N4410U · Substantial damage
- [NTSB CHI67F0089](https://openairdocs.org/ntsb/CHI67F0089.md): Piper PA-28 · Troy, MI · Accident · No injuries · Closed · Jul 6, 1966 · N4689R · Substantial damage
- [NTSB NYC67D0664](https://openairdocs.org/ntsb/NYC67D0664.md): Taylorcraft BC-12D · Cowansville, PA · Accident · No injuries · Closed · Jul 5, 1966 · N95000 · Substantial damage
- [NTSB NYC67A0004](https://openairdocs.org/ntsb/NYC67A0004.md): Pine Air Superv · Mt Pocono, PA · Accident · 2 fatal · Closed · Jul 5, 1966 · N174SV · Destroyed
- [NTSB MIA67F0011](https://openairdocs.org/ntsb/MIA67F0011.md): Cessna 150 · Clinton, NC · Accident · No injuries · Closed · Jul 5, 1966 · N7030F · Substantial damage
- [NTSB NYC67D0016](https://openairdocs.org/ntsb/NYC67D0016.md): Piper PA-23 · Norwood, MA · Accident · No injuries · Closed · Jul 4, 1966 · N4455P · Substantial damage
- [NTSB DEN67D0084](https://openairdocs.org/ntsb/DEN67D0084.md): Cessna 182 · Longmont, CO · Accident · No injuries · Closed · Jul 4, 1966 · N5306B · Substantial damage
- [NTSB CHI67F0077](https://openairdocs.org/ntsb/CHI67F0077.md): Stinson 108 · Ravenna, MI · Accident · No injuries · Closed · Jul 4, 1966 · N97616 · Substantial damage
- [NTSB NYC67F0082](https://openairdocs.org/ntsb/NYC67F0082.md): Cessna 180 · Beaver Falls, PA · Accident · Minor injuries · Closed · Jul 3, 1966 · N3214D · Substantial damage
- [NTSB OAK67D0038](https://openairdocs.org/ntsb/OAK67D0038.md): Cessna 172 · Monache Medow, CA · Accident · Serious injuries · Closed · Jul 2, 1966 · N8903B · Destroyed
- [NTSB NYC67F0053](https://openairdocs.org/ntsb/NYC67F0053.md): Piper PA-28 · White Plains, NY · Accident · No injuries · Closed · Jul 2, 1966 · N6833W · Substantial damage
- [NTSB NYC67D0095](https://openairdocs.org/ntsb/NYC67D0095.md): Boeing E75N1 · Stormville, NY · Accident · Serious injuries · Closed · Jul 2, 1966 · N17811 · Destroyed
- [NTSB NYC67A0003](https://openairdocs.org/ntsb/NYC67A0003.md): Erco 415-D · Johnstown, NY · Accident · 2 fatal · Closed · Jul 2, 1966 · N99566 · Destroyed

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

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

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