NTSB investigations: Piper PA-18A 150, GA

11 cases on aircraft the registry lists as Piper PA-18A 150. 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

19642026

NTSB investigations: Piper PA-18A 150, GA per year, 1964–2026: 11 cases
1964	1
1965	3
1967	1
1968	1
1972	1
1980	1
1997	1
2002	1
2005	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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101837')) 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101837'))
  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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101837'))
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 ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.Jun 8, 2005 · N8680D · Substantial damage NTSB ATL02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Thomaston, GAFailure of the pilot-in-command to maintain directional control on landing, resulting in an inadvertent ground loop.Jun 3, 2002 · N8680D · Substantial damage 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.Sep 17, 1997 · N3985P · Substantial damage NTSB MIA80DKG23Accident · Minor injuriesClosedPiper PA-18 · Sylvester, GAApr 10, 1980 · N9063D · Destroyed NTSB MIA73DKG08Accident · Minor injuriesClosedPiper PA-18A · Cordele, GAJul 22, 1972 · N9473D · Substantial damage NTSB MIA68F0488Accident · Serious injuriesClosedPiper PA-18A · Savannah, GAMar 28, 1968 · N8695D · Destroyed NTSB MIA68F0139Accident · Serious injuriesClosedPiper PA-18 · Taylorsville, GAJul 18, 1967 · N3769P · Destroyed NTSB MIA66F0155Accident · No injuriesClosedPiper PA-18 · Tifton, GAJul 19, 1965 · N9469D · Substantial damage NTSB MIA66A0009Accident · 1 fatalClosedPiper PA-18A · Jacksonville, GAJul 14, 1965 · N9922D · Destroyed NTSB MIA65A0101Accident · 1 fatalClosedPiper PA18A · Lagrange, GAApr 14, 1965 · N9392D · Destroyed NTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GASep 4, 1964 · N7294D · Substantial damage