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

## Cases, newest first

- [NTSB MKC72DER24](https://openairdocs.org/ntsb/MKC72DER24.md): Beech 19A · Blue Earth, MN · Accident · No injuries · Closed · Oct 9, 1971 · N7682R · Substantial damage
- [NTSB CHI72FEE32](https://openairdocs.org/ntsb/CHI72FEE32.md): Beech 95-B55 · Lockport, IL · Accident · No injuries · Closed · Oct 9, 1971 · N7515N · Substantial damage
- [NTSB CHI72AC033](https://openairdocs.org/ntsb/CHI72AC033.md): Piper PA-28 · Urbana, IL · Accident · Minor injuries · Closed · Oct 9, 1971 · N6597W · 2 aircraft · Substantial damage
- [NTSB OAK72FVD24](https://openairdocs.org/ntsb/OAK72FVD24.md): Aeronca 7EC · Sonoma, CA · Accident · No injuries · Closed · Oct 8, 1971 · N7410B · Substantial damage
- [NTSB NYC72FKM11](https://openairdocs.org/ntsb/NYC72FKM11.md): Alon A-2 · Hickory, NC · Accident · Serious injuries · Closed · Oct 8, 1971 · N5486E · Substantial damage
- [NTSB MKC72AK026](https://openairdocs.org/ntsb/MKC72AK026.md): Beech S35 · Topeka, KS · Accident · 3 fatal · Closed · Oct 8, 1971 · N5883S · 2 aircraft · Destroyed
- [NTSB LAX72FUD04](https://openairdocs.org/ntsb/LAX72FUD04.md): Beech A23-19 · Sta Monica, CA · Accident · No injuries · Closed · Oct 8, 1971 · N6147N · Destroyed
- [NTSB MKC72FCG24](https://openairdocs.org/ntsb/MKC72FCG24.md): Beech B35A · Warrensburg, MO · Accident · No injuries · Closed · Oct 7, 1971 · N8756A · Substantial damage
- [NTSB DEN72FTC09](https://openairdocs.org/ntsb/DEN72FTC09.md): Helio H-395 · Jackson, WY · Accident · No injuries · Closed · Oct 6, 1971 · N4198D · Substantial damage
- [NTSB LAX72FUG25](https://openairdocs.org/ntsb/LAX72FUG25.md): Piper PA-32 · Rialto, CA · Accident · No injuries · Closed · Oct 4, 1971 · N5219S · Substantial damage
- [NTSB LAX72FUA17](https://openairdocs.org/ntsb/LAX72FUA17.md): Cessna 150E · Avalon, CA · Accident · No injuries · Closed · Oct 4, 1971 · N4065U · Substantial damage
- [NTSB SEA72DTI08](https://openairdocs.org/ntsb/SEA72DTI08.md): Mooney M20C · Great Falls, MT · Accident · Serious injuries · Closed · Oct 3, 1971 · N78939 · Substantial damage
- [NTSB CHI72FCA01](https://openairdocs.org/ntsb/CHI72FCA01.md): Piper PA-24 · E St Louis, IL · Accident · No injuries · Closed · Oct 3, 1971 · N6886P · Substantial damage
- [NTSB CHI72DEP19](https://openairdocs.org/ntsb/CHI72DEP19.md): Doers B8M · Tichigan, WI · Accident · No injuries · Closed · Oct 2, 1971 · N7195 · Substantial damage
- [NTSB ANC72DAG60](https://openairdocs.org/ntsb/ANC72DAG60.md): Cessna 185A · Homer, AK · Accident · No injuries · Closed · Oct 2, 1971 · N1646Z · Substantial damage
- [NTSB CHI72DEA15](https://openairdocs.org/ntsb/CHI72DEA15.md): Taylorcraft BC12-D · Palmyra, IN · Accident · No injuries · Closed · Oct 1, 1971 · N5610M · Substantial damage
- [NTSB CHI72FEG17](https://openairdocs.org/ntsb/CHI72FEG17.md): Cessna 210 · Versailles, OH · Accident · No injuries · Closed · Sep 27, 1971 · N6126R · Substantial damage
- [NTSB ANC72FAA17](https://openairdocs.org/ntsb/ANC72FAA17.md): Piper PA-28 · Fairbanks, AK · Accident · Minor injuries · Closed · Sep 27, 1971 · N5757U · Substantial damage
- [NTSB NYC72FGM16](https://openairdocs.org/ntsb/NYC72FGM16.md): Gibson VPI · Belle Vernon, PA · Accident · Serious injuries · Closed · Sep 24, 1971 · N5186 · Substantial damage
- [NTSB DEN72AD015](https://openairdocs.org/ntsb/DEN72AD015.md): Martin RB-57C · Albuquerque, NM · Accident · 2 fatal · Closed · Sep 24, 1971 · AF533842 · 2 aircraft · Minor damage
- [NTSB CHI72DEE36](https://openairdocs.org/ntsb/CHI72DEE36.md): Champion 7EC · Lasalle, IL · Accident · No injuries · Closed · Sep 24, 1971 · N7459B · Substantial damage
- [NTSB MIA72FKG44](https://openairdocs.org/ntsb/MIA72FKG44.md): Hughes 269B · Arlington, GA · Accident · No injuries · Closed · Sep 23, 1971 · N9489F · Substantial damage
- [NTSB CHI72AC026](https://openairdocs.org/ntsb/CHI72AC026.md): Piper PA-28 · Toledo, MI · Accident · 1 fatal · Closed · Sep 23, 1971 · N814CR · Destroyed
- [NTSB NYC72FHD15](https://openairdocs.org/ntsb/NYC72FHD15.md): Piper PA-39 · Ambler, PA · Accident · No injuries · Closed · Sep 22, 1971 · N8898Y · Substantial damage
- [NTSB FTW72FPJ15](https://openairdocs.org/ntsb/FTW72FPJ15.md): Luscombe 8A · Oklahoma Cty, OK · Accident · No injuries · Closed · Sep 22, 1971 · N1942B · Substantial damage
- [NTSB NYC72AN044](https://openairdocs.org/ntsb/NYC72AN044.md): Piper PA-23 · Lyme Center, NH · Accident · 1 fatal · Closed · Sep 20, 1971 · N3435P · Destroyed
- [NTSB MKC72FER21](https://openairdocs.org/ntsb/MKC72FER21.md): Piper PA-22 · Isle, MN · Accident · Serious injuries · Closed · Sep 19, 1971 · N5798Z · Substantial damage
- [NTSB DEN72AD014](https://openairdocs.org/ntsb/DEN72AD014.md): Cessna 172F · Capitan, NM · Accident · 2 fatal · Closed · Sep 18, 1971 · N5552R · Destroyed
- [NTSB FTW72DRJ09](https://openairdocs.org/ntsb/FTW72DRJ09.md): Cessna 150 · Nacogdoches, TX · Accident · No injuries · Closed · Sep 16, 1971 · N6881G · Substantial damage
- [NTSB MIA72AM025](https://openairdocs.org/ntsb/MIA72AM025.md): Aero Comdr 560-A · Jackson, MS · Accident · 5 fatal · Closed · Sep 15, 1971 · N2779B · Destroyed
- [NTSB CHI72FEM30](https://openairdocs.org/ntsb/CHI72FEM30.md): Piper PA-28 · Pellston, MI · Accident · No injuries · Closed · Sep 15, 1971 · N201MA · Substantial damage
- [NTSB CHI72DEG14](https://openairdocs.org/ntsb/CHI72DEG14.md): Champion 7ECA · Dayton, OH · Accident · No injuries · Closed · Sep 15, 1971 · N1839G · Substantial damage
- [NTSB DEN72AD012](https://openairdocs.org/ntsb/DEN72AD012.md): Cessna 172L · Lake City, CO · Accident · 2 fatal · Closed · Sep 14, 1971 · N7920G · Destroyed
- [NTSB ANC72DAG38](https://openairdocs.org/ntsb/ANC72DAG38.md): Cessna 150K · Anchorage, AK · Accident · Minor injuries · Closed · Sep 14, 1971 · N6210G · Substantial damage
- [NTSB SEA72FYA13](https://openairdocs.org/ntsb/SEA72FYA13.md): Cessna 172 · Yellowpine, ID · Accident · Minor injuries · Closed · Sep 13, 1971 · N5183A · Destroyed
- [NTSB MIA72FKG40](https://openairdocs.org/ntsb/MIA72FKG40.md): Beech A35 · St.Marys, GA · Accident · Serious injuries · Closed · Sep 12, 1971 · N8499A · Substantial damage
- [NTSB ANC72DAG56](https://openairdocs.org/ntsb/ANC72DAG56.md): Piper PA-18 · Chugiak, AK · Accident · No injuries · Closed · Sep 12, 1971 · N4579A · Substantial damage
- [NTSB SEA72AS011](https://openairdocs.org/ntsb/SEA72AS011.md): Erco 415C · Boise, ID · Accident · 1 fatal · Closed · Sep 11, 1971 · N413L · Destroyed
- [NTSB NYC72AN038](https://openairdocs.org/ntsb/NYC72AN038.md): Lockheed PV-1 · Philadelphia, PA · Accident · Minor injuries · Closed · Sep 11, 1971 · N725YC · Destroyed
- [NTSB MKC72FCG22](https://openairdocs.org/ntsb/MKC72FCG22.md): Cessna 310N · Mound City, MO · Accident · No injuries · Closed · Sep 10, 1971 · N111KC · Substantial damage
- [NTSB CHI72FEM28](https://openairdocs.org/ntsb/CHI72FEM28.md): Cessna 172K · Acme, MI · Accident · Minor injuries · Closed · Sep 10, 1971 · CF-YJZ · Substantial damage
- [NTSB ANC72DAG55](https://openairdocs.org/ntsb/ANC72DAG55.md): Champion 7GC · Cordova, AK · Accident · No injuries · Closed · Sep 10, 1971 · N4891E · Substantial damage
- [NTSB MKC72FCJ24](https://openairdocs.org/ntsb/MKC72FCJ24.md): Cessna 177 · Omaha, NE · Accident · No injuries · Closed · Sep 9, 1971 · N3242T · Substantial damage
- [NTSB CHI72FEG13](https://openairdocs.org/ntsb/CHI72FEG13.md): Piper PA-30 · Tipp City, OH · Accident · Minor injuries · Closed · Sep 9, 1971 · N7714Y · Destroyed
- [NTSB CHI72FEK04](https://openairdocs.org/ntsb/CHI72FEK04.md): Navion A · Coshocton, OH · Accident · Serious injuries · Closed · Sep 8, 1971 · N4483K · Destroyed
- [NTSB CHI72AC021](https://openairdocs.org/ntsb/CHI72AC021.md): Piper PA-28R · Flint, MI · Accident · Serious injuries · Closed · Sep 7, 1971 · N2070T · 2 aircraft · Destroyed
- [NTSB MIA72FLA08](https://openairdocs.org/ntsb/MIA72FLA08.md): Piper PA-28R · Gainesville, FL · Accident · No injuries · Closed · Sep 6, 1971 · N3923T · Substantial damage
- [NTSB OAK72DVM06](https://openairdocs.org/ntsb/OAK72DVM06.md): Piper PA-28 · Santa Cruz, CA · Accident · No injuries · Closed · Sep 5, 1971 · N5928U · Substantial damage
- [NTSB NYC72DGM15](https://openairdocs.org/ntsb/NYC72DGM15.md): Cessna 150 · Eighty Four, PA · Accident · No injuries · Closed · Sep 5, 1971 · N61038 · Substantial damage
- [NTSB MKC72DCD33](https://openairdocs.org/ntsb/MKC72DCD33.md): Piper PA-28 · Osage, IA · Accident · No injuries · Closed · Sep 5, 1971 · N4203J · Substantial damage

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

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

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