# NTSB investigations, LA: Aircraft inspection event

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 CEN17LA174](https://openairdocs.org/ntsb/CEN17LA174.md): Bell 407 · Venice, LA · Accident · No injuries · Limited investigation · Final report · May 2, 2017 · N457PH · Substantial damage
  > An in-flight separation of the tip block from the tail rotor blade due to an inadequate blade repair, which resulted in a rotor imbalance sufficient to crack the gearbox attachment studs and gearbox support assembly, and inadequate postrepair test procedures,…
- [NTSB CEN14LA415](https://openairdocs.org/ntsb/CEN14LA415.md): Bell 47G 2 · Jeanerette, LA · Accident · 1 fatal · Limited investigation · Final report · Aug 10, 2014 · N4690 · Destroyed
  > The pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.
- [NTSB CEN12LA388](https://openairdocs.org/ntsb/CEN12LA388.md): Cessna A150K · Mamou, LA · Accident · No injuries · Limited investigation · Final report · Jun 23, 2012 · N8380M · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.
- [NTSB CEN11IA156](https://openairdocs.org/ntsb/CEN11IA156.md): Sikorsky 92 · Galliano, LA · Incident · No injuries · Incident investigation · Final report · Jan 19, 2011 · N920AL · Minor damage
  > The misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.
- [NTSB CEN11CA062](https://openairdocs.org/ntsb/CEN11CA062.md): Cessna 172 · Pineville, LA · Accident · No injuries · Data collection · Final report · Nov 9, 2010 · N9747L · Substantial damage
  > The pilot/mechanic’s improper inspection of the airplane following the engine installation.
- [NTSB CEN10IA397](https://openairdocs.org/ntsb/CEN10IA397.md): Bell 206 · Gulf of Mexico, LA · Incident · No injuries · Incident investigation · Final report · Jul 12, 2010 · N523RL · Minor damage
  > Improper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.
- [NTSB CEN10CA352](https://openairdocs.org/ntsb/CEN10CA352.md): Aerospatiale AS350 · Lake Charles, LA · Accident · No injuries · Data collection · Final report · Jun 26, 2010 · N191EH · Substantial damage
  > The flight instructor’s inadvertent entry into ground resonance when demonstrating a hydraulic failure running landing, which resulted in substantial damage to the helicopter. Contributing to the accident was the pilot's and instructor pilot's failure to…
- [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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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