NTSB investigations: Piper PA-24, NC
10 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 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1991 | 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\" = 'NC' 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" = 'NC' 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 ATL92FA020Accident · 1 fatalField investigationFinal reportPiper PA-24 · Engelhard, NCThe spatial disorientation experienced by the pilot, and his inadvertent descent into the terrain. A factor was the dark, night lighting condition at the time of the accident.NTSB ATL83FA117Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hendersonville, NCAfter reporting level at 7,000 ft in rain, the plt reported that altitude could not be maintained due to a power loss. He stated that '...we're down to about fourteen inches and we just broke out and I got the lights.' At 1849, after a discussion with ATC…NTSB IAD77FLJ24Accident · Serious injuriesClosedPiper PA-24 · Parkton, NCNTSB IAD75DLJ21Accident · No injuriesClosedPiper PA-24 · Burlington, NCNTSB IAD71FKM29Accident · No injuriesClosedPiper PA-24 · Salisbury, NCNTSB DIA68F0165Accident · No injuriesClosedPiper PA-24 · Raleigh, NCNTSB DIA68A0042Accident · 2 fatalClosedPiper PA-24 · Robbinsville, NCNTSB MIA66A0106Accident · 2 fatalClosedPiper PA-24 · Burnsville, NCNTSB UNK64X4125Accident · No injuriesClosedPiper PA24 · Robersonville, NCNTSB UNK64X0950Accident · No injuriesClosedPiper PA24 · Mt Holly, NC