NTSB investigations: Piper PA-18AS-125
13 cases on aircraft the registry lists as Piper PA-18AS-125. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1979 | 1 |
| 1991 | 1 |
| 2005 | 1 |
| 2019 | 1 |
| 2023 | 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 ('7101816'))
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 ('7101816'))
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 ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.NTSB GAA19CA521Accident · No injuriesData collectionFinal reportPiper PA18 · Beluga, AKThe pilot's failure to maintain an adequate climb rate during takeoff in gusting wind conditions, which resulted in an uncontrolled descent.NTSB ANC05CA139Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.NTSB CHI91DTK01Accident · 2 fatalFinal reportPiper PA-18-125 · Newell, SDAn inadvertent stall/spin during maneuvering flight and inadequate remedial action by the pilot. Factors associated with the accident are the pilot's disregard for procedures and directives and inadequate initial training.NTSB OAK79DXQ16Accident · No injuriesClosedPiper PA-18 · Elko, NVNTSB MKC73DCJ13Accident · Minor injuriesClosedPiper PA-18 · Paxton, NENTSB MKC72FCD18Accident · 1 fatalClosedPiper PA-18 · Webster City, IANTSB MKC70D0258Accident · No injuriesClosedPiper PA-18A · Towner, NDNTSB NYC69F0114Accident · 1 fatalClosedPiper PA-18A · Derry, NHNTSB NYC67F0653Accident · No injuriesClosedPiper PA-18A · Nashua, NHNTSB UNK66X0132Accident · No injuriesClosedPiper PA-18 · El Obeid, RussiaNTSB ANC66A0016Accident · 2 fatalClosedPiper PA-18A · Chignik, AKNTSB MKC66D0054Accident · No injuriesClosedPiper PA-18A · Sutherland, NE