# NTSB investigations, LA: Miscellaneous/other

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 CEN23FA201](https://openairdocs.org/ntsb/CEN23FA201.md): Cessna 182T · Grand Isle, LA · Accident · 1 fatal · Class 3 · Field · Final report · May 24, 2023 · N577TZ · Substantial damage
  > The pilot’s operation of the airplane while intoxicated, resulting in its impact with the ocean.
- [NTSB CEN18LA346](https://openairdocs.org/ntsb/CEN18LA346.md): Cessna 172 · Shreveport, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 2018 · N4275Q · Substantial damage
  > The student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.
- [NTSB GAA18CA153](https://openairdocs.org/ntsb/GAA18CA153.md): American Champion 8GCBC · Many, LA · Accident · No injuries · Data collection · Final report · Mar 8, 2018 · N105BH · Substantial damage
  > The pilot’s improper application of the brakes during landing, which resulted in a nose-over.
- [NTSB GAA18CA066](https://openairdocs.org/ntsb/GAA18CA066.md): Robinson Helicopter R44 · New Orleans, LA · Accident · No injuries · Data collection · Final report · Nov 29, 2017 · N744WT · Substantial damage
  > The pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.
- [NTSB CEN12CA526](https://openairdocs.org/ntsb/CEN12CA526.md): Cessna 172R · Leesville, LA · Accident · Minor injuries · Data collection · Final report · Aug 3, 2012 · N989BT · Substantial damage
  > The student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.
- [NTSB CEN12FA088](https://openairdocs.org/ntsb/CEN12FA088.md): Piper PA-31 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2011 · N6485L · Minor damage
  > The pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.
- [NTSB CEN10IA438](https://openairdocs.org/ntsb/CEN10IA438.md): Bell 206 · Gulf of Mexico, LA · Incident · No injuries · Incident investigation · Final report · Jul 26, 2010 · N317RL · Minor damage
  > The loss of main rotor rpm during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies.
- [NTSB CEN10IA169](https://openairdocs.org/ntsb/CEN10IA169.md): Sikorsky S-92A · Galliano, LA · Incident · No injuries · Incident investigation · Final report · Mar 22, 2010 · N921AL · Minor damage
  > An unsecured access door, which departed the helicopter and damaged a main rotor blade and a tail rotor blade. Contributing to the incident was the helicopter's color scheme, which made visual inspection of the door difficult.

## 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/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.