NTSB investigations: Smith AEROSTAR 601P, TX
8 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.
Cases per year
| 1977 | 1 |
|---|---|
| 1979 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2010 | 1 |
| 2012 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND 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" DESCRun 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 CEN14FA494Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Austin, TXThe pilot's failure to maintain sufficient clearance from trees during the single-engine landing approach. Contributing to the accident was the loss of power in the left engine due to an improperly installed rubber boot that became dislodged and was then…NTSB CEN12CA202Accident · No injuriesData collectionFinal reportSmith Aerostar 601P · Casterville, TXThe pilot did not maintain control of the airplane while circling to land.NTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.NTSB DFW05CA247Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Mexia, TXThe pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB DFW05CA201Accident · Minor injuriesData collectionFinal reportSmith Aerostar 601P · Sinton, TXThe pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…NTSB FTW04FA204Accident · 6 fatalField investigationFinal reportPiper PA-60-601P · Lakeway, TXThe pilot's failure to successfully perform a short-field takeoff and his subsequent failure to maintain adequate airspeed during climbout, which resulted in an aerodynamic stall.NTSB FTW79FA048Accident · 2 fatalClosedAerostar 601P · New Braunfels, TXNTSB FTW77FPA23Accident · No injuriesClosedAerostar 601T · Addison, TX