Skip to content

Fatal NTSB investigations: Piper PA-16

23 cases on aircraft the registry lists as Piper PA-16. 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101602')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101602'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101602'))
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 ATL02FA074Accident · 1 fatalField investigationFinal reportPiper PA-16 · Lakeland, FLThe failure of the PA-16 pilot to maintain a visual lookout and to yield the right-of-way to a lower aircraft while on final approach resulting in a midair collision. Contributing to the accident was the failure of both pilot's to adhere to an ATC clearance…Apr 5, 2002 · N5293H · 2 aircraft · Substantial damage NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.Sep 18, 2000 · N5943H · Destroyed NTSB MIA99FA125Accident · 2 fatalField investigationFinal reportPiper PA-16 · Hardeeville, SCAn inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.Apr 12, 1999 · N5796H · Destroyed NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.Jul 9, 1993 · N5960H · 2 aircraft · Substantial damage NTSB DEN81FA051Accident · 2 fatalClosedPiper PA-16 · Ten Sleep, WYJul 11, 1981 · N6852K · Destroyed NTSB MIA79DA080Accident · 1 fatalClosedPiper PA-16 · Savannah, GAMay 6, 1979 · N5203H · Destroyed NTSB MIA77FA061Accident · 1 fatalClosedPiper PA-16 · Valdosta, GAJun 13, 1977 · N5827H · Destroyed NTSB NYC77FA061Accident · 1 fatalClosedPiper PA-16 · Collins, NYMay 26, 1977 · N6862K · 2 aircraft · Destroyed NTSB ANC73AA044Accident · 1 fatalClosedPiper PA-16 · Pilot Point, AKApr 24, 1973 · N5205H · Destroyed NTSB MKC71AK003Accident · 2 fatalClosedPiper PA-16 · Floodwood, MNJul 14, 1970 · N5691H · Destroyed NTSB LAX69A0078Accident · 2 fatalClosedPiper PA-16 · Diamond Bar, CAJun 29, 1969 · N5666H · Destroyed NTSB SEA69A0055Accident · 2 fatalClosedPiper PA-16 · La Grande, ORMay 16, 1969 · N6853K · Destroyed NTSB SEA69A0027Accident · 2 fatalClosedPiper PA-16 · Pine City, WANov 10, 1968 · N6804K · Substantial damage NTSB LAX69A0024Accident · 4 fatalClosedErco 415-C · Calipatria, CAOct 27, 1968 · N3280H · 2 aircraft · Destroyed NTSB MKC68A0018Accident · 4 fatalClosedPiper PA-16 · Blocker, OKSep 3, 1967 · N5746H · 2 aircraft · Destroyed NTSB FTW68A0012Accident · 2 fatalClosedPiper PA-16 · Duncan, OKAug 2, 1967 · N5800H · Destroyed NTSB SEA68A0074Accident · 1 fatalClosedPiper PA-16 · Wheeler, ORJun 18, 1967 · N5662H · Destroyed NTSB ANC67A0036Accident · 1 fatalClosedPiper PA-16 · ZOct 8, 1966 · N6801K · Destroyed NTSB CHI67A0018Accident · 1 fatalClosedPiper PA-22 · Strongsville, OHJul 30, 1966 · N5722Z · 2 aircraft · Minor damage NTSB OAK67A0003Accident · 6 fatalClosedCessna 172G · Livermore, CAJul 4, 1966 · N4466L · 2 aircraft · Destroyed NTSB SEA66A0054Accident · 1 fatalClosedPiper PA-16 · Sutherlin, ORMay 6, 1966 · N5744H · Destroyed NTSB CHI66A0002Accident · 1 fatalClosedPiper PA-16 · Lake Delton, WIJul 4, 1965 · N6866K · Destroyed NTSB UNK65X1149Accident · 2 fatalClosedPiper PA16 · La Habra, CADec 26, 1964 · N5859H · Destroyed