NTSB investigations: Piper AEROSTAR 601P, 1984
3 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
| 1967 | 1 |
|---|---|
| 1976 | 1 |
| 1979 | 3 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 SEA84LA126Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Las Vegas, NVThe plt stated he lowered the gear before entering the traffic pattern & noted a down-&-locked indication. He reported that during the landing flare, the gear unsafe horn sounded & he applied power to go around. However, he felt the acft scrap the surface, so…NTSB NYC84MA151Accident · 2 fatalMajor investigationFinal reportPiper PA-60-601P · Cockeysville, MDOn the day of departure the plt had received a 30 min familiarization flt upon completion of the superstar conversion. Emphasis was directed to eng gages, fuel flow & counter, & power settings. The flt was flown at 5,500 ft. the plt then obtained a wx…NTSB SEA84FA031Accident · No injuriesField investigationFinal reportPiper 601P · Garfield, WAThe acft was forced to land on a road due to a fire in the left wing. During the investigation of the accident it was found that the left turbocharger had been removed and reinstalled several times. A clamp on the turbocharger exhaust wasimproperly installed…