NTSB investigations: Piper PA-18A 150
10 cases on aircraft the registry lists as Piper PA-18A 150, where the first occurrence was “In flight collision with terrain/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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 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 ('7101837')
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\" = 230))
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 ('7101837')
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" = 230))
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 SEA04LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Blaine, WAThe instructor pilot's inadequate remedial action during his student's final approach for a simulated engine out water landing.NTSB DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.NTSB LAX00TA212Accident · Minor injuriesFinal reportPiper PA-18-150 · Austin, NVLoss of engine power caused by a fuel soaked float pontoon causing an over rich fuel/air mixture, in a critical phase of flight.NTSB ANC98LA063Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain. A factor associated with the accident was rising terrain.NTSB ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.NTSB ANC95FA169Accident · 1 fatalField investigationFinal reportPiper PA-18A · Anchorage, AKThe pilot's improper in-flight planning/decision and failure to maintain adequate clearance or altitude from the mountainous terrain, while maneuvering near an airstrip.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB ANC89LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Harding Lake, AKThe pilot's failure to adequately compensate for the existing wind conditions. A factor related to the accident was: the gusty/variable wind condition.NTSB ANC86LA149Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Umiat, AKThe airplane departed on September 7, 1986 for a local hunting trip with a client. The airplane did not return and the wreckage was found on September 9, 1986. The airplane was destroyed by post-impact fire. According to the guide, for whom the pilot was…NTSB ANC82DA082Accident · No injuriesFinal reportPiper PA-18 · Anchorage, AKThe pilot departed in an easterly direction from an unimproved strip 700 feet in length. He stated that the aircraft waslifted off the ground at an airspeed of 35 to 40 knots and would not climb. He also stated that a 5 to 7 knot wind down the runway caused a…