# NTSB investigations: Aero Commander S2R, 1973

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 MIA74FKG43](https://openairdocs.org/ntsb/MIA74FKG43.md): N.American 600S2R · Albany, GA · Accident · No injuries · Closed · Nov 14, 1973 · N5645X · Substantial damage
- [NTSB FTW74FPA05](https://openairdocs.org/ntsb/FTW74FPA05.md): Aero Comdr S-2R · Waco, TX · Accident · No injuries · Closed · Oct 18, 1973 · N8867Q · Substantial damage
- [NTSB FTW74DPG30](https://openairdocs.org/ntsb/FTW74DPG30.md): Aero Comdr S-2R · Fisher, AR · Accident · No injuries · Closed · Oct 8, 1973 · N5521X · Destroyed
- [NTSB MIA74FKG27](https://openairdocs.org/ntsb/MIA74FKG27.md): Aero Comdr S-2R · Smithville, GA · Accident · No injuries · Closed · Sep 11, 1973 · N8902Q · Substantial damage
- [NTSB MIA74FKG18](https://openairdocs.org/ntsb/MIA74FKG18.md): Aero Comdr S2R · Pineview, GA · Accident · Serious injuries · Closed · Aug 24, 1973 · N8920Q · Destroyed
- [NTSB FTW74FQG09](https://openairdocs.org/ntsb/FTW74FQG09.md): Aero Comdr 600S2R · Dimmitt, TX · Accident · No injuries · Closed · Aug 14, 1973 · N5540X · Substantial damage
- [NTSB FTW74DRG06](https://openairdocs.org/ntsb/FTW74DRG06.md): Aero Comdr S2R · Mission, TX · Accident · No injuries · Closed · Jul 21, 1973 · N5510X · Substantial damage
- [NTSB SEA74FYA02](https://openairdocs.org/ntsb/SEA74FYA02.md): Aero Comdr 600S2R · Homedale, ID · Accident · Minor injuries · Closed · Jul 7, 1973 · N5553X · Substantial damage
- [NTSB CHI74FEC41](https://openairdocs.org/ntsb/CHI74FEC41-201655.md): Aero Comdr 600S2R · Ottowa Lake, MI · Accident · No injuries · Closed · Jun 29, 1973 · N8870Q · Substantial damage
- [NTSB MKC73FTK14](https://openairdocs.org/ntsb/MKC73FTK14.md): Aero Comdr 600S2R · Pierre, SD · Accident · Serious injuries · Closed · Jun 4, 1973 · N39767 · Destroyed
- [NTSB MIA73DKJ58](https://openairdocs.org/ntsb/MIA73DKJ58.md): Aero Comdr 600S2C · Camden, AL · Accident · No injuries · Closed · May 1, 1973 · N5598X · Substantial damage
- [NTSB MIA73FKT82](https://openairdocs.org/ntsb/MIA73FKT82.md): Aero Comdr 600S2R · Ft Myers, FL · Accident · Minor injuries · Closed · Apr 17, 1973 · N8805Q · Substantial damage
- [NTSB MIA73DKT68](https://openairdocs.org/ntsb/MIA73DKT68.md): Aero Comdr S-2R · Loxahatchee, FL · Accident · No injuries · Closed · Feb 21, 1973 · N8977Q · Substantial damage
- [NTSB MIA73DKT64](https://openairdocs.org/ntsb/MIA73DKT64.md): Aero Comdr S-2R · Atlantic O.North (Atlantic Ocean) · Accident · 1 fatal · Closed · Jan 6, 1973 · N8953Q · 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") = 1973
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0143022'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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