NTSB investigations: Piper PA-30, OH
19 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 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1976 | 2 |
| 1982 | 2 |
| 1998 | 1 |
| 2003 | 1 |
| 2011 | 1 |
| 2013 | 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\" = 'OH' 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" = 'OH' 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 CEN13LA361Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHThe pilot’s loss of control of the airplane for reasons that could not be undetermined because a postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA364Accident · Minor injuriesLimited investigationFinal reportPiper PA30 · Phillipsburg, OHThe pilot’s failure to maintain directional control during takeoff following a loss of left engine power for undetermined reasons.NTSB IAD03FA058Accident · 2 fatalField investigationFinal reportPiper PA-30 · NewPhiladelphia, OHThe pilot's mismanagement of the fuel, and his failure to maintain minimum controllable airspeed with one engine inoperative.NTSB IAD98LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Dayton, OHthe pilot's inadequate recovery from a bounced landing.NTSB CHI83LA028Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbus, OHThe pilot taxiied onto 8 foot culvert after landing. Pilot complained of taxiway markings and lighting. He also said he never saw the culvert.NTSB CHI82FA211Accident · No injuriesField investigationFinal reportPiper PA-30 · Vandalia, OHDuring descent at 215 mph the acft entered violent buffeting. Recovery was initiated by reducing power & the acft landed without any further incident. Examination revealed the horizontal stabilator was permanently bent downward on both sides. The acft was…NTSB CHI77FEI07Accident · No injuriesClosedPiper PA-30 · North Benton, OHNTSB CHI77FEI01Accident · No injuriesClosedPiper PA-30 · Mansfield, OHNTSB CHI73FEK12Accident · No injuriesClosedPiper PA-30 · St Clairsvle, OHNTSB CHI73FEG06Accident · No injuriesClosedPiper PA-30 · Blue Ash, OHNTSB CHI72AC053Accident · 2 fatalClosedPiper PA-30 · Bowlng Green, OHNTSB CHI72FEG13Accident · Minor injuriesClosedPiper PA-30 · Tipp City, OHNTSB CHI71FGD12Accident · No injuriesClosedCessna 150 · Tiffin, OHNTSB CHI69F0169Accident · No injuriesClosedPiper PA-30 · Lebanon, OHNTSB CHI68F0776Accident · No injuriesClosedPiper PA-30 · Youngstown, OHNTSB CHI68D0558Accident · No injuriesClosedPiper PA-30 · Willoughby, OHNTSB CHI68F0542Accident · Serious injuriesClosedPiper PA-30 · Chagrin Flls, OHNTSB CHI67F0045Accident · No injuriesClosedPiper PA-30 · Gallipolis, OHNTSB CHI65A0086Accident · No injuriesClosedPiper PA-30 · Cincinnati, OH