Fatal NTSB investigations: Piper PA-23-250 (6PCLM)
24 cases on aircraft the registry lists as Piper PA-23-250 (6PCLM). 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 6 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 2 |
| 1983 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102313'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102313'))
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 DEN83FA062Accident · 2 fatalField investigationFinal reportPiper PA-23F-250 · Moab, UTThe acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An…NTSB MIA81FA124Accident · 2 fatalClosedPiper PA-23 · Daytona Beach, FLNTSB ATL81FA053Accident · 2 fatalClosedPiper PA-23 · Kingstree, SCNTSB LAX80FA083Accident · 4 fatalClosedPiper PA-23 · Solvang, CANTSB MIA80FA045Accident · 1 fatalClosedPiper PA-23 · Bradley Jct, FLNTSB IAD79FA092Accident · 1 fatalClosedPiper PA-23 · Greensboro, NCNTSB CHI77FA060Accident · 1 fatalClosedPiper PA-23 · Plano, ILNTSB NYC76AN074Accident · 2 fatalClosedPiper PA-23 · S Burlington, VTNTSB LAX76AL032Accident · 3 fatalClosedPiper PA-23 · San Dimas, CANTSB NYC76AN045Accident · 6 fatalClosedPiper PA-23 · Whitehouse Sta, NJNTSB ANC75AA082Accident · 6 fatalClosedPiper PA-23 · Savoonga, AKNTSB CHI75AC085Accident · 1 fatalClosedPiper PA-23 · Cleveland, OHNTSB CHI75AC066Accident · 2 fatalClosedPiper PA-23 · Grandview, INNTSB DEN75AD045Accident · 2 fatalClosedPiper PA-23 · Albuquerque, NMNTSB MKC75AK019Accident · 6 fatalClosedPiper PA-23 · Austin, MNNTSB SEA74AS047Accident · 4 fatalClosedPiper PA-23 · Toledo, WANTSB LAX74AL036Accident · 3 fatalClosedPiper PA-23 · Alpine, CANTSB DEN73AD025Accident · 1 fatalClosedPiper PA-23 · Nederland, CONTSB SEA72AS039Accident · 1 fatalClosedPiper PA-23 · Salem, ORNTSB NYC69A0091Accident · 6 fatalClosedPiper PA-23 · Missing AircraftNTSB NYC69A0011Accident · 8 fatalClosedPiper PA-23 · Wyandanch, NYNTSB CHI67A0034Accident · 3 fatalClosedPiper PA-23 · ZNTSB CAN65AF367Accident · 1 fatalClosedPiper PA-23 · Gander Nf, CanadaNTSB MIA65A0076Accident · 1 fatalClosedPiper PA23 · Atlantic Ocean (Atlantic Ocean)