NTSB investigations: Piper J3C-65, MT
21 cases on aircraft the registry lists as Piper J3C-65. 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1994 | 2 |
| 1997 | 1 |
| 2023 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'MT' 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 ('7100510'))
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" = 'MT' 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 ('7100510'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR23LA311Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Miles City, MTThe pilot's failure to maintain control of the airplane while landing on unimproved terrain.NTSB SEA97LA204Accident · 2 fatalLimited investigationFinal reportPiper J-3 · Jordan, MTThe pilot's inadequate remedial action during an inadvertent stall/spin entry. Factors include buzzing, a rapid pull-up, and failure to maintain proper airspeed (Vs).NTSB SEA94FA237Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Dixon, MTThe pilot in command's allowing the aircraft airspeed to decrease below the stall speed.NTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.NTSB DEN87FA002Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Richey, MTAfter making a low pass so the passenger could shoot at a coyote, the plt initiated a rgt turn to position the acft for another pass. While in the turn, the acft impacted the ground. The plt stated that the passenger (rear seat occupant) was partially out the…NTSB DEN86LA188Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ashland, MTPlt did not possess a plt certificate or medical certificate. The plt stated that he fueled the acft with the 'last gas in the storage tank.' The plt preflighted the acft and took off. Shortly after takeoff the engine lost power. The plt executed a landing in…NTSB DEN85FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Columbus, MTAfter making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact.NTSB DEN84LA078Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Billings, MTThe plt stated that during takeoff a gust of wind blew the acft to the right and he decided to abort the takeoff. Duringthe abort the acft departed the rwy, went down a bank and came to rest upside down.NTSB DEN83LA101Accident · No injuriesLimited investigationFinal reportPiper J3C65 · Kalispell, MTWhile making an approach to a field on a ranch, the acft hit a power line on short final and crashed upright in the field. The pilot said he did not see the wire across the north approach to the field.NTSB SEA77FTA21Accident · No injuriesClosedPiper J3C-65 · Scobey, MTNTSB SEA77FTA16Accident · No injuriesClosedPiper J3 · Otter, MTNTSB SEA76AS052Accident · 2 fatalClosedPiper J3C-65 · Rock Springs, MTNTSB SEA74DTA14Accident · No injuriesClosedPiper J-3 · Culbertson, MTNTSB SEA69F0121Accident · No injuriesClosedPiper J3C-65 · Chinook, MTNTSB SEA68D0165Accident · No injuriesClosedPiper J3C-65 · Richland, MTNTSB SEA66D0235Accident · No injuriesClosedPiper J3C · Lewiston, MTNTSB SEA66F0036Accident · No injuriesClosedPiper J3C-65 · Missoula, MTNTSB UNK65X0718Accident · No injuriesClosedPiper J3C · Billings, MTNTSB UNK64X2004Accident · No injuriesClosedPiper J3 · Winifred, MTNTSB UNK64X0677Accident · No injuriesClosedPiper J3 · Belgrade, MT