Skip to content

NTSB investigations: Piper PA-28R-180, NY

22 cases on aircraft the registry lists as Piper PA-28R-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

19682026

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" = 'NY' 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 ('7102809')) 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\" = 'NY' 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 ('7102809'))
  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" = 'NY' 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 ('7102809'))
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 ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.Jun 14, 2009 · N3226R · Substantial damage NTSB NYC04FA100Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Harrietstown, NYThe pilot's failure to follow instrument flight rules procedures resulting in a collision with a tree. Factors related to the accident were the dark night conditions, low visibility, and low cloud ceiling.Apr 3, 2004 · N4686J · Substantial damage NTSB NYC92FA161Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Bradford, NYA mechanical malfunction of the artificial horizon in IMC that resulted in spatial disorientation of the pilot and his inability to maintain airplane orientation. A factor in the accident was the improper maintenance of the artificial horizon.Aug 13, 1992 · N44AE · Destroyed NTSB NYC87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dansville, NYAbout 5 min after taking off, the eng began running rough, then lost power & would not restart. Subsequently, the acft was damaged drg an emerg lndg in a potato field. The acft was moved before aviation inspectors arrived. No fuel was fnd in the fuel pumps,…Jul 16, 1987 · N7684J · Substantial damage NTSB NYC82DA065Accident · No injuriesFinal reportPiper PA-28R-180 · Perry Warsaw, NYThe pilot elected to takeoff at night with low visibility, rain, and fog. Soon after takeoff visual ground contact was lost due to what the pilot stated as quickly lowering ceilings and visibility. The pilot then decided to make a precautionary landing in a…Mar 26, 1982 · N4909J · Substantial damage NTSB NYC81FA040Accident · 1 fatalClosedPiper PA-28R · Hartford, NYApr 17, 1981 · N7435J · Destroyed NTSB NYC80FA093Accident · Serious injuriesClosedPiper PA-28R · Farmingdale, NYSep 28, 1980 · N3923T · Destroyed NTSB NYC80FHJ03Accident · No injuriesClosedPiper PA-28R · Flushing, NYNov 28, 1979 · N4668J · Substantial damage NTSB NYC77FFJ09Accident · No injuriesClosedPiper PA-28 · Akron, NYDec 27, 1976 · N3916T · Substantial damage NTSB NYC76DFA30Accident · No injuriesClosedPiper PA-28R · White Lake, NYMar 20, 1976 · N4635J · Substantial damage NTSB NYC76DHM11Accident · No injuriesClosedPiper PA-28R · Spring Valley, NYSep 10, 1975 · N3711 · Substantial damage NTSB NYC75DFJ19Accident · No injuriesClosedPiper PA-28 · Syracuse, NYDec 15, 1974 · N4598J · Substantial damage NTSB NYC75FHJ19Accident · No injuriesClosedPiper PA-28R · Islip, NYNov 18, 1974 · N3985T · Substantial damage NTSB NYC75DHJ22Accident · No injuriesClosedPiper PA-28R · Amityville, NYNov 10, 1974 · N3923T · Substantial damage NTSB NYC75DFA18Accident · No injuriesClosedPiper PA-28 · Broadalbin, NYSep 27, 1974 · N4605J · Substantial damage NTSB NYC74FFJ10Accident · No injuriesClosedPiper PA-28R · Hornell, NYSep 9, 1973 · N459WE · Substantial damage NTSB NYC74FHJ09Accident · Minor injuriesClosedPiper PA-28 · Mt Pleasant, NYAug 7, 1973 · N5091S · Substantial damage NTSB NYC72DFJ30Accident · No injuriesClosedPiper PA-28R · Olean, NYMar 8, 1972 · N4605J · Substantial damage NTSB NYC72DHM38Accident · Serious injuriesClosedPiper PA-28R · Yulan, NYMar 4, 1972 · N4930J · No damage NTSB NYC71DFJ19Accident · No injuriesClosedPiper PA-28R · Skaneateles, NYDec 20, 1970 · N3701T · Substantial damage NTSB NYC71DFJ10Accident · No injuriesClosedPiper PA-28R · Geneva, NYAug 26, 1970 · N7610J · Substantial damage NTSB NYC68A0095Accident · 2 fatalClosedPiper PA-28 · Cornwall, NYJan 28, 1968 · N3922T · Destroyed