# Final NTSB investigations, MI: 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 CEN11CA003](https://openairdocs.org/ntsb/CEN11CA003.md): Cessna 310J · St. Johns, MI · Accident · Minor injuries · Data collection · Final report · Oct 1, 2010 · N3051L · Substantial damage
  > The failure by the pilot to attain/maintain a climb rate for undetermined reasons during a go-around.
- [NTSB CHI05CA120](https://openairdocs.org/ntsb/CHI05CA120.md): Brantly Helicopter B-2B · Lakeview, MI · Accident · No injuries · Data collection · Final report · May 20, 2005 · N2274U · Substantial damage
  > The dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.
- [NTSB CHI02FA172](https://openairdocs.org/ntsb/CHI02FA172.md): Cessna 182A · Foster City, MI · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2002 · N5034D · Destroyed
  > The incapacitation of the pilot. A contributing factor was the pilot and medical examiner providing false information on the pilot's medical applications.
- [NTSB CHI02LA121](https://openairdocs.org/ntsb/CHI02LA121.md): Yoder GP-4 · Mount Pleasant, MI · Accident · 2 fatal · Limited investigation · Final report · May 5, 2002 · N59JY · Destroyed
  > The inadvertent stall/spin by the pilot-in-command.
- [NTSB CHI91FA266](https://openairdocs.org/ntsb/CHI91FA266.md): Bellanca 17-30A · Boyne City, MI · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1991 · N6704V · Substantial damage
  > The pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..
- [NTSB CHI81FA012](https://openairdocs.org/ntsb/CHI81FA012.md): Piper PA-28R · Kalkaska, MI · Accident · 2 fatal · Closed · Dec 12, 1980 · N559PA · Destroyed
- [NTSB CHI80FAMS1](https://openairdocs.org/ntsb/CHI80FAMS1.md): Piper PA-24 · Ganges, MI · Accident · 1 fatal · Closed · Oct 10, 1979 · N8437P · Destroyed
- [NTSB DCA79AA016](https://openairdocs.org/ntsb/DCA79AA016.md): Boeing 727-31 · Saginaw, MI · Accident · Minor injuries · Closed · Apr 4, 1979 · N840TW · Substantial damage
- [NTSB CHI79FA019](https://openairdocs.org/ntsb/CHI79FA019-138560.md): Cessna 150M · Big Bay Denoc, MI · Accident · 1 fatal · Closed · Feb 4, 1978 · C-GYEF · Destroyed
- [NTSB CHI77FEC48](https://openairdocs.org/ntsb/CHI77FEC48.md): Piper PA-28 · Romeo, MI · Accident · 1 fatal · Closed · Sep 24, 1977 · N5194S · Destroyed
- [NTSB CHI77FA016](https://openairdocs.org/ntsb/CHI77FA016.md): Erco 415-C · Palo, MI · Accident · 1 fatal · Closed · Dec 19, 1976 · N99258 · Destroyed
- [NTSB CHI77AC095](https://openairdocs.org/ntsb/CHI77AC095.md): Beech 95 · L'Anse, MI · Accident · 2 fatal · Closed · Sep 20, 1976 · N2080C · Destroyed
- [NTSB CHI76FEM53](https://openairdocs.org/ntsb/CHI76FEM53.md): Thorp T-18 · Menominee, MI · Accident · 2 fatal · Closed · Aug 7, 1976 · N12BS · Destroyed
- [NTSB CHI76AC081](https://openairdocs.org/ntsb/CHI76AC081.md): Piper PA-22 · Gadwin, MI · Accident · 2 fatal · Closed · Jun 18, 1976 · N2227A · Destroyed
- [NTSB CHI76AC047](https://openairdocs.org/ntsb/CHI76AC047.md): Cessna 172L · Bay City, MI · Accident · 1 fatal · Closed · Jan 31, 1976 · N3971Q · Destroyed
- [NTSB CHI76FEM05](https://openairdocs.org/ntsb/CHI76FEM05.md): Piper PA-36 · Munger, MI · Accident · 1 fatal · Closed · Jul 23, 1975 · N9919P · Destroyed
- [NTSB CHI75AC020](https://openairdocs.org/ntsb/CHI75AC020.md): Mooney M20F · Manistique, MI · Accident · 2 fatal · Closed · Aug 22, 1974 · N6438Q · Destroyed
- [NTSB CHI74AC065](https://openairdocs.org/ntsb/CHI74AC065.md): Beech A35 · Traverse Cty, MI · Accident · 3 fatal · Closed · Jan 27, 1974 · N9329Y · Destroyed
- [NTSB CHI73AC093](https://openairdocs.org/ntsb/CHI73AC093.md): Stinson 108-3 · Freeland, MI · Accident · 3 fatal · Closed · May 27, 1973 · N4125C · Destroyed
- [NTSB CHI73AC079](https://openairdocs.org/ntsb/CHI73AC079.md): Beech E35 · Hanover, MI · Accident · 2 fatal · Closed · Mar 30, 1973 · N3506B · Destroyed
- [NTSB CHI73AC063](https://openairdocs.org/ntsb/CHI73AC063.md): Cessna 150G · Berrien Spgs, MI · Accident · 2 fatal · Closed · Jan 14, 1973 · N4033J · Destroyed
- [NTSB CHI73AC058](https://openairdocs.org/ntsb/CHI73AC058.md): Lear 23 · Romulus, MI · Accident · 2 fatal · Closed · Dec 15, 1972 · N20M · Destroyed
- [NTSB CHI73DEC04](https://openairdocs.org/ntsb/CHI73DEC04.md): Hughes 269A · Troy, MI · Accident · No injuries · Closed · Aug 26, 1972 · N8889F · Destroyed
- [NTSB CHI72AC078](https://openairdocs.org/ntsb/CHI72AC078.md): Piper PA-28 · Stockbridge, MI · Accident · 1 fatal · Closed · Apr 2, 1972 · N7321J · Destroyed
- [NTSB CHI72AC067](https://openairdocs.org/ntsb/CHI72AC067.md): Beech 35 · Saginaw, MI · Accident · 2 fatal · Closed · Feb 27, 1972 · N3806N · Destroyed
- [NTSB CHI72AC032](https://openairdocs.org/ntsb/CHI72AC032.md): Piper PA-28 · Concord, MI · Accident · 1 fatal · Closed · Oct 8, 1971 · N4700L · Destroyed
- [NTSB CHI72AC018](https://openairdocs.org/ntsb/CHI72AC018.md): Piper PA-28 · Marshall, MI · Accident · 4 fatal · Closed · Aug 27, 1971 · N7905W · Destroyed
- [NTSB CHI72AC017](https://openairdocs.org/ntsb/CHI72AC017.md): Piper PA-22 · Cadillac, MI · Accident · 2 fatal · Closed · Aug 27, 1971 · N7039B · Destroyed
- [NTSB CHI71AC079](https://openairdocs.org/ntsb/CHI71AC079.md): Cessna 182L · Ionia, MI · Accident · 2 fatal · Closed · Apr 13, 1971 · N42241 · Destroyed
- [NTSB CHI71AC071](https://openairdocs.org/ntsb/CHI71AC071.md): Beech 35-B33 · Bellaire, MI · Accident · 1 fatal · Closed · Apr 3, 1971 · CF-RGX · Destroyed
- [NTSB CHI71FBJ56](https://openairdocs.org/ntsb/CHI71FBJ56.md): Cessna 150H · Gladstone, MI · Accident · Minor injuries · Closed · Jan 25, 1971 · N22587 · Substantial damage
- [NTSB CHI70FDW23](https://openairdocs.org/ntsb/CHI70FDW23.md): Bell 47-J2 · Union Lake, MI · Accident · No injuries · Closed · Jun 20, 1970 · N73271 · Destroyed
- [NTSB CHI70AC072](https://openairdocs.org/ntsb/CHI70AC072.md): Piper PA-28 · Fowler, MI · Accident · 4 fatal · Closed · Apr 19, 1970 · N7815W · Destroyed
- [NTSB CHI70A0029](https://openairdocs.org/ntsb/CHI70A0029.md): Piper PA-23 · Charlotte, MI · Accident · 1 fatal · Closed · Nov 8, 1969 · N6095C · Destroyed
- [NTSB CHI70F0290](https://openairdocs.org/ntsb/CHI70F0290.md): Beech F35 · Freeland, MI · Accident · No injuries · Closed · Sep 13, 1969 · N3357C · Destroyed
- [NTSB CHI69A0098](https://openairdocs.org/ntsb/CHI69A0098.md): Beech 23 · Mackinaw Cty, MI · Accident · 3 fatal · Closed · Jun 1, 1969 · N2365J · Destroyed
- [NTSB CHI69A0052](https://openairdocs.org/ntsb/CHI69A0052.md): Globe GC-1B · Reed City, MI · Accident · 1 fatal · Closed · Nov 17, 1968 · N78061 · Destroyed
- [NTSB CHI69F0008](https://openairdocs.org/ntsb/CHI69F0008.md): Cessna 172D · Tecumseh, MI · Accident · Serious injuries · Closed · Jun 1, 1968 · N2652U · Destroyed
- [NTSB CHI68A0059](https://openairdocs.org/ntsb/CHI68A0059.md): Luscombe 8E · Jeddo, MI · Accident · 2 fatal · Closed · Jan 3, 1968 · N842B · Destroyed
- [NTSB CHI67A0090](https://openairdocs.org/ntsb/CHI67A0090.md): Cessna 337A · Sault St Mar, MI · Accident · 1 fatal · Closed · Jan 17, 1967 · CFUIC · Destroyed
- [NTSB CHI67A0070](https://openairdocs.org/ntsb/CHI67A0070.md): Aero Comdr 680F · Bangor, MI · Accident · 2 fatal · Closed · Nov 26, 1966 · N226AA · Destroyed
- [NTSB CHI67A0050](https://openairdocs.org/ntsb/CHI67A0050.md): Piper PA-32 · Dowagiac, MI · Accident · 6 fatal · Closed · Oct 9, 1966 · N3279W · Destroyed
- [NTSB CHI66A0082](https://openairdocs.org/ntsb/CHI66A0082.md): Piper PA-23 · Jackson, MI · Accident · 1 fatal · Closed · Apr 1, 1966 · N1118P · Destroyed
- [NTSB CHI66A0080](https://openairdocs.org/ntsb/CHI66A0080.md): Mooney MK 20C · Freeland, MI · Accident · 2 fatal · Closed · Mar 31, 1966 · N5647Q · Destroyed
- [NTSB CHI66A0041](https://openairdocs.org/ntsb/CHI66A0041.md): Lear Jet 23 · Jackson, MI · Accident · 2 fatal · Closed · Oct 21, 1965 · N804LJ · Destroyed
- [NTSB CHI66F0377](https://openairdocs.org/ntsb/CHI66F0377.md): Piper J3C-65 · Saline, MI · Accident · 1 fatal · Closed · Oct 16, 1965 · N30575 · Destroyed
- [NTSB CHI66A0031](https://openairdocs.org/ntsb/CHI66A0031.md): Cessna 172 · White Cloud, MI · Accident · 3 fatal · Closed · Sep 30, 1965 · N8413U · Destroyed
- [NTSB CHI65A0073](https://openairdocs.org/ntsb/CHI65A0073.md): Piper PA-22 · Pontiac, MI · Accident · 2 fatal · Closed · Feb 12, 1965 · N3509Z · Destroyed
- [NTSB UNK65X1189](https://openairdocs.org/ntsb/UNK65X1189.md): Curtis-Writ C-46A · Detroit, MI · Accident · 4 fatal · Closed · Dec 30, 1964 · N608Z · 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" = 'MI' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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=MI&status=final

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