NTSB investigations: Piper PA-28-151, MT
6 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1975 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102805', '7104223'))
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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102805', '7104223'))
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 DEN82DA203Accident · No injuriesFinal reportPiper PA-28-151 · Near Darby, MTSince the shook mountain resort airport was new to the pilot, he called the airport to get further information. He stated that the person who answered reported it was a nice day and the wind sock had blown down. During arrival, he approached from the…NTSB DEN82DA107Accident · No injuriesFinal reportPiper PA-28-151 · Jackson, MTThe pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at…NTSB DEN81FTI14Accident · Minor injuriesClosedPiper PA-28 · Seely Lake, MTNTSB SEA79FTI01Accident · Serious injuriesClosedPiper PA-28 · Belgrade, MTNTSB SEA77FTA13Accident · No injuriesClosedPiper PA-28 · Plentywood, MTNTSB SEA75DTI18Accident · No injuriesClosedPiper PA-28 · Anaconda, MT