# NTSB investigations, 1972, SC: Landing

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.

## Latest cases

- [NTSB MIA73DLG30](https://openairdocs.org/ntsb/MIA73DLG30.md): Cessna 140 · N Myrtle Beach, SC · Accident · No injuries · Closed · Dec 27, 1972 · N72137 · Substantial damage
- [NTSB MIA73DLG28](https://openairdocs.org/ntsb/MIA73DLG28.md): Luscombe 8A · Columbia, SC · Accident · No injuries · Closed · Nov 5, 1972 · N25129 · Substantial damage
- [NTSB MIA73FLG26](https://openairdocs.org/ntsb/MIA73FLG26.md): Cessna 310G · Union, SC · Accident · No injuries · Closed · Oct 16, 1972 · N2920R · Substantial damage
- [NTSB MIA73FLG23](https://openairdocs.org/ntsb/MIA73FLG23.md): Piper PA-22 · Ridgeland, SC · Accident · No injuries · Closed · Sep 29, 1972 · N8746D · Substantial damage
- [NTSB MIA73DLG19](https://openairdocs.org/ntsb/MIA73DLG19.md): Beech E33 · Greenwood, SC · Accident · No injuries · Closed · Sep 13, 1972 · N3162 · Substantial damage
- [NTSB MIA73DLG13](https://openairdocs.org/ntsb/MIA73DLG13.md): Luscombe 8E · Gaffney, SC · Accident · No injuries · Closed · Aug 12, 1972 · N2489K · Substantial damage
- [NTSB MIA73DLG12](https://openairdocs.org/ntsb/MIA73DLG12.md): Cessna 172G · Saluda, SC · Accident · No injuries · Closed · Aug 11, 1972 · N4311L · Substantial damage
- [NTSB MIA73FLG08](https://openairdocs.org/ntsb/MIA73FLG08.md): Cessna 421A · Hilton Head, SC · Accident · No injuries · Closed · Jul 28, 1972 · N2983Q · Substantial damage
- [NTSB MIA73DLG04](https://openairdocs.org/ntsb/MIA73DLG04.md): Curtis-Wrt 4C-1A · Columbia, SC · Accident · No injuries · Closed · Jul 9, 1972 · N563N · Substantial damage
- [NTSB MIA72DLG05](https://openairdocs.org/ntsb/MIA72DLG05.md): Piper PA-28 · Myrtle Beach, SC · Accident · No injuries · Closed · Jul 9, 1972 · N5129S · Substantial damage
- [NTSB MIA73DLG03](https://openairdocs.org/ntsb/MIA73DLG03.md): Piper J-3 · Aiken, SC · Accident · Minor injuries · Closed · Jul 2, 1972 · N5147B · Substantial damage
- [NTSB MIA72FLG42](https://openairdocs.org/ntsb/MIA72FLG42.md): Aeronca 7AC · White Rock, SC · Accident · No injuries · Closed · Jun 3, 1972 · N4328E · Substantial damage
- [NTSB MIA72FLG38](https://openairdocs.org/ntsb/MIA72FLG38.md): Cessna 310K · Landrum, SC · Accident · No injuries · Closed · May 4, 1972 · N3833X · Substantial damage
- [NTSB MIA72DLG36](https://openairdocs.org/ntsb/MIA72DLG36.md): Cessna 150 · Liberty, SC · Accident · No injuries · Closed · Apr 25, 1972 · N8451M · Substantial damage
- [NTSB MIA72DLG31](https://openairdocs.org/ntsb/MIA72DLG31.md): Cessna 150 · Pelzer, SC · Accident · No injuries · Closed · Mar 15, 1972 · N6679F · Substantial damage
- [NTSB MIA72DLG30](https://openairdocs.org/ntsb/MIA72DLG30.md): Taylorcraft BC12-D · Myrtle Beach, SC · Accident · No injuries · Closed · Mar 9, 1972 · N95301 · Substantial damage
- [NTSB MIA72FLG28](https://openairdocs.org/ntsb/MIA72FLG28.md): Champion 7GCAA · Edgefield, SC · Accident · No injuries · Closed · Mar 3, 1972 · N2760G · Substantial damage
- [NTSB MIA72DLG27](https://openairdocs.org/ntsb/MIA72DLG27.md): Cessna 305A · Johns Island, SC · Accident · No injuries · Closed · Feb 29, 1972 · N12755 · Substantial damage
- [NTSB MIA72DLG26](https://openairdocs.org/ntsb/MIA72DLG26.md): Maule M-4 · Mt.Pleasant, SC · Accident · No injuries · Closed · Feb 20, 1972 · N40319 · Substantial damage
- [NTSB MIA72DLG23](https://openairdocs.org/ntsb/MIA72DLG23.md): Cessna 170 · Columbia, SC · Accident · No injuries · Closed · Jan 16, 1972 · N8152A · Substantial damage

## 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 year(c."eventDate") = 1972
  AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?state=SC&year=1972

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