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

## Cases, newest first

- [NTSB MKC66A0023](https://openairdocs.org/ntsb/MKC66A0023.md): Cessna 172C · Fulton, MO · Accident · 3 fatal · Closed · Oct 8, 1965 · N1578Y · Destroyed
- [NTSB MKC66A0022](https://openairdocs.org/ntsb/MKC66A0022.md): Air & Space 18A · Creve Coeur, MO · Accident · Serious injuries · Closed · Oct 7, 1965 · N6166S · Substantial damage
- [NTSB CHI66F0355](https://openairdocs.org/ntsb/CHI66F0355.md): Cessna 172 · Delaware, OH · Accident · No injuries · Closed · Oct 7, 1965 · N6430E · Substantial damage
- [NTSB ANC66F0058](https://openairdocs.org/ntsb/ANC66F0058.md): Champion 7HC · Anchorage, AK · Accident · Minor injuries · Closed · Oct 5, 1965 · N8974R · Substantial damage
- [NTSB DEN66F0111](https://openairdocs.org/ntsb/DEN66F0111.md): Cessna 320D · Albuquerque, NM · Accident · Serious injuries · Closed · Oct 4, 1965 · N4104T · Substantial damage
- [NTSB ANC66D0065](https://openairdocs.org/ntsb/ANC66D0065.md): Aeronca 11BC · Sleetmute, AK · Accident · No injuries · Closed · Oct 4, 1965 · N3936E · Substantial damage
- [NTSB FTW66F0336](https://openairdocs.org/ntsb/FTW66F0336.md): Navion A · Clovis, NM · Accident · No injuries · Closed · Oct 3, 1965 · N91165 · Substantial damage
- [NTSB MIA66D0292](https://openairdocs.org/ntsb/MIA66D0292.md): Cessna 172 · Miami, FL · Accident · No injuries · Closed · Oct 2, 1965 · N3920S · Substantial damage
- [NTSB SEA66D0160](https://openairdocs.org/ntsb/SEA66D0160.md): Cessna 170 · Monument, OR · Accident · No injuries · Closed · Oct 1, 1965 · N3903V · Substantial damage
- [NTSB NYC66A0043](https://openairdocs.org/ntsb/NYC66A0043.md): Cessna 182 · Chantilly, VA · Accident · 4 fatal · Closed · Oct 1, 1965 · N2068X · Destroyed
- [NTSB CHI66F0339](https://openairdocs.org/ntsb/CHI66F0339.md): Beechcraft A23 · East Lansing, MI · Accident · No injuries · Closed · Sep 29, 1965 · N3530R · Substantial damage
- [NTSB MKC66F0268](https://openairdocs.org/ntsb/MKC66F0268.md): Cessna 150 · Warrensburg, MO · Accident · Minor injuries · Closed · Sep 28, 1965 · N7938Z · Substantial damage
- [NTSB ANC66D0055](https://openairdocs.org/ntsb/ANC66D0055.md): Champion 7HC · Tyonek, AK · Accident · No injuries · Closed · Sep 27, 1965 · N8974R · Substantial damage
- [NTSB NYC66F0276](https://openairdocs.org/ntsb/NYC66F0276-201526.md): Piper PA-24 · Martinsville, VA · Accident · No injuries · Closed · Sep 26, 1965 · N6335P · Substantial damage
- [NTSB NYC66D0296](https://openairdocs.org/ntsb/NYC66D0296.md): Cessna 175 · Bedford, PA · Accident · No injuries · Closed · Sep 26, 1965 · N7036M · Substantial damage
- [NTSB MIA66D0273](https://openairdocs.org/ntsb/MIA66D0273.md): Ercoupe 415-C · Sylacauga, AL · Accident · No injuries · Closed · Sep 26, 1965 · N87272 · Substantial damage
- [NTSB CHI66F0322](https://openairdocs.org/ntsb/CHI66F0322.md): Cessna 182 · Columbus, OH · Accident · No injuries · Closed · Sep 26, 1965 · N9019X · Substantial damage
- [NTSB MKC66F0262](https://openairdocs.org/ntsb/MKC66F0262.md): Piper PA-24 · Wichita, KS · Accident · No injuries · Closed · Sep 25, 1965 · N6839P · Substantial damage
- [NTSB LAX66A0033](https://openairdocs.org/ntsb/LAX66A0033.md): N.American P-51 · Boulder City, NV · Accident · 1 fatal · Closed · Sep 25, 1965 · N5151 · Destroyed
- [NTSB FTW66F0302](https://openairdocs.org/ntsb/FTW66F0302.md): Piper PA-22 · Abernathy, TX · Accident · No injuries · Closed · Sep 25, 1965 · N7107B · Substantial damage
- [NTSB ANC66D0043](https://openairdocs.org/ntsb/ANC66D0043.md): Piper PA-22 · Fairbanks, AK · Accident · Minor injuries · Closed · Sep 25, 1965 · N9167D · Substantial damage
- [NTSB OAK66D0073](https://openairdocs.org/ntsb/OAK66D0073.md): Cessna 182 · Arbuckle, CA · Accident · No injuries · Closed · Sep 24, 1965 · N2299C · Substantial damage
- [NTSB OAK66F0096](https://openairdocs.org/ntsb/OAK66F0096.md): Beech C-45H · Honolulu, HI · Accident · No injuries · Closed · Sep 22, 1965 · N134 · Substantial damage
- [NTSB NYC66F0267](https://openairdocs.org/ntsb/NYC66F0267.md): Cessna 150 · Beverly, MA · Accident · No injuries · Closed · Sep 22, 1965 · N7884E · Substantial damage
- [NTSB MIA66F0247](https://openairdocs.org/ntsb/MIA66F0247.md): Champion 7FC · Cabo Rojo, PR · Accident · No injuries · Closed · Sep 22, 1965 · N8909R · Substantial damage
- [NTSB NYC66F0271](https://openairdocs.org/ntsb/NYC66F0271.md): Piper PA-28 · Gloucester, VA · Accident · No injuries · Closed · Sep 18, 1965 · N7838W · Substantial damage
- [NTSB NYC66F0224](https://openairdocs.org/ntsb/NYC66F0224-107195.md): Cessna 150F · Gardner, KS · Accident · Minor injuries · Closed · Sep 18, 1965 · N8257S · Substantial damage
- [NTSB MKC66A0019](https://openairdocs.org/ntsb/MKC66A0019.md): Douglas A-26 · Scottsbluff, NE · Accident · 3 fatal · Closed · Sep 17, 1965 · N67907 · Destroyed
- [NTSB MIA66F0257](https://openairdocs.org/ntsb/MIA66F0257.md): Cessna 150 · Birmingham, AL · Accident · Minor injuries · Closed · Sep 16, 1965 · N8667S · Destroyed
- [NTSB SEA66D0129](https://openairdocs.org/ntsb/SEA66D0129.md): Cessna 172 · Condon, OR · Accident · Minor injuries · Closed · Sep 15, 1965 · N8872U · Substantial damage
- [NTSB CHI66A0027](https://openairdocs.org/ntsb/CHI66A0027.md): Air Space 18A · Hobart, IN · Accident · Serious injuries · Closed · Sep 15, 1965 · N6114S · Substantial damage
- [NTSB CHI66A0026](https://openairdocs.org/ntsb/CHI66A0026.md): Douglas DC-3 · Stevens Pt., WI · Accident · No injuries · Closed · Sep 14, 1965 · N28341 · Substantial damage
- [NTSB MKC66F0231](https://openairdocs.org/ntsb/MKC66F0231.md): Piper PA-22 · Bigelow, MO · Accident · No injuries · Closed · Sep 13, 1965 · N7033D · Substantial damage
- [NTSB FTW66F0300](https://openairdocs.org/ntsb/FTW66F0300.md): Beechcraft M35 · El Paso, TX · Accident · Serious injuries · Closed · Sep 13, 1965 · N9709R · Destroyed
- [NTSB MIA66F0246](https://openairdocs.org/ntsb/MIA66F0246.md): Piper PA-22 · Orlando, FL · Accident · Minor injuries · Closed · Sep 12, 1965 · N5897Z · Substantial damage
- [NTSB LAX66A0025](https://openairdocs.org/ntsb/LAX66A0025.md): Cougar MACH.2 · Pacoima, CA · Accident · 2 fatal · Closed · Sep 12, 1965 · N58922 · Destroyed
- [NTSB OAK66A0010](https://openairdocs.org/ntsb/OAK66A0010.md): Beechcraft B35 · Lone Pine, CA · Accident · 1 fatal · Closed · Sep 11, 1965 · N5107C · Destroyed
- [NTSB LAX66D0108](https://openairdocs.org/ntsb/LAX66D0108.md): Cessna 172 · Rosamond, CA · Accident · No injuries · Closed · Sep 11, 1965 · N364SR · Substantial damage
- [NTSB NYC66F0216](https://openairdocs.org/ntsb/NYC66F0216.md): Piper PA-22 · West Point, VA · Accident · No injuries · Closed · Sep 9, 1965 · N5837Z · Substantial damage
- [NTSB DEN66A0020](https://openairdocs.org/ntsb/DEN66A0020.md): Bell 47G3B1 · Commerce Cty, CO · Accident · No injuries · Closed · Sep 9, 1965 · N1135W · Substantial damage
- [NTSB FTW66A0027](https://openairdocs.org/ntsb/FTW66A0027.md): Cessna 120 · Garland, TX · Accident · 1 fatal · Closed · Sep 8, 1965 · N76416 · Destroyed
- [NTSB NYC66F0210](https://openairdocs.org/ntsb/NYC66F0210.md): Ercoupe 415C · Agawam, MA · Accident · No injuries · Closed · Sep 7, 1965 · N93674 · Substantial damage
- [NTSB NYC66D0239](https://openairdocs.org/ntsb/NYC66D0239.md): Leister-K 10-A · Frizzelburg, MD · Accident · No injuries · Closed · Sep 6, 1965 · N58179 · Substantial damage
- [NTSB CHI66D0346](https://openairdocs.org/ntsb/CHI66D0346.md): Cessna 182C · Strongsville, OH · Accident · Minor injuries · Closed · Sep 6, 1965 · N1812C · Substantial damage
- [NTSB OAK66A0007](https://openairdocs.org/ntsb/OAK66A0007.md): Huller UH12E · Honeydew, CA · Accident · No injuries · Closed · Sep 5, 1965 · N9747C · Substantial damage
- [NTSB NYC66F0261](https://openairdocs.org/ntsb/NYC66F0261.md): Piper PA-23 · Flushing, NY · Accident · Minor injuries · Closed · Sep 4, 1965 · N1260 · 2 aircraft · Substantial damage
- [NTSB MKC66D0212](https://openairdocs.org/ntsb/MKC66D0212.md): Cessna 180 · Maize, KS · Accident · No injuries · Closed · Sep 4, 1965 · N1577C · Substantial damage
- [NTSB CHI66F0306](https://openairdocs.org/ntsb/CHI66F0306.md): Cessna 195A · Frankfort, IL · Accident · Serious injuries · Closed · Sep 4, 1965 · N1052D · Destroyed
- [NTSB OAK66D0083](https://openairdocs.org/ntsb/OAK66D0083.md): Piper PA-24 · El Marco, CA · Accident · No injuries · Closed · Sep 3, 1965 · N8764P · Substantial damage
- [NTSB LAX66F0079](https://openairdocs.org/ntsb/LAX66F0079.md): Beech 35 · Long Beach, CA · Accident · No injuries · Closed · Sep 3, 1965 · N2996V · Substantial damage

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

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

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