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

## Cases, newest first

- [NTSB IAD75AI029](https://openairdocs.org/ntsb/IAD75AI029.md): Piper PA-28 · Morgantown, WV · Accident · 3 fatal · Closed · Nov 9, 1974 · N6545J · Destroyed
- [NTSB MIA75DKT26](https://openairdocs.org/ntsb/MIA75DKT26.md): Cessna 188 · Indiantown, FL · Accident · No injuries · Closed · Nov 8, 1974 · N5751G · Substantial damage
- [NTSB IAD75AI028](https://openairdocs.org/ntsb/IAD75AI028.md): Cessna 172K · Charlotte, NC · Accident · 1 fatal · Closed · Nov 7, 1974 · N84718 · Destroyed
- [NTSB MIA75FKT23](https://openairdocs.org/ntsb/MIA75FKT23.md): Cessna 150L · Pompano Beach, FL · Accident · No injuries · Closed · Nov 5, 1974 · N19330 · Destroyed
- [NTSB FTW75FPD15](https://openairdocs.org/ntsb/FTW75FPD15.md): Cessna 150 · Burleson, TX · Accident · Minor injuries · Closed · Nov 5, 1974 · N60281 · Substantial damage
- [NTSB FTW75AF031](https://openairdocs.org/ntsb/FTW75AF031.md): Piper PA-22 · Shallowater, TX · Accident · 4 fatal · Closed · Nov 3, 1974 · N1941P · Destroyed
- [NTSB NYC75DHA21](https://openairdocs.org/ntsb/NYC75DHA21.md): Cessna 150 · Readington, NJ · Accident · No injuries · Closed · Nov 2, 1974 · N5459Q · Substantial damage
- [NTSB IAD75FKM13](https://openairdocs.org/ntsb/IAD75FKM13.md): Cessna 172M · Statesville, NC · Accident · Serious injuries · Closed · Nov 2, 1974 · N1635V · Destroyed
- [NTSB FTW75AF030](https://openairdocs.org/ntsb/FTW75AF030.md): Cessna 210 · Grand Prairie, TX · Accident · No injuries · Closed · Nov 2, 1974 · N7352E · 2 aircraft · Substantial damage
- [NTSB SEA75AS021](https://openairdocs.org/ntsb/SEA75AS021.md): Cessna 182E · Boise, ID · Accident · 2 fatal · Closed · Nov 1, 1974 · N3155Y · Destroyed
- [NTSB CHI75FET10](https://openairdocs.org/ntsb/CHI75FET10.md): Piper PA-23 · Hobart, IN · Accident · No injuries · Closed · Oct 31, 1974 · N142X · Substantial damage
- [NTSB CHI75DEM18](https://openairdocs.org/ntsb/CHI75DEM18.md): Cessna 120 · Burlington, MI · Accident · No injuries · Closed · Oct 31, 1974 · N2339N · Substantial damage
- [NTSB NYC75FHJ18](https://openairdocs.org/ntsb/NYC75FHJ18.md): Beech V35 · White Plains, NY · Accident · Minor injuries · Closed · Oct 30, 1974 · N3728Q · Destroyed
- [NTSB CHI75FEV09](https://openairdocs.org/ntsb/CHI75FEV09.md): Luscombe 8A · Palmyra, IL · Accident · No injuries · Closed · Oct 30, 1974 · N25127 · Substantial damage
- [NTSB MKC75DCJ36](https://openairdocs.org/ntsb/MKC75DCJ36.md): Cessna 180 · Whitman, NE · Accident · No injuries · Closed · Oct 28, 1974 · N9370C · Substantial damage
- [NTSB MIA75DKJ30](https://openairdocs.org/ntsb/MIA75DKJ30.md): Cessna 305A · Vincent, AL · Accident · Serious injuries · Closed · Oct 28, 1974 · N5187G · Substantial damage
- [NTSB CHI75FEP31](https://openairdocs.org/ntsb/CHI75FEP31.md): Cessna 182P · Racine, WI · Accident · Serious injuries · Closed · Oct 28, 1974 · N21534 · Substantial damage
- [NTSB CHI75DEC21](https://openairdocs.org/ntsb/CHI75DEC21.md): Piper PA-30 · Port Huron, MI · Accident · No injuries · Closed · Oct 28, 1974 · CF-VLE · Substantial damage
- [NTSB MKC75DER27](https://openairdocs.org/ntsb/MKC75DER27.md): Amer Avco AA1-B · Northome, MN · Accident · No injuries · Closed · Oct 27, 1974 · N9606L · Substantial damage
- [NTSB MIA75AM024](https://openairdocs.org/ntsb/MIA75AM024-142927.md): Cessna 172K · Haleyville, AL · Accident · 4 fatal · Closed · Oct 27, 1974 · N7046G · Destroyed
- [NTSB DEN75AD021](https://openairdocs.org/ntsb/DEN75AD021.md): Cessna 182 · Burlington, CO · Accident · 1 fatal · Closed · Oct 27, 1974 · N2894Y · Substantial damage
- [NTSB CHI75FEV08](https://openairdocs.org/ntsb/CHI75FEV08.md): Jeanie TWO · Monticello, IL · Accident · 1 fatal · Closed · Oct 27, 1974 · N109 · Destroyed
- [NTSB NYC75DFA17](https://openairdocs.org/ntsb/NYC75DFA17.md): Piper PA-28 · Johnstown, NY · Accident · Minor injuries · Closed · Oct 26, 1974 · N3891K · Substantial damage
- [NTSB DEN75DTE32](https://openairdocs.org/ntsb/DEN75DTE32.md): Cessna 150 · Greeley, CO · Accident · No injuries · Closed · Oct 26, 1974 · N5349Q · Destroyed
- [NTSB FTW75DRG33](https://openairdocs.org/ntsb/FTW75DRG33.md): Erco 415-C · Weslaco, TX · Accident · Minor injuries · Closed · Oct 24, 1974 · N87382 · Substantial damage
- [NTSB FTW75AF029](https://openairdocs.org/ntsb/FTW75AF029.md): Piper PA-31 · Blair, OK · Accident · 2 fatal · Closed · Oct 24, 1974 · N979L · Destroyed
- [NTSB CHI75FEI23](https://openairdocs.org/ntsb/CHI75FEI23.md): Piper PA-23 · Oberlin, OH · Accident · No injuries · Closed · Oct 24, 1974 · N6308Y · Destroyed
- [NTSB IAD75FIG07](https://openairdocs.org/ntsb/IAD75FIG07.md): Piper PA-18 · Emmitsburg, MD · Accident · Minor injuries · Closed · Oct 23, 1974 · N10468 · Substantial damage
- [NTSB OAK75FVW09](https://openairdocs.org/ntsb/OAK75FVW09.md): Piper PA-32 · Bishop, CA · Accident · Minor injuries · Closed · Oct 22, 1974 · N4062R · Destroyed
- [NTSB CHI75FEA12](https://openairdocs.org/ntsb/CHI75FEA12.md): Piper PA-28 · Indianapolis, IN · Accident · No injuries · Closed · Oct 22, 1974 · N4552T · Substantial damage
- [NTSB MIA75FKG40](https://openairdocs.org/ntsb/MIA75FKG40.md): Luscombe 8E · Brooks, GA · Accident · Serious injuries · Closed · Oct 20, 1974 · N1181K · Destroyed
- [NTSB FTW75FRG29](https://openairdocs.org/ntsb/FTW75FRG29.md): Cessna 150F · Mathis, TX · Accident · Minor injuries · Closed · Oct 20, 1974 · N8898S · Substantial damage
- [NTSB FTW75FRD13](https://openairdocs.org/ntsb/FTW75FRD13.md): Lockheed P-38L · Lafayette, LA · Accident · 1 fatal · Closed · Oct 19, 1974 · N38LL · Destroyed
- [NTSB NYC74AN050](https://openairdocs.org/ntsb/NYC74AN050-140914.md): Piper PA-28 · Montgomeryvl, PA · Accident · 1 fatal · Closed · Oct 18, 1974 · N4825L · Destroyed
- [NTSB LAX75FUJ40](https://openairdocs.org/ntsb/LAX75FUJ40.md): Cessna 170B · Casa Grande, AZ · Accident · No injuries · Closed · Oct 16, 1974 · N4509C · Substantial damage
- [NTSB MKC75FCD19](https://openairdocs.org/ntsb/MKC75FCD19.md): Cessna 150 · Runnells, IA · Accident · Minor injuries · Closed · Oct 15, 1974 · N1126Y · Substantial damage
- [NTSB FTW75FPA11](https://openairdocs.org/ntsb/FTW75FPA11.md): Piper PA-28 · Plano, TX · Accident · No injuries · Closed · Oct 15, 1974 · N41761 · Substantial damage
- [NTSB FTW75FRG25](https://openairdocs.org/ntsb/FTW75FRG25.md): Cessna 177B · Kingsville, TX · Accident · No injuries · Closed · Oct 14, 1974 · N34547 · Substantial damage
- [NTSB OAK75DVD20](https://openairdocs.org/ntsb/OAK75DVD20.md): Schweizer SGS232 · Fremont, CA · Accident · No injuries · Closed · Oct 13, 1974 · N9845E · Substantial damage
- [NTSB LAX75DUG15](https://openairdocs.org/ntsb/LAX75DUG15.md): Bellanca 8GCBC · Adelanto, CA · Accident · No injuries · Closed · Oct 13, 1974 · N86917 · Substantial damage
- [NTSB NYC75DFJ14](https://openairdocs.org/ntsb/NYC75DFJ14.md): Cessna 150 · Kirkwood, NY · Accident · No injuries · Closed · Oct 11, 1974 · N17084 · Substantial damage
- [NTSB MIA75FKG15](https://openairdocs.org/ntsb/MIA75FKG15-201227.md): Cessna 305A · Summerville, SC · Accident · No injuries · Closed · Oct 11, 1974 · N12755 · Substantial damage
- [NTSB DEN75AD020](https://openairdocs.org/ntsb/DEN75AD020.md): Piper PA-28 · Aurora, CO · Accident · 2 fatal · Closed · Oct 11, 1974 · N3994R · Destroyed
- [NTSB NYC75AN045](https://openairdocs.org/ntsb/NYC75AN045.md): Cessna 195 · Albion, NJ · Accident · 1 fatal · Closed · Oct 10, 1974 · N3461V · Destroyed
- [NTSB CHI75AC031](https://openairdocs.org/ntsb/CHI75AC031.md): Beech B55 · Tremont, OH · Accident · No injuries · Closed · Oct 10, 1974 · N8668M · Substantial damage
- [NTSB MIA75DKG35](https://openairdocs.org/ntsb/MIA75DKG35.md): Piper PA-18 · Brooklet, GA · Accident · Minor injuries · Closed · Oct 9, 1974 · N5777D · Destroyed
- [NTSB CHI75FEC17](https://openairdocs.org/ntsb/CHI75FEC17.md): Luscombe 8A · Napoleon, MI · Accident · No injuries · Closed · Oct 9, 1974 · N72011 · Substantial damage
- [NTSB NYC75FHD25](https://openairdocs.org/ntsb/NYC75FHD25.md): Cessna 170 · Marlton, NJ · Accident · Minor injuries · Closed · Oct 5, 1974 · N3860V · Destroyed
- [NTSB NYC75DFA12](https://openairdocs.org/ntsb/NYC75DFA12.md): Beech B24R · Wallkill, NY · Accident · No injuries · Closed · Oct 5, 1974 · N2HK · Substantial damage
- [NTSB NYC75DFA11](https://openairdocs.org/ntsb/NYC75DFA11.md): Stinson 108 · Andes, NY · Accident · Minor injuries · Closed · Oct 5, 1974 · N97370 · Substantial damage

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

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

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