Skip to content

NTSB investigations: Piper PA-28-180, CT

27 cases on aircraft the registry lists as Piper PA-28-180. 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" = 'CT' 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 ('7102808')) 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\" = 'CT' 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 ('7102808'))
  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" = 'CT' 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 ('7102808'))
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 ERA23LA341Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Preston, CTA failure of the No. 2 connecting rod, which resulted in a total loss of engine power.Aug 19, 2023 · N7463W · Substantial damage NTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.Nov 19, 2012 · N8826J · Substantial damage NTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.Sep 18, 2007 · N9285J · Substantial damage NTSB NYC01LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · New Milford, CTSeparation of the number two connecting rod for reasons undetermined.Jul 31, 2001 · N55205 · Substantial damage NTSB NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.Dec 20, 1992 · N5135L · Substantial damage NTSB BFO92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Windham, CTThe pilot's improper IFR operation. Contributing was the pilot's instrument flight inexperience.Sep 5, 1992 · N3751R · Destroyed NTSB NYC88LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Griswold, CTThe takeoff was made with the temp at about 90 deg f. the acft was about 60 lbs over the authorized max gross wt. Witnesses said the nose of the acft was high as it passed over trees just beyond the end of the rwy. The acft then descended with the wings…Sep 10, 1988 · N1840T · Destroyed NTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.Apr 10, 1985 · N55408 · Destroyed NTSB NYC80FA016Accident · 2 fatalClosedPiper PA-28 · Broad Brook, CTDec 28, 1979 · N16436 · Destroyed NTSB NYC78FA046Accident · 1 fatalClosedPiper PA-28 · Danbury, CTApr 29, 1978 · N7126W · Destroyed NTSB NYC78FNE06Accident · No injuriesClosedPiper PA-28 · Stratford, CTJan 29, 1978 · N7906W · Substantial damage NTSB NYC74AN039Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 31, 1973 · N2133T · 2 aircraft · Minor damage NTSB NYC73AN129Accident · 3 fatalClosedPiper PA-28 · Bantam, CTApr 3, 1973 · N2660T · Destroyed NTSB NYC73FNE16Accident · No injuriesClosedPiper PA-28 · Ellington, CTJan 9, 1973 · N6497J · Substantial damage NTSB NYC72FNE25Accident · No injuriesClosedPiper PA-28 · Stratford, CTFeb 21, 1972 · N5315L · Substantial damage NTSB NYC71AN041Accident · 2 fatalClosedPiper PA-28 · No.Windham, CTSep 26, 1970 · N9012J · Destroyed NTSB NYC70F0209Accident · Serious injuriesClosedPiper PA-28 · Waterford, CTOct 26, 1969 · N7175W · Destroyed NTSB NYC70F0176Accident · Minor injuriesClosedPiper PA-28 · Waterford, CTSep 28, 1969 · N9245J · Substantial damage NTSB NYC69A0014Accident · No injuriesClosedPiper PA-28 · East Hampton, CTAug 1, 1968 · N9311J · Substantial damage NTSB NYC68D0432Accident · No injuriesClosedPiper PA-28 · Waterford, CTApr 8, 1968 · N9245J · Substantial damage NTSB NYC68A0079Accident · 4 fatalClosedPiper PA-28 · Bridgeport, CTDec 16, 1967 · N9736J · Destroyed NTSB NYC68A0017Accident · 2 fatalClosedPiper PA-28 · Bridgeport, CTJul 27, 1967 · N7865W · Destroyed NTSB NYC67D0663Accident · No injuriesClosedPiper PA-28 · Plainville, CTMay 13, 1967 · N9068J · Substantial damage NTSB NYC67D0313Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 6, 1966 · N7649W · Substantial damage NTSB NYC66D0399Accident · No injuriesClosedPiper PA-28 · Hartford, CTDec 23, 1965 · N7649W · Substantial damage NTSB UNK65X0887Accident · No injuriesClosedPiper PA28 · Waterbury, CTNov 29, 1964 · N7906W · Substantial damage NTSB UNK65X0692Accident · Serious injuriesClosedPiper PA-28 · Burlington, CTNov 13, 1964 · N7665W · Destroyed