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

## Cases, newest first

- [NTSB FTW71FPD27](https://openairdocs.org/ntsb/FTW71FPD27.md): Stinson SR-9C · Lake Dallas, TX · Accident · Serious injuries · Closed · Nov 22, 1970 · N17195 · Substantial damage
- [NTSB OAK71AP026](https://openairdocs.org/ntsb/OAK71AP026.md): Piper PA-28 · Vacaville, CA · Accident · Minor injuries · Closed · Nov 21, 1970 · N6728J · 2 aircraft · Destroyed
- [NTSB LAX71DUJ45](https://openairdocs.org/ntsb/LAX71DUJ45.md): Piper PA-23 · Tucson, AZ · Accident · No injuries · Closed · Nov 21, 1970 · N3033P · Substantial damage
- [NTSB CHI71FBM10](https://openairdocs.org/ntsb/CHI71FBM10.md): Piper PA-32 · South Bend, IN · Accident · Minor injuries · Closed · Nov 21, 1970 · N4167R · Destroyed
- [NTSB OAK71DVW19](https://openairdocs.org/ntsb/OAK71DVW19.md): Cessna 182 · Las Vegas, NV · Accident · No injuries · Closed · Nov 20, 1970 · N92386 · Substantial damage
- [NTSB MKC71AK027](https://openairdocs.org/ntsb/MKC71AK027.md): Republic F-105D · Wichita, KS · Accident · 2 fatal · Closed · Nov 20, 1970 · AF610166 · 2 aircraft · Minor damage
- [NTSB NYC71AN062](https://openairdocs.org/ntsb/NYC71AN062.md): Piper PA-23 · Poestenkill, NY · Accident · 1 fatal · Closed · Nov 19, 1970 · N6879Y · Destroyed
- [NTSB DEN71DQD14](https://openairdocs.org/ntsb/DEN71DQD14.md): Cessna 150E · Las Cruces, NM · Accident · No injuries · Closed · Nov 19, 1970 · N6175T · Substantial damage
- [NTSB LAX71FUA35](https://openairdocs.org/ntsb/LAX71FUA35.md): Cessna 182 · Tijuana, Mexico · Accident · Serious injuries · Closed · Nov 14, 1970 · N5341B · Substantial damage
- [NTSB IAD71FIG21](https://openairdocs.org/ntsb/IAD71FIG21.md): Cessna 172 · Reistertown, MD · Accident · Minor injuries · Closed · Nov 14, 1970 · N1174F · Substantial damage
- [NTSB FTW71FPD26](https://openairdocs.org/ntsb/FTW71FPD26.md): Piper PA-28 · Denton, TX · Accident · No injuries · Closed · Nov 14, 1970 · N95353 · Substantial damage
- [NTSB DCA71AZ005](https://openairdocs.org/ntsb/DCA71AZ005.md): Douglas DC-9 · Huntington, WV · Accident · 75 fatal · Closed · Nov 14, 1970 · N97S · Destroyed
- [NTSB CHI71A0033](https://openairdocs.org/ntsb/CHI71A0033.md): Aero Comdr 1121 · Lexington, KY · Accident · 2 fatal · Closed · Nov 14, 1970 · N100RC · Destroyed
- [NTSB NYC71FFJ16](https://openairdocs.org/ntsb/NYC71FFJ16.md): Aero Comdr 600S2R · Rochester, NY · Accident · 1 fatal · Closed · Nov 13, 1970 · N8844Q · Destroyed
- [NTSB NYC71AN060](https://openairdocs.org/ntsb/NYC71AN060.md): Beech G18S · Clinton, PA · Accident · Serious injuries · Closed · Nov 12, 1970 · N871MP · Destroyed
- [NTSB NYC71AN059](https://openairdocs.org/ntsb/NYC71AN059.md): Cessna 421 · Bath, PA · Accident · 2 fatal · Closed · Nov 11, 1970 · N3155K · Destroyed
- [NTSB LAX71FUG22](https://openairdocs.org/ntsb/LAX71FUG22.md): Beech V35 · El Monte, CA · Accident · Minor injuries · Closed · Nov 11, 1970 · N2040W · Substantial damage
- [NTSB CHI71AC031](https://openairdocs.org/ntsb/CHI71AC031.md): Dehavilland DHC-6 · Lacrosse, WI · Accident · Serious injuries · Closed · Nov 9, 1970 · N956SM · Destroyed
- [NTSB LAX71IL026](https://openairdocs.org/ntsb/LAX71IL026.md): Boeing B727 · Los Angeles, CA · Incident · No injuries · Closed · Nov 8, 1970 · N973A · Minor damage
- [NTSB LAX71DUQ40](https://openairdocs.org/ntsb/LAX71DUQ40.md): Champion 7GCAA · Lebec, CA · Accident · Minor injuries · Closed · Nov 8, 1970 · N1646G · Substantial damage
- [NTSB CHI71FDJ24](https://openairdocs.org/ntsb/CHI71FDJ24.md): Cessna 195 · Franklin, WI · Accident · Minor injuries · Closed · Nov 8, 1970 · N3878V · Substantial damage
- [NTSB MIA71FKA07](https://openairdocs.org/ntsb/MIA71FKA07.md): Beech 95-C55 · Mayaguez, PR · Accident · Serious injuries · Closed · Nov 7, 1970 · N263Q · Destroyed
- [NTSB LAX71AL025](https://openairdocs.org/ntsb/LAX71AL025.md): Bellanca 14-133 · San Fernando, CA · Accident · 1 fatal · Closed · Nov 7, 1970 · N6513N · Destroyed
- [NTSB FTW71FRA26](https://openairdocs.org/ntsb/FTW71FRA26.md): Cessna 140A · Port Oconner, TX · Accident · No injuries · Closed · Nov 7, 1970 · N9650A · Substantial damage
- [NTSB MKC71DCG31](https://openairdocs.org/ntsb/MKC71DCG31.md): Piper PA-28R · Harrisonville, MO · Accident · No injuries · Closed · Nov 6, 1970 · N3763T · Substantial damage
- [NTSB MKC71FCG30](https://openairdocs.org/ntsb/MKC71FCG30.md): Beech V35A · Kansas City, KS · Accident · Serious injuries · Closed · Nov 5, 1970 · N8325N · Substantial damage
- [NTSB MIA71FKT16](https://openairdocs.org/ntsb/MIA71FKT16.md): Piper PA-18 · Davie, FL · Accident · Minor injuries · Closed · Nov 5, 1970 · N4042Z · Substantial damage
- [NTSB ANC71DAG50](https://openairdocs.org/ntsb/ANC71DAG50.md): Cessna 180 · Pilot Point, AK · Accident · Minor injuries · Closed · Nov 5, 1970 · N7858A · Destroyed
- [NTSB OAK71DVD15](https://openairdocs.org/ntsb/OAK71DVD15.md): Aero Comdr 560-E · Ukiah, CA · Accident · Minor injuries · Closed · Nov 4, 1970 · N70C · Substantial damage
- [NTSB OAK71AP023](https://openairdocs.org/ntsb/OAK71AP023.md): Piper PA-30 · Mcknlyville, CA · Accident · 2 fatal · Closed · Nov 4, 1970 · N7161Y · Destroyed
- [NTSB MIA71OM041](https://openairdocs.org/ntsb/MIA71OM041.md): Piper PA-28 · Enriquilo, DR · Accident · 1 fatal · Closed · Nov 4, 1970 · N7959N · Destroyed
- [NTSB MKC71FDM34](https://openairdocs.org/ntsb/MKC71FDM34.md): Cessna 172L · Minneapolis, MN · Accident · No injuries · Closed · Nov 3, 1970 · N7737G · Substantial damage
- [NTSB OAK71AP022](https://openairdocs.org/ntsb/OAK71AP022.md): Beech C-45H · San Bruno, CA · Accident · Minor injuries · Closed · Nov 2, 1970 · N6654R · Destroyed
- [NTSB SEA71AS024](https://openairdocs.org/ntsb/SEA71AS024.md): Mooney M20C · Seattle, WA · Accident · 4 fatal · Closed · Nov 1, 1970 · CF-DBR · 2 aircraft · Destroyed
- [NTSB NYC71DHM08](https://openairdocs.org/ntsb/NYC71DHM08.md): Cessna 180 · Morganville, NJ · Accident · No injuries · Closed · Nov 1, 1970 · N750N · Substantial damage
- [NTSB LAX71FUQ31](https://openairdocs.org/ntsb/LAX71FUQ31.md): Cessna 150 · Valencia, CA · Accident · Serious injuries · Closed · Nov 1, 1970 · N3035J · Substantial damage
- [NTSB MIA71FLD31](https://openairdocs.org/ntsb/MIA71FLD31.md): Cessna 172 · Seminole, FL · Accident · Serious injuries · Closed · Oct 31, 1970 · N7816T · Substantial damage
- [NTSB IAD71FIG18](https://openairdocs.org/ntsb/IAD71FIG18.md): Piper PA-28R · Martinsburg, WV · Accident · Serious injuries · Closed · Oct 31, 1970 · N3990T · Destroyed
- [NTSB FTW71DQG42](https://openairdocs.org/ntsb/FTW71DQG42.md): Cessna 210 · Midland, TX · Accident · No injuries · Closed · Oct 30, 1970 · N6538X · Substantial damage
- [NTSB NYC71FGM20](https://openairdocs.org/ntsb/NYC71FGM20.md): Piper PA-28 · Jeannette, PA · Accident · No injuries · Closed · Oct 29, 1970 · N3649R · Substantial damage
- [NTSB OAK71AP021](https://openairdocs.org/ntsb/OAK71AP021.md): Piper PA-32 · San Francisco, CA · Accident · No injuries · Closed · Oct 27, 1970 · N4144R · Substantial damage
- [NTSB NYC71DHD29](https://openairdocs.org/ntsb/NYC71DHD29.md): Piper PA-28 · Philadelphia, PA · Accident · Minor injuries · Closed · Oct 27, 1970 · N95474 · Substantial damage
- [NTSB MIA71AM037](https://openairdocs.org/ntsb/MIA71AM037.md): Piper PA-18S · Demopolis, AL · Accident · 1 fatal · Closed · Oct 27, 1970 · N118T · Destroyed
- [NTSB FTW71FRD23](https://openairdocs.org/ntsb/FTW71FRD23.md): Cessna 140 · Westwego, LA · Accident · No injuries · Closed · Oct 26, 1970 · N964J · Substantial damage
- [NTSB OAK71DVG33](https://openairdocs.org/ntsb/OAK71DVG33.md): Piper PA-28 · Vacaville, CA · Accident · No injuries · Closed · Oct 25, 1970 · N5714U · Substantial damage
- [NTSB NYC71FFD17](https://openairdocs.org/ntsb/NYC71FFD17.md): Piper PA-28 · Norwood, MA · Accident · No injuries · Closed · Oct 25, 1970 · N5884U · Substantial damage
- [NTSB NYC71DHA19](https://openairdocs.org/ntsb/NYC71DHA19.md): Piper PA-28 · Buckingham, PA · Accident · Minor injuries · Closed · Oct 25, 1970 · N9646J · Substantial damage
- [NTSB NYC71DFA24](https://openairdocs.org/ntsb/NYC71DFA24.md): Luscombe 8A · Plattsburgh, NY · Accident · No injuries · Closed · Oct 25, 1970 · N77894 · Substantial damage
- [NTSB MKC71FCD30](https://openairdocs.org/ntsb/MKC71FCD30.md): Piper PA-28 · Earlham, IA · Accident · No injuries · Closed · Oct 25, 1970 · N2500U · Substantial damage
- [NTSB MIA71DLA15](https://openairdocs.org/ntsb/MIA71DLA15.md): Luscombe 8A · Gainesville, FL · Accident · No injuries · Closed · Oct 25, 1970 · N71776 · Substantial damage

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

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

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