NTSB investigations: Piper PA-30, IN
14 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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2018 | 1 |
| 2021 | 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\" = 'IN' 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" = 'IN' 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 CEN21LA171Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Wanatah, INThe pilots’ fuel mismanagement, which resulted in fuel starvation and a total loss of engine power to both engines.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB CHI84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indianapolis, INAfter takeoff from dyersburg the gear would not fully retract. The plt attempted to lower the gear manually but it was stuck in the transient position. The plt then diverted to Indianapolis & landed with the gear in the transient position. Investigation…NTSB CHI82DA078Accident · No injuriesFinal reportPiper PA-30 · Valparaiso, INThe pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.…NTSB CHI76AC040Accident · 2 fatalClosedPiper PA-30 · Monrovia, INNTSB CHI73DEA19Accident · No injuriesClosedPiper PA-30 · Franklin, INNTSB CHI70F0118Accident · Minor injuriesClosedPiper PA-30 · Gary, INNTSB CHI69I0037Incident · No injuriesClosedPiper PA-30 · Michigan City, INNTSB CHI68F0777Accident · No injuriesClosedPiper PA-30 · Elkhart, INNTSB CHI68A0024Accident · 2 fatalClosedPiper PA-30 · Crawfordsvle, INNTSB CHI67F0551Accident · No injuriesClosedPiper PA-30 · Seymour, INNTSB CHI66F0378Accident · No injuriesClosedPiper PA-30 · Muncie, INNTSB CHI66D0098Accident · No injuriesClosedPiper PA-30 · Seymour, INNTSB UNK64X3792Accident · No injuriesClosedPiper PA30 · Muncie, IN