# NTSB investigations, AL: Unknown

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 MIA08FA026](https://openairdocs.org/ntsb/MIA08FA026.md): Cessna R182 · Woodland, AL · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2007 · N2643C · Destroyed
  > The flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…
- [NTSB MIA99LA194](https://openairdocs.org/ntsb/MIA99LA194.md): Cessna 177RG · Jasper, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1999 · N2619V · Substantial damage
  > the pilot inadvertently became disoriented and misjudged his position on the runway/airport, which resulted in him turning the airplane too soon, and subsequently impacting with a tree. Factors in this accident were a loss of electrical power for undetermined…
- [NTSB ATL83FA161](https://openairdocs.org/ntsb/ATL83FA161.md): Cessna 177RG · Mobile, AL · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1983 · N2765V · Destroyed
  > The plt had not flown actively for aprx 1 yr. However, shortly before the accident, he had told friends that he had missed flying & was going to resume this activity. He received a checkout in the Cessna 177RG on 12/12/82 in anticipation of flying again. This…
- [NTSB ATL83FKJ01](https://openairdocs.org/ntsb/ATL83FKJ01.md): Cessna 172N · Clanton, AL · Accident · 1 fatal · Final report · Dec 22, 1982 · N609CW · Destroyed
  > The acft was observed in a high speed glide to touch down briefly in a pasture at the top of a knoll. It then dropped below the rise & crashed in a wooded area adjacent to the pasture. Examination of the eng showed a crack extending from the top forward…
- [NTSB ATL82DKJ03](https://openairdocs.org/ntsb/ATL82DKJ03.md): Cessna T210N · Bayou La Batre, AL · Accident · No injuries · Closed · Nov 8, 1981 · N6335C · Destroyed
- [NTSB MIA73AM072](https://openairdocs.org/ntsb/MIA73AM072.md): Beech E35 · Mobile, AL · Accident · 5 fatal · Closed · Jan 6, 1973 · N3294C · Destroyed
- [NTSB MIA69A0016](https://openairdocs.org/ntsb/MIA69A0016.md): Piper PA-28 · Eufaula, AL · Accident · 2 fatal · Closed · Sep 22, 1968 · N6544W · Destroyed
- [NTSB MIA68D0048](https://openairdocs.org/ntsb/MIA68D0048.md): Taylorcraft BL-65 · Russellville, AL · Accident · No injuries · Closed · Jun 3, 1967 · N27485 · Destroyed
- [NTSB MIA67D0464](https://openairdocs.org/ntsb/MIA67D0464.md): Cessna 172 · Northport, AL · Accident · No injuries · Closed · Jan 7, 1967 · N3951L · 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 c."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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