Skip to content

NTSB investigations: Piper PA-23-250

858 cases on aircraft the registry lists as Piper PA-23-250. 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 ('7102308')) 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 ('7102308'))
  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 ('7102308'))
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 SEA77FA017Accident · 1 fatalClosedPiper PA-23 · Moro, ORFeb 2, 1977 · N484G · Destroyed NTSB NYC77FGT08Accident · No injuriesClosedPiper PA-23 · Lock Haven, PAJan 28, 1977 · N62719 · Substantial damage NTSB MIA77DKJ13Accident · No injuriesClosedPiper PA-23C · Enterprise, ALJan 26, 1977 · N6293Y · Substantial damage NTSB DEN77FQA13Accident · Minor injuriesClosedPiper PA-23 · Datil, NMJan 24, 1977 · N4867P · Substantial damage NTSB MIA77DA019Accident · 1 fatalClosedPiper PA-23 · Caribbean Sea (Atlantic Ocean)Jan 10, 1977 · N5002Y · Destroyed NTSB OAK77DVG17Accident · No injuriesClosedPiper PA23 · Chico, CAJan 9, 1977 · N5VM · Substantial damage NTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftDec 28, 1976 · N4573P · Destroyed NTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CADec 15, 1976 · N5590Y · Destroyed NTSB OAK77FVG15Accident · No injuriesClosedPiper PA-23 · Jackson, CADec 6, 1976 · N5381Y · Substantial damage NTSB CHI77FEK08Accident · Serious injuriesClosedPiper PA-23 · Mt Sterling, OHDec 6, 1976 · N5046Y · Destroyed NTSB MIA77DLA06Accident · No injuriesClosedPiper PA-24 · Lake City, FLNov 17, 1976 · N593RT · Substantial damage NTSB NYC76IA006Incident · No injuriesClosedPiper PA-23 · Windsor Locks, CTOct 30, 1976 · N5670Y · No damage NTSB LAX77DUJ08Accident · No injuriesClosedPiper PA-23 · San Carlos, AZOct 21, 1976 · N424MC · Substantial damage NTSB DEN76AD074Accident · 6 fatalClosedPiper PA-23 · Steamboat Spgs, COSep 26, 1976 · N777MF · Destroyed NTSB OAK76FVA90Accident · No injuriesClosedPiper PA-23 · San Joaquin, CASep 17, 1976 · N76JT · Substantial damage NTSB MKC76AK081Accident · Serious injuriesClosedPiper PA-23 · Independence, MOSep 15, 1976 · N6510Y · Destroyed NTSB MIA76AM105Accident · 1 fatalClosedPiper PA-23 · Clarksdale, MSAug 23, 1976 · N4889P · Destroyed NTSB DEN76FQA54Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMJul 8, 1976 · N13986 · Substantial damage NTSB IAD76FKM39Accident · Minor injuriesClosedPiper PA-23 · Huntersville, NCJul 1, 1976 · N5112Y · Substantial damage NTSB IAD76AI076Accident · 2 fatalClosedPiper PA-23 · West Liberty, KYJun 12, 1976 · N852PS · Destroyed NTSB DEN76AD053Accident · 1 fatalClosedPiper PA-23 · Cheyenne, WYJun 11, 1976 · N5448Y · Destroyed NTSB SEA76AS055Accident · 1 fatalClosedPiper PA-23 · Hamilton, MTJun 3, 1976 · N6507Y · Destroyed NTSB NYC76AN101Accident · 6 fatalClosedPiper PA-23 · Newville, PAJun 1, 1976 · N13991 · Destroyed NTSB IAD76AI068Accident · 3 fatalClosedPiper PA-23 · Lynchburg, VAMay 1, 1976 · N6835Y · Destroyed NTSB FTW76AF084Accident · 1 fatalClosedPiper PA-23 · Princeton, TXApr 16, 1976 · N5424Y · Destroyed NTSB SEA76AS040Accident · 2 fatalClosedPiper PA-23 · Pullman, WAMar 28, 1976 · N6199Y · Destroyed NTSB FTW76O0004Accident · No injuriesClosedPiper PA-23 · Huascato, MexicoMar 20, 1976 · N4779P · Destroyed NTSB FTW76AF072Accident · 2 fatalClosedPiper PA-23 · Hope, ARMar 15, 1976 · N4855P · Destroyed NTSB IAD76DLQ15Accident · No injuriesClosedPiper PA-23 · Banner Elk, NCMar 12, 1976 · N400BB · Substantial damage NTSB LAX76AL059Accident · 3 fatalClosedPiper PA-23 · Desert Hot Spg, CAMar 1, 1976 · N5931Y · Destroyed NTSB FTW76FPD29Accident · No injuriesClosedPiper PA-23 · Bowie, TXFeb 17, 1976 · N5185Y · Substantial damage NTSB NYC76AN078Accident · Serious injuriesClosedPiper PA-23 · Ludlow, MAFeb 12, 1976 · N7RW · Substantial damage NTSB DEN76AD028Accident · 4 fatalClosedPiper PA-23 · Grants, NMJan 6, 1976 · N5258Y · Destroyed NTSB NYC76IN058Incident · No injuriesClosedPiper PA-23 · Boston, MADec 23, 1975 · N48PB · Minor damage NTSB NYC76IN050Incident · No injuriesClosedPiper PA-23 · White Plains, NYNov 12, 1975 · N5700Y · Minor damage NTSB IAD76II032Incident · No injuriesClosedPiper PA-23 · Beckley, WVNov 12, 1975 · N100BA · Minor damage NTSB LAX76AL031Accident · 2 fatalClosedPiper PA-23 · Julian, CAOct 30, 1975 · N6982Y · Destroyed NTSB DEN76AD021Accident · 4 fatalClosedPiper PA-23 · Penasco, NMOct 19, 1975 · N4770P · Destroyed NTSB MIA76OKT29Accident · No injuriesClosedPiper PA-24 · Nassau, Burkina FasoOct 17, 1975 · N5444Y · Destroyed NTSB MIA76FKG24Accident · No injuriesClosedPiper PA-23 · Ringgold, GAOct 3, 1975 · N54772 · Substantial damage NTSB MKC76AK020Accident · 2 fatalClosedPiper PA-23 · Mulberry, KSSep 18, 1975 · N524PR · Destroyed NTSB NYC76DHI03Accident · No injuriesClosedPiper PA-23 · Shelter Isl, NYAug 3, 1975 · N14007 · Substantial damage NTSB MIA76AM006Accident · 2 fatalClosedPiper PA-23 · Bradenton, FLJul 20, 1975 · N770J · Destroyed NTSB MKC75AER76Accident · No injuriesClosedPiper PA-23 · Hackensack, MNJun 15, 1975 · N6679Y · Substantial damage NTSB NYC75DFA40Accident · No injuriesClosedPiper PA-23 · Plattsburgh, NYJun 3, 1975 · N6514Y · Substantial damage NTSB CHI75FEK27Accident · No injuriesClosedPiper PA-23 · Columbus, OHMay 23, 1975 · N6046Y · Substantial damage NTSB MIA75FKT67Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLMar 21, 1975 · N5241Y · Substantial damage NTSB FTW75FPG36Accident · Serious injuriesClosedPiper PA-23 · Brookland, ARMar 11, 1975 · N6966Y · Destroyed NTSB NYC75FNA33Accident · No injuriesClosedPiper PA-23 · Lincoln, RIMar 2, 1975 · N40245 · Substantial damage NTSB DEN75FTE52Accident · No injuriesClosedPiper PA-23 · Broomfield, COFeb 18, 1975 · N4519P · Substantial damage