NTSB investigations: Piper PA-18A 150, CA
18 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.
Cases per year
| 1964 | 4 |
|---|---|
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1985 | 2 |
| 1990 | 1 |
| 1997 | 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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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" 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 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.NTSB LAX90LA323Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Montague, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the student pilot's lack of experience performing landings.NTSB LAX86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Likely, CAWhile practicing power-off forced landings in an open, snow covered field, the pilot said he applied the throttle to abort the approach but the engine 'sputtered then quit.' The aircraft landed in the snow covered field and flipped over. The pilot said he…NTSB SEA85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brentwood, CAOn the student plts seventh attempted landing, directional control was lost and a groundloop occurred. The student plt had less than two hours of total pilot in command time.NTSB LAX79FUG32Accident · No injuriesClosedPiper PA-18A · Lake Elsinore, CANTSB OAK75FVG62Accident · 1 fatalClosedPiper PA-18A · Hood, CANTSB OAK74FVG59Accident · Serious injuriesClosedPiper PA-18 · Marysville, CANTSB LAX74DUQ14Accident · No injuriesClosedPiper PA-18A · Mojave, CANTSB LAX72FUG66Accident · Minor injuriesClosedPiper PA-18 · Elsinore, CANTSB OAK70FVG11Accident · Minor injuriesClosedPiper PA-18A · Glenn, CANTSB OAK70DVM08Accident · No injuriesClosedPiper PA-18 · Shandon, CANTSB OAK70D0102Accident · Minor injuriesClosedPiper PA-18A · Livermore, CANTSB LAX69F0178Accident · Serious injuriesClosedPiper PA-18A · Corona, CANTSB LAX68D0394Accident · Minor injuriesClosedPiper PA-18 · Tehachapi, CANTSB UNK64X2992Accident · No injuriesClosedPiper PA18A · La Verne, CANTSB UNK64X1785Accident · No injuriesClosedPiper PA18 · Cantil, CANTSB UNK64X0603Accident · No injuriesClosedPiper PA18 · El Toro, CANTSB UNK64X0346Accident · No injuriesClosedPiper PA18 · Grass Valle, CA