NTSB investigations: Piper PA-30, MI
32 cases on aircraft the registry lists as Piper PA-30. 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
| 1965 | 1 |
|---|---|
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 4 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2002 | 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\" = '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 ('7103002'))
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 ('7103002'))
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 CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.NTSB CHI91LA165Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Big Rapids, MIExcessive application of the flight controls by the student pilot. A factor related to the accident is delayed remedial action by the flight instructor.NTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.NTSB CHI87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bad Axe, MIDuring a demonstration of an aborted takeoff, the 'power was cut' after the aircraft accelerated to about 75 mph. At about that time, the aircraft encountered a gust of wind and became airborne. A power recovery was initiated, but the aircraft touched down in…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB CHI86LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Troy, MIThe plt landed on rwy 27 with winds from 185 degs at 20 KTS gusting to 30 KTS. The acft ballooned on short final. The plt added pwr but the right wing dropped and hit the rwy. The acft cartwheeled.NTSB CHI84LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Berrien Springs, MIThe acft crashed shortly after takeoff near the end of the rwy. The sequence began when the plt noticied that acft acceleration was 'a bit slow' on the rwy. Then a noticable drop in RPM on the right engine occurred at about halfway down the 3100 ft rwy. The…NTSB CHI81FEC21Accident · Minor injuriesClosedPiper PA-30 · Ann Arbor, MINTSB CHI80FEM12Accident · No injuriesClosedPiper PA-30 · Lansing, MINTSB CHI79FEM31Accident · No injuriesClosedPiper PA-30 · Kalamazoo, MINTSB CHI78FEC15Accident · No injuriesClosedPiper PA-30 · Pontiac, MINTSB CHI76FEC45Accident · No injuriesClosedPiper PA-30 · S Lyon, MINTSB CHI74FEM67Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI74FEC06Accident · No injuriesClosedPiper PA-30 · Dansville, MINTSB CHI74 EM04Accident · No injuriesClosedPiper PA-30 · West Branch, MINTSB CHI72DEM55Accident · No injuriesClosedPiper PA-30 · Caspian, MINTSB CHI72FEM04Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI71FBJ71Accident · No injuriesClosedPiper PA-30 · Lansing, MINTSB CHI71FBJ18Accident · No injuriesClosedPiper PA-30 · Pellston, MINTSB CHI70AC085Accident · No injuriesClosedCessna 182 · Edenville, MINTSB CHI70FBJ28Accident · No injuriesClosedPiper PA-30 · Charlotte, MINTSB CHI70F0391Accident · No injuriesClosedPiper PA-30 · Grand Rapids, MINTSB CHI70F0359Accident · No injuriesClosedPiper PA-30 · Harrison, MINTSB CHI69A0102Accident · 3 fatalClosedPiper PA-30 · Inkster, MINTSB CHI69F0551Accident · No injuriesClosedPiper PA-30 · Birmingham, MINTSB CHI68F0737Accident · No injuriesClosedPiper PA-30 · Ann Arbor, MINTSB CHI68F0499Accident · 1 fatalClosedPiper PA-30 · Lowell, MINTSB CHI68F0461Accident · No injuriesClosedPiper PA-30 · Traverse Cty, MINTSB CHI68F0329Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI67F0556Accident · No injuriesClosedPiper PA-30 · Birmingham, MINTSB CHI66F0182Accident · No injuriesClosedPiper PA-30 · Alpena, MI