NTSB investigations: Piper PA-18, 1986

7 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

19642026
NTSB investigations: Piper PA-18, 1986 per year, 1964–2026: 477 cases
196447
196531
196621
196720
196818
196914
197023
197115
197215
197311
197419
197513
197611
197710
19788
19797
198010
19817
19829
19834
19845
19859
19867
19874
19883
19896
19909
19917
19923
19934
19946
19955
19965
19972
19984
19996
20006
20011
20027
20034
20042
20054
20062
20074
20084
20093
20102
20114
20124
20131
20142
20152
20162
20171
20181
20193
20204
20213
20224
20234
20252
20263

Latest 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 year(c.\"eventDate\") = 1986
    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.

NTSB ANC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe pilot stated he encountered freezing rain and due to the build-up on the aircraft, he stalled and crashed in an open area next to the airport.Dec 7, 1986 · N9940D · Substantial damageNTSB ANC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork Rive, AKThe pilot lost control of the aircraft and nosed over during landing on a gravel bar. The pilot stated that the airplane nosed over because he stood on the brakes hard during the landing roll to prevent traveling into the river. The plt could not be contacted…Sep 21, 1986 · N202T · Substantial damageNTSB 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 damageNTSB ANC86LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcneil River, AKPilot applied brakes too firmly; lost control on landing and aircraft nosed over on its back.Aug 19, 1986 · N146T · Substantial damageNTSB ANC86LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrovahn, AKThe plt reported a total loss of pwr occurred while maneuvering over an area to observe the terrain. A forced landing was made on a gravel bar during which the acft nosed over. In his recommendation on how the accident could have been prevented, the plt…Jul 3, 1986 · N5472H · Substantial damageNTSB ANC86LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe flight instructor stated that he was demonstrating a stall landing to the student pilot. After touchdown and rollout the aircraft struck a snow drift on the runway causing the aircraft to nose over on its back.Mar 24, 1986 · N7145K · Substantial damageNTSB ANC86LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Houston, AKThe pilot was buzzing the area less than 200 feet above the ground when the engine started to run rough; the pilot attempted to land near the road when the aircraft struck power lines and a row of trees. Examination of the engine revealed no mechanical…Feb 23, 1986 · N1827A · Substantial damage