NTSB investigations: Smith AEROSTAR 601P, CA
5 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
| 1979 | 1 |
|---|---|
| 1981 | 1 |
| 1983 | 2 |
| 1992 | 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\" = 'CA' 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" = 'CA' 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 LAX92LA399Accident · No injuriesLimited investigationFinal reportPiper 601P · Bakersfield, CAThe pilot's selection of an inadequate altitude for an intentional low pass. Contributing to the accident was the dusk light conditions, and the pilots improper inflight planning and decision.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…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…NTSB LAX82FUQ03Accident · No injuriesClosedPiper 601P · Burbank, CANTSB LAX80FA024Accident · 1 fatalClosedAerostar 601P · Bishop, CA