NTSB investigations: Piper PA-28-161, MI
12 cases on aircraft the registry lists as Piper PA-28-161. 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
| 1977 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2019 | 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\" = 'MI' 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 ('7102803', '7102834'))
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" = 'MI' 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 ('7102803', '7102834'))
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 GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…NTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.NTSB CHI91LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Pleasant, MIDirectional control was not maintained by the pilot. Factors related to the accident were a wet, grass runway and buildings adjacent the runway.NTSB CHI90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pontiac, MIOverload failure of the left main landing gear attach bolts for an undetermined reason.NTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.NTSB CHI88LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Detroit, MIThe plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51…NTSB CHI85LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Troy, MIThe acft collided with a sign during a forced lndg after a loss of power that occurd during initial climb at an alt of 400 ft AGL. The plt stated that the eng began to run rough and with the application of carb heat the eng quit. A post accident eng run-up…NTSB CHI80FEM48Accident · No injuriesClosedPiper PA-28 · Shelby, MINTSB CHI80FA020Accident · 3 fatalClosedPiper PA-28 · Royal Oak, MINTSB CHI78FEM04Accident · No injuriesClosedPiper PA-28 · Grand Ledge, MI