# NTSB investigations, LA: Aircraft power plant, general

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 CEN21LA385](https://openairdocs.org/ntsb/CEN21LA385.md): Robinson Helicopter R44 II · New Roads, LA · Accident · No injuries · Class 4 · Limited · Final report · Aug 20, 2021 · N744RB · Destroyed
  > A loss of engine power for reasons that could not be determined due to a lack of available evidence.
- [NTSB CEN21LA358](https://openairdocs.org/ntsb/CEN21LA358.md): Cessna 182 · Patterson, LA · Accident · No injuries · Class 3 · Limited · Final report · Jul 27, 2021 · N148LP · Substantial damage
  > The mechanic’s failure to properly secure the throttle arm rendering it loose and inoperable after takeoff, which resulted in a total loss of engine power.
- [NTSB CEN20LA282](https://openairdocs.org/ntsb/CEN20LA282.md): Robinson R22 · Venice, LA · Accident · No injuries · Class 3 · Limited · Final report · Jul 8, 2020 · N7186K · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB CEN19LA130](https://openairdocs.org/ntsb/CEN19LA130.md): Cessna L19 · Milton, LA · Accident · No injuries · Class 3 · Limited · Final report · Mar 21, 2019 · N13FM · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010500'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010500/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
