NTSB investigations: Piper PA-31-350
15 cases on aircraft the registry lists as Piper PA-31-350, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 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 ('7103110', '7103125')
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\" = 130))
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 ('7103110', '7103125')
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" = 130))
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 NYC07IA164Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Orlando, FLThe mechanic's failure to secure the right engine cowling fasteners. Contributing to the incident was the pilot's inadequate preflight inspection.NTSB ANC07LA059Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Kotzebue, AKLocked parking brakes and the operator's maintenance personnel's failure to properly secure the parking brake cable at its fuselage attaching clamp.NTSB ANC05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Elim, AKAn improper installation of a fuel line fitting by company maintenance personnel, which resulted in a fuel leak and subsequent in-flight engine compartment fire during cruise flight that was discovered during the landing roll.NTSB DEN01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COthe failure of the nose landing gear right drag brace (link assembly) due to fatigue.NTSB DEN01LA005Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Grand Junction, COTotal failure of the right forward inboard landing gear door hinge pin for undetermined reasons.NTSB FTW98IA361Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Denver, COA hydraulic failure due to a ruptured hydraulic line, preventing the extension of the nose and right main landing gear.NTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.NTSB ANC97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKa fuel leak from an engine driven fuel pump which initiated an engine fire, and the fuel pump manufacturer's inadequate quality control of the fuel pump.NTSB ANC97IA035Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Kotzebue, AKthe jammed main landing gear which was caused by a binding main landing gear door with a broken hinge. The fractured, inadequate main landing gear door hinge was also causal.NTSB ANC96FA078Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Point Hope, AKThe pilot's inadequate preflight to ensure the nose baggage door was properly latched, and the subsequent opening of the baggage compartment door, which allowed items to collide with the left propeller, resulting in propeller damage and loss of thrust from…NTSB ANC90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKInadequate maintenance and inspection of the nose baggage door.NTSB LAX89FA314Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Ontario, CAFailure of the right propeller hub due to metal fatigue which resulted in catastrophic separation of the propeller. Contributing to the accident was damage done to the aircraft airframe in flight by the separating propeller making the aircraft uncontrollable.NTSB FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…NTSB MKC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · Chillicothe, MODuring arrival, the plt attempted to lower the gear, but only 2 of the 3 would indicate down & safe. The plt was unable to extend the left gear, so he continued flying for aprx 1 hr to burn down fuel, then intentionally landed with the gear up. The landing…NTSB MIA82IA110Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Tallahassee, FLWhile cruising at 8000 feet, the right alternator light came on and the pilot accomplished the required procedures for an alternator failure. Shortly thereafter, he noticed an area of discoloration on the inboard nacelle of the right engine and saw flames…