NTSB investigations: Piper PA-18-105 SPECIAL
5 cases on aircraft the registry lists as Piper PA-18-105 SPECIAL, 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
| 1982 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 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 ('7101808')
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 ('7101808')
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 ANC90LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Falls Creek, AKPilot-in-command's failure to maintain aircraft control.NTSB MKC89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Marion, NEShortly after takeoff from a farm field, the acft's left wing dropped & the acft descended striking the terrain. Witnesses said that immediately after takeoff, the plt attempted to make a steep climbing, left turn. A post acdnt inspn revealed no preimpact…NTSB DEN88LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Monte Vista, COThe plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over.NTSB ANC87FA095Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Sheep Mountain, AKThe pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby…NTSB DEN82FTK06Accident · 1 fatalFinal reportPiper PA-18 · Watertown, SDThe pilot was spraying a sunflower field next to an alfalfa field that was being irrigated. As he pulled up from his third swath run, he began a procedure turn-around over the alfalfa field. During the turn, the plane rolled to an inverted attitude, then…