NTSB investigations: Piper PA-16, CA
17 cases on aircraft the registry lists as Piper PA-16. 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 | 5 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 2 |
| 1970 | 1 |
| 1984 | 1 |
| 2007 | 1 |
| 2013 | 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\" = 'CA' 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 ('7101602'))
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" = 'CA' 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 ('7101602'))
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 WPR14CA064Accident · No injuriesData collectionFinal reportPiper PA 16 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll.NTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.NTSB LAX84LA323Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Novato, CAPlt lost directional control during landing roll. Acft veered off left side of rwy. Plt attempted to return to rwy and acft contacted VASI light. Gusty crosswind conditions existed. Plt's ttl flt time was 68.9 hrs.NTSB OAK70DVG01Accident · No injuriesClosedPiper PA-16 · Rio Linda, CANTSB OAK70D0206Accident · No injuriesClosedPiper PA-16 · Antioch, CANTSB LAX69A0078Accident · 2 fatalClosedPiper PA-16 · Diamond Bar, CANTSB LAX69A0024Accident · 4 fatalClosedErco 415-C · Calipatria, CANTSB LAX68F0423Accident · No injuriesClosedPiper PA-16 · Long Beach, CANTSB LAX68D0257Accident · No injuriesClosedPiper PA-16 · Imperial, CANTSB OAK67A0003Accident · 6 fatalClosedCessna 172G · Livermore, CANTSB LAX66D0190Accident · No injuriesClosedPiper PA-16 · Compton, CANTSB OAK66D0173Accident · No injuriesClosedPiper PA-16 · Palo Alto, CANTSB UNK65X1149Accident · 2 fatalClosedPiper PA16 · La Habra, CANTSB UNK65X0141Accident · No injuriesClosedPiper PA16 · Compton, CANTSB UNK64X3262Accident · Serious injuriesClosedPiper PA16 · Arvin, CANTSB UNK64X2684Accident · No injuriesClosedPiper PA16 · Apple Valley, CANTSB UNK64X2541Accident · No injuriesClosedPiper PA16 · Boulevard, CA