NTSB investigations: Piper PA-34-200T, AR
4 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 2000 | 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\" = 'AR' 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" = 'AR' 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 FTW00LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fayetteville, ARThe failure of the inboard half of the right main landing gear wheel as a result of fatigue.NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…NTSB MKC85FA060Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Mena, ARThe pilot had been cleared for an instrument approach to themena, Arkansas intermountain regional airport. The airplane impacted a mountain side 8 1/2 miles off course.NTSB FTW82DA168Accident · No injuriesFinal reportPiper PA-34-200T · Harrison, ARDuring landing the aircraft porpoised and on the second bounce the nose gear assembly buckled, the windshield support buckled and the right windshield popped partially out of its channel. The pilot regained control and taxied in. The props and engine nacelles…