NTSB investigations: Piper PA-31-325, 1985
2 cases on aircraft the registry lists as Piper PA-31-325. 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
| 1968 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 4 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1988 | 6 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2000 | 3 |
| 2002 | 2 |
| 2009 | 1 |
| 2012 | 2 |
| 2016 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103105'))
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 year(c."eventDate") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103105'))
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 FTW86LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-325 · Junction, TXDuring initial climb after takeoff the pilot noticed oil streaming out from the oil filler access door on the right engine cowling. He elected to continue climbing and make a tear drop turn back to the airport and land in the opposite direction from which he…NTSB MIA85FA088Accident · No injuriesField investigationFinal reportPiper PA-23-250 · St. CroixWhen starting descent the pilot stated the right eng failed & the propeller feathered by itself. The pilot then switchedthe left fuel tank selector to the left aux tank. Shortly thereafter, the left engine failed. The pilot declared a mayday to St. Croix twr…