NTSB investigations: Piper PA-18A, ID
13 cases on aircraft the registry lists as Piper PA-18A. 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 |
|---|---|
| 1965 | 3 |
| 1967 | 2 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2017 | 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\" = 'ID' 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 ('7101804', '7102831'))
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" = 'ID' 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 ('7101804', '7102831'))
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 WPR17LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA 18A · Coeur D'Alene, IDThe loss of yaw control due to an inadequately compressed rudder swage, which resulted from inadequate maintenance and led to the separation of the forward right rudder cable.NTSB SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.NTSB SEA83LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Fort Hall, IDThe acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed…NTSB SEA76DYA22Accident · No injuriesClosedPiper PA-18 · Idaho Falls, IDNTSB SEA74DYA08Accident · No injuriesClosedPiper PA-18A · Mud Lake, IDNTSB SEA72DYA11Accident · No injuriesClosedPiper PA-18 · Burley, IDNTSB SEA69D0269Accident · No injuriesClosedPiper PA-18A · Grasmere, IDNTSB SEA68D0221Accident · No injuriesClosedPiper PA-18 · Preston, IDNTSB SEA67A0072Accident · 2 fatalClosedPiper PA-18 · Parma, IDNTSB SEA66F0155Accident · Serious injuriesClosedPiper PA18A · Homedale, IDNTSB SEA66F0020Accident · Minor injuriesClosedPiper PA-18A · Burley, IDNTSB SEA66F0096Accident · No injuriesClosedPiper PA-18A · Copeland, IDNTSB UNK64X2844Accident · No injuriesClosedPiper PA18 · Garden Valley, ID