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

## Cases, newest first

- [NTSB NYC66A0030](https://openairdocs.org/ntsb/NYC66A0030.md): Navion A · St Marys, PA · Accident · 1 fatal · Closed · Sep 2, 1965 · N5115K · Destroyed
- [NTSB MIA66F0260](https://openairdocs.org/ntsb/MIA66F0260.md): Piper PA-30 · Mobile, AL · Accident · No injuries · Closed · Sep 1, 1965 · N7025Y · Substantial damage
- [NTSB CHI66F0302](https://openairdocs.org/ntsb/CHI66F0302.md): Mooney M20C · Owensboro, KY · Accident · No injuries · Closed · Sep 1, 1965 · N6487U · Substantial damage
- [NTSB SEA66F0120](https://openairdocs.org/ntsb/SEA66F0120.md): Piper PA-22 · Beavercreek, OR · Accident · Serious injuries · Closed · Aug 31, 1965 · N4769Z · Destroyed
- [NTSB OAK66D0117](https://openairdocs.org/ntsb/OAK66D0117.md): Cessna 182 · Templeton, CA · Accident · No injuries · Closed · Aug 29, 1965 · N5603B · Substantial damage
- [NTSB MKC66D0256](https://openairdocs.org/ntsb/MKC66D0256.md): Piper PA-28 · Sedalia, MO · Accident · No injuries · Closed · Aug 29, 1965 · N8520W · Substantial damage
- [NTSB CHI66F0314](https://openairdocs.org/ntsb/CHI66F0314.md): Cessna 150 · Northbrook, IL · Accident · No injuries · Closed · Aug 29, 1965 · N4429U · 2 aircraft · Substantial damage
- [NTSB OAK66F0126](https://openairdocs.org/ntsb/OAK66F0126.md): Cessna 150 · Hamilton Afb, CA · Accident · Minor injuries · Closed · Aug 28, 1965 · N5975T · Substantial damage
- [NTSB MKC66F0192](https://openairdocs.org/ntsb/MKC66F0192.md): Cessna 185 · Fairbury, NE · Accident · No injuries · Closed · Aug 27, 1965 · N9852X · Substantial damage
- [NTSB OAK66D0059](https://openairdocs.org/ntsb/OAK66D0059.md): Cessna 140 · Modesto, CA · Accident · No injuries · Closed · Aug 26, 1965 · N72507 · Substantial damage
- [NTSB NYC66F0214](https://openairdocs.org/ntsb/NYC66F0214.md): Navion 4 · Austin, PA · Accident · Minor injuries · Closed · Aug 26, 1965 · N4270K · Destroyed
- [NTSB FTW66D0272](https://openairdocs.org/ntsb/FTW66D0272.md): Cessna 172 · De Quincy, LA · Accident · No injuries · Closed · Aug 26, 1965 · N5621A · Substantial damage
- [NTSB MKC66F0177](https://openairdocs.org/ntsb/MKC66F0177.md): Cessna 180 · Wichita, KS · Accident · No injuries · Closed · Aug 25, 1965 · N2915C · Substantial damage
- [NTSB DEN66A0016](https://openairdocs.org/ntsb/DEN66A0016.md): Bell 47G3B1 · Bountiful, UT · Accident · Minor injuries · Closed · Aug 24, 1965 · N1169W · Substantial damage
- [NTSB DEN66D0090](https://openairdocs.org/ntsb/DEN66D0090.md): Piper PA-30 · Delta, CO · Accident · No injuries · Closed · Aug 23, 1965 · N7049Y · Substantial damage
- [NTSB LAX66A0020](https://openairdocs.org/ntsb/LAX66A0020-201534.md): Schweizer SGS126 · Tehachapi, CA · Accident · No injuries · Closed · Aug 22, 1965 · N2759Z · Minor damage
- [NTSB MKC66D0242](https://openairdocs.org/ntsb/MKC66D0242.md): Piper PA-18A · Fairmont, MN · Accident · No injuries · Closed · Aug 19, 1965 · N9134D · Substantial damage
- [NTSB FTW66I0020](https://openairdocs.org/ntsb/FTW66I0020.md): British AC 1-11 · Corpus Christ, TX · Incident · No injuries · Closed · Aug 19, 1965 · N1544 · No damage
- [NTSB ANC66D0053](https://openairdocs.org/ntsb/ANC66D0053.md): Piper PA-18 · Gulkana, AK · Accident · Minor injuries · Closed · Aug 18, 1965 · N7156Z · Destroyed
- [NTSB CHI66D0411](https://openairdocs.org/ntsb/CHI66D0411.md): Beechcraft F35 · Baraboo, WI · Accident · No injuries · Closed · Aug 16, 1965 · N3844B · Substantial damage
- [NTSB CHI66D0341](https://openairdocs.org/ntsb/CHI66D0341.md): Schweitzer SGS1 · Jefferson, OH · Accident · No injuries · Closed · Aug 16, 1965 · N2756Z · Substantial damage
- [NTSB NYC66A0023](https://openairdocs.org/ntsb/NYC66A0023.md): Piper PA-22 · Greencastle, PA · Accident · 1 fatal · Closed · Aug 15, 1965 · N3834P · Substantial damage
- [NTSB MKC66F0239](https://openairdocs.org/ntsb/MKC66F0239.md): Champion 7GC · Silver Bay, MN · Accident · Minor injuries · Closed · Aug 15, 1965 · N8972R · Substantial damage
- [NTSB FTW66A0018](https://openairdocs.org/ntsb/FTW66A0018.md): Bell 47G4 · Intracostl Cty, LA · Accident · No injuries · Closed · Aug 15, 1965 · N73263 · Substantial damage
- [NTSB CHI66F0171](https://openairdocs.org/ntsb/CHI66F0171.md): Piper PA-28 · Stclairsvlle, OH · Accident · Serious injuries · Closed · Aug 15, 1965 · N6240W · Destroyed
- [NTSB MKC66A0009](https://openairdocs.org/ntsb/MKC66A0009.md): Champion 7ECA · 3n Floodwood, MN · Accident · 1 fatal · Closed · Aug 14, 1965 · N2528F · Destroyed
- [NTSB FTW66D0223](https://openairdocs.org/ntsb/FTW66D0223.md): Piper PA-25 · Parkin, AR · Accident · No injuries · Closed · Aug 14, 1965 · N7264Z · Substantial damage
- [NTSB LAX66F0069](https://openairdocs.org/ntsb/LAX66F0069.md): Cessna 172 · Burbank, CA · Accident · No injuries · Closed · Aug 13, 1965 · N361SR · Substantial damage
- [NTSB LAX66F0060](https://openairdocs.org/ntsb/LAX66F0060.md): Beechcraft A-23 · Pixley, CA · Accident · No injuries · Closed · Aug 13, 1965 · N8897M · Substantial damage
- [NTSB DEN66A0009](https://openairdocs.org/ntsb/DEN66A0009.md): Piper PA-24 · Ruidoso, NM · Accident · 3 fatal · Closed · Aug 13, 1965 · N7960P · Destroyed
- [NTSB CHI66F0181](https://openairdocs.org/ntsb/CHI66F0181.md): Stinson 108-3 · Springfield, IL · Accident · No injuries · Closed · Aug 12, 1965 · N726C · Substantial damage
- [NTSB CHI66D0173](https://openairdocs.org/ntsb/CHI66D0173.md): Piper PA-22 · Troy, MI · Accident · No injuries · Closed · Aug 12, 1965 · N8722D · Substantial damage
- [NTSB NYC66F0183](https://openairdocs.org/ntsb/NYC66F0183.md): Aeronca 11AC · Tewksbury, MA · Accident · No injuries · Closed · Aug 11, 1965 · N3199E · Substantial damage
- [NTSB NYC66F0175](https://openairdocs.org/ntsb/NYC66F0175.md): Beechcraft T-34A · Turner Falls, MA · Accident · No injuries · Closed · Aug 11, 1965 · N8701R · Substantial damage
- [NTSB MKC66F0209](https://openairdocs.org/ntsb/MKC66F0209.md): Beechcraft A23 · Rochester, MN · Accident · No injuries · Closed · Aug 11, 1965 · N8771M · Substantial damage
- [NTSB NYC66A0020](https://openairdocs.org/ntsb/NYC66A0020.md): Brantly B-2B · Cumberland, MD · Accident · Serious injuries · Closed · Aug 9, 1965 · N2263U · Substantial damage
- [NTSB OAK66A0005](https://openairdocs.org/ntsb/OAK66A0005.md): Cessna 150 · Stockton, CA · Accident · 1 fatal · Closed · Aug 8, 1965 · N4351U · Destroyed
- [NTSB NYC66D0162](https://openairdocs.org/ntsb/NYC66D0162.md): Helisoar HP-10 · Kutztown, PA · Accident · Minor injuries · Closed · Aug 8, 1965 · N294B · Substantial damage
- [NTSB DEN66D0079](https://openairdocs.org/ntsb/DEN66D0079.md): Mooney M20C · Pueblo, CO · Accident · Minor injuries · Closed · Aug 8, 1965 · N6259U · Substantial damage
- [NTSB CHI66A0015](https://openairdocs.org/ntsb/CHI66A0015.md): Beech B35 · Boulder Jct, WI · Accident · 4 fatal · Closed · Aug 7, 1965 · N5091C · Destroyed
- [NTSB FTW66F0191](https://openairdocs.org/ntsb/FTW66F0191.md): Cessna 150 · West Helena, AR · Accident · No injuries · Closed · Aug 5, 1965 · N4063U · Substantial damage
- [NTSB CHI66D0136](https://openairdocs.org/ntsb/CHI66D0136.md): Cessna 140 · Plymouth, MI · Accident · Minor injuries · Closed · Aug 5, 1965 · N72873 · Destroyed
- [NTSB MKC66F0150](https://openairdocs.org/ntsb/MKC66F0150.md): Cessna 172 · Aberdeen, SD · Accident · Minor injuries · Closed · Aug 4, 1965 · N3617S · Substantial damage
- [NTSB MKC66F0117](https://openairdocs.org/ntsb/MKC66F0117.md): Cessna 140 · Omaha, NE · Accident · No injuries · Closed · Aug 1, 1965 · N4279N · Substantial damage
- [NTSB CHI66F0127](https://openairdocs.org/ntsb/CHI66F0127.md): Republic RC-3 · Youngstown, OH · Accident · Minor injuries · Closed · Aug 1, 1965 · N6175K · Substantial damage
- [NTSB CHI66D0137](https://openairdocs.org/ntsb/CHI66D0137.md): Schleicher KA7 · Jefferson, OH · Accident · No injuries · Closed · Jul 31, 1965 · N4280C · Substantial damage
- [NTSB NYC66D0130](https://openairdocs.org/ntsb/NYC66D0130.md): Scheibe L-SPAT · Heath, MA · Accident · No injuries · Closed · Jul 30, 1965 · N8752R · Substantial damage
- [NTSB NYC66A0016](https://openairdocs.org/ntsb/NYC66A0016.md): Cessna 172F · Newburg, MD · Accident · 4 fatal · Closed · Jul 29, 1965 · N5469R · Destroyed
- [NTSB DEN66A0013](https://openairdocs.org/ntsb/DEN66A0013.md): Hughes 269A-1 · Mesa, AZ · Accident · No injuries · Closed · Jul 29, 1965 · N8949F · Substantial damage
- [NTSB DEN66F0082](https://openairdocs.org/ntsb/DEN66F0082.md): Piper PA-23 · Las Animas, CO · Accident · No injuries · Closed · Jul 28, 1965 · N5448Y · Substantial damage

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

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

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