NTSB investigations: Piper PA-28R-201, CA

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

19802026

NTSB investigations: Piper PA-28R-201, CA per year, 1980–2026: 10 cases
1980	1
1982	2
1986	1
1988	1
1994	1
1997	1
1998	1
1999	1
2010	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."eventStateOrRegion" = 'CA' 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 ('7102816', '7102833')) 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\" = 'CA' 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 ('7102816', '7102833'))
  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" = 'CA' 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 ('7102816', '7102833'))
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 WPR10FA399Accident · 2 fatalField investigationFinal reportPiper PA28R · Emigrant Gap, CAThe pilots’ failure to maintain sufficient altitude to clear terrain while maneuvering. Contributing to the accident was the flight instructor’s delayed remedial action.Aug 13, 2010 · N3463Q · Substantial damage NTSB LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.Dec 23, 1999 · N87WA · 2 aircraft · Minor damage NTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…May 17, 1998 · N36574 · 2 aircraft · Substantial damage NTSB LAX97LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · San Diego, CAthe pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.Jun 22, 1997 · N6471C · Substantial damage NTSB LAX94LA366Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Bragg, CAthe pilot's failure to adequately anticipate and compensate for the existing crosswind/windshear conditions during the takeoff initial climb.Sep 17, 1994 · N30150 · Destroyed NTSB LAX89LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Palmdale, CAAt approximately 6000 ft MSL two airplanes collided in flight. N49382 was climbing to altitude, N31386 was descending in a shallow left turn. The airplane descending colliding with the climbing airplane from behind and to the right. Both airplanes were able…Oct 2, 1988 · N31386 · 2 aircraft · Substantial damage NTSB LAX87FA071Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Gorman, CAThe aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further…Dec 27, 1986 · N50U · Destroyed NTSB LAX82FUD04Accident · No injuriesFinal reportPiper PA-28R-201 · Hawthorne, CAThe acft crashed on final approach after the engine lost power. The plt stated that on final the engine backfired, lost power and would not respond to throttle movement. The engine had been the subject of previous write-ups & work orders, which included fuel…Aug 14, 1982 · N9342C · Substantial damage NTSB LAX82DA129Accident · No injuriesFinal reportPiper PA-28R-201 · Napa, CAAfter making 8 touch & go landings, the pilot lost directional control during a full-stop landing. The aircraft slid off the runwway into grass & then onto a taxiway.Apr 8, 1982 · N30325 · Substantial damage NTSB LAX80DXQ39Accident · No injuriesClosedPiper PA-28R · Mammoth Lakes, CAAug 11, 1980 · N2299Q · Substantial damage