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

## Cases, newest first

- [NTSB NYC82FA006](https://openairdocs.org/ntsb/NYC82FA006.md): Piper PA-28 · Farmingdale, NY · Accident · 3 fatal · Closed · Oct 28, 1981 · N8140H · Destroyed
- [NTSB FTW82FQG04](https://openairdocs.org/ntsb/FTW82FQG04.md): Hughes 269C · Guthrie, TX · Accident · Serious injuries · Closed · Oct 28, 1981 · N7433F · Destroyed
- [NTSB ATL82FKG03](https://openairdocs.org/ntsb/ATL82FKG03.md): Cessna 150F · Columbus, GA · Accident · Minor injuries · Closed · Oct 28, 1981 · N8808G · Destroyed
- [NTSB NYC82FA005](https://openairdocs.org/ntsb/NYC82FA005.md): Beech 36 · Marlborough, NY · Accident · Minor injuries · Closed · Oct 27, 1981 · N7981R · Destroyed
- [NTSB MIA82FA006](https://openairdocs.org/ntsb/MIA82FA006.md): Lockheed 749 · St Thomas, VI · Accident · 3 fatal · Closed · Oct 26, 1981 · HI-328 · Destroyed
- [NTSB FTW82FPJ02](https://openairdocs.org/ntsb/FTW82FPJ02.md): Cessna 150 · Asher, OK · Accident · Serious injuries · Closed · Oct 26, 1981 · N2762S · Destroyed
- [NTSB LAX82FA006](https://openairdocs.org/ntsb/LAX82FA006.md): Cessna 421B · Camarillo, CA · Accident · 1 fatal · Closed · Oct 24, 1981 · N14AC · Destroyed
- [NTSB MIA82FLA01](https://openairdocs.org/ntsb/MIA82FLA01.md): Cassutt III-M · St.Augustine, FL · Accident · Minor injuries · Closed · Oct 23, 1981 · N94KR · Substantial damage
- [NTSB FTW82DQG02](https://openairdocs.org/ntsb/FTW82DQG02.md): Cessna 182J · Muleshoe, TX · Accident · No injuries · Closed · Oct 23, 1981 · N3316F · Substantial damage
- [NTSB LAX82DUJ02](https://openairdocs.org/ntsb/LAX82DUJ02.md): Piper PA-38 · Show Low, AZ · Accident · No injuries · Closed · Oct 22, 1981 · N2425A · Substantial damage
- [NTSB CHI82FEV02](https://openairdocs.org/ntsb/CHI82FEV02.md): Cessna 205 · Danville, IL · Accident · Minor injuries · Closed · Oct 20, 1981 · N202QL · Substantial damage
- [NTSB NYC82FHD02](https://openairdocs.org/ntsb/NYC82FHD02.md): Cessna 150H · Manahawkin, NJ · Accident · Minor injuries · Closed · Oct 19, 1981 · N23402 · Destroyed
- [NTSB SEA82DYK02](https://openairdocs.org/ntsb/SEA82DYK02.md): Piper PA-24 · Gold Beach, OR · Accident · No injuries · Closed · Oct 18, 1981 · N7686P · Substantial damage
- [NTSB FTW82FA012](https://openairdocs.org/ntsb/FTW82FA012.md): Hiller FH1100 · Porte Barre, LA · Accident · 1 fatal · Closed · Oct 18, 1981 · N9054 · Destroyed
- [NTSB SEA82FA001](https://openairdocs.org/ntsb/SEA82FA001.md): Champion 7GCAA · Goldendale, WA · Accident · 1 fatal · Closed · Oct 17, 1981 · N9606S · Destroyed
- [NTSB NYC82FA004](https://openairdocs.org/ntsb/NYC82FA004.md): Piper PA-28 · Danvers, MA · Accident · 2 fatal · Closed · Oct 17, 1981 · N2065M · Destroyed
- [NTSB FTW82FRG04](https://openairdocs.org/ntsb/FTW82FRG04.md): Piper PA-38 · San Benito, TX · Accident · No injuries · Closed · Oct 17, 1981 · N9080Y · Substantial damage
- [NTSB ATL82FIA01](https://openairdocs.org/ntsb/ATL82FIA01.md): Erco 415-D · Churchton, MD · Accident · Minor injuries · Closed · Oct 17, 1981 · N2250H · Substantial damage
- [NTSB SEA82DYA02](https://openairdocs.org/ntsb/SEA82DYA02.md): Luscombe 8F · Howe, ID · Accident · Minor injuries · Closed · Oct 15, 1981 · N9018Y · Substantial damage
- [NTSB NYC81FNA03](https://openairdocs.org/ntsb/NYC81FNA03-122898.md): Piper PA-30 · Norwood, MA · Accident · Minor injuries · Closed · Oct 15, 1981 · N33JL · Destroyed
- [NTSB LAX82DVG05](https://openairdocs.org/ntsb/LAX82DVG05.md): Bellanca 14-19 · Rio Vista, CA · Accident · No injuries · Closed · Oct 15, 1981 · N7615E · Substantial damage
- [NTSB ATL82FLJ01](https://openairdocs.org/ntsb/ATL82FLJ01.md): Cessna 150J · Knightdale, NC · Accident · Minor injuries · Closed · Oct 14, 1981 · N5504G · Substantial damage
- [NTSB FTW82FA008](https://openairdocs.org/ntsb/FTW82FA008.md): Piper PA-28 · Killeen, TX · Accident · 3 fatal · Closed · Oct 12, 1981 · N8351S · Destroyed
- [NTSB NYC82FGT03](https://openairdocs.org/ntsb/NYC82FGT03.md): Cessna 182A · Chambersburg, PA · Accident · No injuries · Closed · Oct 11, 1981 · N4724D · Substantial damage
- [NTSB MIA82FA001](https://openairdocs.org/ntsb/MIA82FA001.md): Beech 58 · Gainesville, FL · Accident · 3 fatal · Closed · Oct 11, 1981 · N4158S · Destroyed
- [NTSB FTW82DRD01](https://openairdocs.org/ntsb/FTW82DRD01.md): Cessna TU206G · Lafayette, LA · Accident · Minor injuries · Closed · Oct 11, 1981 · N5404X · Substantial damage
- [NTSB FTW82FA005](https://openairdocs.org/ntsb/FTW82FA005.md): Cessna 152 · Jayton, TX · Accident · 1 fatal · Closed · Oct 10, 1981 · N48253 · Destroyed
- [NTSB FTW82FQA05](https://openairdocs.org/ntsb/FTW82FQA05.md): Raven S-55A · Corrales, NM · Accident · No injuries · Closed · Oct 9, 1981 · N3251R · Destroyed
- [NTSB FTW82FA004](https://openairdocs.org/ntsb/FTW82FA004.md): Cessna 172P · Flat, TX · Accident · 2 fatal · Closed · Oct 8, 1981 · N52070 · Destroyed
- [NTSB FTW82DA002](https://openairdocs.org/ntsb/FTW82DA002.md): Beech V35A · Dallas, TX · Accident · No injuries · Closed · Oct 7, 1981 · N7173N · Substantial damage
- [NTSB CHI82FET01](https://openairdocs.org/ntsb/CHI82FET01.md): Cessna 150 · Ft Wayne, IN · Accident · No injuries · Closed · Oct 7, 1981 · N7688G · Substantial damage
- [NTSB CHI82FEC01](https://openairdocs.org/ntsb/CHI82FEC01.md): Cessna 177A · Gibralter, MI · Accident · No injuries · Closed · Oct 5, 1981 · N30624 · Substantial damage
- [NTSB CHI82FEE01](https://openairdocs.org/ntsb/CHI82FEE01.md): Piper PA-28 · Wheeling, IL · Accident · Serious injuries · Closed · Oct 4, 1981 · N9303J · Destroyed
- [NTSB FTW82FRG01](https://openairdocs.org/ntsb/FTW82FRG01.md): Cessna T337B · Port Isabel, TX · Accident · No injuries · Closed · Oct 3, 1981 · N670AL · Substantial damage
- [NTSB CHI82DEV01](https://openairdocs.org/ntsb/CHI82DEV01.md): Schweizer SGS126 · Monticello, IL · Accident · Minor injuries · Closed · Oct 3, 1981 · N10390 · Substantial damage
- [NTSB ATL81FKQ02](https://openairdocs.org/ntsb/ATL81FKQ02-123783.md): Bellanca 14-19 · Benoit, MS · Accident · No injuries · Closed · Oct 3, 1981 · N8510R · Substantial damage
- [NTSB MKC82DCG01](https://openairdocs.org/ntsb/MKC82DCG01.md): Cessna 152 · Point Lookout, MO · Accident · No injuries · Closed · Oct 2, 1981 · N49480 · Substantial damage
- [NTSB CHI82FER01](https://openairdocs.org/ntsb/CHI82FER01.md): Volksplane UP-1 · East Bethal, MN · Accident · Minor injuries · Closed · Oct 2, 1981 · N1211H · Substantial damage
- [NTSB CHI82FEP01](https://openairdocs.org/ntsb/CHI82FEP01.md): Cessna 150J · Waukesha, WI · Accident · No injuries · Closed · Oct 1, 1981 · N51046 · Substantial damage
- [NTSB LAX81FA134](https://openairdocs.org/ntsb/LAX81FA134.md): Cessna 414 · Tonopah, NV · Accident · 2 fatal · Closed · Sep 29, 1981 · N5404G · Destroyed
- [NTSB CHI81FEX29](https://openairdocs.org/ntsb/CHI81FEX29.md): Aerospatial AS350D · Lynnville, IN · Accident · No injuries · Closed · Sep 29, 1981 · N200HE · Substantial damage
- [NTSB ATL81DIJ14](https://openairdocs.org/ntsb/ATL81DIJ14.md): Cessna 152 · Smithville, WV · Accident · No injuries · Closed · Sep 29, 1981 · N64833 · Substantial damage
- [NTSB LAX81FUG53](https://openairdocs.org/ntsb/LAX81FUG53.md): Luscombe 8A · Upland, CA · Accident · No injuries · Closed · Sep 27, 1981 · N39023 · Substantial damage
- [NTSB NYC81FHD40](https://openairdocs.org/ntsb/NYC81FHD40.md): Piper PA-38 · Lumberton, NJ · Accident · No injuries · Closed · Sep 26, 1981 · N2513C · Substantial damage
- [NTSB LAX81DUK07](https://openairdocs.org/ntsb/LAX81DUK07.md): Cessna 172 · Wahweap, AZ · Accident · No injuries · Closed · Sep 25, 1981 · N6586J · Substantial damage
- [NTSB CHI81FA104](https://openairdocs.org/ntsb/CHI81FA104-123639.md): Cessna 210 · Mosinee, WI · Accident · 3 fatal · Closed · Sep 25, 1981 · N9582T · Destroyed
- [NTSB CHI81FA104](https://openairdocs.org/ntsb/CHI81FA104-201209.md): Piper PA-32 · Newberry, MI · Accident · 2 fatal · Closed · Sep 25, 1981 · N9574C · Destroyed
- [NTSB DCA81AA028](https://openairdocs.org/ntsb/DCA81AA028.md): Piper PA-34 · E.Rutherford, NJ · Accident · 2 fatal · Closed · Sep 23, 1981 · N8110R · 2 aircraft · Destroyed
- [NTSB MKC81FCD40](https://openairdocs.org/ntsb/MKC81FCD40.md): Aeronca 7AC · Larchwood, IA · Accident · Serious injuries · Closed · Sep 19, 1981 · N2256E · Substantial damage
- [NTSB FTW81FA145](https://openairdocs.org/ntsb/FTW81FA145.md): Piper PA-28R · Dallas, TX · Accident · 2 fatal · Closed · Sep 19, 1981 · N2156H · Destroyed

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

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

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