NTSB investigations: Piper PA-18, MT
20 cases on aircraft the registry lists as Piper PA-18. 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 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 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 ('7101802'))
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 ('7101802'))
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 SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTNTSB DEN81FTA01Accident · Serious injuriesClosedPiper PA-18 · Glasgow, MTNTSB DEN80FTA22Accident · No injuriesClosedPiper PA-18 · Alzada, MTNTSB SEA77FTA07Accident · No injuriesClosedPiper PA-18 · Miles City, MTNTSB SEA77FTA06Accident · No injuriesClosedPiper PA-18 · Glasgow, MTNTSB SEA76FTA10Accident · No injuriesClosedPiper PA-18 · Glasgow, MTNTSB SEA75DTA03Accident · No injuriesClosedPiper PA-18 · Ft.Peck, MTNTSB SEA72FTA18Accident · No injuriesClosedPiper PA-18 · Laurel, MTNTSB SEA72DTI24Accident · No injuriesClosedPiper PA-18 · Virginia Cty, MTNTSB SEA72DT117Accident · No injuriesClosedPiper PA-18 · Plains, MTNTSB SEA70FDA16Accident · Serious injuriesClosedPiper PA-18 · Wolf Point, MTNTSB SEA69D0243Accident · No injuriesClosedPiper PA-18 · Peerless, MTNTSB SEA68D0257Accident · No injuriesClosedPiper PA-18 · Worden, MTNTSB SEA68F0159Accident · No injuriesClosedPiper PA-18 · Billings, MTNTSB SEA66F0301Accident · Serious injuriesClosedPiper PA-18 · Ekalaka, MTNTSB UNK65X1107Accident · No injuriesClosedPiper PA18 · Alzada, MTNTSB UNK64X2716Accident · No injuriesClosedPiper PA18 · Ryegate, MTNTSB UNK64X2032Accident · No injuriesClosedPiper PA18 · Malta, MT