# NTSB investigations, LA: Uncontrolled descent

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 WPR19LA112](https://openairdocs.org/ntsb/WPR19LA112.md): Air Tractor AT502 · Morganza, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 16, 2019 · N599LA · Substantial damage
  > A loss of aircraft control due to the separation of the elevator pushrod attachment bolt.
- [NTSB FTW87DRD06](https://openairdocs.org/ntsb/FTW87DRD06.md): Air Command 532 · St.Francisville, LA · Accident · 1 fatal · Final report · Jun 28, 1987 · N532X · Destroyed
  > Witnesses observed the gyroplane flying at 10-15 feet AGL when it started a turn to the right. It continued the right turn and descended into the ground. Dr. Moore of the FAA sw regional flight surgeon's office stated that the plt had coronary disease and…
- [NTSB FTW81FA132](https://openairdocs.org/ntsb/FTW81FA132.md): Piper PA-32R · Mount Hermon, LA · Accident · 2 fatal · Closed · Aug 16, 1981 · N304FW · Destroyed
- [NTSB FTW81FA105](https://openairdocs.org/ntsb/FTW81FA105.md): Swearingen SA226T · Cameron, LA · Accident · 2 fatal · Closed · Jun 10, 1981 · N555AM · Destroyed
- [NTSB FTW81FA090](https://openairdocs.org/ntsb/FTW81FA090.md): Cessna 172A · Verda, LA · Accident · 1 fatal · Closed · May 13, 1981 · N7232T · Destroyed
- [NTSB FTW80FA116](https://openairdocs.org/ntsb/FTW80FA116.md): Piper PA-32 · Goodwill, LA · Accident · 4 fatal · Closed · Sep 17, 1980 · N1806T · Destroyed
- [NTSB FTW80FA100](https://openairdocs.org/ntsb/FTW80FA100.md): Bell 205A-1 · Houma, LA · Accident · 13 fatal · Closed · Aug 6, 1980 · N95AL · Destroyed
- [NTSB FTW80FA028](https://openairdocs.org/ntsb/FTW80FA028.md): Beech 65-90 · Leeville, LA · Accident · 2 fatal · Closed · Dec 22, 1979 · N724N · Destroyed
- [NTSB FTW79FA108](https://openairdocs.org/ntsb/FTW79FA108.md): Piper PA-31 · Luling, LA · Accident · 4 fatal · Closed · Sep 20, 1979 · N27614 · Destroyed
- [NTSB FTW79DA100](https://openairdocs.org/ntsb/FTW79DA100.md): Bell 206B · Morgan City, LA · Accident · 1 fatal · Closed · Aug 11, 1979 · N5018F · Destroyed
- [NTSB FTW79FA076](https://openairdocs.org/ntsb/FTW79FA076.md): Cessna 320E · Covington, LA · Accident · 3 fatal · Closed · Apr 22, 1979 · N3482Q · Destroyed
- [NTSB FTW78FA065](https://openairdocs.org/ntsb/FTW78FA065.md): Cessna 310B · Cameron, LA · Accident · 3 fatal · Closed · Jul 20, 1978 · N5403A · Destroyed
- [NTSB FTW78FA043](https://openairdocs.org/ntsb/FTW78FA043.md): Aero Comdr 1121A · Flatwoods, LA · Accident · 2 fatal · Closed · Apr 27, 1978 · N250UA · Destroyed
- [NTSB FTW77FA070](https://openairdocs.org/ntsb/FTW77FA070.md): Beech V35B · Ida, LA · Accident · 1 fatal · Closed · Aug 18, 1977 · N1605W · Destroyed
- [NTSB FTW77FA028](https://openairdocs.org/ntsb/FTW77FA028.md): Bolkow BO105C · Morgan City, LA · Accident · 1 fatal · Closed · Jan 6, 1977 · N200BB · Substantial damage
- [NTSB FTW77FA008](https://openairdocs.org/ntsb/FTW77FA008.md): Cessna 182L · Shaw, LA · Accident · 2 fatal · Closed · Oct 23, 1976 · N42213 · Destroyed
- [NTSB FTW76FRJ20](https://openairdocs.org/ntsb/FTW76FRJ20.md): Cessna 182P · Jones, LA · Accident · Serious injuries · Closed · Apr 13, 1976 · N9110M · Destroyed
- [NTSB FTW76AF071](https://openairdocs.org/ntsb/FTW76AF071.md): Cessna 172 · Marksville, LA · Accident · 1 fatal · Closed · Mar 12, 1976 · N5928R · Destroyed
- [NTSB FTW76AF018](https://openairdocs.org/ntsb/FTW76AF018.md): Bellanca 17-31 · Larto, LA · Accident · 1 fatal · Closed · Sep 7, 1975 · N14713 · Destroyed
- [NTSB FTW76AF031](https://openairdocs.org/ntsb/FTW76AF031.md): Piper PA-32 · Bernice, LA · Accident · 2 fatal · Closed · Jul 21, 1975 · N3704W · Destroyed
- [NTSB FTW75FRD31](https://openairdocs.org/ntsb/FTW75FRD31.md): Aero Comdr 600S2R · Oberlin, LA · Accident · 1 fatal · Closed · Feb 21, 1975 · N4887X · Destroyed
- [NTSB FTW75AF047](https://openairdocs.org/ntsb/FTW75AF047.md): Cessna 175 · Abbeville, LA · Accident · 1 fatal · Closed · Dec 31, 1974 · N8066T · Destroyed
- [NTSB FTW74AF036](https://openairdocs.org/ntsb/FTW74AF036.md): Piper PA-28 · Slidell, LA · Accident · 1 fatal · Closed · Nov 22, 1973 · N6629J · Destroyed
- [NTSB FTW73AF009](https://openairdocs.org/ntsb/FTW73AF009.md): Beech F35 · Ruston, LA · Accident · 1 fatal · Closed · Sep 4, 1972 · N5048B · Destroyed
- [NTSB FTW72AF009](https://openairdocs.org/ntsb/FTW72AF009.md): Beech D18S · Loreauville, LA · Accident · 1 fatal · Closed · Aug 1, 1971 · N296RB · Destroyed
- [NTSB FTW71AF067](https://openairdocs.org/ntsb/FTW71AF067.md): Cessna 310L · Crowley, LA · Accident · 1 fatal · Closed · Apr 1, 1971 · N13PS · Destroyed
- [NTSB FTW71AF040](https://openairdocs.org/ntsb/FTW71AF040.md): Piper PA-22 · Franklin, LA · Accident · 2 fatal · Closed · Jan 17, 1971 · N8101C · Destroyed
- [NTSB FTW71DRD29](https://openairdocs.org/ntsb/FTW71DRD29.md): Bell 206A · Leeville, LA · Accident · Serious injuries · Closed · Dec 14, 1970 · N7850S · Substantial damage
- [NTSB FTW70F0296](https://openairdocs.org/ntsb/FTW70F0296.md): Bell 206A · New Iberia, LA · Accident · No injuries · Closed · Oct 31, 1969 · N4043G · Substantial damage
- [NTSB FTW70A0003](https://openairdocs.org/ntsb/FTW70A0003.md): Piper PA-22 · Sulphur, LA · Accident · 1 fatal · Closed · Jul 22, 1969 · N3583A · Destroyed
- [NTSB FTW69A0067](https://openairdocs.org/ntsb/FTW69A0067.md): Beech S35 · Mansfield, LA · Accident · 5 fatal · Closed · Mar 30, 1969 · N5736K · Destroyed
- [NTSB FTW69A0046](https://openairdocs.org/ntsb/FTW69A0046.md): Piper PA-24 · Oakdale, LA · Accident · 5 fatal · Closed · Dec 30, 1968 · N7702P · Destroyed
- [NTSB FTW68A0083](https://openairdocs.org/ntsb/FTW68A0083.md): Bell 47G-2A · Leeville, LA · Accident · No injuries · Closed · Mar 30, 1968 · N74096 · Substantial damage
- [NTSB FTW68A0066](https://openairdocs.org/ntsb/FTW68A0066.md): Beech 95-B55 · New Orleans La, LA · Accident · 6 fatal · Closed · Dec 31, 1967 · N6139V · Destroyed
- [NTSB FTW68A0045](https://openairdocs.org/ntsb/FTW68A0045.md): Beech V35 · Monroe, LA · Accident · 2 fatal · Closed · Oct 16, 1967 · N506SW · Destroyed
- [NTSB FTW68A0019](https://openairdocs.org/ntsb/FTW68A0019.md): Bell 206A · Morgan City, LA · Accident · 4 fatal · Closed · Aug 15, 1967 · N7846S · Destroyed
- [NTSB FTW67A0116](https://openairdocs.org/ntsb/FTW67A0116.md): Beech E35 · Crowley, LA · Accident · 1 fatal · Closed · May 31, 1967 · N7372B · Destroyed
- [NTSB FTW67A0036](https://openairdocs.org/ntsb/FTW67A0036.md): Luscombe 8A · Holly Ridge, LA · Accident · 1 fatal · Closed · Sep 18, 1966 · N25380 · Destroyed
- [NTSB FTW65A0104](https://openairdocs.org/ntsb/FTW65A0104.md): Cessna 120 · Plaquemine, LA · Accident · 3 fatal · Closed · Apr 18, 1965 · N77380 · Destroyed
- [NTSB UNK64X0704](https://openairdocs.org/ntsb/UNK64X0704.md): Piper PA24 · New Orleans, LA · Accident · 2 fatal · Closed · Feb 27, 1964 · N7871P · Destroyed
- [NTSB UNK64X0687](https://openairdocs.org/ntsb/UNK64X0687.md): Douglas DC-8 · New Orleans, LA · Accident · 58 fatal · Closed · Feb 25, 1964 · N8607 · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb-phases/650/cases?state=LA

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