Skip to content

NTSB investigations: Piper J3C-65, AL

26 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.

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" = 'AL' 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

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\" = 'AL' 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" = 'AL' 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

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 ERA20LA023Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Grand Bay, ALA loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.Oct 27, 2019 · N7009H · Substantial damage NTSB GAA19CA539Accident · No injuriesData collectionFinal reportPiper J3C · Winfield, ALThe pilot's failure to maintain proper wind correction input during taxi in a gusting tailwind, which resulted in a nose over.Sep 4, 2019 · N7326H · Substantial damage NTSB ATL82FKJ12Accident · 1 fatalFinal reportPiper J3C-65 · Alabaster, ALDuring an air show, the aircraft was observed flying slowly over the runway on a southerly heading at about 200 to 250 ft AGL. Full left rudder was applied along with full up elevator and the plane entered a spin. After one turn, full opposite rudder was…May 16, 1982 · N42799 · Destroyed NTSB ATL81FKJ24Accident · 1 fatalClosedPiper J3C-65 · Fadette, ALJul 13, 1981 · N2220M · Substantial damage NTSB MIA77FKJ30Accident · Minor injuriesClosedPiper J3 · Graysville, ALApr 16, 1977 · N30451 · Substantial damage NTSB MIA77DKJ31Accident · Serious injuriesClosedPiper J-3 · Mobile, ALApr 16, 1977 · N65881 · Substantial damage NTSB MIA74DKJ04Accident · Serious injuriesClosedPiper J3C · Guntersville, ALJul 21, 1974 · N7473H · Substantial damage NTSB IAD73A1006Accident · 2 fatalClosedPiper J3 · Brundidge, ALMar 24, 1973 · N98633 · Destroyed NTSB MIA71DKJ21Accident · No injuriesClosedPiper J-3 · Hazel Green, ALOct 1, 1970 · N5555P · Substantial damage NTSB MIA70DKJ28Accident · No injuriesClosedPiper J-3 · Bessemer, ALApr 29, 1970 · N98453 · Substantial damage NTSB MIA70D0186Accident · No injuriesClosedPiper J-3 · Bay Minette, ALSep 29, 1969 · N35471 · Substantial damage NTSB MIA69F0425Accident · Minor injuriesClosedPiper J-3 · Laceys Spring, ALMar 20, 1969 · N58378 · Substantial damage NTSB MIA69I0259Incident · No injuriesClosedPiper J-3 · Ozark, ALNov 23, 1968 · N98576 · No damage NTSB MIA69F0197Accident · Serious injuriesClosedPiper J3C-65 · Headland, ALOct 20, 1968 · N92043 · Substantial damage NTSB MIA68A0103Accident · 2 fatalClosedPiper J3C-65 · Montgomery, ALJun 8, 1968 · N65886 · Substantial damage NTSB MIA68A0018Accident · 1 fatalClosedPiper J3C-65 · Headland, ALAug 9, 1967 · N3419N · Destroyed NTSB MIA68D0054Accident · Serious injuriesClosedPiper J-3 · Dothan, ALJul 1, 1967 · N42999 · Destroyed NTSB MIA67A0093Accident · 1 fatalClosedPiper J3C-65 · Fosters, ALMar 10, 1967 · N92295 · Destroyed NTSB MIA67D0312Accident · No injuriesClosedPiper L-4 · Guntersville, ALNov 24, 1966 · N42933 · Substantial damage NTSB MIA67D0242Accident · Minor injuriesClosedPiper J-3 · Florence, ALSep 24, 1966 · N98069 · Substantial damage NTSB MIA67F0161Accident · No injuriesClosedPiper J3C-65 · Fort Payne, ALSep 7, 1966 · N32612 · Substantial damage NTSB MIA66A0081Accident · 2 fatalClosedPiper J3 · Piedmont, ALJan 8, 1966 · N92358 · Destroyed NTSB MIA65A0088Accident · 2 fatalClosedPiper J3C · Atmore, ALFeb 28, 1965 · N70262 · Destroyed NTSB UNK64X3481Accident · Minor injuriesClosedPiper J3 · Talladega, ALAug 19, 1964 · N98023 · Destroyed NTSB UNK64X3442Accident · Minor injuriesClosedPiper J3C · Headland, ALAug 17, 1964 · N92304 · Substantial damage NTSB UNK64X0853Accident · 1 fatalClosedPiper J-3C · Chunchula, ALMar 8, 1964 · N24879 · Destroyed