NTSB investigations: Piper PA-18, WA

11 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Piper PA-18, WA per year, 1964–2026: 11 cases
1964	3
1965	2
1967	1
1980	1
1986	1
1990	1
2010	1
2011	1

Where

Open the map

Latest cases

Query with SQL

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" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

Run 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 WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.Jul 2, 2011 · N23TT · Destroyed NTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.Aug 19, 2010 · N1662P · Substantial damage NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.Jun 1, 1990 · N5895D · Substantial damage NTSB SEA86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kent, WAThe plt lost control of the acft during landing roll and a ground loop to the right occurred despite the plts attempt to regain control of the acft. The plt stated his ability to use the heel brakes was delayed due to the type of shoes he was wearing.Aug 24, 1986 · N23TT · Substantial damage NTSB SEA80DYP18Accident · No injuriesClosedPiper PA-18 · Pullman, WAApr 13, 1980 · N7149K · Substantial damage NTSB SEA67F0335Accident · No injuriesClosedPiper PA-18 · Quincy, WAMay 19, 1967 · N3783Z · Substantial damage NTSB SEA66F0166Accident · Minor injuriesClosedPiper PA-18 · Waitsburg, WANov 13, 1965 · N1265A · Substantial damage NTSB SEA66F0158Accident · No injuriesClosedPiper PA-18 · White Swan, WANov 9, 1965 · N1323A · Destroyed NTSB UNK65X0132Accident · 2 fatalClosedPiper PA-18 · Waterville, WAOct 3, 1964 · N7221K · Destroyed NTSB UNK64X2994Accident · No injuriesClosedPiper PA18 · Pt Townsend, WAJul 23, 1964 · N1041A · Substantial damage NTSB UNK64X1896Accident · No injuriesClosedPiper PA18 · Tacoma, WAMay 23, 1964 · N7151C · Substantial damage