# NTSB investigations: Cassutt III M SPORT

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 MKC83FA084](https://openairdocs.org/ntsb/MKC83FA084.md): Cassutt III M Sport · Hiawatha, KS · Accident · No injuries · Field investigation · Final report · Mar 31, 1983 · N1790 · Substantial damage
  > While en route at 5500 ft MSL, the plt noticed an oil film start to cover the windshield of the home built acft. At that time, he was approaching hiawath, KS, so he diverted to the Hiawatha arpt. By the time he entered the traffic pattern to land, the oil…
- [NTSB UNK77X0108](https://openairdocs.org/ntsb/UNK77X0108.md): Cassutt Sport · Corona, CA · Accident · Serious injuries · Closed · Jun 22, 1977 · N50JE · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('05601E5'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=05601E5

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