NTSB investigations: New Piper PA46-350P
4 cases on aircraft the registry lists as New Piper PA46-350P. 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
| 2008 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7104607'))
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 ('7104607'))
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 CEN21WA059Accident · No injuriesClass 4 · ForeignPiper PA46 · Villingen-Schwenningen, GermanyNTSB ERA15WA119Accident · No injuriesForeign investigationNew Piper PA46 350P · Milan, ItalyOn January 26, 2015, at 1057 Coordinated Universal Time (UTC), a Piper PA-46-250P, N369ST, was substantially damaged when the landing gear collapsed during landing at Milano Linate Airport (LIML), Milan, Italy. The pilot, copilot, and two passengers were not…NTSB WPR14CA057Accident · No injuriesData collectionFinal reportNew Piper PA46 350P · Salt Lake City, UTThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's improper use of the checklist.NTSB WPR09CA066Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Idaho Falls, IDThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the icy runway conditions and a snow bank.