Skip to content

NTSB investigations: Piper PA-18A

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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

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'))
  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'))
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 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.Oct 8, 1986 · N6191D · Substantial damage NTSB ANC86LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Stoney River, AKAccording to a witness, a certificated pilot, a crowd had gathered to wave, watch the takeoff and take photographs. The airplane began its takeoff roll about mid point on the airstrip and rolled 120 feet before lifting off. The airplane climbed steeply and…Jul 12, 1986 · N1825A · Substantial damage NTSB DEN85LQA03Accident · No injuriesFinal reportPiper PA-18A · Tucumcari, NMOn July 4, 1985, at 1400 MDT, a Piper PA-18, N1754A, registered to ted w. stallings, departed the designated taxiway and collided with a culvert at Tucumcari municipal airport, Tucumcari, new Mexico. The aircraft was being taxied for thepurpose of a local…Jul 4, 1985 · N1754A · Substantial damage NTSB ANC84LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Anchorage, AKThe plt stated that just prior to the eng failure, the left fuel tank 'was empty' and the right tank contained approximately 1/8 of a tank of fuel. The plt suspected fuel starvation.Jan 24, 1984 · N7286D · Substantial damage 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…Dec 29, 1983 · N1829A · Substantial damage NTSB ANC83LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Big Lake, AKThe acft collided with bushes at the departure end of the rwy. The pilot told the investigator that he attempted to takeoff from the grass strip but aborted at the last moment. He said he was unable to stop the acft before striking bushes at the departure end.Sep 17, 1983 · N7286D · Substantial damage 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…Jun 25, 1983 · N1144A · Substantial damage 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.May 24, 1983 · N8576C · Substantial damage NTSB FTW82FRG35Accident · Minor injuriesFinal reportPiper PA-18A · San Marcos, TXThe pilot was on a flight to spray his own farm. While maneuvering during aerial application, the left wing tip struck a telephone guy wire and then the plane crashed. The pilot had been spraying his own farm over the previous 10 yrs with the same telephone…Jun 4, 1982 · N3590P · Destroyed NTSB ANC81DAG92Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKSep 27, 1981 · N4359A · Substantial damage NTSB FTW81DRA55Accident · No injuriesClosedPiper PA-18 · Palacios, TXAug 25, 1981 · N1959A · Substantial damage NTSB ANC81DAG65Accident · No injuriesClosedPiper PA-18A · Canyon Creek, AKAug 9, 1981 · N6760B · Substantial damage NTSB DEN81DTM24Accident · No injuriesClosedPiper PA-18 · Moab, UTMay 14, 1981 · N8481D · Substantial damage NTSB MIA81FA031Accident · 2 fatalClosedPiper PA-18A · Lake Wales, FLDec 30, 1980 · N1956A · Destroyed NTSB ANC80DAG19Accident · No injuriesClosedPiper PA-18 · Lachbuna Lake, AKDec 4, 1979 · N2854D · Substantial damage NTSB ANC79DAH17Accident · No injuriesClosedPiper PA-18 · Farewell, AKAug 23, 1979 · N4737A · Substantial damage NTSB ANC79DAG90Accident · No injuriesClosedPiper PA-18 · Anchorage, AKAug 7, 1979 · N7186D · Substantial damage NTSB ANC78DAH20Accident · No injuriesClosedPiper PA-18 · Palmer, AKSep 8, 1978 · N1752A · Substantial damage NTSB ANC78DAG25Accident · Minor injuriesClosedPiper PA-18 · Eureka, AKFeb 17, 1978 · N1793A · Substantial damage NTSB CHI78DET12Accident · Minor injuriesClosedPiper PA-18A · Three Oaks, MIFeb 10, 1978 · N4490A · Substantial damage NTSB ANC76DAH86Accident · No injuriesClosedPiper PA-18 · Chitina, AKSep 24, 1976 · N7286D · Substantial damage NTSB SEA76FTI38Accident · 1 fatalClosedPiper PA-18A · Helena, MTAug 31, 1976 · N1189C · Substantial damage NTSB ANC76DAH55Accident · No injuriesClosedPiper PA-18 · Kodiak, AKAug 9, 1976 · N2496P · Substantial damage NTSB ANC76DAA36Accident · Minor injuriesClosedPiper PA-18 · Healy, AKMay 22, 1976 · N1856A · Substantial damage NTSB MIA76DKT60Accident · No injuriesClosedPiper PA-18A · Ft Lauderdale, FLMar 23, 1976 · N4388A · Substantial damage NTSB SEA76DYA22Accident · No injuriesClosedPiper PA-18 · Idaho Falls, IDJan 25, 1976 · N3707A · Substantial damage NTSB OAK76DVG38Accident · Serious injuriesClosedPiper PA-18A · Tulelake, CADec 28, 1975 · N1452C · Destroyed NTSB ANC76DAG45Accident · No injuriesClosedPiper PA-18 · Mcgrath, AKSep 22, 1975 · N7186D · Substantial damage NTSB ANC76DAG10Accident · No injuriesClosedPiper PA-18 · Whittier, AKJul 7, 1975 · N2891P · Substantial damage NTSB DEN75FTC11Accident · No injuriesClosedPiper PA-18 · Casper, WYDec 2, 1974 · N2154A · Substantial damage NTSB SEA75DYC17Accident · Minor injuriesClosedPiper PA-18A · Friend, ORSep 26, 1974 · N1456C · Substantial damage NTSB ANC75DAG31Accident · No injuriesClosedPiper PA-18 · Glennallen, AKSep 4, 1974 · N1987A · Substantial damage NTSB OAK75AP006Accident · 1 fatalClosedPiper PA-18A · Meridian, CAAug 13, 1974 · N9914D · Destroyed NTSB ANC74DAH21Accident · No injuriesClosedPiper PA-18A · Homer, AKJun 15, 1974 · N2496P · Substantial damage NTSB DEN74DTE65Accident · No injuriesClosedPiper PA-18A · Sheridan Lk, COApr 6, 1974 · N6760B · Substantial damage NTSB CHI74FET16Accident · Serious injuriesClosedPiper PA-24 · Fort Wayne, INDec 27, 1973 · N8074D · Destroyed NTSB SEA74DYE18Accident · No injuriesClosedPiper PA-18 · Arlington, WASep 23, 1973 · N7474D · Substantial damage NTSB SEA74DYA08Accident · No injuriesClosedPiper PA-18A · Mud Lake, IDAug 13, 1973 · N3707A · Substantial damage NTSB FTW73DRA40Accident · No injuriesClosedPiper PA-18A · Ganado, TXJun 27, 1973 · N1874A · Substantial damage NTSB MKC73FER68Accident · 1 fatalClosedPiper PA-18A · Beardsley, MNJun 12, 1973 · N8073D · Destroyed NTSB CHI73FEV24Accident · Minor injuriesClosedPiper PA-18A · Claremont, ILMar 13, 1973 · N1471C · Destroyed NTSB ANC73AAO32Accident · 2 fatalClosedPiper PA-18A · Portage, AKNov 4, 1972 · N7287D · Destroyed NTSB FTW73FRD09Accident · Serious injuriesClosedPiper PA-18 · Bayou Chene, LAOct 15, 1972 · N1860P · Destroyed NTSB ANC73AA025Accident · 1 fatalClosedPiper PA-18 · Iliamna, AKOct 7, 1972 · N2263A · Destroyed NTSB ANC73DAA10Accident · Serious injuriesClosedPiper PA-18 · Fairbanks, AKSep 4, 1972 · N7561D · Substantial damage NTSB ANC73DAG28Accident · No injuriesClosedPiper PA-18A · Skwentna, AKSep 2, 1972 · N2666P · Substantial damage NTSB ANC72DAA36Accident · No injuriesClosedPiper PA-18 · Clear, AKJun 10, 1972 · N8091D · Substantial damage NTSB OAK72DVG67Accident · No injuriesClosedPiper PA-18A · Lincoln, CAJun 4, 1972 · N2854D · Substantial damage NTSB FTW72DPG71Accident · No injuriesClosedPiper PA-18 · Forrest City, ARMay 2, 1972 · N9887D · Substantial damage NTSB FTW72FQG30Accident · No injuriesClosedPiper PA-18A · Friona, TXFeb 15, 1972 · N7496D · Substantial damage