NTSB investigations: Piper PA-28R-201

7 cases on aircraft the registry lists as Piper PA-28R-201, where the first occurrence was “In flight encounter with weather”. 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

19822026

NTSB investigations: Piper PA-28R-201 per year, 1982–2026: 7 cases
1982	1
1984	1
1985	1
1986	1
1987	1
1990	1
2002	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN02LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver, UTthe pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.Jun 1, 2002 · N171M · Substantial damage NTSB LAX91FA045Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Show Low, AZThe pilot's improper in-flight planning/decision, which resulted in loss of engine power, due to induction system icing. Factors related to the accident were: the adverse weather condition and lack of a suitable area for a forced landing.Nov 26, 1990 · N31638 · Destroyed NTSB ATL87FA104Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Rhine, GAThe non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.Apr 3, 1987 · N47887 · Destroyed NTSB NYC86LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · West Dover, VTShortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.Jul 5, 1986 · N43792 · Substantial damage NTSB NYC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Red Hook, NYDuring flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.…Mar 31, 1985 · N2263Q · 2 aircraft · Substantial damage NTSB NYC84FA129Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Burlington, CTThe acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the…Apr 14, 1984 · N9487C · Destroyed NTSB ATL82FA278Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Alma, GADuring his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…Sep 10, 1982 · N39685 · Destroyed