NTSB investigations: Piper PA-16
11 cases on aircraft the registry lists as Piper PA-16, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101602')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101602')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.NTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.NTSB ANC01LA089Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKAn inadvertent ground loop during the landing roll.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB ANC88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Bethel, AKThe 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted…NTSB ANC88LA001Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Fairbanks, AKThe plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over.NTSB SEA87LA072Accident · No injuriesLimited investigationFinal reportPiper PA 16 · Jean, NVThe plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks.NTSB CHI86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Effingham, ILAcft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of…NTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.NTSB NYC85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Livingston, NYThe acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the…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.