NTSB investigations: Piper PA-18A
6 cases on aircraft the registry lists as Piper PA-18A, where the first occurrence was “Nose over”. 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
| 1983 | 2 |
|---|---|
| 1986 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101804', '7102831')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 300))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101804', '7102831')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300))
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 ANC96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable site for landing. A factor associated with the accident is the snow-covered terrain.NTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.NTSB ANC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Totatlanika Rvr, AKThe pilot's poor inflight planning/decision in evaluating and selecting unsuitable terrain for the landing area. Factors contributing to the accident were: snow covered terrain, and the pilot's lack of recent experience in this type of operation.NTSB SEA87LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Petersburg, AKThe plt reported that while landing on a river the acft skidded on river silt. He stated he could not stop the acft which traveled to the FAR end of the river into 8 inch deep water where it nosed over.NTSB SEA84LA029Accident · No injuriesLimited investigationFinal reportPiper PA18-A · Rome, ORThe acft nosed over in the snow during an enroute landing while on a cross country. The plt had landed at this arpt a week before. In the meanwhile there had accumulated 14 inches of snow on the rwy. During the rollout in this snow the acft suddenly stopped…NTSB SEA83LA108Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Touchet, WAThe acft nosed over during landing and came to rest inverted in an off airport landing. The pilot was surveying some land to be sprayed to estimate the cost. He landed on the field which was very soft and the acft nosed over. The pilot was not injured.