# Major NTSB investigations, LA

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 CEN20MA044](https://openairdocs.org/ntsb/CEN20MA044.md): Piper PA 31T · Lafayette, LA · Accident · 5 fatal · Class 2 · Major · Final report · Dec 28, 2019 · N42CV · Destroyed
  > The pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.
- [NTSB CEN09MA117](https://openairdocs.org/ntsb/CEN09MA117.md): Sikorsky S-76C · Morgan City, LA · Accident · 8 fatal · Major investigation · Final report · Jan 4, 2009 · N748P · Destroyed
  > (1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…
- [NTSB DCA94MA033](https://openairdocs.org/ntsb/DCA94MA033.md): Saab-Scania 340B · New Roads, LA · Accident · Minor injuries · Class 1 · Major · Final report · Feb 2, 1994 · N349SB · Substantial damage
  > The captain's movement of the power levers below flight idle in flight, the inadequate certification requirements and consequent design of the airplane's power levers that permitted them to be moved below the flight idle position into the beta range, either…
- [NTSB FTW88MA047](https://openairdocs.org/ntsb/FTW88MA047.md): Gates Learjet 36A · Monroe, LA · Accident · 2 fatal · Major investigation · Final report · Jan 8, 1988 · N79SF · Destroyed
  > The crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…
- [NTSB DCA87MA033](https://openairdocs.org/ntsb/DCA87MA033.md): British Aerospace 3101 · Kenner, LA · Accident · Serious injuries · Major investigation · Final report · May 26, 1987 · N331CY · Destroyed
  > The acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…
- [NTSB LAX86MA309](https://openairdocs.org/ntsb/LAX86MA309.md): Aerospatiale AS-355F-1 · Morgan City, LA · Accident · No injuries · Major investigation · Final report · Jul 18, 1986 · N57967 · Destroyed
  > The plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…
- [NTSB LAX72AL043](https://openairdocs.org/ntsb/LAX72AL043.md): Boeing 747 · Lake Charles, LA · Accident · Serious injuries · Closed · Jan 4, 1972 · N77772 · Minor damage
- [NTSB DCA69A0015](https://openairdocs.org/ntsb/DCA69A0015.md): Douglas DC3A · New Orleans, LA · Accident · 16 fatal · Closed · Mar 20, 1969 · N142D · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&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.