NTSB investigations: Piper J3C-65, MO
15 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 | 1 |
| 1967 | 2 |
| 1970 | 1 |
| 1975 | 3 |
| 1976 | 2 |
| 1980 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 2021 | 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\" = 'MO' 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" = 'MO' 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 CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.NTSB MKC89FA090Accident · 2 fatalField investigationFinal reportPiper J-3 · Oak Grove, MOThe pilot's attempt to takeoff with the aircraft over its allowable takeoff weight and out of the center of gravity limits.NTSB MKC89FA011Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Harrisonville, MOThe plt elected to fly in winds that were gusting from the northwest. He stated that while taking off to the north, he was maintaining a normal rate of climb & airspeed, but at aprx 100 ft AGL, the acft enctrd a sudden severe downdraft & was slammed to the…NTSB MKC88FA171Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Goodman, MOEngine ignition and lubrication problems which resulted in the pilot's election to execute a precautionary landing. A contributing factor was the pilot's inability to see and avoid power lines in his approach path due to bright sunshine.NTSB MKC81FA004Accident · 1 fatalClosedPiper J3C-65 · Senath, MONTSB MKC77DCG04Accident · No injuriesClosedLuscombe 8A · Carthage, MONTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MONTSB MKC76FCG30Accident · Minor injuriesClosedPiper J-3 · Grain Valley, MONTSB MKC76FCG20Accident · Serious injuriesClosedPiper J3C · Cameron, MONTSB MKC76DCG16Accident · Minor injuriesClosedPiper J-3 · Sedalia, MONTSB MKC71DCG25Accident · No injuriesClosedPiper J3C-65 · Fairfax, MONTSB MKC68D0392Accident · No injuriesClosedPiper J3C-65 · Lancaster, MONTSB MKC67F0621Accident · Serious injuriesClosedPiper J-3 · Higginsville, MONTSB MKC67F0132Accident · No injuriesClosedPiper J-3 · Waldron, MONTSB UNK64X0808Accident · No injuriesClosedPiper J3C · Lancaster, MO