NTSB investigations: Piper PA-28R-201, 1987
6 cases on aircraft the registry lists as Piper PA-28R-201. 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 | 5 |
|---|---|
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 2 |
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 ('7102816', '7102833'))
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 ('7102816', '7102833'))
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 MIA88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Roseland, FLThe acft was preflighted approx 20 min after refueling with no discrepancies noted. The plt had difficulty starting the acft. Mechanics flushed the acft fuel lines and declared the acft ok. No water was found in the fuel sumps or strainer during the plts…NTSB FTW87LA176Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Houston, TXAccording to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…NTSB ATL87LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Unity, OHThe CFI reported that he reduced pwr to near idle with the throttle, to have his student practice a simulated forced ldg. The engine subsequently lost pwr completely at about 400-500 ft AGL when he attempted to add pwr back so that the student could initiate…NTSB NYC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Falmouth, MAAbout 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…NTSB NYC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lehighton, PADuring takeoff roll, the flight encountered a wind gust and the plt aborted the takeoff at about 1500 feet from the takeoff point. The acft continued to slide off the end of the runway, down a slope and across a road impacting two trees.NTSB ATL87FA104Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Rhine, GAThe non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.