# Major NTSB investigations: Lycoming TI0-540 series

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 ERA09MA447](https://openairdocs.org/ntsb/ERA09MA447.md): Piper PA-32R-300 · Hoboken, NJ · Accident · 9 fatal · Class 1 · Major · Final report · Aug 8, 2009 · N71MC · 2 aircraft · Substantial damage
  > (1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…
- [NTSB ANC08MA038](https://openairdocs.org/ntsb/ANC08MA038.md): Piper PA-31-350 · Kodiak, AK · Accident · 6 fatal · Major investigation · Final report · Jan 5, 2008 · N509FN · Substantial damage
  > The failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…
- [NTSB DCA00MA080](https://openairdocs.org/ntsb/DCA00MA080.md): Piper PA-31 Navajo · Burlington Twp., NJ · Accident · 11 fatal · Major investigation · Final report · Aug 9, 2000 · N27944 · 2 aircraft · Destroyed
  > the failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.
- [NTSB ATL86MA087](https://openairdocs.org/ntsb/ATL86MA087.md): Piper PA-32-300 · Andalusia, AL · Accident · 1 fatal · Major investigation · Final report · Mar 7, 1986 · N1099X · Destroyed
  > The accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…
- [NTSB ATL84MA208](https://openairdocs.org/ntsb/ATL84MA208.md): Piper PA-32-300 · Canton, GA · Accident · 5 fatal · Major investigation · Final report · Jun 24, 1984 · N8640N · Destroyed
  > The acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…
- [NTSB DCA82AA007](https://openairdocs.org/ntsb/DCA82AA007.md): Piper PA-31 · Durango, CO · Accident · 4 fatal · Closed · Dec 31, 1981 · N41070 · Destroyed
- [NTSB FTW80AA057](https://openairdocs.org/ntsb/FTW80AA057.md): Piper PA-31 · Houston, TX · Accident · 7 fatal · Closed · Mar 21, 1980 · N59932 · 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41533'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41533&major=1

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