NTSB investigations: Piper PA-31-325, 1988
6 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\") = 1988
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") = 1988
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 CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…NTSB CHI89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Big Rapids, MIThe pilot stated that he failed to maintain sufficient airspeed and altitude during an IFR circle-to-land maneuver. The pilot reported that when he thought he was going to overshoot final, he tightened up the bank. The aircraft stalled and the left wing…NTSB ATL88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Wilkesboro, NCAfter a normal approach and landing, the left main gear slowly collapsed during the roll out. The aircraft veered to the left, struck a sign off the runway edge and collided with a ditch. The left main gear was found unlocked during postaccident…NTSB NYC88LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · West Seneca, NYLoss of power due to fuel starvation. Contributing factor was adversed weather conditions.NTSB LAX88FA148Accident · 5 fatalField investigationFinal reportPiper PA-31-325 · Orinda, CABefore the acdnt, witnesses observed the acft circling in a valley beneath a low cloud layer & below the surrounding hilltops. They estimated the ceiling was 400' obscured. Two witnesses said the acft entered clouds before it crashed. A 3rd witness, who was a…NTSB NYC88FA087Accident · 3 fatalField investigationFinal reportPiper PA-31-325 · Hamilton Twp., NJThe aircraft disappeared from radar at approximately 1 mile final on a night ILS rwy 13 approach. Radar data indicated that the aircraft completed almost 180 degrees of turn prior to disappearing. The aircraft crashed in a heavily wooded area. No evidence of…