# NTSB investigations: Lycoming R680E series, VA

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 ERA25LA024](https://openairdocs.org/ntsb/ERA25LA024.md): Boeing A75N1(PT17) · Williamsburg, VA · Accident · No injuries · Class 4 · Limited · Final report · Oct 21, 2024 · N300E · Substantial damage
  > The pilot’s failure to maintain directional control on landing.
- [NTSB ERA09CA374](https://openairdocs.org/ntsb/ERA09CA374.md): Boeing A75N1(PT17) · Quinton, VA · Accident · No injuries · Data collection · Final report · Jun 29, 2009 · N38978 · Substantial damage
  > A loss of directional control on landing for undetermined reasons.
- [NTSB BFO87LA067](https://openairdocs.org/ntsb/BFO87LA067.md): Stinson SR8B · Lynchburg, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N16182 · Substantial damage
  > The pilot diverted to falwell airport due to deteriorating weather and uneven fuel consumption indication between the left and right fuel tanks. During the landing approach for runway 28 the pilot noted the upslope of the runway surface. The pilot misjudged…
- [NTSB NYC73DIA02](https://openairdocs.org/ntsb/NYC73DIA02.md): Stearman A75N1 · Warrenton, VA · Accident · No injuries · Closed · Jul 1, 1972 · N66442 · 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" = 'VA' 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 ('41545'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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