NTSB investigations: Piper PA-22-150, OK
21 cases on aircraft the registry lists as Piper PA-22-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 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 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\" = 'OK' 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 ('7102210'))
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" = 'OK' 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 ('7102210'))
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 FTW90LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Edmond, OKInadequate supervision by the pilot. Factors related to the accident were: darkness and the passenger's impairment from use of a prescription drug (medication).NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB FTW83LA265Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tulsa, OKThe acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.NTSB FTW82DPJ03Accident · No injuriesClosedPiper PA-22 · Seiling, OKNTSB FTW81FA019Accident · 1 fatalClosedPiper PA-22 · Oklahoma City, OKNTSB FTW79DPJ38Accident · Serious injuriesClosedPiper PA-22 · O'Keene, OKNTSB FTW76FPJ39Accident · Serious injuriesClosedPiper PA-22 · Randlett, OKNTSB FTW76FPJ28Accident · No injuriesClosedPiper PA-22 · Oklahoma City, OKNTSB FTW75AF071Accident · 2 fatalClosedPiper PA-22 · Gore, OKNTSB FTW75FPM12Accident · No injuriesClosedPiper PA-22 · Tulsa, OKNTSB FTW74FPM05Accident · No injuriesClosedPiper PA-22 · Tulsa, OKNTSB FTW71AF066Accident · 2 fatalClosedPiper PA-22 · Meers, OKNTSB FTW71AF029Accident · 1 fatalClosedPiper PA-22 · Baker, OKNTSB FTW68F0331Accident · Minor injuriesClosedPiper PA-22 · Fairview, OKNTSB FTW68D0415Accident · Minor injuriesClosedPiper PA-22 · Honobia, OKNTSB FTW68D0220Accident · No injuriesClosedPiper PA-22 · Marshall, OKNTSB FTW66F0675Accident · No injuriesClosedPiper PA-22 · Stilwell, OKNTSB FTW66D0609Accident · No injuriesClosedPiper PA-22 · Oklahoma City, OKNTSB FTW66F0346Accident · No injuriesClosedPiper PA-22 · Yukon, OKNTSB FTW66D0229Accident · No injuriesClosedPiper PA-22 · Oklahoma Cty, OKNTSB UNK65X1462Accident · Minor injuriesClosedPiper PA22 · Yukon, OK