NTSB investigations: Piper PA-18-150, LA
18 cases on aircraft the registry lists as Piper PA-18-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
| 1965 | 2 |
|---|---|
| 1966 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1989 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2025 | 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\" = 'LA' 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 ('7101828', '7104221', '7102835'))
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" = 'LA' 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 ('7101828', '7104221', '7102835'))
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 CEN26LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA18 · Reserve, LAThe pilot’s inadvertent application of the wheel brakes after touchdown.NTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…NTSB FTW78FRJ33Accident · Serious injuriesClosedPiper PA-18A · Vick, LANTSB FTW78DRJ17Accident · No injuriesClosedPiper PA-18 · Ferriday, LANTSB FTW76DRJ29Accident · No injuriesClosedPiper PA-18 · Oak Grove, LANTSB FTW7LDRD07Accident · No injuriesClosedPiper PA-18 · Wilson, LANTSB FTW72AF005Accident · 2 fatalClosedPiper PA-18 · Houma, LANTSB FTW71FRD16Accident · Serious injuriesClosedPiper PA-18 · Cocodrie, LANTSB FTW71FRJ08Accident · No injuriesClosedPiper PA-18A · Colfax, LANTSB FTW70D0117Accident · Minor injuriesClosedPiper PA-18 · Cameron, LANTSB FTW68D0485Accident · Minor injuriesClosedPiper PA-18 · Mer Rouge, LANTSB FTW67F0159Accident · No injuriesClosedPiper PA-18 · Vick, LANTSB FTW67F0157Accident · No injuriesClosedPiper PA-18 · Vick, LANTSB FTW67A0018Accident · 2 fatalClosedPiper PA-18 · Cameron, LANTSB FTW66D0311Accident · No injuriesClosedPiper PA-18 · Slidell, LANTSB FTW66A0023Accident · 1 fatalClosedPiper PA-18A · Rayville, LA