Skip to content

Fatal NTSB investigations: Piper PA-18A

33 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 per year

19642026

Where

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."highestInjuryLevel" = 'Fatal' 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

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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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

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 ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.Mar 31, 2012 · N7276D · Substantial damage NTSB CHI03FA003Accident · 1 fatalField investigationFinal reportPiper PA-18A · Garden City, KSThe inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.Oct 2, 2002 · N3279Z · Destroyed NTSB ANC93FA167Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Sanona Creek, AKThe pilot's failure to maintain flying speed during a downwind turn for landing. Factors contributing to the accident were: the overweight condition of the airplane, and failure to assure that the airplane complied with all applicable airworthiness…Sep 2, 1993 · N4713A · Destroyed NTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…Jul 28, 1990 · N2789P · Destroyed 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 MIA81FA031Accident · 2 fatalClosedPiper PA-18A · Lake Wales, FLDec 30, 1980 · N1956A · Destroyed NTSB SEA76FTI38Accident · 1 fatalClosedPiper PA-18A · Helena, MTAug 31, 1976 · N1189C · Substantial damage NTSB OAK75AP006Accident · 1 fatalClosedPiper PA-18A · Meridian, CAAug 13, 1974 · N9914D · Destroyed NTSB MKC73FER68Accident · 1 fatalClosedPiper PA-18A · Beardsley, MNJun 12, 1973 · N8073D · Destroyed NTSB ANC73AAO32Accident · 2 fatalClosedPiper PA-18A · Portage, AKNov 4, 1972 · N7287D · Destroyed NTSB ANC73AA025Accident · 1 fatalClosedPiper PA-18 · Iliamna, AKOct 7, 1972 · N2263A · Destroyed NTSB DEN71FX202Accident · 1 fatalClosedPiper PA-18A · Monticello, UTJul 25, 1970 · N2976P · Destroyed NTSB MKC70F0191Accident · 1 fatalClosedPiper PA-18A · Gillett Grve, IAAug 26, 1969 · N9901D · Destroyed NTSB NYC70A0005Accident · 2 fatalClosedPiper PA-18 · Sewell, NJJul 4, 1969 · N9362D · Destroyed NTSB LAX69F0140Accident · 1 fatalClosedPiper PA-18A · Lompoc, CAAug 26, 1968 · N1631A · Substantial damage NTSB FTW69A0012Accident · 1 fatalClosedPiper PA-18A · Sinton, TXAug 24, 1968 · N7798B · Destroyed NTSB DIA69F0056Accident · 1 fatalClosedPiper PA-18A · Parkton, NCAug 19, 1968 · N1459C · Destroyed NTSB ANC68A0042Accident · 1 fatalClosedPiper PA-18 · Nome, AKMar 12, 1968 · N2159A · Destroyed NTSB MIA68A0003Accident · 1 fatalClosedPiper PA-18A · Bonita Sprgs, FLJul 4, 1967 · N1677P · Destroyed NTSB SEA67A0072Accident · 2 fatalClosedPiper PA-18 · Parma, IDJun 10, 1967 · N2879P · Destroyed NTSB SEA67A0066Accident · 1 fatalClosedPiper PA-18A · Absarokee, MTMay 22, 1967 · N9446D · Destroyed NTSB CHI67A0036Accident · 1 fatalClosedPiper PA-18A · Topeka, ILSep 8, 1966 · N3198Z · Destroyed NTSB MKC67A0016Accident · 1 fatalClosedPiper PA-18A · East Chain, MNAug 25, 1966 · N9939D · Destroyed NTSB MIA67A0026Accident · 1 fatalClosedPiper PA-18A · Eufaula Ala, ALAug 19, 1966 · N8675C · Destroyed NTSB FTW66A0081Accident · 1 fatalClosedPiper PA-18A · Electra, TXMar 19, 1966 · N9360D · Destroyed NTSB MIA66A0028Accident · 1 fatalClosedPiper PA-18A · Clarksdale, MSSep 8, 1965 · N1981A · Destroyed NTSB MIA65A0121Accident · 1 fatalClosedPiper PA-18 · Hartsville, SCJun 18, 1965 · N7160B · Destroyed NTSB MIA65A0119Accident · 1 fatalClosedPiper PA-18A · Lambert, MSJun 17, 1965 · N8169C · Destroyed NTSB SEA65A0062Accident · 1 fatalClosedPiper PA-18A · Great Falls, MTMay 11, 1965 · N1295C · Destroyed NTSB FTW65A0100Accident · 1 fatalClosedPiper PA-18 · Royse City, TXApr 9, 1965 · N8677D · Destroyed NTSB UNK64X2527Accident · 1 fatalClosedPiper PA18A · Sinton, TXJun 27, 1964 · N7797B · Destroyed NTSB UNK64X2483Accident · 1 fatalClosedPiper PA18A · Jamestown, NDJun 25, 1964 · N4870A · Destroyed NTSB UNK64X1512Accident · 1 fatalClosedPiper PA18A · Belt, MTApr 29, 1964 · N3686P · Destroyed