NTSB investigations: Piper PA-32R-300, NC
15 cases on aircraft the registry lists as Piper PA-32R-300. 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
| 1980 | 2 |
|---|---|
| 1981 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2018 | 1 |
| 2022 | 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.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103213'))
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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103213'))
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 ERA22LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Washington, NCThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB ERA18FA197Accident · 2 fatalField investigationFinal reportPiper PA32R · Lincolnton, NCThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing the accident was the pilot's self-induced pressure to complete…NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.NTSB ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…NTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB MIA01LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Wilmington, NCA total loss of engine power due to the failure of maintenance to properly secure the fuel selector cover, resulting in the pilot inadvertently selecting "off" instead of "left" tank, and the subsequent forced landing to uneven terrain.NTSB ATL95LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Burnsville, NCThe pilot's failure to complete the before-landing checklist to ensure that the landing gear was extended.NTSB ATL94FA171Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Glenville, NCThe fatigue failure of #4 intake valve. A factor was hilly terrain.NTSB ATL93FA151Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Laurinburg, NCThe pilot's VFR flight into instrument meteorological conditions (IMC), failure to maintain control of the aircraft after becoming spatially disoriented, and inadvertently exceeding the design stress limits of the aircraft. Factors related to the accident…NTSB ATL91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Boone, NCThe pilot's failure to follow the manufacturer's procedures related to takeoff performance. Factors in the accident were: the high density altitude, the high obstructions, and the pilot's lack of expereince with takeoff operations at high density altitude.NTSB ATL90LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Morrisville, NCLoss of engine power for an unknown reason. The dark night and instrument conditions contributed to the accident.NTSB ATL81FKM14Accident · Serious injuriesClosedPiper PA-32R · Asheville, NCNTSB ATL80IA089Incident · No injuriesClosedPiper PA-32 · Raeford, NCNTSB IAD80FLJ10Accident · No injuriesClosedPiper PA-32R · Redford, NC