# Final NTSB investigations, 1981: Standing

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 ATL82FLG04](https://openairdocs.org/ntsb/ATL82FLG04.md): Piper PA-32 · Columbia, SC · Accident · No injuries · Closed · Nov 30, 1981 · N8564E · Substantial damage
- [NTSB LAX82FVD05](https://openairdocs.org/ntsb/LAX82FVD05.md): Cessna 172 · Ukiah, CA · Accident · No injuries · Closed · Nov 19, 1981 · N5609A · Substantial damage
- [NTSB FTW82DA010](https://openairdocs.org/ntsb/FTW82DA010.md): Boeing 727 · Dal Ftw Arpt, TX · Accident · Serious injuries · Closed · Oct 13, 1981 · N6816 · No damage
- [NTSB FTW82FPA01](https://openairdocs.org/ntsb/FTW82FPA01.md): Cessna 177 · Dallas, TX · Accident · Serious injuries · Closed · Oct 3, 1981 · N3215T · Minor damage
- [NTSB MIA81FKU05](https://openairdocs.org/ntsb/MIA81FKU05.md): Cessna 402B · Miami, FL · Accident · No injuries · Closed · Sep 26, 1981 · N5879M · Substantial damage
- [NTSB LAX81FA131](https://openairdocs.org/ntsb/LAX81FA131.md): Bell 206L-1 · Waialae Falls, HI · Accident · No injuries · Closed · Sep 22, 1981 · N1075S · Substantial damage
- [NTSB DEN81FA065](https://openairdocs.org/ntsb/DEN81FA065.md): Douglas DC-10 · Salt Lake City, UT · Accident · 1 fatal · Closed · Sep 7, 1981 · N109AA · No damage
- [NTSB CHI81FER64](https://openairdocs.org/ntsb/CHI81FER64.md): Cessna U206 · Lake Benson, MN · Accident · Serious injuries · Closed · Aug 29, 1981 · N51301 · Minor damage
- [NTSB ATL81FA110](https://openairdocs.org/ntsb/ATL81FA110.md): Beech 99 · Washington, DC · Accident · Serious injuries · Closed · Aug 23, 1981 · N124CA · Minor damage
- [NTSB MKC81FA051](https://openairdocs.org/ntsb/MKC81FA051.md): Douglas DC-9 · St.Louis, MO · Accident · No injuries · Closed · Aug 13, 1981 · N924L · Substantial damage
- [NTSB NYC81FA067](https://openairdocs.org/ntsb/NYC81FA067-201162.md): Cessna 210 · Philadelphia, PA · Accident · No injuries · Closed · Jun 25, 1981 · N4805K · Minor damage
- [NTSB MIA81IA085](https://openairdocs.org/ntsb/MIA81IA085.md): Boeing 707 · Miami, FL · Incident · No injuries · Closed · Jun 20, 1981 · HC-BCT · Minor damage
- [NTSB MKC81FA038](https://openairdocs.org/ntsb/MKC81FA038.md): Boeing 707 · St Louis, MO · Accident · No injuries · Closed · Jun 3, 1981 · N6728 · No damage
- [NTSB NYC81IA051](https://openairdocs.org/ntsb/NYC81IA051.md): Swearingen SA226 · Newark, NJ · Incident · No injuries · Closed · May 29, 1981 · N105UR · 2 aircraft · Minor damage
- [NTSB SEA81FA036](https://openairdocs.org/ntsb/SEA81FA036.md): Bell 206B · Govt Camp, OR · Accident · 1 fatal · Closed · May 22, 1981 · N58004 · Substantial damage
- [NTSB LAX81DUJ53](https://openairdocs.org/ntsb/LAX81DUJ53.md): Cessna 172 · Phoenix, AZ · Accident · No injuries · Closed · Apr 21, 1981 · N7296G · Substantial damage
- [NTSB LAX81FA077](https://openairdocs.org/ntsb/LAX81FA077.md): Cessna 404 · Burbank, CA · Accident · Serious injuries · Closed · Apr 20, 1981 · N5375C · Minor damage
- [NTSB FTW81IA067](https://openairdocs.org/ntsb/FTW81IA067.md): Bell 222 · Lake Charles, LA · Incident · No injuries · Closed · Apr 9, 1981 · N38929 · No damage
- [NTSB ATL81IA060](https://openairdocs.org/ntsb/ATL81IA060.md): Boeing 727 · Washington, DC · Incident · Minor injuries · Closed · Apr 9, 1981 · N281US · No damage
- [NTSB CHI81DEE27](https://openairdocs.org/ntsb/CHI81DEE27.md): Cessna 172 · Rock Falls, IL · Accident · No injuries · Closed · Mar 31, 1981 · N35585 · Substantial damage
- [NTSB CHI81FEI12](https://openairdocs.org/ntsb/CHI81FEI12.md): Piper PA-28 · Youngstown, OH · Accident · No injuries · Closed · Mar 22, 1981 · N40881 · 2 aircraft · Substantial damage
- [NTSB CHI81FEV09](https://openairdocs.org/ntsb/CHI81FEV09.md): Bell 206 · Duquoin, IL · Accident · Serious injuries · Closed · Mar 2, 1981 · N3904N · Destroyed
- [NTSB NYC81FA035](https://openairdocs.org/ntsb/NYC81FA035.md): Boeing 727 · Jamaica, NY · Accident · Serious injuries · Closed · Feb 12, 1981 · N3606 · No damage
- [NTSB MIA81FA043](https://openairdocs.org/ntsb/MIA81FA043.md): Airbus A300 · Miami, FL · Accident · No injuries · Closed · Feb 6, 1981 · N206EA · No damage
- [NTSB LAX81FVG13](https://openairdocs.org/ntsb/LAX81FVG13.md): Beech A60 · Sacramento, CA · Accident · No injuries · Closed · Jan 21, 1981 · N7420D · Substantial damage
- [NTSB SEA81DYE11](https://openairdocs.org/ntsb/SEA81DYE11.md): Hiller Acft UH-12E · Beaver, WA · Accident · No injuries · Closed · Jan 7, 1981 · N28875 · 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") = 1981
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?status=final&year=1981

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