NTSB investigations: Piper PA-28R-180, 1982
7 cases on aircraft the registry lists as Piper PA-28R-180. 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
| 1968 | 24 |
|---|---|
| 1969 | 36 |
| 1970 | 34 |
| 1971 | 24 |
| 1972 | 27 |
| 1973 | 19 |
| 1974 | 6 |
| 1975 | 12 |
| 1976 | 15 |
| 1977 | 14 |
| 1978 | 13 |
| 1979 | 6 |
| 1980 | 10 |
| 1981 | 10 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 1 |
| 1997 | 6 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 1 |
| 2003 | 5 |
| 2004 | 8 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 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 ('7102809'))
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 ('7102809'))
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 LAX82DA284Accident · No injuriesFinal reportPiper PA-28R · San Pedro, CAPilot was flying near catalina island and when he switched tanks the engine quit. Procedures to restart did not work so aircraft was ditched.NTSB ATL82DA192Accident · No injuriesFinal reportPiper PA-28-180R · Carrollton, GADuring cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation…NTSB ATL82DA126Accident · Serious injuriesFinal reportPiper PA-28R-180 · Front Royal, VADuring flight the aircraft engine developed a noise which the pilot described as a hissing. The pilot declared an emergency, was vectored to the nearest airport, and proceeded to shut off the engine at 5000 feet when over the airport. During the forced…NTSB NYC82DA065Accident · No injuriesFinal reportPiper PA-28R-180 · Perry Warsaw, NYThe pilot elected to takeoff at night with low visibility, rain, and fog. Soon after takeoff visual ground contact was lost due to what the pilot stated as quickly lowering ceilings and visibility. The pilot then decided to make a precautionary landing in a…NTSB LAX82FUQ10Accident · Serious injuriesFinal reportPiper PA-28R-180 · Captinteria, CAThe pilot reported that he had some head congestion and had experienced ear discomfort on the first leg of the flight. He elected to fly the second leg of the flight in a canyon that he thought would allow passage through the mountains at low altitude.…NTSB ATL82FA054Accident · Serious injuriesField investigationFinal reportPiper PA-28R-180 · Hagerstown, MDThe pilot made an erratic visual approach after performing an ILS approach to within 2 miles of the runway. She varied her flight path from side to side and was corrected verbally by the more experienced co-pilot. The flare was started too high and the…NTSB ATL82FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Blairsville, GAThe aircraft departed atlanta, GA on a flight with no flight plan to an intended final destination of morristown, TN. However, during a weather briefing, the pilot had inquired about the tri-cities airport at bristol, TN. While en route, the aircraft crashed…