NTSB investigations: Piper PA-12, NC
18 cases on aircraft the registry lists as Piper PA-12. 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 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 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 ('7101202'))
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 ('7101202'))
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 ATL97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Swansboro, NCThe pilot's failure to maintain directional control. A factor was the gusting winds.NTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.NTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.NTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.NTSB ATL84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rockingham, NCN92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost.NTSB IAD77DLJ13Accident · Minor injuriesClosedPiper PA-12 · Elizabeth City, NCNTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCNTSB NYC72FKM32Accident · No injuriesClosedPiper PA-12 · Rockingham, NCNTSB NYC72FLJ14Accident · Minor injuriesClosedPiper PA-12 · Beaufort, NCNTSB DIA69F0177Accident · No injuriesClosedPiper PA-12 · Burlington, NCNTSB DIA69D0153Accident · Serious injuriesClosedPiper PA-12 · Morehead City, NCNTSB DIA69A0011Accident · 1 fatalClosedPiper PA-12 · Monroe, NCNTSB DIA69F0030Accident · Serious injuriesClosedPiper PA-12 · White Lake, NCNTSB DIA68F0230Accident · No injuriesClosedPiper PA-12 · Mooresville, NCNTSB DIA68F0016Accident · No injuriesClosedPiper PA-12 · Winston-Salem, NCNTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCNTSB UNK64X0850Accident · Minor injuriesClosedPiper PA12 · Ocean Isle, NC