# NTSB investigations: Lycoming IGSO-540-B1A, TN

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 ATL84FLT04](https://openairdocs.org/ntsb/ATL84FLT04.md): Aero Commander 680F · Charleston, TN · Accident · Serious injuries · Final report · Feb 20, 1984 · N6000F · Substantial damage
  > The acft crashed during a ferry flight and the plt could not recall the circumstances of the flight. Investigation revealed that the acft had been parked on the service ramp for nearly two years without being used. The last annual inspection was recorded on…
- [NTSB IAD78FLT10](https://openairdocs.org/ntsb/IAD78FLT10.md): Rockwell 680F · Memphis, TN · Accident · Serious injuries · Closed · Aug 22, 1978 · N680RG · Destroyed
- [NTSB UNK64X3971](https://openairdocs.org/ntsb/UNK64X3971.md): Beechcraft 65-80 · Seward Afb, TN · Accident · No injuries · Closed · Sep 13, 1964 · N6811Q · Substantial damage

## 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" = 'TN' 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 ('41535'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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