Skip to content

Fatal NTSB investigations: Smith AEROSTAR 600

19 cases on aircraft the registry lists as Smith AEROSTAR 600. 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

19742026

Where

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 ('8360602')) 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 ('8360602'))
  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 ('8360602'))
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 ERA22FA351Accident · 2 fatalClass 3 · FieldFinal reportSmith Aerostar 600 · South Haven Charter Township, MIA loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.Aug 2, 2022 · N9784Q · Destroyed NTSB ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaSep 11, 2015 · N164HH · Destroyed NTSB WAS05WA004Accident · 5 fatalForeign investigationAerostar 600 · Cornelia, South AfricaJan 18, 2005 · N7478S · Destroyed NTSB LAX00LA038Accident · 1 fatalLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Avalon, CAThe pilot's in-flight loss of control due to physical incapacitation from sudden cardiac death secondary to an acute myocardial infarction.Nov 21, 1999 · N97CC · Destroyed NTSB NYC98FA179Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar TS-600 · Marietta, PAThe failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…Sep 5, 1998 · N600JB · Destroyed NTSB NYC98FA092Accident · 1 fatalField investigationFinal reportAerostar 600A · Mapleton, MEthe failure of the pilot to maintain control of the airplane during takeoff for undetermined reasons.Apr 10, 1998 · N7527S · Destroyed NTSB DEN93FA031Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Panama City, FLThe pilot's poorly planned approach to the runway following an instrument approach resulting in a loss of control.Mar 3, 1993 · N90399 · Destroyed NTSB FTW91FA045Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Fort Chaffee, ARThe pilot's operation of the aircraft with known deficiencies in equipment. Factors were the improper overhaul of the engines by other maintenance personnel resulting in oil loss, deteriorated engine performance, and unsuitable terrain.Mar 1, 1991 · N7488S · Destroyed NTSB MIA90FA021Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Apopka, FLFailure of the pilot to maintain altitude/clearance above the water, while proceeding over a lake and approaching the vicinity of the airport.Nov 2, 1989 · N7526S · Destroyed NTSB MIA88FA201Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Catano, PRAs the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up…Jun 20, 1988 · N90360 · Destroyed NTSB CHI88FA010Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Oshtemo Townshp, MIThe aircraft was at cruise altitude (9,000 feet) for approximately 20 minutes when the pilot reported the loss of right engine power. Chicago ARTCC reported the closest airport was kalamazoo, 28 miles west. The aircraft began to descend and at 0330:53 chicago…Oct 23, 1987 · N554AC · Destroyed NTSB MIA87FA002Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Tallahassee, FLWitnesses stated seeing the acft enter a left downwind apch to rwy 16, turn base to final normally then veer to the left of the runway in a nose high attitude & disappear behind a line of trees & crash aprx 500 feet east of rwy 16. Post crash examination of…Oct 2, 1986 · N217HM · Destroyed NTSB ATL86FA147Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Dickson, TNThe acft contacted electrical wires and trees shortly after takeoff. The acft then descended to impact with the terrain. Examination of the wreckage revealed the elevator trim actuator rod was extended 2.5 inches which correlates with a full nose down…May 29, 1986 · N260A · Destroyed NTSB LAX82FA161Accident · 3 fatalField investigationFinal reportSmith Aerostar 600 · Burbank, CAThe aircraft departed into IFR conditions with a non-instrument rated pilot in the left front seat and his wife, an instrument rated pilot, in the right front seat. After the pilot reported climbing through 2800 ft MSL, the radar controller observed that the…May 8, 1982 · N8007J · Destroyed NTSB MKC79FA024Accident · 1 fatalClosedAerostar 600 · Sikeston, MOMar 22, 1979 · N90501 · Destroyed NTSB MIA78FA105Accident · 2 fatalClosedTed Smith 600 · Jacksonville, FLJul 19, 1978 · N868Y · Destroyed NTSB IAD76AI072Accident · 2 fatalClosedAerostar 600 · Morganfield, KYMay 8, 1976 · N7549S · Destroyed NTSB MIA76AM036Accident · 2 fatalClosedTed Smith 600 · Bunnell, FLOct 28, 1975 · N90390 · Destroyed NTSB NYC74AN110Accident · 3 fatalClosedAerostar 600 · Perkasie, PAJun 15, 1974 · N14ES · Destroyed