NTSB investigations: Piper PA-18-150, UT
12 cases on aircraft the registry lists as Piper PA-18-150. 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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2007 | 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.\"eventStateOrRegion\" = 'UT' 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 ('7101828', '7104221', '7102835'))
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" = 'UT' 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 ('7101828', '7104221', '7102835'))
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 WPR20CA134Accident · Minor injuriesData collectionFinal reportPiper PA18 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a roll-over.NTSB SEA07CA222Accident · No injuriesData collectionFinal reportPiper PA-18-150 · St. George, UTThe pilot's failure to maintain directional control and excessive braking during the landing roll.NTSB DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.NTSB SEA97GA008Accident · 2 fatalFinal reportPiper PA-18-150 · Holden, UTThe first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…NTSB DEN83LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, UTBefore departing salt lake city, UT, the pilot obtained information about the weather and destination airport at mt Pleasant, UT. The weather was reported VFR and the mt Pleasant municipal airport was reported open. During arrival, the pilot observed furrows…NTSB DEN80DTM22Accident · No injuriesClosedPiper PA-18 · Santaquin, UTNTSB DEN77DTM32Accident · No injuriesClosedPiper PA-18 · Ogden, UTNTSB DEN76FTM28Accident · No injuriesClosedPiper PA-18 · Tooele, UTNTSB DEN72DTM19Accident · No injuriesClosedPiper PA-18 · Laketown, UTNTSB DEN69D0184Accident · No injuriesClosedPiper PA-18 · Woods Cross, UTNTSB DEN68F0239Accident · Minor injuriesClosedPiper PA-18 · Ogden, UTNTSB UNK65X0470Accident · No injuriesClosedPiper PA18 · Promontory Pt, UT