# Final NTSB investigations, LA: 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 CEN21LA204](https://openairdocs.org/ntsb/CEN21LA204.md): Piper J3C-65 · Slaughter, LA · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 26, 2021 · N26783 · Substantial damage
  > A total loss of engine power for reasons that could not be determined from the available evidence.
- [NTSB FTW00LA210](https://openairdocs.org/ntsb/FTW00LA210.md): Grumman-Schweizer G-164B · Ville Platte, LA · Accident · 1 fatal · Limited investigation · Final report · Jul 15, 2000 · N428KG · Destroyed
  > The loss of control for an undetermined reason.
- [NTSB FTW88DRD20](https://openairdocs.org/ntsb/FTW88DRD20.md): Alon A2A · New Orleans, LA · Accident · 1 fatal · Final report · Aug 24, 1988 · N5626F · Destroyed
  > The highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of.11%, there was evidence of…
- [NTSB FTW84LA366](https://openairdocs.org/ntsb/FTW84LA366.md): Grumman G-164 · Oak Grove, LA · Accident · No injuries · Limited investigation · Final report · Aug 24, 1984 · N528Y · Substantial damage
  > Aircraft landed with a flat left main tire, veered left and nosed over inverted.
- [NTSB FTW84LAMS4](https://openairdocs.org/ntsb/FTW84LAMS4.md): Piper PA-32-260 · Lafayette, LA · Accident · 1 fatal · Final report · May 10, 1984 · N3545W · Destroyed
  > The acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…
- [NTSB FTW84FA190](https://openairdocs.org/ntsb/FTW84FA190.md): Beech 65 · Jennings, LA · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1984 · N6RG · Destroyed
  > A popping or backfiring sound was heard by several people who later observed the acft flying at low altitude on what appeared to be a final approach to rwy 13 at Jennings arpt (located about 75 mi sw of the departure point.) No radios were onboard the acft so…
- [NTSB FTW82FRD08](https://openairdocs.org/ntsb/FTW82FRD08.md): Cessna 150G · Jeanerette, LA · Accident · 2 fatal · Final report · Feb 2, 1982 · N3166J · Destroyed
  > According to a friend of the deceased pilot and his female companion the three of them had been at a nightclub until 0215 CST. The friend then followed them to the airport, since he lived adjacent to the airport. After arriving he heard an aircraft takoeff.…
- [NTSB FTW76AF061](https://openairdocs.org/ntsb/FTW76AF061.md): Cessna 210 · Jena, LA · Accident · 2 fatal · Closed · Jan 25, 1976 · N9490T · Destroyed
- [NTSB FTW75FRJ37](https://openairdocs.org/ntsb/FTW75FRJ37.md): Navion A · Mansfield, LA · Accident · No injuries · Closed · Jun 15, 1975 · N8885H · Substantial damage
- [NTSB FTW75FRD63](https://openairdocs.org/ntsb/FTW75FRD63.md): Bell 206B · St Martinville, LA · Accident · No injuries · Closed · Jun 1, 1975 · N58099 · Destroyed
- [NTSB FTW73AF053](https://openairdocs.org/ntsb/FTW73AF053.md): Bell 206B · Patterson, LA · Accident · 2 fatal · Closed · Mar 20, 1973 · N36AL · Destroyed
- [NTSB FTW71FRJ34](https://openairdocs.org/ntsb/FTW71FRJ34.md): Aeronca 7AC · Waterproof, LA · Accident · Serious injuries · Closed · May 15, 1971 · N83076 · Destroyed
- [NTSB FTW69A0050](https://openairdocs.org/ntsb/FTW69A0050.md): Cessna 150J · Farmerville, LA · Accident · 1 fatal · Closed · Jan 24, 1969 · N50468 · Destroyed
- [NTSB FTW68A0103](https://openairdocs.org/ntsb/FTW68A0103.md): Bell 206A · Morgan City, LA · Accident · 1 fatal · Closed · Jun 3, 1968 · N7943S · Destroyed
- [NTSB FTW67A0077](https://openairdocs.org/ntsb/FTW67A0077.md): Mooney M20E · New Orleans, LA · Accident · 1 fatal · Closed · Jan 21, 1967 · N2670W · 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."completionStatus" = 'Completed'
  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=LA&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.
