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

## Cases, newest first

- [NTSB NYC72FHM24](https://openairdocs.org/ntsb/NYC72FHM24.md): Cessna 150 · West Caldwell, NJ · Accident · Minor injuries · Closed · Dec 29, 1971 · N8735S · Substantial damage
- [NTSB MIA72FKW10](https://openairdocs.org/ntsb/MIA72FKW10.md): Beech B95 · Rockwood, TN · Accident · No injuries · Closed · Dec 27, 1971 · N9890R · Substantial damage
- [NTSB MIA72DLA24](https://openairdocs.org/ntsb/MIA72DLA24.md): Piper PA-28 · High Springs, FL · Accident · No injuries · Closed · Dec 27, 1971 · N5202L · Substantial damage
- [NTSB NYC72DHA28](https://openairdocs.org/ntsb/NYC72DHA28.md): Beech B23 · Doylestown, PA · Accident · No injuries · Closed · Dec 26, 1971 · N6127N · Substantial damage
- [NTSB FTW72FPA11](https://openairdocs.org/ntsb/FTW72FPA11.md): Schweizer TG-3A · Valley Mills, TX · Accident · Serious injuries · Closed · Dec 26, 1971 · N59432 · Destroyed
- [NTSB CHI72AC054](https://openairdocs.org/ntsb/CHI72AC054.md): Piper PA-30 · Chesterfield, MO · Accident · 2 fatal · Closed · Dec 26, 1971 · N7756Y · Destroyed
- [NTSB MIA72FKJ36](https://openairdocs.org/ntsb/MIA72FKJ36.md): Cessna 172F · Oneonta, AL · Accident · 1 fatal · Closed · Dec 24, 1971 · N7856U · Destroyed
- [NTSB MIA72DKW11](https://openairdocs.org/ntsb/MIA72DKW11.md): Champion 7ECA · Lafollette, TN · Accident · No injuries · Closed · Dec 23, 1971 · N7585F · Substantial damage
- [NTSB MIA72IM055](https://openairdocs.org/ntsb/MIA72IM055.md): Boeing 727 · Atlanta, GA · Incident · No injuries · Closed · Dec 21, 1971 · N8168G · Minor damage
- [NTSB MIA72AM057](https://openairdocs.org/ntsb/MIA72AM057.md): Brittnorman BN-2 · Culebra, PR · Accident · Serious injuries · Closed · Dec 21, 1971 · N589JA · Destroyed
- [NTSB MKC72FCJ41](https://openairdocs.org/ntsb/MKC72FCJ41.md): Piper PA-28 · Lincoln, NE · Accident · Minor injuries · Closed · Dec 19, 1971 · N6710J · Substantial damage
- [NTSB SEA72FYC25](https://openairdocs.org/ntsb/SEA72FYC25.md): Cessna 150 · Forest Grove, OR · Accident · No injuries · Closed · Dec 18, 1971 · N7011S · Substantial damage
- [NTSB MKC72FER34](https://openairdocs.org/ntsb/MKC72FER34.md): Cessna 172E · Walker, MN · Accident · No injuries · Closed · Dec 18, 1971 · N3599S · Substantial damage
- [NTSB ANC72DAG84](https://openairdocs.org/ntsb/ANC72DAG84.md): Cessna 120 · Hope, AK · Accident · No injuries · Closed · Dec 18, 1971 · N72233 · Substantial damage
- [NTSB SEA72AS024](https://openairdocs.org/ntsb/SEA72AS024.md): Beech 65-B80 · Mccall, ID · Accident · Serious injuries · Closed · Dec 16, 1971 · N1028C · Substantial damage
- [NTSB NYC72FNE20](https://openairdocs.org/ntsb/NYC72FNE20.md): Cessna 182L · Simsbury, CT · Accident · No injuries · Closed · Dec 15, 1971 · N3366R · Destroyed
- [NTSB NYC72AN082](https://openairdocs.org/ntsb/NYC72AN082.md): Piper PA-23 · Haledon, NJ · Accident · Serious injuries · Closed · Dec 15, 1971 · N6685Y · Destroyed
- [NTSB MIA72DKA08](https://openairdocs.org/ntsb/MIA72DKA08.md): Piper PA-28 · Mayaguez, PR · Accident · Minor injuries · Closed · Dec 14, 1971 · N5991W · Substantial damage
- [NTSB NYC72AN080](https://openairdocs.org/ntsb/NYC72AN080.md): Beech 95-C55 · Charlotte, NC · Accident · 4 fatal · Closed · Dec 13, 1971 · N4877J · Destroyed
- [NTSB MKC72FCJ40](https://openairdocs.org/ntsb/MKC72FCJ40.md): Piper PA-28R · Scribner, NE · Accident · Minor injuries · Closed · Dec 13, 1971 · N4981J · Substantial damage
- [NTSB FTW72AF036](https://openairdocs.org/ntsb/FTW72AF036.md): Cessna 310 · San Antonio, TX · Accident · 1 fatal · Closed · Dec 13, 1971 · N5203A · Destroyed
- [NTSB MIA72AM052](https://openairdocs.org/ntsb/MIA72AM052.md): Schweizer SGS233 · Williamson, GA · Accident · 1 fatal · Closed · Dec 12, 1971 · N1201S · Substantial damage
- [NTSB CHI72AC051](https://openairdocs.org/ntsb/CHI72AC051.md): Cessna 320D · Springfield, IL · Accident · 2 fatal · Closed · Dec 12, 1971 · N777K · Destroyed
- [NTSB NYC72AN077](https://openairdocs.org/ntsb/NYC72AN077.md): Cessna 172 · Buckhannon, WV · Accident · 1 fatal · Closed · Dec 11, 1971 · N2501Y · Destroyed
- [NTSB FTW72AF034](https://openairdocs.org/ntsb/FTW72AF034.md): Piper PA-28 · Piedmont, OK · Accident · 1 fatal · Closed · Dec 11, 1971 · N5461S · Destroyed
- [NTSB CHI72FEP24](https://openairdocs.org/ntsb/CHI72FEP24.md): Mitsubishi MU2B20 · East Troy, WI · Accident · No injuries · Closed · Dec 11, 1971 · N304L · Substantial damage
- [NTSB CHI72FEE48](https://openairdocs.org/ntsb/CHI72FEE48.md): Navion B · Harvard, IL · Accident · No injuries · Closed · Dec 11, 1971 · N5327K · Substantial damage
- [NTSB NYC72FHM23](https://openairdocs.org/ntsb/NYC72FHM23.md): Aero Comdr 500S · Morristown, NJ · Accident · Serious injuries · Closed · Dec 10, 1971 · N9128N · Destroyed
- [NTSB NYC72FHM22](https://openairdocs.org/ntsb/NYC72FHM22.md): Cessna 150 · Linden, NJ · Accident · No injuries · Closed · Dec 10, 1971 · N61274 · Substantial damage
- [NTSB MIA72FLA25](https://openairdocs.org/ntsb/MIA72FLA25.md): Cessna 337A · Mcintosh, FL · Accident · No injuries · Closed · Dec 8, 1971 · N6357F · Substantial damage
- [NTSB FTW72FRA23](https://openairdocs.org/ntsb/FTW72FRA23.md): Lockheed 1329 · Houston, TX · Incident · No injuries · Closed · Dec 8, 1971 · N110G · No damage
- [NTSB MKC72FER31](https://openairdocs.org/ntsb/MKC72FER31.md): Cessna 421 · Crystal, MN · Accident · No injuries · Closed · Dec 7, 1971 · N4018L · Substantial damage
- [NTSB MKC72FCA18](https://openairdocs.org/ntsb/MKC72FCA18.md): Piper PA-30 · Scott City, MO · Accident · Serious injuries · Closed · Dec 7, 1971 · N8040Y · Destroyed
- [NTSB LAX72DUG38](https://openairdocs.org/ntsb/LAX72DUG38.md): Cessna 150 · Chino, CA · Accident · No injuries · Closed · Dec 5, 1971 · N5927J · Substantial damage
- [NTSB FTW72AF031](https://openairdocs.org/ntsb/FTW72AF031.md): Aero Comdr 680T · New Orleans, LA · Accident · 3 fatal · Closed · Dec 5, 1971 · N78D · Destroyed
- [NTSB CHI72FEP23](https://openairdocs.org/ntsb/CHI72FEP23.md): Piper PA-32 · Waukesha, WI · Accident · Minor injuries · Closed · Dec 5, 1971 · N3449W · Destroyed
- [NTSB OAK72AP017](https://openairdocs.org/ntsb/OAK72AP017.md): Taylorcraft DC-65 · Mariposa, CA · Accident · 1 fatal · Closed · Dec 4, 1971 · N47545 · Destroyed
- [NTSB NYC72AN074](https://openairdocs.org/ntsb/NYC72AN074.md): Cessna 206 · Raleigh, NC · Accident · 2 fatal · Closed · Dec 4, 1971 · N2110F · 2 aircraft · Destroyed
- [NTSB FTW72FRG38](https://openairdocs.org/ntsb/FTW72FRG38.md): Ted Smith 600 · Victoria, TX · Accident · Serious injuries · Closed · Dec 4, 1971 · N7497S · Destroyed
- [NTSB MKC72FER29](https://openairdocs.org/ntsb/MKC72FER29.md): Cessna 182M · Belview, MN · Accident · Minor injuries · Closed · Dec 1, 1971 · N91834 · Substantial damage
- [NTSB NYC72FID17](https://openairdocs.org/ntsb/NYC72FID17.md): Beech H18 · Charlottsville, VA · Accident · Minor injuries · Closed · Nov 29, 1971 · N717Z · Destroyed
- [NTSB NYC72FLJ18](https://openairdocs.org/ntsb/NYC72FLJ18.md): Piper PA-28 · Angier, NC · Accident · 1 fatal · Closed · Nov 28, 1971 · N7854N · Substantial damage
- [NTSB OAK72DVD30](https://openairdocs.org/ntsb/OAK72DVD30.md): Cessna 337 · Hayward, CA · Accident · No injuries · Closed · Nov 26, 1971 · N6214F · Destroyed
- [NTSB CHI72FEA23](https://openairdocs.org/ntsb/CHI72FEA23.md): Cessna 150 · Pittsboro, IN · Accident · Minor injuries · Closed · Nov 26, 1971 · N5988G · Substantial damage
- [NTSB NYC72FHD23](https://openairdocs.org/ntsb/NYC72FHD23.md): Cessna 177 · Sewell, NJ · Accident · No injuries · Closed · Nov 25, 1971 · N3258T · Substantial damage
- [NTSB MKC72FTK11](https://openairdocs.org/ntsb/MKC72FTK11.md): Beech S35 · Pierre, SD · Accident · Serious injuries · Closed · Nov 25, 1971 · N198Q · Substantial damage
- [NTSB MKC72FCA17](https://openairdocs.org/ntsb/MKC72FCA17.md): Cessna 172K · Fenton, MO · Accident · No injuries · Closed · Nov 25, 1971 · N7041G · Substantial damage
- [NTSB MKC72AK030](https://openairdocs.org/ntsb/MKC72AK030.md): Beech E35 · Garden City, KS · Accident · 4 fatal · Closed · Nov 24, 1971 · N3202C · Destroyed
- [NTSB LAX72AL039](https://openairdocs.org/ntsb/LAX72AL039.md): Cessna 182A · Big Bear, CA · Accident · 1 fatal · Closed · Nov 24, 1971 · N3715D · Destroyed
- [NTSB FTW72DRA29](https://openairdocs.org/ntsb/FTW72DRA29.md): Cessna 182 · Kountze, TX · Accident · No injuries · Closed · Nov 24, 1971 · N71038 · Substantial damage

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

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

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