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

## Cases, newest first

- [NTSB MKC66A0049](https://openairdocs.org/ntsb/MKC66A0049.md): Brantly B-2B · Axtell, NE · Accident · No injuries · Closed · Mar 8, 1966 · N2284U · Substantial damage
- [NTSB CHI66A0072](https://openairdocs.org/ntsb/CHI66A0072.md): Cessna 150 · Utica, MI · Accident · 2 fatal · Closed · Mar 3, 1966 · N8147S · Destroyed
- [NTSB NYC66D0589](https://openairdocs.org/ntsb/NYC66D0589.md): Piper PA-22 · Fredericksburg, VA · Accident · No injuries · Closed · Mar 2, 1966 · N3630Z · Substantial damage
- [NTSB LAX66F0291](https://openairdocs.org/ntsb/LAX66F0291.md): Piper PA-28 · Chino, CA · Accident · Serious injuries · Closed · Mar 2, 1966 · N5887W · Substantial damage
- [NTSB MKC66D0491](https://openairdocs.org/ntsb/MKC66D0491.md): Cessna 140 · Coffeyvill, KS · Accident · Minor injuries · Closed · Feb 28, 1966 · N76152 · Destroyed
- [NTSB FTW66D0571](https://openairdocs.org/ntsb/FTW66D0571.md): Aero Cmdr 680 · Laredo, TX · Accident · No injuries · Closed · Feb 28, 1966 · N118E · Substantial damage
- [NTSB MIA66A0096](https://openairdocs.org/ntsb/MIA66A0096.md): Cessna 182 · Muscogee, GA · Accident · 4 fatal · Closed · Feb 27, 1966 · N5314B · Destroyed
- [NTSB LAX66F0266](https://openairdocs.org/ntsb/LAX66F0266.md): Piper PA-24 · Santa Paula, CA · Accident · No injuries · Closed · Feb 26, 1966 · N5003P · Substantial damage
- [NTSB FTW66A0074](https://openairdocs.org/ntsb/FTW66A0074.md): Piper PA-24 · Lubbock, TX · Accident · No injuries · Closed · Feb 25, 1966 · N8328P · Substantial damage
- [NTSB FTW66F0545](https://openairdocs.org/ntsb/FTW66F0545.md): Aeronca 0-58B · Lubbock, TX · Accident · Serious injuries · Closed · Feb 23, 1966 · N50562 · Substantial damage
- [NTSB NYC66F0567](https://openairdocs.org/ntsb/NYC66F0567.md): Luscombe 8A · Tarentum, PA · Accident · No injuries · Closed · Feb 20, 1966 · N45825 · Substantial damage
- [NTSB NYC66D0515](https://openairdocs.org/ntsb/NYC66D0515.md): Piper J-3 · Edgewater, MD · Accident · Minor injuries · Closed · Feb 19, 1966 · N70255 · Substantial damage
- [NTSB NYC66D0514](https://openairdocs.org/ntsb/NYC66D0514.md): Piper PA-22 · Newberg, MD · Accident · No injuries · Closed · Feb 19, 1966 · N7040B · Substantial damage
- [NTSB MKC66F0453](https://openairdocs.org/ntsb/MKC66F0453.md): Cessna 175 · Manhattan, KS · Accident · No injuries · Closed · Feb 18, 1966 · N7056M · Destroyed
- [NTSB MKC66F0439](https://openairdocs.org/ntsb/MKC66F0439.md): Piper PA-22 · Kansas City, MO · Accident · Serious injuries · Closed · Feb 15, 1966 · N5727Z · Destroyed
- [NTSB DEN66D0226](https://openairdocs.org/ntsb/DEN66D0226.md): Piper PA-22 · Denver, CO · Accident · No injuries · Closed · Feb 15, 1966 · N5684Z · Substantial damage
- [NTSB NYC66D0485](https://openairdocs.org/ntsb/NYC66D0485.md): Piper PA-28 · Lehighton, PA · Accident · No injuries · Closed · Feb 14, 1966 · N6091W · Substantial damage
- [NTSB LAX66D0257](https://openairdocs.org/ntsb/LAX66D0257.md): Taylorcraft BC12-D · Minden, NV · Accident · No injuries · Closed · Feb 13, 1966 · N27426 · Substantial damage
- [NTSB FTW66F0568](https://openairdocs.org/ntsb/FTW66F0568.md): Mooney M20A · Orange, TX · Accident · Minor injuries · Closed · Feb 13, 1966 · N8108E · Substantial damage
- [NTSB FTW66F0532](https://openairdocs.org/ntsb/FTW66F0532.md): Piper J3 · Orange, TX · Accident · Minor injuries · Closed · Feb 13, 1966 · N24934 · Substantial damage
- [NTSB FTW66F0510](https://openairdocs.org/ntsb/FTW66F0510.md): Luscombe 8A · Oak Grove, LA · Accident · Serious injuries · Closed · Feb 13, 1966 · N829B · Destroyed
- [NTSB NYC66D0471](https://openairdocs.org/ntsb/NYC66D0471.md): Cessna 182 · Marlboro, MA · Accident · No injuries · Closed · Feb 12, 1966 · N6065B · Substantial damage
- [NTSB OAK66D0204](https://openairdocs.org/ntsb/OAK66D0204.md): Beechcraft 35 · Franklin, CA · Accident · No injuries · Closed · Feb 11, 1966 · N2856V · Substantial damage
- [NTSB NYC66F0484](https://openairdocs.org/ntsb/NYC66F0484.md): Piper PA-23 · Somerville, NJ · Accident · No injuries · Closed · Feb 11, 1966 · N4490P · Substantial damage
- [NTSB MIA66D0423](https://openairdocs.org/ntsb/MIA66D0423.md): Cessna 180 · Andros Is, Burkina Faso · Accident · No injuries · Closed · Feb 11, 1966 · N4088D · Substantial damage
- [NTSB DEN66D0229](https://openairdocs.org/ntsb/DEN66D0229.md): Piper PA-28 · Las Cruces, NM · Accident · No injuries · Closed · Feb 11, 1966 · N6242W · Substantial damage
- [NTSB SEA66D0227](https://openairdocs.org/ntsb/SEA66D0227.md): Piper PA-22 · Paulina, OR · Accident · No injuries · Closed · Feb 9, 1966 · N9017D · Substantial damage
- [NTSB CHI66A0067](https://openairdocs.org/ntsb/CHI66A0067.md): Beech D35 · Mattoon, IL · Accident · 2 fatal · Closed · Feb 8, 1966 · N112U · Destroyed
- [NTSB CHI66F0588](https://openairdocs.org/ntsb/CHI66F0588.md): Cessna 140 · Portage, MI · Accident · No injuries · Closed · Feb 7, 1966 · N89758 · Substantial damage
- [NTSB OAK66F0205](https://openairdocs.org/ntsb/OAK66F0205.md): Bellanca 14-19 · Santa Rosa, CA · Accident · No injuries · Closed · Feb 6, 1966 · N8868R · Substantial damage
- [NTSB OAK66D0187](https://openairdocs.org/ntsb/OAK66D0187.md): Stinson 108-1 · Healdsburg, CA · Accident · Minor injuries · Closed · Feb 6, 1966 · N8156K · Destroyed
- [NTSB NYC66D0488](https://openairdocs.org/ntsb/NYC66D0488.md): Aeronca S-65CA · Ravena, NY · Accident · No injuries · Closed · Feb 6, 1966 · N34596 · Substantial damage
- [NTSB CHI66D0574](https://openairdocs.org/ntsb/CHI66D0574.md): Piper PA-22 · Painesville, OH · Accident · Minor injuries · Closed · Feb 6, 1966 · N5454Z · Substantial damage
- [NTSB NYC66D0479](https://openairdocs.org/ntsb/NYC66D0479.md): Piper PA-28 · Clearfield, PA · Accident · No injuries · Closed · Feb 5, 1966 · N8546W · Substantial damage
- [NTSB NYC66A0085](https://openairdocs.org/ntsb/NYC66A0085.md): Beech 23 · Wappingers Fls, NY · Accident · 3 fatal · Closed · Feb 5, 1966 · N2328Q · 2 aircraft · Destroyed
- [NTSB MIA66F0443](https://openairdocs.org/ntsb/MIA66F0443.md): Aeronca L-16 · Muscle Shoals, AL · Accident · Minor injuries · Closed · Feb 5, 1966 · N65885 · 2 aircraft · Destroyed
- [NTSB FTW66F0519](https://openairdocs.org/ntsb/FTW66F0519.md): Cessna 150 · Dickinson, TX · Accident · No injuries · Closed · Feb 4, 1966 · N4155U · Substantial damage
- [NTSB NYC66A0084](https://openairdocs.org/ntsb/NYC66A0084.md): Bell 47G2 · Bowie, MD · Accident · No injuries · Closed · Feb 3, 1966 · N7890B · Substantial damage
- [NTSB MKC66D0408](https://openairdocs.org/ntsb/MKC66D0408.md): Cessna 172B · Litchfield, MN · Accident · No injuries · Closed · Feb 3, 1966 · N7436X · Substantial damage
- [NTSB MIA66D0408](https://openairdocs.org/ntsb/MIA66D0408.md): Swift GC-1B · Memphis, TN · Accident · No injuries · Closed · Feb 3, 1966 · N78290 · Substantial damage
- [NTSB DEN66A0057](https://openairdocs.org/ntsb/DEN66A0057.md): Lockheed PV-2 · Phoenix, AZ · Accident · 2 fatal · Closed · Feb 3, 1966 · N7258C · Destroyed
- [NTSB CHI66D0557](https://openairdocs.org/ntsb/CHI66D0557.md): Cessna 120 · Wooster, OH · Accident · No injuries · Closed · Feb 3, 1966 · N72783 · Substantial damage
- [NTSB MIA66D0418](https://openairdocs.org/ntsb/MIA66D0418.md): Cessna 150 · Homestead, FL · Accident · Minor injuries · Closed · Feb 2, 1966 · N5768E · Substantial damage
- [NTSB LAX66F0247](https://openairdocs.org/ntsb/LAX66F0247.md): Cessna 172 · Chiriaco Sut, CA · Accident · Minor injuries · Closed · Feb 2, 1966 · N5660T · Substantial damage
- [NTSB FTW66F0513](https://openairdocs.org/ntsb/FTW66F0513.md): Cessna 210 · Devine, TX · Accident · No injuries · Closed · Feb 2, 1966 · N9661T · Substantial damage
- [NTSB FTW66F0505](https://openairdocs.org/ntsb/FTW66F0505.md): Cessna 210 · Seguin, TX · Accident · No injuries · Closed · Feb 2, 1966 · N9661T · Substantial damage
- [NTSB DEN66D0235](https://openairdocs.org/ntsb/DEN66D0235.md): Cessna 320 · Sierra Vsta, AZ · Accident · No injuries · Closed · Feb 1, 1966 · N3045T · Substantial damage
- [NTSB CHI66F0653](https://openairdocs.org/ntsb/CHI66F0653.md): Beech B50 · Waukegan, IL · Accident · Serious injuries · Closed · Feb 1, 1966 · N3660B · Destroyed
- [NTSB CHI66F0536](https://openairdocs.org/ntsb/CHI66F0536.md): Piper PA-23 · Columbus, OH · Accident · No injuries · Closed · Feb 1, 1966 · N5512Y · Substantial damage
- [NTSB LAX66F0225](https://openairdocs.org/ntsb/LAX66F0225.md): Cessna 172 · Apple Valley, CA · Accident · Minor injuries · Closed · Jan 31, 1966 · N8480X · Destroyed

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

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

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