NTSB investigations: Piper PA-12
22 cases on aircraft the registry lists as Piper PA-12, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 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 ('7101202')
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\" = 353))
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 ('7101202')
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" = 353))
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 LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.NTSB ANC06LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…NTSB ANC04LA120Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.NTSB DEN04LA032Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Edgewood, NMthe pilot's inadequate in-flight planning and decision making. Factors contributing to the accident include the resulting fuel exhaustion, the snow covered field and the fence.NTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB ANC96LA157Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKthe pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.NTSB ANC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Ketchikan, AKThe pilot's inadequate preflight preparation and the water in the airplane's fuel system. A factor in the accident was the rough water in the forced landing area.NTSB ANC93LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKTotal loss of engine power due to fuel exhaustion and the pilot's improper fuel consumption calculations. Factor was the unsuitable terrain.NTSB ANC93LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Goose Bay, AKThe loss of engine power due to fuel starvation. A factor in the accident was the inadequate installation information supplied with the STC for the engine upgrade.NTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ANC91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKFuel contamination and the pilot's failure to perform an adequate preflight of the airplane. Contributing to the accident was the rough, uneven terrain of the tundra landing area.NTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.NTSB ANC87LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kvichak Bay, AKThe pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the…NTSB ANC86LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that the aircraft is not equipped with a header tank on the fuel system. The engine was starved of fuel when in a shallow dive.NTSB ANC85LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe plt reported that when he departed seward. The fuel gages indicated there was aprx 15 gal on board. About 5 min from the intended destination, the eng lost power from fuel exhaustion while the left fuel gage showed there was 5 gal remaining. During an…NTSB ANC85LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Beluga, AKAcft was doing low alt turns-about-a-point when the eng quit due to fuel starvation. The acft then crashed into trees. Plt stated the acft had aprx 5 gals of fuel an board at the time of the accident.NTSB CHI85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Waynesville, OHThe engine quit at about 500 ft AGL during the initial takeoff climb. The pilot made a forced landing in a plowed field and the main gear sheared off. Water was observed dripping out of the gascolator after the accident.NTSB MIA85LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Miramar, FLAn interruption of pwr was experienced as an abrupt steep dive maneuver was entered to release the banner towed by the acft. The plt then attempted a 180 deg turn at an alt of aprx 200 ft AGL to avoid pwr lines. The acft entered a high descent rate and…NTSB ANC83LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKAccording to the pilot the engine started running intemittently after he was over trees at the departure end of the runway. The engine stopped and the pilot set up for and accomplished a forced landing. After the accident the pilot and a mechanic found water…NTSB ANC83FA177Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKWhile approaching merrill field the eng quit. The acft landed on a city road & the gear collapsed. The wx in the vicinity of the accident site had marginal conditions with both rain & fog. The temp/dew point spread was 2 deg f. the plt attributed the eng…NTSB ANC83LA116Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe acft was damaged while making a forced landing after the engine stopped. The pilot said he was at 1200 feet near point mackenzie when the engine started running rough. The engine stopped operating a few seconds later. The pilot said he had trouble…NTSB ANC82DA045Accident · Minor injuriesFinal reportPiper PA-12 · Near Anchorage, AKThe pilot reported that during flight, the engine quit when the right tank went dry. He switched the fuel selector to the left tank, but the engine would not start. Subsequently, the plane was damaged during a forced landing in a creek bottom Near powerlines.…