Fatal NTSB investigations: Smith AEROSTAR 601

13 cases on aircraft the registry lists as Smith AEROSTAR 601. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

Fatal NTSB investigations: Smith AEROSTAR 601 per year, 1971–2026: 13 cases
1971	1
1973	2
1974	1
1977	1
1978	1
1979	1
1983	1
1985	1
1989	1
2000	1
2017	1
2020	1

Where

Open the map

Latest cases

Query with 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 ('8360606')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('8360606'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 ('8360606'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN20LA160Accident · 1 fatalClass 3 · LimitedFinal reportAerostar 601 · Craig, COThe student pilot’s flight into terrain for undetermined reasons.Apr 24, 2020 · N601X · Destroyed NTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.Dec 10, 2017 · N7529S · Destroyed NTSB DEN00FA086Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Estes Park, COA descent below the surrounding terrain, by the pilot, in IMC conditions. Factors were high mountainous terrain, clouds, inaccurate weather evaluation by the pilot, and the pilot's flight into IMC conditions.Apr 30, 2000 · N7421S · Destroyed NTSB FTW89FA089Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601 · New Iberia, LAThe pilot failed to maintain a proper climb immediately after takeoff. Contributing to the accident was excessive manifold pressure indications for the left engine. The pilot's diverted attention in dealing with that condition most probably resulted in the…May 4, 1989 · N90619 · Destroyed NTSB LAX85FA169Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601 · Sepulveda, CAThe acft crashed into a residence 2 miles short of the rwy after loss of pwr on the left eng. This eng was feathered, the gear was extended, but the flaps remained up as the acft continued the lndg approach. Post acc investigation revealed no irregularities…Mar 7, 1985 · N777PL · Destroyed NTSB FTW83FA252Accident · 1 fatalField investigationFinal reportPiper PA-60 · New Orleans, LAWitnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had…May 30, 1983 · N52AC · Destroyed NTSB CHI79FA025Accident · 4 fatalClosedAerostar 601 · Grand Rapids, MIJan 19, 1979 · N7437S · Destroyed NTSB MIA78DA074Accident · 1 fatalClosedTed Smith 601 · Missing AircraftApr 27, 1978 · N555BU · Destroyed NTSB OAK77FA051Accident · 4 fatalClosedAerostar 601 · Little Norway, CAAug 26, 1977 · N7481S · 2 aircraft · Substantial damage NTSB SEA74AS038Accident · 3 fatalClosedAerostar 601 · La Grande, ORApr 11, 1974 · N7474S · Destroyed NTSB CHI74AC038Accident · 2 fatalClosedAerostar 601 · Raymond, OHNov 3, 1973 · N7430S · Destroyed NTSB NYC73AN147Accident · 2 fatalClosedTed Smith 601 · Hamburg, NYJun 1, 1973 · N711ED · Destroyed NTSB FTW72AF007Accident · 2 fatalClosedAerostar 601 · Fort Worth, TXJul 22, 1971 · N7480S · Destroyed