NTSB investigations: Piper PA-18-150, MN
17 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 3 |
| 1976 | 1 |
| 1977 | 3 |
| 1980 | 1 |
| 1984 | 1 |
| 1998 | 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\" = 'MN' 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" = 'MN' 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 CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI84LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sauk Rapids, MNThe plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over.NTSB CHI81FER03Accident · No injuriesClosedPiper PA-18 · Brainerd, MNNTSB MKC78DER01Accident · No injuriesClosedPiper PA-18 · Belle Plaine, MNNTSB MKC77FER59Accident · No injuriesClosedPiper PA-18 · Spring Grove, MNNTSB MKC77FER27Accident · Serious injuriesClosedPiper PA-18 · Barrett, MNNTSB MKC76AK062Accident · 2 fatalClosedPiper PA-18 · Rockville, MNNTSB MKC72FER30Accident · Serious injuriesClosedPiper PA-18 · Gilman, MNNTSB MKC72FER14Accident · 1 fatalClosedPiper PA-18 · Rosemont, MNNTSB MKC71FER71Accident · 1 fatalClosedPiper PA-18 · Barnesville, MNNTSB MKC70FDD20Accident · No injuriesClosedPiper PA-18 · Rothsay, MNNTSB MKC70FDD13Accident · No injuriesClosedPiper PA-18 · Laporte, MNNTSB MKC70D0058Accident · No injuriesClosedPiper PA-18 · Wheaton, MNNTSB MKC69D0440Accident · No injuriesClosedPiper PA-18A · Downer, MNNTSB MKC69D0183Accident · No injuriesClosedPiper PA-18 · New Ulm, MNNTSB MKC68F0150Accident · No injuriesClosedPiper PA-18 · Barnesville, MN