NTSB investigations: Piper AEROSTAR 601P
9 cases on aircraft the registry lists as Piper AEROSTAR 601P, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2001 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7106012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7106012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 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 NYC98FA127Accident · 3 fatalField investigationFinal reportPiper 601P · Martinsburg, PAThe pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.NTSB MIA95FA208Accident · 2 fatalField investigationFinal reportPiper 601P · Rock Hill, SCThe pilot's in-flight loss of aircraft control, due to incapacitation by a heart attack.NTSB NYC94FA065Accident · 2 fatalField investigationFinal reportPiper Aerostar 601P · Limerick, PAThe pilot's failure to ensure that ice was properly removed from the airplane before flight, possibly due to impairment of judgment caused by a prescription drug (valium) that was not approved for use while flying. Factors related to the accident were: the…NTSB NYC93LA183Accident · No injuriesLimited investigationFinal reportPiper PA-601 · Penn Yan, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with an obstacle and the ground. A factor is the pilot's diverted attention.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 CHI90LA023Accident · No injuriesLimited investigationFinal reportPiper 601P · Cincinnati, OHThe pilot failed to maintain adequate airspeed while maneuvering to circle and land, which resulted in an inadvertent stall. Factors related to the accident were: the excessive maneuver (steep turn) and terrain conditions (road and curb) short of the runway.NTSB DEN89FA020Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Laketown, UTThe plt departed salt lake city on a pleasure flt to bear lake to overfly a home that he owned. Witnesses near the acc site stated they saw the acft circle over the house and then depart the area over a ridge of mtns. The acft turned out over the lake and was…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…