NTSB investigations: Piper PA-12, IA
11 cases on aircraft the registry lists as Piper PA-12. 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 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1991 | 1 |
| 1998 | 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\" = 'IA' 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 ('7101202'))
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" = 'IA' 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 ('7101202'))
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 CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB CHI91LA213Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stockton, IACompensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.NTSB MKC77DCD49Accident · No injuriesClosedPiper PA-12 · Denison, IANTSB MKC73DCD66Accident · No injuriesClosedPiper PA-12 · Davenport, IANTSB MKC73DCD20Accident · Minor injuriesClosedPiper PA-12 · Maysville, IANTSB MKC72DCD41Accident · No injuriesClosedPiper PA-12 · Harlan, IANTSB MKC67D0565Accident · No injuriesClosedPiper PA-12 · Mantelle, IANTSB MKC67F0124Accident · No injuriesClosedPiper PA-12 · Allison, IANTSB MKC66F0322Accident · Minor injuriesClosedPiper PA-12 · Fort Dodge, IANTSB MKC66F0248Accident · Minor injuriesClosedPiper PA-12 · Lemars, IANTSB MKC66D0213Accident · No injuriesClosedPiper PA-12 · Marion, IA