NTSB investigations: Piper PA-23-250, MN
17 cases on aircraft the registry lists as Piper PA-23-250. 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
| 1964 | 2 |
|---|---|
| 1974 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2006 | 2 |
| 2013 | 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 ('7102308'))
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 ('7102308'))
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 CEN14FA034Accident · 3 fatalField investigationFinal reportPiper PA 23-250 · Caledonia, MNThe pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB CHI06LA146Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Faribault, MNDirectional control not obtained/maintained by the pilot during landing. A contributing factor was the ditch.NTSB CHI00LA300Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sandstone, MNthe pilot exceeding the proper touchdown point on the runway.NTSB CHI95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Minneapolis, MNan inadequate windshield deicing system for the inflight icing encountered, airframe icing, and the pilot's inability to maintain a proper descent rate. Factors associated with this accident were an inadequate weather forecast and icing conditions.NTSB CHI91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Lindstrom, MNLeft engine failure for an undetermined reason. A factor related to the accident was: unsuitable terrain.NTSB MKC89LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bemidji, MNThe continued approach and landing by the pilot in known adverse weather. Contributing factors were the weather conditions and the ditch.NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB CHI82DA081Accident · No injuriesFinal reportPiper PA-23 250 · Grand Marais, MNAfter clearing trees located approximately 1000 feet from the end of the runway the pilot reduced power and added flaps in an attempt to land close to the approach end. The aircraft struck a snowbank on short final for the snow covered runway 27.NTSB MKC80FER26Accident · No injuriesClosedPiper PA-32 · Sauk Centre, MNNTSB MKC80DER06Accident · No injuriesClosedPiper PA-23 · Cold Springs, MNNTSB MKC75AER76Accident · No injuriesClosedPiper PA-23 · Hackensack, MNNTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNNTSB MKC75AK012Accident · 8 fatalClosedPiper PA-23 · Fergus Falls, MNNTSB UNK64X2229Accident · No injuriesClosedPiper PA23 · Marshall, MNNTSB UNK64X0624Accident · No injuriesClosedPiper PA23 · Alexandria, MN