Skip to content

NTSB investigations: Piper PA-12

817 cases on aircraft the registry lists as Piper PA-12. 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101202')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101202'))
  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 ('7101202'))
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 CHI67D0407Accident · No injuriesClosedPiper PA-12 · Bowling Grn, OHNov 13, 1966 · N92571 · Substantial damage NTSB CHI67F0306Accident · No injuriesClosedPiper PA12 · Woodruff, WINov 6, 1966 · N2824M · Substantial damage NTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNov 5, 1966 · N4459M · Substantial damage NTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PAOct 30, 1966 · N3414M · Destroyed NTSB NYC67F0344Accident · Serious injuriesClosedPiper PA-12 · Waynesboro, VAOct 23, 1966 · N2890M · Substantial damage NTSB ANC67F0067Accident · No injuriesClosedPiper PA-12 · Anchorage, AKSep 24, 1966 · N3683M · Substantial damage NTSB MIA67F0186Accident · No injuriesClosedPiper PA-12 · Fayetteville, TNSep 16, 1966 · N92765 · Substantial damage NTSB SEA67F0129Accident · Minor injuriesClosedPiper PA-12 · Thomp. Falls, MTSep 10, 1966 · N78576 · Substantial damage NTSB NYC67D0209Accident · No injuriesClosedPiper PA-12 · Atlantic City, NJAug 24, 1966 · N7576H · Substantial damage NTSB NYC67D0324Accident · No injuriesClosedPiper PA-12 · Bluefield, WVAug 18, 1966 · N4346M · Substantial damage NTSB MKC67F0124Accident · No injuriesClosedPiper PA-12 · Allison, IAAug 14, 1966 · N2674M · Substantial damage NTSB NYC67F0139Accident · No injuriesClosedPiper PA-12 · Annville, PAJul 24, 1966 · N87809 · Substantial damage NTSB MIA67F0009Accident · Minor injuriesClosedPiper PA12 · Gallatin, TNJul 17, 1966 · N98966 · Substantial damage NTSB NYC67D0046Accident · No injuriesClosedPiper PA12 · Palmyra, NYJul 10, 1966 · N4448M · Substantial damage NTSB DEN67D0052Accident · No injuriesClosedPiper PA-12 · Blanding, UTJul 9, 1966 · N7909H · Substantial damage NTSB MKC67F0037Accident · Minor injuriesClosedPiper PA-12 · Madison, NEJun 27, 1966 · N2564M · Substantial damage NTSB NYC67F0036Accident · Serious injuriesClosedPiper PA-12 · Chesapeake, VAJun 21, 1966 · N4222M · Substantial damage NTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCJun 15, 1966 · N3656M · Substantial damage NTSB FTW67D0011Accident · No injuriesClosedPiper PA-12 · Salem, ARJun 5, 1966 · N3687N · Substantial damage NTSB NYC67F0004Accident · No injuriesClosedPiper PA12 · Cato, NYJun 4, 1966 · N2793M · Substantial damage NTSB CHI66A0095Accident · 1 fatalClosedPiper PA-12 · Gaylord, MIMay 30, 1966 · N2906M · No damage NTSB CHI67F0031Accident · No injuriesClosedPiper PA-12 · Windfall, INMay 27, 1966 · N2457M · Substantial damage NTSB NYC66F0670Accident · No injuriesClosedPiper PA-12 · Princeton, NJMay 26, 1966 · N3081M · Substantial damage NTSB DEN66D0359Accident · No injuriesClosedPiper PA12 · Yuma, COMay 22, 1966 · N3419M · Substantial damage NTSB SEA67D0010Accident · Minor injuriesClosedPiper PA-12 · La Grande, ORMay 20, 1966 · N3744M · Destroyed NTSB NYC66F0707Accident · No injuriesClosedPiper PA-12 · Mechanicsville, VAMay 15, 1966 · N839Z · Substantial damage NTSB DEN66D0317Accident · No injuriesClosedPiper PA-12 · Roswell, NMMay 12, 1966 · N3780M · Substantial damage NTSB LAX66F0326Accident · Serious injuriesClosedPiper PA-12 · Iverside, CAApr 26, 1966 · N3786M · Substantial damage NTSB CHI66D0677Accident · No injuriesClosedPiper PA-12 · Minooka, ILApr 16, 1966 · N7769H · Substantial damage NTSB NYC66D0581Accident · No injuriesClosedPiper PA-12 · So Woodstock, CTApr 8, 1966 · N3583M · Substantial damage NTSB FTW66D0688Accident · No injuriesClosedPiper PA-12 · San Antonio, TXApr 8, 1966 · N3121M · Substantial damage NTSB NYC66D0580Accident · No injuriesClosedPiper PA-12 · Gaithersburg, MDMar 21, 1966 · N4231M · Substantial damage NTSB NYC66D0643Accident · No injuriesClosedPiper PA-12 · Tappahannock, VAMar 19, 1966 · N4462M · Destroyed NTSB MKC66F0437Accident · No injuriesClosedPiper PA-12 · Appleton, MNFeb 16, 1966 · N2511M · Substantial damage NTSB CHI66D0636Accident · No injuriesClosedPiper PA-12 · Roselle, ILFeb 5, 1966 · N7613H · Substantial damage NTSB MIA66F0440Accident · Minor injuriesClosedPiper PA-12 · Forsyth, GAFeb 3, 1966 · N2782M · Substantial damage NTSB CHI66F0628Accident · No injuriesClosedPiper PA-12 · Rockford, ILFeb 2, 1966 · N92732 · Substantial damage NTSB ANC66D0093Accident · No injuriesClosedPiper PA-12 · Campbell Lke, AKJan 27, 1966 · N4112M · Substantial damage NTSB NYC66D0490Accident · No injuriesClosedPiper PA-12 · Morganville, NJDec 19, 1965 · N92713 · Substantial damage NTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damage NTSB MKC66F0322Accident · Minor injuriesClosedPiper PA-12 · Fort Dodge, IANov 2, 1965 · N3812M · Substantial damage NTSB CHI66F0453Accident · No injuriesClosedPiper PA-12 · Akron, OHOct 29, 1965 · N4020H · Substantial damage NTSB MIA66D0325Accident · No injuriesClosedPiper PA-12 · Gainesville, FLOct 19, 1965 · N3446M · Substantial damage NTSB NYC66F0285Accident · No injuriesClosedPiper PA-12 · College Park, MDOct 9, 1965 · N2573M · Substantial damage NTSB MKC66F0248Accident · Minor injuriesClosedPiper PA-12 · Lemars, IAOct 9, 1965 · N4035M · Substantial damage NTSB CHI66F0381Accident · No injuriesClosedPiper PA-12 · Rensselaer, INSep 25, 1965 · N7743H · Substantial damage NTSB ANC66D0035Accident · No injuriesClosedPiper PA-12 · Fairbanks, AKSep 23, 1965 · N4409M · Substantial damage NTSB UNK65X1536Accident · Serious injuriesClosedPiper PA12S · Ely, VTSep 21, 1965 · N98918 · Substantial damage NTSB UNK65X1527Accident · No injuriesClosedPiper PA-12 · Aleknagik, AKAug 26, 1965 · N4369M · Substantial damage NTSB MKC66D0213Accident · No injuriesClosedPiper PA-12 · Marion, IAAug 23, 1965 · N7502H · Substantial damage