NTSB investigations: Piper PA-18-125
10 cases on aircraft the registry lists as Piper PA-18-125, where the first occurrence was “Loss of control - in flight”. 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 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1999 | 1 |
| 2000 | 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 ('7101812')
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\" = 250))
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 ('7101812')
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" = 250))
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 ANC08CA009Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Pilot Point, AKThe pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in a loss of control, and an in-flight collision with terrain. Factors associated with the accident were gusty, high winds.NTSB ANC00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.NTSB DEN00FA021Accident · 2 fatalField investigationFinal reportPiper PA-18-125 · Afton, WYFailure of the pilot to remove frost from the wings prior to takeoff, causing an inadvertent stall/spin on initial climbout. Factors included exceeding the aircraft's certificated gross weight, and fog conditions.NTSB CHI92DCJ01Accident · 2 fatalFinal reportPiper PA-18-125 · Ashby, NEThe pilot's failure to maintain aircraft control while maneuvering.NTSB ANC92LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain airspeed.NTSB ANC91LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eagle River, AKThe pilot's failure to maintain airspeed during climbout and lack of aircraft control. Contributing to the accident was both the downdraft and gusting wind.NTSB DEN88FA062Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Brighton, COThe student pilot was observed by witnesses to 'buzz' the city of Brighton, Colorado. Witnesses stated that N1153A flew over houses and buildings at a very low altitude. The acft was then observed to climb to a high altitude, do a 'wing over' or 'hammerhead'…NTSB DEN88FA001Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Miles City, MTA cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew…NTSB SEA85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bellevue, WAThe plt reported that during the pre-flt check, she neglected to untie the rear seat belt from the aft control stick. Standard procedure for taxi & takeoff in this float plane was to keep the stick full aft. Since the acft was low on fuel & was taking off in…NTSB ANC84LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe plt stated that at the time of the accident, he encountered a white out condition. The acft stalled and crashed on ahillside.