NTSB investigations: Piper PA-32RT-300, 1987
6 cases on aircraft the registry lists as Piper PA-32RT-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
| 1978 | 5 |
|---|---|
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 5 |
| 1982 | 4 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 6 |
| 1988 | 1 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 4 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
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 NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB ATL87LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Liberty, NCBfr departing on a ngt flt, the acft was loaded until it was at or near its max gross wt limit. The plt stated that as he was taking off on a 3000' rwy, the eng 'coughed' after the acft had accelerated to about the rotation speed & was aprx 3/4 of the way…NTSB NYC87FA172Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Nantucket, MAThe weather at the Nantucket airport was below the prescribed minima for the ILS approach to runway 24. A blanket broadcast had been made on the air traffic frequencies that the Nantucket weather was below the minima for most users and, thereafter, the…NTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.NTSB DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…NTSB ATL87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Nashville, TNThe plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…