NTSB investigations: Piper PA-44-180
11 cases on aircraft the registry lists as Piper PA-44-180, 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
| 2010 | 2 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104402', '7104406')
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 ('7104402', '7104406')
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 WPR21LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Redmond, ORFailure of the landing gear strut piston tube due to fatigue cracking from corrosion pitting.NTSB ERA17LA204Accident · No injuriesLimited investigationFinal reportPiper PA 44-180 · Gaithersburg, MDThe failure of the right main landing gear trunnion bracket due to an undetermined overstress event.NTSB GAA17CA349Accident · No injuriesData collectionFinal reportPiper PA44 · Tulsa, OKThe pilot receiving instruction’s failure to maintain directional control during landing in gusting wind conditions.NTSB ERA15LA225Accident · No injuriesLimited investigationFinal reportPiper PA44 · Miami, FLThe failure of the nose landing gear upper drag link knee bolt due to reverse-bending fatigue, which was likely preceded by excessive bearing wear due to reasons that could not be determined based on the available evidence.NTSB ERA14IA370Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLThe nose landing gear collapse for reasons that could not be determined because examination of the airplane revealed no anomalies.NTSB WPR13LA349Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Billings, MTThe pilots’ inadequate landing flare, which resulted in a hard landing and collapse of the left main landing gear.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB ERA12LA117Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe mechanic's improper installation and lubrication of the bushing on the right main landing gear truss assembly, which resulted in the landing gear not locking in the down position.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB CEN10CA311Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Okmulgee, OKThe student pilot’s inadvertent retraction of the nose landing gear and the flight instructor's delayed response.NTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…