NTSB investigations: Piper PA-28R-200, MN
13 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
| 1972 | 1 |
|---|---|
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1981 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2019 | 1 |
| 2024 | 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 c.\"eventStateOrRegion\" = 'MN' 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" = 'MN' 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 CEN25LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Crystal, MNThe malfunction of the landing gear system which resulted in a collapse of the main landing gear during the landing roll.NTSB CEN24LA342Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R · Crystal, MNThe failure of the engine mount under normal operating loads due to the fracture of a vertical tube that was weakened by corrosion and fatigue of the internal surfaces.NTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.NTSB CHI99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-R200 · Eden Prairie, MNthe pilot misjudged the flare and did not maintain directional control during touchdown. A factor was the VASI lights.NTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.NTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNNTSB CHI82FER06Accident · Minor injuriesClosedPiper PA-28R · Lynd, MNNTSB CHI81FER37Accident · No injuriesClosedPiper PA-28R · Detroit Lakes, MNNTSB MKC79DER30Accident · No injuriesClosedPiper PA-28R · Fergus Falls, MNNTSB MKC79FER27Accident · No injuriesClosedPiper PA-28 · Winona, MNNTSB MKC76FER45Accident · No injuriesClosedPiper PA-28R · Albert Lea, MNNTSB MKC75FER33Accident · No injuriesClosedPiper PA-28R · Eden Prairie, MNNTSB MKC72AK044Accident · No injuriesClosedPiper PA-28 · Fergus Falls, MN