NTSB investigations: Piper J3C-65
12 cases on aircraft the registry lists as Piper J3C-65, where the sequence of events included Collision during takeoff/land. 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
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2026 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100510')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('7100510')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN27LA021Accident · 1 fatalClass 3 · LimitedInvestigation openPiper J3C-65 · Boonville, INNTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB CEN24LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Park Rapids, MNThe pilot’s failure to maintain directional control and terrain clearance during initial climb, that resulted in an impact with trees and terrain.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB CEN19LA184Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Vine Grove, KYThe pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.NTSB ERA15CA143Accident · No injuriesData collectionFinal reportPiper J3C 65 · Clermont, FLThe pilot's failure to land the airplane within the desired touchdown zone, resulting in a long landing and collision with a fence.NTSB WPR14CA223Accident · No injuriesData collectionFinal reportPiper J3C 65 · Bellingham, WAThe pilot's failure to maintain directional control during the landing on a narrow airstrip, which resulted in a collision with trees.NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.NTSB MIA08LA109Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Durham, NCThe pilot's failure to maintain clearance from trees while approaching to land.NTSB DFW08CA069Accident · No injuriesData collectionFinal reportPiper J3C-65 · Shallowater, TXFailure of the pilot to maintain a safe clearance from the terrain while manuevering for the landing surface.