NTSB investigations: Piper PA-28RT-201, 1982
5 cases on aircraft the registry lists as Piper PA-28RT-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
| 1980 | 5 |
|---|---|
| 1981 | 9 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 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\") = 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 ('7102818'))
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 ('7102818'))
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 LAX82FYM18Accident · No injuriesFinal reportPiper PA-28RT-201 · San Carlos, CAAfter landing at the airport, the pilot taxied to the transient parking area, parked and got a cup of coffee. He stated that he then made a quick preflight check, but did not visually inspect the fuel tanks. During the takeoff, the engine began to surge at…NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB NYC82AA125Accident · 4 fatalFinal reportPiper PA-28RT-201 · Dunkirk, NYThe flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…NTSB CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…