Fatal NTSB investigations: Piper PA-31T1
10 cases on aircraft the registry lists as Piper PA-31T1. 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
| 1979 | 1 |
|---|---|
| 1994 | 1 |
| 1998 | 2 |
| 2001 | 1 |
| 2004 | 1 |
| 2012 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2020 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103126'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103126'))
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 WPR20LA128Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA31T · Billings, MTThe degraded airplane performance after takeoff for reasons that could not be determined from available evidence.NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB ERA15FA181Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Fort Lauderdale, FLA rapid onset of smoke and/or fire inflight for reasons that could not be determined due to the postimpact fire and the condition of the wreckage.NTSB WPR13FA070Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Ely, NVThe pilot’s failure to regain airplane control following a sudden rapid descent during cruise flight, which resulted in an exceedance of the design stress limits of the aircraft and led to an in-flight structural failure.NTSB NYC04WA055Accident · 3 fatalForeign investigationPiper PA-31T · Toussus Le Nobl, FranceNTSB FTW02FA036Accident · 4 fatalField investigationFinal reportPiper PA-31T1 · Graham, TXThe pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.NTSB LAX98FA260Accident · 3 fatalField investigationFinal reportPiper PA-31-T1 · Baker, NVthe pilot's failure to comply with a 12,500-foot altitude restriction placed on the aircraft by an FAA approved maintenance facility due to unresolved oxygen system issues. Contributing to the accident was the pilot's failure to divulge his true physical…NTSB SEA98FA078Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Great Falls, MTThe flight crew's failure to maintain aircraft control.NTSB SEA95FA025Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Brockway, MTa loss of control for undetermined reasons.NTSB IAD79FA033Accident · 3 fatalClosedPiper PA-31T · Baltimore, MD