NTSB investigations: Piper PA-34-200T, WV
8 cases on aircraft the registry lists as Piper PA-34-200T. 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
| 1977 | 1 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 2001 | 1 |
| 2009 | 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\" = 'WV' 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 ('7103406'))
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" = 'WV' 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 ('7103406'))
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 ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…NTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.NTSB BFO93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Williamson, WVA fire in the cockpit area for undetermined reasons.NTSB ATL85IA153Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · White Sulphur, WVDuring VFR ldg apch, pilot noted a vehicle on the left edge of the rwy. The apch was contd and as the ldg flare was started, the pilot and one of his passengers stated that the vehicle started across the rwy in front of them. The pilot pulled the yoke back to…NTSB ATL84IA137Incident · 2 fatalIncident investigationFinal reportPiper PA-34-200T · Parkersburg, WVAfter an unscheduled landing due to the condition of a patient aboard the acft, the acft turned off a taxiway into the grass and stopped. Rescue personnel found the plt incapacitated from a heart attack and collapsed over the controls and the nurse…NTSB ATL81FA045Accident · 1 fatalClosedPiper PA-34 · Morgantown, WVNTSB IAD79FA060Accident · No injuriesClosedMooney M20G · Bluefield, WVNTSB IAD77FA041Accident · 1 fatalClosedPiper PA-34 · Bridgeport, WV