Skip to content

NTSB investigations: Smith AEROSTAR 601P

67 cases on aircraft the registry lists as Smith AEROSTAR 601P. 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360608')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360608'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360608'))
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 LAX84FA049Accident · No injuriesField investigationFinal reportPiper 601P · Helendale, CAThe pilot stated that during cruise flight the right engine manifold pressure fell to zero. The engine was feathered and set up for single engine performance but the acft continued to descend. Suitable airports were flown over during the descent and the acft…Nov 6, 1983 · N9774Q · Substantial damage NTSB ATL84LA032Accident · No injuriesLimited investigationFinal reportPiper PA-61P · Norfolk, VAThe plt stated that during the takeoff roll the airspeed had accelerated through 128 KTS, but as the takeoff continued the airspeed dropped to 115 KTS & remained between 100-115 KTS. After rotation the acft would not climb or accelerate above 100-115 KTS. The…Oct 29, 1983 · N9531Q · Substantial damage NTSB LAX83FA104Accident · 5 fatalField investigationFinal reportPiper 601P · San Diego, CAWhile taking off, the acft climbed aprx 100 to 200 ft, then began loosing alt. During a forced landing on a street, it hit a parked car & a light pole & burst in flames. The plt, who later expired, said that neither eng developed full power (2575 RPM). He…Feb 18, 1983 · N90353 · Destroyed NTSB MIA83FA046Accident · 3 fatalField investigationFinal reportPiper PA-601P · Valparaiso, FLTwo minutes after takeoff the plt reported a loss of the left eng. He was immediately cleared for a landing at eglin afb. While maneuvering for a landing the left eng & wing separated from the acft. The eng was separated from the wing & showed evidence of in…Dec 9, 1982 · N90692 · Destroyed NTSB NYC83FA004Accident · 1 fatalField investigationFinal reportTed Smith 601P · Augusta, MEPilot lost control of his aircraft during low altitude maneuvers to align the aircraft for landing. The low ceiling and rising terrain around the airport influenced the pilots decisions to make tight turns at low altitude. The aircraft was stalled and rolled…Oct 29, 1982 · N90439 · Destroyed NTSB MIA82FA120Accident · 1 fatalField investigationFinal reportPiper P-60-601P · Titusville, FLShortly after takeoff witnesses observed the acft in a steep left bank descending until it crashed approximately 1200 ftnw of the departure end of the rwy. According to the pax the initial climb distracting the attention of the plt who lostcontrol of the acft…May 18, 1982 · N90702 · Destroyed NTSB LAX82FUQ03Accident · No injuriesClosedPiper 601P · Burbank, CANov 9, 1981 · N9774Q · Substantial damage NTSB NYC81FA062Accident · 2 fatalClosedAerostar 601P · Oxford, CTJun 22, 1981 · N86BW · Destroyed NTSB MIA81FLA11Accident · No injuriesClosedAerostar 601P · Gainesville, FLDec 12, 1980 · N90370 · Substantial damage NTSB LAX80FA024Accident · 1 fatalClosedAerostar 601P · Bishop, CADec 9, 1979 · N600WW · Destroyed NTSB DEN79FA030Accident · 4 fatalClosedAerostar 601P · Aspen, COMar 18, 1979 · N35FC · Destroyed NTSB FTW79FA048Accident · 2 fatalClosedAerostar 601P · New Braunfels, TXFeb 16, 1979 · N9779Q · Destroyed NTSB NYC79FA014Accident · 3 fatalClosedAerostar 601P · Hartford, CTNov 28, 1978 · N8999A · Destroyed NTSB NYC78FA023Accident · 2 fatalClosedAerostar 601P · Dubois, PAJan 24, 1978 · N1BE · Destroyed NTSB SEA77FA047Accident · 1 fatalClosedAerostar 601P · Burns, ORAug 12, 1977 · N9578Q · Destroyed NTSB FTW77FPA23Accident · No injuriesClosedAerostar 601T · Addison, TXAug 2, 1977 · N300AM · Substantial damage NTSB SEA77FYK07Accident · Serious injuriesClosedAerostar 601P · Redmond, ORMay 17, 1977 · N90362 · Substantial damage