NTSB investigations: Smith AEROSTAR 601P, FL
9 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
| 1980 | 1 |
|---|---|
| 1982 | 2 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 2002 | 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\" = 'FL' 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" = 'FL' 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 MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.NTSB MIA96LA149Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Orlando, FLloss of power in both engines for undetermined reason(s).NTSB MIA90FA022Accident · 1 fatalField investigationFinal reportPiper 601P · Fort Myers, FLFailure of the pilot to properly follow the IFR procedure and to identify the decision height. Factors related to the accident were: the adverse weather conditions, darkness, the pilot's lack of visual perception without the approach lights, and tree(s) in…NTSB MIA89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Fort Pierce, FLAir traffic controllers stated that while the aircraft was on short final they noticed that the gear on the aircraft was not extended. They attempted to contact the pilot but he never responded. The pilot stated that he failed to extend the landing gear prior…NTSB MIA87LA021Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Jacksonville, FLWhile in cruise flight, the pilot noted that the left engine began losing power and oil pressure. He stated that he then shut down the engine and feathered the propeller. He declared an emergency and descended to land. While on final approach, he lowered the…NTSB MIA86LA145Accident · No injuriesLimited investigationFinal reportPiper 601P · Miami, FLNearing completion of an international flt of nearly 5 hrs duration, the flt advised ATC they were low on fuel & would like vectors to the nearest arpt. The flt was unable to make the arpt & a forced ldg was made in the everglades aprx 6 mi from the arpt. An…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…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…NTSB MIA81FLA11Accident · No injuriesClosedAerostar 601P · Gainesville, FL