NTSB investigations: Piper AEROSTAR 601P, FL
6 cases on aircraft the registry lists as Piper 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 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2001 | 1 |
| 2007 | 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 ('7106012'))
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 ('7106012'))
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 NYC07LA183Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Fort Lauderdale, FLThe total loss of power in one engine during approach, due to a fatigue fracture of the crankshaft.NTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…NTSB MIA90FA033Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Orlando, FLLoss of aircraft control during takeoff for an unknown reason which resulted in a collision with the ground.NTSB MIA88FA261Accident · 3 fatalField investigationFinal reportPiper PA-60 · Pembroke Pines, FLWitnesses stated that the acft used almost the entire length of the runway during the ground run. After rotation & gear retraction, it continued to climb in a nose high attitude to aprx 100-150 feet, then it started an aprx 20 degree bank to the right until…NTSB MIA83LA111Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Tampa, FLThe aircraft departed runway 18L at Tampa intl airport. Shortly after takeoff the pilot reported to the control tower that the main cabin door was open and requested landing instructions. The pilot stated he was holding the door and trying to fly the aircraft…NTSB MIA81FA007Accident · 2 fatalClosedPiper 601P · Wilma, FL