NTSB investigations: Piper PA-32R-301
8 cases on aircraft the registry lists as Piper PA-32R-301, 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
| 1985 | 1 |
|---|---|
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 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 ('7103218')
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 ('7103218')
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 ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB ATL04FA023Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spencer, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and the subsequent collision with the ground.NTSB CHI02FA034Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spearville, KSthe pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.NTSB NYC00FA248Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · South Kingstown, RIThe pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB CHI97LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Jefferson City, MOthe pilot's incomplete preflight of the airplane's stabilizer and rudder trim settings for takeoff, his failure to correct for the high pitch during the initial climb, his failure to recover from the bounced landing, and the inadvertent stall. Factors…NTSB CHI97FA200Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · St. Paul, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. Related factors were the pilot's diverted attention and gusty wind conditions.NTSB LAX86LA033Accident · 3 fatalLimited investigationFinal reportPiper PA-32R-301T · San Diego, CAThe flt departed in VFR conditions after a wx briefing which indicated that clear skies and unrestricted visibilty existed and were forecasted at the destination airport. On arrival the plt requested and received clearance for an instrument apch. When the flt…