# NTSB investigations: Aero Commander 100, 1971

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 DEN72FQD20](https://openairdocs.org/ntsb/DEN72FQD20.md): Aero-Comdr 100 · Deming, NM · Accident · Minor injuries · Closed · Dec 24, 1971 · N4127X · Substantial damage
- [NTSB OAK72FVW19](https://openairdocs.org/ntsb/OAK72FVW19.md): Aero Comdr 100 · Mercury, NV · Accident · No injuries · Closed · Nov 22, 1971 · N3697X · Substantial damage
- [NTSB MKC72DCG27](https://openairdocs.org/ntsb/MKC72DCG27.md): Aero Comdr 100 · Grain Valley, MO · Accident · Minor injuries · Closed · Oct 6, 1971 · N3637X · Substantial damage
- [NTSB NYC72FHA15](https://openairdocs.org/ntsb/NYC72FHA15.md): Aero Comdr 100 · Warrington, PA · Accident · No injuries · Closed · Sep 3, 1971 · N3859X · Substantial damage
- [NTSB MIA72FKG06](https://openairdocs.org/ntsb/MIA72FKG06.md): Aero Comdr 100 · Albany, GA · Accident · No injuries · Closed · Jul 13, 1971 · N3625X · Substantial damage
- [NTSB DEN71FTM31](https://openairdocs.org/ntsb/DEN71FTM31.md): Aero Comdr 100 · Granger, UT · Accident · Minor injuries · Closed · Jun 17, 1971 · N2947T · Substantial damage
- [NTSB MIA71FLG30](https://openairdocs.org/ntsb/MIA71FLG30.md): Aero Comdr 100 · Allendale, SC · Accident · Serious injuries · Closed · Jun 14, 1971 · N3624X · Destroyed
- [NTSB NYC71DGM48](https://openairdocs.org/ntsb/NYC71DGM48.md): Aero Comdr 100 · Connellsville, PA · Accident · No injuries · Closed · May 30, 1971 · N4102X · Substantial damage
- [NTSB CHI71DEE66](https://openairdocs.org/ntsb/CHI71DEE66.md): Aero-Comdr 100 · Mendota, IL · Accident · No injuries · Closed · Apr 17, 1971 · N2952T · Substantial damage
- [NTSB NYC71FNC25](https://openairdocs.org/ntsb/NYC71FNC25-160950.md): Aero Comdr 100 · North Havrhill, NH · Accident · No injuries · Closed · Apr 11, 1971 · N3864X · Substantial damage
- [NTSB MKC71FDM50](https://openairdocs.org/ntsb/MKC71FDM50.md): Aero Comdr 100 · Vineland, MN · Accident · Minor injuries · Closed · Mar 26, 1971 · N5503M · Destroyed
- [NTSB MKC71DCJ48](https://openairdocs.org/ntsb/MKC71DCJ48.md): Aero Cmdr 100 · Columbus, NE · Accident · No injuries · Closed · Feb 17, 1971 · N3780X · Substantial damage
- [NTSB CHI71DDJ38](https://openairdocs.org/ntsb/CHI71DDJ38.md): Aero Comdr 100 · New Holstein, WI · Accident · No injuries · Closed · Jan 21, 1971 · N3623X · Substantial damage
- [NTSB MKC71DCD52](https://openairdocs.org/ntsb/MKC71DCD52.md): Aero Comdr 100 · Shenandoah, IA · Accident · No injuries · Closed · Jan 16, 1971 · N5539M · Substantial damage
- [NTSB SEA71FWD26](https://openairdocs.org/ntsb/SEA71FWD26.md): Aero Comdr 100 · Vashon Isl, WA · Accident · Minor injuries · Closed · Jan 3, 1971 · N3768X · Substantial damage
- [NTSB MIA71AM055](https://openairdocs.org/ntsb/MIA71AM055.md): Aero Comdr 100 · Boca Raton, FL · Accident · 2 fatal · Closed · Jan 3, 1971 · N5534M · 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 year(c."eventDate") = 1971
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0140202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0140202&year=1971

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