NTSB investigations: Piper PA-44-180
7 cases on aircraft the registry lists as Piper PA-44-180, where the first occurrence was “Hard landing”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2005 | 2 |
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.NTSB LAX99LA100Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe pilot's misjudged landing flare resulting in a hard touchdown, and, his failure to adequately compensate for the existing crosswind condition and to maintain directional control during rollout on the wet runway.NTSB LAX98LA176Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Fresno, CAThe dual's student improper flare that led to the right main landing gear collapsing. A related factor in the accident was the instructor pilot's inadequate supervision.NTSB CHI95LA043Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Thief Rvr Falls, MNthe flight instructor's delayed remedial action during a simulated forced landing. A factor in the accident is the student pilot's improper landing flare.NTSB MIA88IA255Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe CFI & his pvt plt-rated multi eng student were conducting touch & go ldgs in preparation for the multi-eng rating. The CFI stated that one of the ldgs was harder than usual, but not overly hard. On the next aprch, they noticed the rt gear indicator was…NTSB MIA88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLWhile practicing short field landings, the student plt flared the acft prematurely resulting in a hard landing & substantial damage. The acft was then taxied to the ramp.