# NTSB investigations: Cessna 441: In flight collision with terrain/water

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 CHI87FA009](https://openairdocs.org/ntsb/CHI87FA009.md): Cessna 441 · West Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1986 · N241FW · Destroyed
  > The plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very…
- [NTSB CHI86MA025](https://openairdocs.org/ntsb/CHI86MA025.md): Cessna 441 · Derry, PA · Accident · 5 fatal · Major investigation · Final report · Nov 11, 1985 · N59MD · Destroyed
  > Drg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…
- [NTSB FTW85FA086](https://openairdocs.org/ntsb/FTW85FA086.md): Cessna 441 · Marble Falls, TX · Accident · 1 fatal · Field investigation · Final report · Dec 26, 1984 · N441CM · Destroyed
  > The acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…

## 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 ('2076020')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2076020&occurrence=230

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