NTSB investigations: Piper PA-28-140, AL
78 cases on aircraft the registry lists as Piper PA-28-140. 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, newest first
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.\"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 ('7102802'))
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 ('7102802'))
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 MIA71DLA48Accident · No injuriesClosedPiper PA-28 · Florala, ALNTSB MIA71FKJ52Accident · No injuriesClosedPiper PA-28 · Columbia, ALNTSB MIA71FKJ45Accident · No injuriesClosedPiper PA-28 · Grady, ALNTSB MIA71DKJ55Accident · No injuriesClosedPiper PA-28 · Grove Hill, ALNTSB MIA71DKJ41Accident · No injuriesClosedPiper PA-28 · Meridianville, ALNTSB MIA71DKJ40Accident · No injuriesClosedPiper PA-28 · Russellville, ALNTSB MIA71DKJ33Accident · No injuriesClosedPiper PA-28 · Talladega, ALNTSB MIA71AKJ20Accident · Minor injuriesClosedPiper PA-28 · Jasper, ALNTSB MIA71FKJ18Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB MIA71FKD04Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB MIA71DKJ05Accident · No injuriesClosedPiper PA-28 · Dutton, ALNTSB MIA70DKJ20Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB MIA70DKJ06Accident · No injuriesClosedPiper PA-28 · Enterprise, ALNTSB MIA69A0016Accident · 2 fatalClosedPiper PA-28 · Eufaula, ALNTSB MIA69D0034Accident · No injuriesClosedPiper PA-28 · Decatur, ALNTSB MIA68D0544Accident · No injuriesClosedPiper PA-28 · Madison, ALNTSB MIA68F0140Accident · No injuriesClosedPiper PA-28 · New Hope, ALNTSB MIA67D0447Accident · No injuriesClosedPiper PA-28 · Monroeville, ALNTSB MIA67F0389Accident · No injuriesClosedPiper PA-28 · Andalusia, ALNTSB MIA67D0127Accident · No injuriesClosedPiper PA-28 · Enterprise, ALNTSB MIA66F0504Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB MIA66D0494Accident · No injuriesClosedPiper PA-28 · Selma, ALNTSB MIA66D0471Accident · No injuriesClosedPiper PA-28 · Birmingham, ALNTSB MIA66D0195Accident · No injuriesClosedPiper PA-28 · Huntsville, ALNTSB MIA65D0125Accident · No injuriesClosedPiper PA-28 · Huntsville, ALNTSB UNK65X1284Accident · No injuriesClosedPiper PA-28 · Atmore, ALNTSB UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALNTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, AL