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

## Cases, newest first

- [NTSB MIA73AM036](https://openairdocs.org/ntsb/MIA73AM036.md): Psota/Smith Mini · Pensacola, FL · Accident · Minor injuries · Closed · Oct 1, 1972 · N1008Z · 2 aircraft · Substantial damage
- [NTSB FTW73FPG26](https://openairdocs.org/ntsb/FTW73FPG26.md): Cessna 172 · N.Little Rock, AR · Accident · Minor injuries · Closed · Oct 1, 1972 · N5473R · Substantial damage
- [NTSB CHI73FEC10](https://openairdocs.org/ntsb/CHI73FEC10.md): Piper PA-22 · Sebewaing, MI · Accident · No injuries · Closed · Sep 30, 1972 · N3338Z · Substantial damage
- [NTSB ANC73DAG45](https://openairdocs.org/ntsb/ANC73DAG45.md): Piper PA-14 · King Salmon, AK · Accident · No injuries · Closed · Sep 30, 1972 · N4295H · Substantial damage
- [NTSB NYC73AN048](https://openairdocs.org/ntsb/NYC73AN048.md): Beech 95-55 · Hamburg, PA · Accident · 5 fatal · Closed · Sep 29, 1972 · N914Q · Destroyed
- [NTSB LAX72FUG18](https://openairdocs.org/ntsb/LAX72FUG18-201459.md): Cessna 140 · Adelanto, CA · Accident · Serious injuries · Closed · Sep 29, 1972 · N72525 · Substantial damage
- [NTSB CHI73FEC09](https://openairdocs.org/ntsb/CHI73FEC09-168541.md): Aero Comdr 100 · Laingsburg, MI · Accident · No injuries · Closed · Sep 28, 1972 · N2951T · Substantial damage
- [NTSB MKC73FCG12](https://openairdocs.org/ntsb/MKC73FCG12.md): Cessna 172E · Ft.Leavenwth, KS · Accident · Minor injuries · Closed · Sep 27, 1972 · N6048 · Substantial damage
- [NTSB MIA73FLT07](https://openairdocs.org/ntsb/MIA73FLT07.md): Cessna 150K · Memphis, TN · Accident · No injuries · Closed · Sep 27, 1972 · N5772G · Substantial damage
- [NTSB MIA73DKJ25](https://openairdocs.org/ntsb/MIA73DKJ25.md): Piper PA-22 · Atmore, AL · Accident · Minor injuries · Closed · Sep 27, 1972 · N1147C · Substantial damage
- [NTSB MIA73AM035](https://openairdocs.org/ntsb/MIA73AM035.md): Bellanca 17-30A · Lake Wales, FL · Accident · 3 fatal · Closed · Sep 27, 1972 · N8800V · Destroyed
- [NTSB OAK73DJY08](https://openairdocs.org/ntsb/OAK73DJY08.md): Bell 204B · Lat Khai, Laos · Accident · Minor injuries · Closed · Sep 26, 1972 · N8513F · Substantial damage
- [NTSB CHI73DEV12](https://openairdocs.org/ntsb/CHI73DEV12.md): Cessna 310G · Fairfield, IL · Accident · No injuries · Closed · Sep 25, 1972 · N8900Z · Substantial damage
- [NTSB NYC73FLJ10](https://openairdocs.org/ntsb/NYC73FLJ10.md): Piper PA-22 · Maple Hill, NC · Accident · No injuries · Closed · Sep 24, 1972 · N3380B · Substantial damage
- [NTSB OAK73FVW08](https://openairdocs.org/ntsb/OAK73FVW08.md): Cessna 182 · Alamo, NV · Accident · Serious injuries · Closed · Sep 23, 1972 · N7281E · Substantial damage
- [NTSB MIA73DLD16](https://openairdocs.org/ntsb/MIA73DLD16.md): Cessna 150 · Elfers, FL · Accident · Minor injuries · Closed · Sep 23, 1972 · N22806 · Substantial damage
- [NTSB NYC73DKM12](https://openairdocs.org/ntsb/NYC73DKM12.md): Piper PA-22 · Reidsville, NC · Accident · No injuries · Closed · Sep 22, 1972 · N5361Z · Substantial damage
- [NTSB DEN73FTE28](https://openairdocs.org/ntsb/DEN73FTE28.md): Beech D35 · Denver, CO · Accident · Serious injuries · Closed · Sep 22, 1972 · N737D · Destroyed
- [NTSB MIA73AM045](https://openairdocs.org/ntsb/MIA73AM045.md): Cessna 177 · Natchez, MS · Accident · 1 fatal · Closed · Sep 20, 1972 · N30245 · Destroyed
- [NTSB DEN73FTM09](https://openairdocs.org/ntsb/DEN73FTM09.md): Cessna 150J · Ogden, UT · Accident · No injuries · Closed · Sep 20, 1972 · N51369 · Substantial damage
- [NTSB CHI73FLQ11](https://openairdocs.org/ntsb/CHI73FLQ11.md): Cessna 177 · Lexington, KY · Accident · Serious injuries · Closed · Sep 20, 1972 · N3357F · Substantial damage
- [NTSB LAX73FUO1O](https://openairdocs.org/ntsb/LAX73FUO1O.md): Cessna 150 · Van Nuys, CA · Accident · No injuries · Closed · Sep 19, 1972 · N17183 · Substantial damage
- [NTSB SEA73DYE16](https://openairdocs.org/ntsb/SEA73DYE16.md): Amer Avco AA1A · Oak Harbor, WA · Accident · No injuries · Closed · Sep 17, 1972 · N6372L · Substantial damage
- [NTSB MIA73DKT16](https://openairdocs.org/ntsb/MIA73DKT16.md): Cessna 150K · Andytown, FL · Accident · No injuries · Closed · Sep 17, 1972 · N5674G · Substantial damage
- [NTSB FTW73DPG20](https://openairdocs.org/ntsb/FTW73DPG20.md): Cessna 120 · Lakeview, AR · Accident · No injuries · Closed · Sep 17, 1972 · N89729 · Substantial damage
- [NTSB NYC73FFJ09](https://openairdocs.org/ntsb/NYC73FFJ09.md): Cessna 150 · Brockport, NY · Accident · No injuries · Closed · Sep 16, 1972 · N60950 · Substantial damage
- [NTSB NYC73FFA17](https://openairdocs.org/ntsb/NYC73FFA17.md): Cessna 140 · Postenkill, NY · Accident · Minor injuries · Closed · Sep 16, 1972 · N2897N · Substantial damage
- [NTSB NYC73FFA16](https://openairdocs.org/ntsb/NYC73FFA16.md): Eclectic 1C · Cairo, NY · Accident · Serious injuries · Closed · Sep 16, 1972 · N9211 · Substantial damage
- [NTSB OAK73DVA21](https://openairdocs.org/ntsb/OAK73DVA21.md): Luscomb 8E · Poplar, CA · Accident · No injuries · Closed · Sep 13, 1972 · N71936 · Substantial damage
- [NTSB MIA73FKQ16](https://openairdocs.org/ntsb/MIA73FKQ16.md): Cessna 172 · Columbus, MS · Accident · Serious injuries · Closed · Sep 13, 1972 · N3934R · Substantial damage
- [NTSB LAX73AL013](https://openairdocs.org/ntsb/LAX73AL013.md): Beech D18S · Santa Maria, CA · Accident · No injuries · Closed · Sep 13, 1972 · N281H · Substantial damage
- [NTSB SEA73FYE14](https://openairdocs.org/ntsb/SEA73FYE14.md): Piper PA-32 · Olympia, WA · Accident · Minor injuries · Closed · Sep 11, 1972 · N4281R · Substantial damage
- [NTSB MIA73RM030](https://openairdocs.org/ntsb/MIA73RM030.md): Piper PA-23 · Georgetown, Burkina Faso · Accident · 5 fatal · Closed · Sep 11, 1972 · N14265 · Destroyed
- [NTSB OAK73DVG18](https://openairdocs.org/ntsb/OAK73DVG18.md): Schweizer 2-33 · Vacaville, CA · Accident · No injuries · Closed · Sep 10, 1972 · N2473W · Substantial damage
- [NTSB CHI73FEI13](https://openairdocs.org/ntsb/CHI73FEI13.md): Cessna 182A · Cleveland, OH · Accident · Minor injuries · Closed · Sep 10, 1972 · N6049B · Destroyed
- [NTSB OAK73FVW07](https://openairdocs.org/ntsb/OAK73FVW07.md): Piper PA-32 · Las Vegas, NV · Accident · No injuries · Closed · Sep 9, 1972 · N2843T · Substantial damage
- [NTSB NYC73FNE08](https://openairdocs.org/ntsb/NYC73FNE08.md): Cessna 150J · Madison, CT · Accident · Serious injuries · Closed · Sep 9, 1972 · N61060 · Destroyed
- [NTSB LAX73AL012](https://openairdocs.org/ntsb/LAX73AL012.md): Cessna 206 · Bakersfield, CA · Accident · Minor injuries · Closed · Sep 9, 1972 · N2642X · Destroyed
- [NTSB NYC73FNA20](https://openairdocs.org/ntsb/NYC73FNA20.md): Cessna 177 · Oak Bluffs, MA · Accident · No injuries · Closed · Sep 8, 1972 · N34201 · Substantial damage
- [NTSB MIA73AM026](https://openairdocs.org/ntsb/MIA73AM026.md): Piper PA-31 · Columbus, MS · Accident · 6 fatal · Closed · Sep 7, 1972 · N9261Y · Destroyed
- [NTSB MIA73DKG18](https://openairdocs.org/ntsb/MIA73DKG18.md): Amer Avco AA1A · Ft Benning, GA · Accident · No injuries · Closed · Sep 6, 1972 · N9305L · Substantial damage
- [NTSB FTW73FPG18](https://openairdocs.org/ntsb/FTW73FPG18.md): Cessna 182E · Pocahontas, AR · Accident · No injuries · Closed · Sep 6, 1972 · N9341X · Substantial damage
- [NTSB NYC73FNC22](https://openairdocs.org/ntsb/NYC73FNC22.md): Cessna 150 · Pittsfield, ME · Accident · Serious injuries · Closed · Sep 5, 1972 · N7728E · Substantial damage
- [NTSB NYC73DNA19](https://openairdocs.org/ntsb/NYC73DNA19.md): Navion A · Providence, RI · Accident · No injuries · Closed · Sep 4, 1972 · N91698 · Substantial damage
- [NTSB NYC73DHD13](https://openairdocs.org/ntsb/NYC73DHD13.md): Piper PA-28 · Bristol, PA · Accident · Minor injuries · Closed · Sep 4, 1972 · N3696R · Destroyed
- [NTSB NYC73DFJ07](https://openairdocs.org/ntsb/NYC73DFJ07.md): Schweizer 1-23 · Campbell, NY · Accident · No injuries · Closed · Sep 4, 1972 · N1140S · Substantial damage
- [NTSB MKC73DCD29](https://openairdocs.org/ntsb/MKC73DCD29.md): Perth-Amboy CK · Ottumwa, IA · Accident · No injuries · Closed · Sep 3, 1972 · N914V · Substantial damage
- [NTSB MKC73AK019](https://openairdocs.org/ntsb/MKC73AK019.md): Johnson 185 · Blakesburg, IA · Accident · 2 fatal · Closed · Sep 3, 1972 · N90201 · Destroyed
- [NTSB NYC73FHM10](https://openairdocs.org/ntsb/NYC73FHM10.md): Piper PA-28 · East Hanover, NJ · Accident · No injuries · Closed · Sep 2, 1972 · N5318T · Substantial damage
- [NTSB CHI73FEM16](https://openairdocs.org/ntsb/CHI73FEM16.md): Cessna 172L · Newberry, MI · Accident · Minor injuries · Closed · Sep 2, 1972 · N19636 · Destroyed

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

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

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