# Major NTSB investigations: Lycoming 0-320 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 WPR15MA243](https://openairdocs.org/ntsb/WPR15MA243.md): Cessna 172M · San Diego, CA · Accident · 5 fatal · Major investigation · Final report · Aug 16, 2015 · N1285U · 2 aircraft · Destroyed
  > The local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…
- [NTSB DEN03MA035](https://openairdocs.org/ntsb/DEN03MA035.md): Piper PA-31T · Denver, CO · Accident · 5 fatal · Major investigation · Final report · Jan 25, 2003 · N360LL · 2 aircraft · Destroyed
  > Both pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.
- [NTSB DCA87MA023](https://openairdocs.org/ntsb/DCA87MA023.md): Cessna 172N · Oakland, CA · Accident · 3 fatal · Class 1 · Major · Final report · Mar 31, 1987 · N75584 · 2 aircraft · Destroyed
  > At 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…
- [NTSB DCA87MA010](https://openairdocs.org/ntsb/DCA87MA010.md): Piper PA-23-150 · Tampa, FL · Accident · 1 fatal · Class 1 · Major · Final report · Nov 6, 1986 · N2185P · 2 aircraft · Destroyed
  > At aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…
- [NTSB ATL86MA114](https://openairdocs.org/ntsb/ATL86MA114.md): Bell 206L-3 · Holliston, MA · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1986 · N302MC · 2 aircraft · Destroyed
  > The Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a…
- [NTSB ANC74DAG18](https://openairdocs.org/ntsb/ANC74DAG18-134460.md): Piper PA-28 · Aniak, AK · Accident · No injuries · Closed · Aug 19, 1974 · N6141W · 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.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 ('41508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41508&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.