# Fatal NTSB investigations: Air & Space America 18A

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 CHI03LA133](https://openairdocs.org/ntsb/CHI03LA133.md): Air & Space 18A · South Shore, SD · Accident · 1 fatal · Limited investigation · Final report · May 19, 2003 · N6155S · Destroyed
  > The pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.
- [NTSB MIA00LA133](https://openairdocs.org/ntsb/MIA00LA133.md): Air & Space. 18A · Lakeland, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 13, 2000 · N905AS · Substantial damage
  > The pilot's in-flight loss of control while maneuvering for undetermined reasons resulting in an uncontrolled descent and subsequent in-flight collision with terrain.
- [NTSB MKC76AK082](https://openairdocs.org/ntsb/MKC76AK082.md): Air & Space 18A. · Oxford, KS · Accident · 2 fatal · Closed · Sep 18, 1976 · N73546 · Destroyed
- [NTSB MKC69A0027](https://openairdocs.org/ntsb/MKC69A0027.md): Air-Space 18A · Marion, IA · Accident · 1 fatal · Closed · Oct 20, 1968 · N6105S · Destroyed
- [NTSB MIA67A0014](https://openairdocs.org/ntsb/MIA67A0014.md): Air Space 18A · Arden, NC · Accident · 1 fatal · Closed · Jul 24, 1966 · N6157S · Destroyed
- [NTSB CHI66A0032](https://openairdocs.org/ntsb/CHI66A0032.md): Air Space 18A · Muncie, IN · Accident · 1 fatal · Closed · Oct 7, 1965 · N6138S · 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0440104'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=0440104

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