NTSB investigations: Piper PA-44-180, MN
5 cases on aircraft the registry lists as Piper PA-44-180. 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
| 1994 | 1 |
|---|---|
| 2005 | 1 |
| 2007 | 1 |
| 2024 | 1 |
| 2025 | 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\" = '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 ('7104402', '7104406'))
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 ('7104402', '7104406'))
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 CEN25LA174Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Saint James, MNThe failure of the left main landing gear tire casing and tube due to excessive wear which resulted in a loss of directional control during the landing.NTSB CEN24LA360Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Shakopee, MNThe pilots’ failure to apply carburetor heat during the descent, which resulted in a loss of power on both engines due to carburetor ice.NTSB CHI08FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Browerville, MNAn in-flight collision with at least one Canada goose, and the resulting damage to the left stabilator that caused the airplane to become uncontrollable. Contributing to the accident was the night lighting condition, which precluded any possibility of the…NTSB CHI05CA258Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Fertile, MNThe flightcrew's failure to extend the landing gear prior to touchdown, and the flight instructor's inadequate supervision of the flight.NTSB CHI95LA043Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Thief Rvr Falls, MNthe flight instructor's delayed remedial action during a simulated forced landing. A factor in the accident is the student pilot's improper landing flare.