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

## Cases, newest first

- [NTSB NYC72FHM17](https://openairdocs.org/ntsb/NYC72FHM17.md): Piper PA-28 · Belmar, NJ · Accident · No injuries · Closed · Nov 23, 1971 · N2171T · Substantial damage
- [NTSB CHI72FEK09](https://openairdocs.org/ntsb/CHI72FEK09.md): Cessna 150F · Zanesville, OH · Accident · No injuries · Closed · Nov 23, 1971 · N6561F · Substantial damage
- [NTSB OAK72FVW19](https://openairdocs.org/ntsb/OAK72FVW19.md): Aero Comdr 100 · Mercury, NV · Accident · No injuries · Closed · Nov 22, 1971 · N3697X · Substantial damage
- [NTSB MKC72FCG34](https://openairdocs.org/ntsb/MKC72FCG34.md): Piper PA-22 · Lansing, KS · Accident · 1 fatal · Closed · Nov 22, 1971 · N1792P · Substantial damage
- [NTSB NYC72FHA26](https://openairdocs.org/ntsb/NYC72FHA26.md): Schweizer SGS126 · Kutztown, PA · Accident · No injuries · Closed · Nov 21, 1971 · N1136S · Substantial damage
- [NTSB MIA72DKG48](https://openairdocs.org/ntsb/MIA72DKG48.md): Schweizer 2-33A · Sylvania, GA · Accident · No injuries · Closed · Nov 21, 1971 · N7537 · Substantial damage
- [NTSB LAX72FUA24](https://openairdocs.org/ntsb/LAX72FUA24.md): Cessna 150H · Hntngtn Bch, CA · Accident · No injuries · Closed · Nov 20, 1971 · N50441 · Substantial damage
- [NTSB FTW72AF028](https://openairdocs.org/ntsb/FTW72AF028.md): Cessna 150K · Plano, TX · Accident · 1 fatal · Closed · Nov 20, 1971 · N1031M · Destroyed
- [NTSB MIA72AM046](https://openairdocs.org/ntsb/MIA72AM046.md): Cessna 150K · Opa Locka, FL · Accident · No injuries · Closed · Nov 18, 1971 · N5922G · 2 aircraft · Substantial damage
- [NTSB MIA72AM043](https://openairdocs.org/ntsb/MIA72AM043.md): Ted Smith 600 · Hilton Head Is, SC · Accident · No injuries · Closed · Nov 14, 1971 · N7414S · Substantial damage
- [NTSB ANC72FAG75](https://openairdocs.org/ntsb/ANC72FAG75.md): Cessna 207 · Anchorage, AK · Accident · No injuries · Closed · Nov 14, 1971 · N1590U · Destroyed
- [NTSB NYC72FLJ16](https://openairdocs.org/ntsb/NYC72FLJ16.md): Cessna 150L · Macon, NC · Accident · No injuries · Closed · Nov 13, 1971 · N6559G · Substantial damage
- [NTSB LAX72FUG33](https://openairdocs.org/ntsb/LAX72FUG33.md): Cessna 182M · Mentone, CA · Accident · Serious injuries · Closed · Nov 13, 1971 · N71169 · Destroyed
- [NTSB CHI72AC044](https://openairdocs.org/ntsb/CHI72AC044.md): Aero Comdr 200-D · Louisville, KY · Accident · No injuries · Closed · Nov 11, 1971 · N2913T · Substantial damage
- [NTSB CHI72AC043](https://openairdocs.org/ntsb/CHI72AC043.md): Piper PA-24 · Ypsilanti, MI · Accident · 1 fatal · Closed · Nov 10, 1971 · N6861P · Destroyed
- [NTSB SEA72DYA20](https://openairdocs.org/ntsb/SEA72DYA20.md): Cessna 175 · Rexburg, ID · Accident · No injuries · Closed · Nov 8, 1971 · N7328M · Substantial damage
- [NTSB OAK72FVW17](https://openairdocs.org/ntsb/OAK72FVW17.md): Republic RC-3 · Las Vegas, NV · Accident · Minor injuries · Closed · Nov 8, 1971 · N87545 · Destroyed
- [NTSB CHI72DEE39](https://openairdocs.org/ntsb/CHI72DEE39.md): Piper PA-23 · Streator, IL · Accident · No injuries · Closed · Nov 2, 1971 · N5511Y · Substantial damage
- [NTSB LAX72DUQ39](https://openairdocs.org/ntsb/LAX72DUQ39.md): Bellanca 14-13 · Saugus, CA · Accident · Minor injuries · Closed · Oct 30, 1971 · N74421 · Substantial damage
- [NTSB ANC72FAA18](https://openairdocs.org/ntsb/ANC72FAA18.md): Champion 7GCBC · Fairbanks, AK · Accident · Serious injuries · Closed · Oct 30, 1971 · N9621S · Substantial damage
- [NTSB FTW72AF025](https://openairdocs.org/ntsb/FTW72AF025.md): Piper PA-28 · Tomball, TX · Accident · 3 fatal · Closed · Oct 29, 1971 · N1788J · 2 aircraft · Destroyed
- [NTSB CHI72FEM38](https://openairdocs.org/ntsb/CHI72FEM38.md): Dehavilland DH.115 · Kalamazoo, MI · Accident · No injuries · Closed · Oct 29, 1971 · N11925 · Substantial damage
- [NTSB FTW72FPD19](https://openairdocs.org/ntsb/FTW72FPD19.md): Cessna 140 · Denton, TX · Accident · No injuries · Closed · Oct 27, 1971 · N72623 · Substantial damage
- [NTSB FTW72AF023](https://openairdocs.org/ntsb/FTW72AF023.md): Piper PA-28R · La Porte, TX · Accident · Minor injuries · Closed · Oct 26, 1971 · N5015S · Substantial damage
- [NTSB MKC72DCG30](https://openairdocs.org/ntsb/MKC72DCG30.md): N. American SNJ-5 · Grain Valley, MO · Accident · No injuries · Closed · Oct 25, 1971 · N21JD · Substantial damage
- [NTSB OAK72FVD23](https://openairdocs.org/ntsb/OAK72FVD23.md): Cessna 182 · Sonoma, CA · Accident · Minor injuries · Closed · Oct 24, 1971 · N5329B · Substantial damage
- [NTSB NYC72FFA23](https://openairdocs.org/ntsb/NYC72FFA23.md): Piper PA-28 · Lake Placid, NY · Accident · Minor injuries · Closed · Oct 24, 1971 · N4269J · Substantial damage
- [NTSB NYC72AN059](https://openairdocs.org/ntsb/NYC72AN059.md): Beech B99 · Bath, PA · Accident · 4 fatal · Closed · Oct 24, 1971 · N986MA · Destroyed
- [NTSB LAX72FUG28](https://openairdocs.org/ntsb/LAX72FUG28.md): Cessna 180 · Perris, CA · Accident · No injuries · Closed · Oct 24, 1971 · N2977C · Substantial damage
- [NTSB LAX72FUA20](https://openairdocs.org/ntsb/LAX72FUA20.md): Piper PA-28 · Avalon, CA · Accident · Serious injuries · Closed · Oct 24, 1971 · N7268F · Destroyed
- [NTSB LAX72FUQ36](https://openairdocs.org/ntsb/LAX72FUQ36.md): Republic P-47G · Oxnard, CA · Accident · No injuries · Closed · Oct 23, 1971 · N33956 · Substantial damage
- [NTSB DCA72AZ004](https://openairdocs.org/ntsb/DCA72AZ004.md): Beech E18S · Peoria, IL · Accident · 16 fatal · Closed · Oct 21, 1971 · N51CS · Destroyed
- [NTSB NYC72FNC12](https://openairdocs.org/ntsb/NYC72FNC12.md): Taylorcraft BC12-D · Frye, ME · Accident · No injuries · Closed · Oct 20, 1971 · N23648 · Substantial damage
- [NTSB NYC72FFA22](https://openairdocs.org/ntsb/NYC72FFA22.md): Cessna 150H · Frankfort, NY · Accident · Minor injuries · Closed · Oct 20, 1971 · N7072S · Substantial damage
- [NTSB DEN72FTE34](https://openairdocs.org/ntsb/DEN72FTE34.md): Cessna 150 · Aurora, CO · Accident · No injuries · Closed · Oct 20, 1971 · N3731J · Substantial damage
- [NTSB CHI72FEE41](https://openairdocs.org/ntsb/CHI72FEE41.md): Cessna 150 · Seneca, IL · Accident · No injuries · Closed · Oct 20, 1971 · N5696G · Substantial damage
- [NTSB NYC72FNC14](https://openairdocs.org/ntsb/NYC72FNC14.md): Piper PA-28 · Manchester, VT · Accident · Serious injuries · Closed · Oct 17, 1971 · N6042W · Destroyed
- [NTSB MKC72FCD39](https://openairdocs.org/ntsb/MKC72FCD39.md): Aeronca 0-58B · Des Moines, IA · Accident · No injuries · Closed · Oct 17, 1971 · N48295 · Substantial damage
- [NTSB NYC72AN053](https://openairdocs.org/ntsb/NYC72AN053.md): Swearingen SA26AT · Hot Springs, VA · Accident · 6 fatal · Closed · Oct 16, 1971 · N20DE · Destroyed
- [NTSB MIA72DKG47](https://openairdocs.org/ntsb/MIA72DKG47.md): Globe GC-1B · Albany, GA · Accident · No injuries · Closed · Oct 16, 1971 · N2414B · Substantial damage
- [NTSB NYC72FNE14](https://openairdocs.org/ntsb/NYC72FNE14.md): Cessna 172H · Agawam, MA · Accident · Serious injuries · Closed · Oct 14, 1971 · N2463L · Destroyed
- [NTSB LAX72FUG27](https://openairdocs.org/ntsb/LAX72FUG27.md): Cessna 172 · Chino, CA · Accident · Serious injuries · Closed · Oct 14, 1971 · N7621X · Substantial damage
- [NTSB LAX72DUJ51](https://openairdocs.org/ntsb/LAX72DUJ51.md): Cessna 150 · Scottsdale, AZ · Accident · Minor injuries · Closed · Oct 13, 1971 · N6390G · Destroyed
- [NTSB MKC72DCJ33](https://openairdocs.org/ntsb/MKC72DCJ33.md): Beech A23-24 · Oneill, NE · Accident · No injuries · Closed · Oct 12, 1971 · N2324W · Substantial damage
- [NTSB SEA72DYG16](https://openairdocs.org/ntsb/SEA72DYG16.md): Piper PA-22 · Bovill, ID · Accident · No injuries · Closed · Oct 11, 1971 · N3744P · Substantial damage
- [NTSB FTW72AF020](https://openairdocs.org/ntsb/FTW72AF020.md): Piper PA-28 · San Antonio, TX · Accident · 4 fatal · Closed · Oct 11, 1971 · N5680U · Destroyed
- [NTSB MKC72FCD34](https://openairdocs.org/ntsb/MKC72FCD34.md): Cessna 150E · Spirit Lake, IA · Accident · Minor injuries · Closed · Oct 10, 1971 · N3967U · Destroyed
- [NTSB LAX72FUG22](https://openairdocs.org/ntsb/LAX72FUG22.md): Laister LK-10A · Elsinore, CA · Accident · Minor injuries · Closed · Oct 10, 1971 · N53625 · Substantial damage
- [NTSB FTW72FRA11](https://openairdocs.org/ntsb/FTW72FRA11.md): Piper PA-24 · Lagrange, TX · Accident · Serious injuries · Closed · Oct 10, 1971 · N5400P · Substantial damage
- [NTSB SEA72IS014](https://openairdocs.org/ntsb/SEA72IS014.md): Boeing 747 · Seattle, WA · Incident · No injuries · Closed · Oct 9, 1971 · N601US · Minor damage

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

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

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