NTSB investigations: Piper PA-31-350
14 cases on aircraft the registry lists as Piper PA-31-350, where the first occurrence was “Wheels up 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
| 1995 | 1 |
|---|---|
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 4 |
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\" = 232))
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" = 232))
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 SEA08LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salt Lake City, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a written checklist.NTSB DEN08LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Trinidad, COThe pilot's failure to extend the landing gear.NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.NTSB ANC06LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Fairbanks, AKThe pilot's inadvertent landing with the landing gear retracted, which resulted in structural damage to the airplane.NTSB ANC04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Telida, AKA failure of the pilot-in-command to extend the landing gear, which resulted in a gear-up landing and structural damage to the airplane.NTSB ANC02LA104Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nuiqsut, AKThe pilot's inadvertent wheels-up landing. Factors contributing to the accident were the pilot's failure to complete the prelanding checklist, his diverted attention, and a delayed gear warning horn alarm.NTSB ANC02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot's failure to complete his prelanding checklist, and a subsequent inadvertent wheels up landing.NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.NTSB ANC98LA167Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Noorvik, AKA failure of the pilot to follow the aircraft checklist, and an inadvertent wheels up landing.NTSB ANC98LA120Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fort Yukon, AKThe pilot's failure to follow the pre-landing checklist. A factor associated with the accident was the pilot's diverted attention.NTSB ANC97LA069Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Selawik, AKThe pilot's failure to extend the landing gear. A factor associated with the accident was the pilot's diverted attention while in the landing pattern.NTSB MIA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Opa-Locka, FLThe failure of maintenance personnel to comply with manufacturer inspection procedures for hydraulic lines resulting in the failure of the right main gear door line and loss of all hydraulic fluid.