NTSB investigations: Piper PA-18-135, MT
9 cases on aircraft the registry lists as Piper PA-18-135. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1985 | 2 |
| 1996 | 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\" = '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 ('7101820'))
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 ('7101820'))
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 SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.NTSB DEN85LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Cut Bank, MTThe purpose of the flt was to clean the acft spray sys. The plt reported that he initiated a downhill/donwind takeoff in winds that were light, but gusting. At lift-off, the plt lost directional control & the acft mushed & crashed. The plt believed the…NTSB DEN85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Polson, MTThe plt stated a 35 kt gust of wind from the north lifted the tail of the acft to the left. The acft veered right, contacted a snow bank and nosed over. The plt was taxiing on rwy 18 after landing when the accident occurred.NTSB SEA79FTA15Accident · No injuriesClosedPiper PA-18 · Circle, MTNTSB SEA76AS078Accident · 1 fatalClosedPiper PA-18 · Zurich, MTNTSB SEA71DTI31Accident · No injuriesClosedPiper PA-18 · Gallatin Gwy, MTNTSB SEA67F0107Accident · No injuriesClosedPiper PA-18 · Zortman, MTNTSB SEA66F0180Accident · Minor injuriesClosedPiper PA-18A · Huntley, MTNTSB SEA66D0039Accident · No injuriesClosedPiper PA-18 · Billings, MT