NTSB investigations: Piper PA-44-180
5 cases on aircraft the registry lists as Piper PA-44-180, where the first occurrence was “Loss of engine power”. 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
| 1989 | 1 |
|---|---|
| 2001 | 1 |
| 2003 | 2 |
| 2007 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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" = 350))
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 DFW07CA121Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lubbock, TXThe failure of the engine fuel supply line and the separation of the number one cylinder exhaust pipe resulting in an engine fire.NTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.NTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.NTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.NTSB MIA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe failure of the instructor to maintain the proper airspeed during a simulated engine failure on initial climb. The instructor, after taking control of the aircraft, also failed to properly flare the aircraft resulting in a hard landing during which the…