NTSB investigations: Piper PA-28R-200, OH
19 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2017 | 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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
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 GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB CEN14CA088Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Bowling Green, OHA bird strike during takeoff.NTSB CHI07CA143Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cincinnati, OHThe pilot's improper decision to leave the aircraft unattended while the engine was running. A factor in the accident was the disengagement of the parking brake.NTSB NYC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Ashland, OHThe pilot's improper fuel management which resulted in fuel exhaustion and loss of engine power.NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB ATL89FA090Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Tipp City, OHImproper planning by the pilot resulting in fuel exhaustion. The pilots lack of equipment and ability to handle the weather situation was ignored by the pilot in his planning for the flight.NTSB CHI84LA350Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Put-In-Bay, OHPlt departed on flt with 30 gals fuel. En route weather required route deviation, extending flt. Calculated fuel reserve was consumed before reaching destination. When fuel exhaustion occurred, plt attempted forced landing on curving road. Acft departed road…NTSB CHI84LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Stow, OHThe acft ran off the rwy & collided with a snowbank during landing. The acft had been subjected to previous damage whichhad not been fully repaired when a mechanic released it for further flt. A bolt (slightly worn, according to the mechanic) was reused in…NTSB CHI84LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Zanesville, OHAfter departing Zanesville, OH, the acft was at 2500 ft MSL when the eng began to 'knock'. The cockpit filed with smoke & the eng began to lose oil. The plt turned back to land at the arpt. He reported that the eng continued to run until the acft was about…NTSB CHI82DA165Accident · No injuriesFinal reportPiper PA-28R · Stow, OHThe instructor pilot and his student, a rated private pilot, were on a flight to provide dual instruction for a commercial pilot certificate. A landing approach was made to a runway with a slight downslope in the touchdown area. The instructor estimated that…NTSB CHI80FEK20Accident · No injuriesClosedPiper PA-28R · Circleville, OHNTSB CHI79FEK03Accident · Serious injuriesClosedPiper PA-28R · Zanesville, OHNTSB CHI78FEG04Accident · No injuriesClosedPiper PA-28R · Miamisburg, OHNTSB CHI77FEG22Accident · Serious injuriesClosedPiper PA-28 · Piqua, OHNTSB CHI77FEK15Accident · No injuriesClosedPiper PA-28 · Heath, OHNTSB CHI75FEI49Accident · No injuriesClosedPiper PA-28R · Strongsville, OHNTSB CHI74FEK23Accident · No injuriesClosedPiper PA-28R · Marion, OHNTSB CHI72DEI31Accident · No injuriesClosedPiper PA-28R · Painesville, OHNTSB CHI71DGD45Accident · No injuriesClosedPiper PA-28R · Painsville, OH