NTSB investigations: Piper PA-30
8 cases on aircraft the registry lists as Piper PA-30, where the sequence of events included Landing gear not configured. 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
| 2016 | 1 |
|---|---|
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2026 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR27LA016Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-30 · Reno, NVNTSB CEN25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Springfield, MOThe flight instructor’s inability to confirm landing gear position before landing due to the sun glare which resulted in gear up landing. Contributing to the accident was an undetected tripped circuit breaker for the landing gear and the inoperative gear…NTSB ERA23LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · St. Augustine, FLThe pilot’s failure to extend the landing gear before landing.NTSB GAA22WA121Accident · No injuriesClass 5 · ForeignPiper PA-30 · Sandown, United KingdomNTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB CEN22LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Houston, TXThe instructed pilot and the flight instructor’s failure to extend the landing gear before landing resulting in a wheels up landing.NTSB CEN21LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Navasota, TXThe pilot’s failure to extend the landing gear before landing.NTSB ERA16LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Dublin, GAThe pilot’s inadvertent retraction of the landing gear during the landing roll following a landing approach in gusting wind conditions.