NTSB investigations: Smith AEROSTAR 600, FL
14 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.
Cases per year
| 1975 | 1 |
|---|---|
| 1978 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 2 |
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 ('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."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 ('8360602'))
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 MIA94LA023Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Orlando, FLThe failure of the pilot-in-command of the other aircraft to maintain a visual lookout and clearance between aircraft.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.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.NTSB MIA87IA246Incident · No injuriesIncident investigationFinal reportPiper PA-60 · W.Palm Beach, FLThe plt stated that on landing after rolling about 1000 ft. the scissors on the right main landing gear strut disconnected causing the wheel assembly to rotate & skid. He then applied heavy left brake to keep the acft straight on the runway, but the main gear…NTSB MIA87FA004Accident · No injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Jacksonville, FLReportedly, during an ILS approach to land, the pilot did not use the company approved checklist and landed with the gear retracted.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…NTSB MIA86LA130Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Panama City, FLThe plt stated that on his apch he had a gear down & locked indication but on landing rollout, the nose gear completely collapsed and the acft slid to a stop on the rwy. Post accident examination of the landing gear system revealed that the nose gear…NTSB MIA85IA242Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar PA-600 · Sarasota, FLWhile on takeoff initial climb the right engine hydraulic pump shaft failed and the pilot did not receive a positive uplock. The pilot then selected gear down and did obtain a gear down indication. On landing the nose gear collapsed. Nose gear down locks were…NTSB MIA85LA131Accident · No injuriesLimited investigationFinal reportPiper Aerostar 600 · Fort Myers, FLThe acft landed with both main wheel brakes locked as evidenced by skid marks in the touchdown zone of the rwy. After aprx 200 feet of skidding the left brake released and due to the right brake not releasing the plt lost control. The acft veered off the…NTSB MIA85IA021Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Jacksonville, FLThe acft swerved left off the rwy during the landing roll. An exam of the left main landing gear strut revealed that the collar had failed permitting the lower portion of the landing gear strut to shift. The shift was transmitted tothe tire causing it to…NTSB MIA83LA200Accident · No injuriesLimited investigationFinal reportAerostar 600 · Pahokee, FLThe acft departed ft. pierce, FL on a VFR flight to key west, FL, and ditched in lake okeechobee. While climbing THROUGH5000 ft the left engine lost power and started surging, the oil temperature gauge failed and smoke came from under the instrument panel.…NTSB MIA81FA070Accident · No injuriesClosedAerostar 600 · Orlando, FLNTSB MIA78FA105Accident · 2 fatalClosedTed Smith 600 · Jacksonville, FLNTSB MIA76AM036Accident · 2 fatalClosedTed Smith 600 · Bunnell, FL