NTSB investigations: Piper PA-28R-201T, 1984
8 cases on aircraft the registry lists as Piper PA-28R-201T. 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 | 10 |
| 1979 | 6 |
| 1980 | 8 |
| 1981 | 9 |
| 1982 | 8 |
| 1983 | 6 |
| 1984 | 8 |
| 1985 | 3 |
| 1987 | 3 |
| 1988 | 8 |
| 1989 | 1 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 8 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 3 |
| 2024 | 1 |
| 2025 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813'))
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 MKC85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Norfolk, NEThe plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…NTSB ATL85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Madison, WVFollowing a loss of eng power during a x-country flt, the plt landed on a bridge. During the ldg roll the wing struck a pole. Post crash examination of the engine disclosed that the camshaft gear teeth suffered fatigue failure.NTSB MIA85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Gainesville, FLThe acft collided with a tractor during taxi. The plt stated that he saw the tractor and thought there was room to pass.NTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…NTSB ATL84LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Henderson, KYThe acft was damaged in an off arpt forced landing after the engine lost oil pressure, overheated and quit running. The plt said she checked the oil quantity at 7 1/2 qts before takeoff for the local flt. The engine overheated after about one hour of flt…NTSB MIA84LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · St. Augustine, FLThe plt reported the eng lost partial power shortly after becoming airborne. He attempted to return to the field & land on rwy 24, but he missed the rwy & landed hard north of the rwy. Disassembly of the eng fuel pump revealed that the o-ring sealing the…NTSB LAX84LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hayward, CACompleting a night instrument private pilot biennial flight reivew, the acft was issued landing clearance for rwy 28L. On short final the pvt plt began to align the acft to land on rwy 28R which was closed for maintenance & not illuminated. The instructor plt…NTSB CHI84LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · East St. Louis, ILThe pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the…