NTSB investigations: Piper PA-22-135, FL
18 cases on aircraft the registry lists as Piper PA-22-135. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1973 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 1996 | 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\" = 'FL' 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 ('7102206'))
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" = 'FL' 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 ('7102206'))
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 MIA96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · Merritt Island, FLThe pilot's inadequate compensation for crosswind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.NTSB MIA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Fort Lauderdale, FLThe pilot's failure to follow procedures, resulting in the airplane being landed with the landing gear in the up position.NTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.NTSB MIA83LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Okeechobee, FLThe non-rated plt stated that the eng lost power while he was flying over lake Okeechobee. He was unable to restart the eng & subsequently ditched the acft in the lake. After recovery, the eng was inspected, but no preimpact, mechanical failure was evident.NTSB MIA83FA031Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Miramar, FLThe aircraft lost power after a touch and go landing and the pilot elected to land in a meadow. The aircraft collided with a ditch after 300 feet of ground roll and the pilot lost control. The aircraft cartwheeled and was destroyed. The pilot was fatally…NTSB MIA79DLD26Accident · No injuriesClosedPiper PA-22 · Lakeland, FLNTSB MIA73DLD71Accident · No injuriesClosedPiper PA-22 · Seminole, FLNTSB MIA70AM060Accident · 1 fatalClosedPiper PA-22 · Merritt Islnd, FLNTSB MIA69D0450Accident · No injuriesClosedPiper PA-22 · Merritt Is., FLNTSB MIA69D0415Accident · Minor injuriesClosedPiper PA-22 · Kissimmee, FLNTSB MIA69F0114Accident · Serious injuriesClosedPiper PA-22 · Clearwater, FLNTSB MIA68D0372Accident · No injuriesClosedPiper PA-22 · Gretna, FLNTSB MIA68F0299Accident · No injuriesClosedPiper PA-22 · Melbourne, FLNTSB MIA68D0011Accident · No injuriesClosedPiper PA-22 · Orlando, FLNTSB MIA66F0428Accident · Minor injuriesClosedPiper PA-22 · Davie, FLNTSB MIA66F0224Accident · No injuriesClosedPiper PA-22 · Daytona Beach, FLNTSB UNK64X3848Accident · No injuriesClosedPiper PA22 · Tallahassee, FLNTSB UNK64X2550Accident · No injuriesClosedPiper PA-22 · Trenton, FL