NTSB investigations: Piper PA-18-150, MI
12 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
| 1967 | 2 |
|---|---|
| 1972 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1997 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 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\" = 'MI' 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" = 'MI' 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 CEN20CA213Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18 · Cadillac, MIThe pilot’s failure to maintain control of the float-equipped airplane after the float became caught on the trailer used for takeoff.NTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.NTSB CEN16LA029Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Tecumseh, MIThe pilot's failure to maintain directional control during the landing and his subsequent improper decision to attempt an aborted landing after the airplane had departed the runway.NTSB CHI97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rogers City, MIthe disconnection of the tailwheel spring which resulted in the pilot's inability to maintain directional control of the airplane.NTSB CHI89FA129Accident · 2 fatalField investigationFinal reportPiper PA-18 · Roscommon, MILoss of control in flight while maneuvering and the failure to perform remedial action by the PIC.NTSB DEN82FTA11Accident · 2 fatalFinal reportPiper PA-18 · Hardin, MIThe wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at…NTSB CHI78FEC27Accident · No injuriesClosedPiper PA-18 · Bad Axe, MINTSB CHI78FET35Accident · 1 fatalClosedPiper PA-18 · Benton Harbor, MINTSB CHI77DEM20Accident · Minor injuriesClosedPiper PA-18 · Faithorne, MINTSB CHI72FEM76Accident · Minor injuriesClosedPiper PA-18 · Ionia, MINTSB CHI68F0053Accident · No injuriesClosedPiper PA-18 · Grand Beach, MINTSB CHI67D0591Accident · No injuriesClosedPiper PA-18 · Eaton Rapids, MI