NTSB investigations: Piper PA-32-300
19 cases on aircraft the registry lists as Piper PA-32-300, where the first occurrence was “In flight collision with terrain/water”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1993 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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 ('7103212')
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\" = 230))
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 ('7103212')
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" = 230))
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 CHI06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Worthington, MNThe missed approach not performed by the pilot and the directional control not maintained by the pilot during landing. Contributing factors were the crosswind, wind information not available due to inoperative meteorological equipment, and a Notices to Airman…NTSB CHI05FA260Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Wabash, INThe pilot's spatial disorientation that resulted in his failure to maintain clearance from terrain. Factors to the accident were the pilot's lack of recent night experience and the hazy night conditions.NTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…NTSB ANC03LA044Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kotzebue, AKThe pilot's failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with terrain during cruise flight. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB DEN01LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Angel Fire, NMthe pilot's failure to maintain control of the airplane during landing. Contributing factors were the crosswind, the pilot exceeding the published maximum demonstrated crosswind component, and the snow bank.NTSB SEA00FA080Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Fort Smith, MTThe pilot's failure to maintain clearance from the terrain. Factors include low ceilings, snow, rain, and rising, mountainous/hilly terrain.NTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…NTSB IAD97FA001Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Brandywine, MDThe pilots failure to maintain his assigned altitude in IFR conditions. A related factor was the failure of the radar controller to prevent the descent of N2881W to an altitude below the minimum vectoring altitude. Additionally, the controller's failure to…NTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.NTSB LAX94FA005Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Kernville, CAthe pilot's inadvertent flight into a box canyon and his failure to attain a safe altitude. A factor in the accident was the pilot's lack of familiarity with the geographic area.NTSB LAX89FA013Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Santa Maria, CAThe pilot failed to follow the correct I.f.r. procedures whereas he descended below the final approach fix altitude.NTSB ANC88LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Cold Bay, AKThe ATP certificated pilot in command departed on a solo, cargo-only air-taxi flight at 1104 a.k.s.t. for a destination 83SM to the n.e. the pilot was normally assigned to copilot duties on a multi-engined airplane, and was not familiar with the terrain he…NTSB NYC87FA262Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Montoursville, PAThe plt initiated the ILS approach and acknowledged a frequency change. The acft was found on a steep hill one mile south of the airport. No evidence of an engine or control system malfunction was found. It appeared that the pilot made a missed approach and…NTSB MIA87LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · St. ThomasThe pilot stated that as he lifted off the aircraft encountered a gust of wind. The pilot lost control of the aircraft and it struck a displaced threshold sign and the ground.NTSB SEA85FA203Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Bridge, IDAt 1445 MDT, the 60 yr old plt departed on a routine, VFR, repositioning flt which he had frequently flown before. After takeoff, he leveled the acft at 9500 ft on a direct course toward the destination. While en route at about 1515, the acft began a shallow…NTSB ATL85FA055Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burlington, KYAcft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded…NTSB NYC85LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Prospectville, PAPlt stated he allowed the acft to go low on final approach. Collision with terrain separated the landing gear but plt recovered control as acft rebounded and executed a successful go-around. Plt diverted with escort to nearby military arpt where CFR…NTSB MIA83LA012Accident · 2 fatalLimited investigationFinal reportPiper PA-32-300 · Near St. CroixThe non-instrument rated pilot departed st Croix, VI at about 2000 local time on a VFR flight to san juan, PR. The weather was VFR, but it was a dark night. The aircraft failed to arrive at its destination and a search was initiated. About 10 miles northwest…NTSB ANC82DA063Accident · Minor injuriesFinal reportPiper PA-32-300 · Mckinley Nat'L., AKThe pilot was flying over one glacier at about 700 feet AGL and turned to fly to another upslope glacier. He encountereda downdraft and was unable to climb enough to avoid colliding with the glacier. The elevation of the crash site was about 6600 ft MSL.