Skip to content

NTSB investigations: Piper PA-22-108, FL

24 cases on aircraft the registry lists as Piper PA-22-108. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('7102204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102204'))
  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 ('7102204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.Sep 16, 2004 · N4647Z · Substantial damage NTSB MIA96LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Pensacola, FLloss of engine power during the initial climb due to contamination in the carburetor. Trees in the emergency landing area were a related factor.Sep 16, 1996 · N984WB · Substantial damage NTSB MIA93LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · La Belle, FLThe pilot in commands failure to correct for wind conditions during landing rollout resulting in the aircraft flipping over during wind gust encounter.Apr 28, 1993 · N5712Z · Substantial damage NTSB MIA82DA121Accident · No injuriesFinal reportPiper PA-22-108 · Tampa, FLWhile circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were…May 23, 1982 · N4607Z · Substantial damage NTSB MIA82FLD07Accident · Minor injuriesClosedPiper PA-22 · Zephyrhills, FLNov 16, 1981 · N5738Z · Substantial damage NTSB MIA75DKT19Accident · No injuriesClosedPiper PA-22 · Ft Lauderdale, FLOct 26, 1974 · N5853Z · Substantial damage NTSB MIA73DLD46Accident · No injuriesClosedPiper PA-22 · Ft Pierce, FLDec 16, 1972 · N5072Z · Substantial damage NTSB MIA72FLD30Accident · Serious injuriesClosedPiper PA-22 · New Smrna, FLDec 10, 1971 · N5195Z · Destroyed NTSB MIA69D0055Accident · No injuriesClosedPiper PA-22 · Immokalee, FLJun 30, 1968 · N5953Z · Substantial damage NTSB MIA68D0079Accident · No injuriesClosedPiper PA-22 · Orlando, FLJul 20, 1967 · N5388Z · Substantial damage NTSB MIA67D0510Accident · No injuriesClosedPiper PA-22 · Clewiston, FLApr 30, 1967 · N5399Z · Substantial damage NTSB MIA66D0354Accident · Minor injuriesClosedPiper PA-22 · Clewiston, FLDec 7, 1965 · N5399Z · Substantial damage NTSB MIA66F0294Accident · No injuriesClosedPiper PA-22 · Holmes Beach, FLOct 10, 1965 · N4574Z · Substantial damage NTSB MIA66F0246Accident · Minor injuriesClosedPiper PA-22 · Orlando, FLSep 12, 1965 · N5897Z · Substantial damage NTSB MIA66D0096Accident · Minor injuriesClosedPiper PA-22 · Orlando, FLJun 14, 1965 · N5897Z · Substantial damage NTSB MIA66F0021Accident · No injuriesClosedPiper PA-22 · Plymouth, FLJun 10, 1965 · N5796Z · Substantial damage NTSB MIA65F0104Accident · No injuriesClosedPiper PA-22 · Ft Lauderdale, FLMay 12, 1965 · N5934Z · Substantial damage NTSB UNK65X1381Accident · No injuriesClosedPiper PA22 · Melbourne, FLFeb 1, 1965 · N5738Z · Substantial damage NTSB UNK64X3714Accident · No injuriesClosedPiper PA22 · Kissimmee, FLAug 31, 1964 · N5388Z · Substantial damage NTSB UNK64X3419Accident · No injuriesClosedPiper PA22 · Orlando, FLAug 16, 1964 · N5796Z · Substantial damage NTSB UNK64X3258Accident · No injuriesClosedPiper PA22 · Clewiston, FLAug 7, 1964 · N5399Z · Substantial damage NTSB UNK64X2559Accident · 2 fatalClosedPiper PA22 · Miami Beach, FLJun 29, 1964 · N5198Z · Destroyed NTSB UNK64X1712Accident · 1 fatalClosedPiper PA22 · Sarasota, FLMay 10, 1964 · N4577Z · Destroyed NTSB UNK64X1222Accident · No injuriesClosedPiper PA22 · Orlando, FLApr 8, 1964 · N5388Z · Substantial damage