NTSB investigations: Piper PA-18, SD
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
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 4 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1984 | 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\" = 'SD' 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" = 'SD' 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 DEN84LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Barnard, SDDuring a landing in a soy bean field the acft encountered a soft muddy spot which caused the acft to nose over.NTSB DEN83LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Camp Crook, SDPilot making low altutude turns found controls jammed and collided left wing low in descent with bales of hay. Fuselage was found to contain spent and live shotgun shells under the floor. Aileron had a firing pin from a shotgun lodged in a pulley. The pilot…NTSB MKC79FA029Accident · 1 fatalClosedPiper PA-18 · Oelrichs, SDNTSB MKC78FTK20Accident · 1 fatalClosedPiper PA-18 · Naples, SDNTSB MKC76FTK19Accident · Serious injuriesClosedPiper PA-18 · Milbank, SDNTSB MKC76AK019Accident · 2 fatalClosedPiper PA-18 · Hayes, SDNTSB MKC75DTK12Accident · No injuriesClosedPiper PA-18 · Milbank, SDNTSB MKC75DTK07Accident · No injuriesClosedPiper PA-18 · Cresbard, SDNTSB MKC73DTK15Accident · Minor injuriesClosedPiper PA-18 · Winner, SDNTSB MKC73FTK11Accident · Serious injuriesClosedPiper PA-18 · Mclaughlin, SDNTSB DEN73DTC02Accident · No injuriesClosedPiper PA-18 · Belle Frche, SDNTSB MKC71FDQ13Accident · No injuriesClosedPiper PA-18 · Pierre, SDNTSB MKC71DDQ05Accident · No injuriesClosedPiper PA-18 · Opal, SDNTSB MKC71DDQ02Accident · No injuriesClosedPiper PA-18 · Ludlow, SDNTSB MKC70DDQ02Accident · No injuriesClosedPiper PA-18 · Mobridge, SDNTSB MKC70D0072Accident · No injuriesClosedPiper PA-18 · Camp Crook, SDNTSB MKC69D0478Accident · No injuriesClosedPiper PA-18 · Onida, SDNTSB MKC67F0509Accident · Minor injuriesClosedPiper PA-18 · Watertown, SDNTSB MKC67F0179Accident · No injuriesClosedPiper PA-18 · Hermosa, SDNTSB MKC66D0432Accident · No injuriesClosedPiper PA-18 · Summit, SD