Skip to content

NTSB investigations: Piper PA-28R-201

136 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, newest first

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')) 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'))
  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'))
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 ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…Nov 15, 1984 · N30001 · Substantial damage NTSB DEN84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Los Alamos, NMThe attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was…Jul 9, 1984 · N2292M · 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 CHI83LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Mora, MNThe acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…May 11, 1983 · N36804 · Substantial damage NTSB ANC83IA072Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201 · Mcgrath, AKAfter 3 attempts to takeoff from a muddy airstrip and failing, the pilot off-loaded one passenger and some baggage. On the fourth takeoff attempt the aircraft got airborne but settled back to a snow covered frozen river. The snow slowed the aircraft and the…Apr 19, 1983 · N38565 · Minor damage 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 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 DEN82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Medicine Bow, WYDuring takeoff from a muddy field with a density altitude of 7253 feet the aircraft failed to clear a boundary fence. The passengers stated the stall warning sounded steadily from takeoff until impact with the ground. After the collision with the fence the…May 8, 1982 · N6994C · 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 LAX82FXQ05Accident · Minor injuriesFinal reportPiper PA-28R-201 · Elko, NVThe pilot stated that the engine quit producing power and the plane crashed in mountainous terrain. A teardown of the engine revealed no preimpact failure. The initial impact occurred with a tree at an elevation of about 7000 ft MSL. A piece of the right wing…Mar 14, 1982 · N2105M · Destroyed NTSB NYC81FHJ08Accident · No injuriesClosedPiper PA-28R · Shelter Island, NYMay 21, 1981 · N6320C · Substantial damage NTSB MKC81FA030Accident · No injuriesClosedPiper PA-28R · Hopkins, MOApr 13, 1981 · N40010 · Substantial damage NTSB DEN81FA026Accident · 2 fatalClosedPiper PA-28 · Rock Springs, WYMar 29, 1981 · N44900 · Destroyed NTSB CHI81FEM09Accident · Serious injuriesClosedPiper PA-28R · Houghton, MIFeb 2, 1981 · N4542Q · Destroyed NTSB SEA81DYM03Accident · No injuriesClosedPiper PA-28R · Nehalem, OROct 4, 1980 · N5145W · Substantial damage NTSB ATL80DKJ31Accident · No injuriesClosedPiper PA-28R · Redstone Arsnl, ALSep 8, 1980 · N1996H · Substantial damage NTSB LAX80DXQ39Accident · No injuriesClosedPiper PA-28R · Mammoth Lakes, CAAug 11, 1980 · N2299Q · Substantial damage NTSB ATL80DKJ18Accident · No injuriesClosedPiper PA-28R · Dothan, ALJul 7, 1980 · N36586 · Substantial damage NTSB ATL80FIA10Accident · No injuriesClosedPiper PA-28R · Elkton, VAJun 15, 1980 · N36739 · Substantial damage NTSB MIA80DLD14Accident · No injuriesClosedPiper PA-28 · New Pt Richey, FLNov 22, 1979 · N3623M · Substantial damage NTSB NYC79FGM38Accident · Serious injuriesClosedPiper PA-28 · Greensburg, PAJul 30, 1979 · N69EJ · Destroyed NTSB CHI79FEP47Accident · No injuriesClosedPiper PA-32R · Burlington, WIJun 6, 1979 · N1134Q · 2 aircraft · Substantial damage NTSB NYC79FA028Accident · 4 fatalClosedPiper PA-28R · Palmerton, PAMar 4, 1979 · N5964V · Destroyed NTSB OAK79FA018Accident · 2 fatalClosedPiper PA-28R · Fernley, NVFeb 18, 1979 · N222WF · Destroyed NTSB MIA79FLD04Accident · No injuriesClosedPiper PA-28 · Ft Pierce, FLOct 13, 1978 · N43792 · Substantial damage NTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJOct 11, 1978 · N1690H · Destroyed NTSB DEN78FQA46Accident · Serious injuriesClosedPiper PA-32 · Canjilon, NMAug 15, 1978 · N6347C · Destroyed NTSB DEN78FQA50Accident · No injuriesClosedPiper PA-28R · Santa Rosa, NMAug 14, 1978 · N2574M · Substantial damage NTSB MKC79DER86Accident · No injuriesClosedCessna 421B · Crystal, MNAug 10, 1978 · N110SW · 2 aircraft · Minor damage NTSB MIA78FA092Accident · 2 fatalClosedPiper PA-28R · Hernando Beach, FLJun 1, 1978 · N2291M · Destroyed NTSB MIA78DA089Accident · 4 fatalClosedPiper PA-28 · Missing AircraftMay 19, 1978 · N47910 · Destroyed NTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IADec 16, 1977 · N44988 · Destroyed NTSB MKC78FCJ04Accident · No injuriesClosedPiper PA-28R · Omaha, NENov 18, 1977 · N2241Q · Substantial damage NTSB OAK78FA003Accident · 2 fatalClosedPiper PA-28R · Las Vegas, NVNov 4, 1977 · N5690V · Destroyed NTSB FTW77FA071Accident · 1 fatalClosedPiper PA-28R · Healdton, OKAug 19, 1977 · N38140 · Destroyed NTSB FTW77DPG56Accident · No injuriesClosedPiper PA-28R · Mt.Olive, ARJul 2, 1977 · N38140 · Substantial damage