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

## Cases, newest first

- [NTSB MKC73DCQ07](https://openairdocs.org/ntsb/MKC73DCQ07.md): Piper J4A · Beaumont, KS · Accident · No injuries · Closed · Jul 29, 1972 · N27078 · Substantial damage
- [NTSB UNK72X0112](https://openairdocs.org/ntsb/UNK72X0112.md): Cessna 170 · Iron Crk, Canada · Accident · 3 fatal · Closed · Jul 27, 1972 · N4059V · Destroyed
- [NTSB SEA73DYG06](https://openairdocs.org/ntsb/SEA73DYG06.md): Convair PB4Y-2 · Wenatchee, WA · Accident · No injuries · Closed · Jul 27, 1972 · N6816D · Destroyed
- [NTSB NYC73FNC15](https://openairdocs.org/ntsb/NYC73FNC15.md): Piper PA-30 · Manchester, NH · Accident · No injuries · Closed · Jul 27, 1972 · N7846Y · Substantial damage
- [NTSB FTW73IF005](https://openairdocs.org/ntsb/FTW73IF005.md): Boeing 727 · New Orleans, LA · Incident · No injuries · Closed · Jul 26, 1972 · N4735 · Minor damage
- [NTSB OAK73FVG05](https://openairdocs.org/ntsb/OAK73FVG05.md): Luscombe 8A · Oroville, CA · Accident · Minor injuries · Closed · Jul 25, 1972 · N28498 · Substantial damage
- [NTSB NYC73DKM01](https://openairdocs.org/ntsb/NYC73DKM01.md): Piper PA-28 · Lenoir, NC · Accident · No injuries · Closed · Jul 25, 1972 · N9538J · Substantial damage
- [NTSB CHI73DET03](https://openairdocs.org/ntsb/CHI73DET03.md): Beech 23 · Crown Point, IN · Accident · No injuries · Closed · Jul 25, 1972 · N2324L · Substantial damage
- [NTSB ANC73AA008](https://openairdocs.org/ntsb/ANC73AA008.md): Dehavilland DHC-2 · Juneau, AK · Accident · No injuries · Closed · Jul 24, 1972 · N4747S · Substantial damage
- [NTSB MIA73FLA08](https://openairdocs.org/ntsb/MIA73FLA08.md): Cessna 150L · Jacksonville, FL · Accident · No injuries · Closed · Jul 23, 1972 · N1750Q · Substantial damage
- [NTSB FTW73AF004](https://openairdocs.org/ntsb/FTW73AF004.md): Dehavilland DH82A · Jenks, OK · Accident · 1 fatal · Closed · Jul 23, 1972 · N3549 · Destroyed
- [NTSB OAK73FVA10](https://openairdocs.org/ntsb/OAK73FVA10.md): Cessna 150G · Fresno, CA · Accident · Serious injuries · Closed · Jul 22, 1972 · N3147J · Substantial damage
- [NTSB MIA73DKG06](https://openairdocs.org/ntsb/MIA73DKG06.md): Cessna 150 · Butler, GA · Accident · No injuries · Closed · Jul 20, 1972 · N8308G · Substantial damage
- [NTSB OAK73DXQ03](https://openairdocs.org/ntsb/OAK73DXQ03.md): Bolkow C · Lee Vining, CA · Accident · No injuries · Closed · Jul 18, 1972 · N11RB · Substantial damage
- [NTSB OAK73DJY06](https://openairdocs.org/ntsb/OAK73DJY06.md): Cessna 172 · Savannakhet, Laos · Accident · 1 fatal · Closed · Jul 18, 1972 · 0067 · 2 aircraft · Destroyed
- [NTSB NYC73DNC13](https://openairdocs.org/ntsb/NYC73DNC13.md): Piper PA-28 · Monticello, ME · Accident · No injuries · Closed · Jul 18, 1972 · N9430J · Substantial damage
- [NTSB LAX73FUG03](https://openairdocs.org/ntsb/LAX73FUG03.md): Piper PA-24 · Hesperia, CA · Accident · Minor injuries · Closed · Jul 18, 1972 · N5941P · Destroyed
- [NTSB NYC73AN011](https://openairdocs.org/ntsb/NYC73AN011.md): Aeronca 7AC · Culpeper, VA · Accident · 2 fatal · Closed · Jul 16, 1972 · N81637 · Destroyed
- [NTSB NYC72DFJ02](https://openairdocs.org/ntsb/NYC72DFJ02.md): Cessna 337C · Buffalo, NY · Accident · No injuries · Closed · Jul 16, 1972 · N2662S · Substantial damage
- [NTSB CHI73FEE08](https://openairdocs.org/ntsb/CHI73FEE08.md): Pitts Spcl SC-1 · Aurora, IL · Accident · No injuries · Closed · Jul 16, 1972 · N87V · Substantial damage
- [NTSB OAK73FVD06](https://openairdocs.org/ntsb/OAK73FVD06.md): Cessna 150 · San Leandro, CA · Accident · Serious injuries · Closed · Jul 15, 1972 · N5577G · Destroyed
- [NTSB NYC73DHA02](https://openairdocs.org/ntsb/NYC73DHA02.md): Schweizer 233A · Erwinna, PA · Accident · No injuries · Closed · Jul 15, 1972 · N1241S · Substantial damage
- [NTSB MKC73AK009](https://openairdocs.org/ntsb/MKC73AK009.md): Cessna 150J · Caldwell, KS · Accident · 1 fatal · Closed · Jul 15, 1972 · N61025 · Destroyed
- [NTSB MIA73FKT05](https://openairdocs.org/ntsb/MIA73FKT05.md): Cessna 182 · Homestead, FL · Accident · Minor injuries · Closed · Jul 15, 1972 · N5868B · Substantial damage
- [NTSB FTW73FRG02](https://openairdocs.org/ntsb/FTW73FRG02.md): Miniplane DSA · San Antonio, TX · Accident · No injuries · Closed · Jul 15, 1972 · N3867 · Substantial damage
- [NTSB OAK73FVD03](https://openairdocs.org/ntsb/OAK73FVD03.md): Stinson 108-2 · Concord, CA · Accident · Minor injuries · Closed · Jul 14, 1972 · N9870K · Substantial damage
- [NTSB NYC73FNE03](https://openairdocs.org/ntsb/NYC73FNE03.md): Cessna 172E · Sterling, MA · Accident · Minor injuries · Closed · Jul 14, 1972 · N3689S · Destroyed
- [NTSB MIA73DLT01](https://openairdocs.org/ntsb/MIA73DLT01.md): Cessna 150 · Milan, TN · Accident · Serious injuries · Closed · Jul 14, 1972 · N2940J · Substantial damage
- [NTSB FTW73DQG05](https://openairdocs.org/ntsb/FTW73DQG05.md): Erco 415-C · Canyon, TX · Accident · Serious injuries · Closed · Jul 13, 1972 · N2108H · Substantial damage
- [NTSB OAK73FVD02](https://openairdocs.org/ntsb/OAK73FVD02.md): Piper PA-28 · Hayward, CA · Accident · Serious injuries · Closed · Jul 12, 1972 · N9707J · Destroyed
- [NTSB NYC73FHA01](https://openairdocs.org/ntsb/NYC73FHA01.md): Champion 7GCAA · Kutztown, PA · Accident · No injuries · Closed · Jul 11, 1972 · N9090L · Substantial damage
- [NTSB ANC73AA005](https://openairdocs.org/ntsb/ANC73AA005.md): Bell 47G3B1 · Fairbanks, AK · Accident · Serious injuries · Closed · Jul 11, 1972 · N8597F · Destroyed
- [NTSB NYC73FLJ02](https://openairdocs.org/ntsb/NYC73FLJ02.md): Cessna 170B · Scotland Neck, NC · Accident · Minor injuries · Closed · Jul 10, 1972 · N8209A · Substantial damage
- [NTSB NYC73AN008](https://openairdocs.org/ntsb/NYC73AN008.md): Beech G35 · Wellsville, NY · Accident · 2 fatal · Closed · Jul 10, 1972 · N4635D · Destroyed
- [NTSB SEA73FYE02](https://openairdocs.org/ntsb/SEA73FYE02.md): Cessna 182 · Bellevue, WA · Accident · Serious injuries · Closed · Jul 9, 1972 · N5452B · Substantial damage
- [NTSB OAK72DVA05](https://openairdocs.org/ntsb/OAK72DVA05-201443.md): Maule M-4 · Lone Pine, CA · Accident · No injuries · Closed · Jul 9, 1972 · N40319 · Substantial damage
- [NTSB MKC73FCQ03](https://openairdocs.org/ntsb/MKC73FCQ03.md): Taylorcraft BC12-D · Minneola, KS · Accident · Serious injuries · Closed · Jul 9, 1972 · N95537 · Destroyed
- [NTSB MKC73DCD01](https://openairdocs.org/ntsb/MKC73DCD01.md): Cessna 172H · Cresco, IA · Accident · No injuries · Closed · Jul 8, 1972 · N1433F · Substantial damage
- [NTSB CHI73FEE04](https://openairdocs.org/ntsb/CHI73FEE04.md): Piper PA-28 · Lansing, IL · Accident · No injuries · Closed · Jul 8, 1972 · N7346J · Substantial damage
- [NTSB NYC73FNA01](https://openairdocs.org/ntsb/NYC73FNA01.md): Cessna 182B · Concord, MA · Accident · No injuries · Closed · Jul 5, 1972 · N2524G · Substantial damage
- [NTSB NYC73DIG02](https://openairdocs.org/ntsb/NYC73DIG02.md): Piper PA-28 · Churchville, MD · Accident · No injuries · Closed · Jul 4, 1972 · N8941J · Substantial damage
- [NTSB FTW73FPA02](https://openairdocs.org/ntsb/FTW73FPA02.md): Schweizer SGS233 · Rockwell, TX · Accident · No injuries · Closed · Jul 4, 1972 · N7769S · Substantial damage
- [NTSB CHI73FEE01](https://openairdocs.org/ntsb/CHI73FEE01.md): Cessna 140 · Harvard, IL · Accident · No injuries · Closed · Jul 4, 1972 · N89325 · Substantial damage
- [NTSB CHI73AC001](https://openairdocs.org/ntsb/CHI73AC001.md): Cessna 421B · Pataskala, OH · Accident · 1 fatal · Closed · Jul 3, 1972 · N5977M · Destroyed
- [NTSB MKC73DTG01](https://openairdocs.org/ntsb/MKC73DTG01.md): Piper PA-18 · Minot, ND · Accident · No injuries · Closed · Jul 2, 1972 · N7585K · Substantial damage
- [NTSB NYC73FLJ01](https://openairdocs.org/ntsb/NYC73FLJ01.md): Woods Windy TOO · Holly Springs, NC · Accident · Serious injuries · Closed · Jul 1, 1972 · N2550 · Substantial damage
- [NTSB NYC73FHJ02](https://openairdocs.org/ntsb/NYC73FHJ02.md): Dehavilland DH82A · Amityville, NY · Accident · Serious injuries · Closed · Jul 1, 1972 · N40DH · Substantial damage
- [NTSB NYC73FHJ01](https://openairdocs.org/ntsb/NYC73FHJ01-166621.md): Cessna 172 · Ronkonkoma, NY · Accident · Minor injuries · Closed · Jul 1, 1972 · N8893B · Destroyed
- [NTSB MIA73FLA01](https://openairdocs.org/ntsb/MIA73FLA01.md): Cessna 175R · Tallahassee, FL · Accident · No injuries · Closed · Jul 1, 1972 · N8082T · Substantial damage
- [NTSB MIA73DKG02](https://openairdocs.org/ntsb/MIA73DKG02.md): Piper J-3 · Kathleen, GA · Accident · Minor injuries · Closed · Jul 1, 1972 · N122JT · Substantial damage

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

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

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