NTSB investigations: Piper PA-18A 150

7 cases on aircraft the registry lists as Piper PA-18A 150, where the first occurrence was “In flight 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations: Piper PA-18A 150 per year, 1984–2026: 7 cases
1984	1
1989	1
1991	1
1992	1
1993	1
1997	1
2004	1

Where

Open the map

Latest cases

Query with SQL

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" = 220)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 220))
  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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.Jun 8, 2004 · N7094D · Destroyed NTSB LAX97LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-18A · Livingston, CAthe pilot's failure to see and avoid power lines. A factor was the pilot's poor judgment in conducting unwarranted low altitude maneuvering.Feb 15, 1997 · N8487D · Destroyed NTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.Oct 4, 1993 · N81648 · Substantial damage NTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.Aug 13, 1992 · N3889P · Substantial damage NTSB ANC91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gold King, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was the rising terrain and the tailwind condition.Aug 31, 1991 · N2664A · Substantial damage NTSB FTW89DPJ06Accident · No injuriesFinal reportPiper PA-18A · Eva, OKThe pilot's failure to maintain visual lookout. A factor was the pilot's limited visual perception due to the ground vehicle.Jun 14, 1989 · N6873B · Substantial damage NTSB NYC84LA253Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seboomook Lake, METhe acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated…Jul 21, 1984 · N9276D · Substantial damage