NTSB investigations: Piper PA-18A 150
8 cases on aircraft the registry lists as Piper PA-18A 150, where the first occurrence was “On ground/water collision with object”. 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 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 310))
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" = 310))
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 CHI06LA278Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Lawrenceville, ILThe visual separation from the glider attempted by the tow pilot and traffic advisories from the glider not received by the tow pilot. The airport sign/marker was a contributing factor.NTSB ANC05CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Aleknagik, AKThe pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…NTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.NTSB FTW93LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Palacios, TXThe pilot's selection of unsuitable terrain for landing. A factor was the hidden culvert.NTSB SEA90LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's failue to maintain adequate clearance from an object near the runway.NTSB ANC89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKInadequate visual lookout by the pilot due to his diverted attention. The vehicles (tractor & truck) were considered to be related factors.NTSB ANC88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKWitnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The…NTSB SEA85LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot was returning from his third aerial tow. After releasing the tow rope while on the ramp, the plt was making clearing turns to avoid parked acft. The tow plane's parked unoccupied acft. The acft then pivoted into the mid portion of the right wing…