NTSB investigations: Piper PA-18A 150, MT
10 cases on aircraft the registry lists as Piper PA-18A 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 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1975 | 2 |
| 1983 | 1 |
| 1989 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 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 ('7101837'))
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 ('7101837'))
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 SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.NTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.NTSB DEN83LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Hilger, MTThe pilot stated that he and another pilot were spraying a field in tandem formation at an alt of about 10 feet AGL. He was about 1/2 mile behind the lead acft and slightly to the left. After making a swath run he pulled up to about 100 ft AGL and started…NTSB SEA76DTI13Accident · Minor injuriesClosedPiper PA-18A · Fairfield, MTNTSB SEA75DTI20Accident · No injuriesClosedPiper PA-18 · Adel, MTNTSB SEA68D0061Accident · No injuriesClosedPiper PA-18 · Tampico, MTNTSB SEA67F0148Accident · No injuriesClosedPiper PA-18 · Molt, MTNTSB UNK64X2105Accident · Minor injuriesClosedPiper PA18A · Geraldine, MT