# NTSB investigations: Lycoming TIO-540-AE2A, CA

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 WPR21LA111](https://openairdocs.org/ntsb/WPR21LA111.md): Piper PA46R-350T · Tehachapi, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Feb 14, 2021 · N40TS · Destroyed
  > The pilot’s encounter with mountain wave activity with severe turbulence, which resulted in a loss of airplane control. Contributing to the accident was the pilot’s failure to obtain a preflight weather briefing.
- [NTSB GAA16CA069](https://openairdocs.org/ntsb/GAA16CA069.md): Piper PA 46-350P · Mammoth, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2015 · N546C · Substantial damage
  > The pilot's decision to takeoff in high crosswind conditions resulting in the inability to maintain an adequate crosswind correction, consequently failing to maintain directional control and departing the runway, and subsequently colliding with fixed airfield…
- [NTSB WPR12LA261](https://openairdocs.org/ntsb/WPR12LA261.md): Piper PA46R-350T · Cameron Park, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 2012 · N488EA · Substantial damage
  > The fatigue failure of the nose landing gear actuator attach foot during the landing roll. Contributing to the accident was the non-compliance with the manufacturer’s service bulletin.
- [NTSB WPR12LA015](https://openairdocs.org/ntsb/WPR12LA015.md): Piper PA46R · Paso Robles, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2011 · N422HP · Substantial damage
  > A loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.

## 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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41999', '40999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41999&state=CA

---
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.
