Final NTSB investigations: Piper J3C-65, ND
14 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 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1990 | 1 |
| 2001 | 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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" = 'ND' AND c."eventCountry" = 'USA'
AND c."completionStatus" = 'Completed'
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 CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.NTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.NTSB MKC77DTG08Accident · No injuriesClosedPiper J-3 · Kenmare, NDNTSB MKC76DTG08Accident · No injuriesClosedPiper J-3 · Rolette, NDNTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDNTSB MKC72FTG16Accident · No injuriesClosedPiper J-3 · Crosby, NDNTSB MKC72DTG15Accident · No injuriesClosedPiper J-3 · Mott, NDNTSB MKC72DTG14Accident · No injuriesClosedPiper J-3 · Colgan, NDNTSB MKC69D0337Accident · No injuriesClosedPiper J-3 · Stanley, NDNTSB MKC69F0047Accident · No injuriesClosedPiper J3-65 · Carrington, NDNTSB MKC68F0323Accident · No injuriesClosedPiper J-3 · Douglas, NDNTSB MKC67F0046Accident · No injuriesClosedPiper J3C-65 · Regent, NDNTSB MKC67F0034Accident · Serious injuriesClosedPiper J3C · New England, NDNTSB UNK64X3595Accident · No injuriesClosedPiper J3 · Lucca, ND