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

## Cases, newest first

- [NTSB MIA72DKT15](https://openairdocs.org/ntsb/MIA72DKT15.md): Siai-Marche S.205 · W Palm Beach, FL · Accident · No injuries · Closed · Sep 5, 1971 · N993WA · Substantial damage
- [NTSB LAX72DUJ41](https://openairdocs.org/ntsb/LAX72DUJ41.md): Cessna 310 · Marana, AZ · Accident · Minor injuries · Closed · Sep 5, 1971 · N5262A · Destroyed
- [NTSB FTW72DPD10](https://openairdocs.org/ntsb/FTW72DPD10.md): Cessna 150 · Graford, TX · Accident · No injuries · Closed · Sep 5, 1971 · N3416J · Substantial damage
- [NTSB CHI72FEK03](https://openairdocs.org/ntsb/CHI72FEK03.md): Cessna 180 · Paulding, OH · Accident · No injuries · Closed · Sep 5, 1971 · N1684C · Substantial damage
- [NTSB CHI72AC020](https://openairdocs.org/ntsb/CHI72AC020.md): Stinson 108-3 · Fowlerville, MI · Accident · 1 fatal · Closed · Sep 5, 1971 · N6480M · Destroyed
- [NTSB NYC72FNE10](https://openairdocs.org/ntsb/NYC72FNE10.md): Piper PA-28 · Plainville, CT · Accident · Minor injuries · Closed · Sep 4, 1971 · N1769T · Substantial damage
- [NTSB MKC72DCQ27](https://openairdocs.org/ntsb/MKC72DCQ27.md): Maule M-4 · Newton, KS · Accident · No injuries · Closed · Sep 4, 1971 · N40307 · Substantial damage
- [NTSB MIA72FKQ18](https://openairdocs.org/ntsb/MIA72FKQ18.md): Grumman G-164A · Oakland, MS · Accident · No injuries · Closed · Sep 4, 1971 · N980X · Destroyed
- [NTSB DCA72AZ003](https://openairdocs.org/ntsb/DCA72AZ003.md): Boeing 727 · Juneau, AK · Accident · 111 fatal · Closed · Sep 4, 1971 · N2969G · Destroyed
- [NTSB CHI72FEM19](https://openairdocs.org/ntsb/CHI72FEM19.md): Schweizer 1-26 · Ionia, MI · Accident · Serious injuries · Closed · Sep 4, 1971 · N3809A · Substantial damage
- [NTSB CHI72DEM25](https://openairdocs.org/ntsb/CHI72DEM25.md): Piper J-3 · Fremont, MI · Accident · No injuries · Closed · Sep 4, 1971 · N6840H · Substantial damage
- [NTSB ANC72DAG50](https://openairdocs.org/ntsb/ANC72DAG50.md): Piper J3C-65 · Tyonek, AK · Accident · Minor injuries · Closed · Sep 4, 1971 · N88330 · Substantial damage
- [NTSB NYC72FHM08](https://openairdocs.org/ntsb/NYC72FHM08.md): Bensen B8M · New Shrewsbury, NJ · Accident · Serious injuries · Closed · Sep 3, 1971 · N2765 · Substantial damage
- [NTSB FTW72DPD08](https://openairdocs.org/ntsb/FTW72DPD08.md): Piper PA-22 · Ft.Worth, TX · Accident · No injuries · Closed · Sep 3, 1971 · N5673Z · Substantial damage
- [NTSB CHI72DEM17](https://openairdocs.org/ntsb/CHI72DEM17.md): Cessna 150H · Bruce Crosng, MI · Accident · No injuries · Closed · Sep 3, 1971 · N6501S · Substantial damage
- [NTSB SEA72IS008](https://openairdocs.org/ntsb/SEA72IS008.md): Boeing 747 · Seattle, WA · Incident · No injuries · Closed · Sep 2, 1971 · N606US · Minor damage
- [NTSB DEN72FQA18](https://openairdocs.org/ntsb/DEN72FQA18.md): Cessna 210 · Ruidoso, NM · Accident · Minor injuries · Closed · Sep 2, 1971 · N9649T · Destroyed
- [NTSB ANC72FAG54](https://openairdocs.org/ntsb/ANC72FAG54.md): Cessna 180 · Tyonek, AK · Accident · Serious injuries · Closed · Sep 2, 1971 · N2831A · Substantial damage
- [NTSB DEN72DTE26](https://openairdocs.org/ntsb/DEN72DTE26-163402.md): Cessna 150 · Hillrose, CO · Accident · No injuries · Closed · Aug 31, 1971 · N6859G · Substantial damage
- [NTSB NYC72AN031](https://openairdocs.org/ntsb/NYC72AN031.md): Beech F33A · Andover, NJ · Accident · 2 fatal · Closed · Aug 29, 1971 · N9176Q · Substantial damage
- [NTSB LAX72FUG08](https://openairdocs.org/ntsb/LAX72FUG08.md): Amer Avco AA1 · Rialto, CA · Accident · Minor injuries · Closed · Aug 28, 1971 · N9350L · Substantial damage
- [NTSB FTW72DPM06](https://openairdocs.org/ntsb/FTW72DPM06.md): Cessna 150 · Skiatook, OK · Accident · No injuries · Closed · Aug 28, 1971 · N3474J · Substantial damage
- [NTSB CHI72FEM24](https://openairdocs.org/ntsb/CHI72FEM24.md): Piper J3 · Otsego, MI · Accident · No injuries · Closed · Aug 28, 1971 · N78521 · Substantial damage
- [NTSB SEA72DYC19](https://openairdocs.org/ntsb/SEA72DYC19.md): Piper PA-12 · Kimberley, OR · Accident · No injuries · Closed · Aug 27, 1971 · N3480M · Substantial damage
- [NTSB FTW72FPJ10](https://openairdocs.org/ntsb/FTW72FPJ10.md): Cessna 172H · Bethany, OK · Accident · Minor injuries · Closed · Aug 27, 1971 · N2790L · Substantial damage
- [NTSB SEA72FYI08](https://openairdocs.org/ntsb/SEA72FYI08.md): Cessna 150G · Paisley, OR · Accident · Serious injuries · Closed · Aug 26, 1971 · N3837J · Destroyed
- [NTSB NYC72FKM03](https://openairdocs.org/ntsb/NYC72FKM03-201417.md): Champion 7KCAB · Morganton, NC · Accident · Serious injuries · Closed · Aug 24, 1971 · N1622G · Destroyed
- [NTSB LAX72FUM08](https://openairdocs.org/ntsb/LAX72FUM08.md): Cessna 172K · Salton City, CA · Accident · Serious injuries · Closed · Aug 24, 1971 · N7131G · Destroyed
- [NTSB ANC72AA013](https://openairdocs.org/ntsb/ANC72AA013.md): Piper PA-18 · Kenai, AK · Accident · 2 fatal · Closed · Aug 24, 1971 · N3393B · 2 aircraft · Destroyed
- [NTSB NYC72DHA11](https://openairdocs.org/ntsb/NYC72DHA11.md): Piper PA-28 · Prospectville, PA · Accident · No injuries · Closed · Aug 23, 1971 · N7307J · Substantial damage
- [NTSB MIA72FKT11](https://openairdocs.org/ntsb/MIA72FKT11.md): Piper J3C-65 · Delray Beach, FL · Accident · Serious injuries · Closed · Aug 23, 1971 · N92188 · Destroyed
- [NTSB ANC72AA012](https://openairdocs.org/ntsb/ANC72AA012.md): Cessna 185 · Seldovia, AK · Accident · No injuries · Closed · Aug 23, 1971 · N1667M · Substantial damage
- [NTSB NYC72FNA09](https://openairdocs.org/ntsb/NYC72FNA09.md): Cessna 150K · Mansfield, MA · Accident · Minor injuries · Closed · Aug 22, 1971 · N5792G · Substantial damage
- [NTSB MIA72AM016](https://openairdocs.org/ntsb/MIA72AM016.md): Cessna 210A · Madison, AL · Accident · 3 fatal · Closed · Aug 22, 1971 · N9432X · Destroyed
- [NTSB LAX72FUJ29](https://openairdocs.org/ntsb/LAX72FUJ29.md): Cessna 172 · Stanfield, AZ · Accident · 1 fatal · Closed · Aug 22, 1971 · N8249B · Substantial damage
- [NTSB CHI72FEE18](https://openairdocs.org/ntsb/CHI72FEE18.md): Piper PA-28 · Grayslake, IL · Accident · Minor injuries · Closed · Aug 22, 1971 · N6652W · Substantial damage
- [NTSB SEA72DTI05](https://openairdocs.org/ntsb/SEA72DTI05.md): Dehavilland DH 104 · Chester, MT · Accident · No injuries · Closed · Aug 21, 1971 · N1565V · Substantial damage
- [NTSB NYC72DFA08](https://openairdocs.org/ntsb/NYC72DFA08.md): Bell 47-G · Malone, NY · Accident · No injuries · Closed · Aug 21, 1971 · N932B · Destroyed
- [NTSB MKC72FCG14](https://openairdocs.org/ntsb/MKC72FCG14.md): Cessna 210F · Bolivar, MO · Accident · Serious injuries · Closed · Aug 21, 1971 · N4719F · Destroyed
- [NTSB MIA72FKT09](https://openairdocs.org/ntsb/MIA72FKT09.md): Champion 7FC · Lantana, FL · Accident · Serious injuries · Closed · Aug 21, 1971 · N9865B · Destroyed
- [NTSB ANC72FAG27](https://openairdocs.org/ntsb/ANC72FAG27.md): Piper PA-28 · Soldotna, AK · Accident · Minor injuries · Closed · Aug 21, 1971 · N1827J · Substantial damage
- [NTSB NYC72FID07](https://openairdocs.org/ntsb/NYC72FID07.md): Cessna 150 · Ft Eustis, VA · Accident · No injuries · Closed · Aug 20, 1971 · N6260G · Substantial damage
- [NTSB LAX72FVA16](https://openairdocs.org/ntsb/LAX72FVA16.md): Cessna 177 · Bakersfield, CA · Accident · No injuries · Closed · Aug 20, 1971 · N2878X · Substantial damage
- [NTSB SEA72DYE15](https://openairdocs.org/ntsb/SEA72DYE15.md): Ryan ST-3KR · Olympia, WA · Accident · Minor injuries · Closed · Aug 19, 1971 · N53438 · Substantial damage
- [NTSB SEA72DYE11](https://openairdocs.org/ntsb/SEA72DYE11.md): Cessna 150 · Bellingham, WA · Accident · No injuries · Closed · Aug 18, 1971 · N23313 · Substantial damage
- [NTSB SEA72DYA09](https://openairdocs.org/ntsb/SEA72DYA09.md): Luscombe 8A · Jordan Vally, OR · Accident · No injuries · Closed · Aug 18, 1971 · N72019 · Substantial damage
- [NTSB OAK72FVG18](https://openairdocs.org/ntsb/OAK72FVG18.md): Aeronca 11AC · Sacramento, CA · Accident · Serious injuries · Closed · Aug 18, 1971 · N9285E · Substantial damage
- [NTSB FTW72AF010](https://openairdocs.org/ntsb/FTW72AF010.md): Aero Comdr 100 · Georgetown, TX · Accident · 4 fatal · Closed · Aug 18, 1971 · N3715X · Destroyed
- [NTSB CHI72FET06](https://openairdocs.org/ntsb/CHI72FET06.md): Bell 47G-2 · Laporte, IN · Accident · Minor injuries · Closed · Aug 18, 1971 · N2495B · Destroyed
- [NTSB CHI72FEV13](https://openairdocs.org/ntsb/CHI72FEV13.md): Cessna 150 · Manito, IL · Accident · No injuries · Closed · Aug 16, 1971 · N6510S · Substantial damage

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

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

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