NTSB investigations: Piper PA-28R-200, 1992
17 cases on aircraft the registry lists as Piper PA-28R-200. 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
| 1969 | 5 |
|---|---|
| 1970 | 10 |
| 1971 | 11 |
| 1972 | 27 |
| 1973 | 37 |
| 1974 | 39 |
| 1975 | 39 |
| 1976 | 44 |
| 1977 | 50 |
| 1978 | 41 |
| 1979 | 25 |
| 1980 | 27 |
| 1981 | 25 |
| 1982 | 15 |
| 1983 | 20 |
| 1984 | 13 |
| 1985 | 11 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 17 |
| 1989 | 15 |
| 1990 | 11 |
| 1991 | 14 |
| 1992 | 17 |
| 1993 | 13 |
| 1994 | 18 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 18 |
| 1998 | 12 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 11 |
| 2004 | 6 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 4 |
| 2009 | 8 |
| 2010 | 7 |
| 2011 | 3 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 10 |
| 2016 | 9 |
| 2017 | 11 |
| 2018 | 5 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 1 |
Where
Latest 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\") = 1992
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811'))
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") = 1992
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811'))
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 MIA93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Tarpon Springs, FLThe pilot's failure to maintain the minumum descent altitude (mda) while on a non-precision instrument approach. Factors which contributed to the accident were: the flight service station (fss) specialist's failure to provide the published notice to airmen…NTSB SEA93FA025Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTClearance from mountainous terrain was not maintained. Factors to the accident were: dark night condition, snow showers, and intentional flight into known adverse weather.NTSB NYC93LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Akron, NYThe failure of the pilot to compensate for adverse winds and wind shear. A factor related to the accident was the adverse wind conditions.NTSB FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.NTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.NTSB LAX92LA398Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's intentional flight at an altitude which provided insufficient clearance from the water.NTSB ATL92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oviedo, FLThe failure of the dual student to properly flare the aircraft during the landing attempt, and the flight instructor's failure to perform remedial action to prevent the hard landing.NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.NTSB DEN92LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200R · Nederland, COA partial loss of power for undetermined reasons. A factor was: no suitable terrain for a forced landing.NTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.NTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.NTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.NTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.NTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…