NTSB investigations: Piper PA-28R-201T, 1982
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\") = 1982
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") = 1982
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 ATL83FID02Accident · 2 fatalFinal reportPiper PA-28R · Chesapeake, VAThe aircraft had previously been flown from orlando, FL to norfolk/Chesapeake, VA. While the original non-instrument rated pilot was in Virginia, the weather deteriorated, so the owner flew up from orlando (via the airlines) to fly the original occupants back…NTSB CHI83FA044Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Evart, MIThe aircraft flew into trees during low flight in IMC weather. The pilot had received a weather briefing and was instrument rated but was not on an IFR flight plan. IMC weather was forecast for the route planned. Hunters heard the aircraft fly over at a low…NTSB ATL82FA251Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · State Road, NCThe plt reported his engine had quit. ARTCC advised the plt that the nearest arpt was elking at 12 mi. Several minutes later he reported that he didn't think he could make the arpt & was going to look for a field. Witnesses observed the landing gear down…NTSB ANC82DAG60Accident · 3 fatalFinal reportPiper PA-28R · Dillingham, AKPilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…NTSB MIA82DA157Accident · 4 fatalFinal reportPiper PA-28R-201T · West Of Cross C, FLAt about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.…NTSB DEN82DA055Accident · No injuriesFinal reportPiper PA-28R-201T · Longmont, COThe pilot reported that he made a normal approach and touched down in the landing zone as defined by the VASI. However, during the landing roll, the right brake was inoperative. He was unable to stop on the remaining runway while rolling straight ahead. About…NTSB LAX82IA062Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201T · Truckee, CADuring the landing roll the aircraft veered sharply to the left and struck a snowbank, collapsing the nose and left main landing gear. Inspection of the runway revealed the presence of several large ice chunks adhering to the runway surface.NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…