Skip to content

NTSB investigations: Piper PA-22-150

1,313 cases on aircraft the registry lists as Piper PA-22-150. 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 ('7102210')) 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 ('7102210'))
  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 ('7102210'))
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 CHI67F0398Accident · No injuriesClosedPiper PA-22 · Elyria, OHDec 4, 1966 · N6859B · Substantial damage NTSB FTW67F0427Accident · No injuriesClosedPiper PA-22 · Kingsville, TXDec 3, 1966 · N6135D · Substantial damage NTSB FTW67D0341Accident · No injuriesClosedPiper PA-22 · Buffalo, TXDec 2, 1966 · N4803A · Substantial damage NTSB LAX67F0212Accident · No injuriesClosedPiper PA-22 · San Diego, CANov 26, 1966 · N1720P · Substantial damage NTSB SEA67D0215Accident · Serious injuriesClosedPiper PA-22 · Gibbon, ORNov 25, 1966 · N5830D · Destroyed NTSB CHI67D0399Accident · Minor injuriesClosedPiper PA-22 · Sycamore, OHNov 24, 1966 · N9641D · Substantial damage NTSB MKC67D0346Accident · No injuriesClosedPiper PA-22 · Independence, MONov 20, 1966 · N7159D · Substantial damage NTSB MIA67F0358Accident · Minor injuriesClosedPiper PA-22 · Lake City, FLNov 8, 1966 · N7749D · Substantial damage NTSB MKC67F0266Accident · No injuriesClosedPiper PA22 · Lisbon, NDOct 26, 1966 · N2306P · Substantial damage NTSB OAK67D0145Accident · No injuriesClosedPiper PA-22 · Milpitas, CAOct 22, 1966 · N2476P · Substantial damage NTSB CHI67A0053Accident · 2 fatalClosedPiper PA-22 · Stow, OHOct 21, 1966 · N6952D · Destroyed NTSB MIA67A0049Accident · 4 fatalClosedPiper PA-22 · Cross, SCOct 17, 1966 · N4502A · Destroyed NTSB MKC67D0255Accident · No injuriesClosedPiper PA-22 · De Witt, IAOct 16, 1966 · N4744A · Substantial damage NTSB LAX67D0218Accident · No injuriesClosedPiper PA-22 · Seligman, AZOct 13, 1966 · N2437P · Substantial damage NTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYOct 5, 1966 · N4751A · Substantial damage NTSB SEA67D0190Accident · No injuriesClosedPiper PA-22 · Idanha, OROct 2, 1966 · N4418A · Substantial damage NTSB MKC67D0225Accident · No injuriesClosedPiper PA-22 · Lebanon, IAOct 2, 1966 · N6166D · Substantial damage NTSB DEN67F0175Accident · No injuriesClosedPiper PA-22 · Greeley, COSep 30, 1966 · N7614D · Substantial damage NTSB NYC67F0281Accident · Minor injuriesClosedPiper PA-22 · Sinclair, MESep 29, 1966 · N6900B · Destroyed NTSB MIA67A0034Accident · 2 fatalClosedPiper PA-22 · Newberry, SCSep 11, 1966 · N1923P · Destroyed NTSB CHI67F0296Accident · Serious injuriesClosedPiper PA-22 · Toronto, OHSep 6, 1966 · N7445D · Destroyed NTSB ANC67F0030Accident · Serious injuriesClosedPiper PA-22 · Yakutat, AKSep 2, 1966 · N6940D · Substantial damage NTSB ANC67D0054Accident · No injuriesClosedPiper PA-22 · Chugiak, AKAug 31, 1966 · N7835D · Substantial damage NTSB NYC67D0273Accident · No injuriesClosedPiper PA-22 · Colebrook, NHAug 25, 1966 · N3556P · Substantial damage NTSB SEA67F0214Accident · No injuriesClosedPiper PA-22 · Hillsboro, ORAug 24, 1966 · N2931P · Substantial damage NTSB FTW67D0183Accident · Serious injuriesClosedPiper PA-22 · Borger, TXAug 23, 1966 · N3752P · Destroyed NTSB ANC67D0021Accident · No injuriesClosedPiper PA-22 · Moses Point, AKAug 21, 1966 · N3661P · Substantial damage NTSB MIA67F0133Accident · No injuriesClosedPiper PA-22 · Claxton, GAAug 18, 1966 · N4335A · Substantial damage NTSB SEA67D0087Accident · No injuriesClosedPiper PA-22 · Heppner, ORAug 8, 1966 · N4512A · Substantial damage NTSB SEA67A0009Accident · 2 fatalClosedPiper PA-22 · Seaside, ORAug 7, 1966 · N7629D · Destroyed NTSB NYC67F0210Accident · No injuriesClosedPiper PA-22 · Roscoe, NYAug 7, 1966 · N7457D · Substantial damage NTSB LAX67D0080Accident · No injuriesClosedPiper PA-22 · Santa Ana, CAAug 7, 1966 · N9670D · Substantial damage NTSB MKC67D0256Accident · No injuriesClosedPiper PA-22 · Ft.Thompson, SDAug 3, 1966 · N1790P · Substantial damage NTSB SEA67F0086Accident · Minor injuriesClosedPiper PA-22 · Eurek, MTJul 30, 1966 · N6063D · Substantial damage NTSB MKC67D0100Accident · No injuriesClosedPiper PA-22 · Milesville, SDJul 28, 1966 · N2639P · Substantial damage NTSB NYC67D0116Accident · No injuriesClosedPiper PA-22 · Bridgeport, NJJul 24, 1966 · N3228Z · Substantial damage NTSB MKC67F0103Accident · No injuriesClosedPiper PA-22 · Cuba, MOJul 18, 1966 · N9303D · Substantial damage NTSB DEN67D0026Accident · No injuriesClosedPiper PA-22 · Santa Rosa, NMJul 13, 1966 · N6067D · Substantial damage NTSB ANC67A0004Accident · 2 fatalClosedPiper PA-22 · Fairbanks, AKJul 11, 1966 · N2913Z · Destroyed NTSB ANC67A0001Accident · Minor injuriesClosedPiper PA-22 · Garden City, NYJul 11, 1966 · N3500P · Destroyed NTSB MKC67D0071Accident · Minor injuriesClosedPiper PA-22 · Pittsburg, KSJul 10, 1966 · N5701D · Substantial damage NTSB SEA67D0117Accident · No injuriesClosedPiper PA-22 · Vancouver, WAJul 4, 1966 · N4507A · Substantial damage NTSB MIA67D0063Accident · No injuriesClosedPiper PA-22 · Lewisburg, NCJul 4, 1966 · N2703P · Substantial damage NTSB FTW67F0064Accident · No injuriesClosedPiper PA22 · El Paso, TXJun 30, 1966 · N3012Z · Substantial damage NTSB MKC67F0131Accident · No injuriesClosedPiper PA-22 · Topeka, KSJun 27, 1966 · N7159D · Substantial damage NTSB MIA67F0079Accident · Minor injuriesClosedPiper PA-22 · Starr, SCJun 15, 1966 · N3659P · Substantial damage NTSB DEN67D0063Accident · Minor injuriesClosedPiper PA-22 · Conifer, COJun 14, 1966 · N5633Z · Substantial damage NTSB MIA66F0578Accident · Minor injuriesClosedPiper PA-22 · Parsons, TNJun 12, 1966 · N7434D · Destroyed NTSB FTW67D0040Accident · No injuriesClosedPiper PA-22 · Strawn, TXJun 12, 1966 · N3825P · Substantial damage NTSB CHI67F0022Accident · Minor injuriesClosedPiper PA-22 · Middleton, WIJun 2, 1966 · N9964D · Substantial damage