Fatal NTSB investigations: Piper AEROSTAR 602P
10 cases on aircraft the registry lists as Piper AEROSTAR 602P. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2019 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7106014'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7106014'))
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 CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…NTSB LAX08FA028Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · McFarland, CAThe pilot's inadequate preflight preparation and improper fueling procedures that led to fuel exhaustion.NTSB IAD03FA001Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Bradford, PAThe pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.NTSB SEA01WA033Accident · 4 fatalForeign investigationAerostar 602P · Penticton, CanadaNTSB NYC95LA087Accident · 1 fatalLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe pilot's delay in initiating a go-around (aborted landing) and failure to assure that the flaps were properly reset for the go-around. Factors relating to the accident were: the pilot's failure to achieve the proper touchdown point for landing, the wet…NTSB BFO92FA125Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · Georgetown, DEThe pilot's failure to maintain airspeed, while circling to land, resulting in an inadvertent stall. Factors related to the accident were: the pilot's excessive maneuvering of the airplane and his insufficient altitude for recovery from the stall.NTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…NTSB ATL84FA286Accident · 1 fatalField investigationFinal reportPiper 602P · Dayton, TNOn arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen…NTSB DEN83FA044Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Almy, WYBefore departing, the plt obtained a wx briefing & was advised of a SIGMET which forecasted severe turbulence below 18,000 ft, strong up/downdrafts, strong surface winds & wind shear near mountains & in passes. He took off with full fuel tanks & aprx 400 lbs…NTSB FTW82FRA16Accident · 1 fatalFinal reportPiper PA-60-602P · Brenham, TXAircraft during entire roll and initial climb after takeoff had an unusually nose high attitude. Aircraft climbed to about 200 feet AGL then appeared to stall and fall off on left wing. Investigation did not reveal any reason for the unusual attitude.