Skip to content

NTSB investigations: Piper PA-28-140, HI

24 cases on aircraft the registry lists as Piper PA-28-140. 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."eventStateOrRegion" = 'HI' 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 ('7102802')) 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\" = 'HI' 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 ('7102802'))
  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" = 'HI' 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 ('7102802'))
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 ANC25LA028Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Royal Kunia, HIImproper alteration of the crankshaft propeller flange at an unknown time, which resulted in an in-flight separation of the propeller assembly.Mar 27, 2025 · N261FC · Substantial damage NTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.Aug 21, 2018 · N98146 · Substantial damage NTSB WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.Jun 30, 2017 · N4244T · Substantial damage NTSB WPR09FA060Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kapolei, HIThe partial loss of engine power during the initial climb due to the failure of both pilots to use carburetor heat during a long descent for landing in carburetor icing conditions, and, the flight instructor's inadequate supervision of the flight.Dec 19, 2008 · N6182J · Substantial damage NTSB LAX01FA208Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Lanai City, HIthe CFI's inadequate in-flight planning/decision making, inadequate supervision, and his delayed remedial action, which resulted in controlled flight into terrain.Jun 15, 2001 · N319FC · Destroyed NTSB LAX98LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lanai City, HIInterference on the controls by the passenger as the aircraft neared touchdown, and the pilot's failure to adequately brief and supervise the passenger on the use and relinquishing of the flight controls. A factor in the accident was the intentional control…Oct 12, 1997 · N836FC · Destroyed NTSB LAX95FA031Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Honolulu, HIImproper loading of the airplane. Contributing to the accident was the pilot's failure to maintain minimum control airspeed.Nov 4, 1994 · N3198Q · Destroyed NTSB LAX84FJA02Accident · Serious injuriesFinal reportPiper PA-28-140 · Wailuku Maui, HIThe acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence.Aug 30, 1984 · N835FC · Destroyed NTSB LAX83FJA02Accident · No injuriesFinal reportPiper PA-28-140 · Honolulu, HIThe eng quit & the plt ditched in the ocean near the beach. The #4 connecting rod shank was found broken at the crankpin bearing housing. One rod bolt head was broken off & the bolt grip was necked down. The nut on this bolt was still on the bolt & flush with…Nov 16, 1982 · N56351 · Destroyed NTSB LAX82FJA04Accident · Serious injuriesFinal reportPiper PA-28-140 · Kalaupapa, HIWitnesses stated that the aircraft touched down approximately halfway down runway 5 with the winds out of the west. The pilot stated that when nearing the end of the runway she put on full throttle to initiate a go around but it was too late. The aircraft…Feb 7, 1982 · N16524 · Destroyed NTSB OAK78DJA14Accident · Minor injuriesClosedPiper PA-28 · Honolulu, HIAug 17, 1978 · N4448J · Destroyed NTSB OAK78FJA12Accident · No injuriesClosedPiper PA-28 · Honolulu, HIAug 2, 1978 · N3198Q · Substantial damage NTSB OAK75FJA01Accident · No injuriesClosedPiper PA-28 · Maui, HIAug 20, 1974 · N4259T · Destroyed NTSB OAK73FJA21Accident · Minor injuriesClosedPiper PA-28 · Honolulu, HIMay 23, 1973 · N8074N · Destroyed NTSB OAK72FJA11Accident · 1 fatalClosedPiper PA-28 · Hilo, HIDec 7, 1971 · N774FC · Destroyed NTSB OAK71FJA05Accident · No injuriesClosedPiper PA-28 · Waipahu, HISep 28, 1970 · N5702U · Substantial damage NTSB OAK70D0143Accident · Minor injuriesClosedPiper PA-28 · Kalaupapa, HIOct 10, 1969 · N163FC · Destroyed NTSB OAK70D0031Accident · Minor injuriesClosedPiper PA-28 · Hilo, HIJul 12, 1969 · N187FC · Substantial damage NTSB OAK69D0193Accident · Minor injuriesClosedPiper PA-28 · Pepeekeo, HIDec 15, 1968 · N4698R · Destroyed NTSB OAK68F0283Accident · No injuriesClosedPiper PA-28 · Waipahu, HIFeb 6, 1968 · N6649W · Substantial damage NTSB OAK67F0152Accident · No injuriesClosedPiper PA-28 · Honolulu, HINov 7, 1966 · N6649W · Substantial damage NTSB OAK67F0042Accident · No injuriesClosedPiper PA-28 · Honolulu, HIJul 30, 1966 · N6007W · Substantial damage NTSB OAK65F0054Accident · 1 fatalClosedPiper PA-28 · Lanai City, HIMar 9, 1965 · N6382W · Destroyed NTSB UNK65X0366Accident · No injuriesClosedPiper PA28 · Oahu, HIOct 22, 1964 · N6007W · Substantial damage