NTSB investigations: Piper PA-24, AR
7 cases on aircraft the registry lists as Piper PA-24. 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
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1992 | 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.\"eventStateOrRegion\" = 'AR' 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 ('7102402'))
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" = 'AR' 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 ('7102402'))
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 FTW92LA210Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Russellville, ARThe pilot's improper flare. Factors were the propeller system's pitch change mechanism disconnected due to improper overhaul and failure to install the staking pins by other maintenance personnel.NTSB MKC87FA012Accident · 2 fatalField investigationFinal reportPiper PA-24 · Siloam Springs, ARThe plt had logged 3 hrs of simulated instrument training prior to this accident. He received a wx briefing which reported wx conditions nearby were IFR due to low ceilings and fog. Immediately after takeoff, the acft started a left turn and impacted terrain…NTSB MKC84FA103Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Springdale, ARAbout 3 minutes after takeoff the acft was observed coming out of the 400-600 ft overcast sky in about a 75 deg nose down, right wing attitude. It impacted a 4-strand high voltage powerline prior to impact with the ground. The plt had received his instrument…NTSB FTW81FPG39Accident · No injuriesClosedPiper PA-24 · Stuttgart, ARNTSB FTW75FPG47Accident · Minor injuriesClosedPiper PA-28 · N.Little Rock, ARNTSB FTW69A0084Accident · 1 fatalClosedPiper PA-24 · Boydville, ARNTSB UNK65X0842Accident · 1 fatalClosedPiper PA-24 · El Dorado, AR