NTSB investigations: Piper PA-32R-300
8 cases on aircraft the registry lists as Piper PA-32R-300, where the sequence of events included Landing gear collapse. 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
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2022 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103213')
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\" = '094' 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 ('7103213')
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" = '094' 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 ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.NTSB ERA24LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Selma, ALThe pilot receiving instruction’s improper landing flare which resulted in a hard landing and subsequent landing gear collapse.NTSB CEN22LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · Gettysburg, SDAn inadvertent hard landing by the pilot.NTSB GAA18CA088Accident · No injuriesData collectionFinal reportPiper PA 32R · Kwigillingok, AKThe pilot’s decision to land with the sun in his eyes, which resulted in a short landing.NTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.NTSB ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.