Skip to content

NTSB investigations: Piper PA-28-140, CT

45 cases on aircraft the registry lists as Piper PA-28-140. 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

19652026

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 ('7102802')) 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 ('7102802'))
  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 ('7102802'))
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 WPR18LA173Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Hartford, CTA loss of engine power for undetermined reasons because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation, which led to the pilot’s forced landing and subsequent runway overshoot and…Jun 16, 2018 · N1782J · Substantial damage NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Jan 27, 2018 · N9673W · Substantial damage NTSB NYC06CA056Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · East Killingly, CTThe flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.Jan 21, 2006 · N32729 · Substantial damage NTSB NYC97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ellington, CTice ingestion into the engine from the carburetor air box, which resulted in a loss of engine power and a subsequent forced landing, off airport, on unprepared terrain.Dec 22, 1996 · N55228 · Substantial damage NTSB BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.Nov 15, 1992 · N4492T · Substantial damage NTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.Sep 12, 1987 · N670FL · Destroyed NTSB NYC83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Willimatic, CTOn the second approach to the airport, after executing a go-around on the first, the pilot encountered ground fog. In zero visibility, at 3-5 feet above the ground, the pilot elected to execute a "controlled crash" rather than attempt a transition to…Nov 3, 1982 · N7423R · Substantial damage NTSB NYC82FNE03Accident · Serious injuriesFinal reportPiper PA-28-140 · Ellington, CTThe aircraft was allowed to warm up for 5 to 10 minutes at end of the runway before takeoff. The instructor pilot (ip) reported that the before takeoff run-up was made by using the checklist and all engine instruments were in-the-green. He reported that…Feb 5, 1982 · N721FL · Substantial damage NTSB NYC81FNE06Accident · Serious injuriesClosedPiper PA-28 · Chester, CTDec 12, 1980 · N6348R · Substantial damage NTSB NYC79FNE14Accident · Minor injuriesClosedPiper PA-28 · East Haven, CTMay 16, 1979 · N95446 · Substantial damage NTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTDec 26, 1977 · N713FL · Substantial damage NTSB NYC77FNE20Accident · No injuriesClosedPiper PA-28 · Milford, CTMay 22, 1977 · N9937W · Substantial damage NTSB NYC77FNE16Accident · No injuriesClosedPiper PA-28 · Ellington, CTApr 13, 1976 · N6214J · Substantial damage NTSB NYC76FNE17Accident · Serious injuriesClosedPiper PA-28 · Waterford, CTMar 10, 1976 · N8752N · Substantial damage NTSB NYC75FNE02Accident · No injuriesClosedPiper PA-28 · Ansonia, CTJul 2, 1975 · N98267 · Substantial damage NTSB NYC75FNE35Accident · No injuriesClosedPiper PA-28 · Danielson, CTMay 13, 1975 · N95011 · Substantial damage NTSB NYC75AN053Accident · 1 fatalClosedPiper PA-28 · East Hampton, CTOct 25, 1974 · N1698T · Destroyed NTSB NYC74FNE01Accident · No injuriesClosedPiper PA-28 · Ellington, CTJul 6, 1974 · N5820U · Substantial damage NTSB NYC73AN156Accident · 2 fatalClosedPiper PA-28 · Killingworth, CTJun 25, 1973 · N6427W · Destroyed NTSB NYC73FNE34Accident · No injuriesClosedPiper PA-28 · Danbury, CTJun 10, 1973 · N9591W · Destroyed NTSB NYC73FNE27Accident · No injuriesClosedPiper PA-28 · Danielson, CTMar 28, 1973 · N95011 · Substantial damage NTSB NYC73FNE19Accident · Minor injuriesClosedPiper PA-28 · Ellington, CTJan 21, 1973 · N95321 · Destroyed NTSB NYC72FNE29Accident · No injuriesClosedPiper PA-28 · Hartford, CTFeb 29, 1972 · N1806J · Substantial damage NTSB NYC72FNE10Accident · Minor injuriesClosedPiper PA-28 · Plainville, CTSep 4, 1971 · N1769T · Substantial damage NTSB NYC72FNE08Accident · Serious injuriesClosedPiper PA-28 · Danbury, CTAug 29, 1971 · N95409 · Destroyed NTSB NYC71DNE39Accident · No injuriesClosedPiper PA-28 · Plainville, CTJun 11, 1971 · N3981K · Substantial damage NTSB NYC71DFM06Accident · No injuriesClosedPiper PA-28 · Waterford, CTAug 2, 1970 · N8776N · Substantial damage NTSB NYC70DFM09Accident · No injuriesClosedPiper PA-28 · East Hampton, CTApr 12, 1970 · N6713J · Substantial damage NTSB NYC70AN072Accident · 4 fatalClosedPiper PA-28 · E.Hartford, CTJan 17, 1970 · N5731F · 2 aircraft · Destroyed NTSB NYC70F0192Accident · No injuriesClosedPiper PA-28 · Groton, CTOct 14, 1969 · N7214J · Substantial damage NTSB NYC69D0412Accident · No injuriesClosedPiper PA-28 · Danbury, CTApr 21, 1969 · N7243J · Substantial damage NTSB NYC69D0307Accident · No injuriesClosedPiper PA-28 · Groton, CTJan 4, 1969 · N6971W · Substantial damage NTSB NYC69F0252Accident · Serious injuriesClosedPiper PA-28 · Glastonbury, CTOct 30, 1968 · N3728K · Substantial damage NTSB NYC69D0213Accident · No injuriesClosedPiper PA-28 · E Hampton, CTSep 29, 1968 · N7280J · Substantial damage NTSB NYC69F0078Accident · No injuriesClosedPiper PA-28 · Danbury, CTJul 7, 1968 · N4397J · 2 aircraft · Substantial damage NTSB NYC69F0033Accident · Serious injuriesClosedPiper PA-28 · Branford, CTJun 9, 1968 · N4455J · Destroyed NTSB NYC68D0163Accident · No injuriesClosedPiper PA-28 · East Haddam, CTAug 5, 1967 · N6079W · Substantial damage NTSB NYC67F0589Accident · No injuriesClosedCessna 172 · Plainville, CTApr 9, 1967 · N5519R · 2 aircraft · Substantial damage NTSB NYC67F0527Accident · Serious injuriesClosedPiper PA-28 · Cheshire, CTFeb 21, 1967 · N6370R · Destroyed NTSB NYC67D0482Accident · No injuriesClosedPiper PA-28 · Hartford, CTJan 31, 1967 · N6937W · Substantial damage NTSB NYC66F0686Accident · No injuriesClosedPiper PA28 · Hartford, CTJun 7, 1966 · N6937W · Substantial damage NTSB NYC66A0667Accident · Serious injuriesClosedPiper PA-28 · Willimantic, CTMay 2, 1966 · N4600R · Substantial damage NTSB NYC66D0294Accident · No injuriesClosedPiper PA-28 · Hartford, CTOct 10, 1965 · N6937W · Substantial damage NTSB NYC65F0114Accident · No injuriesClosedPiper PA-28 · New Haven, CTApr 3, 1965 · N6405W · Substantial damage NTSB UNK65X1365Accident · No injuriesClosedPiper PA28 · Plainville, CTJan 28, 1965 · N6068W · Substantial damage